Monday, 16 July 2018

How to change apss password in r12.1.3


Hey DBA-Mates,
Hope you all are doing great.
Recently, one of my junior team mates learned How to change APPS Password in R12.1.3. He is a junior and newly joined.

We asked him to change the APPS and SYSADMIN password after the clone.
But he was not done earlier and asked me some basics questions and its good. Even he google and checked but he was having some doubts.
He asked me some basics questions as:
1. Will we run FNDCPASS from SQL> prompt or $ prompt.
2. Apps Services should be UP or Down.

He knows the FNDCPASS uses to change the APPS user password but he have not done yet, so he got confused.
Then I thought it may be basics and easy lets share with you all guys.

Please find the below Steps:
1. FNDCPASS should be run from $ prompt.
2. Apps Services should be Down.
3. After changing Apps password through FNDCPASS, we should run autoconfig.
4. APPS and APPLSYS password will be same.

Steps to change the Apps password through FNDCPASS:
1. Run the env file.
$ . ./ora-data.blogspot.env

2. Cross check for correct server/host.
$ echo $TWO_TASK
ORA-DATA

3. Changing the APPS password through FNDCPASS:

$ FNDCPASS apps/<apps_oldpassword> 0 Y system/<system_pass> SYSTEM APPLSYS <apps_newpassword>
Log filename : L2331757.log


Report filename : O2331757.out
$

4. Always check the log because sometimes it will through error which you cannot know without checking log file.

$ cat L2331757.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.1

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDCPASS:
+---------------------------------------------------------------------------+

Current system time is 15-JUL-2018 10:15:50

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

Working...

FNDCPASS completed successfully.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 15-JUL-2018 10:15:58

+---------------------------------------------------------------------------+
$

5. Changing the SYSADMIN password :

$ FNDCPASS apps/<apps_newpassword>  0 Y system/dev0dba USER SYSADMIN <password for sysadmin>
Log filename : L2471757.log


Report filename : O2471757.out

6. Now check the logfile.

$ cat L2471757.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.1

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDCPASS:
+---------------------------------------------------------------------------+

Current system time is 15-JUL-2018 10:16:42

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

Working...
Password is changed successfully for user SYSADMIN.
FNDCPASS completed successfully.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 15-JUL-2018 10:16:46

+---------------------------------------------------------------------------+
$

Note: Once completed , please check and connect with APPS user with new password then start the services.

Regards,
ora-data Team

Wednesday, 11 July 2018

R12.2 Cloning Steps


Hey DBA-Mates,
Hope you all are rocking in APPS DBA because we DBAs always rock in case of work.. :D, just kidding.

Friends, when I searched in google almost people posted only for Apps tier cloning , what about DB tier which no one has mentioned. So, I thought let me cover that.

From long time, I was thinking for cloning as per real time scenario. But due to lack of time, I was not able to do so…

R12.2 CLONING STEPS:
Source: PROD
Target: TEST

1. Pre-requiste TASK AT PROD Instance PROD (Before Backup check space)
Please check the space for DB Backup, Conc Backup and App Backup as per your environment on server.

2. Preclone & Cold Backup on PROD Source                       
Prepare the source system database tier for cloning

$ cd $ORACLE_HOME/appsutil/scripts/PROD_hostname
$ perl adpreclone.pl dbTier

Prepare the Source System Application Tier for cloning
$ echo $FILE_EDITION  ==> Should return run

$ cd <INST_TOP>/admin/scripts
$ perl adpreclone.pl appsTier

Verification of adpreclone.pl done in all Tiers.
AT DBTier
Under cd $ORACLE_HOME/appsutil/clone below 2 files should be latest timestamp:
ls -lrtd jlib
ls -lrtd data
Same as above data => stage , below 2 files should be with current timestamp.
ls -lrt adcrdb.zip
ls -lrt addbhomsrc.xml

At AP(MT)
Here, we check the clone directory under $COMMON_TOP and for more confirmation we can check below two files:
cd $COMMON_TOP/clone
ls -lrtd jlib
ls -lrtd appl

As of Release 12.2, the adpreclone.pl process on the Application Tier creates a complete compressed archive of the Oracle Fusion Middleware such as:
Oracle WebLogic Server home,
Oracle Web Tier Utilities home,
Oracle Common Utilities home and
The Oracle E-Business Suite home.

Now, Shutdown PROD Completely [ because we are using cold backup]

cd $ADMIN_SCRIPTS_HOME
$./adstpall.sh

We need to take COLD Backup of PROD database and application RUN_BASE files system:

/test/pp/PROD/oradata/data
/test/pp/PROD/oradata/11.2.0 
$RUN_BASE/EBSapps/appl
$RUN_BASE/EBSapps/comn
$RUN_BASE//EBSapps/10.1.2

Copy/Restore (unzip) to TEST by using cp command as per file structure and directory.

Start the PROD Services because we don’t need.

3. Let’s start DB Clone:

Log on to the Target System as the ORACLE and Run the adcfgclone on the DBTier with dbTier option:

$ cd $ORACLE_HOME/appsutil/clone/bin
$ perl adcfgclone.pl dbTier

After adcfgclone.pl at DB-TIER please check whether DB services and DB listener is up and running. Then Proceed to next step.
Check DB Status and Create Temp Tablespace(if Not exists).

select count(*) from v$datafile; ==> should match as source count

Select distinct status from v$datafile;
Output as below shown:
SYSTEM
ONLINE

select file_name , tablespace_name , bytes/1024/1024 from dba_temp_files;
Example to add:
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/TEST/oradata/data/temp01.dbf' SIZE 1100M REUSE AUTOEXTEND OFF;

Clean FND_NODES table
Connect apps/<passwd>
EXEC FND_CONC_CLONE.SETUP_CLEAN;
commit;

Run Following command to close open mails:
sqlplus apps/appspwd

SQL>Update WF_NOTIFICATIONS set status = 'CLOSED', mail_status = 'SENT' where status = 'OPEN' and mail_status = 'MAIL';

Run autoconfig in DB tier and check whether the DB entry is updated in FND_NODES table.

$cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME
$adautocfg.sh

After Autoconfig runs successfull check following entry, it should not point to PROD :
sqlplus apps/appspwd
SQL> select node_name,support_db,last_update_date from fnd_nodes;

4. Application Tier Clone TEST

Run adcfgclone.pl on Apps Tier on "Run Edition File System".
Log on to the "Run Edition File System" in the Target System as the applmgr user:
$ cd <COMMON_TOP>/clone/bin
$ perl adcfgclone.pl appsTier

Start the application Tier using adstral.sh on RUN FILE System
cd $ADMIN_SCRIPTS_HOME
adstrtall.sh apps/appspwd

Run adpreclone on TARGET(TEST) RUN FILESYSTEM
We have to run adpreclone.pl on the "Run Edition File System" in the Target System. [New in R12.2]

On TARGET (TEST) RUN FILE System
$ cd <INST_TOP>/admin/scripts
$ perl adpreclone.pl appsTier

SHUTDOWN THE APPLICATION which is running on RUN FILESYSTEM
cd $ADMIN_SCRIPTS_HOME
adstpal.sh apps/appspwd
Weblogic admin password:

COPY THE TARGET RUN FILESYSTEM to TARGET PATCH FILESYSTEM
Now, CONFIGURE TARGET PATCH FILESYSTEM

Run adcfgclone.pl on Apps Tier on "Patch Edition File System"
Log on to the "Patch Edition File System" in the Target System( as the APPLMGR user) and enter the following commands:

$ cd <COMMON_TOP>/clone/bin
$ perl adcfgclone.pl appsTier

Note-1: It will ask for Context file name, provide the fs1 (Run Fs) contetxt file name.
Note-2: Port will be different for Run and Patch FS.

Once completed: Startup the application tier services of  TEST

cd $ADMIN_SCRIPTS_HOME
adstrtal.sh apps/password
Enter WLSADMIN password:

Once above all done successfully, please perform Sanity Check.[Here, I can provide your some points or steps very soon]

5. Post Clone steps:

Update profile options and FND_CONCURRENT_REQUESTS:

sqlplus apps/passwd
UPDATE FND_CONCURRENT_REQUESTS
SQL> update fnd_concurrent_requests set status_code='C', phase_code='C'  where phase_code='P';

Change Site level Profile option.

Execute the below sql for running programs.
a) Set Terminating or Running to Completed/Terminated
SQL>UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE status_code ='T'
OR phase_code = 'R'
/

b) Place Pending/(Normal/Standby) to On Hold
SQL>UPDATE fnd_concurrent_requests
SET hold_flag = 'Y'
WHERE phase_code = 'P'
AND status_code in ('Q','I')
/

Then check for Health check and sanity check. Login to front end and submit the request.

Some more useful links:




Please let us know for any suggestions either in comment box or contact us @https://ora-data.blogspot.com

Regards,
Ora-data Team