+ Reply to Thread
Results 1 to 10 of 10

ORA-39700: database must be opened with UPGRADE option - 10g R2 database

  1. ORA-39700: database must be opened with UPGRADE option - 10g R2 database

    I received the following error in my alert log file when i was trying
    to open the 10g R2 database after creating a NEW database manually.

    ORA-00704: bootstrap process failure
    ORA-39700: database must be opened with UPGRADE option

    I was wondering how the solution worked considering it was a new
    database and why I was being asked to use the UPGRADE option.

    I used following script to create the database manually

    CREATE DATABASE bmw01
    Maxinstances 1
    Maxloghistory 1
    Maxlogfiles 10
    Maxdatafiles 100
    logfile
    group 1 ('D:\oracle\bmw\oradata\logfile\redo_01.log') size 10M,
    group 2 ('D:\oracle\bmw\oradata\logfile\redo_02.log') size 10M,
    group 3 ('D:\oracle\bmw\oradata\logfile\redo_03.log') size 10M
    datafile 'D:\oracle\bmw\oradata\datafile\system_01.dbf' size 300M
    sysaux datafile 'D:\oracle\bmw\oradata\datafile\sysaux_01.dbf' size
    100M
    undo tablespace UNDO datafile
    'D:\oracle\bmw\oradata\datafile\undo_01.dbf' size 125M
    character set WE8MSWIN1252
    ;

    Upon firing the above the database was created but catalog /
    catproc.sql's failed, after which I was not able to open/start the
    database at all.

    I could find the following solution somehow on the net. Follow the
    steps mentioned below

    1. start a new sqlplus session
    2. fire the following command on sqlplus

    STARTUP UPGRADE

    3. The database now opens successfully after which catalog and cataproc
    sql's can be fired.

    4. Now shutdown and startup the database as the database was started
    with UPGRADE option.

    pupbld sql can be executed after step 4.

    (please note that the database created was a new one, It wasn't a 9i
    database ).

    Krishnaprasad
    9i OCP DBA


  2. Re: ORA-39700: database must be opened with UPGRADE option - 10gR2 database

    Did you try to startup with UPGRADE and then run CATALOG and CATPROC as
    suggested?

    Have you read the Administrator's Guide for your version? Pay particular
    attention to Chapter 2 - Creating an Oracle Database.

    HTH,
    Brian



    --
    ===================================================================

    Brian Peasland
    oracle_dba@nospam.peasland.net
    http://www.peasland.net

    Remove the "nospam." from the email address to email me.


    "I can give it to you cheap, quick, and good.
    Now pick two out of the three" - Unknown

  3. Re: ORA-39700: database must be opened with UPGRADE option - 10gR2 database

    Did you try to startup with UPGRADE and then run CATALOG and CATPROC as
    suggested?

    Have you read the Administrator's Guide for your version? Pay particular
    attention to Chapter 2 - Creating an Oracle Database.

    HTH,
    Brian



    --
    ===================================================================

    Brian Peasland
    oracle_dba@nospam.peasland.net
    http://www.peasland.net

    Remove the "nospam." from the email address to email me.


    "I can give it to you cheap, quick, and good.
    Now pick two out of the three" - Unknown

  4. Re: ORA-39700: database must be opened with UPGRADE option - 10gR2 database

    Did you try to startup with UPGRADE and then run CATALOG and CATPROC as
    suggested?

    Have you read the Administrator's Guide for your version? Pay particular
    attention to Chapter 2 - Creating an Oracle Database.

    HTH,
    Brian



    --
    ===================================================================

    Brian Peasland
    oracle_dba@nospam.peasland.net
    http://www.peasland.net

    Remove the "nospam." from the email address to email me.


    "I can give it to you cheap, quick, and good.
    Now pick two out of the three" - Unknown

  5. Re: ORA-39700: database must be opened with UPGRADE option - 10g R2 database

    Hi Brian

    Actually, I dont ve the guide you are speaking of. I had downloaded
    10gR2 from oracle website.

    Yes I executed catalog and catproc after i did a STARTUP UPGRADE.

    If you know about any other possible solution then please revert with
    the same.

    thank you
    Krishnaprasad / krishna / kris / kp

    Brian Peasland wrote:
    > Did you try to startup with UPGRADE and then run CATALOG and CATPROC as
    > suggested?
    >
    > Have you read the Administrator's Guide for your version? Pay particular
    > attention to Chapter 2 - Creating an Oracle Database.
    >
    > HTH,
    > Brian
    >



  6. Re: ORA-39700: database must be opened with UPGRADE option - 10g R2 database

    Hi Brian

    Actually, I dont ve the guide you are speaking of. I had downloaded
    10gR2 from oracle website.

    Yes I executed catalog and catproc after i did a STARTUP UPGRADE.

    If you know about any other possible solution then please revert with
    the same.

    thank you
    Krishnaprasad / krishna / kris / kp

    Brian Peasland wrote:
    > Did you try to startup with UPGRADE and then run CATALOG and CATPROC as
    > suggested?
    >
    > Have you read the Administrator's Guide for your version? Pay particular
    > attention to Chapter 2 - Creating an Oracle Database.
    >
    > HTH,
    > Brian
    >



  7. Re: ORA-39700: database must be opened with UPGRADE option - 10g R2 database

    Hi Brian

    Actually, I dont ve the guide you are speaking of. I had downloaded
    10gR2 from oracle website.

    Yes I executed catalog and catproc after i did a STARTUP UPGRADE.

    If you know about any other possible solution then please revert with
    the same.

    thank you
    Krishnaprasad / krishna / kris / kp

    Brian Peasland wrote:
    > Did you try to startup with UPGRADE and then run CATALOG and CATPROC as
    > suggested?
    >
    > Have you read the Administrator's Guide for your version? Pay particular
    > attention to Chapter 2 - Creating an Oracle Database.
    >
    > HTH,
    > Brian
    >



  8. Re: ORA-39700: database must be opened with UPGRADE option - 10g R2 database

    The guide Brian referenced, along with *all* of the Oracle docs, is
    available on-line in both html and pdf format. Go to
    http://tahiti.oracle.com/ You will have to sign-up for an account,
    but it's free and will pay dividends for years.


  9. Re: ORA-39700: database must be opened with UPGRADE option - 10g R2 database

    The guide Brian referenced, along with *all* of the Oracle docs, is
    available on-line in both html and pdf format. Go to
    http://tahiti.oracle.com/ You will have to sign-up for an account,
    but it's free and will pay dividends for years.


  10. Re: ORA-39700: database must be opened with UPGRADE option - 10g R2 database

    The guide Brian referenced, along with *all* of the Oracle docs, is
    available on-line in both html and pdf format. Go to
    http://tahiti.oracle.com/ You will have to sign-up for an account,
    but it's free and will pay dividends for years.


+ Reply to Thread