Re: The problem is how to find the port number of My ORACLE server

Huaping Luo wrote:
>
> The biggest trouble is to how find the port number of ORACLE server.
> My ORACLE is ORACLE7.x. If each ORACLE server has a file called "tnsnames.ora",
> how can I fail to find it after I logged into my ORACLE account. Is it
> possible that some ORACLE installation is incomplete so that "tnsnames.ora" is
> not installed or "tnsnames.ora" can be changed into other file name?
>
> Thanks.
>
> Huaping Luo

Hi
It seems to me that you're confused with the naming and location of the different files for SQL*Net. So here's my definition (and should be coresponding
to the one of Oracle :-))

The server must have the listener.ora file (in cases where SQL*Net is used).
This file contains the definitions for the DB's which can be accessed via
SQL*Net (the DB-name, Host-name and on which port the listener listen).

The client should have a tnsnames.ora file.

In cases where the server is also a client he should also have the listener.ora
and the tnsnames.ora .

If you can't find the tnsping.ora on the client but you can still connect to
the DB via SQL*Net try the tnsping programm to determin host and port (syntax on the Unix system: tnsping DB-name)

HtH
eugen Received on Wed May 13 1998 - 11:39:50 CDT