ORA-01092: ORACLE instance terminated

Printable View

12-20-2002, 06:38 AM
bang_dba

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
12-20-2002, 07:12 AM
pando

wth

12701, 00000, "CREATE DATABASE character set is not known"
// *Cause: The character set specified when creating the database is unknown.
// *Action:
12-20-2002, 07:13 AM
jovery

Is this a new database or one you have migrated?

Regards
12-20-2002, 11:00 AM
jlakhani

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?
12-20-2002, 11:12 AM
pando

jlakhani, the error itself is pretty explicit
12-21-2002, 01:17 AM
bang_dba

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.