I relinked all after OS upgraded to 5L. Oracle 8.1.7.4 32bit. Robin ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 31, 2003 10:29 AM
> Hi Muqthar , > I am planning to upgrade from AIX 4.3.3 to AIX 5L (5.2), > but I am not planning to upgrade Oracle. > I am at 8.1.7.2 and can't upgrade to 9i yet due to applications > compatibility.... > Do I have to upgrade Oracle to 9i if I upgrade AIX to 5L???? > I understand Oracle 8.1.7.2 can run on AIX 5L at 32 bits without problems. > > Saludos, > Verónica Levin Enríquez > GTI > Compañía Cervecera de Nicaragua > > > -----Mensaje original----- > De: Muqthar Ahmed [mailto:[EMAIL PROTECTED] > Enviado el: Tuesday, October 28, 2003 12:00 PM > Para: Multiple recipients of list ORACLE-L > Asunto: RE: Clone db 9.2 on AIX 5L > > > Hi, > > You DO NOT have to CLONE the databases if you are upgrading the OS from > 4.3.3 to 5L. You mentioned that the instances are already running. > > IBM has break the technology at AIX 5.1.0.0, meaning the AIX 4.3.3 and AIX > 5.1.0.0 have different architecture. So if you are upgrading IBM AIX 4.3.3 > to AIX 5.1.0.0, you also have to upgrade Oracle at the same time. Oracle > 9.2 CDs are separate for IBM AIX 4.3.3 and IBM AIX 5.1.0.0. > > If you are in this situation, all you have to is shutdown all databases, > install Oracle 9.2 with 5L CDs in new ORACEL HOME and setup your environment > with new ORACLE HOME to start your existing databases. > > Muqthar Ahmed > > > -----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: Muqthar Ahmed > 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: Veronica Levin > 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: Robin Li 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).