Step 01: Download the appropriate Oracle software version.
The first step is to download oracle software for windows vista or windows 7. So determine your hardware and operating system in order to determine whether you will download oracle 32 bit or 64 bit. You can follow the post http://arjudba.blogspot.com/2008/05/how-to-identify-os-or-oracle-64-bit-or.html in order to determine which version of oracle you will download.
You can get the oracle software from two ways.
Either download from
OTN (technet.oracle.com)
or from
edelivery (edelivery.oracle.com)
I am showing the downloads way from OTN (technet.oracle.com).
You can directly go to page http://www.oracle.com/technetwork/database/database10g/downloads/index.html in order to download Oracle 10g.
If you want to download 64 bit oracle for your windows vista or windows 7 then go to http://www.oracle.com/technetwork/database/10204-winx64-vista-win2k8-082253.html.
If you want to download 64 bit oracle for your windows vista or windows 7 then go to http://www.oracle.com/technetwork/database/10203vista-087538.html to download.
In summary,
For 32bit Windows: Oracle Database 10g Release 2 (10.2.0.3/10.2.0.4) for Microsoft Windows Vista and Windows 2008
For 64bit Windows: Oracle Database 10g Release 2 (10.2.0.4) for Microsoft Windows Vista x64 and Microsoft Windows Server 2008 x64
With 32 bit downloads you can install on Windows Vista, Windows Server 2008 and Windows 7.
With 64 but downloads you can install on Windows Vista x64, Windows Server 2008 x64, Windows 7 x64 and Windows Server 2008 R2 x64.
Step 02: Run the installer (OUI).
Double click on setup.exe. Ignore the following prerequisite errors displayed by Oracle Universal Installer and complete the installation:
i) Checking operating system requirements
ii) Checking service pack requirements
(Click on the Ignore Errors Check Box)
Another option is to run the following command from the command line:
change to the directory where the Oracle files were extracted.
Then run the command:
> setup.exe -ignoreSysprereqs
(command is case sensitive)
This will ignore the Pre-Requisite checks.
Showing posts with label Installation. Show all posts
Showing posts with label Installation. Show all posts
Wednesday, September 29, 2010
Thursday, July 22, 2010
How to uninstall Oracle 11g
Uninstall Oracle software 11.2g
In 11.2g there is deinstall command through which you can uninstall standalone Oracle Database installations, Oracle Clusterware and Automatic Storage Management (ASM) from your server, as well as Oracle Real Application Clusters (Oracle RAC) and Oracle Database client installations. You can find out deinstall tool under $ORACLE_HOME/deinstall folder.
If you don't have deinstall tool you can download it from url http://www.oracle.com/technology/software/products/database/index.html
- Under Oracle Database 11g Release 2, click See All for the respective platform for which you want to download the Deinstallation Tool.
- The Deinstallation Tool is available for download at the end of the page.
So, in 11.2g just use,
$$ORACLE_HOME/deinstall/deinstall
Uninstall Oracle software in 11.1g
If you are running Oracle 11.1g then you have to open the Oracle Universal Installer on windows and runInstaller on unix. In windoes you can find oui under $ORACLE_HOME/oui/bin and file name is setup.exe.
In 11.2g there is deinstall command through which you can uninstall standalone Oracle Database installations, Oracle Clusterware and Automatic Storage Management (ASM) from your server, as well as Oracle Real Application Clusters (Oracle RAC) and Oracle Database client installations. You can find out deinstall tool under $ORACLE_HOME/deinstall folder.
If you don't have deinstall tool you can download it from url http://www.oracle.com/technology/software/products/database/index.html
- Under Oracle Database 11g Release 2, click See All for the respective platform for which you want to download the Deinstallation Tool.
- The Deinstallation Tool is available for download at the end of the page.
So, in 11.2g just use,
$$ORACLE_HOME/deinstall/deinstall
Uninstall Oracle software in 11.1g
If you are running Oracle 11.1g then you have to open the Oracle Universal Installer on windows and runInstaller on unix. In windoes you can find oui under $ORACLE_HOME/oui/bin and file name is setup.exe.
Saturday, December 5, 2009
Oracle Database Installation Exercises
Oracle was developed as a Client/Server database, although there is a mainframe version. Although the process is somewhat automated, the Oracle Enterprise Database is not your simple auto-run installation application. The truth is that there is some pre-configuration work of the OS system, as well as some forethought about naming conventions and the like, that really need to be done before the actual physical installation process begins.
For this lab, you will document what you find to be some of the major differences in the installation process between the current Oracle database version and the previous version, based on information you are pointed toward.
You will be using your textbook and the Internet as your major sources of reference. For the installation of oracle10g, 11g and 9i create a word file and save it in a word document.
 | L A B S T E P |  |
| Step 1: Create a comparison document |
- Any pre-configuration of the Operating System.
- Memory configuration consideration (both physical and logical).
- Naming conventions of the Global Database or System Identifier (SID).
- Online input screens within the Oracle Installer.
- Processes that run during the installation (i.e. port assignments, directories defined, etc.).
- Password configurations or assignments.
- Web Services created (is there one?).
- Any post-configuration of the Operating Ssystem.
Related Documents
Basic Oracle Sql Exercise
Thursday, April 16, 2009
Oracle Installation fails with OUI-10133: Invalid staging area
Problem Description
While installing oracle on my windows machine it fails with the message,
OUI-10133: Invalid staging area. There are no top level components for Windows NT, Windows 2000 available for installation in this staging area.
On linux system this message is like,
OUI-10133: Invalid staging area. There are no top level components for Linux available for installation in this staging area.
Cause of the problem
There are many causes by which this problem can happen.
1)The product.xml directory is not found and hence the problem occurs. In the oraparam.ini the source location is specified to product.xml but no product.xml exist in the stage directory.
2)Someone has deleted the products.xml file from its location and installer could not find it.
3)You have downloaded oracle from e-delivery.oracle.com which contains three zip files and you extracted three zip files into different locations.
4)The staging area i.e stage folder is corrupted.
5)The media is corrupted.
Solution of the Problem
1)Open oraparam.ini configuration file which resides in the install directory both in windows and linux.
2)Within the file you will see there is SOURCE parameter and within it the location of products.xml is specified.
3)Go to that location and be sure that products.xml exist. There might be several reasons that installer could not find any. Suppose you copied oracle software from network and it is not fully copied. Someone deleted file from stage directory.
4)If you download zipped file of oracle software from e-delivery.oracle.com for 11g, then there will be three zip file. Unzip those three files into the same directory and then start installing the software.
5)After downloading software do cksum on source and verify with cksum in the OTN.
6)Get a fresh copy of oracle software and install.
Related Documents
While installing oracle on my windows machine it fails with the message,
OUI-10133: Invalid staging area. There are no top level components for Windows NT, Windows 2000 available for installation in this staging area.
On linux system this message is like,
OUI-10133: Invalid staging area. There are no top level components for Linux available for installation in this staging area.
Cause of the problem
There are many causes by which this problem can happen.
1)The product.xml directory is not found and hence the problem occurs. In the oraparam.ini the source location is specified to product.xml but no product.xml exist in the stage directory.
2)Someone has deleted the products.xml file from its location and installer could not find it.
3)You have downloaded oracle from e-delivery.oracle.com which contains three zip files and you extracted three zip files into different locations.
4)The staging area i.e stage folder is corrupted.
5)The media is corrupted.
Solution of the Problem
1)Open oraparam.ini configuration file which resides in the install directory both in windows and linux.
2)Within the file you will see there is SOURCE parameter and within it the location of products.xml is specified.
3)Go to that location and be sure that products.xml exist. There might be several reasons that installer could not find any. Suppose you copied oracle software from network and it is not fully copied. Someone deleted file from stage directory.
4)If you download zipped file of oracle software from e-delivery.oracle.com for 11g, then there will be three zip file. Unzip those three files into the same directory and then start installing the software.
5)After downloading software do cksum on source and verify with cksum in the OTN.
6)Get a fresh copy of oracle software and install.
Related Documents
Tuesday, March 3, 2009
Install Oracle fails with MakefileException target 'client_sharedlib'
Error Description:
While installing oracle software using oracle universal installer installation fails with a pop up windows Error, Error in invoking target 'client_sharedlib' of makefile '/home/oracle/oracle/product/10.2.0/db_2/network/lib/ins_net_client.mk'.
From the installation log file,
INFO: usr/bin/ld: skipping incompatible /home/oracle/oracle/product/10.2.0/db_2/lib/libxml10.a when
searching for -lxml10
/usr/bin/ld: cannot find -lxml10
collect2: ld returned 1 exit status
genclntsh: Failed to link libclntsh.so.10.1
make: *** [client_sharedlib] Error 1
INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'client_sharedlib' of makefile '/home/oracle/oracle/product/10.2.0/db_2/network/lib/ins_net_client.mk'. See '/home/oracle/oraInventory/logs/installActions200
9-03-03_12-44-04AM.log' for details.
Exception Severity: 1
Cause of the Problem
This problem happens due to the incorrect kernel settings. While installing oracle software using OUI there were several checking and in case of "checking kernel parameters" there were warnings but possibly you avoid warnings by checking the box and hence after wards above error arises.
Solution of the Problems
1)Make sure you are installing 64 bit oracle on your 64 bit linux; 32 bit oracle software on your 32 bit linux software. If you don't do "Error in invoking target 'client_sharedlib' of makefile" will likely be the problem. So before proceed ensure your hardware platform, linux platform and oracle software. Identified these things are discussed detail in
How to Identify OS or Oracle 64 bit or 32 bit on Unix
2)Make sure oracle is the owner of the directory where you install oracle software. You can set ownership recursively as root user by,
#chown -R oracle:oinstall /home/oracle/oracle
if your installation path is /home/oracle/oracle
3)On Red hat linux, correctly set your kernel parameters.
Edit /etc/sysctl.conf file and entry followings.
#vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144
To make immediate effect issue,
#/sbin/sysctl -p
For other system and details about kernel parameter settings see the post
How to configure(modify,see) Kernel Parameters in Linux
While installing oracle software using oracle universal installer installation fails with a pop up windows Error, Error in invoking target 'client_sharedlib' of makefile '/home/oracle/oracle/product/10.2.0/db_2/network/lib/ins_net_client.mk'.
From the installation log file,
INFO: usr/bin/ld: skipping incompatible /home/oracle/oracle/product/10.2.0/db_2/lib/libxml10.a when
searching for -lxml10
/usr/bin/ld: cannot find -lxml10
collect2: ld returned 1 exit status
genclntsh: Failed to link libclntsh.so.10.1
make: *** [client_sharedlib] Error 1
INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'client_sharedlib' of makefile '/home/oracle/oracle/product/10.2.0/db_2/network/lib/ins_net_client.mk'. See '/home/oracle/oraInventory/logs/installActions200
9-03-03_12-44-04AM.log' for details.
Exception Severity: 1
Cause of the Problem
This problem happens due to the incorrect kernel settings. While installing oracle software using OUI there were several checking and in case of "checking kernel parameters" there were warnings but possibly you avoid warnings by checking the box and hence after wards above error arises.
Solution of the Problems
1)Make sure you are installing 64 bit oracle on your 64 bit linux; 32 bit oracle software on your 32 bit linux software. If you don't do "Error in invoking target 'client_sharedlib' of makefile" will likely be the problem. So before proceed ensure your hardware platform, linux platform and oracle software. Identified these things are discussed detail in
How to Identify OS or Oracle 64 bit or 32 bit on Unix
2)Make sure oracle is the owner of the directory where you install oracle software. You can set ownership recursively as root user by,
#chown -R oracle:oinstall /home/oracle/oracle
if your installation path is /home/oracle/oracle
3)On Red hat linux, correctly set your kernel parameters.
Edit /etc/sysctl.conf file and entry followings.
#vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144
To make immediate effect issue,
#/sbin/sysctl -p
For other system and details about kernel parameter settings see the post
How to configure(modify,see) Kernel Parameters in Linux
Running OUI fails with Xlib: No protocol specified
Problem Description
Using VNC Viewer (a software which is used to show GUI in the unix server from any windows machine) whenever you run runInstaller as oracle database user it fails with below message.
$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-03-03_12-34-07AM. Please wait ...[oracle@localhost database]$ Xlib: connection to ":1.0" refused by server
Xlib: No protocol specified
Exception in thread "main" java.lang.InternalError: Can't connect to X11 window server using ':1.0' as the value of the DISPLAY variable.
at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
at sun.awt.X11GraphicsEnvironment.<clinit>(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(Unknown Source)
at java.awt.Window.init(Unknown Source)
at java.awt.Window.<init>(Unknown Source)
at java.awt.Frame.<init>(Unknown Source)
at oracle.ewt.popup.PopupFrame.<init>(Unknown Source)
at oracle.ewt.lwAWT.BufferedFrame.<init>(Unknown Source)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.<init>(OiocOneClickInstaller.java:378)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.main(OiocOneClickInstaller.java:2091)
Cause of the problem
The client users are not authorized to connect to the X Server.
This is by default settings that access control is enabled and client users will not be access the X server.
Solution of the Problem
In order to enable client users to access the X Server as a root user issue "xhost +".
[oracle@localhost database]$ su - root
Password:
[root@localhost ~]# xhost +
access control disabled, clients can connect from any host
Now as oracle user you will be able to run runInstaller successfully.
[root@localhost ~]# su - oracle
[oracle@localhost ~]$ ./runInstaller
Related Documents
Install Oracle fails with MakefileException target 'client_sharedlib'
Clusterware Installation fails at the end of CRS on Red Hat Linux 5
Using VNC Viewer (a software which is used to show GUI in the unix server from any windows machine) whenever you run runInstaller as oracle database user it fails with below message.
$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-03-03_12-34-07AM. Please wait ...[oracle@localhost database]$ Xlib: connection to ":1.0" refused by server
Xlib: No protocol specified
Exception in thread "main" java.lang.InternalError: Can't connect to X11 window server using ':1.0' as the value of the DISPLAY variable.
at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
at sun.awt.X11GraphicsEnvironment.<clinit>(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(Unknown Source)
at java.awt.Window.init(Unknown Source)
at java.awt.Window.<init>(Unknown Source)
at java.awt.Frame.<init>(Unknown Source)
at oracle.ewt.popup.PopupFrame.<init>(Unknown Source)
at oracle.ewt.lwAWT.BufferedFrame.<init>(Unknown Source)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.<init>(OiocOneClickInstaller.java:378)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.main(OiocOneClickInstaller.java:2091)
Cause of the problem
The client users are not authorized to connect to the X Server.
This is by default settings that access control is enabled and client users will not be access the X server.
Solution of the Problem
In order to enable client users to access the X Server as a root user issue "xhost +".
[oracle@localhost database]$ su - root
Password:
[root@localhost ~]# xhost +
access control disabled, clients can connect from any host
Now as oracle user you will be able to run runInstaller successfully.
[root@localhost ~]# su - oracle
[oracle@localhost ~]$ ./runInstaller
Related Documents
Install Oracle fails with MakefileException target 'client_sharedlib'
Clusterware Installation fails at the end of CRS on Red Hat Linux 5
Sunday, March 1, 2009
Exception java.lang.UnsatisfiedLinkError libXp.so.6: cannot open shared object file
Problem Description
Whenever you run Oracle Universal Installer to install oracle software it fails with Exception java.lang.UnsatisfiedLinkError indicating libXp.so.6: cannot open shared object file: No such file or directory.
$./runInstaller
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-03-02_10-57-23AM. Please wait ...$oracle Universal Installer , Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2009-03-02_10-57-23AM/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/OraInstall2009-03-02_10-57-23AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at sun.security.action.LoadLibraryAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
at sun.awt.DebugHelper.<clinit>(Unknown Source)
at java.awt.Component.<clinit>(Unknown Source)
Cause of the Problem
Oracle tries to open the shared object file libXp.so.6 but it could not find any. In RHEL 4 and from fedora core release (1,2,3,4 ....) "libXp.so.6" is deprecated and as such, the "xorg-x11-deprecated-libs" package is missing.
If available, then "libXp.so.6" should be found in the /usr/X11R6/lib64 directory of Linux.
On disk 2 of the linux installation CD "libXp.so.6", is available under rpm package,
xorg-x11-deprecated-libs-<version>6.8.1-12.i386.rpm
Solution of the problem
Install the missing "xorg-x11-deprecated-libs" package.
1)Issue the following command to be sure whether libXp is missing,
$ rpm --query --whatprovides 'libXp.so.6'
or by,
$ rpm --query --whatprovides 'libXp.so.6'
2)Install the package by,
# rpm -ivh xorg-x11-deprecated-libs.<version-info>.rpm
Examples of rpm packages containing libXp.so.6 are,
xorg-x11-deprecated-libs-6.8.1-12.i386.rpm,
xorg-x11-deprecated-libs-6.8.2-31.i386.rpm
Related Documents
Install Oracle fails with MakefileException target 'client_sharedlib'
Clusterware Installation fails at the end of CRS on Red Hat Linux 5
Whenever you run Oracle Universal Installer to install oracle software it fails with Exception java.lang.UnsatisfiedLinkError indicating libXp.so.6: cannot open shared object file: No such file or directory.
$./runInstaller
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-03-02_10-57-23AM. Please wait ...$oracle Universal Installer , Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2009-03-02_10-57-23AM/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/OraInstall2009-03-02_10-57-23AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at sun.security.action.LoadLibraryAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
at sun.awt.DebugHelper.<clinit>(Unknown Source)
at java.awt.Component.<clinit>(Unknown Source)
Cause of the Problem
Oracle tries to open the shared object file libXp.so.6 but it could not find any. In RHEL 4 and from fedora core release (1,2,3,4 ....) "libXp.so.6" is deprecated and as such, the "xorg-x11-deprecated-libs" package is missing.
If available, then "libXp.so.6" should be found in the /usr/X11R6/lib64 directory of Linux.
On disk 2 of the linux installation CD "libXp.so.6", is available under rpm package,
xorg-x11-deprecated-libs-<version>6.8.1-12.i386.rpm
Solution of the problem
Install the missing "xorg-x11-deprecated-libs" package.
1)Issue the following command to be sure whether libXp is missing,
$ rpm --query --whatprovides 'libXp.so.6'
or by,
$ rpm --query --whatprovides 'libXp.so.6'
2)Install the package by,
# rpm -ivh xorg-x11-deprecated-libs.<version-info>.rpm
Examples of rpm packages containing libXp.so.6 are,
xorg-x11-deprecated-libs-6.8.1-12.i386.rpm,
xorg-x11-deprecated-libs-6.8.2-31.i386.rpm
Related Documents
Install Oracle fails with MakefileException target 'client_sharedlib'
Clusterware Installation fails at the end of CRS on Red Hat Linux 5
Monday, January 12, 2009
Resolve of DIM-00019: create service error
Problem Scenario
You have cold backup of oracle database directory structure along with oracle software. Now your Windows OS got corrupted. So you reinstall your windows operating system and you try to restore the database.
After installing software you set the ORACLE_SID and ORACLE_HOME environmental variable and whenever you create oracle service with oradim it fails with below message.
C:\>oradim -new -sid orcl -intpwd orcl -startmode manual -pfile 'F:\oracle10g\pr
oduct\10.2.0\db_1\database\initorcl.ora'
Instance created.
DIM-00019: create service error
O/S-Error: (OS 2) The system cannot find the file specified.
Solution of the Problem
On linux environment you don't need these things. But in windows environment you need to do a lot of things more than restoring files. Whenever a windows OS gets corrupted you loose the Oracle Universal Installer repository and the regedit entries along with oracle home structure. So to solve the problem it is better to install new oracle software in your windows machine without any database and then create oracle instance and service using oradim.
You have cold backup of oracle database directory structure along with oracle software. Now your Windows OS got corrupted. So you reinstall your windows operating system and you try to restore the database.
After installing software you set the ORACLE_SID and ORACLE_HOME environmental variable and whenever you create oracle service with oradim it fails with below message.
C:\>oradim -new -sid orcl -intpwd orcl -startmode manual -pfile 'F:\oracle10g\pr
oduct\10.2.0\db_1\database\initorcl.ora'
Instance created.
DIM-00019: create service error
O/S-Error: (OS 2) The system cannot find the file specified.
Solution of the Problem
On linux environment you don't need these things. But in windows environment you need to do a lot of things more than restoring files. Whenever a windows OS gets corrupted you loose the Oracle Universal Installer repository and the regedit entries along with oracle home structure. So to solve the problem it is better to install new oracle software in your windows machine without any database and then create oracle instance and service using oradim.
Friday, October 24, 2008
Which Options are installed on your oracle database
There are various ways to know which options are installed on your oracle database. Below is some.
1)Using Oracle Universal Installer:
-Go to oracle database software installer.
-Under install folder run oracle universal installer. On windows it is oui.exe and on unix it is runIstaller.sh
-Select Installed Products.
-In the Inventory expand the selection and you can see list of options installed.
2)From V$OPTION:
From v$option view the column value's value TRUE means the corresponding option is installed/available and FALSE mean corresponding option is not installed/ not available.
SQL> set pages 100
SQL> col value for a5
SQL> set lines 120
SQL> select * from v$option;
PARAMETER VALUE
---------------------------------------------------------------- -----
Partitioning TRUE
Objects TRUE
Real Application Clusters FALSE
Advanced replication TRUE
.
.
Which indicates partition can be done or in other word partitioning feature is available but RAC is not installed or in other word RAC yet not available.
3)From DBA_REGISTRY:
In order to know which components are loaded into database and what is their current status issue,
SQL> col comp_name for a70
SQL> select comp_name, status from dba_registry;
COMP_NAME STATUS
---------------------------------------------------------------------- -----------
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
Oracle Workspace Manager VALID
JServer JAVA Virtual Machine VALID
Oracle XDK VALID
Oracle Database Java Packages VALID
Oracle Expression Filter VALID
Oracle Data Mining VALID
Oracle Text VALID
Oracle XML Database VALID
Oracle Rules Manager VALID
Oracle interMedia VALID
OLAP Analytic Workspace VALID
Oracle OLAP API VALID
OLAP Catalog VALID
Spatial VALID
Oracle Enterprise Manager VALID
17 rows selected.
1)Using Oracle Universal Installer:
-Go to oracle database software installer.
-Under install folder run oracle universal installer. On windows it is oui.exe and on unix it is runIstaller.sh
-Select Installed Products.
-In the Inventory expand the selection and you can see list of options installed.
2)From V$OPTION:
From v$option view the column value's value TRUE means the corresponding option is installed/available and FALSE mean corresponding option is not installed/ not available.
SQL> set pages 100
SQL> col value for a5
SQL> set lines 120
SQL> select * from v$option;
PARAMETER VALUE
---------------------------------------------------------------- -----
Partitioning TRUE
Objects TRUE
Real Application Clusters FALSE
Advanced replication TRUE
.
.
Which indicates partition can be done or in other word partitioning feature is available but RAC is not installed or in other word RAC yet not available.
3)From DBA_REGISTRY:
In order to know which components are loaded into database and what is their current status issue,
SQL> col comp_name for a70
SQL> select comp_name, status from dba_registry;
COMP_NAME STATUS
---------------------------------------------------------------------- -----------
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
Oracle Workspace Manager VALID
JServer JAVA Virtual Machine VALID
Oracle XDK VALID
Oracle Database Java Packages VALID
Oracle Expression Filter VALID
Oracle Data Mining VALID
Oracle Text VALID
Oracle XML Database VALID
Oracle Rules Manager VALID
Oracle interMedia VALID
OLAP Analytic Workspace VALID
Oracle OLAP API VALID
OLAP Catalog VALID
Spatial VALID
Oracle Enterprise Manager VALID
17 rows selected.
Tuesday, September 9, 2008
Clusterware Installation fails at the end of CRS on Red Hat Linux 5
Problem Description
While installing oracle clusterware on Red Hat Enterprise Linux 5.0 at then end of the installation of Cluster Ready Services OUI prompts for the $CRS_HOME/root.sh script to be run on all
of the nodes in the cluster. The fact is when the root.sh script is run on the last node in
the cluster, the script calls the VIPCA utility which fails in RHEL 5. The same failure occurs on Red Hat Enterprise Linux 5.0, and SUSE Linux Enterprise Linux 10.
Solution of The Problem
As a workaround to solve the problem before running the root.sh script on the last node in the cluster,
alter the $CRS_HOME/bin/vipca script commenting out lines 119 through 123:
arch=’uname -m’
# if [ "$arch" = "i686" -o "$arch" = "ia64" -o "$arch" = "x86_64" ]
# then
# LD_ASSUME_KERNEL=2.4.19
# export LD_ASSUME_KERNEL
# fi
After commenting out run root.sh and it should be able to call VIPCA successfully.
But don't comment out the line 118 that is arch=’uname -m’ as it is needed by the root.sh script to set the arch variable.
Related Documents
Installing Clusterware through OUI fails Cheking OS version in RHL-5
While installing oracle clusterware on Red Hat Enterprise Linux 5.0 at then end of the installation of Cluster Ready Services OUI prompts for the $CRS_HOME/root.sh script to be run on all
of the nodes in the cluster. The fact is when the root.sh script is run on the last node in
the cluster, the script calls the VIPCA utility which fails in RHEL 5. The same failure occurs on Red Hat Enterprise Linux 5.0, and SUSE Linux Enterprise Linux 10.
Solution of The Problem
As a workaround to solve the problem before running the root.sh script on the last node in the cluster,
alter the $CRS_HOME/bin/vipca script commenting out lines 119 through 123:
arch=’uname -m’
# if [ "$arch" = "i686" -o "$arch" = "ia64" -o "$arch" = "x86_64" ]
# then
# LD_ASSUME_KERNEL=2.4.19
# export LD_ASSUME_KERNEL
# fi
After commenting out run root.sh and it should be able to call VIPCA successfully.
But don't comment out the line 118 that is arch=’uname -m’ as it is needed by the root.sh script to set the arch variable.
Related Documents
Installing Clusterware through OUI fails Cheking OS version in RHL-5
Wednesday, September 3, 2008
In EM connection fails with ERROR: NMO not setuid-root (Unix-only)
Error Description
This problem is notified on Unix system only.
Whenever you try to connect to enterprise manager after giving host username and password as prompted it fails with message
HostPassword - Connection to host as user oracle failed: ERROR: NMO not setuid-root (Unix-only)
Cause of The Problem
There is some permission issue on the enterprise manager binary file. The reason is after installing oracle software you have not run root.sh
Solution of The Problem
1.Stop the dbconsole service
$emctl stop dbconsole
If you face this on grid control then stop the Grid Management Agent
$emctl stop agent
2.Log on as root user and run the root.sh file
bash-3.00$ su
Password:
# cd /oracle/app/oracle/product/10.2.0/db_1/
# ./root.sh
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/app/oracle/product/10.2.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y
Copying coraenv to /usr/local/bin ...
Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
If you are on Grid Control then also run /root.sh from $ORACLE_HOME.
3.Connect to oracle user and start the dbconsole or grid management agent(if you are in grid control).
$emctl start dbconsole (dbcontrol)
$emctl start agent (grid control)
This problem is notified on Unix system only.
Whenever you try to connect to enterprise manager after giving host username and password as prompted it fails with message
HostPassword - Connection to host as user oracle failed: ERROR: NMO not setuid-root (Unix-only)
Cause of The Problem
There is some permission issue on the enterprise manager binary file. The reason is after installing oracle software you have not run root.sh
Solution of The Problem
1.Stop the dbconsole service
$emctl stop dbconsole
If you face this on grid control then stop the Grid Management Agent
$emctl stop agent
2.Log on as root user and run the root.sh file
bash-3.00$ su
Password:
# cd /oracle/app/oracle/product/10.2.0/db_1/
# ./root.sh
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/app/oracle/product/10.2.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y
Copying coraenv to /usr/local/bin ...
Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
If you are on Grid Control then also run /root.sh from $ORACLE_HOME.
3.Connect to oracle user and start the dbconsole or grid management agent(if you are in grid control).
$emctl start dbconsole (dbcontrol)
$emctl start agent (grid control)
Sunday, August 24, 2008
ORA-39212: installation error: XSL stylesheets not loaded correctly
Problem Description
SQL> select dbms_metadata.get_ddl('TABLE','TEST_EXT') from dual;
ERROR:
ORA-39212: installation error: XSL stylesheets not loaded correctly
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7398
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7447
ORA-06512: at "SYS.DBMS_METADATA_INT", line 9453
ORA-06512: at "SYS.DBMS_METADATA", line 1919
ORA-06512: at "SYS.DBMS_METADATA", line 2792
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1
no rows selected
Cause of The Problem
The XSL stylesheets used by the Data Pump Metadata API were not loaded correctly into the Oracle dictionary table "sys.metastylesheet."
It may be the cause that the stylesheets were not loaded at all in the database, or they were not converted to the database character set.
Suppose if you convert your database character set using ALTER DATABASE statement then likely you will face this problem.
Solution of The Problem
Note that never use ALTER DATABASE statement to migrate your characterset.
1)Connect as sysdba.
SQL> conn / as sysdba
Connected.
2)Execute dbms_metadata_util.load_stylesheets to reload the stylesheets.
SQL> exec dbms_metadata_util.load_stylesheets;
PL/SQL procedure successfully completed.
3)Exit and run the above query,
SQL>exit
$>conn ARJU/a
SQL>select dbms_metadata.get_ddl('TABLE','TEST_EXT') from dual;
SQL> select dbms_metadata.get_ddl('TABLE','TEST_EXT') from dual;
ERROR:
ORA-39212: installation error: XSL stylesheets not loaded correctly
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7398
ORA-06512: at "SYS.DBMS_METADATA_INT", line 7447
ORA-06512: at "SYS.DBMS_METADATA_INT", line 9453
ORA-06512: at "SYS.DBMS_METADATA", line 1919
ORA-06512: at "SYS.DBMS_METADATA", line 2792
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1
no rows selected
Cause of The Problem
The XSL stylesheets used by the Data Pump Metadata API were not loaded correctly into the Oracle dictionary table "sys.metastylesheet."
It may be the cause that the stylesheets were not loaded at all in the database, or they were not converted to the database character set.
Suppose if you convert your database character set using ALTER DATABASE statement then likely you will face this problem.
Solution of The Problem
Note that never use ALTER DATABASE statement to migrate your characterset.
1)Connect as sysdba.
SQL> conn / as sysdba
Connected.
2)Execute dbms_metadata_util.load_stylesheets to reload the stylesheets.
SQL> exec dbms_metadata_util.load_stylesheets;
PL/SQL procedure successfully completed.
3)Exit and run the above query,
SQL>exit
$>conn ARJU/a
SQL>select dbms_metadata.get_ddl('TABLE','TEST_EXT') from dual;
Saturday, August 23, 2008
OUI-10020: A write lock cannot be obtained.
Problem Description
While using OUI it fails with following message,
OUI-10020:The target area /oracle/10gR2/oraInventory is being used by another session. A write lock cannot be obtained.
Cause of The Problem
There is some process or software that holds lock on the /oracle/10gR2/oraInventory file. Until that software release lock OUI continues to display message OUI-10020.
Solution of The Problem
1.Go to the oraInventory directory.
$cd /oracle/10gR2/oraInventory
2. See the contents of it.
$ls /oracle/10gR2/oraInventory
You will see the locks directory here.
3.Go to the lock directory and delete the read lock under the directory.
$cd locks
$ rm /oracle/10gR2/oraInventory/locks/reader0.lock
4.Now run your Oracle Universal Installer.
While using OUI it fails with following message,
OUI-10020:The target area /oracle/10gR2/oraInventory is being used by another session. A write lock cannot be obtained.
Cause of The Problem
There is some process or software that holds lock on the /oracle/10gR2/oraInventory file. Until that software release lock OUI continues to display message OUI-10020.
Solution of The Problem
1.Go to the oraInventory directory.
$cd /oracle/10gR2/oraInventory
2. See the contents of it.
$ls /oracle/10gR2/oraInventory
You will see the locks directory here.
3.Go to the lock directory and delete the read lock under the directory.
$cd locks
$ rm /oracle/10gR2/oraInventory/locks/reader0.lock
4.Now run your Oracle Universal Installer.
Sunday, August 17, 2008
RunInstaller fails with java.lang.UnsatisfiedLinkError
To install clusterware whenever I run runIstaller it fails with following errors along with unknown source.
-bash-3.1$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-08-17_03-53-41PM. Please wait ...-bash-3.1$ Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2008-08-17_03-53-41PM/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/OraInstall2008-08-17_03-53-41PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at sun.security.action.LoadLibraryAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
at sun.awt.DebugHelper.(Unknown Source)
at java.awt.Component.(Unknown Source)
at oracle.sysman.oii.oiif.oiifm.OiifmGraphicInterfaceManager.(OiifmGraphicInterfaceManager.java:222)
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.createInterfaceManager(OiicSessionInterfaceManager.java:193)
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.getInterfaceManager(OiicSessionInterfaceManager.java:202)
at oracle.sysman.oii.oiic.OiicInstaller.getInterfaceManager(OiicInstaller.java:436)
at oracle.sysman.oii.oiic.OiicInstaller.runInstaller(OiicInstaller.java:926)
at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:866)
Exception in thread "main" java.lang.NoClassDefFoundError
at oracle.sysman.oii.oiif.oiifm.OiifmGraphicInterfaceManager.(OiifmGraphicInterfaceManager.java:222)
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.createInterfaceManager(OiicSessionInterfaceManager.java:193)
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.getInterfaceManager(OiicSessionInterfaceManager.java:202)
at oracle.sysman.oii.oiif.oiifm.OiifmAlert.(OiifmAlert.java:151)
at oracle.sysman.oii.oiic.OiicInstaller.runInstaller(OiicInstaller.java:984)
at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:866)
Solution of The problem
Create the dynamic link with the library as following,
$cd /usr/lib
$ln -s libXpm.so.4.11.0 libXp.so.6
-bash-3.1$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-08-17_03-53-41PM. Please wait ...-bash-3.1$ Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2008-08-17_03-53-41PM/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/OraInstall2008-08-17_03-53-41PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at sun.security.action.LoadLibraryAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
at sun.awt.DebugHelper.
at java.awt.Component.
at oracle.sysman.oii.oiif.oiifm.OiifmGraphicInterfaceManager.
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.createInterfaceManager(OiicSessionInterfaceManager.java:193)
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.getInterfaceManager(OiicSessionInterfaceManager.java:202)
at oracle.sysman.oii.oiic.OiicInstaller.getInterfaceManager(OiicInstaller.java:436)
at oracle.sysman.oii.oiic.OiicInstaller.runInstaller(OiicInstaller.java:926)
at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:866)
Exception in thread "main" java.lang.NoClassDefFoundError
at oracle.sysman.oii.oiif.oiifm.OiifmGraphicInterfaceManager.
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.createInterfaceManager(OiicSessionInterfaceManager.java:193)
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.getInterfaceManager(OiicSessionInterfaceManager.java:202)
at oracle.sysman.oii.oiif.oiifm.OiifmAlert.
at oracle.sysman.oii.oiic.OiicInstaller.runInstaller(OiicInstaller.java:984)
at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:866)
Solution of The problem
Create the dynamic link with the library as following,
$cd /usr/lib
$ln -s libXpm.so.4.11.0 libXp.so.6
Installing Clusterware through OUI fails Cheking OS version in RHL-5
Whenever to install oracle clusterware I run runInstaller on Red hat linux 5 machine it fails with operating system version test. The same problem happens whenever you try to install Oracle Clusterware or oracle database 10g on Oracle Enterprise Linux 5.0 or SUSE Linux Enterprise Server 10 then the current version of Oracle Universal Installer does not recognized these operating systems as supported operating systems and does not perform the installation. It fails like below.
-bash-3.1$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Failed <<<< style="font-weight: bold;">Cause of The Problem
The installer picks up the version of Linux installed from the /etc/redhat-release file. There may be several reasons for which the above messages can be shown.
1. Your OS is not certified with the oracle certification to install clusterware.
2. The /etc/redhat-release become corrupted and installer can't read the file.
3. It cannot identify the version of Linux installed in the machine and reports a failure accordingly.
4. May be bug of the OUI.
Solution of The Problem
Method 1: Change the release value in /etc/redhat-release
Step 1: Ensure that your OS version is certified with clusterware installation or the product you want to install. This can be seen by oracle certification matrix.
Step2: Ensure that /etc/redhat-release is there and not corrupted. You can copy it to somewhere and edit it.
Step 3: I have seen if you want to install oracle clusterware on RHL 5 then then it shows above failure though it is certified and I have intact /etc/redhat-release. In that case to meet clusterware installation edit the /etc/redhat-release file to make it from 5 to 4.
The original value and changed value is listed below.
•On Oracle Enterprise Linux 5.0, original value is "Enterprise Linux Enterprise Linux server release 5". Change it to Enterprise Release Enterprise Linux server release 4.
•On Red Hat Enterprise Linux 5.0, original value is "Red Hat Enterprise Linux server release 5". Change it to Red Hat Enterprise Linux server release 4.
•On SUSE Linux Enterprise Server 10, original value is
SUSE Linux Enterprise Server 10 (x86_64)
VERSION = 10
Change it to
SUSE Linux Enterprise Server 9 (x86_64)
VERSION = 9
I have done this on my Red Hat system as,
-bash-3.1$ vi /etc/redhat-release
Red Hat Enterprise Linux Server release 4 (Tikanga)
Now again try to run runInstaller and possibly you will not get the error.
Method 2: (recommended) Running as ignoreSysPrereqs flag:
The idea is while running OUI( Oracle Universal Installer) command it to skip operating system test. Start the runIstaller as
./runinstaller -ignoreSysPrereqs
which causes the installer to skip the operating system check and continue with the installation.
Related Documents
Install Oracle Database 10g Software on Red Hat Linux
-bash-3.1$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Failed <<<< style="font-weight: bold;">Cause of The Problem
The installer picks up the version of Linux installed from the /etc/redhat-release file. There may be several reasons for which the above messages can be shown.
1. Your OS is not certified with the oracle certification to install clusterware.
2. The /etc/redhat-release become corrupted and installer can't read the file.
3. It cannot identify the version of Linux installed in the machine and reports a failure accordingly.
4. May be bug of the OUI.
Solution of The Problem
Method 1: Change the release value in /etc/redhat-release
Step 1: Ensure that your OS version is certified with clusterware installation or the product you want to install. This can be seen by oracle certification matrix.
Step2: Ensure that /etc/redhat-release is there and not corrupted. You can copy it to somewhere and edit it.
Step 3: I have seen if you want to install oracle clusterware on RHL 5 then then it shows above failure though it is certified and I have intact /etc/redhat-release. In that case to meet clusterware installation edit the /etc/redhat-release file to make it from 5 to 4.
The original value and changed value is listed below.
•On Oracle Enterprise Linux 5.0, original value is "Enterprise Linux Enterprise Linux server release 5". Change it to Enterprise Release Enterprise Linux server release 4.
•On Red Hat Enterprise Linux 5.0, original value is "Red Hat Enterprise Linux server release 5". Change it to Red Hat Enterprise Linux server release 4.
•On SUSE Linux Enterprise Server 10, original value is
SUSE Linux Enterprise Server 10 (x86_64)
VERSION = 10
Change it to
SUSE Linux Enterprise Server 9 (x86_64)
VERSION = 9
I have done this on my Red Hat system as,
-bash-3.1$ vi /etc/redhat-release
Red Hat Enterprise Linux Server release 4 (Tikanga)
Now again try to run runInstaller and possibly you will not get the error.
Method 2: (recommended) Running as ignoreSysPrereqs flag:
The idea is while running OUI( Oracle Universal Installer) command it to skip operating system test. Start the runIstaller as
./runinstaller -ignoreSysPrereqs
which causes the installer to skip the operating system check and continue with the installation.
Related Documents
Install Oracle Database 10g Software on Red Hat Linux
Wednesday, August 13, 2008
Pre-Installation RAC environement setup check with CVU
Checking the Network Setup with CVU
To verify node connectivity among all nodes in your cluster use following syntax as an oracle user,
/mount_point/crs/Disk1/cluvfy/runcluvfy.sh comp nodecon -n node_list [-verbose]
If you have two nodes node1 and node2 and your mountpoint is /dev/cdrom then enter following command.
/dev/cdrom/crs/Disk1/cluvfy/runcluvfy.sh comp nodecon -n node1,node2 -verbose
Checking the Hardware and Operating System Setup with CV
As an oracle user use the following command syntax to start Cluster Verification Utility (CVU) stage verification to check hardware and OS setup:
/mountpoint/crs/Disk1/cluvfy/runcluvfy.sh stage –post hwos –n node_list [-verbose]
If you have two nodes node1 and node2 and your mountpoint is /dev/cdrom then enter following command,
/dev/cdrom/crs/Disk1/cluvfy/runcluvfy.sh stage –post hwos –n node1,node2
Checking the Operating System Requirements Setup with CVU
To check if your system meets the operating system requirement pre-installation tasks use the following syntax,
/mountpoint/crs/Disk1/cluvfy/runcluvfy.sh comp sys -n node_list -p {crs|database}
-osdba osdba_group -orainv orainv_group -verbose
If you have two nodes node1 and node2 and your mountpoint is /dev/cdrom with the OSDBA dba and Oracle inventory group oinstall then enter following command,
/dev/cdrom/crs/Disk1/cluvfy/runcluvfy.sh comp sys -n node1,node2 -p crs -osdba crs -orainv oinstall
To verify node connectivity among all nodes in your cluster use following syntax as an oracle user,
/mount_point/crs/Disk1/cluvfy/runcluvfy.sh comp nodecon -n node_list [-verbose]
If you have two nodes node1 and node2 and your mountpoint is /dev/cdrom then enter following command.
/dev/cdrom/crs/Disk1/cluvfy/runcluvfy.sh comp nodecon -n node1,node2 -verbose
Checking the Hardware and Operating System Setup with CV
As an oracle user use the following command syntax to start Cluster Verification Utility (CVU) stage verification to check hardware and OS setup:
/mountpoint/crs/Disk1/cluvfy/runcluvfy.sh stage –post hwos –n node_list [-verbose]
If you have two nodes node1 and node2 and your mountpoint is /dev/cdrom then enter following command,
/dev/cdrom/crs/Disk1/cluvfy/runcluvfy.sh stage –post hwos –n node1,node2
Checking the Operating System Requirements Setup with CVU
To check if your system meets the operating system requirement pre-installation tasks use the following syntax,
/mountpoint/crs/Disk1/cluvfy/runcluvfy.sh comp sys -n node_list -p {crs|database}
-osdba osdba_group -orainv orainv_group -verbose
If you have two nodes node1 and node2 and your mountpoint is /dev/cdrom with the OSDBA dba and Oracle inventory group oinstall then enter following command,
/dev/cdrom/crs/Disk1/cluvfy/runcluvfy.sh comp sys -n node1,node2 -p crs -osdba crs -orainv oinstall
Tuesday, August 12, 2008
Various Tools for Installing, Configuring Oracle RAC
1)Oracle Universal Installer (OUI)- After configuring the pre-installation tasks of the nodes OUI installs the Oracle Clusterware and the Oracle Database software with Oracle RAC. It also can install oracle software on the other nodes using a network connection.
2)Cluster Verification Utility (CVU)- The CVU is a command-line tool. It is very useful to check the nodes for preinstallation as well as postinstallation requirements of the cluster environment. In fact OUI runs the CVU after the Oracle Clusterware installation to verify the environment.
3)Oracle Enterprise Manager- With EM it is easy to configure RAC environments. It has both the Database Control and Grid Control graphical user interfaces (GUIs).
4)Server Control (SRVCTL)- SRVCTL is a command-line interface that you can use to manage an Oracle RAC database from a single point. Using SRVCTL you can start or stop or manage any instance on the cluster.
5)Cluster Ready Services Control (CRSCTL)- CRSCTL is a command-line tool that you can use to manage Oracle Clusterware. You can use CRSCTL to start and stop Oracle Clusterware and to determine the current status of your Oracle Clusterware installation.
6)Oracle Interface Configuration Tool (OIFCFG)- OIFCFG is a command-line tool which you can use to allocate and de-allocate network interfaces to components. You can use OIFCFG to direct components to use specific network interfaces and to retrieve component configuration information.
7)OCR Configuration Tool (OCRCONFIG)- OCRCONFIG is a command-line tool for OCR administration. You can also use the OCRCHECK and OCRDUMP utilities to troubleshoot configuration problems that affect the OCR.
2)Cluster Verification Utility (CVU)- The CVU is a command-line tool. It is very useful to check the nodes for preinstallation as well as postinstallation requirements of the cluster environment. In fact OUI runs the CVU after the Oracle Clusterware installation to verify the environment.
3)Oracle Enterprise Manager- With EM it is easy to configure RAC environments. It has both the Database Control and Grid Control graphical user interfaces (GUIs).
4)Server Control (SRVCTL)- SRVCTL is a command-line interface that you can use to manage an Oracle RAC database from a single point. Using SRVCTL you can start or stop or manage any instance on the cluster.
5)Cluster Ready Services Control (CRSCTL)- CRSCTL is a command-line tool that you can use to manage Oracle Clusterware. You can use CRSCTL to start and stop Oracle Clusterware and to determine the current status of your Oracle Clusterware installation.
6)Oracle Interface Configuration Tool (OIFCFG)- OIFCFG is a command-line tool which you can use to allocate and de-allocate network interfaces to components. You can use OIFCFG to direct components to use specific network interfaces and to retrieve component configuration information.
7)OCR Configuration Tool (OCRCONFIG)- OCRCONFIG is a command-line tool for OCR administration. You can also use the OCRCHECK and OCRDUMP utilities to troubleshoot configuration problems that affect the OCR.
Wednesday, July 2, 2008
Install Oracle Database 10g Software on Red Hat Linux
I already assume that you have installed Linux on your machine and now you want to install oracle software in linux box. Before installing oracle you have to perform several checkings. In the following section I have discussed one by one which may help you to install oracle on linux.
1)Check the OS bit:
---------------------------
Before installing oracle it is necessary which type of oracle software you will install. It is actually depend on OS. You have to check whether OS is 32 or 64 bit. Then you have to decide which version of oracle you will install. I have a fine post related to checking OS
Check OS 64 or 32 bit
2)Verify System Requirements:
---------------------------------------------
To install oracle on your system you should be at least 1GB RAM, 1GB swap space on your system. To find the available RAM and swap space on your system issue,
grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo
Besides RMAN and SWAP space you need to have space in your hard disk in a partition where oracle software will reside. Approximately you need 2.5GB space for oracle software, 1.2GB space for oracle database and 400MB space in /tmp directory.
You can check your space available on the hard disk by,
df -h
3)Configure the Linux Kernel Parameters
------------------------------------------------------------------
In order to effect changed linux kernel parameters no need to reboot. Linux support modification of most kernel parameters while the system is up and running.
To install oracle on linux several kernel parameters need to be set. You can see the current settings of these parameters by,
/sbin/sysctl -a | grep shm
/sbin/sysctl -a | grep sem
/sbin/sysctl -a | grep file-max
/sbin/sysctl -a | grep ip_local_port_range
/sbin/sysctl -a | grep rmem_default
/sbin/sysctl -a | grep rmem_max
/sbin/sysctl -a | grep wmem_default
/sbin/sysctl -a | grep wmem_max
You can see the kernel parameter permanently by Forcing the /etc/sysctl.conf settings to the Kernel at run-time.
Here is an example. This will immediately reflect the settings in /etc/sysctl.conf to the Kernel (/proc/sys).
cat >> /etc/sysctl.conf <<
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144
EOF
Copy and paste abouve code and then run,
debian:/home/Arju# /sbin/sysctl -p
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 262144
This procedure sets kernel parameter permanently, however you can set temporary by
debian:/home/Arju# cd /proc/sys/net/core
echo 1048576 > /proc/sys/net/core/rmem_default
echo 1048576> /proc/sys/net/core/rmem_max
echo 262144 > /proc/sys/net/core/wmem_default
echo 262144 > /proc/sys/net/core/wmem_max
4)Create the Oracle Groups and User Account
----------------------------------------------------------------
Log in as a root user and then create two groups oinstall and dba, create oracle user who owns the oracle software making initial group oinstall and secondary group dba.
$su
Password:
# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
# /usr/sbin/useradd -m -g oinstall -G dba oracle
# id oracle
uid=501(oracle) gid=502(oinstall) groups=502(oinstall),503(dba)
Set the password on the oracle user,
# passwd oracle
Changing password for user oracle.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.
5)Create Directory for Oracle software
----------------------------------------------------
Create directory as root and then change permission 755 and make owner to oracle user.
mkdir /u01/oracle
chown -R oracle:oinstall /u01/oracle
chmod -R 775 /u01/oracle
6)Set Shell Limits for the oracle User
-------------------------------------------------------------
It is sometime necessary to set limit of how much memory oracle user permit to use, how many files it can open, how many processes it can run. This is done by,
cat >> /etc/security/limits.conf <<> /etc/pam.d/login <<
7)Install Oracle
-------------------------------
Go to the location of the oracle cd or software.Change the directory install and run the runInstaller file as a oracle user. Like
$cd install
$./runInstaller
Go according to OUI as prompted and click next.
In the end run root.sh as root as OUI prompted.
1)Check the OS bit:
---------------------------
Before installing oracle it is necessary which type of oracle software you will install. It is actually depend on OS. You have to check whether OS is 32 or 64 bit. Then you have to decide which version of oracle you will install. I have a fine post related to checking OS
Check OS 64 or 32 bit
2)Verify System Requirements:
---------------------------------------------
To install oracle on your system you should be at least 1GB RAM, 1GB swap space on your system. To find the available RAM and swap space on your system issue,
grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo
Besides RMAN and SWAP space you need to have space in your hard disk in a partition where oracle software will reside. Approximately you need 2.5GB space for oracle software, 1.2GB space for oracle database and 400MB space in /tmp directory.
You can check your space available on the hard disk by,
df -h
3)Configure the Linux Kernel Parameters
------------------------------------------------------------------
In order to effect changed linux kernel parameters no need to reboot. Linux support modification of most kernel parameters while the system is up and running.
To install oracle on linux several kernel parameters need to be set. You can see the current settings of these parameters by,
/sbin/sysctl -a | grep shm
/sbin/sysctl -a | grep sem
/sbin/sysctl -a | grep file-max
/sbin/sysctl -a | grep ip_local_port_range
/sbin/sysctl -a | grep rmem_default
/sbin/sysctl -a | grep rmem_max
/sbin/sysctl -a | grep wmem_default
/sbin/sysctl -a | grep wmem_max
You can see the kernel parameter permanently by Forcing the /etc/sysctl.conf settings to the Kernel at run-time.
Here is an example. This will immediately reflect the settings in /etc/sysctl.conf to the Kernel (/proc/sys).
cat >> /etc/sysctl.conf <<
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144
EOF
Copy and paste abouve code and then run,
debian:/home/Arju# /sbin/sysctl -p
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 262144
This procedure sets kernel parameter permanently, however you can set temporary by
debian:/home/Arju# cd /proc/sys/net/core
echo 1048576 > /proc/sys/net/core/rmem_default
echo 1048576> /proc/sys/net/core/rmem_max
echo 262144 > /proc/sys/net/core/wmem_default
echo 262144 > /proc/sys/net/core/wmem_max
4)Create the Oracle Groups and User Account
----------------------------------------------------------------
Log in as a root user and then create two groups oinstall and dba, create oracle user who owns the oracle software making initial group oinstall and secondary group dba.
$su
Password:
# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
# /usr/sbin/useradd -m -g oinstall -G dba oracle
# id oracle
uid=501(oracle) gid=502(oinstall) groups=502(oinstall),503(dba)
Set the password on the oracle user,
# passwd oracle
Changing password for user oracle.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.
5)Create Directory for Oracle software
----------------------------------------------------
Create directory as root and then change permission 755 and make owner to oracle user.
mkdir /u01/oracle
chown -R oracle:oinstall /u01/oracle
chmod -R 775 /u01/oracle
6)Set Shell Limits for the oracle User
-------------------------------------------------------------
It is sometime necessary to set limit of how much memory oracle user permit to use, how many files it can open, how many processes it can run. This is done by,
cat >> /etc/security/limits.conf <<
7)Install Oracle
-------------------------------
Go to the location of the oracle cd or software.Change the directory install and run the runInstaller file as a oracle user. Like
$cd install
$./runInstaller
Go according to OUI as prompted and click next.
In the end run root.sh as root as OUI prompted.
Tuesday, May 27, 2008
Required users and groups while installing oracle
In this topic I will describe about the users and groups that are needed to install oracle on linux or solaris machine.
Groups Needed
-----------------------------------------------
Mandatory Group- The OSDBA Group(dba): You must create this group the first time you install Oracle Database software on the system. It identifies operating system user accounts that have database administrative privileges (the SYSDBA privilege). We later can enter as sysdba if current user is a group of OSDBA. The default name for this group is dba.
Optional Group-The OSOPER group (oper): The users of this group have a limited set of database administrative privileges (the SYSOPER privilege). This is optional group.
To know more about SYSDBA and SYSOPER authenticated operations have a look at SYSDBA and SYSOPER Authenticated Operations.
Mandatory Group-The Oracle Inventory group (oinstall): This group owns the Oracle
inventory, which is a catalog of all Oracle software installed on the system. If Oracle software is already installed on the system, then the existing Oracle Inventory group must be the primary group of the operating system user that you use to install new Oracle software.
Users Needed:
--------------------------
An unprivileged user (nobody):Verify that the unprivileged user nobody exists on the system. The nobody user must own the external jobs (extjob) executable after the installation.
The Oracle software owner user (typically, oracle): You must create this user the first time you install Oracle software on the system.This user owns all of the software installed during the installation. This user must have the Oracle Inventory group as its primary group. It must also have the OSDBA and OSOPER groups as secondary groups.
Related Documents:
----------------------------
DBA Authentication
Groups Needed
-----------------------------------------------
Mandatory Group- The OSDBA Group(dba): You must create this group the first time you install Oracle Database software on the system. It identifies operating system user accounts that have database administrative privileges (the SYSDBA privilege). We later can enter as sysdba if current user is a group of OSDBA. The default name for this group is dba.
Optional Group-The OSOPER group (oper): The users of this group have a limited set of database administrative privileges (the SYSOPER privilege). This is optional group.
To know more about SYSDBA and SYSOPER authenticated operations have a look at SYSDBA and SYSOPER Authenticated Operations.
Mandatory Group-The Oracle Inventory group (oinstall): This group owns the Oracle
inventory, which is a catalog of all Oracle software installed on the system. If Oracle software is already installed on the system, then the existing Oracle Inventory group must be the primary group of the operating system user that you use to install new Oracle software.
Users Needed:
--------------------------
An unprivileged user (nobody):Verify that the unprivileged user nobody exists on the system. The nobody user must own the external jobs (extjob) executable after the installation.
The Oracle software owner user (typically, oracle): You must create this user the first time you install Oracle software on the system.This user owns all of the software installed during the installation. This user must have the Oracle Inventory group as its primary group. It must also have the OSDBA and OSOPER groups as secondary groups.
Related Documents:
----------------------------
DBA Authentication
Subscribe to:
Posts (Atom)