Error will come JSP Page and Login Page:-
sol: just restart the applmgr services.
Ex: $ adstpall.sh apps/apps
$ adstrtal.sh apps/apps
RW-50015: Error: - JSP is not responding. The service might not have started on the port yet.
Solution:
1) Shut all application services.
2) create the below link for library file as below
ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2
3) Startup all application services
or
Download the os patch from metalink:
Note ID: 564174.1
patch number:6078836
*****************************************************************************************************
Error: (os = RHEL5.3 Application = R12 )
FRM-92101: There was a failure in the Forms Server during startup. This could happen due to invalid configuration.please look into web - server log files for details.
click on Details:
Cause:
missing library links libXp.so.6
Solution:
There can be various reasons for this error.
This is a generic error and indicates disconnection from client and user.
We can check the following:
- Forms Version (5 digits)
- java Version
- client OS
- When did this started to happen / any changes implemented recently?
- Are you using a firewall / load balancer / emulators?
(or)
Install the following RPM's in
[root@ravi D]# rpm -ivh openmotif21-2.1.30-11.EL5.i386.rpm Preparing... ########################################### [100%]
1:openmotif21 ########################################### [100%]
[root@ravi D]#
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm
libXp-1.0.0-8.i386.rpm
Note: There is no way to customize like FRM-92101, FRM-92102 error messages because they are they are hard coded in the forms jar files.
Error:
When login to the applications, getting the below error:
FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508
Solution-1: Generate Jar Files on Web tier and bouncing the web tier services
Solution-2:
1) Delete the CUSTOM.pll and CUSTOM.plx in $AU_TOP/resource
2) Re-create the soft links for CUSTOM.pll and CUSTOM.plx in $AU_TOP/resource
3) Compile the CUSTOM.pll (f60gen module=CUSTOM.pll userid=apps/xxxx output_file=$AU_TOP/resource/CUSTOM.pll module_type=library)
******************************************************************
Opatch Error:
inventory_loc=/cnv2001/app/oracnv2/product/9.2.0/inventory/
Updating inventory...
Verifying patch...
Verifying that patch ID is in Oracle Home inventory.
INVENTORY PROBLEM: Patch 5496862 is not present in Oracle Home inventory.
Verifying archive files.
Comparing "/cnv2001/app/oracnv2/product/9.2.0/OPatch/5496862/files/lib/libgeneric9.a/skgfr.o" and "/cnv2001/app/oracnv2/product/9.2.0/.patch_storage/verify/lib/libgeneric9.a/skgfr.o"
OPATCH_JAVA_ERROR: Patch was not successfully applied.
Verification of the patch failed.
log : "/cnv2001/app/oracnv2/product/9.2.0/.patch_storage/5496862/Apply_5496862_10-07-2008_05-34-16.log"
Solution:
export OPATCH_SKIP_VERIFY=TRUE
opatch apply
*****************************************************************
Oracle Forms Web CGI: Error detected
Your request cannot be serviced at this time due to the following error:
ERROR: URL Contains One or More Restricted Characters
Solution-1:
Comment FORMS60_BLOCK_URL_CHARACTERS in $IAS_ORACLE_HOME/Apache/Apache/conf/apps.conf for turnaround
For permanent solution, comment
$IAS_ORACLE_HOME/appsutil/template/Apache/Apache/conf/apps.conf
or
$AD_TOP/admin/template/adxmlctx.tmp
*************************************************************************
Error: There are no active responsibilities available for this user
Solution:
UPDATE fnd_profile_option_values SET profile_option_value = 2
WHERE profile_option_id = (SELECT profile_option_id FROM fnd_profile_options a, fnd_profile_options_tl b
WHERE a.profile_option_name = b.profile_option_name
AND user_profile_option_name = 'Node Trust Level' and language='US');
*******************************************************************************
While opening the Web browser (Frontend),
Error:
Request URI:/OA_HTML/AppsLocalLogin.jsp
Exception:
java.lang.UnsupportedClassVersionError: _oa__html/_AppsLocalLogin (Unsupported major.minor version 49.0)
Solution:
Ran txkrun.pl -force=Yes -script=SetJDKCfg -contextfile=$CONTEXT_FILE -runautoconfig=Yes -appspass=***** -jdktop=/usr/java5 on cmtier and webtier
-run autoconfig on all tiers
-bounced the DataBase.
-bounce Apache server
****************************************************************************
Error after login to applications (mostly after clone or autoconfig):
Request URI:/OA_HTML/AppsLocalLogin.jsp
Exception:
java.lang.NoClassDefFoundError: oracle.apps.fnd.profiles.Profiles (initialization failure)
Solution:
Disable Java caching feature :
- Comment out the following in jserv.properties file
-------------------
JMS & WF
#wrapper.bin.parameters=-DLONG_RUNNING_JVM=true
--------------
- Bounce the Apache Server
*************************************************************************************
java pointing error.... JSP Error
Issue: PATH was not pointing to the /usr/java5
The Javahome was incorrect, vide repfort below:
aptst4@phls6824:>which java
/tst4002/app/aptst4/comn/java14/bin/java
aptst4@phls6824:>java -version <--------------- Older version
java version "1.4.2"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2)
Classic VM (build 1.4.2, J2RE 1.4.2 IBM AIX build ca142-20050929a (SR3) (JIT enabled: jitc))
aptst4@phls6824:>cd /usr/java5/bin
aptst4@phls6824:>./java -version <-------------------- Should be the right one
java version "1.5.0"
Java(TM) 2 Runtime Environment, Standard Edition (build pap32devifx-20100128a (SR11 FP1 ))
IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 AIX ppc-32 j9vmap3223ifx-20100128 (JIT enabled)
J9VM - 20100122_52103_bHdSMr
JIT - 20091016_1845ifx1_r8
GC - 20091026_AA)
JCL - 20100128
Solution:
1) change the .profile $PATH value to point to the most recent $JAVA_TOP (/usr/java5)
2) Relogin to Aptst4 user to point to the new Javahome
3) execute the following command:
txkrun.pl -force=Yes -script=SetJDKCfg -contextfile=/tst4002/app/aptst4/appl/admin/OLMTST04_phls6824.xml runautoconfig=Yes appspass=********* -jdktop=/usr/java5
4) reset the $APACHE_TOP/Apache/url_fw.conf file to the customized one.
5) Bounce the Apache Server.
*************************************************************************************
Issue: Error While Compiling invalid Objects in 11g
Error Message: Errors with ORA-00904: "E"."OBJNUM": invalid identifier
Doc id : 778879.1
Solution:
1. Connected as SYS with SYSDBA privilages execute the following statement :-
SQL> desc sys.enabled$indexes;
2. IF sys.enabled$indexes table exists THEN drop it.
SQL> drop table sys.enabled$indexes
3. Please run following SQL statement to re-create sys.enabled$indexes table. Make sure that you are still connected to SQL as user SYS & run following sql command :-
SQL> CREATE TABLE sys.enabled$indexes( schemaname, indexname, objnum )
AS select u.name, o1.name, i.obj# from user$ u, obj$ o1, obj$ o2, ind$ i
where u.user# = o1.owner# and o1.type# = 1 and o1.obj# = i.obj#
and bitand(i.property, 16)= 16 and bitand(i.flags, 1024)=0
and i.bo# = o2.obj# and bitand(o2.flags, 2)=0;
4. Connected to SQL as user SYS once again run UTLRP.SQL.
SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql
**********************************************************************************
--------------------------
Connected.
Checking for existence of the ACL ....
No ACL exists for this, creating a new one ....
DECLARE
*
ERROR at line 1:
ORA-30554: function-based index XDB.XDB$ACL_XIDX is disabled
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 252
ORA-06512: at line 36
ORA-01403: no data found
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
txkcreateACL.sh: exiting with status 1
.end std out.
.end err out.
Solution : Rebuild the indexes.
*********************************************************************************
Hang the DataBase :
Today We faced an issue, where an database process is kicking off again and again even we killed that in Database level.I identified that process was running as part of job in database (As the process corresponds to background process – j000 ) and followed the below procedure to kill that session.
I identified the job as ’203' ,SID as ’80' and username as ‘APEX_PUBLIC_USER’ etc., from dba_jobs_running using below query.
select jr.job,s.username,s.sid,s.lockwait,s.logon_time
from dba_jobs_running jr,v$session s
where jr.sid = s.sid
order by jr.job;
I used below query to broke the job before killing the session.
SQL> BEGIN SYS.DBMS_IJOB.BROKEN(’203',TRUE);
2 / END;
PL/SQL procedure successfully completed.
and used below command to kill the session and ensured no process is further kicked off..
alter system kill session ‘SID,SERIAL#’;
Helpful Metalink Docs :
How to kill a hung automated materialized view refresh job : 341842.1
ORA-23421 OR ORA-03421 TRYING TO ALTER A JOB : 1029977.6
**************************************************************************
Gather Schema stats Issue in 11g
Gather Schema Stats program failed in OLMTST05. Reuqest ID - 1775545
Following is error
In GATHER_SCHEMA_STATS , schema_name= ALL percent= 10 degree = 8 internal_flag= NOBACKUP Error #1: ERROR: While GATHER_TABLE_STATS: object_name=APPS.BIN$hTyukbG1gMrgQ6wcI4uAyg==$0***ORA-20001: BIN$HTYUKBG1GMRGQ6WCI4UAYG==$0 is an invalid identifier*** Error #2: ERROR: While GATHER_TABLE_STATS: object_name=APPS.BIN$hTyukbG1gMrgQ6wcI4uAyg==$0***ORA-20001: BIN$HTYUKBG1GMRGQ6WCI4UAYG==$0 is an invalid identifier***
Solution;
Report below is for root cause analysis.
select tname from tab;
select object_name, original_name, type, droptime from recyclebin;
STATT TABLE_NAME STA
----- ------------------------------ ---
BIN$cjgR7nHD0OrgQ6wcI2jQ6g==$0
BIN$cjgR7nHJ0OrgQ6wcI2jQ6g==$0
BIN$cjg9M1VmkNLgQ6wcI2iQ0g==$0
BIN$cjg9M1VskNLgQ6wcI2iQ0g==$0
BIN$hSZUf/BEkB7gQ6wcI4uQHg==$0 NO
BIN$hSZYJSB8IC7gQ6wcI4sgLg==$0 NO
BIN$hSZYD6hwoJTgQ6wcI4uglA==$0 NO
BIN$hSZp9NlwYP7gQ6wcI4tg/g==$0 NO
BIN$hSacIO62IAjgQ6wcI4sgCA==$0 NO
BIN$hSad5MCe8IbgQ6wcI4vwhg==$0
BIN$hSafmb1JgPTgQ6wcI4uA9A==$0 NO
BIN$hSbBrmYCoPDgQ6wcI4ug8A==$0 NO
ERROR:
ORA-20001: BIN$HSLETBW2SGRGQ6WCI4UWAG==$0 is an invalid identifier
ORA-06512: at "SYS.DBMS_STATS", line 1989
ORA-06512: at "SYS.DBMS_STATS", line 2005
ORA-06512: at "SYS.DBMS_STATS", line 24669
ORA-06512: at line 1
These BIN$ objects are recycle bin objects from 11g DBMS.
This have caused most possibly because, some of the tables might have been dropped and the recycle bin was not cleaned-up.
Recyclebin has to be purged.
***********************************************************
ORA-01092: ORACLE instance terminated. Disconnection
forced
ORA-00942: table or view does not exist.
ORA-01031: insufficient privilege
Ora-30014: operation only supported in Automatic Undo Management mode
Sol:
SQL> show parameter undo_management
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string MANUAL
SQL>ALTER SYSTEM SET undo_management=AUTO SCOPE=[SPFILE/both/memory];
Scope = spfile
means whenever restart the database it will perform.
Scope = both means
on that time and after restart also be perform.
Scope = memory means on before closing that terminal.
*************************************************************************
ORA-09817:write to audit file failed.
Linux Error: 28: No space left on device
ORA-09945:Unable to initialize the audit trail file
Sol :
Check the mount
point space.
************************************************************************
_allow_resetlogs_corruption=TRUE
By using this parameter if any corruption occur in redo log files while Database startup time we can open the Database.
Step1: define parameter in pfile.
Step2: SQL>STARTUP MOUNT pfile='/././.'
Step 3: try to open the database. if it is not open then RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
Step 4: open the database by using RESETLOGS.
=======================================
======================================
APP-FND-01516 INVALID APPLICATION USERNAME, PASSWORD, OF DATABASE
Username : APPLSYSPUB
Password : PUB
Database : PROD
Solution:
Check the Database listener is up & running or not.
