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
I did some testing with this on HP-UX 11.00 and 11.11. What appears to
matter is the userid, should be the owner of the the shmem seg. For
instance I have a machine with multiple instances. Some are owned by
oraa and the others are owned by orab. These databases have different
Oracle homes.
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
My ORACLE_SIDs are lower case. Does that make a difference.
bvdesi02 # oslevel
4.3.2.0
bvdesi02 # sysresv -l vdev
IPC Resources for ORACLE_SID vdev :
Shared Memory
ID KEY
No shared memory segments used
Oracle Instance not alive for sid vdev
Peter Schauss
-Original
No, it should not matter.
Are you signed on as 'oracle' ?
I see the prompt is: # (typically for root).
- Kirti
-Original Message-
Sent: Thursday, March 27, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L
My ORACLE_SIDs are lower case. Does that make a difference.
bvdesi02
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]
Hi peter,
you need to use sysresv with oracle user.
Is it what you do ?
HTH
At 12:33 26/03/2003 -0800, you wrote:
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