Re: Clone db 9.2 on AIX 5L

I relinked all after OS upgraded to 5L. Oracle 8.1.7.4 32bit.

Robin
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> 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:Muqthar.Ahmed_at_decoratetoday.com]
> 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: jblake_at_arrow.com
>
>
> When are you getting the error? During startup?
>
> Adam
>
>
>
>
> "John Blake" <jblake_at_arrow.com>
> Sent by: ml-errors_at_fatcity.com
> 10/27/2003 03:04 PM
> Please respond to
> ORACLE-L_at_fatcity.com
>
>
> To
> Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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-----
> adamdonahue_at_maximus.com
> 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" <jblake_at_arrow.com>
> Sent by: ml-errors_at_fatcity.com
> 10/27/2003 02:24 PM
> Please respond to
> ORACLE-L_at_fatcity.com
>
>
> To
> Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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: adamdonahue_at_maximus.com
>
> 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: ListGuru_at_fatcity.com (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: jblake_at_arrow.com
>
> 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: ListGuru_at_fatcity.com (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: jblake_at_arrow.com
>
> 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: ListGuru_at_fatcity.com (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: Muqthar.Ahmed_at_decoratetoday.com
>
> 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: ListGuru_at_fatcity.com (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: vlevin_at_victoria.com.ni
>
> 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: ListGuru_at_fatcity.com (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: rli_at_nyp.org

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: ListGuru_at_fatcity.com (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).