OraFAQ Forum: Server Administration » ORA-01034: ORACLE not available (some users only)

Home » RDBMS Server » Server Administration » ORA-01034: ORACLE not available (some users only) (Oracle 8.1.6.3, Solaris 8)

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

ORA-01034: ORACLE not available (some users only) [message #610313]

Wed, 19 March 2014 06:39

lmontejo
Messages: 9
Registered: March 2014

Junior Member

Hi,
I know I'n runnig a very old version, but i'ts the client choice.
I'm getting ORA-01034 error when trying to connect locally to the DB with some unix users, but it works with others.

eoc@zpecas:>sqlplus energia3/energia@zpecas

SQL*Plus: Release 8.1.6.0.0 - Production on Mi� Mar 19 12:40:39 2014

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Conectado a:
Oracle8i Release 8.1.6.3.0 - Production
JServer Release 8.1.6.3.0 - Production

SQL>
eoc@zpecas:>sqlplus energia3/energia

SQL*Plus: Release 8.1.6.0.0 - Production on Mi� Mar 19 12:41:12 2014

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

ERROR:
ORA-01034: ORACLE not available

eoc@zpecas:>su - oracle
Password:
zpecas:oracle> sqlplus energia3/energia

SQL*Plus: Release 8.1.6.0.0 - Production on Wed Mar 19 12:43:35 2014

(c) Copyright 1999 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Release 8.1.6.3.0 - Production
JServer Release 8.1.6.3.0 - Production

Environment is the same in both cases.
Any idea?
Thanks in advance.

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610314 is a reply to message #610313]

Wed, 19 March 2014 06:43

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Doesnt look like your environment variables are set properly in the second example. First one is over sql*net, third one is the oracle user which is presumable set correctly.

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610318 is a reply to message #610314]

Wed, 19 March 2014 07:17

lmontejo
Messages: 9
Registered: March 2014

Junior Member

Both users have the same environmet:

eoc@zpecas:>env | grep ORA
ORACLE_PATH=/users/oracle/bin
ORACLE_SID=orac
ORACLE_HOME=/users/oracle
zpecas:oracle> env | grep ORA
ORACLE_PATH=/users/oracle/bin
ORACLE_SID=orac
ORACLE_HOME=/users/oracle

They have also the same PATH and LD_LIBRARY_PATH
This is why I'm very confused.

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610325 is a reply to message #610318]

Wed, 19 March 2014 07:31

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

Why is the SID different to the one specified in the first sqlplus call?

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610328 is a reply to message #610325]

Wed, 19 March 2014 07:35

lmontejo
Messages: 9
Registered: March 2014

Junior Member

It's not the SID, but the entry at tnsnames.ora:

zpecas =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = zpecas)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = orac)
    )
  )

This is to show you that net connections works with the user that cannot connect locally

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610345 is a reply to message #610328]

Wed, 19 March 2014 08:37

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post the result of: uname -a

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610346 is a reply to message #610345]

Wed, 19 March 2014 08:39

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And also: tnsping zpecas

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610347 is a reply to message #610346]

Wed, 19 March 2014 08:44

lmontejo
Messages: 9
Registered: March 2014

Junior Member

I'm running Oracle8 on a solaris 8 branded zone. The host is running solaris 10.
I have another zone with the same scenario working correctly.

eoc@zpecas:/CC/ctrl_soc.dir>tnsping zpecas

TNS Ping Utility for Solaris: Version 8.1.6.3.0 - Production on 19-MAR-2014 14:46:44

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=zpecas)(PORT=1521))
Realizado correctamente (30 mseg)
eoc@zpecas:/CC/ctrl_soc.dir>uname -a
SunOS zpecas 5.8 Generic_Virtual sun4u sparc SUNW,Sun-Fire-V245

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610349 is a reply to message #610347]

Wed, 19 March 2014 08:46

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I'm running Oracle8 on a solaris 8 branded zone.

Your session and the database are in the same zone, aren't they?

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610350 is a reply to message #610349]

Wed, 19 March 2014 08:47

lmontejo
Messages: 9
Registered: March 2014

Junior Member

Yes

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610354 is a reply to message #610350]

Wed, 19 March 2014 09:26

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Ah! I didn't see you could do it with OS user oracle (which is I think the owner the binaries or at least the owner of the instance, the one that starts it).
I think this a (OS) permission issue on Oracle directories/libraries/binaries. check the differences between this zone and one that works.

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610356 is a reply to message #610354]

Wed, 19 March 2014 09:29

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And check your (the account you are connected with) groups in both environments (and possibly permissions of these groups).

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610362 is a reply to message #610356]

Wed, 19 March 2014 10:00

lmontejo
Messages: 9
Registered: March 2014

Junior Member

They are the same (permissions and group)
In fact, both zones are created from an image of an existing Solaris 8 machine.
This is why I'm so confused. Environments, users, groups are the same. And DB is the same also.
I've tried to restart both the database and the zone with no result.

eoc@zpecas:>id
uid=201(eoc) gid=21(soc)
eoc@zpecas:>groups
soc dba
zpecas:oracle> id
uid=204(oracle) gid=201(dba)
zpecas:oracle> groups
dba

Oracle user is the owner of teh binaries and the instance, but it's the same in the zone that works.

[Updated on: Wed, 19 March 2014 10:03]

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610365 is a reply to message #610362]

Wed, 19 March 2014 10:32

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I'm quite out of idea now.
What happens if you change your primary (or current) group to dba instead of soc?

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610366 is a reply to message #610365]

Wed, 19 March 2014 10:34

lmontejo
Messages: 9
Registered: March 2014

Junior Member

Good try, but it's the same:

eoc@zpecas:>id
uid=201(eoc) gid=201(dba)
eoc@zpecas:>groups
dba soc
eoc@zpecas:>
eoc@zpecas:>sqlplus energia3/energia3

SQL*Plus: Release 8.1.6.0.0 - Production on Mi� Mar 19 16:39:22 2014

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

ERROR:
ORA-01034: ORACLE not available

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610369 is a reply to message #610366]

Wed, 19 March 2014 10:40

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And, desperately searching for something, if you remove yourself from soc group (and start a new session)?

You can also trace (truss/tusc) your session with both oracle and your account to see if there any difference in the system call.
By the way, are LD_LIBRARY_PATH and PATH exactly the same ones for both account (maybe something in the path makes you load a library and another one for oracle)?

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610376 is a reply to message #610369]

Wed, 19 March 2014 11:08

lmontejo
Messages: 9
Registered: March 2014

Junior Member

I've checked out the sqlplus binary used and library loaded in both environments and are the same.
And now I've tried your idea (removing user from soc group) with no result.
Now I'm comparing the truss output from both sessions but I can't find the problem, I'm not a programer. Any other idea?

Thanks.

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610384 is a reply to message #610376]

Wed, 19 March 2014 12:26

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Sorry, no more for the moment, maybe our USA west coast fellows that are coming now will have some.
Or maybe our Asian/Indian ones in a couple of hours.

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610390 is a reply to message #610384]

Wed, 19 March 2014 13:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You can capture the output from truss by first doing like below

script error.log
truss sqlplus energia3/energia3
exit
Then issue Ctrl-D to terminate error.log file

do similar from Oracle user but as below
script good.log
& use "diff" to compare error.log & good.log

I suspect root cause is OS file permission or lack thereof

Report message to a moderator

Re: ORA-01034: ORACLE not available (some users only) [message #610451 is a reply to message #610390]

Thu, 20 March 2014 03:20

lmontejo
Messages: 9
Registered: March 2014

Junior Member

Yesterday I captured truss from both executions. My problem begins when trying to understand the difference between both.
Thanks

Report message to a moderator

Previous Topic:	Identify sessions connected with Oracle connection Magager
Next Topic:	create a distributed database on two servers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 05:36:24 CST 2024