2011-06-22 6-1-7 Quantifiers

Quantifiers are used to describe the number or amount of something. Certain quantifiers are used with certain kinds of nouns.
The nouns on the left side are examples of countable nouns. They can follow “a” or “an” in the singular. Adding “s” or “es” makes them plural. The nouns on the right side are examples of uncountable nouns. They cannot follow “a” or “an” and cannot be made plural.  继续阅读

ASM ORA-01031: insufficient privileges.

when startup goldengate extract processes,  following errors showed in ggserr.log

2011-06-16 23:24:47  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, extgrp1.prm:  Establishing ASM session for login user SYS: (1031) ORA-01031: insufficient privileges.
2011-06-16 23:24:47  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extgrp1.prm:  PROCESS ABENDING.
2011-06-16 23:24:47  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, extgrp2.prm:  Establishing ASM session for login user SYS: (1031) ORA-01031: insufficient privileges.
2011-06-16 23:24:47  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extgrp2.prm:  PROCESS ABENDING.
2011-06-16 23:24:47  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, extgrp3.prm:  Establishing ASM session for login user SYS: (1031) ORA-01031: insufficient privileges.
2011-06-16 23:24:47  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extgrp3.prm:  PROCESS ABENDING.

继续阅读

PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option “-x” -

During ClusterWare installation , show following errors:

Network Time Protocol (NTP) – This task verifies cluster time synchronization on clusters that use Network Time Protocol (NTP). Error:
-
PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option “-x” – Cause: NTP daemon on one or more nodes lacked slewing option. – Action: Shut down and restart the NTP daemon after setting the slewing option as follows: For Linux, edit /etc/sysconfig/ntpd and add -x to the command line option. For SUSE Linux, edit /etc/sysconfig/ntp and add -x to the OPTIONS variable. For AIX, edit /etc/rc.tcpip and add -x to the command line option. For HP-UX, edit /etc/rc.config.d/netdaemons and add -x to the command line option. For Solaris, edit /etc/inet/ntp.conf and add ‘slewalways yes’ and ‘disable pll’ in ntp.conf. 继续阅读

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]