Hardware
My Dell desktop:
[root@erp RPMs]# cat /proc/cpuinfo model name : Intel(R) Pentium(R) 4 CPU 2.80GHz cpu MHz : 2793.022 cache size : 512 KB [root@erp RPMs]# cat /proc/meminfo MemTotal: 2073404 kB ...
Operating System
Download Centos Linux, and install the Linux operating system.
Kernel Version
Download kernel-smp-2.6.9-42.0.3.EL.i686.rpm and apply with:
$ rpm -ivh kernel-smp-2.6.9-42.0.3.EL.i686.rpm
The kernel should look like this:
root@erp RPMs]# uname -a Linux erp.itskills.com 2.6.9-42.0.3.ELsmp #1 SMP Thu Oct 5 15:04:03 CDT 2006 i686 i686 i386 GNU/Linux
Required RPMS
glibc-2.3.4-2.25glibc-common-2.3.4-2.13binutils-2.15.92.0.2-15compat-libstdc++-296-2.96-132.7.2gcc-java-3.4.4-2gcc-c++-3.4.4-2compat-gcc-32-3.2.3-47.3libgcc-3.4.4-2libstdc++-3.4.4-2openmotif-2.2.3-9.RHEL4.1pdksh-5.2.14-30.3setarch-1.6-1make-3.80-5gnome-libs-1.4.1.2.90-44.1sysstat-5.0.5-1compat-db-4.1.25-9control-center-2.8.0-12.rhel4.2xscreensaver-4.18-5.rhel4.9libaio-0.3.103-3libaio-devel-0.3.103-3
Utilities
Before beginning the installation, you must confirm that you have these utilities:
argccg++ldkshmakeX Display Server (VNC)
To check if these are available, use which; for example: which ar.
Kernel Settings
Make sure that the following kernel setting are in effect. Update /etc/sysctl with the following parameters, and then run sysctl -p.
kernel.semmsl = 256 kernel.semmns = 32000 kernel.semopm = 100 kernel.semmni = 142 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.msgmax = 8192 kernel.msgmnb = 65535 kernel.msgmni = 2878 fs.file-max = 65536 net.ipv4.ip_local_port_range = 102465000 net.core.rmem_default = 262144 net.core.rmem_max = 262144 net.core.wmem_default = 262144 net.core.wmem_max = 262144
Number of Open File Descriptors
Modify /etc/security/limits.conf for “hard” and “soft” parameters.
hard nofile 65535 soft nofile 4096 hard nproc 16384 soft nproc 2047
Create Users and Groups
groupadd dba useradd -g dba oracle
I used the oracle user as the owner of both APPS and database.
Downloading 12i Software
Download 12i (12.0.4) from edelivery.oracle.com.
Here are the disk details required.
- Space required for download 12i: 34.1GB
- Space required for the actual install (Fresh Database): 65GB
- Space required for the unzipped 12i Software: 40GB
This is what I did. I had two disks on the PC—40GB and 250GB, and I had a Lacie 500GB Firewire Drive. I used the 40GB for the dual setup (Windows and Linux), and mounted the 250GB as /250G for the 12i software, using an ext2 filesystem. I mounted the Lacie Drive as /500GB for the actual install.
Begin the installation
Once you have unzipped the 12i Software, make sure the following is set up . . .
oracle:dbais the owner of the directory where you are installingoracle:dbaowns the software directory
. . . and then you can start the installation.
As oracle:dba, start a vnc server:
$ vncserver :2
Logmin to vncviewer:
$ vncviewer :2
Try running xclock/code> If you get a clock, you are good to start. Navigate to the staging area.
$ /250G/startCD/Disk1/rapidwiz $ ./rapidwiz
After installation
Congratulations, you now have your 12i instance. Tempted to log in? Why not!
You will require the password for SYSADMIN. Oracle never asked us for that, so I had to wait, and ask here and there. And then this worked: sysadmin. Yes, that’s the password for SYSADMIN. And the password for apps is apps. So log in and scroll through the new windows of your own 12i.
Clarifications
You may wonder why I used oracle:dba for both apps and database. I did so because I intended to used to this machine for other set-ups too—10g, 11g, OID, etc., and so I wanted to keep it simple as the 12i is on Firewire. It will be mounted every time machine boots, so it’s easy to do this:
$ chown -R oracle:dba /500GB
Create a env file for 12i, and log in as oracle. Edit .12i.env and just add the following two lines:
./500GB/12i/db/tech_st/10.2.0/PROD_erp.env . /500GB/12i/tech_st/10.2.0/PROD_erp.env
Now invoke the env file and play around with the file systems.
Share this
Share this
More resources
Learn more about Pythian by reading the following blogs and articles.
Installing Oracle 11g on Ubuntu Linux 7.10 (Gutsy Gibbon)
Installing Oracle 11gR2 Enterprise Edition on Ubuntu 10.04 (Lucid Lynx)
Installing Oracle 11gR1 on Ubuntu 8.10 Intrepid Ibex
Ready to unlock value from your data?
With Pythian, you can accomplish your data transformation goals and more.