Hi John...
Actually I do not use AIX, but I used to work with 3x
and first 4x version.
I do not know if your AIX version still manages AIX
modules, but if it does, then you need to load the
modules pointed in your root.sh (or rootpre.sh) file,
I do not remember very well.
Of course, you can run the command manually with the
root account.
I think this error is because you need to have your
aix modules loaded and of course, this affects your
kernel parameters, i.e. your new instance
cannot allocate enough resources as is needed.
HTH
JL
- John Blake <jblake_at_arrow.com> wrote:
> 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).
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jose Luis Delgado
INET: joseluis_delgado_at_yahoo.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).
Received on Tue Oct 28 2003 - 12:39:25 CST