Check to your alert log for error messages. Maybe you haven't set your kernel parameters accordingly & your new instance can't allocate enough resources it needs.
Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, October 28, 2003 6:49 PM > 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: Tanel Poder 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).
