Oracle listening on changing port for remote connections
I installed开发者_JS百科 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!
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 .
精彩评论