|
|
Re: Where to get OCCI? I need DLL and .h files [message #111575 is a reply to message #94565] |
Thu, 17 March 2005 11:15 |
kuan62
Messages: 3 Registered: March 2005
|
Junior Member |
|
|
Hi~ MeshFire,
Enjoy it~~ In the first, you should join to Oracle's member, then you can download the instant client files!!
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
Please note that Instant Client is provided under a separate OTN Development and Distribution License for Instant Client that allows most licensees to download, redistribute, and deploy in production environments, without charge. Please consult the license and your legal department for clarification, if necessary. For more information on Instant Client, see the official Instant Client site.
Instant Client for Windows 64-bit Itanium New! (04-Mar-05)
Instant Client for Linux x86-64 New! (25-Feb-05)
Instant Client for Mac OS X
Instant Client for Linux x86
Instant Client for Linux Itanium
Instant Client for Microsoft Windows (32-bit) <--- You need it!!
Instant Client for Solaris Operating System (SPARC)(64-bit)
Instant Client for Solaris Operating System (SPARC)(32-bit)
Instant Client for HP-UX PA-RISC (64-bit)
Instant Client for HP-UX PA-RISC (32-bit)
Instant Client for AIX5L (64-bit)
Instant Client for AIX5L (32-bit)
Instant Client for HP Tru64 UNIX
Instant Client for HP-UX Itanium (64-bit)
Instant Client for HP-UX Itanium (32-bit)
Best Regards,
|
|
|
Re: Where to get OCCI? I need DLL and .h files [message #134828 is a reply to message #111575] |
Sat, 27 August 2005 14:51 |
greatb
Messages: 1 Registered: August 2005 Location: Dallas Texas
|
Junior Member |
|
|
In 10g you typically do not connect to an oracle sid with oci. Rather, you connect to a "Service Name"
This allows one service name to specify more than one SID or database instance. This is great for the 10g RAC. Or 10g Grid as they call it. By connecting to a service name you can have transparent application fail over between two different database instances on two different nodes. Only OCI supports TAF as it uses the Oracle Instant client to open a connection through SQLNET.
Take a look at your configuration files on the server running the 10g RAC and be sure it is configured with a service name and that the listner is running with that service name. ( on the db server $ORACLE_HOME/product/.../network/admin/tnsnames.ora, sqlnet.ora and listener.ora )
Then you can connect with the instant client by setting a TNS_ADMIN environemnet variable that points to the directory containing your tnsnames.ora for your client. It should contain an entry similiar to this sample file:
#-------------------------------------------------------
#-- C:\instantclient10_1\tnsnames.ora
#------------------------------------------------------
MYDB = (DESCRIPTION=
( ADDRESS= (PROTOCOL=tcp)(HOST=MYHOST)(PORT=1521) )
( CONNECT_DATA=(SERVICE_NAME=ORCL) )
)
#------------------------------------------------------
#-- End tnsnames.ora entry
#------------------------------------------------------
------------------------------
-- Sample connection jdbc url:
-----------------------------
jdbc:oracle:oci:@mydb
Hope this helps.
Britton
|
|
|
|