If you already have a 10g database setup and running without the JVM (Java Virtual Machine) installed and later descide you want to add say OWB (Oracle Warehouse Builder) to you instance then you need to get JVM working first. It's not that complicated realy but follow these steps laid out in Metalink (Doc-ID:276554.1) if you want to get it right first time.
January 2009 Archives
A friend pointed me at this interesting blog (The Go-Faster Oracle Blog), which has some useful links to performance tools. Analyzing an Oracle database without having the Enterprise Manager either installed or maybe not available to you can be a nightmare. He has developed some Excel sheets, which access the AWR data and output graphics and more right down to individual session analysis. Very useful tool-set, so take a look.
If you are trying to setup an Oracle instance for running OWB then you will need to set the remote_login_passwordfile to EXCLUSIVE in order for that to work. Using SQLPLUS connect to the instance and change the setting like this:
> sqlplus /nolog
SQL> connect / as sysdba
SQL> alter system set remote_login_passwordfile=EXCLUSIVE scope=spfile;
that should do the trick although you will need to bounce the instance before it will take effect.
You may also need to re-generate the sys password file like this:
SQL> orapwd file=orapwinst password=pwd123 force=y
