Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Network adapter could not establish the connection even if the tns listener has started

user12251389Dec 19 2016 — edited Dec 19 2016

I have installed Oracle 12c. And after installation i have started the listenerand OracleSercieORCL from services. I opened the Oracle Sql developer and created a new connection for SYSDBA and it works fine. I have set the the container to PDBORCL. Now i have created new user using SYSDBA account and i have given the role DBA for this user. Now when i tried to create new connection in sql developer for this user i am getting error as network adaptor could not establish connection :

pastedImage_0.png

Listener.ORA file has below information:

SID_LIST_LISTENER =

(SID_LIST =

(SID\_DESC =

  (SID\_NAME = pdborcl

  (ORACLE\_HOME = F:\\app\\oracle\\product\\12.1.0\\dbhome\_1)

  (PROGRAM = extproc)

  (ENVS = "EXTPROC\_DLLS=ONLY:F:\\app\\oracle\\product\\12.1.0\\dbhome\_1\\bin\\oraclr12.dll")

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

)

This post has been answered by user12251389 on Dec 19 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 16 2017
Added on Dec 19 2016
23 comments
3,825 views