Problem Symptoms: After an Oracle refresh of the Test server from Production, Test server backup logs have: ORA-12154: TNS:could not resolve the connect identifier specified >>>rman_set_config ... bstatus=1 >>> 14-05-2015 01:30:08 >>>Error in rman_set_config ... bstatus=1 exec_backup_main 14-05-2015 01:30:02 The environment setup in the backup log shows: BKP_USER = aleph BKP_DB = server X.aleph0 The BKP_DB should be Y.aleph0 (Test) rather than X.aleph0 (Production). Resolution: Rather than bringing just the Oracle data over to Test, the Aleph u-tree, including the alephe, had been brought over. (This includes server specific values, such as the ORA_HOST value in $alephe_root/aleph_start.) Either just the Oracle data needs to be brought over, or the server-specifice alephe values need to be preserved. |