Oracle 10.2 problem on OpenSUSE 11+ Plesk

Posted on 2009-07-03
Medium Priority
Last Modified: 2013-12-19
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

s15338338:~ # echo $ORACLE_SID

s15338338:~ # echo $NLS_LANG

s15338338:~ # echo $LD_LIBRARY_PATH

s15338338:~ # cat /etc/oratab

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

s15338338:~ # echo $PATH

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 - Production on Tue Jun 30 15:39:32 2009

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

Enter user-name: SYS
Enter password:

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



i can't login with sqlplus :(
Question by:Rudolf_Abel
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 29

Accepted Solution

MikeOM_DBA earned 2000 total points
ID: 24773270

Check if you created a password file and then try:

# sqlplus '/as sysdba'

-- or --

# sqlplus
SQL*Plus: Release - 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:


Author Comment

ID: 24784328
thaaaanks :D

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
The purpose of this article is to demonstrate how we can upgrade Python from version 2.7.6 to Python 2.7.10 on the Linux Mint operating system. I am using an Oracle Virtual Box where I have installed Linux Mint operating system version 17.2. Once yo…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question