Sterling B2B Integrator與SAP互動 - 02 安裝配置

標籤：

系統組成：

1. 伺服器OS及硬體：

　　OS: Red Hat Enterprise Linux Server release 6.6

　　Hardware: Virtual Machine, x86_64，2 core, 8GB RAM, 100GB HDD

2. 軟體：

　　Java JDK 1.7.0 update 26

　　IBM DB2 Database V9.7 

　　Sterling B2B Integrator 5.2.4

 

　　繼續裝外掛程式

　　SAP Suite Adapter for JCo 3.x - 串連SAP系統

　　Oracle Database 11g Release 2 JDBC Drivers - 串連Oracle

 

3. 修改OS系統參數

修改參數 - 在Linux系統使用者可開啟檔案的最大數

[[email protected] ~]# vi /etc/security/limits.conf#*               soft    core            0#*               hard    rss             10000#@student        hard    nproc           20#@faculty        soft    nproc           20#@faculty        hard    nproc           50#ftp             hard    nproc           0#@student        -       maxlogins       4 * hard nofile 10240 * soft nofile 10240 * hard memlock 3000000 * soft memlock 3000000 * hard nproc 16000 * soft nproc 16000 * hard stack 512000 * soft stack 512000# End of file

 

資料庫參數

 

[[email protected] ~]$ ipcs -l------ Shared Memory Limits --------max number of segments = 1024max seg size (kbytes) = 4056980max total shared memory (kbytes) = 33554432min seg size (bytes) = 1------ Semaphore Limits --------max number of arrays = 1024max semaphores per array = 250max semaphores system wide = 256000max ops per semop call = 32semaphore max value = 32767------ Messages: Limits --------max queues system wide = 4096max size of message (bytes) = 65536default max size of queue (bytes) = 65536

 

核心參數

[[email protected] ~]$ cat /etc/sysctl.conf# Kernel sysctl configuration file for Red Hat Linux## For binary values, 0 is disabled, 1 is enabled.  See sysctl(8) and# sysctl.conf(5) for more details.# Controls IP packet forwardingnet.ipv4.ip_forward = 0# Controls source route verificationnet.ipv4.conf.default.rp_filter = 1# Do not accept source routingnet.ipv4.conf.default.accept_source_route = 0# Controls the System Request debugging functionality of the kernelkernel.sysrq = 0# Controls whether core dumps will append the PID to the core filename.# Useful for debugging multi-threaded applications.kernel.core_uses_pid = 1# Controls the use of TCP syncookiesnet.ipv4.tcp_syncookies = 1# Disable netfilter on bridges.net.bridge.bridge-nf-call-ip6tables = 0net.bridge.bridge-nf-call-iptables = 0net.bridge.bridge-nf-call-arptables = 0# Controls the default maxmimum size of a mesage queuekernel.msgmnb = 65536# Controls the maximum size of a message, in byteskernel.msgmax = 65536# Controls the maximum shared segment size, in byteskernel.shmmax = 68719476736# Controls the maximum number of shared memory segments, in pageskernel.shmall = 8589934592kernel.shmall = 8388608kernel.shmmni = 1024kernel.shmmax = 4154347520kernel.sem = 250 256000 32 1024kernel.msgmni = 4096kernel.msgmax = 65536kernel.msgmnb = 65536

預設核心參數對照表

 

Oracle驅動參數 - 設定資料庫連接

[[email protected] ~]$ cat /opt/app/gis/install/properties/jdbc_customer.properties.in## PROPERTY_FILE_NAME## jdbc_customer.properties.in (for initialization)## jdbc_customer.properties (for operations)## PROPERTY_FILE_DESCRIPTION## The jdbc_customer.properties file has the same settings as the jdbc.properties file. This allows## you to separate your customized database pool information (in jdbc_customer.properties) from the## pool information provided by Application (in jdbc.properties). This arrangement## has the following benefits:## * During an upgrade, you can copy your jdbc_customer.properties.in file instead of cutting##   and pasting your changes out of jdbc.properties.## * The application can make changes to the jdbc.properties file during a patch (if##   necessary) without changing a database pool that you added.## For information about the properties in the jdbc_customer.properties file, refer to## the documentation for the jdbc.properties file.## DATABASE_SUPPORT: N## Adding Database Pools## You can use the jdbc_customer.properties file to add a new database pool to the application## environment.  You can add this pool without having to restart the application, which lets## you continue running business processes.## To dynamically add a new database pool, do the following:## 1. Create the new pool in jdbc_customer.properties.## 2. Refresh the JDBC properties by doing one of the following:##    * Click the Refresh JDBC Pools button on the JDBC Monitor page.##    * Go the the [install_dir]/install/bin directory (UNIX/Linux) or the##      [install_dir]\install\bin directory (Windows) and run the following command:##      opscmd.sh/opscmd.cmd -cREFRESHJDBC -nnode1## 3. Use the Database Usage page to confirm that you have added the pool.TVCSHTestPool.driver=oracle.jdbc.OracleDriverTVCSHTestPool.url=jdbc:oracle:thin:@192.168.72.109:1521:TDBTVCSHTestPool.user=IPRTVCSH_TTVCSHTestPool.password=passwordTVCSHTestPool.catalog=TDBTVCSHTestPool.type=remoteTVCSHTestPool.testOnReserve=trueTVCSHTestPool.testOnReserveQuery=select ‘x‘ from dualTVCSHTestPool.testOnReserveInterval=60000TVCSHTestPool.max8177RetryCount=1TVCSHTestPool.dbvendor=oracleTVCSHTestPool.buffersize=nTVCSHTestPool.maxsize=10TVCSHTestPool.initsize=2TVCSHTestPool.behaviour=0TVCSHTestPool.lifespan=0TVCSHTestPool.idletimeout=86400000TVCSHTestPool.housekeepinginterval=3600000TVCSHTestPool.storedProcClassName=com.sterlingcommerce.woodstock.util.frame.jdbc.OracleNoAppStoredProcQueryTVCSHTestPool.varDataClassName=com.sterlingcommerce.woodstock.util.frame.jdbc.OracleVarDataTVCSHTestPool.factory=com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionFactory

 

 

 

Sterling B2B Integrator與SAP互動 - 02 安裝配置