月度归档:2011年05月

20110522

 

移植到4A,5A试饮杯中

A.Desire 10 棵

A.Yellow Beauty 17棵

A.紫长筒 20棵

A.Golden Jubilee 3棵

A.Charm 2棵

大天鹅 12棵

K.Rongo 3棵

K.hybird 15棵

K.拿破仑 9棵

K.未知 3棵

v$sql_plan format

set lines 121
set pages 999
col sql_text format a80
select sql_text from
v$sqltext_with_newlines
where hash_value=4041323804
order by piece;
set heading off
select ‘——————————————————————————–‘ from dual
union all
select ‘| Operation                                                    | PHV/Object Name     | Rows  | Bytes| Cost   |’ as "Optimizer Plan:" from dual
union all
select ‘——————————————————————————–‘ from dual
union all
select *
from (select
rpad(‘|’||substr(lpad(‘ ‘,1*(depth-1))||operation||
decode(options, null,”,’ ‘||options), 1, 62), 63, ‘ ‘)||’|’||
rpad(decode(id, 0, ‘—– ‘||to_char(hash_value)||’ —–‘
, substr(decode(substr(object_name, 1, 7), ‘SYS_LE_’, null, object_name)
||’ ‘,1, 20)), 21, ‘ ‘)||’|’||
lpad(decode(cardinality,null,’ ‘,
decode(sign(cardinality-10000), -1, cardinality||’ ‘,
decode(sign(cardinality-1000000), -1, trunc(cardinality/1000)||’K’,
decode(sign(cardinality-1000000000), -1, trunc(cardinality/1000000)||’M’,
trunc(cardinality/1000000000)||’G’)))), 7, ‘ ‘) || ‘|’ ||
lpad(decode(bytes,null,’ ‘,
decode(sign(bytes-1024), -1, bytes||’ ‘,
decode(sign(bytes-1048576), -1, trunc(bytes/1024)||’K’,
decode(sign(bytes-1073741824), -1, trunc(bytes/1048576)||’M’,
trunc(bytes/1073741824)||’G’)))), 6, ‘ ‘) || ‘|’ ||
lpad(decode(cost,null,’ ‘,
decode(sign(cost-10000000), -1, cost||’ ‘,
decode(sign(cost-1000000000), -1, trunc(cost/1000000)||’M’,
trunc(cost/1000000000)||’G’))), 8, ‘ ‘) || ‘|’ as "Explain plan"
from v$sql_plan
where hash_value = 3918835632)
union all
select ‘——————————————————————————–‘ from dual;

java.lang.UnsatisfiedLinkError: libawt.so: libXt.so.6 Missing

 

When installing Oracle Application Server 10.1.2.0.2 32bit on a 64bit Exdata Linux Machine , hit following errors:

Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2011-05-16_03-04-14AM/jre/1.4.2/lib/i386/libawt.so: libXt.so.6: cannot open shared object file: No such file or directory occurred..
java.lang.UnsatisfiedLinkError: /tmp/OraInstall2011-05-16_03-04-14AM/jre/1.4.2/lib/i386/libawt.so: libXt.so.6: cannot open shared object file: No such file or directory
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1560)
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1477)
        at java.lang.Runtime.loadLibrary0(Runtime.java:788)
        at java.lang.System.loadLibrary(System.java:834)

……

[usr01@machine01 i386]$ ldd libawt.so
ldd: warning: you do not have execution permission for `./libawt.so’
        linux-gate.so.1 =>  (0xffffe000)
        libmlib_image.so => not found
        libjvm.so => not found
        libXp.so.6 => /usr/lib/libXp.so.6 (0xf7cbc000)
        libXt.so.6 => not found
        libXext.so.6 => not found
        libXtst.so.6 => /usr/lib/libXtst.so.6 (0xf7cb5000)
        libX11.so.6 => not found
        libm.so.6 => /lib/libm.so.6 (0xf7c8e000)
        libdl.so.2 => /lib/libdl.so.2 (0xf7c8a000)
        libjava.so => not found
        libc.so.6 => /lib/libc.so.6 (0xf7b43000)
        /lib/ld-linux.so.2 (0x0094f000)
        libX11.so.6 => not found
        libXext.so.6 => not found
        libXau.so.6 => not found
        libX11.so.6 => not found
        libXext.so.6 => not found

check google and metalink , this error is caused by a 32bit library miss . (iAAS10.1.2.0.2 only has a 32bit version , when installing in a 64bit machine , just execute linux32 bash before runInstaller is ok)

solution:
install missing 32bit lib in 64bit machine.

rpm -ivh libXau-1.0.1-3.1.i386.rpm
rpm -ivh libXdmcp-1.0.1-2.1.i386.rpm
rpm -ivh libX11-1.0.3-11.el5.i386.rpm
rpm -ivh libSM-1.0.1-3.1.i386.rpm
rpm -ivh libICE-1.0.1-2.1.i386.rpm
rpm -ivh libSM-1.0.1-3.1.i386.rpm
rpm -ivh libXt-1.0.2-3.2.el5.i386.rpm
rpm -ivh libXext-1.0.1-2.1.i386.rpm

ref:
NOTE:726451.1 – Oracle Client Install issue on Linux Red Hat 5, gives "libXp.so.6 is missing" error message
JAVA.LANG.UNSATISFIEDLINKERROR Error Running Net Configuration Assistant [ID 1066299.1]