ORA-01092: ORACLE instance terminated
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORA-01092: ORACLE instance terminated

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    ORA-01092: ORACLE instance terminated

    Hi guys,
    I am using Oracle9.0.1.0 on Sun Spark.......

    Whenever i open the database, after mounting the instanced gets
    terminated
    ORA-01092: ORACLE instance terminated. Disconnection.


    Alert log file says:

    Instance terminated by user, PID 632 force
    ORA-1092 signalled during ALTER DATABASE OPEN

    Trace file says:

    ORA-12701: CREATE DATABASE, character set is no know



    Could some body help me out
    Regards

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    wth

    12701, 00000, "CREATE DATABASE character set is not known"
    // *Cause: The character set specified when creating the database is unknown.
    // *Action:

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Is this a new database or one you have migrated?

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    I would recommend that you talk to the unix admin to find out
    who the user PID 632 is. Also maybe you should check cdump and bdump for trace files. Its a long shot but did you configure your kernel Parms?
    "High Salaries = Happiness = Project Success."

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    jlakhani, the error itself is pretty explicit

  6. #6
    Join Date
    Sep 2002
    Posts
    376
    Hi,
    This was the Database Created with OMF parameters. First time,
    the database created with OMF parameters, and i happened to shutdown the database to alter the CONTROL FILE parameter in the init.ora, and getting this error.

    Even in non-omf databases also, i have faced the similar problems. After mount, when it tries to open the d/b; it gets terminated. I think there is some problem in 9i.

    and the PID which is terminating the instance is oracle ie., the first server process.

    and charecterset; i have never specified anything related to charecter set in my create database. I have left it the default setting.
    Last edited by bang_dba; 12-21-2002 at 12:22 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width