<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=ISO-8859-1">
<STYLE type=text/css>
<!--
.message {background: white; font-size:9pt; font-family:'Arial';}
.message p { margin-top: 0em; margin-bottom: 0em; }
-->
</STYLE>
</HEAD>
<BODY class='message' bgColor=#ffffff>
Hi all<br /><br />When using Instant client with Oracle xe/ MGOS / King provider , there are some additional steps like setting up the TNSnames.ora etc . I have oracle xe installed on my standlone system<br /><br />Can anybody please send me a sample / commented file , on how to setup it up <br /><br />I am facing problems connecting Oracle with MGOS. I have all the instant client files installed properly , but i guess i have not setup TNSNAMES etc right. <br /><br /><br /><br />Haris (sl-king / king oracle , who is helping me with problem) in his readme file had said the following, which i am not able to setup <br /><br />from Haris's readme file<br />********************************************************<br />If you use King.Oracle Instant client you need to check connection string ( use TNS name or sql connection)<br />Here is Oracle documentation about that:<br />----------------------------------- From Oracle Documentation -----------------------------<br />Database Connection Names for Instant Client<br />All Oracle net naming methods that do not require use of ORACLE_HOME or TNS_ADMIN to locate configuration files such as tnsnames.ora or sqlnet.ora work in the Instant Client mode.<br />The connectString parameter in the createConnection() call can be specified in the following formats:<br />As an SQL Connect URL string, of the form:<br />//host:[port][/service name]<br /><br />such as:<br />//myserver111:5521/bjava21<br /><br />As an Oracle Net keyword-value pair. For example:<br />(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=myserver111) (PORT=5521))<br />(CONNECT_DATA=(SERVICE_NAME=bjava21)))<br /><br />As a connection name that is resolved through Directory Naming when the site is configured for LDAP server discovery.<br />As an entry in the tnsnames.ora file.<br />If the TNS_ADMIN environment variable is not set, and TNSNAMES entries such as inst1 are used, then the ORACLE_HOME variable must be set and the configuration files are expected to be in the $ORACLE_HOME/network/admin directory.<br />Naming methods that require TNS_ADMIN to locate configuration files continue to work if the TNS_ADMIN environment variable is set.<br />The ORACLE_HOME variable in this case is only used for locating Oracle Net configuration files, and no other component of OCCI Client Code Library uses the value of ORACLE_HOME.<br />----------------------------------- End of Oracle Documentation -----------------------------<br /><br />********************************************************<br /><br /><br />my TNSnames.ora looks like this <br /><br />XE =<br /> (DESCRIPTION =<br /> (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER)(PORT = 1521))<br /> (CONNECT_DATA =<br /> (SERVER = DEDICATED)<br /> (SERVICE_NAME = XE)<br /> )<br /> )<br />EXTPROC_CONNECTION_DATA =<br /> (DESCRIPTION =<br /> (ADDRESS_LIST =<br /> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))<br /> )<br /> (CONNECT_DATA =<br /> (SID = PLSExtProc)<br /> (PRESENTATION = RO)<br /> )<br /> )<br />ORACLR_CONNECTION_DATA = <br /> (DESCRIPTION = <br /> (ADDRESS_LIST = <br /> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) <br /> ) <br /> (CONNECT_DATA = <br /> (SID = CLRExtProc) <br /> (PRESENTATION = RO) <br /> ) <br /> ) <br /><br /><br /><br />-Thanks <br /><br />
</BODY></HTML>