Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

PROBLEM WHEN CONNECTING TO ORACLE DB

SOLVED
Go to solution
Kamarudin Tik
Occasional Advisor

PROBLEM WHEN CONNECTING TO ORACLE DB

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??

15 REPLIES
Robert-Jan Goossens_1
Honored Contributor

Re: PROBLEM WHEN CONNECTING TO ORACLE DB

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
Honored Contributor

Re: PROBLEM WHEN CONNECTING TO ORACLE DB

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
Occasional Advisor

Re: PROBLEM WHEN CONNECTING TO ORACLE DB

Dear Robert,

Thanks for the download site.

I will ask my OS vendors to install the said patch.
Kamarudin Tik
Occasional Advisor

Re: PROBLEM WHEN CONNECTING TO ORACLE DB

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?
Solution

Re: PROBLEM WHEN CONNECTING TO ORACLE DB


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
Honored Contributor

Re: PROBLEM WHEN CONNECTING TO ORACLE DB

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
Occasional Advisor

Re: PROBLEM WHEN CONNECTING TO ORACLE DB

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
Trusted Contributor

Re: PROBLEM WHEN CONNECTING TO ORACLE DB

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
Trusted Contributor

Re: PROBLEM WHEN CONNECTING TO ORACLE DB

Also check whether ORACLE_SID is properly set.
Kamarudin Tik
Occasional Advisor

Re: PROBLEM WHEN CONNECTING TO ORACLE DB

Dear Wachyu Danyanto,

your solution resolve the problem.

Thank you very much.......

i appreciate it.....
Kamarudin Tik
Occasional Advisor

Re: PROBLEM WHEN CONNECTING TO ORACLE DB

as per recommendation from Wachyu Danyanto.

Re: PROBLEM WHEN CONNECTING TO ORACLE DB


Dear Kamarudin Tik,

Glad to hear that your problem has solved.

Don't forget to assign the point to each member that have helped you to solve your problem.

Thank you.

Regards,
Wachyu Danyanto
Hein van den Heuvel
Honored Contributor

Re: PROBLEM WHEN CONNECTING TO ORACLE DB

Kamarudin,

Thanks for the feedback already?
However WHICH solution provided solved it?
The shmmmax suggestion or the chmod?

(for the setuid like I indicated earlier).
Just curious, and trying to help future readers of this posting.

Regards,
Hein.

Re: PROBLEM WHEN CONNECTING TO ORACLE DB


Kamarudin,

Please read:
http://forums1.itrc.hp.com/service/forums/helptips.do?#33 on how to reward any useful answers given to your questions on each member.


Hein,

I believe that chmod command that solve Kamarudin problem.


Regards,
Wachyu Danyanto
Kamarudin Tik
Occasional Advisor

Re: PROBLEM WHEN CONNECTING TO ORACLE DB

chmod solve the whole problem...thank guys