Browsing Oracle server resources take a few minutes if there is no net service name entry with ORACLE_SID in tnsnames.ora

Article: 100011866
Last Published: 2018-03-07
Ratings: 0 0
Product(s): Backup Exec

Problem

When trying to browse the Oracle server resources it may take a few minutes if there is no net service name entry whose name is ORACLE_SID in tnsnames.ora.

Error Message

ORA-12154 errors are logged several times in the debug log.

[1556] 2014-02-07T17:21:13.401 [fsys\oracle]        - OCIServerAttach() Win 1
[1556] 2014-02-07T17:21:23.837 [fsys\oracle]        - OCI_ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
[1556] 2014-02-07T17:21:23.837 [fsys\oracle]        - OCIServerAttach() Win 2

Solution

Add net service name entry whose name is exactly same as ORACLE_SID to tnsnames.ora


Was this content helpful?