Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6

 

We always refer www.oracle-base.com for exclusive tips on installing various Oracle products and we would suggest, it is one of the best repositories you can also depend upon for.

Recently we were having a requirement to migrate our legacy 10.1.2.x Oracle database to 11gR2 and we followed this thread by www.oracle-base.com to.

Our scenario was involving a VM instead of physical server which was hosted on Windows 8 64 Professional edition using Oracle’s VirtualBox 4.2.18

Following the straight forward instructions we installed Oracle Linux 6.2 X86_64 (64bit) and added Oracle’s own public repository for yum repository (instructions here)

Next we ran an update cycle, and our distro was upgraded to 6.4 from 6.2 and the first issue we realized was X terminal. To resolve, we did the following few activities

Uninstalled the VirtualBox addons

Re-configured the X terminal

Re-installed VirtualBox addons

Then went ahead with instructions available with the oracle-base post for the 11gR2 installation.

Even though all the instructions were tailored for a successful installation of 11GR2 we were stuck as soon as we tried to start the installation process by calling

./runInstaller

A number of Java exceptions where thrown and while digging around, came to a conclusion that, it was due to the exporting DISPLAY and later allowing access to the same.

We found a thread on stackoverflow, with a solution and the solution was

as root

set DISPLAY

$DISPLAY=:0.0

$export DISPLAY

$xhost +

then as user oracle

$su – oracle

$DISPLAY=:0.0

$export DISPLAY

$cd /stage/database

$./runInstaller

A number of .so files were upgraded to recent versions during the 6.2 to 6.4 upgrade process, hence the installer will prompt missing library files which you can safely ignore (We would recommend you to resolve such warning if you are doing a production installation, a test scenario could overlook these wanings)

It is painful, however, please do confirm all the recommended packages or new versions are already available with your linux installation prior going ahead with the installation.

We installed unixODBC package(s) using the add remove software, a newer version than the one suggested by Oracle and proceeded with the database installation.

Even though we were able to complete the installation successfully, left us with huge concerns like the time and efforts required, the level of knowledge about linux and complexities resolving the dependency which is almost nothing in the case of Windows environment.

Anyway, we hope you would enjoy another quality post by us!

regards,

admin

Oracle client server architecture, TNS error “Unable to connect”

Okay guys, a new topic after a long break. We had a situation with a client server based 3rd party application printing certain reports adhering Kuwaiti labor rules (Arabic reports). For reasons unknown our R12 implementation partner has decided to make a set of forms and reports which were copied to individual user computers and called upon requirement.

Recently we wanted to copy the same application for a new user and came across a problem with TNS error “Unable to connect”. Our team has gone through hours to figure out the issue, futile. Ironically legacy applications which were client server architecture were running smooth without triggering the TNS errors at the same time!

Finally, while grouping the folder items by “type” we noticed the presence of a “tnsnames.ora” file along with runtimes (.fmx and .rdp/.rpt files)

Bingo! removing the file resolved almost 48 hours pain in the ***! So, if you come across such a siutation, have a look inside the folder, where ifrun60.EXE “starts in” (Right click the application, check the “Starts in” folder) and make sure that a copy of tnsnames.ora is not present in the same folder with wrong tns entries.

for Windows7bugs,

admin