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.

    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.0So 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 startupThe database is coming to mount state but then it is…

    ORA 01092: ORACLE instance terminated. Disconnection forced

    Very Helpfull

    User Rating: Be the first one !
    Vice Professor Asked on November 11, 2016 in oracle.
    Add Comment
    1 Answer(s)

      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.