Return
-
Title
Compare : Oracle Error 12154: ORA-12154: TNS:could not resolve the connect -
Description
Event_log:
Error 2011-06-28 11:50:21.659605 24531 1 Compare server failed:
aborted due to SIGSEGV Error 2011-06-28 11:50:21.657087 24531 1 Compare server killed due to
SIGSEGV, core file = {$SP_SYS_VARDIR}/dump/core.20180, pid = 20180 [sp_desvr]
Error 2011-06-28 11:50:20.316802 20180 1 Compare server: Oracle Error
12154: ORA-12154: TNS:could not resolve the connect identifier specified. [sp_desvr] [module deq]
Info 2011-06-28 11:50:13.974957 20180 1 Compare server completed
Notice 2011-06-28 11:50:13.924674 20180 1 Compare server: Opened
Compare session log file{$SP_SYS_VARDIR}/log/{source sid}_desvr-20180-01 [sp_desvr] [module deq]
-
Cause
Software issue with the $ORACLE_HOME variable inside the program
-
Resolution
Resolution:Requested oneoff ST978150 so that compare does not use the ASM $ORACLE_HOMEWorkaround:Copy tnsnames.ora to ASM Oracle HomeStatus:Waiting for fix in a future release of SharePlex -
Defect ID
978150