| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: sysresv doesn't work on AIX
One thing I shall add. I tested it on a machine with different databases on
HP-UX 11 under different Oracle version. Here Oracle is owner of all Oracle
versions.
Under 7.3.4.5 is is not working as that utility belongs to 8i.
Even under 8i it will check for only those databases which have same version like 8.1.6.2 or 8.1.7.4 meaning if you run it from 8.1.6.2 it will check only those databases pointing to that home or created with that version. Likewise 9i databases will be checked by sysresv of that version.
However, I shall still prefer ipcs -mb command to check it in one go for all databases as we DBA must know SGA sizes of our all databases on a machine and remove it accordingly.
Regards
Rafiq
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Thu, 27 Mar 2003 08:18:48 -0800
Interesting...
It works for me on AIX
oracle rs015 [DBMP]: oslevel
4.3.3.0
oracle rs015 [DBMP]: sysresv -l DBMP DBCP
IPC Resources for ORACLE_SID "DBMP" :
Shared Memory:
ID KEY 262150 0x566bfa00
IPC Resources for ORACLE_SID "DBCP" :
Shared Memory:
ID KEY 7 0xa086ab38
But if I tried a non-existent SID name:
oracle rs015 [DBMP]: sysresv -l junk
IPC Resources for ORACLE_SID "junk" :
Shared Memory
ID KEY
No shared memory segments used
Oracle Instance not alive for sid "junk"
HTH,
-----Original Message-----
Sent: Thursday, March 27, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L
I was logged in as oracle, owner of the shared segments.
Peter Schauss
-----Original Message-----
Sent: Wednesday, March 26, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
Login as the owner of the shared mem segments and run it.
It just worked for me on RH 7.2 with 8.1.7
Jared
"Schauss, Peter" <pschauss_at_northropgrumman.com>
Sent by: root_at_fatcity.com
03/26/2003 12:33 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: sysresv doesn't work on AIX
Poking around metalink I found a reference to a utility called sysresv (note 123322.1). According to the document it displays the id and key for each for the shared memory segments which the Oracle instances have created.
I tried it on an AIX 4.3 system running three Oracle instances and it does not work.
Example:
# sysresv -l vdev delmia ngcdev
IPC Resources for ORACLE_SID "vdev" :
Shared Memory
ID KEY
No shared memory segments used
Oracle Instance not alive for sid "vdev"
IPC Resources for ORACLE_SID "delmia" :
Shared Memory
ID KEY
No shared memory segments used
Oracle Instance not alive for sid "delmia"
IPC Resources for ORACLE_SID "ngcdev" :
Shared Memory
ID KEY
No shared memory segments used
Oracle Instance not alive for sid "ngcdev"
If I do Aipcs -m | grep oracle
I get:
m 1179648 0xf50105e0 --rw-r----- oracle oinstall m 1179649 0xfa5fbc28 --rw-r----- oracle oinstall m 2 0x02da4bbc --rw-r----- oracle oinstall
Anyone else have similar experiences?
Thanks,
Peter Schauss
Northrop Grumman Corporation
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: kirti.deshpande_at_verizon.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Mar 27 2003 - 11:48:36 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: rafiq9857_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |