Home » Infrastructure » Linux » ORA-01034: ORACLE not available
ORA-01034: ORACLE not available [message #411055] Wed, 01 July 2009 14:17 Go to next message
neugi
Messages: 2
Registered: July 2009
Junior Member
Hi,

i'm new to Oracle and tried to setup a test server on my debian lenny.

Evering seems to work fine. listener starts and oracle starts

but if i try to login to sqlplus with system i get the following:

sqlplus
Enter user-name: SYSTEM
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

if i do the same this way:

sqlplus /nolog

QL> connect / AS SYSDBA
ERROR:
ORA-01031: insufficient privileges

i've search google and all parts on the forum but found no solution. maybe somebody can help me here

best
Re: ORA-01034: ORACLE not available [message #411056 is a reply to message #411055] Wed, 01 July 2009 14:24 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Did you set ORACLE_HOME & ORACLE_SID by running . oraenv?

For details, see http://www.orafaq.com/wiki/Oraenv
Re: ORA-01034: ORACLE not available [message #411057 is a reply to message #411055] Wed, 01 July 2009 14:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't search very well.
Try again.

Regards
Michel
Re: ORA-01034: ORACLE not available [message #411060 is a reply to message #411056] Wed, 01 July 2009 14:37 Go to previous messageGo to next message
neugi
Messages: 2
Registered: July 2009
Junior Member
HI,

HOME is set to: "/usr/lib/oracle/xe/app/oracle/product/10.2.0/server"
SID is set to "XE"

when i run oraenv

ebian-50-lenny-64-LAMP:/# oraenv
ORACLE_SID = [XE] ? XE
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oraenv: line 64: dbhome: command not found
ORACLE_HOME = [] ?

gruz

[Updated on: Wed, 01 July 2009 14:42]

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #411064 is a reply to message #411060] Wed, 01 July 2009 14:56 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
1. You need a dot in front of oraenv

2. dbhome should be in $ORACLE_HOME/bin/. Debug the script to see why it cannot be found.
Re: ORA-01034: ORACLE not available [message #411082 is a reply to message #411055] Wed, 01 July 2009 18:56 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>1. You need a dot in front of oraenv
Or possibly a dot space as in below
ebian-50-lenny-64-LAMP:/# . oraenv
Re: ORA-01034: ORACLE not available [message #424416 is a reply to message #411055] Fri, 02 October 2009 04:49 Go to previous messageGo to next message
mohd_dba
Messages: 19
Registered: October 2009
Junior Member
Try to connect to the database by using the command like,

$ sqlplus system/manager@<db name>

db name is nothing but the name which you specify at tnsnames.ora file.And try to connect the once again.
It will get connect.
Re: ORA-01034: ORACLE not available [message #424429 is a reply to message #424416] Fri, 02 October 2009 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It will not if the database is not started.

Regards
Michel
Re: ORA-01034: ORACLE not available [message #424561 is a reply to message #411055] Sat, 03 October 2009 16:33 Go to previous message
ursusca
Messages: 40
Registered: September 2009
Location: Toronto, ON
Member

Hi,

Try to connect to the database by using the command like,

sqlplus / as sysdba

Can you post ~oracle/.bash_profile file?

But I can tell you straight away that there are no Oracle products supported on Debian. OEL is free. You can try it.

[Updated on: Sat, 03 October 2009 16:34]

Report message to a moderator

Previous Topic: shell script
Next Topic: No such file or directory?
Goto Forum:
  


Current Time: Fri Dec 09 13:50:47 CST 2016

Total time taken to generate the page: 0.09108 seconds