Clone E-business suite and grid control problem

When discovering oracle applications on grid control 10.2.05, you encounter error "Wrong System Name" or "Waited for five minutes" and you see the context file mentioned on the log is not correct, then
1. Source your environment for EBusiness Suite instance.
2. Run sqlplus as apps user
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;
3. Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers, to repopulate the required system tables.
4. Bounce Agent.
5. Retry to discover EBusiness Suite instance.

Grid Agent URL connection interrupted

When trying to open agent URL, something like https://host:3872/emd/main, you receive connection interrupted message on your browser. Go to your agent home/bin directory.
> ./emctl stop agent
> ./emctl secure agent
> ./emctl start agent

EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..

When you execute "emctl upload" command, you receive "EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..."
Check your repository URL, you probably use secure connection to OMS, change the URL to https://oms_server:1159/em/upload. Restart your agent.

Patching Setup - My Oracle Support authorization failed

When you receive this message when setup patching on Grid Control 10.2.0.5: "My Oracle Support authorization failed. - Although metalink credentials are correct and successfully validated, an error occurred while downloading a sample patch from the patch url specified. Please check log files for details." then go see the log file on $ORACLE_HOME/sysman/log/emoms.log.
Just see some lines at the end of the file, use tail -n 100 emoms.log.
If you see ORA-14400, then using sqlplus and as sysman, run this on sqlplus:
exec emd_maintenance.analyze_emd_schema(‘SYSMAN’);

Unable to compile invalid object ORA-04030

Solution from http://oracledbas.blogspot.com/2009/02/ora-04030-out-of-process-memory.html

SQL> alter package apps.XLA_00200_AAD_S_000010_PKG COMPILE BODY;
alter package apps.XLA_00200_AAD_S_000010_PKG COMPILE BODY
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 4108 bytes (PLS
non-lib hp,pdzgM64_New_Link)

Solution
1.SQL>select object_name,object_type from dba_objects where status='INVALID';
OBJECT_NAME OBJECT_TYPE
----------------------------------- -------------------
XLA_00200_AAD_S_000010_PKG PACKAGE BODY
XLA_00200_AAD_S_000011_PKG PACKAGE BODY

2. SQL> alter system set plsql_optimize_level =0;
System altered.

3.SQL> alter package apps.XLA_00200_AAD_S_000010_PKG COMPILE BODY;
Package body altered.

4.SQL> alter package apps.XLA_00200_AAD_S_0000011_PKG COMPILE BODY;
Package body altered.

5.SQL> alter system set plsql_optimize_level =2;
System altered.

Don't forget to turn SLA: Enable Diagnostic off

If you need to set SLA: Enable Diagnostic to yes, then you must set it back to no right after you run your SLA request. If you forget to do so, your database will grow rapidly. Mine has grown 1.6 Gb in only one day!

Blank Page Accessing R12 - 'Missing class: _RF' in OACore application.log

Applies to:

Oracle Applications Technology Stack - Version: 12.0
This problem can occur on any platform.

Symptoms

On 12.0, trying to connect to the home page (http://<server>.<domain>.<port#>), redirects to http://<server>.<domain>.<port#>/OA_HTML/AppsLocalLogin.jsp which shows a blank page.

Further more, the application.log file of the OACore OC4J shows the following error stack:

javax.servlet.ServletException: oracle.classloader.util.AnnotatedClassNotFoundException:

Missing class: _RF

Dependent class: oracle.jsp.runtimev2.JspPageInfo
Loader: oc4j:10.1.3
Code-Source: /oracle/apps/tech_st/10.1.3/j2ee/home/lib/ojsp.jar
Configuration: <code-source> in META-INF/boot.xml in /oracle/apps/tech_st/10.1.3/j2ee/home/oc4j.jar

This load was initiated at oacore.web.html.jsp8892557:0.0.0 using the loadClass() method.

The missing class is not available from any code-source or loader in the system.
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:387)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)

Cause

JSPs need recompilation.

Solution

-- To implement the solution, please execute the following steps:
Either:
A. Set the JSP compilation to Automatic using the following steps:
1. Use the vi editor to edit the $CONTEXT_NAME.xml context file used by AutoConfig and change the value for "s_jsp_main_mode" from "justrun" to "recompile" (without the double quotes)

NOTE
~~~~~
Backup the context file before editing it.

2. Run Autoconfig to propagate the changes to the configuration files.

3. Verify that now the
$INST_TOP/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml has

<init-param>
<param-name>main_mode</param-name>
<param-value>recompile</param-value>
</init-param>

4. Restart the Middle Tier services and access the applications to load JSP's which will cause them to be recompiled on the run.

5. After successfully accessing the applications, use the vi editor to edit the $CONTEXT_NAME.xml context file used by AutoConfig and revert the value for "s_jsp_main_mode" to "justrun" (without the double quotes) in order not to hamper the performance of your system.

6. Run AutoConfig to propagate the changes.

NOTE
~~~~~

You can always use the next option to compile JSP's manually at any time.

OR
B. Recompile the JSP manually using the following steps:
1. Telnet to your server using applmgr user and source the environment by running the script:

/oracle/apps/apps_st/appl/APPS<SID>_<host>.env

2. Run the commands

UNIX

cd $FND_TOP/patch/115/bin
perl ojspCompile.pl --compile --flush -p 2

Windows

cd %FND_TOP%\patch\115\bin
- perl -x ojspCompile.pl –compile –flush

3. Restart the Middle Tier services.

$5 discount coupon

I have a $5 discount coupon from play-asia.com. But I won't use it because it has minimum order value $50 to use. You can use it if you want, the code is: WP-FKV-YIF. This coupon expires on August 30th, 2009. Just click below to visit play-asia.com. Don't forget to leave a comment when you have used it.

Ora-07445: Core Dump [Ioc_pin_shared_executable_object()+796]

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6
This problem can occur on any platform.

Symptoms

You can find the following exception in the alert log.

Tue Feb 12 15:00:02 2008
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x1063BAD1C, ioc_pin_shared_executable_object()+796]
Tue Feb 12 15:00:02 2008
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x1063BAD1C, ioc_pin_shared_executable_object()+796]
Errors in file /u00/app/oracle/diag/rdbms/ORCL/ORCL/trace/ORCL_m000_19716.trc (incident=33881):
ORA-07445: exception encountered: core dump [ioc_pin_shared_executable_object()+796] [SIGSEGV] [ADDR:0x0] [PC:0x1063BAD1C] [Address not mapped to object] []
Incident details in: /u00/app/oracle/diag/rdbms/ORCL/ORCL/incident/incdir_33881/ORCL_m000_19716_i33881.trc
Errors in file /u00/app/oracle/diag/rdbms/ORCL/ORCL/trace/ORCL_j000_19714.trc (incident=33873):
ORA-07445: exception encountered: core dump [ioc_pin_shared_executable_object()+796] [SIGSEGV] [ADDR:0x0] [PC:0x1063BAD1C] [Address not mapped to object] []
Incident details in: /u00/app/oracle/diag/rdbms/ORCL/ORCL/incident/incdir_33873/ORCL_j000_19714_i33873.trc
Tue Feb 12 15:00:04 2008
Trace dumping is performing id=[cdmp_20080212150004]

Cause

Bug 6325878 - USING VLM & RAMFS W/11G CAUSES ORA-7445 [IOC_PIN_SHARED_EXECUTABLE_OBJECT]

RELEASE NOTES: 
Oracle VLM configuration which instructs dba to mount /dev/shm as ramfs was incompatible with Oracle Java JIT

REDISCOVERY INFORMATION: 
Mounting /dev/shm as ramfs and start the database with JIT not disabled 

WORKAROUND: 
Two workarounds. 
1. Do not mount /dev/shm as ramfs and hence do not use VLM which requires it. 
2. Disable JIT and do not use pl/sql native compilation.

Solution

To workaround the issue, set JAVA_JIT_ENABLED=FALSE at parameter file and bounce the instance.

SQL> alter system set JAVA_JIT_ENABLED= FALSE scope = both;

System altered.

SQL> shutdown immediate
SQL> startup

SQL> show parameter JAVA_JIT_ENABLED
NAME             TYPE    VALUE
---------------- ------- ------------------------------
java_jit_enabled boolean FALSE

Using FND Log

Set the following Profile Options at the User Level:

FND: Debug Log Enabled -> Yes
FND: Debug Log Level -> Statement
FND: Debug Log Module -> %

1) Run the following sql query:

Select max(log_sequence) from fnd_log_messages;

2) Simulate the error process.

3) Provide the log file using the following query:

Select module, message_text from fnd_log_messages
Where log_sequence > 'put max log_sequence from above'
order by log_sequence;

Do not run adpatch with only one worker

When running adpatch, when asked for number of workers, do not enter 1. Sometimes an error needed for adpatch is included on the same patch. So if error occured, the job will be deferred if there are more than one worker. After that another worker will continue to work and the error fixed. When adpatch retry the failed job, it will be fixed.
If only one worker assigned, when error occurred, adpatch will stop, no job is deferred, so the error must be fixed outside adpatch.

Living in the desert

I have never thought of living in the desert. It's a little bit scary. But after viewing Desert Ridge Realtor website, it's interesting to see houses on desert.
The website gives you facilities to search and select houses located in the desert. Even 2D and 3D maps also provided.
If you like to have a house in the desert, you should visit this website.

Unable to cancel invoice due to tax distribution variance

CAUSE DETERMINATION
===================
The cause of the issue is invalid / incorrect data in ap_invoice_lines_all
and ap_invoice_distributions_all .

CAUSE JUSTIFICATION
===================
The following bug was logged for this specific customer to receive a datafix
from Oracle Development:
Bug.8357578: UNABLE TO CANCEL INVOICE DUE TO TAX DISTRIBUTION VARIANCE
Oracle Development stated that the issue is due to invalid / incorrect data.

The AP List identified the issue data.

PROPOSED SOLUTION(S)
====================
Apply a datafix to correct invalid / incorrect data in ap_invoice_lines_all
and
ap_invoice_distributions_all.

PROPOSED SOLUTION JUSTIFICATION(S)
==================================
The following bug was logged for this specific customer to receive a datafix
from Oracle
Development:
Bug.8357578: UNABLE TO CANCEL INVOICE DUE TO TAX DISTRIBUTION VARIANCE
Oracle Development stated that the issue is due to invalid / incorrect data.
Oracle Development provided a datafix.
The datafix will do the following:
1. correct the data in ap_invoice_lines_all and
ap_invoice_distributions_all.

SOLUTION / ACTION PLAN
======================
-- To implement the solution, please execute the following steps::
Execute the below SQL and commit the changes:

create table aid_bkp as
select *
from ap_invoice_distributions_all
where invoice_id = 10490
and line_type_lookup_code like '%TAX%';

create table ail_bkp as
select *
from ap_invoice_lines_all
where invoice_id = 10490
and line_type_lookup_code like '%TAX%';

delete
from ap_invoice_distributions_all
where invoice_id = 10490
and line_type_lookup_code like '%TAX%';

delete
from ap_invoice_lines_all
where invoice_id = 10490
and line_type_lookup_code like '%TAX%';

commit;