ORA-01034: ORACLE not available
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



ORA-01034: ORACLE not available Expand / Collapse
Message
Posted 4/23/2009 10:23:20 AM Post #115
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
Hi,

I am getting the following ora error message when using sqlplus to login to oracle.   I am logged in as my own unix account and not oracle.

gguser@prodhost:/u01/home/gguser > sqlplus ggadmin


SQL*Plus: Release 9.2.0.4.0 - Production on Wed Apr 18 13:23:00 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Error: 13: Permission denied

 

Here is the solution to this ora error message:

#  cd $ORACLE_HOME/bin

#  ls -ltr oracle

-rwxr-xrwx 1 oracle dba 74053740 Sep 04 2003 oracle

The file permissions for "oracle" executable should be "-rwsr-s--x",  so that others can access the oracle environment from the same host.

You need to shutdown the oracle database and then issue the command:

cd $ORACLE_HOME/bin

chmod 6751 oracle
ls -lr oracle

rwsr-s--x 1 oracle dba 74053740 Sep 04 2003 oracle

After you do this, startup the oracle database and then try to connect .   This should have resolved the issue.

 

Hope this helps.

« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 10:23am

Powered By InstantForum.NET v4.1.4 © 2012
Execution: 0.068. 10 queries. Compression Disabled.
Contextual Links