Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
Ankit Grover
Frequent Advisor

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

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
8 REPLIES
Steven E. Protter
Exalted Contributor

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

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Ankit Grover
Frequent Advisor

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

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
Honored Contributor
Solution

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

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
Frequent Advisor

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

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
Frequent Advisor

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

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

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

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Kamarudin Tik
Occasional Advisor

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

how to set the permission of the sticky bit?
i am having the same problem
Dennis Handly
Acclaimed Contributor

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

>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