Install Oracle R12 on Ubuntu

This post describes how to install Oracle Release 12 on Ubuntu ( Hardy Heron ). This follows on the footsteps of a successful Oracle 11g database install described in my previous post.

Specs for my Dell Inspiron 530 were:
1. 3GB RAM
2. 500 GB External HDD ( Western Digital )
3. Ubuntu ( Hardy Heron ).
4. Headless Server ( ie no monitor ).
5. ssh running on server.


1. ssh into server from client machine.

2.Mount external hdd

#fdisk -l

Disk /dev/sdb: 500.1 GB, 500107862016 bytes
255 heads, 63 sectors/track, 60801 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk identifier: 0xea3aae34

Device Boot Start End Blocks Id System
/dev/sdb1 1 12748 102398278+ c W95 FAT32 (LBA)
/dev/sdb2 12749 60801 385985722+ f W95 Ext'd (LBA)
/dev/sdb5 12749 60801 385985691 83 Linux

#mount -t ext3 /dev/sdb5 /u01/oracle

3. Stage disks from Oracle into staging directory under /u01/oracle

4. Start vncserver as root.
#vncserver :1
#xhost+

5. On the client, vncviewer -via <ip address of host> hostname:1

6. Switch user to Oracle.

7. Set DISPLAY. export DISPLAY=localhost:1

8. Change Directory to <staging directory>/Disk1

9. runinstaller.sh

10. This step is optional. Drink <your favorite beverage>

Install took about 5 hours. Please note that linux clients to view forms are not supported yet in R12.

Install Oracle 11g on Ubuntu

Installed Oracle 11g on Ubuntu. The detailed instructions at
Installing Oracle 11g were a great help.

For some reason adding Red Hat ( Step 6 ) to /etc/redhat-release didn't work. The installer failed pre-install check. To get around that, I used runInstaller -ignoreSysPrereqs. This worked well.There were no other problems.

Apache, php, mysql continued

I added ServerName 127.0.0.1 to apache.conf in the /etc/apache2 directory ($APACHE_HOME ).
Changed the default port from 80 to 1080 in ports.conf. Note this is just so that http://localhost:1080 takes me to my home not http://localhost.

Stopping and starting apache

• apache2ctl stop
• apache2ctl start

Look up DocumentRoot in $APACHE_HOME/sites-available/default.Change the DocumentRoot to a directory that makes sense to you. Create an index.html file in this DocumentRoot directory.
Created a php file test.php in DocumentRoot.
Mine for instance has <?php phpinfo() ?>
Point your browser to http://localhost:1080/test.php to test.

http://localhost:1080/phpmyadmin takes you to the phpMyAdmin home page. Enter your userid and password that you created during the install.

Starting and Stopping mysql
mysqladmin -u root -p shutdown
mysqld & to startup.

How to Install Apache,PHP and Mysql on Ubuntu

Installing Apache , php and mysql was easy using the synaptic package manager.

• Installed the database server mysql
• Installed Apache server, apache2
• Installed php (php5)
• Installed libapache2-mod-auth-mysql
• Installed php5-mysql

Next post, I will actually try using php to connect to mysql and build a page.

Oracle Min Max is not creating requisitions

Problem: Min Max is not generating requisitions. No errors.No data in po_requisitions_interface_all table.

Check the following item setup:

Inventory Item flag enabled
Stockable flag enabled
Transactable flag enabled


Purchased flag enabled
Purchasable flag enabled
Use Approved Supplier disabled

Inventory Planning Method is set to Min-Max
Source Type = Supplier
Make or Buy = Buy
Safety Stock = Non-MRP Planned

Profile : INV: Minmax Reorder Approval=Approved

Check to see if BOM Calendar / Workday Calendar is open for the demand dates in question. If not, open it and rebuild calendar.

Run MinMax with Restock=Yes