Veronica,
There are two different types of installation CDs for Oracle 8.1.7:
1. Oracle 8.1.7 64-bit and
2. Oracle 8.1.7
Oracle cerfitied 8.1.7(32-bit) for 5L not for Oracle 8.1.6 64-bit. If you have Oracle
8.1.7(32-bit), then you can upgrade AIX 4.3.3 to AIX 5L:
1. Upgrade OS from AIX 4.3.3 to AIX 5L
2. Install the following AIX 5L OS patches as required by the Installation Guide,
refer to Note: 169706.1:
IY26778(5100-01)
IY28766(5100-01)
IY28949(5100-01)
IY29965(5100-02)
IY30150(5100-02)
Maint Level 1 and IY22854
Required OS packages:
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.perfstat
bos.perf.libperfstat
3. Install Oracle 8.1.7 for AIX 5L from CDs into new ORACLE_HOME
4. Copy init.ora to new ORACLE_HOME and modify the init.ora to change dump
directories,
5. Setup your environment to point to new ORACLE_HOME and start the databases.
I would recommend you to open a TAR with Oracle Support.
Muqthar Ahmed
-----Original Message-----
Sent: Friday, October 31, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
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: 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).
