Results 1 to 4 of 4

Thread: How to install OracleXE on openSUSE 11.2

  1. #1

    Default How to install OracleXE on openSUSE 11.2

    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. #2

    Default Re: How to install OracleXE on openSUSE 11.2

    Hi all,

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

    best regards
    Michael

  3. #3
    Join Date
    Jun 2008
    Location
    Dublin, Ireland
    Posts
    298

    Default Re: How to install OracleXE on openSUSE 11.2

    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:

    Code:
    SQL> shutdown
    then try starting it again:

    Code:
    SQL> startup
    See how that goes first.

    /jlar

  4. #4
    Join Date
    Dec 2008
    Location
    GMT-7
    Posts
    382

    Default Re: How to install OracleXE on openSUSE 11.2

    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':
    Code:
    > 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):
    Code:
    conn / as sysdba
    startup
    quit
    stop_instance.sql (used by the shutdown script):
    Code:
    conn / as sysdba
    shutdown immediate
    quit
    startinstance.sh:
    Code:
    #!/bin/sh
     
    lsnrctl start
    sqlplus /nolog @/home/oracle/start_instance.sql
    stopinstance.sh:
    Code:
    #!/bin/sh
     
    sqlplus /nolog @/home/oracle/stop_instance.sql
    lsnrctl stop
    To stop and start the management console, use the following commands:
    Code:
    > 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.
    Code:
    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.
    Desk: AMD Phenom II X4 945 8GB RAM Radeon HD 3300 Arch Linux Xfce 4.8
    Lap: Intel 2.13GHz Core i3 M330 8GB RAM nVidia GeForce 310M Arch Linux KDE 4.7.3

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •