PROBLEM WHEN CONNECTING TO ORACLE DB

[Kamarudin Tik]

I have created a normal oracle unix user e.g orauser instead using oracle unix id.
I have copied the oracle .profile to the orauser.
But i have this error in which ORACLE still not sure what is the problem?

This is the error when trying to connect to the database:

$ sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Mar 27 11:30:06 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> connect eltprod/eltpca01
ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
HPUX-ia64 Error: 22: Invalid argument
Additional information: 1
Additional information: 3604487


FOR THEM TO SOLVE THE PROBLEM, the need "truss" tools as per below command:

We need to trace the connection here.
Do the below given action plan & upload the 'mytruss' trace file in SR.

truss -o /tmp/mytruss sqlplus /nolog


I have check with OS vendors but they are not sure whether "truss" tool is there.

Any solution guys??

[Robert-Jan Goossens_1]

Hi,

Tusc/truss can be downloaded from

http://hpux.cs.utah.edu/hppd/hpux/Sysadmin/tusc-7.8/

Regards,
Robert-Jan

[Hein van den Heuvel]

Kamarudin,

The DB is up and operational when you connect trhough the original oracle user name right?

And you can probably also connect through the listener instead of BEQ protocol right?
#sqlplus /nolog eltprod/eltpca01@elt...

This is a fairly common error condition when creating new users caused by incorrect protection/security settings.

Check google: +oracle +27123 +user

You might need 'setuid' or umask 022 or such.

hth,
Hein van den Heuvel
HvdH Performance Consulting

[Kamarudin Tik]

Dear Robert,

Thanks for the download site.

I will ask my OS vendors to install the said patch.

[Kamarudin Tik]

Hi Hein,

I have set the setuid to 022 already for the profile of the oracle user.
But it still giving error.

I have check on google for the error in which this particular problem is still not resolve eventhough i have run changePerm.sh scripts from Oracle binary.

Do you suggest anything else for me?

[Wachyu Danyanto · Accepted solution]

Hi Kamarudin,

It seems the error usually be related to shmmax size in the kernel or could be in the binary of oracle.

Try to set good size shmmax in the kernel and reboot.

or

Set sticky bit for oracle binary.
Do the following as owner of the oracle software:
chmod 6755 $ORACLE_HOME/bin/oracle

Usually that two things above will get rid of the error.


Regards,
Danyanto

[Hein van den Heuvel]

Please confirm that the database is up and running and useable from the orginal account.
If it is, then you can stop worrying about shmmax and other kernel parameters.
Also consider the the TSNlistener test/method.

Hein.

[Kamarudin Tik]

I have copied your recommendation and suggestion to my Oracle Support. I will close this thread after i have solve the problem guys....thanks for your fast feedback guys

[SANTOSH S. MHASKAR]

Hi ,

have u seen and noted the ORA errors
ORA-01034 & ORA-27123

------------------------------------------------
$oerr ora 1034
01034, 00000, "ORACLE not available"
// *Cause: Oracle was not started up. Possible causes include the following:
// - The SGA requires more space than was allocated for it.
// - The operating-system variable pointing to the instance is
// improperly defined.
// *Action: Refer to accompanying messages for possible causes and correct
// the problem mentioned in the other messages.
// If Oracle has been initialized, then on some operating systems,
// verify that Oracle was linked correctly. See the platform
// specific Oracle documentation.


and


$oerr ora 27123
27123, 00000, "unable to attach to shared memory segment"
// *Cause: shmat() call failed
// *Action: check permissions on segment, contact Oracle support


------------------------------

Check if the database is in UP state

-Santosh

[SANTOSH S. MHASKAR]

Also check whether ORACLE_SID is properly set.