Re: Connection Problem!

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 Mon May 14 2001 - 17:09:21 CDT