| ORA-01034: ORACLE not available [message #411055] |
Wed, 01 July 2009 14:17  |
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 #411060 is a reply to message #411056] |
Wed, 01 July 2009 14:37  |
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 #424416 is a reply to message #411055] |
Fri, 02 October 2009 04:49 |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
