This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

Oracle DBA

/Oracle DBA

What happens if I lose my voting disk(s)?

By | February 2nd, 2014|Database, Oracle – RAC, Oracle DBA|

If you lose 1/2 or more of all of your voting disks, then nodes get evicted from the cluster, or nodes kick themselves out of the cluster. It doesn't threaten database corruption. Alternatively you can use external redundancy which means you are providing redundancy at the storage level using RAID. For this reason when using [...]

What is voting disk and used for?

By | February 1st, 2014|Database, Oracle – RAC, Oracle DBA|

A voting disk is a backup communications mechanism that allows CSS daemons to negotiate which sub-cluster will survive. These voting disks keep a status of who is currently alive and counts votes in case of a cluster reconfiguration. It works as follows: a) Ensures that you cannot join the cluster if you cannot access the [...]

Managing a Standby Database – Commands

By | December 16th, 2013|Database, DBA Miscellaneous, Oracle DBA|

ALTER DATABASE ACTIVATE [PHYSICAL] STANDBY DATABASE [SKIP [STANDBY LOGFILE]]   Changes the state of a standby database to an active database and prepares it to become the primary database.  ALTER DATABASE ADD [STANDBY] LOGFILE [THREAD integer] [GROUP integer]filespec Adds one or more redo log file groups to the specified thread, making them available to the instance assigned [...]

How to create blackout in Oracle Enterprise Manager 12c

By | December 6th, 2013|OEM, Oracle DBA|

Following are the Steps to Create Blackouts from EM Console: 1). Login to OEM 12c -> click Enterprise ->  Monitoring -> Blackouts. 2). Click on Create.   3). Enter Name, Comments, Reason and Select the Targets and click Next. 4). Select Members Targets  to Blackout and click Next  5). Select TimeZone, Duration and click Next. 6). Review the details given for Blackout and [...]

Data Dictionary Storage

By | October 21st, 2013|DB Architecture, Oracle DBA|

1). Data dictionary (also called system catalog) stores metadata such as: Information about relations names of relations names and types of attributes of each relation names and definitions of views integrity constraints 2). User and accounting information, including passwords 3). Statistical and descriptive data number of tuples in each relation 4). Physical file organization information [...]

How to use VLANs in Oracle RAC?

By | September 29th, 2013|Oracle – RAC, Oracle DBA|

It is Oracle's standing recommendation to separate the various types of communication in an Oracle RAC cluster as much as possible. This general recommendation is the basis for the following separation of communication: Each node in an Oracle RAC cluster must have at least one public network. Each node in an Oracle RAC cluster must [...]

Oracle Single Client Access Name (SCAN)

By | September 3rd, 2013|Oracle – RAC, Oracle DBA|

Single Client Access Name (SCAN) is a single name that allows client connections to connect to any database in an Oracle cluster independently of which node in the cluster the database (or service) is currently running. The SCAN should be used in all client connection strings and does not change when you add/remove nodes from [...]

Difference between user and schema oracle ?

By | May 23rd, 2013|Oracle DBA|

A schema is collection of database objects, including logical structures such as tables, views, sequences, stored procedures, synonyms, indexes, clusters, and database links. A user owns a schema. A user and a schema have the same name. The CREATE USER command creates a user. It also automatically creates a schema for that user. The CREATE [...]