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

Article:TECH214950  |  Created: 2014-02-12  |  Updated: 2014-02-12  |  Article URL http://www.symantec.com/docs/TECH214950
Article Type
Technical Solution


Issue



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



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




Article URL http://www.symantec.com/docs/TECH214950


Terms of use for this information are found in Legal Notices