Re: Remote connection in SQLplus: ORA-06401: NETCMN....

I can only go on what information you provide. Where in your original post did it say that you are attempting to do this with minimal privileges on the other machines?

OK. Easy to re-write, too.

1. Get the system administrator to install the Oracle Client
2. Get the system administrator to copy tnsnames.ora onto his or her other machines.

HJR "czorny" <czorny_news_at_o2.pl> wrote in message news:aahm82$s72$1_at_sunsite.icm.edu.pl...
> 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 - 03:58:17 CDT