CODEWITHSUNDEEP
oracle-databaseportlisteneroracle11g
tsauerwein
tsauerwein

Reputation: 6051

Oracle listening on changing port for remote connections

I installed Oracle 11gR2 and I am now trying to access the database from a remote system.

My listener.ora is still the default:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /media/oracle/app/oracle

./lsnrctl services returns this:

oracle@ubuntu:/media/oracle/app/oracle/product/11.2.0/dbhome_1/bin$ ./lsnrctl services

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-MAY-2010 05:00:49

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "gis.c2c" has 1 instance(s).
  Instance "gis", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "gisXDB.c2c" has 1 instance(s).
  Instance "gis", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:972 state:ready
         DISPATCHER <machine: ubuntu, pid: 2916>
         (ADDRESS=(PROTOCOL=tcp)(HOST=ubuntu.localdomain)(PORT=47616))
The command completed successfully

I am not able to get a remote connection using port 1521, but the above listed port 47616 works. I wouldn't mind using a different port than 1521, but the problem is that this port changes on every reboot.

What is going wrong?

Thanks!

Upvotes: 1

Views: 10868

Answers (1)

Juraj
Juraj

Reputation: 870

This is not programming question, maybe it belongs to serverfault.

However, I would think of following:

Is localhost defined in /etc/hosts ? And, if you want to access the listener from network, you should not be listening on localhost, but on external address.

Is the port 1521 available? Verify by running netstat -tlnp .

Upvotes: 2

Related Questions