Oracle 8i/9i on Solaris 5.8 - OUI not running
Hi All,
Being quite new to UNIX I'm not sure where I'm going wrong, but I'm installing Oracle 8.1.7 Standard Edition onto a SUN box.
I have read through the PDF guide for install, and don't think that I have missed anything. I am running the OUI as follows (from the root directory, logged in as the oracle user):
/cdrom/oracle8i/runInstall
This brings the installer up, but it does nothing when I click on 'next', 'help' or 'exit'. The 'installed products' and 'about oui' buttons seem to work.
The only thing I can think of is that I haven't set the PATH, but I'm not sure how. can someone help please!
Many Thanks
Paul
Being quite new to UNIX I'm not sure where I'm going wrong, but I'm installing Oracle 8.1.7 Standard Edition onto a SUN box.
I have read through the PDF guide for install, and don't think that I have missed anything. I am running the OUI as follows (from the root directory, logged in as the oracle user):
/cdrom/oracle8i/runInstall
This brings the installer up, but it does nothing when I click on 'next', 'help' or 'exit'. The 'installed products' and 'about oui' buttons seem to work.
The only thing I can think of is that I haven't set the PATH, but I'm not sure how. can someone help please!
Many Thanks
Paul
ASKER
Thanks schwertner,
I have added the following variables to the Oracle users .profile file:
ORACLE_HOME=/usr/oracle/or
PATH=$ORACLE_HOME/bin,/usr
export PATH
DISPLAY=xx.xx.xx.xx:0.0
export DISPLAY
I still have the problem.
I have tried both 8.1.7 and 9.2 using different user acounts with the same settings, but get the same problem.
I am using official CDs, and have tried several different ones, to no avail.
Any other ideas?
PS. The documentation says that only the PATH and DISPLAY variables are required.
I have added the following variables to the Oracle users .profile file:
ORACLE_HOME=/usr/oracle/or
PATH=$ORACLE_HOME/bin,/usr
export PATH
DISPLAY=xx.xx.xx.xx:0.0
export DISPLAY
I still have the problem.
I have tried both 8.1.7 and 9.2 using different user acounts with the same settings, but get the same problem.
I am using official CDs, and have tried several different ones, to no avail.
Any other ideas?
PS. The documentation says that only the PATH and DISPLAY variables are required.
Where is
ORACLE_BASE?
Look how many steps are you missed:
This document is designed to be a quick reference that can be used when
installing Oracle9i Release 2 (9.2.0) on a Sun SPARC Solaris platform. It
is NOT designed to replace the Installation Guide or other documentation.
A familiarity with the Sun SPARC Solaris Operating System is assumed. If more
detailed information is needed, please see the Appendix at the bottom of this
document for additional resources.
Each step should be performed in the order that it is listed. These steps
are the bare minimum that is necessary for a typical install of the Oracle9i
RDBMS.
Verify OS version is certified with the RDBMS version:
==========================
The following steps are required to verify your version of the Solaris operating
system is certified with the version of the RDBMS (Oracle9i Release 2 (9.2.0)):
1. Point your web browser to http://metalink.oracle.com.
2. Click the "Certify & Availability" button near the left.
3. Click the "Certifications" button near the top middle.
4. Click the "View Certifications by Platform" link.
5. Select "Solaris Operating System (SPARC)" and click "Submit".
6. Select Product Group "Oracle Server" and click "Submit".
7. Select Product "Oracle Server - Enterprise Edition" and click "Submit".
8. Read any general notes at the top of the page.
9. Select "9.2 (9i) 64-bit" or "9.2 (9i)"(for 32bit Oracle) and click "Submit".
The "Status" column displays the certification status. The links in the
"Addt'l Info" and "Install Issue" columns may contain additional information
relevant to a given version. Note that if patches are listed under one of
these links, your installation is not considered certified unless you apply
them. The "Addt'l Info" link also contains information about available
patchsets. Installation of patchsets is not required to be considered
certified, but they are highly recommended.
Pre-Installation Steps for the System Administrator:
==========================
The following steps are required to verify your operating system meets minimum
requirements for installation, and should be performed by the root user. For
assistance with system administration issues, please contact your system
administator or operating system vendor.
Use these steps to manually check the operating system requirements before
attempting to install Oracle RDBMS software, or you may choose to use the
convenient "Unix InstallPrep script" which automates these checks for you. For
more information about the script, including download information, please
review the following article:
Note:189256.1 UNIX: Script to Verify Installation Requirements for
Oracle 9.x version of RDBMS
The Following Steps Need to be Performed by the Root User:
1. Configure System Resources:
Ensure that the system has at least the following resources:
? 400 MB in /tmp *
? 256 MB of Physical Memory (RAM)
? Three times the amount of Physical Memory for Swap space (unless the
system exceeds 1 GB of Physical Memory, where two times
the amount of Physical Memory for Swap space is sufficient)
* You may also redirect /tmp by setting the TEMP environment variable.
This is only recommended in rare circumstances where /tmp cannot be
expanded to meet free space requirements.
2. Create a Software Owner and Group:
Create a Unix user and group that will own the Oracle software
(user = oracle, group = dba)
? Use the "useradd" Solaris script or vi the /etc/password file and
add the user manually.
? Use the "groupadd" Solaris script or vi the /etc/group file and add
the group manually.
? This user must be local to the machine.
3. Create a Software Mount Point and DataFile Mount Points:
Create a mount point for the Oracle software installation (at least 2.5
GB, typically /u01)
Create a second, third and fourth mount point for the database files,
control files, and log files to be created (typically /u02, /u03, /u04).
? The oracle user should own these mount points and all of the
directories below the mount point.
4. Create the directory for the oratab file:
Create the directory /var/opt/oracle and ensure that the oracle user has
write permissions on this directory.
5. Test the Permissions:
Ensure that the oracle user can write to the new mount points
? As a test, change directories to each of the new mount point
directories as the oracle user and create a file or directory.
Example:
% touch /u01/test
6. Configure Kernel Resources:
Add the following kernel parameters to the /etc/system file:
set shmsys:shminfo_shmmax=4294
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmseg=10
set shmsys:shminfo_shmmni=100
set semsys:seminfo_semmns=1000
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=250
7. Reboot System:
After modifications are made to the /etc/system file, you must reboot the
system for the new kernel parameters to take affect.
8. Mount CD-ROM:
Mount the Oracle 9.2.0 CD-ROM. Typically, the CD-ROM will automount when
placing it into the Solaris CD-ROM drive.
INSTALLATION STEPS
==================
The Following Steps Need to be Performed by the Oracle User:
1. Set Environment Variables
Environment variables should be set in the login script for the oracle
user. If the oracle user's default shell is the C-shell (/usr/bin/csh),
then the login script will be named ".login". If the oracle user's
default shell is the Bourne-shell (/usr/bin/bsh) or the Korn-shell
(/usr/bin/sh or /usr/bin/ksh), then the login script will be named
".profile". In either case, the login script will be located in the
oracle user's home directory ($HOME).
The examples below assume that your software mount point is /u01.
Parameter Value
----------- ------
ORACLE_HOME /u01/app/oracle/product/9.
ORACLE_BASE /u01/app/oracle
PATH /u01/app/oracle/product/9.
/usr/ccs/bin:/usr/openwin/
and whatever else you want to have set
follows these three items in the PATH
ORACLE_SID Set this to what you will call your
database instance.
(Typically 4 characters in length)
DISPLAY <ip-address>:0.0
(review Note:153960.1 for detailed information)
ENSURE THAT CLASS_PATH IS NOT SET IN THE ENVIRONMENT
2. Set the umask:
Set the oracle user's umask to 022 in your .login or .profile file.
3. Verify the Environment:
Log-off and log-on as the Oracle user to ensure all environment settings
are present.
Type 'env' at the UNIX prompt to view all the environment variables.
Before attempting to run the Oracle Universal Installer, verify that you
can successfully run the following command:
% /usr/openwin/bin/xclock
If this does not display a clock on your display screen, please review the
following article:
Note:153960.1 FAQ: X Server testing and troubleshooting
4. Start the Oracle Universal Installer and install the RDBMS software:
Use the following commands to start the installer:
% cd /tmp
% /cdrom/runInstaller
Respond to the installer prompts as shown below:
? At the "Welcome Screen", click Next.
? If prompted, enter the directory to use for the "Inventory Location".
This can be any directory, but is usually not under ORACLE_HOME because
the oraInventory is shared with all Oracle products on the system.
? If prompted, enter the "UNIX Group Name" for the oracle user (dba).
? At the "File Locations Screen", verify the Destination listed is your
ORACLE_HOME directory. Also enter a NAME to identify this ORACLE_HOME.
The NAME can be anything, but is typically "DataServer" and the first
three digits of the version. For example: "DataServer920"
? At the "Available Products Screen", choose Oracle9i Database, then click
Next.
? At the "Installation Types Screen", choose Enterprise Edition, then
click Next.
? If prompted, click Next at the "Component Locations Screen" to accept
the default directories.
? At the "Database Configuration Screen", choose the the configuration
based on how you plan to use the database, then click Next.
? If prompted, click Next at the "Privileged Operating System Groups
Screen" to accept the default values (your current OS primary group).
? If prompted, enter the Global Database Name in the format
"ORACLE_SID.hostname" at the "Database Identification Screen".
For example: "TEST.AIXhost". The SID entry should be filled in with
the value of ORACLE_SID. Click Next.
? If prompted, enter the directory where you would like to put datafiles
at the "Database File Location Screen". Click Next.
? If prompted, select "Use the default character set" (WE8ISO8859P1) at
the "Database Character Set Screen". Click Next.
? At the "Summary Screen", review your choices, then click Install.
The install will begin. Follow instructions regarding running "root.sh"
and any other prompts. When completed, the install will have created a
default database, configured a Listener, and started both for you.
Note: If you are having problems changing CD-ROMs when prompted to do so,
please review the following article:
Note:146566.1 How to Unmount / Eject First Cdrom
Your Oracle9i Release 2 (9.2.0) RDBMS installation is now complete and ready
for use.
APPENDIX A
==========
Documentation is available from the following resources:
Oracle9i Release 2 (9.2.0) CD-ROM Disk1
--------------------------
Mount the CD-ROM, then use a web browser to open the file "index.htm" located
at the top level directory of the CD-ROM. On this CD-ROM you will find the
Installation Guide, Administrator's Reference, and other useful documentation.
Oracle Documentation Center
--------------------------
Point your web browser to the following URL:
http://otn.oracle.com/documentation/content.html
Select the highest version CD-pack displayed to ensure you get the most
up-to-date information.
.
SOLARIS: Quick Start Guide - 9.0.x RDBMS Installation
Note:148673.1
PURPOSE
=======
This document is designed to be a quick reference that can be used when
installing Oracle 9.0.x on the Sun SPARC Solaris platform. It is NOT designed
to take the place of the Installation Guide. Please refer to the 'Oracle9i
Quick Installation Procedure Release x (9.0.x) for Sun SPARC Solaris' and the
'Oracle9i Installation Guide Release x (9.0.x) for UNIX Systems', for additional
information on any of the steps listed below.
OVERVIEW
========
Quick and easy steps for installing Oracle 9.0.x on Sun SPARC Solaris.
Each step should be performed in the order that it is listed. These steps
are the bare minimum that is necessary for an installation of the 9i Enterprise
Edition RDBMS.
Verification of Version Certification:
==========================
Steps required to verify the version of Oracle is certified with the version
of the Operating System.
1. Enter http://metalink.oracle.com into a web brower
2. Click button labeled "Certify & Availability"
3. Click button labeled "Certifications"
4. Click link "View Certifications by Product"
5. Select "Oracle Server" ... Click Submit
6. Select "Oracle Server - Enterprise Edition" ... Click Submit
7. Select "Sun SPARC Solaris" ... Click Submit
8. Select the version of Oracle ... Click Submit
9. Check the column "Status" for Certification Status
10. Click link "Yes" in the column "Addtl. Info." for PatchSet information.
Pre-requisite Requirements for System Administrator:
==========================
For a successful installation of Oracle Rdbms software, make sure to
meet the requirements below. You can check them manually or use the
convenient "Unix InstallPrep script" to generate a report of configuration
steps that you need to perform prior the installation. Please refer to
[NOTE:189256.1] Unix InstallPrep script
For assistance with system administration issues please contact your system
administrator or operating system vendor.
Steps required as the Root User (login as root to perform each of the
following tasks):
1. Configure System Resources:
Ensure that the system has at least the following resources:
? 400 MB in /tmp *
? 256 MB of Physical Memory (RAM)
? Three times the amount of Physical Memory for Swap space (unless the
system exceeds 1 GB of Physical Memory, where two times
the amount of Physical Memory for Swap space is sufficient)
* You may also redirect /tmp by setting the TEMP environment variable.
This is only recommended in rare circumstances where /tmp cannot be
expanded to meet free space requirements.
2. Create a Software Owner and Group:
Create a Unix user and group that will own the Oracle software
(user = oracle, group = dba)
? Use the "useradd" Solaris script or vi the /etc/password file and
add the user manually.
? Use the "groupadd" Solaris script or vi the /etc/group file and add
the group manually.
? This user must be local to the machine.
3. Create a Software Mount Point and DataFile Mount Points:
Create a mount point for the Oracle software installation (at least 2.5
GB, typically /u01)
Create a second, third and fourth mount point for the database files,
control files, and log files to be created (typically /u02, /u03, /u04).
? The oracle user should own these mount points and all of the
directories below the mount point.
4. Create the directory for the oratab file:
Create the directory /var/opt/oracle and ensure that the oracle user has
write permissions on this directory.
5. Test the Permissions:
Ensure that the oracle user can write to the new mount points
? As a test, change directories to each of the new mount point
directories as the oracle user and create a file or directory.
Example:
% touch /u01/test
6. Configure Kernel Resources:
Add the following kernel parameters to the /etc/system file:
set shmsys:shminfo_shmmax=4294
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmseg=10
set shmsys:shminfo_shmmni=100
set semsys:seminfo_semmns=1000
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=250
7. Reboot System:
After modifications are made to the /etc/system file, you must reboot the
system for the new kernel parameters to take affect.
8. Mount CD-ROM:
Mount the Oracle 9.0.x CD-ROM. Typically, the CD-ROM will automount when
placing it into the Solaris CD-ROM drive.
INSTALLATION STEPS
==================
Steps required to be performed as the Oracle user.
1. Set up the environment variables:
Set the following environment variables in the .profile or .login file of
the oracle user (depending on the default shell for the oracle user), before
starting the Installer.
The values in the examples are assuming that your software mount point is
/u01 and you are installing 9.0.1.
Parameter Value
----------- ------
ORACLE_HOME /u01/app/oracle/product/9.
ORACLE_BASE /u01/app/oracle
PATH /u01/app/oracle/product/9.
/usr/ccs/bin:/usr/openwin/
and whatever else you want to have set
follows these three items in the PATH
ORACLE_SID Set this to what you will call your
database instance.
(Typically 4 characters in length)
DISPLAY <ip-address>:0.0
ENSURE THAT CLASS_PATH IS NOT SET IN THE ENVIRONMENT
2. Set the umask:
Set the oracle user's umask to 022 in your .login or .profile file.
3. Verify the Environment:
Log-off and log-on as the Oracle user to ensure all environment settings
are present.
Type 'env' at the Unix prompt to view all the environment variables.
Before attempting to run the Oracle Universal Installer, verify that you
can successfully run the following command:
% /usr/openwin/bin/xclock
4. Start the Oracle Universal Installer and Install the Oracle Software:
Change the current directory to /tmp and start the Installer.
Example:
% cd /tmp
% /cdrom/cdrom0/runInstaller
? Verify that the destination listed for file location is your
ORACLE_HOME.
NOTE: If this is the first installation of Oracle 9i on this machine,
you will be prompted to enter the location of the Oracle
Inventory. This will create the pointer file
/var/opt/oracle/oraInst.lo
directory location.
? Enter the primary group name of the oracle user.
? Select "Oracle 9i Database" on the Available Products screen.
? Select "Enterprise Edition" to install the software and a seeded
database. Note, other installation types are available.
? Choose the appropriate Database Configuration based on how you intend
to use the database.
? Click only the 'Next' button when prompted to upgrade or migrate an
existing database.
? Enter the Global Database Name and SID for the database being created.
? Verify the database file locations.
? Select the database character set.
? At the Summary screen, verify the space requirements and the products
being installed, then click 'Install'.
? The installation will begin.
? Follow the instructions regarding root.sh and other prompts.
Note: A complete 9i installation will require all 3 cd's and the install will
prompt for them accordingly.
You may run into the following problems:
- "Device busy" messages when attempting to unmount/eject
the the first or second cdrom of the product set. This is because
the current working directory of the session that started the installer
is the cdrom mount point.
To overcome this problem:
. Return to the session/window where the installer was launched.
. Press the Return key once or twice to get the unix prompt.
. Change directory to a location other than the cdrom mount point,
for example 'cd /tmp'.
. You should now be able to 'umount' or 'eject' the cd-rom.
- After ejecting the first cdrom, mounting the second, and selecting
'OK' in the dialog box, the dialog box displays again as if the cdrom
was not changed. This happens because when the cdrom is automounted,
the mount point contains the volume label of the cdrom. For example,
when cdrom #1 is mounted, the mount point may be /cdrom/oracle9i#1.
When cdrom #2 is mounted, the mount point may change to
/cdrom/oracle9i#2. In this situation it will be necessary to change
the cdrom "path" when prompted by the installer.
To workaround this problem:
. Use the 'mount' command without any options to display currently
mounted filesystems.
. Check the first column of the output of the mount command and
locate the cdrom mount point.
. Use this information to correct the "path" specified in the dialog
box.
. Select OK and the install will proceed.
APPENDIX A
==========
Documentation is available from the following resources:
? You can find the "Oracle9i Installation Guide Release x (9.0.x) for
UNIX Systems" and the "Oracle9i Quick Installation Procedure Release x
(9.0.x) for Sun SPARC Solaris" on:
1. The Oracle 9i Server cdrom (CDROM #1).
The installation guides can be accessed from:
/<cdrom_mount_point>/doc/u
2. The Oracle Documentation Center - http://otn.oracle.com/documentation/content.html
? You can find the "Release Notes" on:
1. The Oracle 9i Server cdrom.
The Release Notes can be accessed from:
/<cdrom_mount_point>/doc/r
2. The Oracle Documentation Center - http://otn.oracle.com/documentation/content.html
.
ORACLE_BASE?
Look how many steps are you missed:
This document is designed to be a quick reference that can be used when
installing Oracle9i Release 2 (9.2.0) on a Sun SPARC Solaris platform. It
is NOT designed to replace the Installation Guide or other documentation.
A familiarity with the Sun SPARC Solaris Operating System is assumed. If more
detailed information is needed, please see the Appendix at the bottom of this
document for additional resources.
Each step should be performed in the order that it is listed. These steps
are the bare minimum that is necessary for a typical install of the Oracle9i
RDBMS.
Verify OS version is certified with the RDBMS version:
==========================
The following steps are required to verify your version of the Solaris operating
system is certified with the version of the RDBMS (Oracle9i Release 2 (9.2.0)):
1. Point your web browser to http://metalink.oracle.com.
2. Click the "Certify & Availability" button near the left.
3. Click the "Certifications" button near the top middle.
4. Click the "View Certifications by Platform" link.
5. Select "Solaris Operating System (SPARC)" and click "Submit".
6. Select Product Group "Oracle Server" and click "Submit".
7. Select Product "Oracle Server - Enterprise Edition" and click "Submit".
8. Read any general notes at the top of the page.
9. Select "9.2 (9i) 64-bit" or "9.2 (9i)"(for 32bit Oracle) and click "Submit".
The "Status" column displays the certification status. The links in the
"Addt'l Info" and "Install Issue" columns may contain additional information
relevant to a given version. Note that if patches are listed under one of
these links, your installation is not considered certified unless you apply
them. The "Addt'l Info" link also contains information about available
patchsets. Installation of patchsets is not required to be considered
certified, but they are highly recommended.
Pre-Installation Steps for the System Administrator:
==========================
The following steps are required to verify your operating system meets minimum
requirements for installation, and should be performed by the root user. For
assistance with system administration issues, please contact your system
administator or operating system vendor.
Use these steps to manually check the operating system requirements before
attempting to install Oracle RDBMS software, or you may choose to use the
convenient "Unix InstallPrep script" which automates these checks for you. For
more information about the script, including download information, please
review the following article:
Note:189256.1 UNIX: Script to Verify Installation Requirements for
Oracle 9.x version of RDBMS
The Following Steps Need to be Performed by the Root User:
1. Configure System Resources:
Ensure that the system has at least the following resources:
? 400 MB in /tmp *
? 256 MB of Physical Memory (RAM)
? Three times the amount of Physical Memory for Swap space (unless the
system exceeds 1 GB of Physical Memory, where two times
the amount of Physical Memory for Swap space is sufficient)
* You may also redirect /tmp by setting the TEMP environment variable.
This is only recommended in rare circumstances where /tmp cannot be
expanded to meet free space requirements.
2. Create a Software Owner and Group:
Create a Unix user and group that will own the Oracle software
(user = oracle, group = dba)
? Use the "useradd" Solaris script or vi the /etc/password file and
add the user manually.
? Use the "groupadd" Solaris script or vi the /etc/group file and add
the group manually.
? This user must be local to the machine.
3. Create a Software Mount Point and DataFile Mount Points:
Create a mount point for the Oracle software installation (at least 2.5
GB, typically /u01)
Create a second, third and fourth mount point for the database files,
control files, and log files to be created (typically /u02, /u03, /u04).
? The oracle user should own these mount points and all of the
directories below the mount point.
4. Create the directory for the oratab file:
Create the directory /var/opt/oracle and ensure that the oracle user has
write permissions on this directory.
5. Test the Permissions:
Ensure that the oracle user can write to the new mount points
? As a test, change directories to each of the new mount point
directories as the oracle user and create a file or directory.
Example:
% touch /u01/test
6. Configure Kernel Resources:
Add the following kernel parameters to the /etc/system file:
set shmsys:shminfo_shmmax=4294
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmseg=10
set shmsys:shminfo_shmmni=100
set semsys:seminfo_semmns=1000
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=250
7. Reboot System:
After modifications are made to the /etc/system file, you must reboot the
system for the new kernel parameters to take affect.
8. Mount CD-ROM:
Mount the Oracle 9.2.0 CD-ROM. Typically, the CD-ROM will automount when
placing it into the Solaris CD-ROM drive.
INSTALLATION STEPS
==================
The Following Steps Need to be Performed by the Oracle User:
1. Set Environment Variables
Environment variables should be set in the login script for the oracle
user. If the oracle user's default shell is the C-shell (/usr/bin/csh),
then the login script will be named ".login". If the oracle user's
default shell is the Bourne-shell (/usr/bin/bsh) or the Korn-shell
(/usr/bin/sh or /usr/bin/ksh), then the login script will be named
".profile". In either case, the login script will be located in the
oracle user's home directory ($HOME).
The examples below assume that your software mount point is /u01.
Parameter Value
----------- ------
ORACLE_HOME /u01/app/oracle/product/9.
ORACLE_BASE /u01/app/oracle
PATH /u01/app/oracle/product/9.
/usr/ccs/bin:/usr/openwin/
and whatever else you want to have set
follows these three items in the PATH
ORACLE_SID Set this to what you will call your
database instance.
(Typically 4 characters in length)
DISPLAY <ip-address>:0.0
(review Note:153960.1 for detailed information)
ENSURE THAT CLASS_PATH IS NOT SET IN THE ENVIRONMENT
2. Set the umask:
Set the oracle user's umask to 022 in your .login or .profile file.
3. Verify the Environment:
Log-off and log-on as the Oracle user to ensure all environment settings
are present.
Type 'env' at the UNIX prompt to view all the environment variables.
Before attempting to run the Oracle Universal Installer, verify that you
can successfully run the following command:
% /usr/openwin/bin/xclock
If this does not display a clock on your display screen, please review the
following article:
Note:153960.1 FAQ: X Server testing and troubleshooting
4. Start the Oracle Universal Installer and install the RDBMS software:
Use the following commands to start the installer:
% cd /tmp
% /cdrom/runInstaller
Respond to the installer prompts as shown below:
? At the "Welcome Screen", click Next.
? If prompted, enter the directory to use for the "Inventory Location".
This can be any directory, but is usually not under ORACLE_HOME because
the oraInventory is shared with all Oracle products on the system.
? If prompted, enter the "UNIX Group Name" for the oracle user (dba).
? At the "File Locations Screen", verify the Destination listed is your
ORACLE_HOME directory. Also enter a NAME to identify this ORACLE_HOME.
The NAME can be anything, but is typically "DataServer" and the first
three digits of the version. For example: "DataServer920"
? At the "Available Products Screen", choose Oracle9i Database, then click
Next.
? At the "Installation Types Screen", choose Enterprise Edition, then
click Next.
? If prompted, click Next at the "Component Locations Screen" to accept
the default directories.
? At the "Database Configuration Screen", choose the the configuration
based on how you plan to use the database, then click Next.
? If prompted, click Next at the "Privileged Operating System Groups
Screen" to accept the default values (your current OS primary group).
? If prompted, enter the Global Database Name in the format
"ORACLE_SID.hostname" at the "Database Identification Screen".
For example: "TEST.AIXhost". The SID entry should be filled in with
the value of ORACLE_SID. Click Next.
? If prompted, enter the directory where you would like to put datafiles
at the "Database File Location Screen". Click Next.
? If prompted, select "Use the default character set" (WE8ISO8859P1) at
the "Database Character Set Screen". Click Next.
? At the "Summary Screen", review your choices, then click Install.
The install will begin. Follow instructions regarding running "root.sh"
and any other prompts. When completed, the install will have created a
default database, configured a Listener, and started both for you.
Note: If you are having problems changing CD-ROMs when prompted to do so,
please review the following article:
Note:146566.1 How to Unmount / Eject First Cdrom
Your Oracle9i Release 2 (9.2.0) RDBMS installation is now complete and ready
for use.
APPENDIX A
==========
Documentation is available from the following resources:
Oracle9i Release 2 (9.2.0) CD-ROM Disk1
--------------------------
Mount the CD-ROM, then use a web browser to open the file "index.htm" located
at the top level directory of the CD-ROM. On this CD-ROM you will find the
Installation Guide, Administrator's Reference, and other useful documentation.
Oracle Documentation Center
--------------------------
Point your web browser to the following URL:
http://otn.oracle.com/documentation/content.html
Select the highest version CD-pack displayed to ensure you get the most
up-to-date information.
.
SOLARIS: Quick Start Guide - 9.0.x RDBMS Installation
Note:148673.1
PURPOSE
=======
This document is designed to be a quick reference that can be used when
installing Oracle 9.0.x on the Sun SPARC Solaris platform. It is NOT designed
to take the place of the Installation Guide. Please refer to the 'Oracle9i
Quick Installation Procedure Release x (9.0.x) for Sun SPARC Solaris' and the
'Oracle9i Installation Guide Release x (9.0.x) for UNIX Systems', for additional
information on any of the steps listed below.
OVERVIEW
========
Quick and easy steps for installing Oracle 9.0.x on Sun SPARC Solaris.
Each step should be performed in the order that it is listed. These steps
are the bare minimum that is necessary for an installation of the 9i Enterprise
Edition RDBMS.
Verification of Version Certification:
==========================
Steps required to verify the version of Oracle is certified with the version
of the Operating System.
1. Enter http://metalink.oracle.com into a web brower
2. Click button labeled "Certify & Availability"
3. Click button labeled "Certifications"
4. Click link "View Certifications by Product"
5. Select "Oracle Server" ... Click Submit
6. Select "Oracle Server - Enterprise Edition" ... Click Submit
7. Select "Sun SPARC Solaris" ... Click Submit
8. Select the version of Oracle ... Click Submit
9. Check the column "Status" for Certification Status
10. Click link "Yes" in the column "Addtl. Info." for PatchSet information.
Pre-requisite Requirements for System Administrator:
==========================
For a successful installation of Oracle Rdbms software, make sure to
meet the requirements below. You can check them manually or use the
convenient "Unix InstallPrep script" to generate a report of configuration
steps that you need to perform prior the installation. Please refer to
[NOTE:189256.1] Unix InstallPrep script
For assistance with system administration issues please contact your system
administrator or operating system vendor.
Steps required as the Root User (login as root to perform each of the
following tasks):
1. Configure System Resources:
Ensure that the system has at least the following resources:
? 400 MB in /tmp *
? 256 MB of Physical Memory (RAM)
? Three times the amount of Physical Memory for Swap space (unless the
system exceeds 1 GB of Physical Memory, where two times
the amount of Physical Memory for Swap space is sufficient)
* You may also redirect /tmp by setting the TEMP environment variable.
This is only recommended in rare circumstances where /tmp cannot be
expanded to meet free space requirements.
2. Create a Software Owner and Group:
Create a Unix user and group that will own the Oracle software
(user = oracle, group = dba)
? Use the "useradd" Solaris script or vi the /etc/password file and
add the user manually.
? Use the "groupadd" Solaris script or vi the /etc/group file and add
the group manually.
? This user must be local to the machine.
3. Create a Software Mount Point and DataFile Mount Points:
Create a mount point for the Oracle software installation (at least 2.5
GB, typically /u01)
Create a second, third and fourth mount point for the database files,
control files, and log files to be created (typically /u02, /u03, /u04).
? The oracle user should own these mount points and all of the
directories below the mount point.
4. Create the directory for the oratab file:
Create the directory /var/opt/oracle and ensure that the oracle user has
write permissions on this directory.
5. Test the Permissions:
Ensure that the oracle user can write to the new mount points
? As a test, change directories to each of the new mount point
directories as the oracle user and create a file or directory.
Example:
% touch /u01/test
6. Configure Kernel Resources:
Add the following kernel parameters to the /etc/system file:
set shmsys:shminfo_shmmax=4294
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmseg=10
set shmsys:shminfo_shmmni=100
set semsys:seminfo_semmns=1000
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=250
7. Reboot System:
After modifications are made to the /etc/system file, you must reboot the
system for the new kernel parameters to take affect.
8. Mount CD-ROM:
Mount the Oracle 9.0.x CD-ROM. Typically, the CD-ROM will automount when
placing it into the Solaris CD-ROM drive.
INSTALLATION STEPS
==================
Steps required to be performed as the Oracle user.
1. Set up the environment variables:
Set the following environment variables in the .profile or .login file of
the oracle user (depending on the default shell for the oracle user), before
starting the Installer.
The values in the examples are assuming that your software mount point is
/u01 and you are installing 9.0.1.
Parameter Value
----------- ------
ORACLE_HOME /u01/app/oracle/product/9.
ORACLE_BASE /u01/app/oracle
PATH /u01/app/oracle/product/9.
/usr/ccs/bin:/usr/openwin/
and whatever else you want to have set
follows these three items in the PATH
ORACLE_SID Set this to what you will call your
database instance.
(Typically 4 characters in length)
DISPLAY <ip-address>:0.0
ENSURE THAT CLASS_PATH IS NOT SET IN THE ENVIRONMENT
2. Set the umask:
Set the oracle user's umask to 022 in your .login or .profile file.
3. Verify the Environment:
Log-off and log-on as the Oracle user to ensure all environment settings
are present.
Type 'env' at the Unix prompt to view all the environment variables.
Before attempting to run the Oracle Universal Installer, verify that you
can successfully run the following command:
% /usr/openwin/bin/xclock
4. Start the Oracle Universal Installer and Install the Oracle Software:
Change the current directory to /tmp and start the Installer.
Example:
% cd /tmp
% /cdrom/cdrom0/runInstaller
? Verify that the destination listed for file location is your
ORACLE_HOME.
NOTE: If this is the first installation of Oracle 9i on this machine,
you will be prompted to enter the location of the Oracle
Inventory. This will create the pointer file
/var/opt/oracle/oraInst.lo
directory location.
? Enter the primary group name of the oracle user.
? Select "Oracle 9i Database" on the Available Products screen.
? Select "Enterprise Edition" to install the software and a seeded
database. Note, other installation types are available.
? Choose the appropriate Database Configuration based on how you intend
to use the database.
? Click only the 'Next' button when prompted to upgrade or migrate an
existing database.
? Enter the Global Database Name and SID for the database being created.
? Verify the database file locations.
? Select the database character set.
? At the Summary screen, verify the space requirements and the products
being installed, then click 'Install'.
? The installation will begin.
? Follow the instructions regarding root.sh and other prompts.
Note: A complete 9i installation will require all 3 cd's and the install will
prompt for them accordingly.
You may run into the following problems:
- "Device busy" messages when attempting to unmount/eject
the the first or second cdrom of the product set. This is because
the current working directory of the session that started the installer
is the cdrom mount point.
To overcome this problem:
. Return to the session/window where the installer was launched.
. Press the Return key once or twice to get the unix prompt.
. Change directory to a location other than the cdrom mount point,
for example 'cd /tmp'.
. You should now be able to 'umount' or 'eject' the cd-rom.
- After ejecting the first cdrom, mounting the second, and selecting
'OK' in the dialog box, the dialog box displays again as if the cdrom
was not changed. This happens because when the cdrom is automounted,
the mount point contains the volume label of the cdrom. For example,
when cdrom #1 is mounted, the mount point may be /cdrom/oracle9i#1.
When cdrom #2 is mounted, the mount point may change to
/cdrom/oracle9i#2. In this situation it will be necessary to change
the cdrom "path" when prompted by the installer.
To workaround this problem:
. Use the 'mount' command without any options to display currently
mounted filesystems.
. Check the first column of the output of the mount command and
locate the cdrom mount point.
. Use this information to correct the "path" specified in the dialog
box.
. Select OK and the install will proceed.
APPENDIX A
==========
Documentation is available from the following resources:
? You can find the "Oracle9i Installation Guide Release x (9.0.x) for
UNIX Systems" and the "Oracle9i Quick Installation Procedure Release x
(9.0.x) for Sun SPARC Solaris" on:
1. The Oracle 9i Server cdrom (CDROM #1).
The installation guides can be accessed from:
/<cdrom_mount_point>/doc/u
2. The Oracle Documentation Center - http://otn.oracle.com/documentation/content.html
? You can find the "Release Notes" on:
1. The Oracle 9i Server cdrom.
The Release Notes can be accessed from:
/<cdrom_mount_point>/doc/r
2. The Oracle Documentation Center - http://otn.oracle.com/documentation/content.html
.
PATH is set wrong in your posting.
Set it so:
PATH=/u01/app/oracle/produ
SID=?
Kernel parameters?
The most important is the swap partition - 3 times the RAM or at least 2GB ....
Set it so:
PATH=/u01/app/oracle/produ
SID=?
Kernel parameters?
The most important is the swap partition - 3 times the RAM or at least 2GB ....
ASKER
Thanks again schwertner.
I have now set the ORACLE_BASE parameter, but this has made no difference.
In reference to all other settings. I have already gone through the whole of this document and Kernel parameters are set fine. Oracle was previously installed on this box, so it should be no different.
Can you tell me if 'mkdir /mnt/u01' is ok for creating the mount point, or do I need any other command?
As far as I can tell, PATH was set to /usr/oracle/ora92 previously. Can you tell me how to set it to the one you have mantioned, but still install the software to /usr/oracle/ora92
Also, I have typed umask at the prompt and get 0022, which I think is correct. Where or how would I set it in the .profile file?
Many Thanks
Paul
I have now set the ORACLE_BASE parameter, but this has made no difference.
In reference to all other settings. I have already gone through the whole of this document and Kernel parameters are set fine. Oracle was previously installed on this box, so it should be no different.
Can you tell me if 'mkdir /mnt/u01' is ok for creating the mount point, or do I need any other command?
As far as I can tell, PATH was set to /usr/oracle/ora92 previously. Can you tell me how to set it to the one you have mantioned, but still install the software to /usr/oracle/ora92
Also, I have typed umask at the prompt and get 0022, which I think is correct. Where or how would I set it in the .profile file?
Many Thanks
Paul
Path has to point ORACLE_HOME/bin That is! No choice.
Umask is correct 022.
What about the access rights?
chown oracle /mnt/u01 +R
Umask is correct 022.
What about the access rights?
chown oracle /mnt/u01 +R
ASKER
I have changed the owner to the oracle user, but now I need to know whether I should change the ORACLE_HOME variable to
/u01/app/ etc........
or whether to change
PATH=$ORACLE_HOME/bin to /u01/app/ etc........
Also, I@m really unsure about the whole u01 thing as the 2 previous installations of Oracle do not appear to have had them??
Can I just confirm, I have the oracle users home directory set to /usr/oracle/ora92, so is this not where the software is to be installed?
/u01/app/ etc........
or whether to change
PATH=$ORACLE_HOME/bin to /u01/app/ etc........
Also, I@m really unsure about the whole u01 thing as the 2 previous installations of Oracle do not appear to have had them??
Can I just confirm, I have the oracle users home directory set to /usr/oracle/ora92, so is this not where the software is to be installed?
You can choose every directory for Oracle Home. The best approach is to create a separate one like /u01/.... but this is not mandatory. After creating or chhosing the directory you have to give owner rights over it to the 'oracle' user.
Path MUST include the directory $ORACLE_HOME/bin because there are located the main Oracle executables.
But what you choose is also correct and possible. But dangerous.
I guess ORACLE_HOME should be in this case /usr/oracle/ora92/app/orac
I installed Oracle on SUN using the standart /u01/app/oracle/product/9.
and it works.
this is the clean option.
Path MUST include the directory $ORACLE_HOME/bin because there are located the main Oracle executables.
But what you choose is also correct and possible. But dangerous.
I guess ORACLE_HOME should be in this case /usr/oracle/ora92/app/orac
I installed Oracle on SUN using the standart /u01/app/oracle/product/9.
and it works.
this is the clean option.
ASKER
Ok, this is what I now have.
The oracle users home directory is:
/usr/oracle/ora92
and it is owned by the oracle user.
In the oracle users home directory, I have added the following to the .profile file
ORACLE_HOME=/usr/oracle/or
ORACLE_BASE=/usr/oracle/
PATH=$ORACLE_HOME/bin:/usr
export PATH
DISPLAY=xx.xx.xx.xx:0.0
export DISPLAY
Unfortunately, it still does not seem to be responding when I click on the buttons. Might this have something to do with JAVA?
The oracle users home directory is:
/usr/oracle/ora92
and it is owned by the oracle user.
In the oracle users home directory, I have added the following to the .profile file
ORACLE_HOME=/usr/oracle/or
ORACLE_BASE=/usr/oracle/
PATH=$ORACLE_HOME/bin:/usr
export PATH
DISPLAY=xx.xx.xx.xx:0.0
export DISPLAY
Unfortunately, it still does not seem to be responding when I click on the buttons. Might this have something to do with JAVA?
ORACLE_HOME = /usr/oracle/ora92/app/orac
ORACLE_BASE=/usr/oracle/or
What happens if you try to run xclock?
Do you see the clock?
Do you work in Graphic mode, using some GUI?
You have to start the OUI from a graphic environment.
ORACLE_BASE=/usr/oracle/or
What happens if you try to run xclock?
Do you see the clock?
Do you work in Graphic mode, using some GUI?
You have to start the OUI from a graphic environment.
ASKER
Ok, I have found the following file:
/usr/oracle/oraInventory/l
It contains the following:
----------------------
Environment variables:
ORACLE_HOME =
PATH= /usr/bin:/usr/ccs/bin:/usr
CLASSPATH =
Username is: oracle9
Unable to read the list of homes from the inventory.
The installer version is 2.2.0.12.0
***Welcome Page***
Warning :*** Alert: Do you really want to exit? ***
User selected: Yes/OK
---------------------
The file I edited with the ORACLE_HOME=, PATH= is the .profile file in the oracle9 users home directory (/usr/oracle/ora92). The path within that file is certainly not that long.
Any ideas?
/usr/oracle/oraInventory/l
It contains the following:
----------------------
Environment variables:
ORACLE_HOME =
PATH= /usr/bin:/usr/ccs/bin:/usr
CLASSPATH =
Username is: oracle9
Unable to read the list of homes from the inventory.
The installer version is 2.2.0.12.0
***Welcome Page***
Warning :*** Alert: Do you really want to exit? ***
User selected: Yes/OK
---------------------
The file I edited with the ORACLE_HOME=, PATH= is the .profile file in the oracle9 users home directory (/usr/oracle/ora92). The path within that file is certainly not that long.
Any ideas?
ASKER
I'm using Cygwin/X, and working with the Solaris CDE. The clock shows fine.
You have a bad setting of ORACLE_HOME
Your PATH is wrong!
1. Log as Oracle user
2. Run
env
To see the current set and values of all needed environment variables
Create the directory /var/opt/oracle and ensure that the oracle user has
write permissions on this directory.
Your PATH is wrong!
1. Log as Oracle user
2. Run
env
To see the current set and values of all needed environment variables
Create the directory /var/opt/oracle and ensure that the oracle user has
write permissions on this directory.
ASKER
Ok, my env PATH, is the same as the one in the log file?!?!?!
Have I changed the wrong file, with the PATH variable
I assume I must have because the ORACLE_HOME = is blank in the log file aswell! I have added these variables to both the .profile and .dtprofile files in the oracle users home directory.
What is the /var/opt/oracle directory for?
Have I changed the wrong file, with the PATH variable
I assume I must have because the ORACLE_HOME = is blank in the log file aswell! I have added these variables to both the .profile and .dtprofile files in the oracle users home directory.
What is the /var/opt/oracle directory for?
It is mentioned in the step-by-step installation doc I send you.
You have to follow these steps very careful.
You have to follow these steps very careful.
Also do your Sun is 64 bits or 32 bits? The Oracle installation kit is different for every processor type.
ASKER
32 bit.
So why is the settings I have in my .profile file not showing when I type 'env'?
So why is the settings I have in my .profile file not showing when I type 'env'?
That's the question! I my only installation on SUN we also do not succeed from first attempt to set them.
Look in the Solaris documentation how to do this weird task. I will try to find also some info.
Look in the Solaris documentation how to do this weird task. I will try to find also some info.
ASKER
Thanks schwertner
I have gone through this with a fine tooth comb.
I have also added 'export ORACLE_HOME' and 'export ORACLE_BASE' to both the .profile and .dtprofile and when I type in 'env' it now shows these variables in the list.
The path looks ok, as I assume it converts the $ORACLE_HOME/bin to /usr/oracle/ora92/software
This is very frustrating!
Do you have any other ideas?
I really appreciate your help so far
I have gone through this with a fine tooth comb.
I have also added 'export ORACLE_HOME' and 'export ORACLE_BASE' to both the .profile and .dtprofile and when I type in 'env' it now shows these variables in the list.
The path looks ok, as I assume it converts the $ORACLE_HOME/bin to /usr/oracle/ora92/software
This is very frustrating!
Do you have any other ideas?
I really appreciate your help so far
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I know that this case is closed, but I have recently encountered this and the solution is to turn off the NUM LOCK key. It is as simple as that, as frustrating as it could be.
Let me know if this helps you.
my email address is rolutola@talk21.com
Let me know if this helps you.
my email address is rolutola@talk21.com
ORACLE_HOME
ORACLE_BASE
PATH
etc.?
Try also to store the CD ROM on the hard disk.
If you have downloaded it from OTN a transmission error is also possible.
Why you do not install 9i?