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

user12251389 Dec 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 :

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

推荐文章

成熟的枇杷 · CG教程-网盘免费下载

2 月前

成熟的红薯 · 使用java mail 发送邮件报错处理com.sun.mail.smtp.SMTPSendFailedException: 501 Mail from address must be same as

3 月前

没读研的牛排 · telegram在vs2022中编译失败 · Issue #26646 · telegramdesktop/tdesktop · GitHub

4 月前

重感情的墨镜 · 《上海市房屋使用安全管理办法》_其他政策文件_房管局

11 月前

爱喝酒的香瓜 · 荣耀magic2指纹设置消失荣耀30s指纹失灵？-酷米网

1 年前