Pavan DBA's Blog

The DBA Knowledge Store

Archive for the ‘Installation’ Category

DBCA hanging at 89% in 11.1.0.7

Posted by Pavan DBA on March 8, 2011


Hi Friends,

Yesterday when i am creating a database for a 11.1.0.7 database, I found it hanged at 89% and not moving ahead even after 1 hour.

I started tracing the session and found that problem is with allowing “configure Enterprise Manager” option in one of DBCA screens.

When i deselected the option and started DBCA, database creation completed in just 10min. So please do aware of this while implementing in production.

Note: After creating the database, you can use same DBCA to configure EM at any moment of time

Advertisements

Posted in Installation | Tagged: , , | Leave a Comment »

OUI-10058 error during oracle 10g installation

Posted by Pavan DBA on February 18, 2011


Hi Friends, today one of my collegue faced a peculiar problem during Oracle 10gR2 installation on RHEL 5.

He did everything right and asked Unix team to run orainstRoot.sh and root.sh scripts as he don’t have permission. Unix team ran them and said done. When he clicked “OK” on that window, it throwed below error

We both struggled alot and atlast found the solution as “Problem with permissions for oraInst.loc file in /etc directory”

We should have 644 permissions i.e read permission for that file to oracle user and root should be the owner of the file. In our case, we don’t have read permission for oracle user, so it was unable to identify the location of oraInventory.

Solution

1. check the umask setting, umask normally set to 0022
umask 0022 ->
– 755 for directories
– 644 for files
2. check the permission of /etc/oraInst.loc 

$  ls -l /etc/oraInst.loc
-rw-r–r– 1 root root 61 Nov 28 04:00 /etc/oraInst.loc

Note: The problem & solution could not be same, so try in test env before implementing the same in your prod environments

Posted in Installation | Tagged: , , , | 10 Comments »

Problem in installing Oracle10gR2 on Linux 5.2

Posted by Pavan DBA on October 31, 2010


Long back i discussed about a problem in initiating runInstaller while we are installing oracle 10g on Linux 5 (any vendor) at https://pavandba.wordpress.com/2009/12/10/problem-in-installing-oracle10gr2-on-rhel-5-2-solution/

Now, even after initiating runInstaller, still you may face problems as below

1) Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2005-07-07_09-40-45AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred.. java.lang.UnsatisfiedLinkError: /tmp/OraInstall2005-07-07_09-40-45AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory

you may get above error after runInstaller started. The reason for this is non-availability of libXp-1.0.0-8.1.el5.i386.rpm package. So, contact your unix team to install those packages

2) After fixing above package, your runInstaller will be started successfully, but still you may get error at the time of linking the files. This is again due to some packages missing or when you try to install 32bit oracle on 64-bit operating system.

Note : Never try to install 32-bit oracle on 64-bit OS as it is not compatible

When you are having 32-bit OS and installing same bit version oracle, check if you have following packages

binutils.i386
compat-gcc-7.3-2.96.128.i386
compat-gcc-c++-7.3-2.96.128.i386
compat-libstdc++-7.3-2.96.128.i386
compat-libstdc++-devel-7.3-2.96.128.i386
cpp.i386
gcc.i386
gcc-c++.i386
glibc.i386
glibc-common.i386
glibc-devel.i386
glibc-headers.i386
glibc-kernheaders.i386
libstdc++.i386
libstdc++-devel.i386
libaio
libai-devel.i386
pdksh.i386
setarch.i386
sysstat.i386

we can check for above packages using below command

rpm -q binutils gcc glibc glibc-headers glibc-kernheaders glibc-devel compat-libstdc++ cpp compat-gcc make compat-db compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel setarch sysstat pdksh libaio libaio-devel –qf ‘%{name}.%{arch}\n’|sort

3) when we have 64-bit OS and installing 64-bit oracle, use below command to find all the required packages

rpm -q binutils compat-db compat-libstdc++-33 glibc glibc-devel glibc-headers gcc gcc-c++ libstdc++ cpp make libaio ksh elfutils-libelf sysstat libaio libaio-devel setarch –qf ‘%{name}.%{arch}\n’|sort

binutils.x86_64
compat-db.x86_64
compat-libstdc++-33.i386
compat-libstdc++-33.x86_64
cpp.x86_64
elfutils-libelf.i386
elfutils-libelf.x86_64
gcc-c++.x86_64
gcc.x86_64
glibc-devel.i386
glibc-devel.x86_64
glibc-headers.x86_64
glibc.i686
glibc.x86_64
ksh.x86_64
libaio-devel.i386
libaio-devel.x86_64
libaio.i386
libaio.i386
libaio.x86_64
libaio.x86_64
libstdc++.i386
libstdc++.x86_64
make.x86_64
setarch.x86_64
sysstat.x86_64

once everything is ready, you will be done with installation….

Posted in Installation | Tagged: , | Leave a Comment »

10g client (10.2.0.1) cannot be installed on W2k8

Posted by Pavan DBA on February 18, 2010


Yesterday i was trying to install oracle 10g client (10.2.0.1) on a windows 2008 server machine.

To my surprise, i got below error when OUI is initiated

Very wondering, right ? i also felt the same as what to upload here to oracle support? 🙂

After rigorous search in metalink, i found that we cannot install a 10.2.0.1 version client, but need to install atleast 10.2.0.3 client on that configuration

hope this will help you in your future installations !!!

 

Posted in Installation | Tagged: | Leave a Comment »

Problem in installing Oracle10gR2 on RHEL 5.2 & Solution

Posted by Pavan DBA on December 10, 2009


When trying to install the Oracle10gR2 (10.2) software on a Red Hat Enterprise Linux release 5 (RHEL5) server, the prerequisite checks fail.

Oracle Universal Installer (OUI) initially fails with the following error:

Checking installer requirements…
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2 Failed <<<<

After adding redhat-5 to the <path>/database/oraparam.ini, OUI fails with the following errors (during the product specific prerequisite checks):

*** Product-Specific Prerequisite Checks Page***
INFO: Entry point:oracle.server_Custom
INFO: Starting Prerequisite checks : Wed Aug 29 17:52:40 CEST 2007
INFO: Checking CertifiedVersions
This is a prerequisite condition to test whether the Oracle software is certified on the current O/S.
INFO: Expected result: One of redhat-3,redhat-4,SuSE-9,asianux-1,asianux-2
Actual Result: redhat-Red Hat Enterprise Linux Server release 5 (Tikanga)
Check complete. The overall result of this check is: Failed <<<<

Cause
Oracle10gR2 (10.2) was released before RHEL5, so the base installation media does not make provision for installing on RHEL5.
Solution

To resolve the initial problem (starting OUI), use one of the following workarounds:

Workaround #1

Ignore all the prerequisite checking by using

% ./runInstaller -ignoreSysPrereqs

Workaround #2
If you are installing 10.2 from DVD, copy the <path>/database/install/oraparam.ini to a temporary directory (for example, /tmp).

If you are installing 10.2 from an OTN download or have copied the 10.2 media to disk, take a backup of <path>/database/install/oraparam.ini

Now edit oraparam.ini and change the appropriate line:

    Original

    [Certified Versions]
    Linux=redhat-3,SuSE-9,redhat-4,UnitedLinux-1.0,asianux-1,asianux-2

    New

    [Certified Versions]
    Linux=redhat-3,SuSE-9,redhat-4,UnitedLinux-1.0,asianux-1,asianux-2,redhat-5

Now, if you copied oraparam.ini to /tmp, start OUI like this:

    % ./runInstaller -paramFile /tmp/oraparam.ini

If you edited <path>/database/install/oraparam.ini on disk, just start OUI as normal
 

To resolve the second problem (the product specific prerequisite checks), do the following:

Edit <path>/database/stage/prereq/db/refhost.xml

Find the code where the redhat 4 checking ends and the SUSE 9 checking starts

<PROPERTY NAME=”rmem_default” VALUE=”262144″ />
<PROPERTY NAME=”rmem_max” VALUE=”262144″ />
<PROPERTY NAME=”wmem_default” VALUE=”262144″ />
<PROPERTY NAME=”wmem_max” VALUE=”262144″ />
</KERNEL>
</OPERATING_SYSTEM>

++++++ add the new redhat-5 bit in here

<OPERATING_SYSTEM>
<VERSION VALUE=”9″/>
<ARCHITECTURE VALUE=”x86″/>
<NAME VALUE=”Linux”/>
<VENDOR VALUE=”SuSE”/>

Add the following code in the place suggested above:

<OPERATING_SYSTEM>
<VERSION VALUE=”5″/>
<ARCHITECTURE VALUE=”x86″/>
<NAME VALUE=”Linux”/>
<VENDOR VALUE=”redhat”/>
<GLIBC ATLEAST=”2.5-12″>
</GLIBC>
<PACKAGES>
<PACKAGE NAME=”make” VERSION=”3.81″ />
<PACKAGE NAME=”binutils” VERSION=”2.17″ />
<PACKAGE NAME=”gcc” VERSION=”4.1″ />
<PACKAGE NAME=”libaio” VERSION=”0.3.106″ />
</PACKAGES>
<KERNEL>
<PROPERTY NAME=”semmsl” NAME2=”semmsl2″ VALUE=”250″ />
<PROPERTY NAME=”semmns” VALUE=”32000″ />
<PROPERTY NAME=”semopm” VALUE=”100″ />
<PROPERTY NAME=”semmni” VALUE=”128″ />
<PROPERTY NAME=”shmmax” VALUE=”536870912″ />
<PROPERTY NAME=”shmmni” VALUE=”4096″ />
<PROPERTY NAME=”shmall” VALUE=”2097152″ />
<PROPERTY NAME=”file-max” VALUE=”65536″ />
<PROPERTY NAME=”VERSION” VALUE=”2.6.9″ />
<PROPERTY NAME=”ip_local_port_range” ATLEAST=”1024″ ATMOST=”65000″ />
<PROPERTY NAME=”rmem_default” VALUE=”262144″ />
<PROPERTY NAME=”rmem_max” VALUE=”262144″ />
<PROPERTY NAME=”wmem_default” VALUE=”262144″ />
<PROPERTY NAME=”wmem_max” VALUE=”262144″ />
</KERNEL>
</OPERATING_SYSTEM>

Save the changes to refhost.xml and perform the 10.2 software installation.

If you would prefer not to change the refhost.xml file, please manually check that your RHEL5 server meets all of the prerequisites defined in Note:419646.1 and then check the boxes on the “Product Specific Prerequisite Checks” page in OUI to confirm that you have performed manual verification. This should allow the 10.2 software installation to continue.

For more information, before installing, check metalink note :419646.1 – Requirements For Installing Oracle 10gR2 On RHEL/OEL 5 (x86)

Posted in Installation | 5 Comments »

 
%d bloggers like this: