Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    37

    Unanswered: Oracle 9i - Database creation problem

    Hello

    I have installed Oracle 9i (release 2) standard edition - on a dell sever running w2k advanced server (service pack 4 + all critical patches since).

    The oracle installation went fine, however when we attempted to create the database we got the following error (we were using the Oracle database configuration assistant).

    ORA-00439:Feature Not Enabled:Managed Standby

    When passed the next error message appeared:

    ORA-001034:Oracle Not Available

    Which when we attempted to pass just put the install into a loop (returning the same message over and over) moving very slowly through the creation process (getting up to the early 20's of the install - percentage wise) - in the end the database creation was aborted.


    I have looked this problem up on the web and all the information I can find relates to Oracle 8i - and seems to be to do with the archive log.

    What I wanted to know is whether anyone had encountered the same problem in Oracle 9i - and therefore by extension the solution is the same?

    Many thanks in advance for any assistance on this matter.

    Kind regards

    Keith

  2. #2
    Join Date
    Sep 2003
    Location
    Columbia, MD USA
    Posts
    95
    do you have archive log mode enabled in your init file?

    you either need to comment out the lines for arvhive log mode or change the destination line:

    log_archive_dest_1 = "location=<whatever path>"

    needs to be changed to:

    log_archive_dest = "<whatever path>"


    here is the metalink article:

    http://metalink.oracle.com/metalink/...&p_id=112563.1
    drew
    ------------------
    http://wjtechnologies.com

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Post your INITxxx.ora file ... The database did not get created
    because of a parameter that is not available to you or is wrong...
    Therefore, the database was never available for the remainder of
    the scripts...

    You will need to correct the INITxxx.ora problem then create the database and have CATALOG, CATPROC etc run


    HTH
    Gregg

  4. #4
    Join Date
    Oct 2003
    Posts
    37

    Thanks folks

    I won't get a chance to have another go at creating the database till tomorrow.

    I'll let you know how I get on.


    Keith

  5. #5
    Join Date
    Oct 2003
    Posts
    37

    Re: Thanks folks

    Created the database using the configuration assistant but left archive log mode off - worked a treat.

    Thanks for the assistance.

    Kind regards


    Keith

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •