John,
I'm not running AIX 5.1 or Oracle 9.2 (we're 8.1.6 on AIX 4.3.3). However,
I have had some strange 3113 errors when trying to start a database. Did
you have a false start and then ran the script again? The reason being
we've seen problems due to memory segments hanging around after a crash. I
found this note from our problems.
----------------------------------------------------------------------------
-------------------------------
Oracle error:
ORA-03113 Error: End of Communication Channel -> This error is caused by
shared memory segments hanging due to the crashing of a database. This
happened on prd3 and after a lot of research, it was found that doing a ipcs
-ma command will show you all the processes using shared memory. Look for
the ORACLE processes. On prd3, there were only 4 of them and each process
ties back to a Oracle table by using the NATTCH field and grepping for the
table name. For example, ps -ef | grep prod should give you the number of
attached processes and that can be matched to the NATTCH field in the ipcs
command, therefore that particular table can be associated with that
database. Usually, the NATTCH field contains a 0 (zero), whenever the
segment is hung and no longer associated with the database. In our case,
the table involved was prod and the segment had a NATTCH field of 0 (zero).
If you use the ipcrm -m (pid) to remove the hung segment, it will free it
and allow the database to be started again.
EXAMPLE:
> ipcs -am|grep oracle
# Processes attached to this process
m 655371 0xba08cf68 --rw-r----- oracle dba oracle dba 82 1378840576 8642
67132
m 12 0x90edba50 --rw-r----- oracle dba oracle dba 11 117329920
3896 52348
m 13 0x6b714a88 --rw-r----- oracle dba oracle dba 18 131190784
2712 102820
m 262158 0xf7ef598c --rw-r----- oracle dba oracle dba 21 107368448 11998
134330
Then do:
> ps -ef|grep SYS|wc -l
11
> ps -ef|grep AUTO|wc -l
18
> ps -ef|grep FAX|wc -l
22
> ps -ef|grep PROD|wc -l
83
to verify that the count matches the counts from the ipcs -am. The counts
are in the 9th column.
Have the SA remove the memory segment that doesn't match. In fact, that one
should have 0 as it's number of processes.
----------------------------------------------------------------------------
--------------------------------------
You do need to do your homework with this, because you could drop a good
database. But you should be ok if your SA knows what he's doing.
Don't know if it will help, but thought I'd send it out.
Durinda Jones
Yellow Technologies
-----Original Message-----
Sent: Tuesday, October 28, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
The alert log statest that the instance is starting NORMAL and that is all
she wrote .... No trace files all my directories exist all owned by oracle
UID The cr_spap script contains all create controlfile commands and yes
since the "STARTUP NOMOUNT" is failing the balance is just from the echoed
output ..
Basically I think I'm just missing some obscure detail here, as there was
someone in the list confirming that they are performing this on a similar
environment AIX5.1 and ORACLE 9.2 That in mind I have gone through the
init.ora checked for directory existance now researching listener config
etc..
-----Original Message-----
Sent: Tuesday, October 28, 2003 12:33 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
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: 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: Durinda.Jones
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).
