Re: TNS Listener not working

Sal Tinajero wrote:

> We transferred the Oracle Server to our sister company as a first step to
> relocation. However, after joining the new domain and having different
> machine name and new IP address. The server does not want to start the TNS
> Listener. Any ideas will be helpfull.
>
> Thank you,
>
> SRT
>

please post the platform and version info. If you're on Oracle 8.1.x ...
It is entirely likely that the default_domain in the sqlnet.ora does not co-incide with the parameter db_domain in the init<SID>.ora file. (meaning that the old domain and new domain are different)

Are you using fully qualified service names such as mydb.mydomain.com? If the user previously did not fuly qualify the name, the default_domain was likely appended to the database name to create the service_name.

start lsnrctl
type "set password <mypassword>"

        (you are using a password on the listener, right?) type "set displaymode verbose"
type "services"
turn on tracing - client and server side - start with "USER" level. turn on logging - client and server side. connect with the client and record any error messages. get the trace and log files. read them.

Metalink also has lots of docs for diagnosing net8 connectivity problems.

hth,

Paul Received on Sat Feb 23 2002 - 11:15:36 CST