分类目录归档:工作

EBS, visit homepage, 500 Internal Server Error

restore a 11203 database backup, not change appl files.

visit the EBS login page
http://server:port/

500 Internal Server Error
Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.

check $INST_TOP/logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log
find following errors

12/05/02 00:04:26.497 html: Servlet error
java.lang.ExceptionInInitializerError
at oracle.apps.fnd.sso.Utils.(Utils.java:664)
at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:116)
at oracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpApplication.loadServlet(HttpApplication.java:2379)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4830)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpApplication.findServlet(HttpApplication.java:4754)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpApplication.getRequestDispatcher(HttpApplication.java
:2978)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.ja
va:738)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java
:453)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResource
PooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
Caused by: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDSECUR
ITY_APPL_SERVER_ID
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1509)
at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:362)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:211)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:171)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148)
at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1294)
at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1149)
at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1118)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1085)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1072)
at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:595)
at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:593)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:570)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:524)
at oracle.apps.fnd.common.AppsContext.(AppsContext.java:292)
at oracle.apps.fnd.common.WebAppsContext.(WebAppsContext.java:1095)
at oracle.apps.fnd.sso.Utils.getAppsContext(Utils.java:539)
at oracle.apps.fnd.sso.SessionMgr.loadInstalledLanguages(SessionMgr.java:3875)
at oracle.apps.fnd.sso.SessionMgr.getInstalledLanguages(SessionMgr.java:3693)
at oracle.apps.fnd.sso.Utils.getBaseInstalledLangCode(Utils.java:1476)
at oracle.apps.fnd.sso.Authenticator.(Authenticator.java:45)
… 17 more
Caused by: oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDSECURITY_APPL_SERVER_ID
at oracle.apps.fnd.security.DBConnObj.(DBConnObj.java:246)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1273)
at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:1027)
at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:584)
at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:301)
at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1719)
at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2266)
at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2203)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2061)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1871)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1715)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1728)
at oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1453)
at oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:170)
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1500)
… 37 more

check db connection using sqlplus

$ sqlplus apps/apps@vis1

SQL*Plus: Release 10.1.0.5.0 – Production on Wed May 2 00:19:00 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Data Mining
and Real Application Testing options

SQL>
……..OK

check db connection using
http://host:port/OA_HTML/jsp/fnd/aolj_native_conn_test.jsp
….OK

search FNDSECURITY_APPL_SERVER_ID in metalink
find following notes
Cannot Complete Applications Logon Error When Trying to Access the Personal Home Page in 11.5.10 (Doc ID 297165.1)

check dbc file, in $INST_TOP/appl/fnd/12.0.0/secure

[apps@slcc01db01 secure]$ java oracle.apps.fnd.security.AdminAppServer apps/ STATUS DBC=$FND_TOP/secure/_.dbc

-bash: apps: No such file or directory
$ java oracle.apps.fnd.security.AdminAppServer apps/apps STATUS DBC=$INST_TOP/appl/fnd/12.0.0/secure/VIS.dbc

Database Server
—————
DATABASE_ID: VIS
AUTHENTICATION: SECURE

Application Server
——————
APPL_SERVER_STATUS: INVALID
APPL_SERVER_ID: BE55F0DAD9FD799AE0434840F20A504835206050571755234233375501553514

……INVALID

check VIS.dbc update date, is Apr-24, seems changed by newer version …

redo adconfig
$cd /apps/visappl/ad/12.0.0/bin
$./adconfig.sh contextfile=/apps/visinst/@@/appl/admin/@@.xml appspass=apps
$./adconfig.sh contextfile=/apps/visinst/@@/appl/admin/@@.xml appspass=apps

$ java oracle.apps.fnd.security.AdminAppServer apps/apps STATUS DBC=$INST_TOP/appl/fnd/12.0.0/secure/VIS.dbc

Database Server
—————
DATABASE_ID: VIS
AUTHENTICATION: SECURE

Application Server
——————
APPL_SERVER_STATUS: VALID
APPL_SERVER_ID: BF08D1A8342D3BA2E0434940F20AEDE731393517292025862455146256984412

http connect to login page , ok

从11.1.0.7 32bit ASM OMF rman backup恢复数据到11.1.0.7 64bit filesystem OMF

 

准备工作
安装64bit软件
Install 11.1.0.6 db software
Upgrate to 11.1.0.7

复制rman备份到新机器
复制init.ora到新机器,修改相关路径如下

*.control_files=’/apps/oradata/DESTDB/controlfile/control01.ctl’
*.db_create_file_dest=’/apps/oradata’
*.db_create_online_log_dest_1=’/apps/oradata’

开始恢复
继续阅读

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]