Re: Request SQL*Net Experts

Thomas Pietz wrote:
>
> Hello Pamela,
>
> your listener.ora file miss the following statement:
>
> Pamela Samuels schrieb:
>
> > I have been trying to configure an Oracle 9i instance on a linux
> > server, and am having trouble connecting, both from Windows and Linux.
> > I can tnsping the instance from Windows, though I am not up on my

<snip>

> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = TESTDB)
> (ORACLE_HOME = /u01/.....)
> (SID_NAME = TESTDB)
> )
> )
>

<snip>

> You can see it here:
>
> >
> > The listener supports no services

Because all of the configuration parameters have default values, it is possible to start and use a listener with no configuration. This default listener has a name of LISTENER, supports no services upon startup, and listens on the following TCP/IP protocol address:

(ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1521))

Supported services, that is, the services to which the listener forwards client requests, can be configured in the listener.ora file or this information can be *dynamically registered* with the listener. This *dynamic registration* feature is called service registration and is used by Oracle9i or Oracle8i instances. The registration is performed by the PMON process--an instance background process--of each database instance that has the necessary configuration in the database initialization parameter file. Dynamic service registration does not require any configuration in the listener.ora file.

So, the listener.ora doesn't need the entry you suggested.

Regards,

Knut Received on Mon Jan 21 2002 - 09:39:59 CST