| re-executing query forces db crash [message #53960] |
Tue, 22 October 2002 00:25  |
Krishna Raju
Messages: 1
Registered: October 2002
|
Junior Member |
|
|
Hi ,
I was executing this query to find out the entity relationships in my
database (key columns mapping) .The Server is : Oracle8i 8.1.7 on linux.
SQL>
select master.table_name "MASTER TABLE",master.constraint_name "PRIMARY KEY",
child.table_name "CHILD_TABLE" , child.constraint_name "FOREIGN KEY" ,
mast_col.column_name "PK COLUMN",child_col.column_name "FK COLUMN"
from
dba_constraints master ,
dba_constraints child ,
dba_cons_columns mast_col ,
dba_cons_columns child_col
where
master.constraint_name = child.r_constraint_name and
master.constraint_name = mast_col.constraint_name and
child.constraint_name = child_col.constraint_name and
master.owner = 'SAGI' ;
I re-executed this query and got these errors.
1. ORA-12571 : Packet writer failure . (i looked up the oracle error
manual and found out this is due to DBWR process. the explanation was brief,
and then after certain more tries to fetch data , i got the unix error
2. ORA-27101 - Shared memory realm does not exist.
after these errors , the database went down. i tried to shutdown the instance
and the database, svrmgrl said that database is not open , but the instance
was stopped and when i started up the db , i got an error again saying
3. ORA-01033 - Oracle initialization or shutdown in progress' .
and i could not startup the database.
Please try to resolve this problem ASAP as the database availability is 24/7
and downtime is very costly to us.
in anticipation, truly,
Krishna
Oracle DBA , Packetware INDIA Pvt. Ltd.
email : prasad@packetware.com , sagikrishna@yahoo.com
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
