Key Milestones for Doyensys in 2021
We are happy to share our Key Milestones achieved for the last year. We aligned our efforts and activities with proper solutions and technologies to address our client’s problems. A…
Read MoreNew Cloud Regions in Sweden, Italy & South Africa
With high client demand for Oracle Cloud services, Oracle currently has 37 cloud regions worldwide, with intentions to have a minimum of 44 cloud regions by the end of 2022,…
Read MoreORA-01775: looping chain of synonyms
I encounter the looping chain of synonyms error Reason:- ORA-01775: looping chain of synonyms – Basically means that you created a synonym that points to another object in a circle.…
Read MoreCheck Out the Recent Oracle Analytics Updates for 2022
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 MoreBusiness Benefits of Oracle Cloud ERP
The 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 MoreLoading 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 username/password@servicename -schema schmeaname jar Jar…
Read MoreFind the session which generates more archive log
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 v$statname n on n.statistic# = s.statistic# join v$session sn on sn.sid = s.sid where n.name…
Read MoreQuery 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
Read MoreAC-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 report lists errors AutoConfig encountered during each phase…
Read MoreHow 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 wf_resources set text=’FND_RESP|SYSADMIN|SYSTEM_ADMINISTRATOR|STANDARD’ where name=’WF_ADMIN_ROLE’; 2. Change the value of Context file parameter…
Read More