Tuesday, December 29, 2015

DataInstall menu was not displaying payroll product.



Solution:-

The Payroll was shared but not licensed. I licensed the payroll using OAM. I run DataInstall. Now the Payroll is enabled.

Saturday, December 26, 2015

ADOP + ORA-12516: TNS:listener could not find available handler with matching protocol stack (DBD ERROR: OCIServerAttach)



ERROR in ADOP Log dile:-

[ERROR]     Cannot connect to database
[ERROR]     Error Message: ORA-12516: TNS:listener could not find available handler with matching protocol stack (DBD ERROR: OCIServerAttach)
[ERROR]     Error calling ad_zd_log. Refer to log file for details.
[ERROR]     Error calling ad_zd_log. Refer to log file for details.
[ERROR]     Error calling ad_zd_log. Refer to log file for details. 
[ERROR]     Cannot connect to database
[ERROR]     Error Message: ORA-12516: TNS:listener could not find available handler with matching protocol stack (DBD ERROR: OCIServerAttach) 

Solution:-
Step 1:- Ensure that your sqlnet_ifile.ora has the line:-

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8 (if the initialization parameter
SEC_CASE_SENSITIVE_LOGON is set to FALSE)
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 10 (if SEC_CASE_SENSITIVE_LOGON is set to TRUE)

Step 2:- Restart faild working using adctrl utility.

Step 3:- Restart adop session 

adop phase=apply patchtop=$PER_TOP/patch/115 patches=driver:hrglobal.drv options=nocopyportion,nogenerateportion,forceapply workers=10 maxworkers=20 restart=yes
 


Friday, December 25, 2015

adop phase=prepare – Failed at txkADOPPreparePhaseSynchronize.pl



Issue:-
Error In the adop log :-

              [UNEXPECTED]Error occurred while executing -
---
----
---
              [UNEXPECTED]Error while runSyncFS sub-routine is called

Explanation:-
it seems that it is not able to synchronize the filesystem.

Solution which worked for me
First I checked the ad_adop_sessions and checked the status. Then I queried

select * from ad_adop_session_patches order by end_date desc;

It gave status as N which means “Not Applied In the current node but applied in other nodes”

Action plan :
First we need to abort the failed session

adop phase=abort

Then Synchronize the filesystem using

adop phase=fs_clone

Then I proceeded with

adop phase=prepare



Saturday, November 7, 2015

How to apply patch in R12.2

There are five phases or life cycles of ADOP which are:

a) PREPARE
b) APPLY
c) FINALIZE
d) CUTOVER
e) CLEANUP

Download the patch and unzip on $PATCH_TOP.

Prepare the system for patching.

$ adop phase=prepare

Apply the patch on system

adop phase=apply patches=21068635

Finalize phase - Used to perform the final patching operations that can be executed while the application is still online:

adop phase=finalize

Cutover phase - Used to perform the transition to the patched environment

adop phase=cutover

Cleanup phase - Used to remove old objects that are no longer needed:

$ . /EBSapps.env run

adop phase=cleanup

Now synchronise the technology level between patch and run fc_clone.

adop phase=fs_clone

Friday, October 30, 2015

Unable to Log-In just after installation of R12.2.0

Error:-

You are trying to access a page that is no longer active.
- The referring page may have come from a previous session. Please select Home to proceed.

Solution:- 

1) select session_cookie_domain from icx_parameters;

2) update icx_parameters set session_cookie_domain='host_name.domain';
commit;

3) Restarted Apache

cd $ADMIN_SCRIPTS_HOME
adapcctl.sh stop
adapcctl.sh start