Pastebin

Paste #8944: No description

< previous paste - next paste>

Pasted by Anonymous Coward

Download View as text

--[ INFO] SMO-13036: Starting operation Clone Create on host orcl2
--[ INFO] SMO-13046: Operation GUID 8a2a840e6d5e6af1016d5e6af3b10001 starting on Profile ORCL2_PROFILE
--[ INFO] SMO-04030: Validating uniqueness of new SID "orcl4".
--[ INFO] SMO-04040: Using ORACLE_HOME of "/u/app/oracle/product/12.2.0.1/dbhome_1" 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 "/u/app/oracle/product/12.2.0.1/dbhome_1/dbs/.sm_lock_orcl4" on host orcl2.
--[ INFO] SD-00025: Beginning to connect filesystem(s) [/data] from snapshot smo_orcl2_profile_orcl2_f_c_1_8a2a840e6d5e64e5016d5e64e7da0001_0.
--[ INFO] SD-00016: Discovering storage resources for /data_ORCL4.
--[ INFO] SD-00017: Finished storage discovery for /data_ORCL4.
--[ INFO] SD-00026: Finished connecting filesystem(s) [/data] from snapshot smo_orcl2_profile_orcl2_f_c_1_8a2a840e6d5e64e5016d5e64e7da0001_0.
--[ INFO] ORACLE-00502: Adding entry for database orcl4 in /etc/oratab.
--[ INFO] SMO-07300: Beginning clone of database "ORCL" to SID "orcl4" on host "orcl2".
--[ INFO] SMO-07302: Generating parameter file for "orcl4" at "/u/app/oracle/product/12.2.0.1/dbhome_1/dbs/initorcl4.ora".
--[ INFO] SMO-07304: Starting up database "orcl4" in NOMOUNT mode.
--[ INFO] SMO-07305: Generating control files for database "orcl4".
--[ INFO] SMO-07312: Create Control File - Database: orcl4.
--[ INFO] SMO-07313: Create Control File - Redolog: /data_ORCL4/redo_2.log.
--[ INFO] SMO-07313: Create Control File - Redolog: /data_ORCL4/redo_1.log.
--[ INFO] SMO-07313: Create Control File - Redolog: /data_ORCL4/redo_3.log.
--[ INFO] SMO-07314: Create Control File - Datafile: /data_ORCL4/oradata/ORCL2/datafile/o1_mf_undotbs1_gqh6cy2b_.dbf.
--[ INFO] SMO-07314: Create Control File - Datafile: /data_ORCL4/oradata/ORCL2/datafile/o1_mf_sysaux_gqh6cxo7_.dbf.
--[ INFO] SMO-07314: Create Control File - Datafile: /data_ORCL4/oradata/ORCL2/datafile/o1_mf_users_gqh6cxo1_.dbf.
--[ INFO] SMO-07314: Create Control File - Datafile: /data_ORCL4/oradata/ORCL2/datafile/o1_mf_system_gqh6cy1z_.dbf.
--[ INFO] SMO-07306: Generating server parameter file for database "orcl4" at Oracle default location.
--[ INFO] SMO-07320: Opening database "orcl4" with RESETLOGS option.
--[ INFO] SMO-07316: Shutting down database "orcl4".
--[ INFO] SMO-07321: Starting up database "orcl4" in MOUNT mode.
--[ INFO] SMO-07307: Generating new Database ID for "orcl4".
--[ INFO] SMO-07308: Opening database "orcl4".
--[ERROR] SMO-13032: Cannot perform operation: Clone Create.  Root cause: ORACLE-00001: Error executing SQL: [ALTER TABLESPACE TEMP ADD TEMPFILE '/data_ORCL4/o1_mf_temp_%u_.tmp' SIZE 0 REUSE;].  The command returned: ORA-02009: the size specified for a file must not be zero
--[ INFO] SMO-07316: Shutting down database "orcl4".
--[ INFO] SMO-07317: Deleting file "/u/app/oracle/product/12.2.0.1/dbhome_1/dbs/initorcl4.ora".
--[ INFO] SMO-07317: Deleting file "/u/app/oracle/admin/orcl4/adump".
--[ INFO] SMO-07317: Deleting file "/data_ORCL4/archive_logs".
--[ INFO] SMO-07317: Deleting file "/u/app/oracle/product/12.2.0.1/dbhome_1/dbs/hc_orcl4.dat".
--[ INFO] SMO-07317: Deleting file "/data_ORCL4/control01.ctl".
--[ INFO] SMO-07317: Deleting file "/u/app/oracle/product/12.2.0.1/dbhome_1/dbs/spfileorcl4.ora".
--[ INFO] SMO-04038: Deleting now empty directory "/u/app/oracle/admin/orcl4"
--[ INFO] ORACLE-00503: Removing entry for database orcl4 from /etc/oratab.
--[ INFO] SD-00031: Beginning to disconnect filesystem(s) [/data_ORCL4].
--[ INFO] SD-00032: Finished disconnecting filesystem(s) [/data_ORCL4].
--[ INFO] SMO-07131: Unlocked database for SnapManager operations - removed lock file "/u/app/oracle/product/12.2.0.1/dbhome_1/dbs/.sm_lock_orcl4" on host orcl2.
--[ INFO] SMO-13039: Successfully aborted operation: Clone Create
--[ERROR] SMO-13048: Clone Create Operation Status: FAILED
--[ INFO] SMO-13049: Elapsed Time: 0:04:25.351

New Paste


Do not write anything in this field if you're a human.

Go to most recent paste.