Monthly Archives: July 2014

ORA-27300: OS system dependent operation:invalid_egid failed with status: 1

When I tried to create a  new database for RAC environment using DBCA, It shows the error about invalid grid and diskgroup not mounted. Error Details are ORA-27300: OS system dependent operation:invalid_egid failed with status: 1 ORA-27301: OS failure message: … Continue reading

Posted in ASM, Oracle RAC | 1 Comment

dbca error ORA-12560: TNS:protocol adapter error

ORA-12560 during database creation in Win Server 2008 64bit   I encountered the following error during creation of database in Windows Server 2008 64bit domain: ORA-12560: TNS:protocol adapter error The version that I am using is Oracle Database 10.2.0.4   I … Continue reading

Posted in Database administration | Leave a comment

How to clone Oracle Binaries

DBAs sometimes install Oracle software by using a utility such as tar to copy an existing installation of the Oracle binaries to a different server . This approach is fast and simple . This technique allows DBAs to easily install the … Continue reading

Posted in Database administration | Leave a comment

Create Database Manually

Create database Manually in a few steps 1- Create Pfile [oracle@11gdb02 dbs]$ cat initorcl.ora db_name=’orcl’ compatible=’11.2.0′ diagnostic_dest=’/u02/app’ audit_file_dest=’/u02/app/diag/adump’ sga_target=300M processes=100 undo_tablespace=’UNDOTBS1′ control_files=(‘/u02/app/orcl/control01.ctl’) 2- Create Password file [oracle@11gdb02 dbs]$orapwd file=$ORACLE_HOME/dbs/orapworcl password=oracle entries=10 3- Create Database Script [oracle@11gdb02 dbs]$ cat create_orcl.sql create … Continue reading

Posted in Uncategorized | Leave a comment