Life At doyensys – Saravana Kumar KP
Employees are the backbone of an organisation. With the right people, a company can not only achieve its goals but also surpass them. We want to thank our employees and…
Read MoreAR Non Printed invoices report
Introduction: This report will display all the Non printed invoices details to business. select (SELECT B1.ACCOUNT_NUMBER FROM apps.hz_cust_accounts_all B1 WHERE A.BILL_TO_CUSTOMER_ID=B1.CUST_ACCOUNT_ID)ACCOUNT_NUMBER, (SELECT E.PARTY_SITE_NUMBER FROM apps.hz_cust_acct_sites_all C, apps.hz_cust_site_uses_all D, apps.hz_party_sites E,…
Read MoreHow Doyensys Migrated a Client’s E-Business Suite to Cloud
As an organisation, Doyensys believes in pushing the boundaries and setting examples for others to follow. Our team of hard-working and talented Doyens is always willing to accept new challenges.…
Read MorePurge AUD$ Table
The AUD$ table growth will impact the performance of database so we want to purge it regularly by using the DBMS_AUDIT_MGMT package Check AUD$ table is not in SYSTEM table tablespace.…
Read MoreMoving AUD$ table to another tablespace using DBMS_AUDIT_MGMT
Steps to move the Audit table from SYSTEM tablespace to newly created tablespace. • Audit trail tables called SYS.aud$ and SYS.fga_log$ keeps all Audit records in the Oracle database and…
Read MoreCREATING AN EXTERNAL USER
EXTERNAL USER CREATION External users and their authentication are managed by external services such as operating system or a network service. If our OS environment is secured, we can enable…
Read MoreORA-01000 maximum open cursors exceeded
CURSORS A cursor is a temporary work area created in the system memory when a SQL statement is executed. It can hold more than one row but can process only…
Read MoreCONNECT TO USER WITHOUT KNOWING PASSWORD
We can connect to another user without knowing the password, with grant connect through privilege In this case a user TEST1 wants to connect to TEST2 user and create a…
Read MoreCREATE PASSWORD FILE IN ASM DISK GROUP
CREATE PASSWORD FILE IN ASM DISK GROUP FOR ORACLE 12C ONLY ASMCMD> pwcreate –dbuniquename {db_unique_name} {file_path} {sys_password} ASMCMD> pwcreate –dbuniquename PRDPRE +DATA/PWDFILE/pwdPRDPREoracle FOR ALL VERSION orapwd file=’+DATA/orapwPRODPRE’ ENTRIES=10 DBUNIQUENAME=’PRODPRE’
Read MoreModify ASM user password
LIST ASM USERS ASMCMD> lspwusr Username sysdba sysoper sysasm SYS TRUE TRUE TRUE CRSUSER__ASM_001 TRUE FALSE TRUE ASMSNMP TRUE FALSE FALSE MODIFY USER PASSWORD ASMCMD> orapwusr –modify asmsnmp Enter password:…
Read More