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

R12.2 OHS was not coming up after unclean shutdown or due to server crash.

Issue: 

R12.2 OHS  was not coming up after unclean shutdown or due to server crash.

processes in Instance: EBS_web_TEST_OHS1
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
EBS_web_TEST                     | OHS                |   6194  | Stop 

OHS was in STOP state and we were not able to either bring down or bring up. It shows PID as 6194 which doens't exist in server.

In logs we were getting below errors.

Log file Location /u01/applmgr/TEST/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/diagnostics/logs/OHS/EBS_web_TEST/

-- console~OHS~1.log:/u01/applmgr/TEST/fs1/FMW_Home/webtier/ohs/bin/apachectl hardstop: httpd (pid 6194?) not running.

EBS_web_TEST.log:[2017-12-08T14:24:32.4446+05:30] [OHS] [WARNING:32] [OHS-9999] [core.c] [host_id: acsebs.oracle.com] [host_addr: 192.168.1.8] [pid: 6194] [tid: 140126851569472] [user: applmgr] [VirtualHost: main]  pid file

/u01/applmgr/TEST/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/diagnostics/logs/OHS/EBS_web_TEST/httpd.pid overwritten -- Unclean shutdown of previous Apache run?

Caution:
So it is very clear that OHS was not shutdown properly.Due to this some lock file or httpd.pid files with old pid exists. we have to remove this and  bring up.


Solution:
a. First shutdown opmn process using adopmnctl.sh stop
b. Remove httpd.pid file from /u01/applmgr/TEST/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/diagnostics/logs/OHS/EBS_web_TEST/
c. cd /u01/applmgr/TEST/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/config/OPMN/opmn/states
d. grep 6194 * -- You will get  the filename from this command.
e. Remove the file and try to start the OHS. It will come up.

How to check If a patch is applied in R12.2

In eBusiness Suite (EBS) 12.2.x you cannot query the AD_BUGS table to check if patches have been applied.The AD_BUGS table may have entries for patches that were applied but later the patching cycle was aborted (not really applied).


To check whether a patch is really applied use the AD_PATCH.IS_PATCH_APPLIED pl/sql function.Using this API is an alternative method for users without access to Oracle Applications Manager's "Patching and Utilities" feature to determine if a certain patch is applied.



Query to Find in single app tier or shared application tier Environment:
select ad_patch.is_patch_applied('R12',-1,20034256) from dual;

Expected results:
EXPLICIT = applied
NOT APPLIED = not applied / aborted


To check Multiple patches,Please use below query:

SELECT adb.bug_number,ad_patch.is_patch_applied('R12',-1, adb.bug_number) FROM ad_bugs adb WHERE adb.bug_number in ('25820806','26720905',
'24591000','26482811','25828573','26400116','26720231','25994411');


To get output in human readable format:
set serveroutput on;
DECLARE
TYPE p_patch_array_type is varray(30) of varchar2(10);
p_patchlist p_patch_array_type;
p_patch_status varchar2(15);
p_appl_top_id number;
p_result varchar2(15);
p_instance varchar2(15);
procedure println(msg in varchar2)
is
begin
dbms_output.enable(1000000);
dbms_output.put_line(msg);
end;
BEGIN
p_patchlist:= p_patch_array_type('25820806','26720905','24591000','26482811','25828573','26400116','26720231','25994411','89989');
println('=============================');
for i in 1..p_patchlist.count
loop
p_patch_status := ad_patch.is_patch_applied('R12',-1,p_patchlist(i));
case p_patch_status
when 'EXPLICIT' then
p_result := 'APPLIED';
else
p_result := p_patch_status;
end case;
println('Patch ' || p_patchlist(i)|| ' - ' || ' - IS ' || p_result);
end loop;
println('.');
END;
/

Query to find patch information  for a specific node in a multinode environment (1045 is the APPL_TOP ID):
Syntax: select AD_PATCH.IS_PATCH_APPLIED(\'$release\',\'$appltop_id\',\'$patch_no\',\'$language\') from dual;

SELECT adb.bug_number,ad_patch.is_patch_applied('R12', 1045, adb.bug_number) FROM ad_bugs adb WHERE adb.bug_number in (20034256);

APPL_TOP_ID -->you cat gen  from ad_appl_tops table.