From: sstefick (sstefick@HARPER.CC.IL.US)
Date: Sat Nov 16 2002 - 10:30:59 EST
Try to explicitly set and export the ORACLE_SID environment variable to point
to the SID of the database with the issue so you know it is pointing to the
correct database. Then try to go back into svrmgrl and "startup nomount" the
pfile pointing to that database. If that works, then in svrmgrl to and
"alter database open;"
Also, do the databases have their own ORACLE_HOME's or do they share one? If
they have their own, then also explicitly set and export the ORACLE_HOME to
point to the correct location for that database.
>===== Original Message From IBM AIX Discussion List <aix-l@Princeton.EDU>
=====
>>What oracle version are you on?
>8.1.7
>
>there are 2 instances, one works, the other doesnt
>
>
>>Try running the oraenv script (as the Oracle user),
>...
>
>no difference:
>
>SVRMGR> connect internal
>Connected.
>SVRMGR> startup pfile=/prod/oracle/ora817/dbs/initPFMSR.ora
>ORACLE instance started.
>Total System Global Area 476207228 bytes
>Fixed Size 116860 bytes
>Variable Size 132018176 bytes
>Database Buffers 327680000 bytes
>Redo Buffers 16392192 bytes
>Database mounted.
>ORA-03113: end-of-file on communication channel
>SVRMGR>
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:21 EDT