Techgoeasy

Steps to clear Production credential in cloned EBS instance

Invalidating all the passwords in the database (1) Start the database clone for the first time startup restrict (2) Clear all production credentials from the cloned database( This step is not mandatory, we can avoid it also) update SYS.user$ setpassword = translate(password,’0123456789ABCDEF’,’0000000000000000′)where type#=1 and length(password) = 16/update APPLSYS.FND_ORACLE_USERID setENCRYPTED_ORACLE_PASSWORD=’INVALID’/update APPLSYS.FND_USER setENCRYPTED_FOUNDATION_PASSWORD=’INVALID’,ENCRYPTED_USER_PASSWORD=’INVALID’/commit; (3)Shutdown the database shutdown …

Steps to clear Production credential in cloned EBS instance Read More »

How to perform DML operations on Oracle View: Insert, Update, delete

Oracle, Oracle Sql

DML operations like insert, update, and delete are allowed in Oracle views with certain restrictions. Let’s check in this post to update the view in Oracle, insert into view Oracle, delete from view in Oracle DML on view in Oracle For example, Let’s first create the TEST view. Create view emp_data as select e.empno,e.ename,e.sal,e.deptno,d.dname From …

How to perform DML operations on Oracle View: Insert, Update, delete Read More »

How to check Stale statistics in Oracle Database

Oracle, Oracle Database

Statistics can become stale when the data in the table changes substantially. Up-to-date statistics are important to generate good execution plans How does Oracle decide if the stats have become stale Stats are considered stale when #(INSERTS + UPDATES + DELETES) >= 10% of NUM_ROWS from dba_tables: The parameter setting required to Track the table …

How to check Stale statistics in Oracle Database Read More »

RMAN List backup commands

Oracle, Oracle Database

RMAN List backup is a useful command to list the backup taken in the system. It shows all the details about the backup taken, what time it was taken, location of the backup. First, you need to connect with the Target database with or without a catalog and then these commands can be run. If …

RMAN List backup commands Read More »

how to find the Oracle database version

Oracle, Oracle Database

Many times questions are being asked about how to find the Oracle database version and version of various Oracle utilities in Linux, Solaris, AIX, and Windows. Let’s check out how is the oracle database version defined and How to find the Oracle database version Oracle Database Versions How to check Oracle database version in Linux …

how to find the Oracle database version Read More »

What is Essbase 21c

hyperion, Oracle

Essbase 21c is the latest version of Oracle essbase. It is the first release after 11.1.2.4 where Oracle is giving the option of installing on the on-prem machine. New Feature in Essbase 21c New Improved User Interface Essbase 21c has improved the user interface from the Essbase 19c Version. Shadow Application New Improved Outline Editor …

What is Essbase 21c Read More »