Sunday 27 November 2016

R12.2 : fs_clone failed with "s_atName" and "s_shared_file_system" Context Variables Multinode configuration

Error:

 [WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.
        [WARNING]: Either some of the required entries in /etc/hosts file might be missing (e.g. localhost or hostname) OR the file /etc/hosts could not be read.

Solution:

Note: appnode1 is primary, appnode2 is secondary

1. Check for the below in $CONTEXT_FILES both RUN & PATCH file system

  • s_shared_file_system is set to true for SHARED_APPL_TOP if not change it to true 
  • s_atName  is set to appnode1 hostname in CONTEXT_FILE of appnode2, if not set it appnode1 hostname

2. Check the values using below command sourcing patch/run:

  • grep -i "s_atName" $CONTEX_FILE
  • grep -i "s_shared_file_system" $CONTEX_FILE

3. Shut down application services
4. Run EXEC FND_CONC_CLONE.SETUP_CLEAN;
5. Run Autoconfig in dbTier, appnode1 run&patch , appnode2 run&patch
6. Run the fs_clone now.

Reference:
adop prepare fails with "s_atName And s_shared_file_system Context Variables Are Not In SYNC" (Doc ID 2176137.1)

Monday 9 May 2016

APPS : XML reports completing with warning

In cloned instance, all the reports are completeing with Warning state

Alert Log Error:
Errors in file /data/UAT/db/tech_st/11.2.0.3/admin/UAT_bctuat/diag/rdbms/uat/UAT/trace/UAT_ora_17385.trc  (incident=9206):
ORA-00600: internal error code, arguments: [kqludp2], [0x096D99A48], [0], [], [], [], [], [], [], [], [], []

Solution:
1. Shut everything down (Concurrent Manager ).
IMPORTANT: Verify NO Concurrent Manager processes are running on OS. This includes FNDLIBR, FNDSM, etc.

2. Run $FND_TOP/patch/115/sql/afopp001.sql as SYSTEM.
- Provide system username and password

3. Run $FND_TOP/patch/115/sql/afopp002.sql as APPLSYS.
- Provide apps username and password

4. Restart managers

5. Test the Reports.


Reference : (Document-id 1394729.1)

SQL Developer displaying Junk characters (??????)

Change the Encoding in SQL Developer Preferences as below Tools --> Preferences --> Environment --> Encoding --> UTF...