To start my database & listener execute:
sqlplus "/as sysdba" <<! startup ! lsnrctl start
To stop my database & listener execute:
sqlplus "/as sysdba" <<! shutdown immediate ! lsnrctl stop
November 28, 2005
Starting my Oracle Database and Listener on Linux
November 15, 2005
WMS Receiving
In stead of tweaking the label we decided to do the split of multiple pallet containers in the receiving interface. This way we will have the items already packed into LPN’s which makes the rest of the putaway easier. We also do not need to tweak the XML file that is generated by Oracle: another plus!
November 3, 2005
Adding Swap Space for Oracle XE
For my Oracle XE installation I needed some extra swap space. Added a disk to my VMWare configuration and booted. The kernel gave it name /dev/sdd.
[root@xs4all ~]# fdisk -l [...] Disk /dev/sdd: 4294 MB, 4294967296 bytes 255 heads, 63 sectors/track, 522 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Disk /dev/sdd doesn't contain a valid partition table
After this some linux configurations need to take place:
# fdisk /dev/sdd # add a partition [...] # pvcreate /dev/sdd1 # create volume on partition [...] # vgextend VolGroup00 /dev/sdd1 # add disk to volume
Used these notes to add swap space:
# swapoff -v /dev/VolGroup00/LogVol01 # disable swapping # lvm lvresize /dev/VolGroup00/LogVol01 -L +512M # mkswap /dev/VolGroup00/LogVol01 # swapon -va # cat /proc/swaps # test if logical volume has been extended ok Filename Type Size Used Priority /dev/mapper/VolGroup00-LogVol01 partition 1048568 0 -1 # free
Installing Oracle XE
Downloaded XE for linux and tried to install it, following error comes up:
[root@xs4all xe]# rpm -ivh oracle-xe-10.2.0.1-0.1.i386.rpm [..] This system does not meet the minimum requirements for swap space. Based on the amount of physical memory available on the system, Oracle Database 10g Express Edition requires 1006 MB of swap space. This system has 511 MB of swap space. Configure more swap space on the system and retry the installation. [..]
After reading this blog of Jeff Moss I tried to lower the memory from 512 to 256 in my virtual machine. This does not work for me: I need to lower it to 256 in order to allow a swap size of 512. In VMWare 256M looks like 250M (this is what Oracle sees, don’t know why). 250M is not enough to install XE ;-(
Changing the swap size will be my next try, check this post.
Got it working now:
