ORA-15110: no diskgroups mounted

Applies to: Database Management Software Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.3 - Release: 10.2 to 11.2 Issu...

Verify Automatic Storage Management Installation

Applies to: Oracle 11g all Grid Editions   1. Login and set Env Variables:   First of all login to system using GRID owner user. Set ORA...

Oracle Restart

What is Oracle Restart : Applies to: Database Management Software Oracle 11g R2 Grid Infrastructure Oracle Restart is a high availabi...

How to set Oracle Environment Variable in Unix

Applies to: All unix based Operating system with Database Management Software Oracle. 1. First of all you need to know, exact location o...

How to Verify Parallel Execution using 3 Different Ways

Applies to: Database Management Software Oracle std & Enterprise Edition Oracle 10g to Oracle 11g. There are many ways to crossche...

ORA-28002: the password will expire within n days

Applies to: Database Management Software Oracle 11G all editions Issue:   ORA-28002: the password will expire within n days Example: ...

Shrink Space Check

Applies to:   Database Management Software Oracle 10.2.0.1 and Later The "ALTER TABLE ... SHRINK SPACE CHECK" statement is use...

Disable anonymous FTP

To disable anonymous ftp on Solaris either delete or comment out the `ftp' user from /etc/passwd and /etc/shadow files. To do it com...

Automatic Storage Management Compatibility

Applies to : Database Management Software Oracle 11g R1 to Oracle 11g R2 Automatic Storage Management introduce two new parameters in O...

Automatic Storage Management file generation scheme

Automatic Storage Management use system generated filename. So, Here is the method used by Automatic Storage Management to generate file n...

RMAN Basic Backup Commands

Applies to : Database Management Software Oracle 10.2.0.1 Std and Enterprise Edition to 11.2.0.2 Whole database backup: RMAN> backu...

Checking Oracle inventory Directory

$ more /etc/oraInst.loc if oraInst.loc exist, it will return inventory_loc=/u01/app/oraInventory inst_group=oinstall if the directo...

Shutdown unknown flag

Reason: Two shutdown commands in Solaris: One in /usr/sbin, and another in /usr/ucb. If user's path was set to check /usr/ucb when t...

FTP get I/O error

GET a file from a remote machine FTP will reports an I/O error. Problem: ftp> get (remote-file) solaris_1.tar.Z (local-file) solar...

find in current directory Only

find commands on the current directory on Solaris, without going into sub directories. Solution: Add the following operations with fin...

Find Solaris OS Release Installed

The easiest command to find is cat /etc/release like below: # cat /etc/release                         Solaris 10 5/08 s10x_u5wos_10 X8...