DevTech101

DevTech101

DB

How to change an Oracle Database from TCP to RDS on Infiniband

Changing an Oracle Database from TCP to RDS If your Oracle Database runs on an Infiniband network, you can greatly benefit by switching from TCP to RDS for DB cluster communications First enable RDS svcadm enable svc:/system/rds:default svcs svc:/system/rds:default STATE STIME FMRI online 4:40:52 svc:/system/rds:default For ASM On one node crsctl stop cluster -all On …

How to change an Oracle Database from TCP to RDS on Infiniband Read More »

Patching An Oracle RAC 11g/12c Grid(GI) / Database

Process to patch an Oracle 11G/12C RAC Grid infrastructure and or database Note1: Starting with OPatch version 11.2.0.3.14 , 12.1.0.2.12 and higher OCM Is Not bundled with OPatch .OPatch utility may be not look for ocm response file while patching in silent mode . Note2: In older versions the emocmrsp might be located under OPatch …

Patching An Oracle RAC 11g/12c Grid(GI) / Database Read More »

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

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 »

sqlite help

sqlite help http://www.sqlite.org/quickstart.html sqlite and perl inetrface http://zetcode.com/db/sqliteperltutorial/ http://perlmaven.com/simple-database-access-using-perl-dbi-and-sql

Compiling DBD driver for informix

Contents 1 DBD::Informix Install Procedure 1.1 General Information 1.2 Informix Client SDK Download Info 1.3 Misc Links 1.4 Environment Information 1.5 Build Procedure DBD::Informix Install Procedure General Information The majority of the procedure must run as user informix. Only the make install runs as root. Make sure that the IP/hostname of the build server is …

Compiling DBD driver for informix Read More »