Re: Newbie: Problems to connect using port 1521

From: rigel <f71_at_hotmail.com>
Date: Tue, 24 Sep 2002 12:21:02 +0200
Message-ID: <amqegj$1oojv$1@salico.udc.es>

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.

"Karsten Farell" <kfarrell_at_medimpact.com> escribió en el mensaje news:SmKj9.64$xn7.7654718_at_newssvr13.news.prodigy.com...
> Port 1521 is monitored by Listener. When it "hears" a connection request
> (from the client), it spawns (or if MTS, perhaps uses an existing)
> dispatcher to handle the normal network "conversation" between client
> and server. The dispatcher has to "talk" over another port (since 1521
> is in use by Listener) ... so a "random" port is assigned for the
> dispatcher. You can make it less "random" by using MTS or Connection
> Manager.

> Michael J. Moore wrote:
> > You need to understand Oracle Net, formerly called Net8. This is like
> > another layer above ( or under ) the TCP/IP stack. It use 1521 by
default.
> > You should not be trying to use Java to connect directly to this port.
> >
> > APP --->Net8 ----> tcpIP -----network----->
tcpIP---->NET8(1521)----->Oracle
> > Instance
> >
> >
> >
> >
> > "rigel" <f71_at_hotmail.com> wrote in message
> > news:amobna$1na6t$1_at_salico.udc.es...
> >
> >>I have installed OracleI 9.0.1 over Red Hat Linux 7.2.
> >>
> >>I want to connect to the default database using scott/tiger user with
> >
> > Java.
> >
> >>I tried to connect using port 1521 but the connection fails. I used the
> >>command "netstat -atup" and I saw that the process "ora_d000_test" uses
> >
> > one
> >
> >>random number, for example 32777. Then I have tried to connect using
this
> >>port and the connection was succesfull. My problem is that this port
> >
> > changes
> >
> >>when the database starts, and I want to connect using 1521 always.
> >>
> >>Thanks in advance.
> >>
> >>Francisco J. Nóvoa
> >>
> >>
> >
> >
> >

> Received on Tue Sep 24 2002 - 05:21:02 CDT