Monthly Archives: September 2013

Viewer Application Profile is Not Set

Problem: When attempting to launch the Journal Wizard, the following message is displayed:

Viewer application profile is not set

Solution: Edit the System Profile GL: Default Desktop Viewer and set its value to one of Excel 97, Excel 2000, Excel 2002, Excel 2003 or Excel 2007.

Bounce application tier services.

Reference: Launch Journal Wizard Fails Error Viewer Application Profile is Not Set (Doc ID 459431.1)

Programmatic access to Office VBA project is denied: http://support.microsoft.com/kb/282830

How Do I Remove The Concurrent Manager Service?

Problem: How Do I Remove The Concurrent Manager Service?

Ensure that the concurrent manager service is not running.

At the command prompt, enter:

%COMMON_TOP%\admin\install\PROD_testsrv2\adsvcm.cmd -deinstall

Reference: Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Microsoft Windows Server (32-bit) (Doc ID 761567.1)

ORA-07445: exception encountered: core dump [clscrsmsgFreeMessage()+32]

Problem: When shutting down 11.2.0 database, the following error occurs:

ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Completed: ALTER DATABASE DISMOUNT
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x3533] [PC:0x8F3194C,
_clscrsmsgFreeMessage()+32]
Errors in file D:\ORACLE\PROD\PRODDB\11.2.0\ADMIN\PROD_testsrv3\diag\rdbms\mfg
p\PROD\trace\PROD_ora_29572.trc  (incident=12993):
ORA-07445: exception encountered: core dump [clscrsmsgFreeMessage()+32] [ACCESS_
VIOLATION] [ADDR:0x3533] [PC:0x8F3194C] [UNABLE_TO_READ] []
Incident details in: D:\ORACLE\PROD\PRODDB\11.2.0\ADMIN\PROD_testsrv3\diag\rdb
ms\PROD\PROD\incident\incdir_12993\PROD_ora_29572_i12993.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Sep 17 11:06:12 2013
Dumping diagnostic data in directory=[cdmp_20130917110612], requested by (instan
ce=1, osid=29572), summary=[incident=12993].

Solution: Oracle Database 11.2.0 was installed twice on the same machine.

In Registry, delete the following keys in My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Oracle:
ORA_CRS_HOME String Value: D:\ORACLE\PROD\PRODdb\11.2.0
Ocr Key

Worker 1 has status ‘C’

Problem: The Command Prompt window running the patch was accidentally closed off. When the patch was resumed, the following error appeared:

AutoPatch error:
Invalid status when reading existing table

Worker 1 has status 'C'

Solution: Restart patch once more.

NTVDM encountered a hard error

Problem: When running admkappsutil.pl on Windows 2008, the following error occurs:

ntvdm.exe – System Error
NTVDM encountered a hard error

Solution: Open Command Prompt and run unzip.exe and zip.exe to see if they are working.

Ensure that you are using the version of zip.exe and unzip.exe for the version of Windows you are using (32-bit or 64-bit).

 

ORA-00201: control file version 11.2.0.0.0 incompatible with ORACLE version 10.1.0.0.0

Problem: When shutting down and restarting the Oracle database (11.2.0.3), the following error occurs:

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  594288640 bytes
Fixed Size                  1386120 bytes
Variable Size             411044216 bytes
Database Buffers          167772160 bytes
Redo Buffers               14086144 bytes
ORA-00201: control file version 11.2.0.0.0 incompatible with ORACLE version 
10.1.0.0.0
ORA-00202: control file: 'D:\ORACLE\PROD\PRODDB\ORADATA\PROD\CNTRL01.DBF'

SQL>

Solution: The startup command is using the SPFILE by default. The old SPFILE is being used. Need to create new SPFILE when the database is up and running. In this case, the fastest way to restart the database is to use the Services panel and restart the OracleServicePROD service, then recreate the spfile:

SQL> create spfile from pfile;
File created.
SQL>

 

FND_SESSION_MANAGEMENT.CHECK_SESSION When Logging On

Problem: After disabling maintenance mode and logging on, the following error appears:

<PRE>Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512: 
at line 1 has been detected in FND_SESSION_MANAGEMENT.CHECK_SESSION. Your session 
is no longer valid. </PRE>
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.

Solution:

1. Please execute the following scripts from $FND_TOP/patch/115/sql
SQL> @AFICXSMS.pls
SQL> @AFICXSMB.pls
Please ensure that the package FND_SESSION_MANAGEMENT is valid and confirm the version again.

2. Bounce the server.

Reference: Login Page Throws Error 1403: Java.Sql.Sqlexception: Ora-01403: No Data Found Ora-06512: At Line 1 H (Doc ID 1336030.1)

CCMSVC.EXE dies when Concurrent Manager started

Problem: CCMSVC.EXE dies when Concurrent Manager started

Solution: Install Microsoft Visual Studio 2005 Redistributable

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.

Problem: When running AutoConfig on the application tier, AutoConfig completes in error. Checked adconfig.log file:

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.
Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates
Instantiating Tools tnsnames.ora
Tools tnsnames.ora instantiated
Web tnsnames.ora instantiated

adgentns.pl exiting with status 2

Solution: Disable IPV6 from Local Area Network connection and retry AutoConfig on apps tier

Other solutions tried:

1. Clean FND_NODES table and rerun AutoConfig.

perl D:\ORACLE\PROD\apps\apps_st\appl\ad\12.0.0\bin\adgentns.pl appspass=apps contextfile=D:\ORACLE\PROD\inst\apps\PROD_testsrv2\appl\admin\PROD_testsrv2.xml –removeserver
perl D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\bin\adgentns.pl appspass=apps contextfile=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\PROD_testsrv2.xml -removeserver
EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;
cd D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\scripts\PROD_testsrv2
adautocfg.cmd
cd D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\scripts
adautocfg.cmd

May need to shutdown database and restart it.

Check D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\log\09062315\adconfig.log
Check D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\log\09062315/NetServiceHandler.log
Check D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\install\admk80ln.sql

ORA-01882: timezone region not found

Problem: When running AutoConfig on the apps tier on Windows 2008, the following error occurs. Checked D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\log\09061418\adconfig.log:

ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

Solution:

Timezone on Windows 2008 is: (UTC-04:00) Georgetown, La Paz, Manaus, San Juan

Shut down database and change time zone to (UTC-04:00) Santiago.