topic Re: ORACLE10G [ORA-01034: ORACLE not available & ORA-27121] in Operating System - HP-UX

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

Ankit Grover — Mon, 07 May 2007 07:24:04 GMT

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

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

Steven E. Protter — Mon, 07 May 2007 08:47:38 GMT

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

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

Ankit Grover — Mon, 07 May 2007 23:47:44 GMT

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.

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

Peter Godron — Tue, 08 May 2007 02:46:03 GMT

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

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

Ankit Grover — Tue, 08 May 2007 06:32:02 GMT

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

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

Ankit Grover — Tue, 08 May 2007 06:34:40 GMT

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

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

Yogeeraj_1 — Tue, 08 May 2007 08:16:36 GMT

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

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

Kamarudin Tik — Tue, 25 Sep 2007 04:42:11 GMT

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

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

Dennis Handly — Tue, 25 Sep 2007 05:38:40 GMT

>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