| How to start Oracle on AIX 4.1 ??? [message #56995] |
Mon, 12 May 2003 22:35  |
tommy
Messages: 22
Registered: July 2000
|
Junior Member |
|
|
I got 2 error messages when I login to AIX with Sun Account System as below :
ORA-01034: ORACLE not available
ORA-07429: smsgsg: shmget() failed to
Does anyone can help me to solve this problem ?
Thanks and regards,
Tommy
|
|
|
|
| Re: How to start Oracle on AIX 4.1 ??? [message #56996 is a reply to message #56995] |
Tue, 13 May 2003 02:05  |
psmyth
Messages: 81
Registered: October 2002
|
Member |
|
|
could be out of semaphores.... but I found this on Metalink...
Note:20478.1
Subject: OERR: ORA 7429 "smsgsg: shmget() failed to get segment."
Type: REFERENCE
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 02-MAR-1995
Last Revision Date: 10-JUN-1999
Error: ORA 7429 Text: smsgsg: shmget() failed to get segment. -------------------------------------------------------------------------------
Cause: a shared memory segment used for all part of the SGA could not be retrieved.
Action: Use the system error number in the error message to determine why the segment could not be retrieved. If it does not exists, shutdown the database using the "abort" option, and then restart it.
If the get failed because the permissions are incorrect, make sure that the ownership of the oracle executable is the same as that on the shared memory segment.
*** Important: The notes below are for experienced users - See [[NOTE:22080.1]]
Explanation:
This is typically reported when a user tries to connect to a database but either the database is NOT running or the user has their environment set up incorrectly.
Diagnosis:
- Is the database actually running ?
- Is the connection attempt local or to a remote database ?
Local:
- Check ORACLE_HOME and ORACLE_SID are correct:
env | grep ORACLE
The ORACLE_SID is case sensitive and MUST match the instance ORACLE_SID.
- Check ORACLE_HOME and the ORACLE_SID thus:
cd $ORACLE_HOME/dbs
ls -l sgadef$ORACLE_SID.*
If the 'cd' fails ORACLE_HOME is incorrect.
If the 'ls' shows no files then either the database is not running OR ORACLE_SID is wrong.
- Check the Operating System error number after the ORA 7429 message.
Error 2 Is typically wrong ORACLE_SID or ORACLE_HOME
Error 13 Is typically incorrect permissions on the 'oracle' executable. As the Oracle user ensure the permissions are correct thus:
cd $ORACLE_HOME/bin
chmod 4755 oracle
If the database is started as 'root' and the permissions are wrong you need to:
Shutdown the database as root
Change the permissions as above
Restart the database
TCP/IP:
- For SQL*Net V1 over TCP/IP ensure that the ORACLE_HOME in the oratab file (/etc/oratab or /var/opt/oracle/oratab)is EXACTLY correct for the instance.
- For SQL*Net V2 over TCP/IP ensure that the ORACLE_HOME in the listener.ora file is EXACTLY correct for the instance.
This file should be in one of:
/etc/listener.ora
$TNS_ADMIN/listener.ora
/var/opt/oracle/listener.ora
or $ORACLE_HOME/network/admin/listener.ora
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
