Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: sysresv doesn't work on AIX

RE: sysresv doesn't work on AIX

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Thu, 27 Mar 2003 09:48:36 -0800
Message-ID: <F001.00574675.20030327094836@fatcity.com>


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

Oracle Instance alive for sid "DBMP"

IPC Resources for ORACLE_SID "DBCP" :
Shared Memory:

ID              KEY
7               0xa086ab38

Oracle Instance alive for sid "DBCP"

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-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). _________________________________________________________________ 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).
Received on Thu Mar 27 2003 - 11:48:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US