Re: Sqlplus login fails

From: <tkvlvk_at_my-deja.com>
Date: Mon, 04 Oct 1999 15:35:38 GMT
Message-ID: <7tahg9$5do$1@nnrp1.deja.com>

Thank you for the corrections, but after doing this also problem not solved.

The "listener.log" in server looks like 04-OCT-99 10:06:35 * (CONNECT_DATA=(SID=c1)(CID=(PROGRAM=)(HOST=<name>) (USER=oracle8))) * (ADDRESS=(PROTOCOL=tcp)(HOST=<ip add>)(PORT=32893)) * establish * c1 * 0

The "sqlnet.log" file on client (my machine) is like VERSION INFORMATION:

        TNS for Solaris: Version 8.0.4.0.0 - Production
        Oracle Bequeath NT Protocol Adapter for Solaris: Version

8.0.4.0.0 - Pro
duction
  Time: 04-OCT-99 10:10:52
  Tracing not turned on.
  Tns error struct:
    nr err code: 12206
    TNS-12206: TNS:received a TNS error during navigation

Please suggest me something about this error. And the correction suggested in tnsnames.ora to be done at server or client?

Thank you.

In article <azKJ3.8978$xJ4.430775_at_newscontent-01.sprint.ca>,   "Mark Malakanov" <markmal_at_sprint.ca> wrote:
> Ensure TNS names.
>
> sqlnet.ora
> names.default_domain = world
> name.default_zone = world
>
> tnsnames.ora
> MyAlias.world = (DESCRIPTION =
>
> There must be word ".WORLD". Or other name, of course.
>
> Mark Malakanov
> DBA
> Sapience, Toronto
>
> <tkvlvk_at_my-deja.com> wrote in message
news:7t2pns$77l$1_at_nnrp1.deja.com...
> > I have net8 client installed for connecting to remote server
(oracle8)
> > through PPP link, dialup modems on solaris2.6(Both are UNIX
machines.
> > After establishing PPP connectivity I am able to do "tnsping
<inst>".
> > But when I try to login using "sqlplus <uid>/<passwd>@<inst>" the
> > process is hanging for quit a long time and finally not getting
> > connected.
> > Is there anything to do on server side to allow remote host to
login?
> > Please help me to have an understanding of the problem. Thank you.
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 04 1999 - 10:35:38 CDT