Posts

How to change the Virtual Disk size in Virtual Box

To increase the vdi size issue the following command: D:\VirtualBox VMs\OEL6U3-Developer>"c:\Program Files\Oracle\VirtualBox\VBoxManag e.exe" modifyhd OEL6U3-OS.vdi --resize 51200 0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100% c:\Program Files\Oracle\VirtualBox\VBoxManage.exe is the Virtual Box exe D:\VirtualBox VMs\OEL6U3-Developer\OEL6U3-OS.vdi is the VDI file 51200 is in MB = 50 GB

SOA Suite 11.1.1.7 on OEL 6 Update 3 Installation Tips

Step 1: Install the RPMs which are missing, the following are required as per oracle document: rpm -q binutils-2.20.51.0.2-5.28.el6 compat-libcap1-1.10-1 compat-libstdc++-33-3.2.3-69.el6 compat-libstdc++-33-3.2.3-69.el6 gcc-4.4.4-13.el6 gcc-c++-4.4.4-13.el6 glibc-2.12-1.7.el6 glibc-2.12-1.7.el6 glibc-devel-2.12-1.7.el6 libaio-0.3.107-10.el6 libaio-devel-0.3.107-10.el6 libgcc-4.4.4-13.el6 libstdc++-4.4.4-13.el6  libstdc++-4.4.4-13.el6  libstdc++-devel-4.4.4-13.el6 libXext  libXtst  openmotif-2.2.3  openmotif22-2.2.3  redhat-lsb-core-4.0-7.el6  sysstat-9.0.4-11.el6 uln-internal-setup-1.0.1-1.el6.noarch.rpm The query will result in several rpm saying as unavailable, most of them have a new version so we will be fine. package binutils-2.20.51.0.2-5.28.el6 is not installed package gcc-4.4.4-13.el6 is not installed package gcc-c++-4.4.4-13.el6 is not installed package glibc-2.12-1.7.el6 is not installed package glibc-2.12-1.7.el6 is not installed ...

Oracle database 11g R2 Pre-installation

1) Install the oracle-validated RPM http://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux-488779.html 2) Set user limits vi /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 3)  Edit /etc/pam.d/login and add the line below in order for the login program to load the pam_limits.so so that the /etc/security/limits.conf is read and limits activated and enforced. session required pam_limits.so 4) Add Groups and Users groupadd –g 1000 oinstall groupadd –g 1021 asmdba groupadd –g 1031 dba groupadd –g 1023 oper useradd –u 1101 –g oinstall –G dba,asmdba,oper oracle 5) Create directory mkdir -p /home/oracle/app/oracle chown oracle:oinstall /home/oracle/app/oracle chmod -R 775 /home/oracle/ 6) Create the user profiles for oracle user. su - oracle vi .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; th...

Auto mount the volume in linux

vi /etc/fstab /dev/sdb                /home/oracle               ext4 defaults        0 0 /dev/sdc                /home/weblogic             ext4 defaults        0 0 mount –a [root@soadev db]# mount /dev/sdb on /home/oracle type ext4 (rw) /dev/sdc on /home/weblogic type ext4 (rw)

Automatically start the network eth0 in linux

login as root cd /etc/sysconfig/network-scripts vi ifcfg-eth0 DEVICE="eth0" BOOTPROTO=dhcp NM_CONTROLLED=" yes " ONBOOT="yes" TYPE="Ethernet" UUID= DEFROUTE=yes IPV4_FAILURE_FATAL=yes IPV6INIT=no NAME=eth0 HWADDR= PEERDNS=yes PEERROUTES=yes

B2B Trading Partner Lookup sql query

How B2B looks for the Trading Partner Agreement in the MDS database SELECT * FROM DEV_SOAINFRA.B2B_LIFECYCLE WHERE ((SENDER_NAME        = <Sender Name e.g. MyCompany>) AND ((RECEIVER_NAME        = <Recipient Name e.g. ACME>) AND ((DOCTYPE_NAME         = <Document Name e.g. CUSDEC>) AND ((DOC_PROTOCOL_VERSION = <Document version e.g. D96B>) AND ((DIRECTION            = <Can be INBOUND or OUTBOUND>) AND (STATE                 = 'Active'))))));

Custom character set in Oracle B2B

Image
To add a custom character set in B2B follow the steps: 1. In Oracle B2B Document Editor, click Tools > Character Set Registry. In the Character Set Registry window, select the character set you want to duplicate. 2. Click the Duplicate icon, or Right click and Duplicate. 3. In the Duplicate Character Set Properties window, accept the defaults and add any other characters at the end of the Charset blank; then click OK. 4. Right click on the Custom Character Set and click the Export icon. Name the file CUST.cs and save it. 5. Copy CUST.cs to SOA_HOME\soa\thirdparty\edifecs\XEngine\config\charsets 6. Edit SOA_HOME\soa\thirdparty\edifecs\Common\Modules\XEngine.dat and add the entry File=XEngine\config\charsets\CUST.cs 7. Restart the SOA server.