Network adapter could not establish the connection
318 views
Skip to first unread message
Rick Johnson
Jan 15, 2016, 6:00:08 PM1/15/16
to Beginning Oracle Database 12c Administration
Hi. I've imported the Oracle DB Developer appliance into VirtualBox as described in the first section of the book and followed the instructions to create a connection with Oracle SQL Developer and its not working. I'm getting and error: "Status: Failure - Test failed: IO error. The network adapter could not establish the connection." What is wrong here? I can ping the adapter and "tnsping localhost" is ok as well but SQL Developer will not connect...
Brandon Frantz
Jan 15, 2016, 6:41:55 PM1/15/16
to Beginning Oracle Database 12c Administration
i am having the same issue...:(
Iggy Fernandez
Jan 15, 2016, 8:10:15 PM1/15/16
to Beginning Oracle Database 12c Administration
I assume that you followed the instructions on page 5 and 6 and are trying to reach the screen seen in Figure 1-4 on page 7. Please would you post a snapshot of the connection parameters (it should look like Figure 1-3) and a snapshot of what happens after you click Connect.
Rick Johnson
Jan 15, 2016, 9:48:48 PM1/15/16
to Beginning Oracle Database 12c Administration
I'm not able to start up the VM at the moment to take a screenshot but I can tell you I made the connection parameters EXACTLY as they are on fig. 1-3 with password oracle. The result when I hit connect is that in place of where it says Status: Success in fig, 1-3, I get the error "Status: Failure - Test failed: IO error. The network adapter could not establish the connection."
Iggy Fernandez
Jan 15, 2016, 10:15:38 PM1/15/16
to Beginning Oracle Database 12c Administration
I'd still like to see the screenshots.
Would you explain what you mean by "ping the adapter".
Also, go back to the terminal window and try the following commands. Please copy and paste the entire output. Note that the last character in "pdb1" is the numeral "1" not the letter "l".
lsnrctl status
tnsping pdb1
Also try the sqlplus command that you see on page 135. Please copy and paste the entire output.
Rick Johnson
Jan 15, 2016, 11:49:29 PM1/15/16
to Beginning Oracle Database 12c Administration
Ok so here's some screenshots. It appears that pdb1 does not exist... Not sure if it matters but tnsping cdb1 returns OK so I tried it in SQL Developer and got "invalid username/password" and same when I changed username to oracle.
Iggy Fernandez
Jan 16, 2016, 10:07:48 AM1/16/16
to Beginning Oracle Database 12c Administration
It appears that Oracle has changed the names of the databases in the 12.1.0.2 version of the virtual machine. In the 12.1.0.1 version of the virtual machine which was used to write the book, the container database was called orcl and the pluggable database was called pdb1. It appears that the names have been changed in the 12.1.0.2 version of the virtual machine. The container database is now called cdb1 and the pluggable database is called orcl. For the purposes of the book, you need to connect to the pluggable database. Therefore all references to "pdb1" in the book would have to be replaced by "orcl". Therefore the service name in the instructions on page 5 should be "orcl", not "pdb1". Let me know if that works.
Kindest regards,
Iggy
Rick Johnson
Jan 16, 2016, 11:06:41 AM1/16/16
to Beginning Oracle Database 12c Administration
That worked. Thank you very much.
Rick
Rick
Iggy Fernandez
Jan 16, 2016, 11:09:07 AM1/16/16
to Beginning Oracle Database 12c Administration
You're very welcome. You're doing a great service to future readers of the book.
Kindest regards,
Iggy
Brandon Frantz
Jan 25, 2016, 4:12:29 PM1/25/16
to Beginning Oracle Database 12c Administration
this worked...thank you!
Jesse Green
May 10, 2016, 4:35:04 PM5/10/16
to Beginning Oracle Database 12c Administration
Yeah I was having problems too with getting connected until I came here and saw this post about Oracle changing the database name. I'm now able to connect too. Thank you.
Reply all
Reply to author
Forward
0 new messages