From: Holger.VanKoll@SWISSCOM.COM
Date: Sat Nov 16 2002 - 09:37:51 EST
well, when the db is up I see such procs
after shutting down, I see none, after restarting I see them again
so that means the db shuts down and starts correctly?
-----Original Message-----
From: sstefick [mailto:sstefick@HARPER.CC.IL.US]
Sent: Saturday, November 16, 2002 3:14 PM
To: aix-l@Princeton.EDU
Subject: Re: oracle (?) problem
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