Start a new topic

ORA-12514

anonymous

started a topic over 8 years ago

[This topic is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

Oracle 12 - Win 2012 R2
Receiving ORA-12514 error
Application works fine; just cannot connect to DBVisualizer


On one instance, no problem connecting via DBV v9.
The other, ORA-12514.

Service_Name on both = PSPRODDB
TNSNAMES.ORA & LISTENER.ORA appear to be the same
Only IPs are different.

********************************************************************************
 tnsnames.ora Network Configuration File: D:\oracle\product\12.1.0.2\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

PSPRODDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 205.xxx.xx.xx)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PSPRODDB)
    )
  )

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

LISTENER_PSPRODDB =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 205.xxx.xx.xx)(PORT = 1521))
********************************************************************************
********************************************************************************
# listener.ora Network Configuration File: D:\oracle\product\12.1.0.2\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\oracle\product\12.1.0.2\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\12.1.0.2\dbhome_1\bin\oraclr12.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 205.xxx.xx.xx)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
**********************************************************************

1 Comment

Hans Bergsten

said over 8 years ago

[This reply is migrated from our old forums.]

Re: ORA-12514

Hi Kinny,

The way you have set up the connection in DbVisualizer, the tnsnames.ora file is not used at all. Instead, the driver uses the Database Server, Port and Service values you have entered directly.

Before digging deeper, please try changing the Connection Type from Service to SID. After all these years I'm still not clear on the difference other than that URL format differs and only one or the other works in some configurations.

Best Regards,
Hans

How can we help you today?

ORA-12514

anonymous

Hans Bergsten