Here are very useful Oracle 12c pluggable database commands which will very helpful in day to day DBA administration for Container and Pluggable database Query to check if the database is CDB or non-CDB SELECT NAME, CDB, CON_ID FROM V$DATABASE; NAME CDB CON_ID ————————— ——— ———- CDB01 YES 0 how to check container database in […]
Active Dataguard in Oracle
What is Active Dataguard in Oracle The Active Data Guard Option available with Oracle Database 11g Enterprise Edition enables you to open a physical standby database for read-only access for reporting, for simple or complex queries, sorting while Redo Apply continues to apply changes from the production database to the standby database. All queries reading […]
DBCLI commands for DBCS and Bare Metals in OCI
What is DBCLI It is a command line interface available on bare metal and virtual machine DB systems. The database CLI commands must be run as the root user dbcli is in the /opt/oracle/dcs/bin/ directory. Oracle Database maintains logs of the dbcli command output in the dcscli.log and dcs-agent.log files in the /opt/oracle/dcs/log/ directory. How […]
Understanding IP Addresses, Subnets, and CIDR Notation
We need to have the basic knowledge of Networking concepts like IP Addresses, Subnets, and CIDR Notation before working on any Cloud infrastructure. Here I am giving the basic and to the my knowledge on few important concept like CIDR notation, Subnet Mask, Subnetting which will be useful for any cloud vendors What is IP […]
Simple View of Functions in Shell Script with some practical examples
Shell programming provides the feature of functions just like any other programming language. This help us develop the program in a modular manner.Using functions in shell script to perform repetitive tasks is an excellent way to create code reuse. Code reuse is an important part of modern object-oriented programming principles. What are functions in Shell Script? […]
What is PLSQL records in Oracle
Oracle PLSQL records PLSQL records are composite datatypes .It is a group of related data items as fields ,each with its own name and datatype. PL/SQL records are similar in structure to a row in a database table. Each scalar data types in the record holds a value. A record consists of components of any […]
