- Install the Oracle client on your other computers.
- Copy the working tnsnames.ora from the original machine to each and every
'other computer'.
HJR
"czorny" <czorny_news_at_o2.pl> wrote in message
news:aaguo6$63q$1_at_sunsite.icm.edu.pl...
> >"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:ucm12l1b1qq387_at_corp.supernews.com...
> >
> > No
> > Yes, once the tnsnames.ora has been setup correctly
> > Oracle Client Administrator is dead and has been replaced by the net8
> > assistant
> > However, it seems you still don't understand or try to understand my
reply
> > Your tnsnames.ora IS correct, and you should be able to connect using
>
> I know that my TNSNAMES.ORA is correct! And every day I use:
> > <username>/<password>@main
>
> But how SQLplus on other computers (i.e. university.computer.edu) can know
> what and where is "main"?
> The F.... Manual (Oracle9i Net Services Administrator's Guide Release 1
> (9.0.1) Part Number A90154-01)
> describes clearly:
> CONNECT username/password_at_connect_identifier
>
>
(http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/network.90
> 1/a90154/connect.htm#430042)
> but it says that connect_identifier must describe how to access to my
> computer and instance. Isn't it?
> OK.
> Connect_identifier is described in
>
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/network.901
> /a90154/connect.htm#435637
> as for example
> CONNECT
> scott/tiger@'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)
> (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com)))'
> so I think I can use it everywhere.
> As you can see there is no word about tnsnames.ora in original Oracle
> manual.
> I tried:
> CONNECT
> system/***@'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=my.host.net)
> (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=main)))'
> and:
> 1. this syntax DOES NOT WORK on remote/university
(university.computer.edu)
> computer - ORA-06401: NETCMN: invalid driver..... (I've wrote this in my
> first post)
> 2. this syntax works on my computer (my.host.net) (but it is not necessary
> because I use CONNECT system/***@main - and it is normal)
> 3. is there a shorter way? Oracle Manuals don't specify all possible
> connect_identifier syntaxes
>
>
> > If you think you can't connect please include any pertinent error
messages
>
> > instead of ignoring my reply.
>
> The error number was in my first post.
>
> >
> >
> > Regards
> >
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> >
> > to reply remove '-verwijderdit' from my e-mail address
> >
> >
>
>
Received on Sun Apr 28 2002 - 14:20:35 CDT
