Oracle 9i Installtion Steps

I)prerequisites: first of all we have to check hardware i.e

1) p3 or p4 or other one
2) minimum ram 512MB
3) 3GB to 5GB harddisk
4) cdrom
5) mount point with minimum space
6) swap space should be double of the ram then

II)procedures: first of all we have to connect to otn.oracle.com through the net and we have to
download the documentation of oracle installation & released notes in that we have
to check the certification if it is certified then read the installation guide
then start installation.



SNO TASK ACTION RESULT
------ ----------------- -------------------- --------------------
1. go to root user $su - get admin promt #.

2. go to kernal dir cd /proc/sys/kernel u r in kernel dir.


3. check sem value cat sem; displays default value.

4. set sem value echo 100 32000 100 100 > sem updates sem value.

5. set shmmax val echo 2147483648 > shmmax updates val.

6. set shmmin val echo 4096 > shmmni updates val.

7. set ulimit ulimit -u 16384 user processes alloted.

8. add groups groupadd dba; dba group is added.

9. add user useradd -G dba,praveen -d/home/praveen praveen user is created.
-p welcome praveen

10. change usr permi chmod -R 775 /home/praveen permissions changed.

11. change owner praveen chown -R praveen:dba /home/praveen dba becomes own of praveen.
to dba

12. switch to praveen user su - praveen changes root to praveen.

13. open .bashrc file vi .bashrc file opened.

14. append environment var umask 022
& save file export ORACLE_SID=PRAVEEN
export ORACLE_BASE=/home/praveen
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0.4
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
export ORA_NLS=$ORACLE_HOME/nls/ocommon/admin/data
export LD_ASSUME_KERNAL=2.4.19 appends this variables.

15. run .bashrc file sh .bashrc file exicutes&sets env var.

16. check for patch /stage/oracle9i file found or download p4198954_40_LINUX.zip from http://oss.oracle.com
/projects/compat-oracle/

17. unzip patch file unzip patchfile two files get from zip

18. install unzip files rpm -ihv ~/ patches are applied.
at root user

19. check for dump s/w /stage/oracl9i/disk1/runInstaller u find runInstaller file.

20. run runInstaller file ./runInstaller user interface is opened.

21. run xhost+ login root run xhost + it will disable all
ristrictions of user.

22. select button click inventary loc window opens.

23. inven window click unix group win opens.

24. select click opens next win.

25. run script /tmp/sh oraInstRoot.sh it will Create Oracle Inventory pointer file
(/etc/oraInst.loc)

26. next window file location display source & dest loc.

27. next window select oracle 9i db selects 9i db.

28. next window select Enterprice edi selects that edition.

29. next window select general purpose select that mode.

30. next win gdbname=SID.orafact.com it takes global name.

31. next win default loc of s/w it stores in that loc.

32. next win select unicode it select unicode char set.

33. run root.sh login root run sh root.sh it will give permitions to
install s/w products in
oracle_home/product.

34. next win install opt it starts install s/w.





MANUAL CREATION OF DATABASE




1. creation of file go to admin create one folder with file structure is
SID name & within that create bdump,udump created.
structure cdump & go to oradata create one folder
with SID name.

2. create env file copy the previous .bashrc file and it create env file.
change the SIDname with new SIDname.
Eg:
export ORACLE_BASE=/home/praveen
export ORACLE_HOME=/home/praveen/product
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=ofdb3
export LD_ASSUME_KERNEL=2.4.19
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORA_NLS=$ORACLE_HOME/ocommon/nls/admin/data
umask 022

3. create parameter file go to $ORACLE_HOME/dbs & copy the init.ora to pfile is
initSID.ora then change the dbname& give controllfiles created
&trace files location.

4. create database creation create database ofdb3 creates sql file
script logfile
group 1 ('/home/praveen/oradata/ofdb3/log_01.rdo') SIZE 15m,
group 2 ('/home/praveen/oradata/ofdb3/log_02.rdo') SIZE 15m,
group 3 ('/home/praveen/oradata/ofdb3/log_03.rdo') SIZE 15m
datafile '/home/praveen/oradata/ofdb3/system.dbf' SIZE 100m
undo tablespace UNDO
datafile '/home/praveen/oradata/ofdb3/UNDO.dbf' size 10m;

5. login as sysdba sqlplus '/as sysdba' logged as sysdba.

6. start db in nomount startup nomount db started in nomount.

7. run the sql script @scriptname.sql it will create database.

8. run the catalog.sql @$ORACLE_HOME/rdbms/admin/catalog.sql it will create the
data dictionary views.

9. run the catproc.sql @$ORACLE_HOME/rdbms/admin/catproc.sql it will create the
procedures.

10. run the pupbld.sql @$ORACLE_HOME/sqlplus/admin/pupbld.sql it will create the
profiles for default
users.