OraFAQ Forum: Server Administration » ORA-01034, ORA-07429 error, but tnsping is ok

Home » RDBMS Server » Server Administration » ORA-01034, ORA-07429 error, but tnsping is ok

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01034, ORA-07429 error, but tnsping is ok [message #53746]

Wed, 09 October 2002 07:12

Money.Qian
Messages: 2
Registered: October 2002

Junior Member

Oracle 7.3.4
OS: Digital Unix 4.0f

I can successfully connect with "sqlplus system/manager" on unix server and retrieve data from database.
But failed when connect with "sqlplus system/manager@asmc" on both unix server and client. The error is: "ORA-01034: Oracle is not available." and "ORA-07429: smsgsg: shmget() failed to get segment". ("asmc" is the database alias. )
On client(Windows 2k Professional English Version) and server "tnsping asmc" is ok.
On server, no obvious error message in alert.log and no file exists in directory "USER_DUMP_DEST". It seems oracle instance has started up!

Can anybody give me some idea to solve the problem?

Report message to a moderator

Re: ORA-01034, ORA-07429 error, but tnsping is ok [message #53747 is a reply to message #53746]

Wed, 09 October 2002 07:38

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1. Make sure u use a physical path, not the symbolic
   link, for ORACLE_HOME in the  "listener.ora". 
   else, change it and try again
2. just issue shutdown abort (make sure u have backup)
   try again.
3. is there anything like
UNIX Error: 2: No such file or directory  ??

Report message to a moderator

Re: ORA-01034, ORA-07429 error, but tnsping is ok [message #53750 is a reply to message #53746]

Wed, 09 October 2002 08:31

Money.Qian
Messages: 2
Registered: October 2002

Junior Member

Execuse me, can you give me detail?
1. Do you mean check 'read' and 'execute' permission of all files and directories under $ORACLE_HOME?
2. Do you mean check 'read' and 'execute' permission of all file under $ORACLE_HOME/lib?

Thanks.

Report message to a moderator

Previous Topic:	Re: what is difference............
Next Topic:	Oracle 9i Traning (Tuning, DBA) ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 14:18:40 CDT 2024