Oracle Database docker linux VM - Laptop connection
1
I have an Oracle database running in a Linux VM. The way i started the docker is using the following command
sudo docker run -d --name my_db --net oac_net -p 1521:1521 -P --shm-size=4G bi.docker.oraclecorp.com/database/enterprise:12.1.0.2
This is running inside a Linux VM.
[oracle@07f1d37f71c9 /]$ hostname -i
172.18.0.2
I would like to connect to this database docker from my laptop. The TNS entry in my laptop is like the following
odidocker = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.0.2)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL.localdomain) ) )
PDBORCL=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.0.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl.localdomain)
))
Trying to connect using the following command
sqlplus system/welcome1@odidocker
the error we are getting is the following
ORA-12154: TNS:could not resolve the connect identifier specified
What is the mistake i am making. Could someone please help.
Thanks
Bala
oracle docker
asked Jan 20 at 3:47
Balaji KrishnanBalaji Krishnan
147116
add a comment |
1
I have an Oracle database running in a Linux VM. The way i started the docker is using the following command
sudo docker run -d --name my_db --net oac_net -p 1521:1521 -P --shm-size=4G bi.docker.oraclecorp.com/database/enterprise:12.1.0.2
This is running inside a Linux VM.
[oracle@07f1d37f71c9 /]$ hostname -i
172.18.0.2
I would like to connect to this database docker from my laptop. The TNS entry in my laptop is like the following
odidocker = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.0.2)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL.localdomain) ) )
PDBORCL=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.0.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl.localdomain)
))
Trying to connect using the following command
sqlplus system/welcome1@odidocker
the error we are getting is the following
ORA-12154: TNS:could not resolve the connect identifier specified
What is the mistake i am making. Could someone please help.
Thanks
Bala
oracle docker
asked Jan 20 at 3:47
Balaji KrishnanBalaji Krishnan
147116
1
With--net oac_netyou have made the container to connect to the specified network. You have to be connected to the same network to reach it.
– Henry
Jan 20 at 8:29
Thanks @henry I have other dockers which gets connected to that network besides the DB docker. Wondering how to get my laptop connected to that network. Guess that is not going to be possible
– Balaji Krishnan
Jan 20 at 16:57
One way would be todocker execinto the container.
– Henry
Jan 21 at 4:51
@Henry can you please help me understanddocker execShould i do this in my laptop ?
– Balaji Krishnan
Jan 22 at 5:06
add a comment |
1
1
1
1
I have an Oracle database running in a Linux VM. The way i started the docker is using the following command
sudo docker run -d --name my_db --net oac_net -p 1521:1521 -P --shm-size=4G bi.docker.oraclecorp.com/database/enterprise:12.1.0.2
This is running inside a Linux VM.
[oracle@07f1d37f71c9 /]$ hostname -i
172.18.0.2
I would like to connect to this database docker from my laptop. The TNS entry in my laptop is like the following
odidocker = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.0.2)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL.localdomain) ) )
PDBORCL=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.0.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl.localdomain)
))
Trying to connect using the following command
sqlplus system/welcome1@odidocker
the error we are getting is the following
ORA-12154: TNS:could not resolve the connect identifier specified
What is the mistake i am making. Could someone please help.
Thanks
Bala
oracle docker
asked Jan 20 at 3:47
Balaji KrishnanBalaji Krishnan
147116
I have an Oracle database running in a Linux VM. The way i started the docker is using the following command
sudo docker run -d --name my_db --net oac_net -p 1521:1521 -P --shm-size=4G bi.docker.oraclecorp.com/database/enterprise:12.1.0.2
This is running inside a Linux VM.
[oracle@07f1d37f71c9 /]$ hostname -i
172.18.0.2
I would like to connect to this database docker from my laptop. The TNS entry in my laptop is like the following
odidocker = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.0.2)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL.localdomain) ) )
PDBORCL=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.0.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdborcl.localdomain)
))
Trying to connect using the following command
sqlplus system/welcome1@odidocker
the error we are getting is the following
ORA-12154: TNS:could not resolve the connect identifier specified
What is the mistake i am making. Could someone please help.
Thanks
Bala
oracle docker
oracle docker
asked Jan 20 at 3:47
Balaji KrishnanBalaji Krishnan
147116
asked Jan 20 at 3:47
Balaji KrishnanBalaji Krishnan
147116
asked Jan 20 at 3:47
Balaji KrishnanBalaji Krishnan
147116
asked Jan 20 at 3:47
Balaji KrishnanBalaji Krishnan
147116
asked Jan 20 at 3:47
Balaji KrishnanBalaji Krishnan
147116
147116
1
With--net oac_netyou have made the container to connect to the specified network. You have to be connected to the same network to reach it.
– Henry
Jan 20 at 8:29
Thanks @henry I have other dockers which gets connected to that network besides the DB docker. Wondering how to get my laptop connected to that network. Guess that is not going to be possible
– Balaji Krishnan
Jan 20 at 16:57
One way would be todocker execinto the container.
– Henry
Jan 21 at 4:51
@Henry can you please help me understanddocker execShould i do this in my laptop ?
– Balaji Krishnan
Jan 22 at 5:06
add a comment |
1
With--net oac_netyou have made the container to connect to the specified network. You have to be connected to the same network to reach it.
– Henry
Jan 20 at 8:29
Thanks @henry I have other dockers which gets connected to that network besides the DB docker. Wondering how to get my laptop connected to that network. Guess that is not going to be possible
– Balaji Krishnan
Jan 20 at 16:57
One way would be todocker execinto the container.
– Henry
Jan 21 at 4:51
@Henry can you please help me understanddocker execShould i do this in my laptop ?
– Balaji Krishnan
Jan 22 at 5:06
1
1
With
--net oac_net you have made the container to connect to the specified network. You have to be connected to the same network to reach it.– Henry
Jan 20 at 8:29
With
--net oac_net you have made the container to connect to the specified network. You have to be connected to the same network to reach it.– Henry
Jan 20 at 8:29
Thanks @henry I have other dockers which gets connected to that network besides the DB docker. Wondering how to get my laptop connected to that network. Guess that is not going to be possible
– Balaji Krishnan
Jan 20 at 16:57
Thanks @henry I have other dockers which gets connected to that network besides the DB docker. Wondering how to get my laptop connected to that network. Guess that is not going to be possible
– Balaji Krishnan
Jan 20 at 16:57
One way would be to
docker exec into the container.– Henry
Jan 21 at 4:51
One way would be to
docker exec into the container.– Henry
Jan 21 at 4:51
@Henry can you please help me understand
docker exec Should i do this in my laptop ?– Balaji Krishnan
Jan 22 at 5:06
@Henry can you please help me understand
docker exec Should i do this in my laptop ?– Balaji Krishnan
Jan 22 at 5:06
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54273410%2foracle-database-docker-linux-vm-laptop-connection%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54273410%2foracle-database-docker-linux-vm-laptop-connection%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
With
--net oac_netyou have made the container to connect to the specified network. You have to be connected to the same network to reach it.– Henry
Jan 20 at 8:29
Thanks @henry I have other dockers which gets connected to that network besides the DB docker. Wondering how to get my laptop connected to that network. Guess that is not going to be possible
– Balaji Krishnan
Jan 20 at 16:57
One way would be to
docker execinto the container.– Henry
Jan 21 at 4:51
@Henry can you please help me understand
docker execShould i do this in my laptop ?– Balaji Krishnan
Jan 22 at 5:06