Please enter search query.
Search <product_name> all support & community content...
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