From: sstefick (sstefick@HARPER.CC.IL.US)
Date: Sat Nov 16 2002 - 09:13:30 EST
Holger,
If this is what I'm thinking,
Do a ps -ef | grep -i yourOracleSID
This will show you the Oracle processes that may still be running. If so, you
have to manually kill them and try to log in again.
I hope this helps.
*******************************
Scott Stefick
UNIX Systems Administrator
Oracle Certified DBA
Wm. Rainey Harper College
Palatine, IL. 60067
847-925-6130
*******************************
>===== Original Message From IBM AIX Discussion List <aix-l@Princeton.EDU>
=====
>Hello,
>
>I
>
>1) shutdown an oracle-db
>2) backed up all files
>3) recreate fs (striped now)
>4) restored everything.
>
>There a 2 db there, one works, on the other I get:
>
>SQL*Plus: Release 8.0.5.0.0 - Production on Fri Nov 15 21:6:42 2002
>
>(c) Copyright 1998 Oracle Corporation. All rights reserved.
>
>Enter user-name: trp@pfmsr.swisscom.com
>Enter password:
>ERROR:
>ORA-01034: ORACLE not available
>ORA-27101: shared memory realm does not exist
>IBM AIX RISC System/6000 Error: 2: No such file or directory
>
>
>How can I tell which "file or directory" does not exist? How can I find
>out? Tracing the listener?
>tnsping works, the listener itself is up.
>
>I checked permissions on every file, no problem there.
>ipcs also shows no segments after shutting down the db.
>
>In oracle-log I see
>
>ORA-00600: internal error code, arguments: [17585], [33554445],
>[271162576], [], [], [], [], []
>
>very meaningful.
>
>Any hint?
>
>Regards,
>
>Holger
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:20 EDT