Oracle 11g Certified Masters

Create a database using OMF (Oracle Managed Files)

— Create the destination folders, root and subfolders /u01/oradata/ folder1 | folder2 | flash_recovery_area | diag — Create the PFILE DB_NAME=orcl600 DB_UNIQUE_NAME=orcl600 DB_CREATE_FILE_DEST=’/u01/oradata/folder1′ DB_CREATE_ONLINE_LOG_DEST_2=’/u01/oradata/folder2′ MEMORY_TARGET=2048m PGA_AGGREGATE_TARGET=130m UNDO_TABLESPACE=undotbs01 CONTROL_FILES=’/u01/oradata/control01.ctl’,’/u01/oradata/control02.ctl’ DB_RECOVERY_FILE_DEST=’/u01/oradata/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g DIAGNOSTIC_DEST=’/u01/oradata/diag’ — Export the SID export ORACLE_SID=orcl600 export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 — Connect and startup the instance [oracle@rman bin]$ sqlplus / as sysdba SQL> startup …

Memory Management

Oracle memory structures consists of System Global Area (SGA) and Program Global Area (PGA). These memory areas can be managed automatically (you cannot set AMM if lock_sga is TRUE) or manually. Contents of PGA:- [pic] [credits] Private SQL Area: Contains data such as bind information and run-time memory structures. It contains Persistent Area which contains bind information and is …

Determine and set sizing parameters for database structures

Linked Articles | Memory Management NAME, TYPE, VALUE db_name, string, orcl – Database name max 8 characters processes, integer, 150 Max processes instance can start. SQL> show parameter processes |processes integer 150SQL> alter system set processes=200 scope=spfile; [oracle@rman dbs]$ strings spfileorcl.ora | grep processes *.processes=200SQL> shutdown immediate; | Database closed. SQL> startup; | ORACLE instance …

Installing Oracle Software in a silent mode

Summary 1. Find and edit the response file. 2. Execute ./runInstaller -silent -responsFile filepath Details 1. Create the groups as the root user–Database groups[oracle@rman ~]$ groupadd -g 54321 oinstall[oracle@rman ~]$ groupadd -g 54322 dba[oracle@rman ~]$ groupadd -g 54323 oper–Grid groups[oracle@rman ~]$ groupadd -g 54327 asmdba[oracle@rman ~]$ groupadd -g 54328 asmoper[oracle@rman ~]$ groupadd -g 54329 asmadmin …

Create the database

Software install Install Oracle database software – GUIInstall Oracle database software – Silent mode Database creationCreate database – dbca GUICreate database – “CREATE DATABASE” statementCreate database – OMF (Oracle Managed Files)Create database – dbca – database templateCreate database – dbca – response file Drop database Drop database – command line De-install softwareDEINSTALL/REMOVE Oracle software Practice items …