topic Re: weird problem with svrmgrl in Operating System - HP-UX

weird problem with svrmgrl

Kirill Cherkashin — Thu, 23 Jan 2003 09:58:09 GMT

Hi,

we have 8i DB on A-server(1CPU,512Mb). When I tried to connect to DB by svrmgrl as user oracle everything is fine. But any unix user even from dba group got the ORA-03113 error.Kernel settings were set according oracle's metalink recomendations. But problem persists.Any idea what is going on?

Kirill
p.s. sqlplus is working fine for any user.

Re: weird problem with svrmgrl

Steve Steel — Thu, 23 Jan 2003 10:20:01 GMT

Hi

Saw something similar once.

Try to disable the memory windows configuration, just replace the
/etc/services.window file with a default one.

Then try again. I believe Oracle can better help you.

Steve Steel

Re: weird problem with svrmgrl

Tom Geudens — Thu, 23 Jan 2003 10:28:58 GMT

Hi,
Sorry for stating the obvious, but did you indicate "dba" as the SYSDBA group during the oracle installation ? If not, your executable is not linked with the right group and svrmgrl will only work for oracle ...

Regards,
Tom

Re: weird problem with svrmgrl

Kirill Cherkashin — Thu, 23 Jan 2003 10:41:34 GMT

we use default /etc/services.window. No changes has been made.

Re: weird problem with svrmgrl

John Palmer — Thu, 23 Jan 2003 10:54:30 GMT

Hi,

Is the Oracle environment set-up the same as oracle when you log in to one of the other users?

Regards,
John

Re: weird problem with svrmgrl

Ian Dennison_1 — Thu, 23 Jan 2003 11:43:34 GMT

-rwsr-s--x 1 root dba 9605120 Aug 21 2001 dbsnmp
-rwsr-s--x 1 oracle8i dba 8200192 Aug 21 2001 oemevent
-rwsr-s--x 1 oracle8i dba 30769152 Aug 21 2001 oracle
-rwsr-s--x 1 root dba 9625600 Aug 21 2001 oratclsh
-rwsr-s--x 1 oracle8i dba 7876608 Aug 21 2001 tnslsnr

Check your sticky bits are set on $ORACLE_HOME/bin, the above file list shows an 817 install.

This usually occurs when people try to upgrade Oracle by copying files rather than using the installer.

Share and Enjoy! Ian

Re: weird problem with svrmgrl

T G Manikandan — Thu, 23 Jan 2003 11:53:47 GMT

The problem should definitely be with the shared memory and semaphore parameters in the kernel.

What are the values of

SEMMNI
SEMMNS
SHMMAX

Revert

Re: weird problem with svrmgrl

Kirill Cherkashin — Thu, 23 Jan 2003 13:49:06 GMT

Thanks Ian,
I really just moved oracle intstallation from another machine to this one. ;-)
Anyway,I forgot to mention. This weird behevior of svrmgrl happened only with one DB and at the same time I have no problem with another two Oracle DB.

Kirill

Re: weird problem with svrmgrl

Brian Crabtree — Thu, 23 Jan 2003 21:41:28 GMT

This will take some work. Most likely, you have a shared memory segment that is hung. This can happen when you do not have a high emough kernel parameter for shmmax or maxdsiz(_64bit). The easiest way is to bring the other databases down, then run "ipcs" and look for memory segments and semaphores owned by "oracle" (or whatever user owns your installation). THen remove the ones left with the "ipcrm" command.

The other way, you have to login to each database, and run "oradebug". This will create a trace file in the userdump destination. Look through the file for the semaphore and memory segments for each database that is running, and then remove any of the segments that are not in the trace files using ipcs and ipcrm.

Hope this helps,

Brian