Oracle Analytics is a potent combination of three forces: augmented analytics, self-service analytics, and regulated analytics. Oracle provides a single solution with integrated machine learning and AI that swiftly grows…
Read MoreThe recent digital era changes much faster than it has ever been. Adopting new technology, embracing new business models, and using the cloud as a platform for constant innovation are…
Read More1.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 username/password@servicename -schema schmeaname jar Jar…
Read MoreQuery: 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 v$statname n on n.statistic# = s.statistic# join v$session sn on sn.sid = s.sid where n.name…
Read MoreQuery: 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
Read MoreERROR: While running adcfgclone faced below error, AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora. [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase…
Read MoreHow 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 wf_resources set text=’FND_RESP|SYSADMIN|SYSTEM_ADMINISTRATOR|STANDARD’ where name=’WF_ADMIN_ROLE’; 2. Change the value of Context file parameter…
Read MoreError: 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 the GLOBAL_NAMES. SQL> show…
Read MoreSometimes 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 complete within…
Read MoreEM Incident: Warning:New: – Agent resident memory utilization in KB is 1. ./emctl stop agent Ensure no EMAgent process is running with the following commands: <AGENT_HOME>/bin>./emctl status agent $ps…
Read More