𝐄𝐫𝐫𝐨𝐫 𝟓𝟎𝟎--𝐈𝐧𝐭𝐞𝐫𝐧𝐚𝐥 𝐒𝐞𝐫𝐯𝐞𝐫 𝐄𝐫𝐫𝐨𝐫 𝐅𝐫𝐨𝐦 𝐑𝐅𝐂 𝟐𝟎𝟔𝟖 𝐄𝐁𝐒 𝐥𝐨𝐠𝐢𝐧

 

EBS LOGIN PAGE ISSUE:

 

Step to troubleshoot:

step 1. Check firewall status and disabled it (Otherwise add Ports to allow in the firewall exception list).

steps 2. Check your ebs login port is open or not through telnet.

step 3.  Check oacore logs file.

In my case step 3 works in oacore logs I have found the below issue:

Log File: /apps/R12.2/fs1/FMW_Home/user_projects/domains/EBS_domain_PROD/servers/oacore_server1/logs/oacore_server1.log

Observation and Findings: 

I have checked in DB the expired users list and found that APPLSYSPUB user is showing expired Status.

Note:-  APPLSYSPUB/PUB - is the default public username and password that grants access to oracle E-business suite initial sign-on form. In EBS Application at the time of login, oracle application connect to public schema - APPLSYSPUB. It has the sufficient privilege to perform the authentication of  FND user (Application users) which includes the PL/SQL packages to verify the username/password and the privilege to record the success or failure of a login attempt.  

SQL> select username,account_status from dba_users where USERNAME='APPLSYSPUB';

USERNAME             ACCOUNT_STATUS

--------------------   --------------------------------

APPLSYSPUB              EXPIRED

Solution:

[applmgr]$  FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYSPUB PUB

Now, Oracle E-business Suite Login page is working fine..!!

𝐀𝐮𝐭𝐨𝐜𝐨𝐧𝐟𝐢𝐠 𝐅𝐚𝐢𝐥𝐬 𝐢𝐧 𝐄𝐁𝐒 𝐑𝟏𝟐.𝟏.𝟑 𝐚𝐟𝐭𝐞𝐫 𝐚𝐝𝐩𝐚𝐭𝐜𝐡 𝐨𝐧 𝐋𝐢𝐧𝐮𝐱 𝟕.𝟗

 

 Adautocfg.sh Issue after adpatch:

Solution:

[applmgr@ebsuatapp]$ cd /orahome/oracle/apps/apps_st/appl/fnd/12.0.0/admin/template/custom/

[applmgr@ebsuatapp custom]$ mv orion_web_xml_1013.tmp  orion_web_xml_1013.tmp_090122_1

$ cp /orahome/oracle/apps/apps_st/appl/fnd/12.0.0/admin/template/orion_web_xml_1013.tmp /orahome/oracle/apps/apps_st/appl/fnd/12.0.0/admin/template/custom/

 Now Run adautocfg.sh again..!!

𝗖𝗥𝗘𝗔𝗧𝗜𝗡𝗚 𝗦𝗡𝗔𝗣𝗦𝗛𝗢𝗧 𝗦𝗧𝗔𝗡𝗗𝗕𝗬 𝗗𝗔𝗧𝗔𝗕𝗔𝗦𝗘 𝗜𝗡 𝗘𝗕𝗦 𝗥𝟭𝟮 𝗔𝗡𝗗 𝗔𝗣𝗟𝗟𝗜𝗖𝗔𝗧𝗜𝗢𝗡 𝗦𝗔𝗡𝗜𝗧𝗬 𝗖𝗛𝗘𝗖𝗞..!!

In PRIMARY DB:

SQL> Alter system set log_archive_dest_state_2=DEFER scope=both;

 

In STANDBY DB:

SQL> Alter database recover managed standby database cancel;

 

>> Wait to clear RFS files in progress….!!

SQL> shu immediate;                                                        

SQL> startup mount;

  In DR (Standby):

$ cd $TNS_ADMIN

Change the ifile - ASCPOCI_ascpoci105_ifile.ora entry to open application in DR Instance.

ASCPOCI =

  (DESCRIPTION =

    (ADDRESS_LIST =

#      (ADDRESS = (PROTOCOL = TCP)(HOST = ascpoci25.co.in)(PORT = 1521)) 

      (ADDRESS = (PROTOCOL = TCP)(HOST = ascpoci105.co.in)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SID = ASCPOCI)

    )

  )  

Note:- Primary host is ascpoci25.co.in (To open apps from DR we have to disable it and point to DR host)

In STANDBY DB (DR) Check the following parameters:

At First, Set the both db_recovery_file_dest parameters:

Convert to snapshot standby DB:

v  Now, login to application user.

         $ sqlplus apps/apps  [Use Source apps user password]

• Run the below command to remove the Source Instance entries.

Note: After execution FND_CONC_CLEAN.SETUP_CLEAN >> COMMIT;

    

v  Run Autoconfig on DBTier  & APPS Tier:-

         $ cd /ascpoci/erp/12.1.0/appsutil/scripts/ASCPOCI_ascpoci105

          [oradev@vm4db DEV_vm4db]$  adautocfg.sh

          Enter the APPS user password:

    

v Start the Application tier.

                 $ cd $ADMIN_SCRIPTS_HOME

                 $ sh adstrtal.sh apps/<apps-password>

                                                      <weblogic-password> 

 

[ascpociappl@ascpoci105 ~]$ adopmnctl.sh status

You are running adopmnctl.sh version 120.0.12020000.2

Checking status of OPMN managed processes...

Processes in Instance: ASCPOCI_web_ASCPOCI_OHS1

---------------------------------+--------------------+---------+---------

ias-component                    | process-type       |     pid | status

---------------------------------+--------------------+---------+---------

ASCPOCI_web_ASCPOCI   | OHS                |   27620 | Alive

adopmnctl.sh: exiting with status 0

   

APPLICATION SANITY CHECK:

         v  Login as SYSADMIN to Application.

             Go to System administrator -> Concurrent Manager-> Submit a New Request->Single Request.

       

     v    Revert back to the Physical Standby database:

          At First, Stop the application service.

          $ cd $ADMIN_SCRIPTS_HOME

          $ adstpall.sh  apps/<apps-password>

                                 <weblogic-password>

   Now, Login to database as sysdba:

 [ascpocidb@ascpoci105 ~]$ sqlplus / as sysdba

 SQL> shu immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 3.7413E+10 bytes

Fixed Size                  2261048 bytes

Variable Size            1.1677E+10 bytes

Database Buffers         2.5636E+10 bytes

Redo Buffers               98385920 bytes

Database mounted.

SQL> alter database convert to physical standby;

Database altered.

SQL> shu immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 1.0689E+10 bytes

Fixed Size                  2262656 bytes

Variable Size            1577060736 bytes

Database Buffers         9093251072 bytes

Redo Buffers               16900096 bytes

Database mounted.

SQL> select name,open_mode,database_role,protection_mode from v$database;

NAME      OPEN_MODE   DATABASE_ROLE       PROTECTION_MODE

--------- --------------------     -----------------------------  -----------------------------------

ASCPOCI   MOUNTED     PHYSICAL STANDBY  MAXIMUM PERFORMANCE

   

𝙀𝙍𝙍𝙊𝙍: 𝘾𝙤𝙣𝙩𝙚𝙭𝙩 𝙘𝙧𝙚𝙖𝙩𝙞𝙤𝙣 𝙣𝙤𝙩 𝙘𝙤𝙢𝙥𝙡𝙚𝙩𝙚𝙙 𝙨𝙪𝙘𝙘𝙚𝙨𝙨𝙛𝙪𝙡𝙡𝙮(../𝙟𝙧𝙚/𝙗𝙞𝙣/𝙟𝙖𝙫𝙖: /𝙡𝙞𝙗/𝙡𝙙-𝙡𝙞𝙣𝙪𝙭.𝙨𝙤.2) 𝙬𝙝𝙚𝙣 𝙧𝙪𝙣𝙣𝙞𝙣𝙜 𝙖𝙙𝙘𝙛𝙜𝙘𝙡𝙤𝙣𝙚.𝙥𝙡 𝙤𝙣 𝘼𝙥𝙥𝙨𝙏𝙞𝙚𝙧

    

Solution:

Step 1: Check java [applprod@apps]$ which java /usr/bin/java   Now, Go to java directory: [applprod@apps]$ cd $COMMON_TOP/clone/jre/bin   [applprod@apps bin]$  ls ControlPanel  java  java_vm  javaws  jcontrol  keytool  orbd  pack200  policytool  rmid  rmiregistry  servertool  tnameserv  unpack200   [applprod@ndrapps ~]$ mv java java_old   [applprod@apps bin]$ ln -s /usr/bin/java java Step 2:  Now,  Check Again->  Run perl adcfgclone.pl appsTier  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Issue Resolved...!!~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Enable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldRephraseRephrase current sentenceEdit in Ginger×Enable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldRephraseRephrase current sentenceEdit in Ginger×

𝐎𝐫𝐚𝐜𝐥𝐞 𝐄𝐁𝐒 𝐑𝟏𝟐.𝟐 ( 𝐄-𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐒𝐮𝐢𝐭𝐞 ) 𝐒𝐭𝐞𝐩 𝐛𝐲 𝐒𝐭𝐞𝐩 𝐂𝐥𝐨𝐧𝐢𝐧𝐠

 

Step 1:  Run Pre-Clone on the Source Apps Tier and DB Tier Application Preclone $ /apdata/erp/fs2/inst/apps/UAT_vm3uat/admin/scripts/adpreclone.pl appsTier pwd=apps Make tar file : $  tar -zcPf /apdata/Binary_BKP/apps.tar.gz /apdata/erp/fs2/EBSapps Database Preclone $ /dbuat/erp/12.1.0/appsutil/scripts/UAT_vm4db/adpreclone.pl dbTier pwd=apps Make tar file: $ tar --exclude='/dbuat/erp/12.1.0/admin' -cvf /dbuat/archbackup/Binary/UAT_db.tar.gz /dbuat/erp/12.1.0/

Step 2:  Take Full RMAN Backup (Include current control file & Archive log) at Source Server   Step 3:  Copy the Application Tier binary tar file from Source to Target. Step 4:  Copy the Database binary tar file & RMAN backup from Source to Target.

Step 5: Now, Prepare file system at target server Create the following directories in Target DB server             mkdir –p /dbdev/erp/12.1.0             mkdir –p /dbdev/erp/data             chown -Rf  oradev:dba  /dbdev/erp/             chmod -Rf 775 /dbdev/erp/              ***Here ,              RDBMS_ORACLE_HOME=/dbdev/erp/12.1.0              ORACLE BASE=/dbdev/erp/              DATA_TOP Directory=/dbdev/erp/data   ·         Create the following directories in Target EBS Application server              mkdir –p /apdata/erp/fs2/EBSapps  (Run File system)             mkdir –p /apdata/erp/fs1/   (Patch File system)             chown -Rf  appldev:dba  /apdata/erp/             chmod  -Rf 775 /apdata/erp/   ·         Untar DB binary and copy to target file system Ø  tar –xvf  UAT_db.tar.gz Ø  cp –rf  /dbuat/erp/12.1.0/* /dbdev/erp/12.1.0   ·         Untar Application binary and copy to target file system Ø   tar –xvf  apps.tar.gz Ø  cp –rf   /apdata/erp/fs2/EBSapps/* /apdata/erp/fs2/EBSapps/

Step 6: Configure the Oracle home on Target Database Server   [oradev@vm4db bin]$ perl adcfgclone.pl dbTechStack                        Copyright (c) 2002, 2015 Oracle Corporation                         Redwood Shores, California, USA                         Oracle E-Business Suite Rapid Clone                                  Version 12.2                       adcfgclone Version 120.63.12020000.60   Enter the APPS password :   Running: Context clone...   Log file located at /dbdev/erp/12.1.0/appsutil/clone/bin/CloneContext_0405185655.log   Provide the values required for creation of the new Database Context file.   Target System Hostname (virtual or normal) [vm4db] : vm4db.alam.com   Target Instance is RAC (y/n) [n] : n   Target System Database SID : DEV   Target System Base Directory : /dbdev/erp/   Role separation is supported y/n [n] ? : n   Target System utl_file_dir Directory List : /tmp   Number of DATA_TOP's on the Target System [1] :   Target System DATA_TOP Directory 1 [/dbdev/erp/data] :   Target System RDBMS ORACLE_HOME Directory [/dbdev/erp/12.1.0] :   Do you want to preserve the Display [vm4db:0.0] (y/n)  : n   Target System Display [vm4db:0.0] :   Target System Port Pool [0-99] : 20

Step 7: Start the database in nomount mode. Before starting check the pfile and make sure all the paths are pointing as per target server directory structure.   Add below entry in InitDEV.ora (files are to be restored to a different location):   *.db_file_name_convert=’<source_path>’,’<target_path>’ *.db_file_name_convert='/dbuat/erp/data/','/dbdev/erp/data/'    *.log_file_name_convert=’<source_path>’,’<target_path>’ *.log_file_name_convert='/dbuat/erp/data/','/dbdev/erp/data/' SQL> startup nomount pfile='initDEV.ora'; SQL> create spfile from pfile='initDEV.ora'; SQL> shu immediate; SQL> startup nomount;   Step 8. Rman backup Restoration at target DB server   $ rman auxiliary / log=rman_output_060421.txt Recovery Manager: Release 12.1.0.2.0- Production on Tue Apr 05 18:10:49 2021 Copyright (c) 1991, 2014, Oracle and/or its affiliates.  All rights reserved. connected to target database: uattest (not mounted)   RMAN> run{ allocate auxiliary channel C1 DEVICE TYPE DISK; allocate auxiliary channel C2 DEVICE TYPE DISK; allocate auxiliary channel C3 DEVICE TYPE DISK; allocate auxiliary channel C4 DEVICE TYPE DISK; allocate auxiliary channel C5 DEVICE TYPE DISK; allocate auxiliary channel C6 DEVICE TYPE DISK; allocate auxiliary channel C7 DEVICE TYPE DISK; allocate auxiliary channel C8 DEVICE TYPE DISK; duplicate database to 'DEV' backup location '/dbuat/BACKUP/rman05042021_BKP/databkp' nofilenamecheck; }

v   Change database to Noarchivelog mode             SQL> shut immediate;             SQL> startup mount;             SQL> alter database noarchivelog;             SQL> alter database open;   v  Now, login to application user.          $ sqlplus apps/apps  [Use Source apps user password] Run the below command to remove the Source Instance entries.           SQL>  EXEC FND_CONC_CLONE.SETUP_CLEAN;           SQL> commit;   v  Run Autoconfig on DBTier:-          $ cd /dbdev/erp/12.1.0/appsutil/scripts/DEV_vm4db           [oradev@vm4db DEV_vm4db]$  adautocfg.sh           Enter the APPS user password:

Step 9. Now login to application server, run adcfgclone on appstier. #[RUN FILE SYSTEM] $ cd /apdata/erp/fs2/EBSapps/comn/clone/bin [appldev@vm2dev bin]$  perl adcfgclone.pl appsTier                        Copyright (c) 2002, 2015 Oracle Corporation                         Redwood Shores, California, USA                         Oracle E-Business Suite Rapid Clone                                  Version 12.2                       adcfgclone Version 120.63.12020000.60                 ***********************************************************                 In AD-TXK Delta 7, we recommend you clone the run and patch                 file systems in a single operation using the 'dualfs' option.                 Separate cloning of the run and patch file systems will be deprecated                 ************************************************************   Enter the APPS password :   Enter the Weblogic AdminServer password :   Do you want to add a node (yes/no) [no] :   Running: Context clone...   Log file located at /apdata/erp/fs2/EBSapps/comn/clone/bin/CloneContext_0406034543.log   Target System File Edition type [run] :   Provide the values required for creation of the new APPL_TOP Context file.   Target System Hostname (virtual or normal) [vm2dev] : vm2dev.alam.com   Target System Database SID : DEV   Target System Database Server Node [vm2dev] : vm4db.alam.com   Target System Base Directory : /apdata/erp/   Target System Base Directory set to /apdata/erp   Target System Current File System Base set to /apdata/erp/fs2   Target System Other File System Base set to /apdata/erp/fs1   Target System Fusion Middleware Home set to /apdata/erp/fs2/FMW_Home   Target System Web Oracle Home set to /apdata/erp/fs2/FMW_Home/webtier   Target System Appl TOP set to /apdata/erp/fs2/EBSapps/appl   Target System COMMON TOP set to /apdata/erp/fs2/EBSapps/comn   Target System Instance Home Directory [/apdata/erp] :   Target System Instance Top set to /apdata/erp/fs2/inst/apps/DEV_vm2dev   Do you want to preserve the Display [vm3uat:0.0] (y/n)  : n   Target System Display [vm2dev:0.0] :   Target System Root Service [enabled] :   Target System Web Entry Point Services [enabled] :   Target System Web Application Services [enabled] :   Target System Batch Processing Services [enabled] :   Target System Other Services [disabled] :   Do you want the target system to have the same port values as the source system (y/n) [y] ? : n   Target System Port Pool [0-99] : 20   Checking the port pool 20 done: Port Pool 20 is free Report file located at /apdata/erp/fs2/inst/apps/DEV_vm2dev/admin/out/portpool.lst   UTL_FILE_DIR on database tier consists of the following directories.   1. /usr/tmp 2. /tmp 3. /dbdev/erp/12.1.0/appsutil/outbound/DEV_vm4db 4. /usr/tmp Choose a value which will be set as APPLPTMP value on the target node [1] :   Step 10:  (i) Start the Application tier.                  $ cd $ADMIN_SCRIPTS_HOME                  $ sh adstrtal.sh apps/<apps-password>                  (ii)Run adpreclone on TARGET RUN File System                  $ /apdata/erp/fs2/inst/apps/UAT_vm3uat/admin/scripts/adpreclone.pl appsTier pwd=apps                (iii) Shutdown application on TARGET RUN File System                  $ cd $ADMIN_SCRIPTS_HOME                  $ sh adstpall.sh apps/<apps-password>                 (iv) Copy Target RUN File System to Target Patch File System                   $ cp -rf  /apdata/erp/fs2/* /apdata/erp/fs1/

v Patch Edition File System cloning

Step 11:   (i) UNSET the application Enviroment. Previously we have executed env.                  (ii) Before we run adcfgclone.pl dont run any env’s                     Now, Directly go to /apdata/erp/fs1/EBSapps/comn/clone/bin/ and execute adcfgclone.pl [appldev@vm2dev bin]$ perl adcfgclone.pl appsTier                        Copyright (c) 2002, 2015 Oracle Corporation                         Redwood Shores, California, USA                           Oracle E-Business Suite Rapid Clone                                    Version 12.2                         adcfgclone Version 120.63.12020000.60                   ***********************************************************                 In AD-TXK Delta 7, we recommend you clone the run and patch                 file systems in a single operation using the 'dualfs' option.                 Separate cloning of the run and patch file systems will be deprecated                 ************************************************************   Enter the APPS password :   Enter the Weblogic AdminServer password :   Do you want to add a node (yes/no) [no] :     Running: Context clone...   Log file located at /apdata/erp/fs1/EBSapps/comn/clone/bin/CloneContext_0406115635.log   Target System File Edition type [run] : patch   Enter the full path of Run File System Context file : /apdata/erp/fs2/inst/apps/DEV_vm2dev/appl/admin/DEV_vm2dev.xml   Provide the values required for creation of the new APPL_TOP Context file.   Target System Fusion Middleware Home set to /apdata/erp/fs1/FMW_Home   Target System Web Oracle Home set to /apdata/erp/fs1/FMW_Home/webtier   Target System Appl TOP set to /apdata/erp/fs1/EBSapps/appl   Target System COMMON TOP set to /apdata/erp/fs1/EBSapps/comn   Target System Instance Top set to /apdata/erp/fs1/inst/apps/DEV_vm2dev   Target System Port Pool [0-99] : 21

v POST CLONING STEPS

Update the Sitename & Date: SQL>DECLARE stat boolean; BEGIN dbms_output.disable; dbms_output.enable(100000); stat := FND_PROFILE.SAVE('SITENAME', 'DEV(Data Till 05-APR-21)', 'SITE'); IF stat THEN dbms_output.put_line( 'Stat = TRUE - profile updated' ); ELSE dbms_output.put_line( 'Stat = FALSE - profile NOT updated' ); END IF; commit; END; /   Change the profile name: SQL> DECLARE stat boolean; BEGIN dbms_output.disable; dbms_output.enable(100000); stat := FND_PROFILE.SAVE('FS_SVC_PREFIX', 'FNDFS_DEV_', 'SITE'); IF stat THEN dbms_output.put_line( 'Stat = TRUE - profile updated' ); ELSE dbms_output.put_line( 'Stat = FALSE - profile NOT updated' ); END IF; commit; END; /    To change color of the site: SQL>DECLARE stat boolean; BEGIN dbms_output.disable; dbms_output.enable(100000); stat := FND_PROFILE.SAVE('FND_COLOR_SCHEME', 'BLUE', 'SITE'); IF stat THEN dbms_output.put_line( 'Stat = TRUE - profile updated' ); ELSE dbms_output.put_line( 'Stat = FALSE - profile NOT updated' ); END IF; commit; END; /   Clear the schedule concurrent program: SQL> UPDATE  fnd_concurrent_requests    SET phase_code = 'C', status_code = 'X'  WHERE phase_code = 'P'        AND request_id NOT IN               (SELECT request_id                  FROM fnd_conc_req_summary_v                 WHERE program IN                          ('WIP Move Transaction Manager',                           'Process transaction interface',                           'Manager: Lot Move Transactions',                         'Workflow Background Process',                           'Cost Manager')                       AND (phase_code = 'P' OR phase_code = 'R'));       SQL> UPDATE  fnd_concurrent_requests    SET phase_code = 'C', status_code = 'X'  WHERE phase_code = 'R' AND status_code = 'R'        AND request_id NOT IN               (SELECT request_id                  FROM fnd_conc_req_summary_v                 WHERE program IN                          ('WIP Move Transaction Manager',                           'Process transaction interface',                           'Manager: Lot Move Transactions',                         'Workflow Background Process',                           'Cost Manager')                       AND (phase_code = 'P' OR phase_code = 'R'));   SQL>  COMMIT;     v Run autoconfig on dbtier and then on appstier.   DB tier:            $ cd $ORACLE_HOME/appsutil/scripts/DEV_vm4db           $  adautocfg.sh           Apps tier:           $  cd $ADMIN_SCRIPTS_HOME           $  adautocfg.sh     v Start the Application tier. Check OPMN status and from front end.            $  cd $ADMIN_SCRIPTS_HOME            $ ./adstrtal.sh  apps/apps              Enter the weblogic user password: ~~~~~~~~~~~~~~~~~~EBS R12.2 Cloning is completed!!~~~~~~~~~~~~~~~~~~