Home » RDBMS Server » Server Administration » ORA-01034: ORACLE not available (some users only) (Oracle 8.1.6.3, Solaris 8)
ORA-01034: ORACLE not available (some users only) [message #610313] Wed, 19 March 2014 06:39 Go to next message
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.
Re: ORA-01034: ORACLE not available (some users only) [message #610314 is a reply to message #610313] Wed, 19 March 2014 06:43 Go to previous messageGo to next message
Roachcoach
Messages: 1178
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.
Re: ORA-01034: ORACLE not available (some users only) [message #610318 is a reply to message #610314] Wed, 19 March 2014 07:17 Go to previous messageGo to next message
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.
Re: ORA-01034: ORACLE not available (some users only) [message #610325 is a reply to message #610318] Wed, 19 March 2014 07:31 Go to previous messageGo to next message
cookiemonster
Messages: 10846
Registered: September 2008
Location: Rainy Manchester
Senior Member
Why is the SID different to the one specified in the first sqlplus call?
Re: ORA-01034: ORACLE not available (some users only) [message #610328 is a reply to message #610325] Wed, 19 March 2014 07:35 Go to previous messageGo to next message
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
Re: ORA-01034: ORACLE not available (some users only) [message #610345 is a reply to message #610328] Wed, 19 March 2014 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 58545
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post the result of: uname -a

Re: ORA-01034: ORACLE not available (some users only) [message #610346 is a reply to message #610345] Wed, 19 March 2014 08:39 Go to previous messageGo to next message
Michel Cadot
Messages: 58545
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And also: tnsping zpecas

Re: ORA-01034: ORACLE not available (some users only) [message #610347 is a reply to message #610346] Wed, 19 March 2014 08:44 Go to previous messageGo to next message
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
Re: ORA-01034: ORACLE not available (some users only) [message #610349 is a reply to message #610347] Wed, 19 March 2014 08:46 Go to previous messageGo to next message
Michel Cadot
Messages: 58545
Registered: March 2007
Location: Nanterre, France, http://...
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?

Re: ORA-01034: ORACLE not available (some users only) [message #610350 is a reply to message #610349] Wed, 19 March 2014 08:47 Go to previous messageGo to next message
lmontejo
Messages: 9
Registered: March 2014
Junior Member
Yes
Re: ORA-01034: ORACLE not available (some users only) [message #610354 is a reply to message #610350] Wed, 19 March 2014 09:26 Go to previous messageGo to next message
Michel Cadot
Messages: 58545
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: ORA-01034: ORACLE not available (some users only) [message #610356 is a reply to message #610354] Wed, 19 March 2014 09:29 Go to previous messageGo to next message
Michel Cadot
Messages: 58545
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: ORA-01034: ORACLE not available (some users only) [message #610362 is a reply to message #610356] Wed, 19 March 2014 10:00 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58545
Registered: March 2007
Location: Nanterre, France, http://...
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?

Re: ORA-01034: ORACLE not available (some users only) [message #610366 is a reply to message #610365] Wed, 19 March 2014 10:34 Go to previous messageGo to next message
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
Re: ORA-01034: ORACLE not available (some users only) [message #610369 is a reply to message #610366] Wed, 19 March 2014 10:40 Go to previous messageGo to next message
Michel Cadot
Messages: 58545
Registered: March 2007
Location: Nanterre, France, http://...
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)?

Re: ORA-01034: ORACLE not available (some users only) [message #610376 is a reply to message #610369] Wed, 19 March 2014 11:08 Go to previous messageGo to next message
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.
Re: ORA-01034: ORACLE not available (some users only) [message #610384 is a reply to message #610376] Wed, 19 March 2014 12:26 Go to previous messageGo to next message
Michel Cadot
Messages: 58545
Registered: March 2007
Location: Nanterre, France, http://...
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.


Re: ORA-01034: ORACLE not available (some users only) [message #610390 is a reply to message #610384] Wed, 19 March 2014 13:17 Go to previous messageGo to next message
BlackSwan
Messages: 22495
Registered: January 2009
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
Re: ORA-01034: ORACLE not available (some users only) [message #610451 is a reply to message #610390] Thu, 20 March 2014 03:20 Go to previous message
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
Previous Topic: Identify sessions connected with Oracle connection Magager
Next Topic: create a distributed database on two servers
Goto Forum:
  


Current Time: Thu Jul 24 22:59:38 CDT 2014

Total time taken to generate the page: 0.14374 seconds