Home » Infrastructure » Linux » ORA-1092
ORA-1092 [message #98889] Wed, 02 July 2003 15:16 Go to next message
Kailash Hingorani
Messages: 3
Registered: July 2003
Junior Member
I have linux 8.1 (suse) and oracle 9.2
Installed oracle fine, default database created fine and working ok.
Wanted to create a new database, borowwed the init.ora from existing db and made appropriate changes (db_name, file location)
set oracle_sid and started sqlplus /nolog
startup nomount pfile= (worked fine)
create database script worked fine ... till the end .. at the time of opening database i get ora-1092.
control file, redolog, datafiles are all created and in place.
metalink suggested to recreate control file which i did all ok till time of 'Alter database open' where once again i get the same error.
this is end portion of alert log

Errors in file /opt/oracle/admin/testtwo/udump/sidtwo_ora_2465.trc:
ORA-01403: no data found
Error 1403 happened during db open, shutting down database
USER: terminating instance due to error 1403
Instance terminated by USER, pid = 2465
ORA-1092 signalled during: alter database open...

seems to be 1403 (no data found) trigering off 1092
WHY ??? and how do I resolve it ???
Would appreciate any and all help in this matter
thanx
-kailash hingorani
Re: ORA-1092 [message #98890 is a reply to message #98889] Thu, 03 July 2003 07:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I beleieve, sys.props$ is corrupted.
You have to recreate the database
Re: ORA-1092 [message #98891 is a reply to message #98890] Thu, 03 July 2003 07:38 Go to previous messageGo to next message
Kailash Hingorani
Messages: 3
Registered: July 2003
Junior Member
Mahesh,

Thank you for you reply, what is sys.prop$ ? why does it get corrupted ? how can I prevent if from getting corrupted in future ?

Would appreciate your replies

thanx
-kailash hingorani
Re: ORA-1092 [message #98892 is a reply to message #98891] Mon, 07 July 2003 06:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
it is one of the base tables upon which oracle is built, which is very important for the normal functionality.
There are many unknown scenarios in which prop$ is getting corruputed.
Oracle highly recomends Not to messup with $ tables / views. One reason i know, is when u run catlog.sql and other scripts to create baseline views and dictionary,
if something goes wrong many base tables like prop$ gets corrupted.

Re: ORA-1092 [message #98893 is a reply to message #98892] Mon, 07 July 2003 09:04 Go to previous messageGo to next message
Kailash Hingorani
Messages: 3
Registered: July 2003
Junior Member
Mahesh,

Thank you for your inputs, I ended up deleting and recreating the the database with exactly the same script / process and it went thru without a problem.
Re: ORA-1092 [message #99126 is a reply to message #98893] Thu, 19 August 2004 09:18 Go to previous message
ashish
Messages: 107
Registered: December 2000
Senior Member
Hi..I believe you can reproduce this issue.
Try running catlog.sql after database creation and then
just try to startup the database. You should be getting
same information in the database alert log.
Thanks.
Previous Topic: System crashes with .killing interrupt handler
Next Topic: Linux Display erorr
Goto Forum:
  


Current Time: Thu Mar 28 08:58:08 CDT 2024