ORACLE10G [ORA-01034: ORACLE not available & ORA-27121]

[Ankit Grover]

Hi all:

Finally, I was able to download the Oracle10g client installation and install the procob compilers on my server.

But the problems does not seem to be coming to an end. After the installation, I am not able to login to Oracle10g DB if the OS user is other than Oracle.

While I am able to login to ODB as sysdba as well as normal user if my OS user is Oracle, I am not able to login through any user in case I try through any other OS user.

SYSDBA option give following error:

/home/fnsonlx3>sqlplus sys as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Mon May 7 15:56:54 2007
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter password:
ERROR:
ORA-09925: Unable to create audit trail file

In case of normal user, the error is:

/home/fnsonlx3>sqlplus fnsonlx3/password

SQL*Plus: Release 10.2.0.2.0 - Production on Mon May 7 17:24:13 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
HPUX-ia64 Error: 13: Permission denied


One more thing, I am able to login through other servers also by using connection identifier:
/home/fnsonln1>sqlplus fnsonln1/fnsonln1@rcbo10g

Looks like the case of OS file permissions again. But not sure about the files on which permissions is required to be given to other users.

Regards,
Ankit

[Steven E. Protter]

Shalom,

You say you have downloaded and installed th latest Oracle CLIENT.

Where is the database server you are trying to connect to. If its local, you need the database server. If its remote you need to correctly configure tnsnames.ora (and perhaps other config files) to connect to the remote database.

SEP

[Ankit Grover]

SEP,

Sorry for creating the confusion. Actually this new thread is a continuation of this:
https://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1121357

The Oracle10g database is working fine though oracle OS user. Also, its accessible through remote server.

The problem is coming in case I try to access it locally through any OS user which is not part of DBA group.

[Peter Godron · Accepted solution]

Ankit,
what is the permission on the $ORACLE_HOME/bin dir ?
My suggestion would be :
-rwsr-s--x 1 oracle dba

Although for Tru64, please see thread:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=705859

[Ankit Grover]

Thanks a zillion Peter.
I don't knwo how to thanks you. I was stuck in this problem for so many days. Someone from my team while fixing the problem have done chmod 755 at mant places.

Hence, oracle file was having 755 permissions. Now I have made it "-rwsr-s--x" and its working fine.

Thanks a lot dear.
Ankit

[Ankit Grover]

Peter,
Can you suggest some reading on this "S" permission on file? I mean whats really sticky bits.

[Yogeeraj_1]

hi Ankit,

the best and complete documentation that i have come across so far is found at:
http://en.wikipedia.org/wiki/Chmod

hope this helps!

kind regards
yogeeraj

[Kamarudin Tik]

how to set the permission of the sticky bit?
i am having the same problem

[Dennis Handly]

>Kamarudin: how to set the permission of the sticky bit?

I assume you want to set the setuid or setgid bit? What do you not understand on that link?
http://en.wikipedia.org/wiki/Chmod#Special_modes