3 min read
Hey Folks, We have recently faced issue with huge lag due to bulk transaction(Insert Operation). To resolve the gap quickly,...
3 min read
5 min read
Datafiles are part of the Oracle Database, these are the files that have the actual data in them. Datafiles can...
1 min read
Grid-Installation-ASRBLG-1Download Hope it helped !! :)
2 min read
Backup of the Oracle home can be taken using any preferred method. You can use any tool such as zip,...
1 min read
To create a shell script to run export/import utilities. # SCRIPT # --------- # # Set environment variables for ORACLE_HOME,...
1 min read
There are many middleware tools which require latest version of java jdk to be installed on your Linux machine. You...
1 min read
The ps utility can get the process state. The process state code will contain the character + when running in...
1 min read
1. Create a pfile as a backup of your spfile sqlplus '/ as sysdba' SQL> create pfile='/tmp/spfile-bk.ora' from spfile; 2....
5 min read
A profile is a collection of attributes that apply to a user.The profile is used to enable a single point...
10 min read
About User Accounts:The areas in which you can configure security are as follows: • User accounts For users to access...
6 min read
Many people ask these Questions, Q. How to identify which column is candidate for Index creation? Q. How to determine...
2 min read
This content is password protected. To view it please enter your password below: Password:
4 min read
What is Recovery Catalog? A recovery catalog is a database schema used by RMAN Which is used to stored Metadata...
1 min read
SELECT NAME ,OPEN_MODE FROM V$DATABASE;SELECT LOG_MODE FROM V$DATABASE;SELECT NAME FROM V$DATAFILE;SELECT NAME FROM V$TABLESPACE; CREATE TABLESPACE(TB1) RMAN > BACKUP DATABASE...
2 min read
Control file and Redolog file contains crucial database information and loss of these files will lead to loss of important...
1 min read
RMAN> show all; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; RMAN> CONFIGURE RETENTION POLICY TO NONE; The REDUNDANCY...
1 min read
SQL> select comp_id, status, version from dba_registry; COMP_ID STATUS VERSION ------------ ----------- -------------- CATALOG INVALID 11.2.0.3.0 CATPROC INVALID 11.2.0.3.0 SQL>...
SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED MOUNTED 3 PDB1 READ WRITE NO...
Advantages of AutoUpgrade Utility: ========================== 1. Time saving method (completes the upgrade in a short time) 2. can upgrade multiple...
Supported Upgrade PathsDirect upgrades are possible from existing databases with the following versions.Destination Source=========== ======12c Release 1 (12.1.0.2) 10.2.0.5+, 11.1.0.7+,...
3 min read
Prerequisite. Add below OS groups Add asmdba as secondary group to Oracle user Create Grid User # useradd -u 54331...
2 min read
COMMON USER: 1.A common user is a Database user, which perform an activity in all the containers including root container...
1 min read
The following explains how to rename a container (pluggable databases). Step-By-Step 1. Shutdown the pluggable database (PDB). SQL> show pdbs;...
4 min read
Oracle Database 12c introduced a new feature called “Multitenant.” The multitenant feature provides the ability for a single instance to...
1 min read
STEP-1- Create Gateway Subnet Resource Group > VNET>SUBNETS> GATEWAY SUBNETS>ADD – 10.0.1.0/24 (Available Free Subnet). STEP-2 Create Gateway Create. SEARCH...
