Results 1 to 3 of 3

Thread: oracle 11g express edition on opensuse 12.1

  1. #1
    Join Date
    Jun 2008
    Location
    Raleigh, NC
    Posts
    87

    Default oracle 11g express edition on opensuse 12.1

    both release versions - having problems. I had no issues with oracle 11g XE on opensuse 11.4 but on 12.1, the installation finishes but when I start the DB, database processes start but not the listener- without the listener, I cannot connect.

    I tried replacing localhost with 127.0.0.1 in the listener.ora and tnsnames.ora files. That led to listener starting but when I connect, it says that the service name/id ( XE in my case) does not exist and the listener crashes again.

    Any one had better luck ?

  2. #2

    Default Re: oracle 11g express edition on opensuse 12.1

    I had problem with install of Oracle XE on OpenSUSE 12.1. I edited /etc/hosts, added my IP and host name. Then all started. I find this topic from user Marley:

    SQL> startup
    ORA-00119: invalid specification for system parameter LOCAL_LISTENER
    ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=msk.localdomain)(POR T=1521))'
    SQL> quit

    # vi /etc/hosts
    Code:
    ## IPs Public Network (hosts file, DNS)
    192.168.1.101 msk.localdomain msk
    $ vi /u01/app/oracle/product/11.2/network/admin/tnsnames.ora
    Code:
    ORA112 =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = msk.localdomain)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = ora112)
        )
      )
    $ vi /u01/app/oracle/product/11.2/network/admin/listener.ora
    Code:
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = msk.localdomain)(PORT = 1521))
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        )
      )
    
    ADR_BASE_LISTENER = /u01/app/oracle
    $ lsnrctl stop
    $ lsnrctl start

    $ sqlplus / as sysdba

    SQL> startup
    Code:
    ORACLE instance started.
    
    Total System Global Area  835104768 bytes
    Fixed Size                  2232960 bytes
    Variable Size             507514240 bytes
    Database Buffers          322961408 bytes
    Redo Buffers                2396160 bytes
    Database mounted.
    Database opened.

  3. #3

    Default Re: oracle 11g express edition on opensuse 12.1

    Looks like you a typo in your local_listener parameter. Instead of "PORT=1521" you have "POR T=1521". An extra space is what you need to remove.

    --MM


    Quote Originally Posted by Gogiev View Post
    I had problem with install of Oracle XE on OpenSUSE 12.1. I edited /etc/hosts, added my IP and host name. Then all started. I find this topic from user Marley:

    SQL> startup
    ORA-00119: invalid specification for system parameter LOCAL_LISTENER
    ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=msk.localdomain)(POR T=1521))'
    SQL> quit

    # vi /etc/hosts
    Code:
    ## IPs Public Network (hosts file, DNS)
    192.168.1.101 msk.localdomain msk
    $ vi /u01/app/oracle/product/11.2/network/admin/tnsnames.ora
    Code:
    ORA112 =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = msk.localdomain)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = ora112)
        )
      )
    $ vi /u01/app/oracle/product/11.2/network/admin/listener.ora
    Code:
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = msk.localdomain)(PORT = 1521))
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        )
      )
    
    ADR_BASE_LISTENER = /u01/app/oracle
    $ lsnrctl stop
    $ lsnrctl start

    $ sqlplus / as sysdba

    SQL> startup
    Code:
    ORACLE instance started.
    
    Total System Global Area  835104768 bytes
    Fixed Size                  2232960 bytes
    Variable Size             507514240 bytes
    Database Buffers          322961408 bytes
    Redo Buffers                2396160 bytes
    Database mounted.
    Database opened.

Posting Permissions

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