John, Did you see any messages in the alert log? And what is in the cr_spap script? the startup nomount is failing immediately, so everything else is worthless.
Review the initspap.ora file and make sure that all of the directories exist. Also, is the ORACLE_SID evironmental set prior to running sqlplus? Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Tuesday, October 28, 2003 11:49 AM To: Multiple recipients of list ORACLE-L SQL> @cr_spap SQL> STARTUP NOMOUNT pfile=/iu33/u01/app/oracle/admin/spap/pfile/initspap.ora ORA-03113: end-of-file on communication channel SQL> CREATE CONTROLFILE REUSE DATABASE "SPAP" RESETLOGS NOARCHIVELOG 2 MAXLOGFILES 50 3 MAXLOGMEMBERS 5 4 MAXDATAFILES 100 5 MAXINSTANCES 1 6 MAXLOGHISTORY 226 7 LOGFILE 8 GROUP 1 '/iu33/u02/oradata/spap/redo01.log' SIZE 100M, 9 GROUP 2 '/iu33/u02/oradata/spap/redo02.log' SIZE 100M, 10 GROUP 3 '/iu33/u02/oradata/spap/redo03.log' SIZE 100M 11 DATAFILE 12 '/iu33/u02/oradata/spap/system01.dbf', 13 '/iu33/u02/oradata/spap/undotbs01.dbf', 14 '/iu33/u02/oradata/spap/drsys01.dbf', 15 '/iu33/u02/oradata/spap/example01.dbf', 16 '/iu33/u02/oradata/spap/odm01.dbf', 17 '/iu33/u02/oradata/spap/tools01.dbf', 18 '/iu33/u02/oradata/spap/users01.dbf', 19 '/iu33/u02/oradata/spap/xdb01.dbf', 20 '/iu33/u02/oradata/spap/users02.dbf', 21 '/iu33/u02/oradata/spap/users03.dbf', 22 '/iu33/u02/oradata/spap/users04.dbf', 23 '/iu33/u02/oradata/spap/users05.dbf', 24 '/iu33/u02/oradata/spap/indexes01.dbf', 25 '/iu33/u02/oradata/spap/indexes02.dbf', 26 '/iu33/u02/oradata/spap/indexes03.dbf' 27 CHARACTER SET WE8ISO8859P1 28 ; CREATE CONTROLFILE REUSE DATABASE "SPAP" RESETLOGS NOARCHIVELOG * ERROR at line 1: ORA-03114: not connected to ORACLE SQL> -- RECOVER DATABASE SQL> -- ALTER DATABASE OPEN; SQL> -- ALTER TABLESPACE TEMP ADD TEMPFILE '/iu33/u02/oradata/spap/temp01.dbf' SIZE 3119M REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE ; SQL> The confusing thing is that I have instances already running on the machine. So I know the install is ok. I can start/shutdown the existing instances no problem. But when I try to clone and startup --- I get the results from above. -----Original Message----- Sent: Monday, October 27, 2003 5:24 PM To: [EMAIL PROTECTED] When are you getting the error? During startup? Adam "John Blake" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/27/2003 03:04 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc Subject RE: Clone db 9.2 on AIX 5L Sorry, AIX 5L to AIX 5L cold backup copies create backup controlfile to trace -- edited for the new file locations keeping the SID the same created init.ora from spfile startup nomount pfile=<init.ora> getting ora-3113 I have a TAR opened and figured I would check out here as well. -----Original Message----- [EMAIL PROTECTED] Sent: Monday, October 27, 2003 4:44 PM To: Multiple recipients of list ORACLE-L How about some more details? Are you cloning to a similar platform? Are you using a cold backup with controlfile recreation? RMAN backup or restore? RMAN duplicate? ... Adam "John Blake" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/27/2003 02:24 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc Subject Clone db 9.2 on AIX 5L Just checking to see if anyone has been able to clone a 9.2 DB from one machine to another. I have never had a problem doing this prior to 9.2, and am just wondering if I have overlooked something peculiar to 9i. Thanks in adavance John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Blake INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Blake INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).