DevTech101

DevTech101

OracleDB

Recommended Network Tuning For Oracle Database and Weblogic On Solaris

July 21, 2017 / By / Leave a Comment / solaris-11.3, solaris11.1, solaris11.2

Recommended performance tuning in Solaris 11 for Oracle DB and Weblogic Recommended Oracle Database Tuning. ipadm set-prop -p max_buf=16777216 tcp ipadm set-prop -p send_buf=2097152 tcp ipadm set-prop -p recv_buf=2097152 tcp ipadm set-prop -p _cwnd_max=2097152 tcp ipadm set-prop -p _conn_req_max_q=40000 tcp ipadm set-prop -p _conn_req_max_q0=40000 tcp #ipadm set-prop -p smallest_anon_port=10000 tcp #ipadm set-prop -p _time_wait_interval=10000 tcp …

Recommended Network Tuning For Oracle Database and Weblogic On Solaris Read More »

How to change an IP/subnet on Oracle RAC to use SDP instead of TCP

March 27, 2017 / By / Leave a Comment / DB, OracleDB

To configure SDP, Run the below commands If your Oracle Database runs on an Infiniband network, you can greatly benefit by switching from TCP to SDP for DB to app communications srvctl config scan_listener srvctl modify scan_listener   -p TCP:1521,/SDP:1521 lsnrctl status srvctl modify listener -l LISTENER  -p SDP:1521 Change the Oracle clusterware address crsctl stop …

How to change an IP/subnet on Oracle RAC to use SDP instead of TCP Read More »

NetBackup SAN Client Installation configuration

March 21, 2017 / By / Leave a Comment / NetBackup

Contents 1 Hardware Requirements 1.1 Before you start 2 NetBackup Media Server configuration 2.1 Make sure the NetBackup Media Server is running 6.52A 2.2 Unload the default HBA initiator drivers 2.3 Mark the ports used in target mode 2.4 Load the target mode driver 3 NetBackup SAN Configuration 3.1 SAN Port Configuration 3.2 Configure NetBackup …

NetBackup SAN Client Installation configuration Read More »

Oracle Ops center 12c Using Oracle DB 11g Troubleshooting

July 21, 2017 / By / Leave a Comment / Ops Center

Contents 1 Oracle Grid infrastructure Notes 1.1 Grid install 1.2 Helpful commends 1.3 DB session / process tuning 2 Appendix A 3 Appendix B 4 Appendix C 5 References Oracle Grid infrastructure Notes Doing the install, Oracle ASM allocation unit size was set to 8 Grid install The doc/patch number at supporthtml.oarcle.com is: 10404530 The …

Oracle Ops center 12c Using Oracle DB 11g Troubleshooting Read More »

Sun Web Server 7 PHP-PDO Oracle – Informix extension installation and configuration

May 10, 2017 / By / Leave a Comment / php

Note: The PHP plug we use on the intranet today taken from here and here, will not work with Informix-PDO Because it was compiled with Thread Safety: Enabled and Informix-PDO compiles with Thread Safety: Disabled causing a mismatch Contents 1 Sun Web Server PHP installation 2 Oracle PHP-PDO installation 3 Informix PHP-PDO installation 4 Cool …

Sun Web Server 7 PHP-PDO Oracle – Informix extension installation and configuration Read More »