Skip to main content

Posts

Showing posts with the label Oracle

How to correct dbca error after OS migration for library missing

After migrating Oracle 10 installed in Solaris 8, we have the following issue when we execute the command dbca in Solaris 11 testing{oracle10}# cd /data/oracle10/cfgtoollogs testing{oracle10}# ./dbca Exception in thread "main" test{oracle10}42# Checking the trace log file we found that we have a missing libray "libdps.so.5 testing{oracle10}48# more trace.log java.lang.UnsatisfiedLinkError: /d2/ora10/jdk/jre/lib/sparc/motif21/libmawt.so: ld.so.1: java: fatal: libdps.so.5: open failed: No such file or directory         at java.lang.ClassLoader$NativeLibrary.load(Native Method)         at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1586)         at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1482)         at java.lang.Runtime.load0(Runtime.java:737)         at java.lang.System.load(System.java:811)         at java.lang.ClassLoader$NativeLibrary.load(Native Method)         at java.lang.ClassLoader.loadLibrary0(ClassLoader.ja

How to display information about the completed memory resize operations.

SET LINESIZE 500 set pagesize 80 SELECT l.latch#,        l.name,        l.gets,        l.misses,        l.sleeps,        l.immediate_gets,        l.immediate_misses,        l.spin_gets FROM   v$latch l WHERE  l.misses > 0 ORDER BY l.misses DESC;     LATCH# NAME                                                                   GETS     MISSES     SLEEPS IMMEDIATE_GETS IMMEDIATE_MISSES  SPIN_GETS ---------- ---------------------------------------------------------------- ---------- ---------- ----------        155 cache buffers chains                                             1.3477E+11  973105288    1316978     1.6868E+10          2066703  971673923        245 undo global data                                                 8386769783  127296652      22251              0                0  127274853        280 row cache objects                                                 753491792    2591911        392          34986                0    2591532        26

How to see top latches ordered by misses.

SET LINESIZE 500 SELECT l.latch#,        l.name,        l.gets,        l.misses,        l.sleeps,        l.immediate_gets,        l.immediate_misses,        l.spin_gets FROM   v$latch l WHERE  l.misses > 0 ORDER BY l.misses DESC ;     LATCH# NAME                                                                   GETS     MISSES     SLEEPS IMMEDIATE_GETS IMMEDIATE_MISSES  SPIN_GETS ----------- ---------------------------------------------------------------- ---------- ---------- ---------- -------------- ---------------- ----------         155 cache buffers chains                                             1.3477E+11  973105288    1316978     1.6868E+10          2066703  971673923         245 undo global data                                                 8386769783  127296652      22251              0                0  127274853         280 row cache objects                                                 753491792    2591911        392          34986