PaSSword File – orapwd Utility in Oracle

Password file – orapwd utility in Oracle Oracle password file stores passwords for users with administrative privileges. If the DBA wants to start up an Oracle or ASM instance there must be a way for Oracle to authenticate the DBA. Obviously, DBA password cannot be stored in the database, because Oracle cannot access the database […]

Oracle Database Tips by Ankush Thalavi The oerr itulity and show how oerr is used to display Oracle error message details: Viewing Errors with the oerr Utility is simple The oerr utility (Oracle Error) is provided only with Oracle databases on UNIX platforms. oerr is not an executable, but instead, a shell script that retrieves […]

How to Set up Oracle Database Server on VMware Workstation using( OEL) Linux 7.6 OS Platform?     1.Download Vmware Workstation Pro 2.Download LINUX 7.6 iso files 3.install LINUX 7.6     1.Download and Install latest Vmware Workstation Pro on Windows 10 Machine.         LOCATION:     LINK:   https://www.vmware.com/in/products/workstation-pro/workstation-pro-evaluation.html     2.Download […]

Oracle Listener   The Databases/services needs to be registered with listener in order to establish connection.There are two types of registration Namely    1.Dynamic Registration  2.Static Registration   Dynamic registration : As the name suggests,dynamic means the Database/Service registration is done Automatic. As soon as the listener is started Automatically the dynamic registration happens which […]

SQL Tuning Advisor – Performance Tuning SQL Tuning Advisor How to run SQL Tuning Advisor Manually SQL Tuning Advisor is SQL diagnostic software in the Oracle Database Tuning Pack. SQL Tuning Advisor is a mechanism for resolving problems related to suboptimally performing SQL statements. Use SQL Tuning Advisor to obtain recommendations for improving performance of […]

Oracle Explain Plan – Performance Tuning 1. Creating a Plan Table The first thing you will need to do is make sure you have a table called PLAN_TABLE available in your schema. The following script will create it for you if you don’t already have it: export ORACLE_SID=PrimeDG sqlplus / as sysdba @?/rdbms/admin/utlxplan.sql   2. […]

How To  Generate an ADDM Report? ADDM (Automatic Database Diagnostic Monitoring) Report: Automatic Database Diagnostic Monitoring Report analyzes the AWR data on a regular basis, to give you overview of the root cause of the problem which is affecting your database’s performance. It also provides suggestions or recommendations for rectifying any problem identified and lists […]

How to generate AWR report from Oracle Database?   AWR (Automatic Workload repository) Report: Automatic Workload Repository gathers, processes and maintains performance stats used for problem detection and self-tuning the databases. This collective information can be displayed as views and reports (HTML/text) to better show the current database performance status for further analysis.     […]

How to generate an ASH report from Oracle Database?   ASH reports give a quick glance of how the database has performed between two snapshots. It mainly highlights the following areas: Top User Events (frequent wait events) Details to the wait events Top Queries Top Sessions Top Blocking Sessions Top DB Objects Activity Over Time […]

How to duplicate 19c database on remote server Using RMAN’s Active Duplicate feature?   Task: Task is to clone a database called TESTDB to CLONEDB using RMAN’s Active Duplicate feature.   Source and Destination is as follows: Subject Source Destination IP Address: 192.168.0.197 192.168.0.198 Database Name: TESTDB CLONEDB Database Status OPEN Not Available yet Database […]