R12 Sysadmin account got locked after N number of invalid attempts

Run this query and make sure the account got locked

SELECT DECODE (encrypted_user_password
             , 'INVALID', 'Account locked'
             , 'Account not locked')
  FROM fnd_user
WHERE user_name = '&username';


We can't unlock the account as similar to dba_users account. Please use below command to reset the password.

FNDCPASS apps/XXXXXXX 0 Y system/XXXXXX USER SYSADMIN XXXXXXXX

adop failed with "Patch service is not exist or running"

While applying the patch  ,getting the error "Patch service  is not exist or running".


validating system setup.
    Node registry is valid.
    Log: /u01/JAYPRE/fs1/inst/apps/JAYPRE_JJ10003/logs/appl/rgf/TXK/verifyssh.log
    Output: /u01/JAYPRE/fs1/inst/apps/JAYPRE_JJ10003/logs/appl/rgf/TXK/out.xml
    Remote execution is operational.
    [ERROR]     Patch service  is not exist or running
 
Package AD_ZD_PREP is invalid.
                
SQL> alter package apps.AD_ZD_PREP compile;

Warning: Package altered with compilation errors.

SQL> show errors package body apps.AD_ZD_PREP;
Errors for PACKAGE BODY APPS.AD_ZD_PREP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
463/3    PL/SQL: SQL Statement ignored
463/19   PL/SQL: ORA-00942: table or view does not exist
467/5    PL/SQL: SQL Statement ignored
467/21   PL/SQL: ORA-00942: table or view does not exist
501/5    PL/SQL: SQL Statement ignored
501/21   PL/SQL: ORA-00942: table or view does not exist


Run adgrants.sql script
SQL> @adgrants.sql APPS

SQL>  alter package apps.AD_ZD_PREP compile;

Package altered.

Now retry adop.It should work.

How to increase stuck thread timeout in weblogic?

a.Start the WebLogic Administration Console by typing http://[hostname]:[port]/console in the URL line of a web browser.
b.Under Change Center, click Lock & Edit.
c.Under Domain Structure, click Environment > Servers and, in the right pane, click the managed server name.
d.On the Configuration tab, click on the Tuning tab.
e.In the Stuck Thread Max Time box, type 1800 and then click Save.

How to open Oracle Forms in linux browser?

a.Download the jre-8u181-linux-i586.tar.gz 
b.cd /root & Extract it in one of the directory (Ex: /root ).
c.cd /usr/lib64/mozilla/plugins
d.ln -s /root/jre1.8.0_181/lib/amd64/libnpjp2.so
e.cd /root/jre1.8.0_181/bin;./jcontrol (Add the security Exception)
f.Now try to relaunch the browser and open forms.

How to avoid nodemanager passsword prompt everytime while starting/stopping OHS12c?

$DOMAIN_HOME/bin/startComponent.sh ohs1 storeUserConfig

Subsequent stop and start calls can be made without the extra parameter and without specifying any node manager password.

adop cutover failed with [UNEXPECTED]Please complete Autoconfig on all nodes.

Issue:
=====
Cutover failed with error [UNEXPECTED]Please complete Autoconfig on all nodes.

Execute the below query:
===================
select count(*) from ad_adop_session_patches where adop_session_id = 82 and autoconfig_status <> 'Y'
and bug_number in ( select bug_number from ad_adop_session_patches where adop_session_id = 4 and autoconfig_status='Y' and bug_number <> 'CLONE' and bug_number <> 'CONFIG_CLONE' ) and node_name in ('node1','node2','node3');

If the query returns any row,then please follow below steps.

Solution:
=======
i. Source patch file system env file
ii.Run autoconfig and provide patch context file if prompted for context
iii.Update the ad_adop_session_patches table with below steps:
a. Take a backup of ad_adop_session_patches table
b. update ad_adop_session_patches set autoconfig_status='Y' where adop_session_id=82;"
c. commit;
iv. Rerun cutover again.

How to Clone a Container database using RMAN Backup

Please follow the steps from this Clone_Document