Difference between APPLPTMP and APPLTMP Directories in EBS (Doc ID 1355735.1)

APPLPTMP:

"APPLPTMP is a special directory used only for PLSQL temporary files. When a concurrent program uses the FND_FILE package, the concurrent manager uses APPLPTMP as the directory to which it writes temporary files. FND_FILE uses the UTL_FILE package, which can only write to directories specified in init.ora. Thus, APPLPTMP must be one of the directories listed in init.ora in order for FND_FILE to work.
Ensure that the virtual path assigned to the APPLPTMP environment variable is valid, writable, and is referenced at the beginning of the UTL_FILE_DIR database parameter."

Also as per Note:123977.1 using multiple instances, a unique APPLPTMP directory will be needed for each instance environment used.

So, in case multiple instances running on the same box, please have different directories for each instance, something like

Instance 1: APPLPTMP=/usr/tmp/ or /usr/tmp/<SID1>
Instance 2: APPLPTMP=/usr/tmp2/ or /usr/tmp/<SID2>

with Full permission on them and first entry in UTL_FILE_DIR on Database Node only.


APPLTMP:

APPLTMP does not need a utl_file_dir entry. It is a pointer to the the temporary directory used by the application, and is not referenced by the database. It is generally recommended that the location be the same simply to avoid any confusion that might be caused by multiple temporary file locations, but this is not a requirement, and you may certainly use different and non-shared locations for each host if you wish.

i.e  you can have APPLTMP='/usr/tmp' (Apps Node) or '$INST_TOP/appltmp' with Full permission.

Installation of Oracle Database 11.2.0.2 in Oracle Linux 6 inside Virtual Machine

Do you know ..that 11.2.0.3 patch set is a full release..? 

There is no need to install 11.2.0.1 software

See this Note 1189783.1 : Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2

"Starting with the first patch set for Oracle Database 11g Release 2 (11.2.0.2), Oracle Database patch sets are full installations of the Oracle Database software. In past releases, Oracle Database patch sets consisted of a set of files that replaced files in an existing Oracle home. Beginning with Oracle Database 11g Release 2, patch sets are full installations that replace existing installations."

The software can be downloaded from My Oracle support: Patch:10404530

Please select your platform before downloading (Click on "Platform or Language" drop down menu)

You can check README and download the modules u need like RAC, database, etc.. as i only need grid/Clusterware, database . I downloaded parts 1,2,3

Oracle Database (includes Oracle Database and Oracle RAC)

Note: you must download both zip files to install Oracle Database.

unzip p10098816_112020_Linux-x86-64_1of7.zip

unzip p10098816_112020_Linux-x86-64_2of7.zip

unzip p10098816_112020_Linux-x86-64_3of7.zip

[root@ol6 ~]# yum install oracle-rdbms-server-11gR2-preinstall

[root@ol6 yum.repos.d]# cat  /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.XXX   ol6.localdomain ol6

[oracle@ol6 database]$ export DISPLAY=:0

[oracle@ol6 database]$ xhost +

access control disabled, clients can connect from any host

[oracle@ol6 database]$ ll

total 52

drwxrwx--- 1 root vboxsf     0 Nov 16  2010 doc

drwxrwx--- 1 root vboxsf  4096 Nov 16  2010 install

-rwxrwx--- 1 root vboxsf 27303 Nov 16  2010 readme.html

drwxrwx--- 1 root vboxsf     0 Nov 16  2010 response

drwxrwx--- 1 root vboxsf     0 Nov 16  2010 rpm

-rwxrwx--- 1 root vboxsf  3226 Nov 16  2010 runInstaller

drwxrwx--- 1 root vboxsf     0 Nov 16  2010 sshsetup

drwxrwx--- 1 root vboxsf  8192 Nov 16  2010 stage

-rwxrwx--- 1 root vboxsf  5394 Nov 16  2010 welcome.html

[oracle@ol6 database]$ ./runInstaller 

Starting Oracle Universal Installer...

and for this installation screenshots you can refer to 

https://karunadba.blogspot.com/2014/05/installation-of-oracle-11gr12-in-oracle.html

or you can simply install software without database and later create database using DBCA.

My DB :

[oracle@ol6 ~]$ 

[oracle@ol6 ~]$ !sq

sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tue May 25 19:26:58 2021

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Release 11.2.0.2.0 - 64bit Production

SQL> select name from v$database;

NAME

---------

MANGO

SQL> 

Virtual boxguest additions error - Modprobe vboxguest failed

If you see your guest additions are failing because of below error.

Error building the module:
modprobe vboxguest failed

OR
Verifying archive integrity... All good.
Uncompressing VirtualBox 6.0.4 Guest Additions for Linux........
VirtualBox Guest Additions installer
Removing installed version 6.1.4 of VirtualBox Guest Additions...
Copying additional installer modules ...
Installing additional modules ...
VirtualBox Guest Additions: Starting.
VirtualBox Guest Additions: Building the VirtualBox Guest Additions kernel
modules.  This may take a while.
VirtualBox Guest Additions: To build modules for other installed kernels, run
VirtualBox Guest Additions:   /sbin/rcvboxadd quicksetup <version>
VirtualBox Guest Additions: or
VirtualBox Guest Additions:   /sbin/rcvboxadd quicksetup all
VirtualBox Guest Additions: Kernel headers not found for target kernel
4.1.12-124.24.3.el6uek.x86_64. Please install them and execute
  /sbin/rcvboxadd setup
modprobe vboxguest failed
The log file /var/log/vboxadd-setup.log may contain further informa

SOLUTION:  well in my case below solution worked for oracle vm 6.1

     yum install kernel-uek-devel

## Fedora 34/33/32/31/30 and CentOS 8 / RHEL 8 ##
dnf update kernel*

## CentOS/RHEL 7/6/5 ##
yum update kernel*

uname -r 
ls -ltr /usr/src/kernels/
yum install kernel-uek-devel-$(uname -r)
reboot

Virual Box group - Vboxsf permission issue on /media/sf_directory_name..

The Ideal way of getting access to these files is to allow VirtualBox to automount the shared folder (which will show up under /media/sf_directory_name) and then to add your regular OS user to the vboxsf group (as root #).

Syntax:

# usermod -aG vboxsf <OSUser>

In My case:     

[root@ol6 oracle]# usermod -aG vboxsf oracle

  By default, it looks it look like this

drwxrwx--- 1 root vboxsf 40960 MAY 11:37 sf_directory

so the vboxsf group has full access. By adding your user to that group,

you gain full access. So you no need to worry about changing their permissions

 

Oracle VM Server  Goes To Black Screen After Logging in 

After installing oracle linux6, i was able to play for some time and then i tried installing guest additions which is failing pathetically when i rebooted it starting giving a blank page.

I tried below things,

1. Increasing RAM

2. Increasing Video Memory

3. Disabling 3D Acceleration , NA/PEX

Trust me nothing worked out for me ...Wasted 24 hours on this nasty bug

Solution:

Switch  VMSVGA to VboxSVGA (which is no longer supported!) corrects the problem.

How to use internet from Oracle Virtual Machine 

 Hello again !  Well after a lot many days am trying to play with VM's again like installing a new VM, setting up internet , install databases and learn new things on the way.

So, i could not able to access internet inside my VM and the OS is Oracle Linux Server release 6.4

SOLUTION:

Here is the little trick , go to your host machine and check network connections 

Control Panel\Network and Internet\Network Connections

here you gonna see the type of the wifi your using , use the same adapter name in Oracle VM under 

network tab and choose Promiscuous  mode Allow for all VM's

Do the same thing for Adapter 2 as well and allow mode for all VM's

Now go to ur VM and see.. TADA !! try ping google.com too and u can see its connecting to internet

Happy learning !!