Skip to main content

Checking the ipckey value

This following explains how to check ipckey in the environment where multiple databases are installed on a server.

Use the KEY value of Shared Memory: that is output on the console by executing the sysresv command. Before executing the sysresv command, set the Oracle connection environment variables to enable the Oracle to be monitored.

You must also set the Oracle connection environment variables in the environment where the monitoring agent is run. Because the OCI library is called, the setting for LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH is also required.

Depending on the Oracle version, the location where the KEY value of Shared Memory: is output on the console may differ.

BASH
oracle@localhost:ORA10:/home/oracle/products/10.2.0.2>sysresv

IPC Resources for ORACLE_SID "ORA10" :
Shared Memory:
ID              KEY
3276807         0xebd3a364			<------------- 0xebd3a364
Semaphores:
ID              KEY
131073          0x76138448
163842          0x76138449
196611          0x7613844a
229380          0x7613844b
262149          0x7613844c
294918          0x7613844d
327687          0x7613844e
360456          0x7613844f
393225          0x76138450
Oracle Instance alive for sid "ORA10"