Ameer Khan

To start or stop weblogic, forms , reports in windows fusion middleware 12.2.1.4 we need to execute command manually through cmd. It becomes hectic and time consuming to start and stop these services one by one. To ease the entire startup/shutdown process we can create services for Nodemanager, weblogic admin server , forms ,reports. Create… Continue Reading

No ADR homes are set Recently for one my customer, I upgraded database from 12c to 19c. So after upgrade when I tried to use adrci utility It showed me “No ADR base is set” message [oracle@oda02 ~]$ adrci ADRCI: Release 19.0.0.0.0 – Production on Sun Nov 20 12:12:58 2022 Copyright (c) 1982, 2019, Oracle… Continue Reading

 Recently I faced one error while upgrading oracle database 11.2.0.4 to 19.3.0 using auto upgrade utility. I checked the status of the job and found it was errored out. So I quickly gone through the log files as mentioned in above and found few error messages like 2021-12-09 20:27:53.940 ERROR Database Upgrade Error in File… Continue Reading

How to determine if any certificates used by the OMS 1.Run the command below to check the status of the OMS and gather its details for hostnames and ports and SLB/virtual hostname details Login to OMS server $export ORACLE_HOME=<%MIDDLEWARE_HOME%>Example:$export ORACLE_HOME= /data2/app/oracle/middleware [oem@ccuine25 middleware]$ cd $ORACLE_HOME/bin [oem@ccuine25 bin]$ ./emctl status oms -details Oracle Enterprise Manager Cloud… Continue Reading

Recently in Dec2021, a vulnerability was found in Log4j, an open-source logging library commonly used by apps and services across the internet. This vulnerability has shaken the entire world. To mitigate this vulnerability in Oracle Fusion Middleware, Oracle recommends to apply following patches . Download following patches for WLS Release 12.2.1.4 1.    Download latest Opatch for… Continue Reading

While installing agent in target host for oracle enterprise manager 13c, following error is observed Solution:- This issue has two different solutions 1.       Change the entry “Defaults !visiblepw” to “Defaults visiblepw” in the /etc/sudoers file and re-try Agent Deployment. This needs to be done in host server. 2. You can also set the “oracle.sysman.prov.agentpush.enablePty” property… Continue Reading

While installing agent in target host for oracle enterprise manager 13c, following error is observed EM 12c, 13c: Error During Agent Installation : Ensure central inventory is owned by install user, has read and write permission Solution:- Make sure in inventory_loc in /etc/oraInst.loc file points to a valid inventory location and it is writable by… Continue Reading

 To get forms process id first. SQL> SET LINES 222 SQL> col MODULE for a40 SQL> col ACTION for a40 select sid,serial#,process,module,action from v$session where process=(SELECT p.os_process_id FROM FND_CONCURRENT_REQUESTS r, FND_CONCURRENT_PROCESSES p  where r.controlling_manager = p.concurrent_process_id and request_id=211503612) To get more details of process id and command kill that session:- select s.ECID ,s.inst_id, s.SID,s.SERIAL#,p.spid,s.status,s.machine, s.ACTION,… Continue Reading

1.       Create webutil schema SQL> create user webutil identified by Concept_ora1; SQL> grant dba to webutil; Login to application server, and connect to sqlplus  Cd D:\app\oracle\product\12.2.1.4\bin D:\weblogic\Middleware\12.2.1.4\bin>sqlplus webutil@PRDPDB SQL> @D:\app\oracle\product\12.2.1.4\forms\create_webutil_db.sql SQL> create public synonym webutil_db for webutil.webutil_db; 2.       Download the jacob version 1.2 and unzip it in the directory of your choice – https://github.com/freemansoft/jacob-project/releases unzip jacob-1.20.zip cd jacob-1.20 copy… Continue Reading

V$TRANSACTION lists the active transactions in the database Use following query to find out uncommitted active transactions in database select t.start_time,a.sid,a.serial#,a.username,a.status,a.schemaname, a.osuser,a.process,a.machine,a.terminal,a.program,a.module,to_char(a.logon_time,’DD/MON/YY HH24:MI:SS’) logon_time from v$transaction t, v$session a where a.saddr = t.ses_addr order by start_time; To find out sql statement of uncommitted transaction SELECT a.SID, a.SERIAL#, a.USERNAME, a.OSUSER, a.PROGRAM, a.EVENT   ,TO_CHAR(a.LOGON_TIME,’YYYY-MM-DD HH24:MI:SS’)   ,TO_CHAR(T.START_DATE,’YYYY-MM-DD HH24:MI:SS’)   ,a.LAST_CALL_ET,… Continue Reading