Re: No shared memory segment for the instance

"Christian" <cgregoir99_at_yahoo.com> wrote in message news:be18vc$62r$1_at_reader1.imaginet.fr...
> Hello,
>
> I thought that when an instance is running, there should be a shared
memory
> segment created. But that's not the case here.
> Why is it so ? The application generating the oracleORCL processes uses
OCI
> version 7.
>
> Christian
>
> RedHat/Linux 2.4.20
> Oracle 8.0.5
>
> cilink : black - ~> ipcs -m
> ------ Shared memory segments --------
> key shmid owner perms bytes nattch status
> 0x33445547 0 root 777 132004 28
>
> cilink : black - ~> ps auxw | grep ora
> root 1822 0:02 /oracle/app/oracle/product/8.0.5/bin/tnslsnr
> LISTENER -inherit
> oracle 7936 0:00 ora_pmon_ORCL
> oracle 7938 0:01 ora_dbw0_ORCL
> oracle 7940 0:00 ora_arch_ORCL
> oracle 7942 0:00 ora_lgwr_ORCL
> oracle 7944 0:00 ora_ckpt_ORCL
> oracle 7946 0:00 ora_smon_ORCL
> oracle 7948 0:00 ora_reco_ORCL
> oracle 9939 0:00 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 9966 0:15 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 10078 0:00 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 10107 0:06 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 10137 0:04 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 10306 0:00 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 10368 0:01 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 10372 0:00 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 10531 0:00 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 10654 0:01 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 10704 0:00 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 10760 0:11 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 11235 0:06 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 11967 0:04 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 13577 0:07 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 13654 0:01 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 13756 0:00 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 13889 0:00 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 13891 0:00 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 13915 0:00 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 15057 0:03 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 15263 0:00 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 15815 0:00 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 15997 0:00 oracleORCL
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> oracle 16012 0:00 oracleORCL (LOCAL=NO)
>
>

Following Fred Denis' advice, i ran ipcs with id root, and indeed, the shared memory segment dedicated to Oracle appeared.

Thanks.

Christian Received on Fri Jul 04 2003 - 03:48:49 CDT