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

TNSNAMES.ora is a client component of SQL*Net version 2, the server component is LISTENER.ora, the port number of these two files must match, for example, TCP should always use port 1526. Therefore on the server side there might not be a TNSNAMES.ora at all, though most DBAs should have created one for testing purposes.

Having said that, the installation of Oracle client software on a PC would not necessary create a TNSNAMES.ora, this file has to be created separately using either Network Manager or just a text editor. The location is %ORACLE_HOME%\Network\Admin . From same reasoning the installation of Oracle server software might not create LISTENER.ora, even if it did, it would not match your particular Oracle7 instance.

Regards
Joe

On 13 May 1998 03:52:33 GMT, huaping_at_pollux.cs.uga.edu (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
>
Received on Thu May 14 1998 - 20:49:34 CDT