ORA 01092: ORACLE instance terminated. Disconnection forced

[Former Member]

Hi,

I have oracle 10.2.0.1 in my system. But as per installation guide instruction we need atleast oracle 10.2.0.2 version for ECC 6.0

So I have applied patch for oracle 10.2.0.2. Before doing that I stopeed the sap system. Then I shutdown the database by using "SHUTDOWN IMMEDIATE". Then I stopped all SAP & oracle related services. Then I run setup.exe to apply the patch. After the patch application I have started all the services again.

Now when I come to the command prompt & type sqlplus /nolog

conn /as sysdba

startup

The database is coming to mount state but then it is showing ORA 01092: ORACLE instance terminated. Disconnection forced.

I have checked the alert log file. It says:

Mon Mar 07 12:21:36 2011

ORACLE V10.2.0.2.0 - Production vsnsta=0

vsnsql=14 vsnxtr=3

Windows NT Version V5.2 Service Pack 2

CPU : 4 - type 586, 2 Physical Cores

Process Affinity : 0x00000000

Memory (Avail/Total): Ph:3300M/3839M, Ph+PgF:14785M/15203M, VA:1928M/2047M

Mon Mar 07 12:21:36 2011

Adjusting the default value of parameter parallel_max_servers

from 80 to 65 due to the value of parameter processes (80)

Mon Mar 07 12:21:36 2011

Starting ORACLE instance (normal)

Mon Mar 07 12:21:37 2011

Specified value of sga_max_size is too small, bumping to 633339904

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Shared memory segment for instance monitoring created

Picked latch-free SCN scheme 2

Autotune of undo retention is turned on.

IMODE=BR

ILAT =10

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Now to start the database what I have to do? Can anyone tell me the solution.

[sunny_pahuja2]

Hi,

Execute below commands then it will work:

1. Started oracle instance with STARTUP UPGRADE command at sql prompt

2. Applied suggested scripts i.e. catalog.sql, catupgrd.sql and after executing both scripts;

3. Compile using suggested script utlrp.sql

4. Shutdown immediate and startup

Thanks

Sunny

[Former Member]

Hi,

can you tell me the entire process of applying suggested scipts catalog.sql, catupgrd.sql, utlrp.sql ?

I mean the queries. should I have to login as sys user with sysdba privilages?

[markus_doehr2]

I suggest you just read the "readme.html" that comes with the patch, it explains all in detail.

Markus

[Former Member]

Hi ,

You should connect with sysdba privilages and excute the above mentioned scripts, i hope your problem is solved.

[Former Member]

Hi Experts,

Thanks you a lot. My problem is resolved.

[Former Member]

Have you only applied the patch, or did you run the upgrade scripts as well?

Kind regards,

Mark