Oracle for humans

NB. To enlarge image click on 
    If you want to size down image just click two time on it.

In this demo VMware Fusion (for Windows VMware workstation),
Enterprise-R5-U5-Server-i386-dvd.iso, Oracle Database Grid Infrastructure, Oracle 11gR2 and ASMlibs will be used.

Database creation

Log on as oracle user and run runInstaler.

cd /mnt/hgfs/SOFTWARE/database
./runInstaler

Since this is only a test installation we do not want to receive email from Oracle, therefore:




Install database software only:



Single instance database installation:



Languages = English

Enterprise edition, for extra option you should select “Select Option”



Use default for Oracle Base end Software Location
Oracle_base=/data/app/oracle



DBA group i default group



Click on "Fix & Check again"



run the root.sh script and accept defaults



Select “ignore all” and click “Next”.



Create new listener using netca
[oracle@oraasm-primary bin]$ netca

Oracle Net Services Configuration:
Configuring Listener:LISTENER
Listener configuration complete.
Oracle Net Listener Startup:
Listener started successfully.
Oracle Net Services configuration successful. The exit code is 0




[oracle@oraasm-primary bin]$ crsctl status resource ora.LISTENER.lsnr
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on oraasm-primary
or
[oracle@oraasm-primary bin]$ srvctl config listener
Name: LISTENER
Home: /data/app/11.2.0/grid
End points: TCP:1521
[oracle@oraasm-primary bin]$

update orataf file
cat >> /etc/oratab << EOF
rdbms112:/data/app/oracle/product/11.2.0/dbhome_1:N
EOF

Execute the next command in terminal as oracle user
[oracle@oraasm-primary bin]$ . oraenv -v

ORACLE_SID = [+ASM] ? rdbms112
The Oracle base for ORACLE_HOME=/data/app/oracle/product/11.2.0/dbhome_1 is /data/app/oracle
[oracle@oraasm-primary bin]$ dbca




On the next screen select “use the same Administrative password for all accounts”. For production installations this might not be appropriate but it is acceptable for this demonstration.





Click “next” and then “YES”
1. Select “automatic Storage Management (ASM)
2. Click “Browse” and select the disk group you want to use for data files (DG1)




Specify asmsnmp password specific to ASM: oracle

Choose space for FRA.




Mark “Enable Archiving”
Keep default: “Next”




Keep default: “Next”




Highlight “Create Database” and “generate database creation scripts” buttons. It is always useful to be able to review the scripts after installation.





Done. We have now an Oracle database running on Linux enterprise using ASM as storage.