ORA-01092: ORACLE instance terminated
I am using Oracle220.127.116.11 on Sun Spark.......
Whenever i open the database, after mounting the instanced gets
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
12701, 00000, "CREATE DATABASE character set is not known"
// *Cause: The character set specified when creating the database is unknown.
Is this a new database or one you have migrated?
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!
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."
jlakhani, the error itself is pretty explicit
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 01:22 AM.
Click Here to Expand Forum to Full Width