星期五, 7月 28, 2017

Oracle 12c/11g Client 的軟體下載與手冊與Tomcat 環境建議

Oracle 12c R2 Client Download for Linux
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-linux-12201-3608234.html

Oracle 12c R2 Client Download for Aix
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-aix-12201-3677038.html

Oracle 12c R2 Client Download for Solaris
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-sparc-12201-3608235.html

Oracle 11.2.0.4 Client Download Patchset 13390677 (p13390677_112040_platform_4of7.zip)
https://updates.oracle.com/download/13390677.html (需要有Oracle Support帳號)
 Oracle Database Client p13390677_112040_platform_4of7.zip

Oracle Client 安裝方式
http://sajidkhadarabad.blogspot.tw/2015/09/oracle-12c-linux-client-64-bit-step-by.html

*以Oracle所建議的support matrix, 如果要能夠連接12c R2 (12.2) Database, Oracle Client最低版本要求為 11.2.0.3 or 11.2.0.4
*update 2018/3/9 
要連到 18c database, Oracle Client最低版本要求亦為 11.2.0.3 or 11.2.0.4

ref: Oracle Client 最小要求版本為11.2.0.3 or 11.2.0.4 (11g R2 Client)
Client / Server Interoperability Support Matrix for Different Oracle Versions (Doc ID 207303.1)
--
Tomcat 8 (jdk 1.8) 下載與安裝方式
https://oracle-base.com/articles/linux/apache-tomcat-8-installation-on-linux

Oracle JDBC Driver 連接建議
若從Tomcat 6 / 7 / 8開發程式需要連接新的oracle 資料庫 例如11g/ 12c Oracle DB
只要確認您的openJDK為相容的最低要求版本、並搭配ojdbc6.jar 就可以連接到11g/ 12c Oracle DB

Oracle JDBC Driver 連接注意事項
1.原環境把ojdbc14.jar 替換為ojdbc6.jar 就可以連接

2.在DB 端需要修改$ORACLE_HOME/network/admin/sqlnet.ora 設定 SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
  ref: Oracle 9i/10g Client 透過odbc連12c DB 無法連線 ORA-28040 no matching authentication protocol
       http://jaychu649.blogspot.tw/2017/07/oracle-9i10g-client-odbc12c-db-ora.html
  ref: Copy ojdbc6.jar and ucp.jar into $TOMCAT_HOME/lib directory.
       http://www.oracle.com/technetwork/articles/oem/ucp-jdbc-tomcat-355431.html
  ref: Tomcat 6/7/8 所限制的mininal java 開發環境 (tomcat 7 可支援 openjdk 1.7 、openjdk 1.6、tomcat 8 可支援 openjdk 1.7)
       http://tomcat.apache.org/whichversion.html

Oracle JDBC Driver 8下載連結 (ojdbc8.jar 下載後放置到tomcat資料夾的lib資料夾)
http://www.oracle.com/technetwork/database/features/jdbc/jdbc-ucp-122-3110062.html

Oracle JDBC Driver 7下載連結 (ojdbc7.jar 下載後放置到tomcat資料夾的lib資料夾)
http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html

Oracle JDBC Driver 6下載連結 (ojdbc6.jar 下載後放置到tomcat資料夾的lib資料夾)
http://www.oracle.com/technetwork/apps-tech/jdbc-112010-090769.html

Instant Client Package - Precompiler (v12.2.0.1.0) download
http://www.oracle.com/technetwork/topics/precomp-112010-084940.html

Oracle® Database Client Installation Guide 12c Release 2 (12.2) for Linux
https://docs.oracle.com/database/122/LACLI/LACLI.pdf

Database Database Client Installation Guide for IBM AIX on POWER Systems (64-Bit) 
https://docs.oracle.com/database/122/AXCLI/AXCLI.pdf

PS. Oracle PRO*C precomplier 通常是跟Oracle Client一起進行安裝, PROC 設定可以參考此連結 :
 安裝Oracle 12c Client 與Pro*C Precompilers 的方法
 http://jaychu649.blogspot.tw/2017/07/oracle-12c-client-proc-precompilers.html

關於開發者可能會需要在Solaris / Oracle Linux 安裝所需的Oracle JAVA JDK套件
Oracle Developer Studio and Oracle Solaris Studio Component Matrix 
http://www.oracle.com/technetwork/server-storage/solarisstudio/training/index-jsp-141991.html

Download Oracle Developer Studio
https://www.oracle.com/tools/developerstudio/index.html

關於Oracle 12.2 的線上文件總連結
https://docs.oracle.com/database/122/

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...