Oracle and MySQL Database
Change AWR snapshot Retention period and Interval in Oracle: In this article we will discuss about how to Change AWR snapshot Retention period and Interval in Oracle. About AWR Report: Oracle MMON background process collect the AWR statistics and generate the snapshot based on retention period, which violates the threshold metric. You can enable this … Read more
How to create a password file using ORAPWD Utility in oracle: In this post we will discuss about how to create a password file using ORAPWD Utility in oracle. What is password file in ORACLE ? The password file stores a list of usernames and passwords that are allowed to remotely authenticate as SYSDBA over … Read more
Oracle 19c 2 node RAC to single instance standby database setup: In this article we will discuss about how to setup Oracle 19c 2 node RAC to single instance standby database step by step. Environment Details for both (Primary and Standby): Primary Server side Configurations:- Make sure primary is in archivelog mode: Check FORCE LOGGING … Read more
Upgrade Oracle Database from 12c to 19c using the RMAN backup : In this article we will discuss about how to Upgrade Oracle Database from 12c to 19c using the RMAN backup. Enviroment: Steps of Oracle Database 19c Restore from 12c rman backup : In Oracle 12c : Create pfile from spfile of 12cR2 database: … Read more
For a DBA, starting up and shutting down of oracle database is a routine and basic operation. Sometimes Linux administrator or programmer may end-up doing some basic DBA operations on development database. So, it is important for non-DBAs to understand some basic database administration activities. Oracle Database startup and shutdown procedure Oracle Database startup and … Read more
Compile Invalid Objects In Oracle : In this article we will discuss about how to Compile Invalid Objects In Oracle. Objects in the database can become invalid, if there are any changes to the dependent objects. Oracle recommends that you run the utlrp.sql script after you install, patch, or upgrade a database, to identify and … Read more
MAX_STRING_SIZE Parameter in Oracle 19c : In this article we will discuss about MAX_STRING_SIZE Parameter in Oracle 19c. This parameter was introduced in Oracle 12c onwards. MAX_STRING_SIZE controls the maximum size of string size in Oracle database. By default this parameter value is STANDARD, We can change the value of MAX_STRING_SIZE from STANDARD to EXTENDED, … Read more
How to Find Out the size of your Oracle Database : In this Article we are going to discuss about How to Find Out the size of your Oracle Database. Database Sizes : We can find out Database Total Size, Database Used Size, Database Free Size using below queries. Also you can use below mentioned … Read more
Transparent Data Encryption In Oracle : In this article we will discuss about configuring and enabling Transparent Data Encryption (TDE) in Oracle 19c. To configure Auto Login Wallet in Oracle 19c there are few parameters which needs to be set in spfile. Lets see how to configure TDE. I need to create a subdirectory for … Read more
During this article we will discuss how to Exclude Tablespace from Backup and configure Exclude option using RMAN. Sometimes we may exclude one or more tablespace from our database RMAN backup or regular RMAN backup. Suppose a tablespace contains test data only or its data never changed in such cases, we may exclude this from … Read more
