Author Archives: Vasudev Seeram - Page 3

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.

AutoConfig could not successfully execute adgendbc.cmd

Problem: When running AutoConfig on the application tier, the following error occurs:

  -     90% completed
ERROR while running Apply...

Checked D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\log\09061401\adconfig.log:
  [SETUP PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\install
      adgendbc.cmd            INSTE8_SETUP       1

Possible solution: Disable JAVA_JIT_ENABLED

SQL> show parameter jit

NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------------
java_jit_enabled                     boolean     TRUE

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

System altered.

SQL>

Reference: Adgendbc Fails With Database Connection Failure (Doc ID 1302708.1)

Perl lib version (5.10.0) doesn’t match executable version (v5.8.5)

Problem: When running adcfgclone, the following error occurs:

Complete port information available at D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\out\PROD_testsrv2\portpool.lst

Creating the new Database Context file from :
  D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\template\adxdbctx.tmp

The new database context file has been created :
  D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\PROD_testsrv2.xml

Log file located at D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\CloneContext_0906103441.log
Check Clone Context logfile D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\CloneContext_0906103441.log for details.

Running Rapid Clone with command:
perl D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\adclone.pl java=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\..\jre mode=apply stage=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone component=dbTier method=CUSTOM dbctxtg=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\PROD_testsrv2.xml showProgress contextValidated=true
Running:
perl D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\adclone.pl java=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\..\jre mode=apply stage=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone component=dbTier method=CUSTOM dbctxtg=D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\PROD_testsrv2.xml showProgress contextValidated=true
Perl lib version (5.10.0) doesn't match executable version (v5.8.5) at d:/ORACLE/PROD/db/tech_st/11.2.0/perl/lib/Config.pm line 46.
Compilation failed in require at D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone
\bin\adclone.pl line 34.
BEGIN failed--compilation aborted at D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\adclone.pl line 34.

 ERROR: Failed to execute D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\adclone.pl

 Please check logfile.



Solution: May need to set PERL5LIB before running adcfgclone.

set PERL5LIB=D:\ORACLE\PROD\db\tech_st\11.2.0\perl\lib\5.10.0;D:\ORACLE\PROD\db\tech_st\11.2.0\perl\site_perl\5.10.0;D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\perl
cd /d D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin
d:\ORACLE\PROD\db\tech_st\11.2.0\perl\bin\perl.exe adcfgclone.pl dbTier

RC-20011: Fatal: Failed to Retrieve OS name

Problem: When running adcfgclone on Windows 2008, the following error occurs:

D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin>d:\ORACLE\PROD\db\tech_st\11.2.0\perl\bin\perl.exe adcfgclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.8

Enter the APPS password : apps


Running:
D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\..\jre\bin\java.exe -Xmx600M
 -cp D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\jlib\java;D:\ORACLE\PROD\db
\tech_st\11.2.0\appsutil\clone\jlib\xmlparserv2.jar;D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\jlib\ojdbc5.jar oracle.apps.ad.context.CloneContext -e D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin\..\context\db\CTXORIG.xml -validate -pairsfile C:\Users\ADMINI~1\AppData\Local\Temp\1\adpairsfile_4724.lst -stage
 D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone  2> C:\Users\ADMINI~1\AppData\Local\Temp\1\adcfgclone_4724.err && echo %ERRORLEVEL% > C:\Users\ADMINI~1\AppData\Local\Temp\1\adcfgclone_4724.res
RC-20011: Fatal: Failed to retrieve OS name. The following OS string returned from System.getProperty("os.name") is unknown: Windows Server 2008 R2
Can't open Exception in thread "main" java.lang.ExceptionInInitializerError:
Invalid argument

D:\ORACLE\PROD\db\tech_st\11.2.0\appsutil\clone\bin>

Solution: Apply patch 11071569 on source system, then copy to target system. Then rerun adcfgclone.

Reference: How to Overcome Windows 2008 Being Unrecognised by AutoConfig and rapid Clone? (Doc ID 1270782.

 

 

FAILED: File FNDGFU.exe While Running Patch 9239095

Problem: While running patch 9239095, the following error occurs:

Assigned: file FNDGFU.exe   on worker  1 for product fnd username APPLSYS.

   FAILED: file FNDGFU.exe   on worker  1 for product fnd username APPLSYS.

 Deferred: file FNDGFU.exe   on worker  1 for product fnd username APPLSYS.

          (Deferment number 1 for this job)

Checked D:\ORACLE\MFGPR12\apps\apps_st\appl\admin\MFGP\log\ adwork001.log

ORA-01653: unable to extend table APPLSYS.FND_LOBS by 16 in tablespace APPS_TS_MEDIA

D:\oracle\MFGPR12\apps\apps_st\appl\fa\12.0.0\help\US\FA00019109.htm: upload failed

 

AD Worker error:

The above program failed with error code 1.

See the AD Worker log file and/or the program log file for details.

 Solution: Add datafile to APPS_TS_MEDIA tablespace:

select tablespace_name, file_name, bytes/1024/1024 from dba_data_files 
where tablespace_name = 'APPS_TS_MEDIA';

alter tablespace apps_ts_media add datafile 
'D:\ORACLE\MFGP\MFGPDB\ORADATA\MFGP\A_MEDIA02.DBF' size 1200M;