Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cloning fails in db_clone.pl...

642385May 31 2008 — edited Dec 16 2008
I am trying to clone a windows db to a windows server with just files loaded using Enterprise Manager. We continue to get the following error during the destination preparation step .

Error in closing SQL_SCRIPT : at C:\OracleHomes\agent10g/sysman/admin/scripts/db/dbclone/db_clone.pl line 346.

I have attached the log ouput from the step as well.


Output Log

LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 31-MAY-2008 09:50:36

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PSSAND)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER_PSSAND
Version TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Production
Start Date 31-MAY-2008 08:53:03
Uptime 0 days 0 hr. 57 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\oracle\product\11.1.0\db_1\network\admin\listener.ora
Listener Log File c:\app\oracle\diag\tnslsnr\PSSAND\listener_pssand\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PSSAND)(PORT=1521)))
Services Summary...
Service "PSSAND.PSSAND.UWSTOUT.EDU" has 1 instance(s).
Instance "PSSAND", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 31-MAY-2008 09:50:36

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PSSAND)(PORT=1521)))
The command completed successfully
Error in closing SQL_SCRIPT : at C:\OracleHomes\agent10g/sysman/admin/scripts/db/dbclone/db_clone.pl line 346.

SQL*Plus: Release 11.1.0.6.0 - Production on Sat May 31 09:50:50 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL> Connected to an idle instance.
SQL> ORACLE instance shut down.
SQL> Disconnected
Error in closing SQL_SCRIPT : at C:\OracleHomes\agent10g/sysman/admin/scripts/db/dbclone/db_clone.pl line 346.

SQL*Plus: Release 11.1.0.6.0 - Production on Sat May 31 09:50:51 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL> Connected to an idle instance.
SQL> ORACLE instance shut down.
SQL> create spfile from pfile='C:\app\oracle\product\11.1.0\db_1\database\initPSSAND.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00116: syntax error at 'control_files' following '='


SQL> ORA-01078: failure in processing system parameters
ORA-32004: obsolete and/or deprecated parameter(s) specified
SQL> Disconnected
Error in closing SQL_SCRIPT : at C:\OracleHomes\agent10g/sysman/admin/scripts/db/dbclone/db_clone.pl line 346.

SQL*Plus: Release 11.1.0.6.0 - Production on Sat May 31 09:50:52 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL> Connected to an idle instance.
SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 declare
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> SQL> Disconnected
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2009
Added on May 31 2008
6 comments
4,402 views