Monday, September 23, 2013

How to Increase logical partition in Oracle VM JDE Template Servers

Problem : You are using Oracle VM Manager and Oracle VM Template for JDE Servers for production and the disk is running out of space.

Solution : Since Oracle VM Template is using logical partition, it can be expand easily by following the steps below.

Before proceed to expand the Logical partition, please do a backup of the virtual guest machine first. You can easily clone the virtual machines by using the cloning feature in Oracle VM Manager.
You also need to gather the required information in your system first before proceed.

Prerequisite : You will have to know the file system type, volume group.

To check file system type, you can issue the command df -Thl.


[root@e1ent /]# df -Thl
Filesystem    Type    Size  Used Avail Use% Mounted on
/dev/xvda2    ext3    9.6G  3.0G  6.7G  31% /
/dev/xvda1    ext3     99M   39M   56M  41% /boot
tmpfs        tmpfs    1.5G     0  1.5G   0% /dev/shm
/dev/mapper/VolGrp01-LgVol01
              ext3     20G   11G  8.4G  56% /u01

From the output, we will be expanding the mapped drive which is /u01 with the system filetype ext3, Volume Group name VolGrp01 and Logival volume name LgVol01.
Now, you have got the required information. It is time to proceed to expand the logical drive of u01.

Steps to expand storage:

1.   Create a new virtual disk and attach to the virtual machines that you want to expand the               logical partition by using Oracle VM Manager.
      After attached, in virtual machines issue the command fdisk -l and you will be able to see a       new disk without partition.


      After you have able to see the new disk, run the below command to create a new partition.
   

2.   Unmount partition /u01 in the server with the command umount /u01 .


3.   Run a file system check with the command /sbin/fsck -f /dev/VolGrp01/LgVol01 where           VolGrp01 is the VolumeGroup and LgVol01 is the LogicalVolume. If there is error will                 checking the file system, you can issue the same command but add in the option "-y" to               attempt to repair the error. The new command will be 

      /sbin/fsck -fy /dev/VolGrp01/LgVol01
               

4.   Initialize the new partition with the command pvcreate /dev/xvdc1

5.   Add the newly created partition to the volume group with command
      vgextend VolGrp01 /dev/xvdc1


6.   Type vgs to verify that the Volume Group is extended.

7.   After added in the new partition, you have to extend the actual logical volume with the command          lvextend -L +20G VolGrp01/LgVol01

8.   Type lvs to make sure the Logical Volume is extended. 

9.   Now, extend the ext3 filesystem with the command /sbin/resize2fs /dev/VolGrp01/LgVol01.

10.  Re-check the newly created filesystem with the same command as in Point number 3.

11.   Mount back /u01 with the command mount /u01.

12.  Type df -hl and you should be able to see the size of the mounted volume which is /u01 increased.



Reference :
Oracle Support
How To Extend An LVM (Logical Volume Manager) Volume (Doc ID 979522.1)

Thursday, September 19, 2013

Oracle JDE 9.1.3 Local Web Installation Guide

Preparing Deployment Server for Installation
1. Install Java JDK 6 into a location. For example of location to install:
             C:\Program Files (x86)\Java\jdk1.6.0_45\

2. After finished the JDK installation, go to C:\Program Files (x86)\Java\ and copy the jdk1.6.0_45
folder to deployment server where the jdedwards folder is installed.

3. The location to place the jdk1.6.0_45 folder in the deployment server is
C:\JDEdwards\E910_1\OneWorld Client Install\ThirdParty\WebDevFeature\OH4A

4. After the folder finished copying, rename jdk1.6.0_45 to JDK.

Installation of Local Web in Fat Client
1. From fat Client PC, go to Run -> \\[deployment server name]\E910\OneWorld Client
Install\ThirdParty\WebDevFeature\OH4A\install and double click on setup.exe


2. Click Next on the Welcome Screen.


3. Change the Destination Name to JDE_E910_Client1 by selecting it from the drop down box and
the Path must be pointed to where the Fat Client folder is installed and click Next.



4. Click Install in the Summary screen and the installation will start. Wait for the installation to
complete.

5. After the installation is done. Goto the following link:
D:\E910_1\system\OC4J\j2ee\home\applications\webclient.ear\webclient\WEB-INF\classes

6. Open jas.ini file and look for
[OWWEB]
PathCodes=('DV910') Modify this to the environment that you want to access in local web

7. Make sure the following is correct in jdbj.ini
[JDBj-SPEC DATA SOURCE]
name=Local - DV910
databaseType=E
server=localhost
serverPort=1521
database=ovsorcl
physicalDatabase=JDELocal_DV910

8. In the same folder location, look for tnsnames.ora and make sure the database server hostname is
correct. You can now login to Fat client and access local web.