Re: Connection Problem!

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 Mon May 14 2001 - 02:20:19 CDT