How to install OracleXE on openSUSE 11.2

English Applications
1

Hi all,
I hope I’m right here in this section of the forum…

I have a problem with the installation and usage of ORACLE XE.

I followed the steps in
How to install OracleXE on openSUSE 11.1 - openSUSE Forums
Which was very very helpfull!

But I can’t connect to the webpage from localhost (127.0.0.1), since the listener wasn’t started. I checked before configuring, that the port 8080 (default) is free and is not used by any other application.

Does anybody have an idea what is the reason and the difference between OS 11.1 and 11.2 in this special case.

When using OS 11.1 everthing is working fine and I can access the webpage.

Thanx in advance
Michael

2

Hi all,

is there anybody who has an idea???
Please…

best regards
Michael

3

Hi,

If the listener isn’t started then you won’t be able to connect to the web page. Try starting SQL plus and type:

SQL> shutdown

then try starting it again:

SQL> startup

See how that goes first.

/jlar

4

To start Oracle, there are two tiers - the database and the management console. I never run the management console, but that’s my preference.

Here are my Oracle startup and shutdown scripts (run the startinstance.sh script as the ‘oracle’ user).

Become ‘oracle’:


> su
> (enter pwd)
> su - oracle
> ./startinstance.sh

Put the following files in the home folder of the oracle user /home/oracle.

start_instance.sql (used by the startup script):


conn / as sysdba
startup
quit

stop_instance.sql (used by the shutdown script):


conn / as sysdba
shutdown immediate
quit

startinstance.sh:


#!/bin/sh
 
lsnrctl start
sqlplus /nolog @/home/oracle/start_instance.sql

stopinstance.sh:


#!/bin/sh
 
sqlplus /nolog @/home/oracle/stop_instance.sql
lsnrctl stop

To stop and start the management console, use the following commands:


> emctl start dbconsole
and
> emctl stop dbconsole

Also, these scripts assume you have set up the proper Oracle environment variables for the oracle user. Put the following statements (make sure they point to your install folders) in the .profile file for the oracle user. Since you are running XE, your SID = XE.


export ORACLE_BASE=/opt/oracle
export ORACLE_SID=<your SID>
export ORACLE_HOME=/opt/oracle/product/10.1.0/Db_1
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

Hope this helps.