Re: Connection Problem!

From: Alexander Penev <penev_at_cska.net>
Date: Tue, 15 May 2001 09:57:21 +0200
Message-ID: <3B00E161.40008@cska.net>

Khurram Izhar wrote:

> How to check that. As I told you through the Net8 utility the test option is

Just open the files (default dir is something like c:\orant\net80\admin\) tnsnames.ora and sqlnet.ora with notepad and post here the text (better post also the listener.ora of you oracle box).

> performing a successful connection to the host. Can anyone tell me the exact
> format of connect string from the SQL*PLUS.
>

connect username/password_at_servicename
servicename is the name you've typed for service name in the first screen as you tested the service (with net easy config i suppose)

> I also wanted to confirm; in oracle is "Sql*Plus" is the only utility to
> connect to the remote host for creating objects in the database?
>

no, it's not the only utility at all. There is the DBA Studio and many other thirdpart utilities (TOAD for example).

> Regards,
> Khurram
>
>
> "Alexander Penev" <alex_at_penev.com> wrote in message
> news:3B00578A.EABE00A8_at_penev.com...
>

>>can you post your tnsnames.ora and sqlnet.ora from the win2k box here.
>>
>>Khurram Izhar wrote:
>>
>>
>>>The mentioned service is running. I have also tested through the Net8
>>>utility that the Net Service Name for the database is connecting and the
>>>"Test" says "successfull" though both "scott" and "SYSTEM" accounts.
>>>
>>>While I am running the SQL*PLUS, its not connecting through the connect
>>>string.
>>>
>>>I am using the string "connect scott/tiger_at_TEST" string to connect to
>>>

> the
>

>>>host running the database 'test' for which I have created the net
>>>

> service
>

>>>name 'test' in the client.
>>>
>>>Is the syntax for the connect string is okay? Do I need to give a the
>>>

> same
>

>>>username and password in the fields before the Host string option.
>>>
>>>Khurram
>>>
>>>"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
>>>news:tftr28511df8f4_at_beta-news.demon.nl...
>>>
>>>>"Khurram Izhar" <KhurramI_at_Ducont.Com> wrote in message
>>>>news:9dmbi0$6a42_at_news.emirates.net.ae...
>>>>
>>>>>Hi,
>>>>>
>>>>>I am using release 8.1.5.0.0. I am new to Oracle.
>>>>>
>>>>>I have connection problem from the client machine to the server. On
>>>>>

> the
>

>>>>>server machine, the SQL*PLUS is working fine with the "SYSTEM"
>>>>>

> account.
>

>>>>>I have configured a listenter on TCP/IP port 1521 on the server,
>>>>>

> when I
>

>>>>try
>>>>
>>>>>to connect from a windows 2000 professional machine through
>>>>>

> SQL*PLUS, I
>

>>>am
>>>
>>>>>getting an error saying:
>>>>>
>>>>>ORA-12541: TNS: no listener
>>>>>
>>>>>Do I need to run all the oracle services on the NT Server Machine?
>>>>>
>>>>>Any help would be highly appreciated.
>>>>>
>>>>>Regards,
>>>>>Khurram
>>>>>
>>>>>
>>>>>
>>>>Maybe a stupid question, but did you start the listener or the
>>>>OracleTnsListener service.
>>>>If not at a command prompt type
>>>>lnsrctl start
>>>>
>>>>The message tells:
>>>>a I can find the server
>>>>b There's no listener running
>>>>
>>>>Hth,
>>>>
>>>>Sybrand Bakker, Oracle DBA
>>>>
>>>>
>>>>
>>>>

>
>
Received on Tue May 15 2001 - 02:57:21 CDT