Oracle Apps DBA

My Photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Tuesday, 27 January 2015

Creating virtualbox shared folder on Oracle Solaris 11 Guest

This article demonstrates steps for enabling a windows host shared folder to oracle solaris 11 guest operating system in a virtualbox environment. Before reading further please make sure that "guest additions" are already Installed and configured on a guest OS.

1) Create and configure shared folder for a virtual machine:

Create any directory which you want to share at your desired location. I've used "E:\solshare" 



>> Navigate to devices > shared folders


 >> click on icon to add a new shared folder to guest OS


>>  click on "Folder Path" and add the required folder for enabling sharing.


>> check box - If you want to make this shared as permanent and auto-mount enabled. It will be persistent on reboots. 

>> Verify the configuration of shared folder

2) Mount share folder on guest OS (solaris11):

>> Verify the existing mount-points

root@soltest1:~# df -h
Filesystem             Size   Used  Available Capacity  Mounted on
rpool/ROOT/solaris11_sru234

rpool                   98G   5.0M        70G     1%    /rpool
rpool/VARSHARE/zones    98G    31K        70G     1%    /system/zones
rpool/VARSHARE/pkg      98G    32K        70G     1%    /var/share/pkg
rpool/VARSHARE/pkg/repositories
                        98G    31K        70G     1%    /var/share/pkg/repositories
/dev/dsk/c1t1d0s2      6.8G   6.8G         0K   100%    /media/SOL_REPO_11_2
root@soltest1:~# 

>> Mount the share folder using below command

root@soltest1:~# mkdir /solshare
root@soltest1:~# mount -F vboxfs -o uid=1234,gid=5678 solshare /solshare

root@soltest1:~# df -h
Filesystem             Size   Used  Available Capacity  Mounted on

/dev/dsk/c1t1d0s2      6.8G   6.8G         0K   100%    /media/SOL_REPO_11_2
solshare               932G   911G        21G    98%    /solshare
root@soltest1:~# 

In Linux its not required to mount the vbox file system manually. Vbox guest additions will mount the file system.

3) Verify the share is working properly

Now i will create the file in solaris and same files you can use it windows  and military files created in windows can be used by solaris OS.

.


Hope it helps :)

thanks for reading.

regards,
X A H E E R

Wednesday, 21 January 2015

adop phase=prepare Completes With Error While Executing Sanity Check '[UNEXPECTED]Error while runFSSanityValidateConfig sub-routine is called'

adop prepare phase was failing for on one of our EBS R12.2 Test Instance.  It was failing during the sanity check. adop check for certain fields before it start working. If check failed on any one of those field that i cannot be proceed.

During the sanity check adop checks for the following fields:

1) Provided apps/system/weblogic passwords are correct
2) Verify validity of context file
3) Environment variable for RUN and Patch edition are correct
4) Checks RUN and PATCH edition file system has RW privilege
5) Checks for 25 GB of free space.

Error logfile:

Action = filesystemcheck

=============================
Validating console log key...
=============================

Console = off

===========================
Inside checkPrivileges()...
===========================

Checking whether below directories have READ/WRITE access:
/u01/appl_test/fs1
/u01/appl_test/fs2

Privileges check PASSED.



============================
Inside checkFileEdition()...
============================

Value of FILE EDITION from RUN file system  : run
Value of FILE EDITION from PATCH file system: patch

File edition check PASSED.



================================
Inside checkDiskSpaceOnUnix()...
================================


========================
Inside runDFCommand()...
========================

LOG FILE: /u01/appl_test/fs_ne/EBSapps/log/adop/11/prepare_20150107_114004/test_erpnode3/TXK_SANITY_filesystemcheck_Wed_Jan_7_11_46_25_2015/df.out
Execute SYSTEM command : df /u01/appl_test/fs2 
"df" command output: /dev/sda3            483063744 451280432   6849228  99% /u01


MINIMIUM SPACE REQUIRED (in GB): 25
FREE SPACE AVAILABLE    (in GB): 6.53193283081055
Space check FAILED.

[ERROR] Minimum file system space required 25 GB while you have 6.53193283081055 GB

Here in my case it failed on file system space check.

Solution:

- Increase file system size with min 25GB of free space.
- Delete existing unwanted files

You should plan space Initially before Installing/setting up a new EBS environment to avoid such Issues.  After increasing the space it worked fine without any Issues.

Thanks for reading.

regards,
X A H E E R

Tuesday, 13 January 2015

Oracle EBS R12.2 Installation failing on "Database pre-install checks failed"

Installation of Oracle EBS R12.2 failing on database pre-requisites check with error "Database pre-install checks failed". So many individuals reported same error and they were asking for the cause and solution.
Error:

Error message during R12.2 pre-install check:


The problem is that this error message will not stop until you close the session. It will not provide any further information related to this error. In the Installation logfile also same error is reported without any extra information.

All pre-requisites for application and database are in place and configured, still it will give this  error:

1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.018/0.018/0.018/0.000 ms


   Mid-tier host domain ping has succeeded


Check Completed.

------------------


Database Pre-install Checks
These checks might take a few minutes... 

----------------------------------------------------------------------

Database pre-install checks failed

-----------------------------------

Database pre-install checks failed

-----------------------------------

Database pre-install checks failed

-----------------------------------

Database pre-install checks failed

-----------------------------------

Database pre-install checks failed

-----------------------------------

Database pre-install checks failed

-----------------------------------

Database pre-install checks failed

-----------------------------------

Database pre-install checks failed

-----------------------------------

Database pre-install checks failed

-----------------------------------

Database pre-install checks failed

-----------------------------------

Database pre-install checks failed

----------------------------------

Cause:

This error is reported if R12.2 Stage is located on external hard disk and you are trying to Install it from the external HDD stage.

Solution:

Copy/create the stage on  local file system and start rapidwiz  from beginning to continue the Installation. Do not use R12.2 Stage from external HDD.

This Issue is reported on Linux 5/6 but it can be applicable to other OS as well.

Happy troubleshooting.

Thanks for reading :)

regards,
X A H E E R