| Re: ORA-01092: Oracle instance terminated. Disconnection forced. error [message #52191] |
Mon, 08 July 2002 06:22 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
You need to look on the server where the database is located. With 8i you should have a directory called ORACLE_HOMErdbmsaudit in there you will have trace files ".trc" that give you shutdown times and the command used to shut them down. Did you look at the SID_alert.log file? Is is also on the server in the background_dump_dest directory. You will also want to look for "*.trc" on the server from the ORACLE_HOME directory and down. Also look at all scheduled tasks for jobs that may be doing the shutdown and check all users in the DBA group (connect internal from DOS prompt) or any users with DBA privs and verify that they aren't taking it down.
Run this query to see who has DBA:
select * from dba_role_privs where granted_role='DBA';
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
