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 …

Oracle ASMLib Downloads for Red Hat Enterprise Linux 5

Oracle ASMLib Downloads for Red Hat Enterprise Linux  5 Note: All ASMLib installations require the oracleasmlib and oracleasm-support packages appropriate for their machine. The driver packages are named after the kernel they support. Run the “uname -r” command on your machine to determine your kernel version. The corresponding package has the name oracleasm-<kernel_version>.The Oracle ASMLib kernel driver packages are installed using …