Himu\’s Attempt at Blogging

Tidbits from my thoughts

Archive for the ‘Uncategorized’ Category

2012 in review

leave a comment »

The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.

Here’s an excerpt:

4,329 films were submitted to the 2012 Cannes Film Festival. This blog had 56,000 views in 2012. If each view were a film, this blog would power 13 Film Festivals

Click here to see the complete report.

Written by mhimu

December 31, 2012 at 12:20 pm

Posted in Uncategorized

Oracle 11g EM & Password Expiry

with one comment

I’ve faced this issue twice now – passwords expired after a certain time by default in Oracle 11g. But this also messes up EM (dbconsole) by locking up SYSMAN (status shown as LOCKED(TIMED)). The following link has the details on how to deal with change of password of SYSMAN and DBSNMP in Enterprise Manager: https://forums.oracle.com/forums/thread.jspa?threadID=1011436

In short:

  1. Reset password and unlock SYSMAN
    1. sqlplus /nolog
    2. conn / as sysdba
    3. alter user sysman identified by <pass>
    4. alter user sysman account unlock
  2. Make EM pick up the change
    1. emctl stop dbconsole
    2. emctl setpasswd dbconsole
    3. emctl secure dbconsole
    4. emctl start dbconsole
  3. Fireup EM and log on using SYS as SYSDBA
    1. EM will ask to change all expired/soon-to-be-expired passwords
  4. For DBSNMP please see the given link above

Written by mhimu

February 6, 2012 at 5:03 pm

Posted in Uncategorized

with one comment

free counters

Written by mhimu

June 1, 2009 at 12:37 pm

Posted in Uncategorized

iSeries, Oracle Reports 10g and ODBC-JDBC

with one comment

I’ve been pulling my hair on this issue:

A complex sql with subqueries and a union written and executed OK in iSeriese Navigator for V5R4. Then I copied and pasted the same SQL in the query definition window of Oracle Reports Builder JDBC query dialog. The connection to iSeries is through the JDBC-ODBC bridge driver. I put :P_xxx parameters in the query.

Guess what? I got an error ‘Variable P_xxx not defined or not usable’.

Earlier, I tested using a simple query with a parameter and it worked fine. After a lot of head-scratching and trial-and-error, finally I got the solution:

Place a blank/space (‘ ‘) around the parameter(s) even if it is at the end of a line (not query)!

The parser seems to stumble upon detecting tokens without spaces.

Written by mhimu

February 3, 2009 at 12:02 pm

Posted in Uncategorized

Why Microsoft is so popular?

with one comment

The last time I used VB5 was back in the year 2000. I worked with VC++ and C++Builder during 2001. From then on, I have been working with Java (Eclipse, IDEA) without the AWT/Swing part. Java GUI always scared me.

Java SE, EE and ME have come a long way and J-lovers bark at Microsoft and .NET almost all the time. Yesterday, I wanted to make a list of files of a directory and decided to give VisualStudio (installed sometime ago) a try. To my surprise, I was able to develop a VB.NET windows application in just half-an-hour that allowed me to select a directory, list its files in a listbox and save it to a text file. I wanted to copy the list to the clipboard but that seemed like a bit of work.

So, after 6 years of Java programming, I was able to use VB.NET quite easily. The help system was indeed helpful. And everything seemed so intuitive. I hope Java GUI development will be that easy someday – or has it already?

Written by mhimu

November 29, 2007 at 10:32 am

Posted in Uncategorized

Hello world!

leave a comment »

Hello world! Completed customizing my site. I intend to work on it (i.e. post my thoughts) from time to time when I get the time. Hope someone finds my blog interesting to read. ­čÖé

Written by mhimu

August 7, 2007 at 11:33 am

Posted in Uncategorized