Exadata Certification: Verify InfiniBand Fabric Topology

Exadata Certification: Verify InfiniBand Fabric Topology: Verifying infiniband topology whether it is configured current or not. If it not gives the desired output as per below then it will cause t...

Exadata Certification: Verify Hardware and Firmware on Exadata Components...

Exadata Certification: Verify Hardware and Firmware on Exadata Components...: If the hardware and firmware are not validated, inconsistencies between database and storage servers can lead to problems and outages. W...

Exadata Certification: Exadata Monitoring Tools

Exadata Certification: Exadata Monitoring Tools: Listed known Exadata monitoring tools as well as configuration check tool Exacheck -- To check whether Exadata configuration has been d...

Exadata Certification: User Equivalence between DB Node and Storage Cell

Exadata Certification: User Equivalence between DB Node and Storage Cell: We are configuring SSH equivalence for oracle user between DB server and storage as per below First I am checking the hostname on storage s...

Exadata Certification: DBFS creation in Oracle

Exadata Certification: DBFS creation in Oracle: Follow below steps to create DBFS -- Create the mount point for DBFS [root@db01 ]# mkdir /dbfs_dir --Setup the database [root@db...

Exadata Certification: Pre-login Message / Banner Configuration in Linux

Exadata Certification: Pre-login Message / Banner Configuration in Linux: Create a text file with banner description #vi /etc/ssh/ssh-banner-message.txt WARNING: Unauthorized access to this system is forbidd...

Exadata Certification: ASR Installation and Registration procedure with O...

Exadata Certification: ASR Installation and Registration procedure with O...: Plateforms: RHEL 3 or latter x86 SUSE Linux 9 or latter x86 OEL 4 or latter x86 Software Requirement (08/10/2013) : Oracle Automat...

Exadata Certification: Location of Log files in Exadata

Exadata Certification: Location of Log files in Exadata: On the cell nodes ================ 1. Cell alert.log file /opt/oracle/cell/log/diag/asm/cell/{node name}/trace/alert.logorif th...

The Arup Nanda Blog: Advanced Linux Commands Mastery Series on OTN

The Arup Nanda Blog: Advanced Linux Commands Mastery Series on OTN: Luis Daziano from Argentina asked me about the location of the series I wrote for Oracle Technology Network on Advanced Linux commands. For...

The Arup Nanda Blog: New York Oracle User Group Fall Conference Materia...

The Arup Nanda Blog: New York Oracle User Group Fall Conference Materia...: Thank you all who attended my sessions at NYOUG Fall Conference this morning. I appreciate spending you most precious commodity - your time ...

alt.oracle: RMAN 12c – More SQL without ‘sql’

alt.oracle: RMAN 12c – More SQL without ‘sql’: Up until version 12c, the RMAN command line parser was capable of parsing certain DML and DDL statements.  To do this, we use the “sql” com...

alt.oracle: Oracle 12c - Out With the Grid, In With the Cloud

alt.oracle: Oracle 12c - Out With the Grid, In With the Cloud: So Oracle database 12c is out now.  The cloud (and hence the “c”) is hanging over us.  At least we don’t have to hear about “the grid” anymo...

Oracle Database 12c: Consolidating to Oracle 12c Multitenant Architectu...

Oracle Database 12c: Consolidating to Oracle 12c Multitenant Architectu...: Now that Oracle 12c has been released we want to consolidate our databases to a Multitenant Architecture. Note:  This blog post will be...

Oracle Database 12c: ASM 12c External Redundancy Diskgroup Handles Corr...

Oracle Database 12c: ASM 12c External Redundancy Diskgroup Handles Corr...: I had the pleasure of working for a company where I came across an ASM corruption where to this day no vendor was able to find the root caus...

Oracle Database 12c: ASM 12c New Feature Replace Command

Oracle Database 12c: ASM 12c New Feature Replace Command: We are going to test the new replace command for a simulated disk failure. In the test we will simulate that disk DG_DISK1A is bad after a b...

Oracle Database 12c: Oracle Database 12c New AWR Report Sections

Oracle Database 12c: Oracle Database 12c New AWR Report Sections: Below are a few new sections I found in the Oracle Database 12c AWR Report This sections contains info on GoldenGate component...

Oracle Database 12c: ASM 12101 Normal Redundancy Testing

Oracle Database 12c: ASM 12101 Normal Redundancy Testing: We will be testing normal ASM redundancy using ASM 12c. The test will simulate a device failure for one of the devices used by ASM disk. I...

Oracle Database 12c: Upgrade Grid Infrastructure Cluster 11203 to 12101...

Oracle Database 12c: Upgrade Grid Infrastructure Cluster 11203 to 12101...: This is an out-of-place upgrade, which will create a new GI home and leave old home untouched for us to rollback/downgrade easily. My Set...

Oracle Database 12c: Create Oracle Database 12c Container Database (CDB...

Oracle Database 12c: Create Oracle Database 12c Container Database (CDB...: In this demo I show how to create a CDB using DBCA If you have not read or heard about CDB or PDB I recommend a few references below. C...

Oracle Database 12c: Install Oracle Database 12c Single Instance Softwa...

Oracle Database 12c: Install Oracle Database 12c Single Instance Softwa...: Install Oracle Database 12c Single Instance Software Only Installing Oracle Database 12c Software Only 1. ./runInstaller 2. N...

Oracle Database 12c: Oracle Database 12c Multitenant Architecture Part ...

Oracle Database 12c: Oracle Database 12c Multitenant Architecture Part ...: Now that Oracle Database 12c has been release everyone wants to know about the new multitenant architecture. In part 1 of the multitenant A...

Oracle Database 12c: Provision Cross Platform non-CDB 11gr2 to Pluggabl...

Oracle Database 12c: Provision Cross Platform non-CDB 11gr2 to Pluggabl...: In this demo I will show how to provision PDB on RedHat Linux from a non-CDB 11gr2 on Solaris. You maybe ask what the reason is for mov...

Oracle Database 12c: Use Database 12c Net Manager to Configure TNS for ...

Oracle Database 12c: Use Database 12c Net Manager to Configure TNS for ...: In this demo I will show how to use the well known Net Manager utility to configure the local TNS file on the Multitenant environment. The N...

Oracle Database 12c: RMAN Backup for Multitenant Architecture

Oracle Database 12c: RMAN Backup for Multitenant Architecture: In this demo I will show how to handle different types of RMAN backups in a Multitenant environment. In a Multitenant environment for c...

Oracle Database 12c: Startup and Shutdown of a Container Database

Oracle Database 12c: Startup and Shutdown of a Container Database: In this demo I show how to shutdown and start the container database. I also show what you need to do with your pluggable databases after a ...