- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- PROBLEM WHEN CONNECTING TO ORACLE DB
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2007 12:27 AM
тАО03-31-2007 12:27 AM
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??
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2007 12:37 AM
тАО03-31-2007 12:37 AM
Re: PROBLEM WHEN CONNECTING TO ORACLE DB
Tusc/truss can be downloaded from
http://hpux.cs.utah.edu/hppd/hpux/Sysadmin/tusc-7.8/
Regards,
Robert-Jan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2007 03:43 AM
тАО03-31-2007 03:43 AM
Re: PROBLEM WHEN CONNECTING TO ORACLE DB
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2007 08:45 PM
тАО03-31-2007 08:45 PM
Re: PROBLEM WHEN CONNECTING TO ORACLE DB
Thanks for the download site.
I will ask my OS vendors to install the said patch.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2007 08:52 PM
тАО03-31-2007 08:52 PM
Re: PROBLEM WHEN CONNECTING TO ORACLE DB
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2007 05:07 AM
тАО04-01-2007 05:07 AM
SolutionHi 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2007 06:40 AM
тАО04-01-2007 06:40 AM
Re: PROBLEM WHEN CONNECTING TO ORACLE DB
If it is, then you can stop worrying about shmmax and other kernel parameters.
Also consider the the TSNlistener test/method.
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2007 06:28 PM
тАО04-01-2007 06:28 PM
Re: PROBLEM WHEN CONNECTING TO ORACLE DB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2007 06:33 PM
тАО04-01-2007 06:33 PM
Re: PROBLEM WHEN CONNECTING TO ORACLE DB
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2007 06:35 PM
тАО04-01-2007 06:35 PM