topic Re: Problem while doing upgrade from 9i to 10GR1 in Operating System - HP-UX

Problem while doing upgrade from 9i to 10GR1

Subodh deshpande_1 — Thu, 07 Dec 2006 08:06:49 GMT

Hi all,
I am upgrading from oracle 9.2.0.5 to 10GR1 with 10.1.0.4 patchset. I performed all the initial steps of upgrade. After issuing the command startup upgrade command, i executed the u0902000.sql file.

The file executes but at one point it is failing with the error
create or replace force view sys.ku$_xmlschema_view of sys.ku$_xmlschema_t
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

This is happening repeatedly.

Please help!!!
its very urgent.

REgards
Subodh

Re: Problem while doing upgrade from 9i to 10GR1

Coolmar — Thu, 07 Dec 2006 08:12:09 GMT

Unfortunately, it seems that message is somewhat of a catch-all error message...so it could be any number of things. I found the following for you to look into. HOpe it helps,

Following are some steps on how to check the reason behind the problem.

1. As it turns out, the most common reason is that the Oracle shadow process
on the server died unexpectedly. So, if a running process were to
suddenly encounter an ORA-03113 and/or 3114, the first place to check is
the alert.log on the server to see if any other Oracle errors occurred.

2. Next most common cause of ORA-03113 is that the SQL*Net driver was not
linked into the Oracle executable on Server. While the listener
successfully received the connection and passed it to the Oracle shadow
process, the shadow process would fail to respond in any way because it
would not know how to. So the client will see an ORA-03113 at connect
time.

3. Third most common cause is a machine crash or network failure at the
server side.

4. ORA-03113 has also been noticed where the a TOKEN RING card has the
Shared RAM size set to 8KB rather than 16KB. If you are using a TOKEN
RING card check the shared buffer size and try increasing it.

5. ORA-03113 also occurs when INIT.ORA parameters CONTEXT_AREA and
CONTEXT_INCR are set to a value of 4096. Increasing the value to 8192
resolves the 3113. (RDVMS V6 only)

6. ORA-03113 also occurs when there are duplicate IP addresses on the
network. To find the duplicate addresses turn off the unit that is getting
the 03113 and ping its IP address. If the ping responds then you have to
find the offending unit.

7. If an ORA-03113 error occurs intermittentlly on comparatively large select
statements, try setting the default buffer size to 4096, especially if
issuing an order by causes no problems but going through Q&E or SQR hangs
the machine.

ORA-03113 is just a symptom of a larger problem that will require more
diagnosis to track down. Hopefully, the above information will lead you
in the right direction to find the solution.

To debug an ORA-03113, it is a good idea to attempt the same operation
while doing a loopback, i.e can any tool on the server connect using the
same connect string as they specify from the Desktop client? If the same
problem occurs doing a loopback, then you know the problem resides on the
server side and not on the Desktop client side.

To perform a loopback invoke SQLPLUS or SQLDBA from the server, and at the
SQLPLUS or SQLDBA prompt on the server type:

CONNECT USERNAME/PASSWORD@t:/:

Re: Problem while doing upgrade from 9i to 10GR1

Avoiding the Red Zone — Thu, 07 Dec 2006 08:40:33 GMT

Hi,

I would recommend that you check if during the error any trace files are getting generated. Also have you checked your NET8 software configuration.

Regards,
Angus

Re: Problem while doing upgrade from 9i to 10GR1

Eric Antunes — Mon, 11 Dec 2006 05:19:35 GMT

Hi Subodh,

Now I don't have time to search this further but are you sure that applying directly 10.0.1.0.4 patchset on the 9i database is the right path to do this?

Best Regards,

Eric Antunes

Re: Problem while doing upgrade from 9i to 10GR1

Subodh deshpande_1 — Mon, 11 Dec 2006 05:34:43 GMT

Well i got the solution. One of the temporary tablespaces did not have any temp file. this was the reason.

Thanks a lot to everybody for your suggestions.

Regards
Subodh