Easy to write... But I wonder what will you do if you cannot change screen
resolution because of access restrictions. I think that installing Oracle
client requires much more privileges....
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:aahi4j$b39$1_at_lust.ihug.co.nz...
> 1. Install the Oracle client on your other computers.
> 2. 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 Mon Apr 29 2002 - 00:32:29 CDT
