Solved

Oracle 10.2 problem on OpenSUSE 11+ Plesk

Posted on 2009-07-03
2
626 Views
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
/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
Comment
Question by:Rudolf_Abel
2 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 total points
ID: 24773270

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
 

Author Comment

by:Rudolf_Abel
ID: 24784328
thaaaanks :D
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSH connect to Amazon Centos Instance 7 40
Question About Creating Primary Key Constraints on Oracle Tables... 5 38
Oracle SQL 6 48
Query Records that don't match 8 34
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
The purpose of this article is to show how we can create Linux Mint virtual machine using Oracle Virtual Box. To install Linux Mint we have to download the ISO file from its website i.e. http://www.linuxmint.com. Once you open the link you will see …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

910 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now