Re: Working with a local DB with OracleClient?

On Thu, 12 May 2005 09:55:36 GMT, "Fabio" <corso0web_at_NOSPAMquipo.it> wrote:

>I trayed with BEQ protocol but i obtained the same negative result:
>"Address property are incorrect".
>
>I attempted to modify the tnsnames.ora with
>...
>ADDRESS (PROTOCOL = BEQ)
>...
>
>Thank you for your suggestions
>

From the post of Rauf Sarwar, you obviously didn't read

</quote>

Assuming your oracle sid is ORCL, you can either,

C:\> set oracle_sid=ORCL
C:\> sqlplus username/password
Note that there is no @ORCL in the connect string

OR

Put this in your tnsnames.ora file
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle)(ARGV0 = oracleORCL)(ARGS = '(DESCRIPTION =(LOCAL = YES)(ADDRESS = (PROTOCOL = BEQ)))'))
    (CONNECT_DATA = (SERVICE_NAME = ORCL))   )
then you can
C:\> sqlplus username/password_at_ORCL

In either case, you don't need a listener for local connections.

</end quote>

Replace ORCL by your SID

--
Sybrand Bakker, Senior Oracle DBA