Author: Laurent Schneider

latest patchset

Huge downtime on forums.oracle.com today. After landing on an Error-500 page, I discovered a quick and neat overview of oracle patchsets, accessible without metalink account : http://www.oracle.com/technology/support/patches.htm Still waiting for 9.2.0.8 Solaris by the way, announced for 2006Q3, whatever this mean

sqlnet.wallet_override=true

I recently posted about Oracle Password Repository (OPR). I did get a comment from Andreas Piesk about something similar in Oracle, the wallet. Let’s do a quick test. First, I create a .sqlnet.ora in my home directory (I do not want to mess up the system-wide sqlnet.ora). $ cat /home/lsc/.sqlnet.ora SQLNET.WALLET_OVERRIDE=TRUE WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/home/lsc))) I now create […]

select last rows

I just read about a query to retrieve last modification row of a date SQL> SELECT ora_rowscn FROM tab_test; ORA_ROWSCN ———- 351744 351744 351744 351744 351744 351744 6 rows selected. SQL> UPDATE tab_test SET valeur=valeur*1.1 WHERE col_id=1; 3 rows updated. SQL> commit; Commit complete SQL> SELECT ora_rowscn FROM tab_test: ORA_ROWSCN ———- 351744 351744 351744 371423 […]

oas-console

oas-console Originally uploaded by laurentschneider. I installed OAS 10.1.3 on my notebook. Why? well, just to test if it is installable… and to justify my need of 2Gb of memory to my boss šŸ˜‰ Ok, SLES10 is not certified yet, Not even planned yet on metalink. But it will definitely be certified one day. The […]

indian readers

I am aware indian and pakistan ISP did block access to blogspot blogs. There are some workaround available on google, for example to access my site from Pakistan, you may be able to use pkblogs http://www.pkblogs.com/laurentschneider I am quite sad about this, I used to have a lot of access from India in the past […]

exp/imp

EXP / IMP has a quite a lot of bugs and limitations. Today I had a trouble with a function based index first, generating ORA-942 table does not exist on import. I also had an error with AQ. I have a few invalid objects too : before exp, on source system (tru64/9.2.0.4) SQL> select count(*) […]

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 […]

OCM preparation

The OCM 10g Upgrade is currently under development, and the OCM 10g exam should be available in May. How will I prepare for the 10g OCM? Part I, get confident with the environment : According to http://education.oracle.com/certification, the exam will be on redhat AS3 with DB 10.1.0.4. RHAS3 is not free. If I had not […]