Re: SQL*PLUS question
Date: Wed, 6 May 1998 20:33:50 -0400
Message-ID: <6ir1gq$2ac_at_news.southeast.net>
Take a look at the tnsnames.ora file that should be located in the <oracle home>\network\admin directory. In that file there is a list of what I think are services (that might not be the correct name) that desribe the different instances that you have access to. One of the entries should be the connect_string you are looking for. Below is one entry from my tnsnames.ora. To connect as scott for this instance I would use the following: user=scott, pwd=tiger, connect_string=beq-local.
Beq-Local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = beq.world) (PROTOCOL = BEQ) (PROGRAM = oracle73) (ARGV0 = oracle73ORCL) (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))') )
)
(CONNECT_DATA = (SID = ORCL)
)
)
Hope this helps.
Patrick Flahan
flahan_at_leading.net
Ashok Rathi wrote in message <6iqp34$3b3$1_at_news.bayarea.net>...
>I am using SQL*PLUS with Oracle 8. My entire database is loaded locally,
and
>I can connect using 'user/password' combination. But when I use JDBC
driver,
>it requires connect_string. I do not have any. So how do I find what it
>should be?
>
>Tx.
>
>-- ashok
>
>
Received on Thu May 07 1998 - 02:33:50 CEST