OraFAQ Forum: Linux

Home » Infrastructure » Linux » ORA-1092

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-1092 [message #98889]

Wed, 02 July 2003 15:16

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

Report message to a moderator

Re: ORA-1092 [message #98890 is a reply to message #98889]

Thu, 03 July 2003 07:22

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I beleieve, sys.props$ is corrupted.
You have to recreate the database

Report message to a moderator

Re: ORA-1092 [message #98891 is a reply to message #98890]

Thu, 03 July 2003 07:38

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

Report message to a moderator

Re: ORA-1092 [message #98892 is a reply to message #98891]

Mon, 07 July 2003 06:46

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: ORA-1092 [message #98893 is a reply to message #98892]

Mon, 07 July 2003 09:04

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.

Report message to a moderator

Re: ORA-1092 [message #99126 is a reply to message #98893]

Thu, 19 August 2004 09:18

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.

Report message to a moderator

Previous Topic:	System crashes with .killing interrupt handler
Next Topic:	Linux Display erorr

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 14:22:17 CST 2025