On Thursday, Oct 17, 2002, at 17:01 US/Pacific, Troy Simpson wrote: > Inorder to utilized the jdbc-oci drivers I believe that you actually > need an Oracle Client. More binaries are > required then the ones supplied at: > http://otn.oracle.com/software/tech/java/sqlj_jdbc/htdocs/ > jdbc9201.html. > But you can still use the jdbc:oracle:thin client with out the full > OracleClient.
Correct. Here's what I got from one of my QA engineers who did the installation here. I hope it helps others! > �1. Install Oracle Client in the server where the CF/MX Server is > running. > > 2. Ensure that you have the right version of Oracle OCI driver is > installed, say in the directory /fs0/app/oracle/product/9.2/lib > �� Note: The OCI driver files will be with the extention .so .o .jar .a > .zip > > 3. Ensure that the CF/MX server start up file > /data/www/appserver/cfusionmx/bin/coldfusion has the following shell > parameters defined with the following path information > > �� Note: Modify this with the right path for oracle in your server > ������� > PATH=$PATH:/bin:/sbin:/usr/bin:/usr/sbin:/fs0/app/oracle/product/9.2/ > bin > > LD_LIBRARY_PATH="$CF_DIR/lib:$CF_DIR/lib/_solaris/bin:/fs0/app/oracle/ > pr > oduct/9.2/lib" > > TNS_ADMIN=/fs0/app/oracle/product/9.2/network/admin > > And they are properly included in the start up script > > CFSTART='su $RUNTIME_USER -s /bin/sh -c "export > LD_ASSUME_KERNEL=2.2.9; export PATH=$PATH:$CF_DIR/runtime/bin; export > LD_LIBRARY_PATH=$LD_LIBRARY_PATH; nohup $CF_DIR/bin/cfusion > -autorestart -start default &"' > > 4. Ensure that the TNS netadmin file, > /fs0/app/oracle/product/9.2/network/admin/tnsnames.ora has the TNS name > defined for the oracle instance you are trying to associate with the > data source name you intend to create in the format > > ��������������� <TNSNAME>.MACROMEDIA.COM =� (DESCRIPTION = > (ADDRESS_LIST =� (ADDRESS = (PROTOCOL = TCP) > �������������������� (HOST = <DBSERVER_NAME>.macromedia.com)(PORT = > 1521))) > �������������������� (CONNECT_DATA =(SERVICE_NAME = <ORACLE_SID>))) > > �5. Once all the above things are in place, create Data Source Name > thru > CF/MX Admin screen > > ��������������� CF Data Source Name������� :��� <Data_Source_Name> > ��������������� JDBC URL������������������ : > jdbc:oracle:oci:@<TNSNAME>.macromedia.com > ��������������� Driver Class�������������� :��� > oracle.jdbc.OracleDriver > ��������������� Driver Name��������������� :��� Oracle 9i OCI driver > ��������������� Usenname������������������ :��� <Oracle User Name> > ��������������� Password������������������ :��� <Oracle Password> > ��������������� Description��������������� :��� <Description> > ��� > ��� And enable the CLOB (if needed BLOB> in the 'Advanced Settings' in > the D.S.Name Configuration page. > � > � After completing all the above 5 steps, this Data Source Name > <Data_Source_Name> ready to use. "Conform! Consume! Obey!" -- Mr Snaffleburger : http://www.matazone.co.uk/theotherside.html ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
