| ORA-03113 on startup migrate from 8.1.7.4 to 9.2.0.6 [message #145040] |
Mon, 31 October 2005 09:01  |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi all,
I got a problem upgrading a Database running under HP/UX 11.
We have a 8.1.7.4 and plan to migrate to 9.2.0.6 64 bit. I just take the path Oracle provides in DocID Note:159657.1
But as I started the database with STARTUP MIGRATE
I got the ORA-03113 at opening the DB.
I just found some interesting Doc at Metalink, but no workaround will work on ors (e.g. changing SHLIB and LD_LIBRARY_PATH).
What could be the problem on this migration path ?
I take every step provided in the doc, but I guess I miss someting ?
Thanks in advance
Uwe
|
|
|
|
| Re: ORA-03113 on startup migrate from 8.1.7.4 to 9.2.0.6 [message #145253 is a reply to message #145040] |
Wed, 02 November 2005 01:01  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
ORA-03113: end-of-file on communication channel
Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8 two-task software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.
In addition, this message could occur when any of the following statements/commands have been issued:
* ALTER SYSTEM KILL SESSION ... IMMEDIATE
* ALTER SYSTEM DISCONNECT SESSION ... IMMEDIATE
* SHUTDOWN ABORT/IMMEDIATE/TRANSACTIONAL
Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of Oracle Support Services.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-03113 on startup migrate from 8.1.7.4 to 9.2.0.6 [message #145344 is a reply to message #145040] |
Wed, 02 November 2005 10:39 |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
| Uwe wrote on Mon, 31 October 2005 09:01 |
Hi all,
I got a problem upgrading a Database running under HP/UX 11.
We have a 8.1.7.4 and plan to migrate to 9.2.0.6 64 bit. I just take the path Oracle provides in DocID Note:159657.1
But as I started the database with STARTUP MIGRATE
I got the ORA-03113 at opening the DB.
I just found some interesting Doc at Metalink, but no workaround will work on ors (e.g. changing SHLIB and LD_LIBRARY_PATH).
What could be the problem on this migration path ?
I take every step provided in the doc, but I guess I miss someting ?
Thanks in advance
Uwe
|
OK I am presumming some things here (based on what you provided)
1. you are at 8.1.7.4 32-bit and want to go to 9.2.0.6.0 64-bit
then in your SHLIB and LD_LIBRARY_PATH, make sure that the 64 bit libs come before the 32 bit libs
2. you are at 8.1.7.4 64-bit and want to go to 9.2.0.6.0 64-bit
your SHLIB and LD_LIBRARY_PATH should be already using the 64-bit libs
before you try to do "startup mount"....
do a clean shutdown of database and listener
check
1. .profile (all PATHS)
2. .oenv and anything else you are using during a login
3. ORACLE_SID
4. ORACLE_BASE, ORACLE_HOME (VERY IMP). Make sure you are using the new ORACLE_HOME (/u01/app/oracle/product/9.2.0)
do a fresh login to make sure you have all things set.
try now.
I am using 9.2.0.4.0 64-bit in AIX 5L and I have
$ORACLE_HOME/lib
$ORACLE_HOME/lib32
as can be seen, $ORACLE_HOME/lib is the 64-bit lib, and FYI there is NO 32-bit Oracle for AIX 5L. The 32-bit lib is for apps that use 32-bit library (a lot of them are 32-bit) and backward compatibiliy.
I dunno about HP-UX 11. You may have
$ORACLE_HOME/lib
$ORACLE_HOME/lib64
in which case $ORACLE_HOME/lib64 is the 64-bit lib...and this needs to be ahead of the 32-bit lib in the PATHs.
Good luck.
--
Sanjay
[Updated on: Wed, 02 November 2005 10:45] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
