Dev : Installing Oracle 9i on Solaris 8

Whew... It's really a mess to install oracle in Unix machine. Lucky for me, I've found some steps online where it has reduce many white hair growing on my head.

It make me sweat when asking me to change the Solaris Kernel Parameters. After some troublesome findings, I finally manage to change the kernel parameters at /etc/system and manage to get the oracle 9i installed and database created. If not, you will always get oracle error complaining "Out Of Memory". Remember, it is the kernel parameters' fault. Not your RAM, not your SWAP (because I have increase my RAM from 512Mb to 1Gb and SWAP from 500Mb to 1.5 Gb :D ).

After installing and created a database, you need to create at least a user.
To create a user :

1. Login SQL*Plus with sqlplus "/ as sysdba".
2. In SQL*Plus, type sql > create user user_name identified by user_password;.
3. Grant some access for the user.
   sql > grant connect to user_name;
   sql > grant resource to user_name;
   sql > grant create any snapshot to user_name;

After that, to access oracle from other workstation, you should start the oracle process first.

1. In console, type cd /oracle/home/bin/.
2. To start the oracle process, in console, type ./lsnrctl start.
3. To start the database, in console, type ./dbstart.

And there you go! The very basic of oracle. :)