oracle-l  

RE: sysresv doesn't work on AIX

M Rafiq
Thu, 27 Mar 2003 10:11:54 -0800

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: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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,

- Kirti


-----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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 03/26/2003 12:33 PM
 Please respond to ORACLE-L


        To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).