Loading and unloading java Jar in to database
1.For Loading jar use cmd loadjava -force -genmissing -r -user username/password@servicename -verbose jar 2.For droping jar use cmd ...
Company Blog
Events, Activities, Achievements and Announcements from Doyensys.
Finding session which genrates lo of redo
Query: select s.sid,sn.SERIAL#,n.name, round(value/1024/1024,2) redo_mb, sn.username,sn.status,substr (sn.code1,1,21) “code”, sn.type, ...
Query to find how many chained (and migrated) rows each table has
Query: SELECT owner, table_name, chain_cnt FROM dba_tables WHERE chain_cnt > 0; SELECT owner_name,table_name,count(head_rowid) row_countFROM ...
AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.
ERROR: While running adcfgclone faced below error, AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora. ...
How to update Workflow Administrator Role in Oracle EBS
How to update Workflow Administrator Role in Oracle Applications 1..update wf_resources set text=’&Enter_Admin_Name’ where ...
Loading and unloading java Jar in to database
1.For Loading jar use cmd loadjava -force -genmissing -r -user username/password@servicename -verbose jar 2.For droping jar use cmd dropjava -f -verbose -u ...
Finding session which genrates lo of redo
Query: select s.sid,sn.SERIAL#,n.name, round(value/1024/1024,2) redo_mb, sn.username,sn.status,substr (sn.code1,1,21) “code”, sn.type, sn.module,sn.sql_id from v$sesstat s join ...
Query to find how many chained (and migrated) rows each table has
Query: SELECT owner, table_name, chain_cnt FROM dba_tables WHERE chain_cnt > 0; SELECT owner_name,table_name,count(head_rowid) row_countFROM chained_rows GROUP BY owner_name,table_name
AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.
ERROR: While running adcfgclone faced below error, AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora. [AutoConfig Error Report] The following ...
How to update Workflow Administrator Role in Oracle EBS
How to update Workflow Administrator Role in Oracle Applications 1..update wf_resources set text=’&Enter_Admin_Name’ where name=’WF_ADMIN_ROLE’; e.g update ...
ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE
Error: ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE Cause: a database link connected to a database with a different name. The connection is rejected. Solution: I checked ...
ORA-12609: TNS: Receive timeout occurred 12 & 19c
Sometimes You can get “ORA-12609: TNS: Receive timeout occurred ” error. Details of error are as follows. ORA-12609: TNS: Receive timeout occurred Cause: The receive or read operation did not ...
Agent resident memory utilization in KB is
EM Incident: Warning:New: – Agent resident memory utilization in KB is 1. ./emctl stop agent Ensure no EMAgent process is running with the following commands: ...
ORA-01552: cannot use system rollback segment for non-system tablespace, clone database
ORA-01552: cannot use system rollback segment for non-system tablespace “TBS Name” ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Tried to use the ...
Enhance your Business Operations with Oracle ERP Health Check
A well-executed ERP system is a highly valued business strategy secured by every organization. When a company successfully implements the right ERP solution, aptly managed and monitored, it can ...