Hello all,
This worked very well in the past (several weeks ago) but suddenly it caused problem today. I am cloning from a backup to a new host (same host that worked for me before) and got the following error from SMO. It worked fine if I cloned to the same host (but this is not what we do in reality:)
--[ERROR] SMO-13032: Cannot perform operation: Clone Create. Root cause: ORACLE-00001: Error executing SQL: [STARTUP NOMOUNT EXCLUSIVE PFILE=/home/oracle2/102/dbs/initdentoncl.ora;]. The command returned: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12154: TNS:could not resolve the connect identifier specified
I would appreciate any help.
Many thanks,
JS
All messages from SMO (GUI or CLI):
--[ INFO] SMO-13046: Operation GUID 233989e22bd02e6d012bd02e70d70001 starting on Profile ORA10GF_PROFILE
--[ INFO] SMO-04030: Validating uniqueness of new SID "dentoncl".
--[ INFO] SMO-04040: Using ORACLE_HOME of "/home/oracle2/102" from clonespec for clone.
--[ INFO] SMO-04042: Using Oracle OS account "oracle" from clonespec for clone.
--[ INFO] SMO-04044: Using Oracle OS group "dba" from clonespec for clone.
--[ INFO] SMO-07127: Locked database for SnapManager operations - created lock file "/home/oracle2/102/dbs/.sm_lock_dentoncl" on host denton.se.houston.geoquest.slb.com.
--[ INFO] SD-00025: Beginning to connect filesystem(s) [/home/vol2_oracle, /home/oracle2] from snapshot smo_ora10gf_profile_ora10gf_f_h_at_122759_on_20101021_1_2339899f2bcfd512012bcfd51c050001_0_mybackup.
--[ INFO] SD-00016: Discovering storage resources for /home/vol2_oracle_DENTONCL.
--[ INFO] SD-00017: Finished storage discovery for /home/vol2_oracle_DENTONCL.
--[ INFO] SD-00016: Discovering storage resources for /home/oracle2_DENTONCL.
--[ INFO] SD-00017: Finished storage discovery for /home/oracle2_DENTONCL.
--[ INFO] SD-00026: Finished connecting filesystem(s) [/home/vol2_oracle, /home/oracle2] from snapshot smo_ora10gf_profile_ora10gf_f_h_at_122759_on_20101021_1_2339899f2bcfd512012bcfd51c050001_0_mybackup.
--[ INFO] SD-00025: Beginning to connect filesystem(s) [/home/oracle2] from snapshot smo_ora10gf_profile_ora10gf_f_h_at_122833_on_20101021_2_2339899f2bcfd512012bcfd51c050001_0_mybackup.
--[ INFO] SD-00016: Discovering storage resources for /opt/NetApp/smo/mnt/-home-oracle2-20101021140537689_0.
--[ INFO] SD-00017: Finished storage discovery for /opt/NetApp/smo/mnt/-home-oracle2-20101021140537689_0.
--[ INFO] SD-00026: Finished connecting filesystem(s) [/home/oracle2] from snapshot smo_ora10gf_profile_ora10gf_f_h_at_122833_on_20101021_2_2339899f2bcfd512012bcfd51c050001_0_mybackup.
--[ INFO] ORACLE-00502: Adding entry for database dentoncl in /etc/oratab.
--[ INFO] SMO-07300: Beginning clone of database "ORA10GF" to SID "dentoncl" on host "denton".
--[ INFO] SMO-07302: Generating parameter file for "dentoncl" at "/home/oracle2/102/dbs/initdentoncl.ora".
--[ INFO] SMO-07303: Generating password file for "dentoncl" at "/home/oracle2/102/dbs/orapwdentoncl".
--[ INFO] SMO-07304: Starting up database "dentoncl" in NOMOUNT mode.
--[ERROR] SMO-13032: Cannot perform operation: Clone Create. Root cause: ORACLE-00001: Error executing SQL: [STARTUP NOMOUNT EXCLUSIVE PFILE=/home/oracle2/102/dbs/initdentoncl.ora;]. The command returned: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12154: TNS:could not resolve the connect identifier specified
--[ INFO] SMO-07316: Shutting down database "dentoncl".
--[ INFO] SMO-07317: Deleting file "/home/oracle2/102/dbs/initdentoncl.ora".
--[ INFO] SMO-07317: Deleting file "/home/oracle2/admin/dentoncl/bdump".
--[ INFO] SMO-07317: Deleting file "/home/oracle2/admin/dentoncl/cdump".
--[ INFO] SMO-07317: Deleting file "/home/oracle2/admin/dentoncl/udump".
--[ INFO] SMO-07317: Deleting file "/home/oracle2/102/dbs/orapwdentoncl".
--[ INFO] SMO-04038: Deleting now empty directory "/home/oracle2/admin/dentoncl"
--[ INFO] ORACLE-00503: Removing entry for database dentoncl from /etc/oratab.
--[ INFO] SD-00031: Beginning to disconnect filesystem(s) [/opt/NetApp/smo/mnt/-home-oracle2-20101021140537689_0].
--[ INFO] SD-00032: Finished disconnecting filesystem(s) [/opt/NetApp/smo/mnt/-home-oracle2-20101021140537689_0].
--[ INFO] SD-00031: Beginning to disconnect filesystem(s) [/home/oracle2_DENTONCL, /home/vol2_oracle_DENTONCL].
--[ INFO] SD-00032: Finished disconnecting filesystem(s) [/home/oracle2_DENTONCL, /home/vol2_oracle_DENTONCL].
--[ INFO] SMO-07131: Unlocked database for SnapManager operations - removed lock file "/home/oracle2/102/dbs/.sm_lock_dentoncl" on host denton.se.houston.geoquest.slb.com.
--[ INFO] SMO-13039: Successfully aborted operation: Clone Create
--[ERROR] SMO-13048: Clone Create Operation Status: FAILED
--[ INFO] SMO-13049: Elapsed Time: 0:00:56.197