Browsing Oracle server resources take a few minutes if there is no net service name entry with ORACLE_SID in tnsnames.ora
Article ID: 100011866
Updated On:
Description
Error Message
ORA-12154 errors are logged several times in the debug log.
[1556] [fsys\oracle] - OCIServerAttach() Win 1
[1556] [fsys\oracle] - OCI_ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
[1556] [fsys\oracle] - OCIServerAttach() Win 2
Resolution
Add net service name entry whose name is exactly the same as ORACLE_SID to tnsnames.ora
Issue/Introduction
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.
Was this article helpful?
Yes
No
Powered by
