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 ?

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

## IPs Public Network (hosts file, DNS)
192.168.1.101 msk.localdomain msk

$ vi /u01/app/oracle/product/11.2/network/admin/tnsnames.ora

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

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

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.

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