RE: ORA 01092: ORACLE instance terminated. Disconnection forced

      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.

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

      User Rating: Be the first one !
      SilentGhost Vice Professor Asked on November 11, 2016 in oracle.
      Add Comment
      1 Answers

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

         

        Kind regards,

         

        Mark

        Add Comment

        Your Answer

        By posting your answer, you agree to the privacy policy and terms of service.