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

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


Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)