Friday 3 August 2007

~50th Oracle 10g install, still seeing error

This is approximately my 50th Oracle 10g install, was little surprised when I saw error during this install.

Don't be too shocked, this time my Sys Admin let me down, he did not install some basic packages required by Oracle (that we previously agreed will be in OS install list). My kind Sys Admin installed those packages, things started to work like a dream.

1. UnsatisfiedLinkError
$ xterm opens fine but dbca/netca does no work, gives error!

[oracle@lnx-field ~]$ dbca
UnsatisfiedLinkError exception loading native library: njni10
Exception in thread "main" java.lang.UnsatisfiedLinkError: get
at oracle.net.common.NetGetEnv.get(Native Method)
at oracle.net.config.Config.getNetDir(Unknown Source)


Fix was: Install libgcc (and libstdbc++-devel) RPM (make sure 64 bit and 32 are there)
e.g.
up2date --arch i386 expat fontconfig freetype glibc-devel libgcc xorg-x11-deprecated-libs xorg-x11-libs xorg-x11-Mesa-libGL zlib libaio


Fix 2 was:
Got this again on Aug 2008, this time after lib install make sure to reinstall the software (or maybe you can just relink), I did the full software re-install of Oracle, since it onlye takes 15 min.

2. TNS: Lost Contact
Got following error during db creation via dbca (afte hitting Create DB), error came up on pop up.

ORA-12547: TNS:lost contact

Fix was: Install libaio RPM


3. Error towards end of 10g install (20 Aug 2007)
Failed to allocate port(s) in the specified range for the following process(es): JMS [5540-5559], RMI [5520-5539], Database Control [5500-5519], EM agent [3938] [1830-1849]
Could not complete the configuration. Refer to the log file for details.


Fix was: fix the /etc/host file make sure IP and hostname is correct.



4. Error ORA-00600 during startup (24 Aug 2007)
open_cursors = 300
pga_aggregate_target = 402653184
Thu Aug 23 17:07:03 2007
Errors in file /u01/oracle/admin/P1AR/udump/p1ar_ora_5067.trc:
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
USER: terminating instance due to error 600
Instance terminated by USER, pid = 5067


Fix was: Make sure /etc/sysconfig/network is correct (hostname was different).
Why error: Sys Admin changed hostname few days ago, only after OS restart error started happening.


5. Oracle Install logs (dbca)
/u01/oracle/product/10.2.0/cfgtoollogs/dbca/SID

No comments: