Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to use OCI program access remote oracle db?

Re: how to use OCI program access remote oracle db?

From: Xie Haifeng <xiehaifeng_at_hotmail.com>
Date: Tue, 29 Apr 2003 16:52:39 +0800
Message-ID: <b8leif$asaci$1@ID-179281.news.dfncis.de>


  Thank you all!
  I have installed oracle client on the 2nd machine. and have configed a Service Naming with netasst. Then modify the dblink parameter of OCIServerAttach function to the name I configed. Then everything is OK.   But when I have installed oracle client on the 2nd machine, I have to use such command to logon to remote server:

    sqlplus /nolog
    connect user/passwd @Name(which I configed). but

    sqlplus user/passwd
can not logon even I set ORACLE_SID to the name I just configed. Why? Does there are some different between them?
  Thanks!

xie. Received on Tue Apr 29 2003 - 03:52:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US