Re: Oracle 7 Workgroup Server Question - Remote Access

What about the LISTENER.ORA file? Do I need to configure this in order to access my Oracle Server remotely? If so, then how should the file be configured?

I've tried using SQL*Net Easy Configuration. I've entered the database instance, my remote machine name, and the other information. I am still unable to connect to the database remotely. I can connect locally on the NT Server; so, this leads me to believe that the TNSNAMES file is configured properly there.

Any help here would be greatly appreciated.

• Michael Burke mike1.burke_at_born.com (remove 1 for no-spam reply)

On Thu, 12 Nov 1998 08:05:06 +0100, "Pavel Polcar" <pavel.polcar_at_berit.cz> wrote:

>Hi Michael,
>
>there's no need to send the files because if you have installed the SQL*Net
>software (SQL*Net server on the NT box, SQL*Net client on your laptop) you
>will have template files TNSNAMES.ORA and LISTENER.ORA in the
>%ORACLE_NOME%\RDBMS73\NETWORK\ADMIN directory. SQL*Net Easy Configuration
>program (used for configuring the TNSNAMES.ORA) should be available on
>installing the client. When you are careful enough, you can also edit
>TNSNAMES.ORA directly, e.g. in notepad.
>
>Hth,
>Pavel
>burkem_at_citilink.com wrote in message
><364a61ce.14466464_at_news.citilink.com>...
>part of original text left out
>>I am currently trying to configure Oracle 7 Workgroup server on my
>>>I have installed Oracle 7 Workgroup Server on my NT box and have
>>restored our database instance. I am able to start the oracle
>>listener and access the DB from the local NT box.
>>
>>I am unable to connect to this DB from my laptop (connected via my
>>home network). I've read through the Oracle docs and they mention
>>that you must configure the TNSNAMES.ORA and LISTENERS.ORA?? files in
>>order to enable remote access to the DB.
>>
>>The documentation also refers to a utility which "must" be used to
>>configure the TNSNAMES.ORA file. I am unable to find this utility on
>>my NT box.
>>
>>Thank you in advance,
>>
>>- Michael Burke
>> mike1.burke_at_born.com (remove 1 for nospam reply)
>
>
Received on Thu Nov 12 1998 - 17:45:29 CST