From: sstefick (sstefick@HARPER.CC.IL.US)
Date: Sat Nov 16 2002 - 10:04:19 EST
What oracle version are you on?
Try running the oraenv script (as the Oracle user),
then try:
$ svrmgrl
svrmgr> connect internal
svrmgr> startup pfile=/path/to/your/initSID.ora
*******************************
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>
=====
>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