Re: Newbie: Problems to connect using port 1521

Your listener.ora looks ok. Since you are still having trouble, let me ask if you have a firewall. We had that difficulty and only after a thorough search of Oracle's MetaLink did we find out how to configure OracleNet to work with our firewall (which didn't understand Net8). If this is your case, you might start with Note 125021.1 (Oracle Connectivity with Firewalls).

You said you are a Newbie, so you might not have discovered MetaLink yet ... just go to http://metalink.oracle.com ... you have to request a userid/password, but you'll find a wealth of useful tips and such. Just type 'firewall' in the search box (if that's what you have).

You have several options to get ONet to talk on a specific port:

1. Connection Manager
2. Shared socets (NT)
3. Multi-Threaded Server

Hope this puts you on the right trail to track down your particular problem.

rigel wrote:
> At the begining, thank you to answer me so fast, but my problem is that I
> think that my Listener.ora are correctly configured. This file contains:
>
> LISTENER =
> (DESCRIPTION_LIST=
> (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP) (HOST = theNameOfMyHost) (PORT = 1521))
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /opt/oracle/product/9.0.1)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = test.myDomain.es)
> (ORACLE_HOME = /opt/oracle/product/9.0.1)
> (SID_NAME = test)
> )
> )
>
> I suppose that the Net8i dispatches every connection to another ports, but
> anything isn't working properly, because the connection fails.
> I would like to know what I have to do to connect to the data base using the
> same port always.
>
> Thank you very much.
Received on Tue Sep 24 2002 - 11:10:16 CDT