Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 675
  • Last Modified:

Oracle 10.2 problem on OpenSUSE 11+ Plesk

Server: 1&1 Dedicated Server DC M Linux [ http://order.1and1.co.uk ]
             Athlon X2 4200+ (2.2 Ghz), 2 GB RAM, HDD 2 x 250GB

OS: openSUSE 11 with Plesk 9 (32-bit)

Oracle installed Successful
Installation path: /usr/lib/oracle/xe/app/oracle/product/10.2.0

s15338338:/usr/lib/oracle/xe/app/oracle/product/10.2.0 # ls -l
total 4
drwxr-xr-x 11 oracle dba  113 Jun 24 08:41 client
drwxr-xr-x 24 oracle dba 4096 Jun 24 10:05 server

s15338338:~ # echo $ORACLE_HOME
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

s15338338:~ # echo $ORACLE_SID
XE

s15338338:~ # echo $NLS_LANG
AMERICAN_AMERICA.AL32UTF8

s15338338:~ # echo $LD_LIBRARY_PATH
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib:

s15338338:~ # cat /etc/oratab
XE:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server:N

s15338338:~ # sysctl -p
net.ipv4.icmp_echo_ignore_broadcasts = 1
net.ipv4.conf.all.rp_filter = 1
fs.inotify.max_user_watches = 65536
net.ipv4.conf.default.promote_secondaries = 1
net.ipv4.conf.all.promote_secondaries = 1
kernel.shmall = 2097152
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304

net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144

s15338338:~ # echo $JAVA_HOME
/srv/app/jdk1.5.0_18

s15338338:~ # echo $PATH
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin://sbin://bin:/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:/srv/app/jdk1.5.0_18/bin

s15338338:~ # ps -ef | grep oracle
oracle    2944     1  0 07:03 ?        00:00:00 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER inherit

s15338338:~ # sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jun 30 15:39:32 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: SYS
Enter password:

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

ORA-01034:
    http://www.dba-oracle.com/sf_ora_01034_oracle_not_available.htm 
    DONE

ORA-27101:
    http://www.dba-oracle.com/sf_ora_27101_shared_memory_realm_does_not_exist.htm
    DONE

i can't login with sqlplus :(
0
Rudolf_Abel
Asked:
Rudolf_Abel
1 Solution
 
MikeOM_DBACommented:

Check if you created a password file and then try:

# sqlplus '/as sysdba'

-- or --

# sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jun 30 15:39:32 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: SYS as sysdba
Enter password:







0
 
Rudolf_AbelAuthor Commented:
thaaaanks :D
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now