Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sqlplus login fails

Re: Sqlplus login fails

From: Mark Malakanov <markmal_at_sprint.ca>
Date: Sun, 3 Oct 1999 11:27:08 -0300
Message-ID: <azKJ3.8978$xJ4.430775@newscontent-01.sprint.ca>


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.
Received on Sun Oct 03 1999 - 09:27:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US