mod_plsql

mod_plsql is an oracle module for Apache. Let’s do it from A to Z. I install HTTP server. In 10g, it is located on the companion cd and requires a separate oracle home. I copy my tnsnames.ora in COMPANIONHOME/network/admin Then, I configure COMPANIONHOME/Apache/modplsql/conf/dads.conf <Location /helloworld> SetHandler pls_handler PlsqlDatabaseUsername scott PlsqlDatabasePassword tiger PlsqlDatabaseConnectString LSC01 </Location> I […]

SOA

The seminar yesterday focused on SOA, Service Oriented Architecture. Teacher Michel Hascoët gave us an impressive demo with his notebook and JDeveloper; the SOA Workshop is usually taking four days, and for us he did it in one day. Ok, first ADF. With JDeveloper, he created with just a few clicks a connection to a […]

set my ORACLE_HOME, PATH, ORACLE_SID

I posted yesterday some of my aliases. My favorite (and most obfuscated) one is the following (for bash) eval $(awk -F: ‘/^[+a-zA-Z]/{l=tolower($1); sub(“^+”,””,l); print “alias “l”=47x=”$2″;PATH=${PATH//$ORACLE_HOME/$x}; ORACLE_HOME=$x; ORACLE_SID=”$1″; echo ORACLE_SID=”$1”; 47; “}’ /etc/oratab 2>/dev/null) I am setting my path and a default sid/home in my .profile [ -z “$ORACLE_SID” ] && export ORACLE_SID=LSC01 export ORACLE_HOME=$(sed […]