Steves Know Solaris Oracle 8.1.7 Installation

Installation of Oracle 8.1.7.0.0 on Sun Solaris

Prerequisite Check
Get The Oracle Software
Installation Preparation
Installing Oracle Software
Oracle Configuration and Usage for WAS/WEA
Installing WAS With Oracle Installation Instructions
Installing Oracle Database Application User Client
Installing Oracle Database Administrator Client
Installing Filesets Manually
Manual Setup Procedure
Creating And Using An Oracle Database
Miscellaneous Oracle Utilities and Commands
Other Oracle Installation Information
Installation of Windows Oracle Client
Oracle Automatic Install Script
Oracle Administrator Profile (.profile)
Installing Java 1.1.8 Manually
Error Conditions

Prerequisite Check

1) Assure you have enough memory (To confirm amount of memory on your box "prtconf" will display it).

2) Assure your patches are at least 05/06/02 or later.

Get The Oracle Software

These instructions assume you are installing the 32 bit version of Oracle.

The software can be installed from the WEA Test Dept "/WEA/inst.images" mounted disk, from CDs, downloaded from Oracle's web site, as well as resides on several internal IBM servers which can be mounted for your use.

From /WEA/inst.images

The software currently resides on the network mounted drive directory "/WEA/inst.images/Oracle/oracle.817.sun" as 2 disks, "Disk1" and "Disk2". (which is normally already mounted in the WEA Test Dept NIM images).

(OR)

Installing Oracle From CD's

1) Install the Oracle CD1 in the CD drive and then mount the CD (i.e. "mkdir /mntOracle && mount -o ro -v cdrfs /dev/cd0 /mntOracle"). Note, IT IS IMPORTANT that if you use this method you execute the installer from the root directory (i.e. "/mntOracle/runInstaller"), otherwise, when you are instructed to change disks, and you have executed a program that is still running from that disk, you will not be able to unmount the CD 1 to insert CD 2..

(OR)

Download Oracle From Oracle Site

1) Create and change to a directory to perform your installation from (i.e. /tmp/installOracle").

2) Connect to "www.oracle.com" (or "http://otn.oracle.com/software/products/oracle8i/content.html").

3) Create an account, then logon as the created account (the authore used "shayden@ipass.net" with the appropriate password), and then download the 8.1.7.0.0 version of Oracle to the directory you created in step 1. It is actually 2 files, "Solaris_64_81700_Disk1.cpio.gz" and "Solaris_64_81700_Disk2.cpio.gz".

4) Once you unzip the files with "gunzip", then use "cpio" to create the appropriate directories. The commands to perform this follow:

gunzip Solaris_64_81700_Disk1.cpio.gz
gunzip Solaris_64_81700_Disk2.cpio.gz

cpio -idmv < Solaris_64_81700_Disk1.cpio
cpio -idmv < Solaris_64_81700_Disk2.cpio

(OR)

Get the Software From one of the IBM Internal Sites

Mount From wessun450

1) Create a directory "/mntOracle" to mount to (i.e "mkdir /mntOracle").

2) Mount from the /export/home5 directory on wessun450 to access Oracle software (i.e. "mount -o ro wessun450:/export/home5 /mntOracle"

Installation Preparation

These instructions assume you are connected to a network, have the "/WEA" disk mounted, and are using a WEA Test Dept Jumpstart OS image. It also assumes you have a "/etc/system" file that contains appropriate values for your environment (see Solaris System (/etc/system) Values (example).)

Although these instructions assume you are installing from the "/WEA" disk, you can also perform the installation from a mounted CD. They also assume you are at the console for the machine, or are using DSView (if not, you must execute the command "xhost +" at the console for this machine). Whether installing from a network server or CD, there are two methods available for your installation of Oracle, a "Oracle Automatic Install", and a "Manual Setup Procedure".

1) For the "Oracle Automatic Install", there are Solaris commands contained in an Oracle Automatic Install Script (file "OracleRootWEASun" located at "/WEA/inst.images/Oracle/oracle.817.sun"), which automatically perform the majority of the setup required by the root user (if using the CD method, insert the CD before executing the Automatic Setup Script). Also, the script (as well as the Manual Setup Procedure) copies over a ".profile" file which contains the "SID" for your database. You must assure that after copying this file, the file is updated to the appropriate DISPLAY variable, and your SID (if you do not use the example SID in the following instructions). You can modify this script to reflect which method you use for accessing the Oracle installation software (web, CD, or mounted network drive).

(OR)

1) If you wish to performs all of these steps manually, see the section Manual Setup Procedure.

Once the Automatic Setup Script has been run, or you perform the steps manually, you will then invoke the Oracle installation GUI. The section Installing Oracle Software describes the steps you follow to invoke and use the GUI.

Installing Oracle Software

THIS SECTION ASSUMES YOU HAVE PERFORMED ONE OF THE ABOVE STEPS (Oracle Automatic Install Script or Manual Setup Procedure). If you have not, and you continue, the author would like to laugh at you when the following does not work!

If any time during the installation the installer states you should execute anything as root, do so (i.e. if the "Oracle Universal Installer" window pops up informing you to execute the "orainstRoot.sh" script, follow the instructions and do so, then click "Retry").

1) Switch users to "oracle" (i.e. "su - oracle"), and from the AIX command line, if you have not modified your ".profile" to reflect the correct machine to output the Oracle installation GUI, export your DISPLAY variable, reflecting your machine (i.e. "export DISPLAY=weasun16.raleigh.ibm.com:0.0").

2) If installing from the "/WEA/inst.images" mounted disk, change directories to "/WEA/inst.images/Oracle/oracle.817.sun/Disk1" and from the command line execute the script "./runInstaller". If installing from CD, from the root ("/") directory, run the script "runInstaller" (i.e. "/mntOracle/runInstaller"). If installing from the wessun450 server, change directories to "/mntOracle/oracle817/sun/Disk1" and from the command line execute the script "runInstaller". If installing using the Oracle software you obtained from the web, from the directory your "Disk1" directory is in, run the script "runInstaller" (i.e. "/yourinstalldirectoryname/Disk1/runInstaller").

3) The "Oracle Universal Installer" GUI will appear displaying the "Welcome" panel, click "Next".

4) In the "File Locations" panel, accept the defaults, and click "Next" (Source = "(yourinstalldisk)/stage/products.jar", and Destination = "/export/home/oracle/ORA817", (or whatever you specifed as your Oracle Home, which is currently set by the .profile which was copied from /WEA/inst.images/Oracle/oracle.817.sun).

5) In the "UNIX Group Name" panel, enter the value "oinstall", then click "Next".

6) When the "Oracle Universal Installer" window pops up informing you to execute the "./orainstRoot.sh" script, follow the instructions and do so, then click "Retry"). (Output of this execution is "Creating Oracle Inventory ponter file (/etc/oraInst.loc) Changing groupname of /export/home/oracle/oraInventory to oinstall.)

7) In the "Available Products" panel, select "Oracle8i Enterprise Edition 8.1.7.0.0", then click "Next".

8) In the "Installation Types", select "Typical", then click "Next", and wait a minth (which states it takes 1.01 GB of space!).

9) In the "Database Identification" panel, in the 'Global Database Name" field, enter "ORA817." followed by the fully qualified name of the host you are installing on (i.e. "ORA817.weasun16.raleigh.ibm.com" (the "SID" field should reflect "ORA817"), then click "Next". (see note above about the SID value in the Automatic Setup Script)

10) In the "Database File Location" panel, in the "Directory for Database Files" field, enter "/export/home/oracle/dbfiles", then click "Next".

11) In the "Summary" panel, review your installation specifics (156 products, including "Starter Database", and the "Space Requirements" = 959MB) and click "Install". Wait a minth.

A summary log will be created in "/export/home/oracle/oraInventory/logs/installActions.log". If another Oracle product or upgrade is installed, this file will be copied to "/export/home/oracle/oraInventory/logs/installActions/YADAYADA.log" where "YADAYADA" represents a time stamp.

If using CDs, when prompted with the "Disk Location" pop-up, unmount CD 1, remove CD1 and insert CD2, mount it, and click "OK" in the popup.

12) When the popup "Setup Privileges" appears stating "A configuration script needs to be run as root before installation can proceed. Please leave this window up, go run /export/home/oracle/ORA817/root.sh as root from another window, then come back here and click OK to continue". When you execute "root.sh", you will be queried to "Enter the full pathname of the local bin directory: [/usr/local/bin]:", accept the default and press Enter. Back in the Oracle installer GUI "Setup Privileges" popup, click "OK" ("/usr/local/bin" was then created by the installer).

The dialog from this step was:

#root.sh
Running Oracle8 root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME= /export/home/oracle/OraHome1
    ORACLE_SID=   ORA817

Enter the full pathname of the local bin directory: [/usr/local/bin]: (author pressed "Enter")
Creating /usr/local/bin directory...

Creating /var/opt/oracle/oratab file...
Entry will be added to the /var/opt/oracle/oratab file 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.
IMPORTANT NOTE: Please delete any log and trace files previously
                created by the Oracle Enterprise Manager Intelligent
                Agent. These files may be found in the directories
                you use for storing other Net8 log and trace files.
                If such files exist, the OEM IA may not restart.
#

13) The "Database Creation Progress" dialog box will appear reflecting the progress of this operation. Afterwards, when the "Oracle Database Configuration Assistant Alert" pop-up appears, stating:

    Database creation completed.
    Database information:
        global database name: ORA817.wea2aix1.raleigh.ibm.com
        database system Identifier (SID):ORA817
        SYS account password: change_on_install.
        SYSTEM account password: manager"

Click "OK".

14) In the "End of Installation" panel, the display should reflect "The installation of Oracle8i Enterprise Edition was successful.".

If you install additional components, the file "root.sh" will be overwritten. Change directories to "/export/home/oracle/ORA817", and execute the command "cp root.sh root.sh.afterinstall".

At this point you can either exit the installer or choose to install the Application User Client or Database Administrator Client simply by clicking on the "Next Install" button in the "End of Installation" panel. The instructions for installing both clients are included in this web page. Note that as you have just completed the installation, and are using the CD installation method, you will need to reinsert CD1 to complete the client installs. If you wish to exit, click "Exit", and in the "Exit" "Do you really want to exit" pop-up, click "Yes". If you wish to install the install the Oracle Database Client, follow the instructions in "Installing Oracle Database Client" below, otherwise, proceed to the next section if you want to install WEA .

Oracle Configuration and Usage for WAS/WEA

This section might be changed as the design matures for WEA installation on Solaris using Oracle database.

1) You must modify the file "/etc/profile" to include the following two lines:

ORACLE_HOME=/export/home/oracle/ORA817
export ORACLE_HOME

2) Once this file has been modified you must log off and back on your machine to instantiate this environment variable

3) You must then create a set of accounts required for a full WEA installation.Switch user to the oracle account (i.e. "su - oracle").

The following users and priviliges can be created manually (see Creating WEA Users Automatically), or all can be added automajically by using the appropriate script (see Creating WEA Users Manually)

Creating WEA Users Automatically

1) Change directories to "/WEA/inst.images/Oracle/oracle.817.sun". In that directory exists at file "WEAUsers.sql" which contains SQL commands for creating all users a Full WEA installation will require.

2) From the command prompt execute the command "sqlplus". (this results in the text "SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jan 8
10:53:26 2003 (c) Copyright 2000 Oracle Corporation. All rights reserved".

3) When prompted by "Enter user-name", enter "SYSTEM", and for the "Enter password", enter "manager". (alternatively, from the Oracle user's command line type "sqlplus SYSTEM/manager")

4) As you are already in the appropriate directory, simply type "@WEAUsers.sql", which will invoke the SQL script which adds all necessary users and associated priviledges. When this completes, you can confirm these users were added using the SQL command "select username from dba_users;". If your addition of users was successful, type "quit".

5) Test access to the new database with the EJSADMIN user ID by entering the following commands.

$ sqlplus EJSADMIN/ejsadmin

SQL> quit

6) Your users have been successfully created and tested. Proceed with WEA installation.

Content Of WEAUsers.sql

The following is the content of the file which you can use to automatically add all users necessary for a full install of WEA:

-- SQL script file to create users in the Oracle DB
-- Can be used by WEA to create, users for all WEA components
-- and grant appropriate privileges
-- From SQL*PLUS run this script as "@user.sql"
--
create user EJSADMIN identified by EJSADMIN;
grant connect,resource,dba to EJSADMIN;
create user EJB identified by EJB;
grant connect,resource,dba to EJB;
create user WPS identified by WPS;
grant connect,resource,dba to WPS;
create user WMS identified by WMS;
grant connect,resource,dba to WMS;
create user WEA identified by WEA;
grant connect,resource,dba to WEA;
create user WPSPCO identified by WPSPCO;
grant connect,resource,dba to WPSPCO;
create user ESSADMIN identified by ESSADMIN;
grant connect,resource,dba to ESSADMIN;
create user INSUSER identified by INSUSER;
grant connect,resource,dba to INSUSER;
create user DMS identified by DMS;
grant connect,resource,dba to DMS;
create user ATLAS identified by ATLAS;
grant connect,resource,dba to ATLAS;

Creating WEA Users Manually

1) From the command prompt execute the command "sqlplus". (this results in the text "SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jan 8
10:53:26 2003 (c) Copyright 2000 Oracle Corporation. All rights reserved".

2) When prompted by "Enter user-name", enter "SYSTEM", and for the "Enter password", enter "manager".

(OR)

(alternatively, from the Oracle user's command line type "sqlplus SYSTEM/manager")

3) Execute the following commands, each followed by pressing the "Enter" key:

create user EJSADMIN identified by EJSADMIN;
grant connect,resource,dba to EJSADMIN;
create user EJB identified by EJB;
grant connect,resource,dba to EJB;
create user WPS identified by WPS;
grant connect,resource,dba to WPS;
create user WMS identified by WMS;
grant connect,resource,dba to WMS;
create user WEA identified by WEA;
grant connect,resource,dba to WEA;
create user WPSPCO identified by WPSPCO;
grant connect,resource,dba to WPSPCO;
create user ESSADMIN identified by ESSADMIN;
grant connect,resource,dba to ESSADMIN;
create user INSUSER identified by INSUSER;
grant connect,resource,dba to INSUSER;
create user DMS identified by DMS;
grant connect,resource,dba to DMS;
create user ATLAS identified by ATLAS;
grant connect,resource,dba to ATLAS;

4) Exit from the sqlplus utility by typing "quit" and press "Enter".

5) Test access to the new database with the EJSADMIN user ID by entering the following commands.

$ sqlplus EJSADMIN/ejsadmin

SQL> quit

6) Your users have been successfully created and tested. Proceed with WEA installation.

Installing WAS With Oracle Installation Instructions

You must first create the appropriate users with associated priviledges before performing this installation. Follow the instructions in the section Oracle Configuration and Usage for WAS/WEA.

When installing WAS, if you are using Oracle, perform the following steps in the Database Options dialog:

1). In the Database Type field, select Oracle from the pull-down menu.

2) Ensure that Remote DB is not selected. For this example, the database and WebSphere Application Server are installed on the same node.

3). In the Database Name (Database SID) field, type the name of the Oracle database you created. For example, ORA817. machine_name.

4) In the DB Home field, type the full pathname of the directory you created to contain the Oracle software and to be the home directory of the user named oracle, or specify the full path name of the directory by using the Browse button. This path should also be the value of the ORACLE_HOME environment variable.

5) In the DB URL field, accept the default value jdbc:oracle:thin:@fully_qualified_domain_name : port_number : database_name, or specify a different URL for accessing the database.

6) In the Server Name field, type the name of the machine on which the database is installed.

7) In the Port Number field, type the port number used to access the database.

8) In the Database User ID field, type the name of the database owner, EJSADMIN .

9) In the Database Password field, type the current password for the database owner.

10) Click Next to continue.

Installing Oracle Database Application User Client

You will need to have followed the appropriate above previous instructions for setting up the Oracle environment for installation, i.e. Prerequisite Check, Installation Preparation, Get the Oracle Software, and steps 1-6 of Install Oracle Software for the following steps to succeed (Or, if you have already installed Oracle and are still in the GUI, from another AIX window, as root, unmount the CD 2, mount the CD1, and then click the "Next Install" button).

1) In the "File Locations" panel, accept the defaults, and click "Next" (Source = "(yourinstalldisk)/stage/products.jar", and Destination = "/export/home/oracle/ORA817", (or whatever you specifed as your Oracle Home, which is currently set by the .profile you copied from "/WEA/inst.images/Oracle/oracle.817.sun". You must also perform this with Oracle CD1 if using the CD method of installation).

2) In the "Available Products" panel, select "Oracle8i Client 8.1.7.0.0", then click "Next".

3) In the "Installation Types" panel, select "Application User", then click "Next".

4) In the "Summary" panel, click "Install".

5) In the "End of Installation" panel, click "Exit" (OR, choose to install other Oracle software)

Installing Oracle Database Administrator Client

You will need to have followed the appropriate above previous instructions for setting up the Oracle environment for installation, i.e. Prerequisite Check, Installation Preparation, Get the Oracle Software, and steps 1-6 of Install Oracle Software for the following steps to succeed. (Or, if you have already installed Oracle and are still in the GUI, from another AIX window, as root, unmount the CD 2, mount the CD1, and then click the "Next Install" button).

2) In the "Available Products" panel, select "Oracle8i Client 8.1.7.0.0", then click "Next".

3) In the "Installation Types" panel, select "Administrator", then click "Next".

4) In the "Summary" panel, click "Install". (note a message was displayed "Deinstalling Client".)

5) In the "End of Installation" panel, click "Exit" (OR, choose to install other Oracle software)

Creating And Using An Oracle Database

1) After performing the "Logon to Oracle as SYSTEM", execute the command "dbassist", which will invoke the Oracle Database Configuration Assistant.

2) In the Welcome panel, select the "Create a database" option, then click "Next".

3) In the "Select the type of database to create" panel, select "Typical" and click "Next".

4) Select "Copy Existing database files from the CD", then click "Next".

Option 1 - Copy Existing database files from the CD"

1) In the "An Oracle8i databases is uniquely identified by a Global Database Name...", "Global Database Name" field enter "slapit.raleigh.ibm.com" (which will automatically create the SID as "slapit"), then click "Finish".

2) An alert will be displayed reflecting "The datafiles will be copied from the CD to "/export/home/oracle/ORA817/oradata/slapit.(STEVE?)" The Oracle Database Configuration Assistant wil begin creating the database. Do you want to proceed", click "Yes".

3) An additional alert will be displayed "An Oracle databse will be created for you. The database name will be slapit. The system identifier for the database will be slapit. The password for the SYS account will be change_on_install and the SYSTEM account will be manager" click "OK".

4) Final alert will be displayed in dialog box "Oracle Database Configuration Assistant Alert" containing:

Database creation completed.
Database Information:
    global database name:    slapit.wea2aix1.raleigh.ibm.com
    database system identifier (SID): slapit
    SYS account password" change_on_install
    SYSTEM account password: manager

5) Click "OK" in the alert box.

6) From command prompt type "sqlplus system/manager@STEVEZ" and press "Enter".

7) Your database has been created and should be available for population of tables, etc.

Using an Oracle Database

1) When the database creation utility had completed, from the AIX command prompt, type "su - oracle".

2) From the Oracle prompt ("$"), executed the sqlplus command giving the appropriate id/password and SID (i.e. "sqlplus system/manager@slapit").

(Note that "Ctrl" and Backspace key are the delete/rubout key.)

3) From the SQLPLUS command prompt, list data from your tables (i.e. "select * from scott.emp") which will display all rows in the SCOTT schema's "emp" table. (Note that whenever you use DBASSIST to create a database and select "Copy Existing database files from the CD", it automatically creates a "SCOTT" schema.

4) To describe the columns of an table, use the "describe" command (i.e. "describe scott.emp").

5) Do normal creation of tables, insert rows, etc.

6) To list the tables, use the command "select * from tab". This will list all tables, as well as your tables should be in the list.

7) To list only the tables for a particular user/owner (i.e. "SCOTT"), type the command "select TABLE_NAME from ALL_TABLES where OWNER='SCOTT'" (do not include the beginning and ending double quote (")).

(Schema Table Scott emp)

Using The NetAssist Utility

1) From the Oracle command prompt ("$"), type "netasst".

2) In the Net8 Assistant GUI, scope down through "Net8 Configuration", "Local", "Service Naming", and select your "slapit" service. The right panel will display details of this service, (including Port Number).

Miscellaneous Oracle Utilities and Commands

Start/Stop the Database

   1.To start or stop the Oracle database:
          Log in as the user oracle by entering the following command:
          su - oracle
          If not set in the .profile, enter export ORACLE_SID=ORA817
          To start the database, enter the following commands:

$ svrmgrl

SVRMGR> connect internal

SVRMGR> startup SVRMGR

SVRMGR> quit

To stop the database, enter the following commands:

          $ svrmgrl
          SVRMGR> connect internal
          SVRMGR> shutdown
          SVRMGR> quit

Starting Database

Start the database by entering the following commands:
$ svrmgrl SVRMGR
> connect internal SVRMGR
> startup SVRMGR
> quit

(OR, Starting Database)

$ svrmgrl
SVRMGR> connect internal
Connected.
SVRMGR> startup
ORACLE instance started.
Total System Global Area               7275404 bytes
Fixed Size                                          73620 bytes
Variable Size                                55730176 bytes
Database Buffers                          16777216 bytes
Redo Buffers                                   172032 bytes
Database mounted.
Database opened.
SVRMGR> help     blah blah.....
SVRMGR> quit

(OR, a script which performs this contains:)

#!/bin/ksh
su - oracle -c '
echo "Enter sid name (like ispb): "
read sid
PMON=`ps -ef | egrep pmon_${sid} | grep -v grep`
if [ "${PMON}" = "" ]
then
echo "starting Oracle"
    # database still running, shut it down first
    ORACLE_SID=$sid
    sqlplus /nolog <<!
connect internal
startup
!
else
echo "Oracle already running"
fi
'

Stopping Database

$ svrmgrl
SVRMGR> connect internal
Connected.
SVRMGR> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.

(OR, a script which performs this contains:)

#!/bin/ksh
su - oracle -c '
echo "Enter sid name (like ispb):"
read sid
PMON=`ps -ef | egrep pmon_${sid} | grep -v grep`
if [ "${PMON}" != "" ]
then
echo "stopping Oracle"
    # database still running, so we can shut it down
    ORACLE_SID=$sid
    sqlplus /nolog <<!
connect internal
shutdown immediate
!
else
echo "Oracle not running"
fi
'

Starting and Stopping Listener

Starting and stopping the listener is done by the utility "lsnrctl". Usage follows (note the author occasionally had to go the the directory lsnrctl was in and execute it there first (/home/oracle/ORA817/bin/lsnrctl):

1) Log in as the user oracle by entering the command "su - oracle"

2) If not set in the .profile, enter export ORACLE_SID=ORA817

3) To stop/start the listener, enter the following commands:

$ lsnrctl
LSNRCTL for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production on 17-JAN-2003 17:29:26
blah blah blah
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=wea2aix2.raleigh.ibm.com)(PORT=1521)))
-------------------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX blah
Start Date blah blah

LSNRCTL> stop
LSNRCTL> start
LSNRCTL> quit

(OR, a script file which does it should contain:)

#!/bin/ksh
su - oracle -c "lsnrctl stop"

#!/bin/ksh
su - oracle -c "lsnrctl start"

(OR, a script file which restarts it should contain:)

#!/bin/ksh
su - oracle -c "lsnrctl reload"

Adding Oracle Automatic Startup To "inittab"
From command line type:

mkitab "oradb:2:wait:/bin/su oradb -c|/$ORACLE_HOMES/bin/dbstart"

Deleting the WebSphere Application Server Database

1) Ensure that you have run the xhost command and have exported your DISPLAY. See above for details.

2) Log in as the user oracle by entering the following command "su - oracle".

3) If not set in the .profile, enter "export ORACLE_SID=ORA817".

4) Invoke the Database Assistant from the command prompt (i.e. enter "dbassist").

5) When prompted, select Delete a database.

6) When prompted, select ORA817.

Recreating the WebSphere Application Server Database

1) Ensure that you have run the xhost command and have exported your DISPLAY. See above for details.

2) Log in as the user oracle by entering the command "su - oracle".

3) If not set in the .profile, enter "export ORACLE_SID=ORA817".

4) Invoke the Database Assistant from the command prompt (i.e. enter "dbassist").

5) When prompted, select Create a database.

6) When prompted, select Typical Install.

7) When prompted, select "Copy existing database files from the CD". Ignore the text about needing the real CD.

8) For Global Database Name, enter "ORA817.(fully qualified hostname) (i.e. " ORA817.wea2aix2.raleigh.ibm.com").

9) For Oracle SID, enter "ORA817"

2.Configure the database (see above)

Setup Manager Information

   1.On the WebSphere Application Database configuration screen:
          Database Name: ORA817 (STEVE?)
          Database Server Name: (local/remote hostname).raleigh.ibm.com
          Database Home: (value of $ORACLE_HOME
          Usually /home/oracle/OraHome1
          Database URL:
          jdbc:oracle:thin:@(local/remote hostname).raleigh.ibm.com:1521:ORA817
          Database Port: 1521
          EJSADMIN Password: ejsadmin

Miscellaneous sqlplus Commands

ALTER USER USERNAME IDENTIFIED BY PASSWORD; Change password for "USERNAME" to "PASSWORD"

Miscellaneous SQL Commands

show all Show Oracle environment settings
show user Displays the current user

To use sqlplus on the client machine, type:
su - oracle (or whatever your oracle username is)
sqlplus stage_user/oracle@alias (alias is your database name, it could be something like WEA)
(i.e. "sqlplus system/manager@wea430")
List tables: select table_name from user_tables;
Describe columns in table: describe <table_name>;
Output to command line: echo "SELECT trxn_status FROM tsmtransaction where username='X';" | sqlplus stage_user/oracle@WEA
(The column and table names mentioned throughout this section were actuals from a previous test)
Example: echo "select order_state, auth_status from cust_order where user_id in (select user_id from piauthuser where username='KMC3_IN');" | sqlplus stage_user/oracle@wea
List connections to database (like list applications on DB2):
sqlplus stage_master/oracle@wea
SQL> SELECT username, status FROM v$session;

Manual Setup Procedure

1) Assure Xwindows will operate properly on your machine (i.e.from the AIX command prompt as root execute the command "xhost +" (with no quotes)).

2) Create directories "/export/home/oracle" and "/opt/bin/java" for Oracle installation (i.e "mkdir -p /export/home/oracle", "mkdir -p /opt/bin/java")/

4) Create Oracle "dba" and "oinstall" groups by typing the commands "groupadd dba", and "groupadd oinstall".

5) Create user "oracle", by typing the command "useradd -d /export/home/oracle -g oinstall -G dba -s /bin/ksh oracle".

6) Change the Oracle user password by executing the command "passwd oracle". You will be queried for new password and confirmation, enter "oracle" for both.

7) Change to the directory "/export/home/oracle" and rename the file ".profile" (if it exists) to ".profile.orig". Copy the file ".profile" from /WEA/inst.images/Oracle/oracle.817.sun" to the oracle users's home directory (i.e. "/export/home/oracle") as ".profile", and update your DISPLAY variable and your SID if necessary in the copied file.

8) As root, change the "/export/home/oracle" directory structure permissions ("chmod -R 777 /export/home/oracle"), and change it's ownership (i.e. "chown -R oracle:oinstall /export/home/oracle").

At this point you should have confirmed you have the prerequisite software, and have obtained the Oracle software using the technique you desire. As mentioned before, the software can be installed from CDs, downloaded from Oracle's web site, as well as resides on several internal IBM servers which can be mounted for your use.

Other Oracle Installation Information

http://wespoint/wes/wes_tpsmoracle.html
http://shayden/instorawas.html

Installation of Windows Oracle Client

1) From Oracle web site "http://otn.oracle.com/software/products/oracle8i/htdocs/winsoft.html" (or Steves folder "D:\Oracle Installation\OracleClient\OracleUnzipped\autorun" double click on "autorun.exe" (tried running "setup.exe" in the folder above it but it did not seem to anything). The Oracle8i Client GUI will appear.

2) Click "Install/Deinstall Products".

3) In the "Oracle Universal Installer", "Welcome" panel, click "Next".

4) In the "File Locations" panel, accept the default for the "Source" ("D:\Oracle Installation\OracleClient\OracleUnzipped\stage\products.jar"), and "Destination" ("Name" = "OraHome81" and "Path:" = "D:\oracle\ora81"), then click "Next".

5) In the "Installation Types" panel, select "Administrator (356MB)", then click "Next". Wait a minth.

6) In the "Net8 Configuration Assistant: Welcome" window, DO NOT select "Perform typical configuration", click "Next".

7) In the "Net8 Configuration Assistant: Directory Service Access", select "No,..." and click "Next".

8) In the "Net8 Configuration Assistant: Naming Methods Configuration" panel, accept the default "Selected Naming Methods" of "Local", and click "Next".

9) In the "Net8 Configuration Assistant: Net Service Name Configuration" panel, select "Oracle8i database or service", then click "Next".

10) In the "Net8 Configuration Assistant: Net Service Name Configuration, Service Name" panel, in the "Service Name:" field, enter "STEVEZ", then click "Next".

11) In the "Net8 Configuration Assistant: Net Service Name Configuration, Select Protocols" panel, select "TCP" and click "Next".

12) In the "Net8 Configuration Assistant: Net Service Name Configuration, TCP/IP Protocol" panel, for the "Host Name" field enter your Oracle database machine (i.e. "wea2aix2.raleigh.ibm.com", get this right or it wont work!), and for the "TCP/IP Port Number..." field, accept the default "Use the standard port number of 1521", then click "Next".

13) In the "Net8 Configuration Assistant: Net Service Name Configuration, Test" panel, select "Yes, perform a test", then click "Next". The "Details:" panel should reflect "Connecting....Test Successful", then click "Next".

14) In the "Net8 Configuration Assistant: Net Service Name Configuration, Net Service Name" panel, accept the "Net Service Name:" value (i.e. "STEVEZ"), then press "Next".

15) In the "Net8 Configuration Assistant: Net Service Name Configuration, Another Net ServiceName" panel, select "No", then click "Next".

16) In the "Net8 Configuration Assistant: Net Service Name Configuration Done" panel, click "Next".

17) In the "Net8 Configuration Assistant: Naming Configuration Done" panel, click "Next".

18) In the "Net8 Configuration Assistant: Done" panel, click "Finish".

19) Back in the "Oracle Universal Installer" pane "End of Installation" panel, click "Exit", and in the "Do you relly want to exit", click "Yes".

Starting and Using DBA Studio GUI

1) To execute the DBA Studio GUI for viewing the remote database, from the Windows "Start" menu item, select "Programs", "Oracle - OraHome81", "Database Administration", "DBA Studio",

2) In the "Oracle Enterprise Manager Logon", select "Launch DB Studio standalone", then click "OK". The "Oracle DBA Studio" GUI window should appear.

3) If/when queried for a Username and Password, enter the appropriate values (i.e. "SYSTEM" and "manager"), then click "OK".

4) In the Oracle DBA Studio GUI select the database you wish to explore (i.e. "STEVEZ"), and scope down to "Schema", "Table", and select the table you wish to explore (i.e. "SCOTT").

5) In the right side panel of the GUI, select a table you wish to explore, right mouse click and select "Table Data Editor". The "Table Editor" should appear reflecting the data in the associated table. You can manually change data by going to the appropriate data cell and modifying the value, or go to the last row (which should be empty), and inputting a new row of data into the cells.

Oracle Administrator Profile (.profile)

The following is the ".profile" for the Oracle user, which must reside in "/export/home/oracle" (if you have followed the above instructions and used the automatic or manual method of configuration).

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/sbin:.

export PATH
set -o vi
#DISPLAY=weasun10.raleigh.ibm.com:0.0
#export DISPLAY

ORACLE_BASE=/export/home/oracle
export ORACLE_BASE

ORACLE_SID=ORA817
export ORACLE_SID

ORACLE_HOME=$ORACLE_BASE/$ORACLE_SID
export ORACLE_HOME

PATH=$PATH:$ORACLE_HOME/bin
export PATH

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export LD_LIBRARY_PATH

ORA_CLIENT_LIB=shared
export ORA_CLIENT_LIB

echo 'The oracle 8.1.7 environment is set'

set -o vi
if [ -s "$MAIL" ]           # This is at Shell startup. In normal
then echo "$MAILMSG"        # operation, the Shell checks
fi                          # periodically.

Oracle Automatic Install Script

The following is the script which automatically sets up your Solaris environment for an Oracle 8.17 installation for a subsequent WEA installation"

#-----------------------------------
#-----------------------------------
# Oracle environment "root" user setup ONLY EXECUTE THIS ONCE!
#-----------------------------------
#

# Setup xhost to allow windowing to behave properly
xhost +
echo 'Windowing (xhost) has been set up'

mkdir -p /export/home/oracle
mkdir -p /opt/bin/java
echo 'Created directories /export/home/oracle, and /opt/bin/java'

# Create and configure Oracle group and user
groupadd dba
groupadd oinstall

echo 'The Oracle groups dba and oinstall have been created'
useradd -d /export/home/oracle -g oinstall -G dba -s /bin/ksh oracle
echo ' '
echo 'Added oracle user, please change the oracle password. When queried for new '
echo 'and confirm password type in the string "oracle" (no quotes) at the prompt'
echo ' '
passwd oracle
echo 'The Oracle user oracle has been created and password set'

# Copy a new .profile to /home/oracle and change it's file mode,
# change file mode for directories in "/home/oracle", and change
# owner of /export/home/oracle directory
cd /export/home/oracle
mv .profile .profile.orig
cp /WEA/inst.images/Oracle/oracle.817.sun/.profile .profile
chmod -R 777 /export/home/oracle
echo 'File mode has been changed for /home/oracle/.profile'
chown -R oracle:oinstall /export/home/oracle
echo 'Changed Owner of /export/home/oracle directory'
echo ' '

# Now have user follow setup instructions on web page
echo
echo
echo
echo 'From now on, follow instructions on web page and/or as specified by installation GUI'
echo

Solaris System (/etc/system) Values (example)

The following are example values for Solaris's "/etc/system" file:

set shmsys:shminfo_shmmax=966367641
set shmsys:shminfo_shmseg=256
set shmsys:shminfo_shmmni=1024
set shmsys:shminfo_shmmin=1
set msgsys:msginfo_msgmax=65535
set msgsys:msginfo_msgmnb=65535
set msgsys:msginfo_msgmap=1026
set msgsys:msginfo_msgmni=1024
set msgsys:msginfo_msgssz=32
set msgsys:msginfo_msgtql=2048
set msgsys:msginfo_msgseg=32767
set semsys:seminfo_semmni=2048
set semsys:seminfo_semmap=2050
set semsys:seminfo_semmns=4096
set semsys:seminfo_semmnu=4096
set semsys:seminfo_semume=256
set semsys:seminfo_semmsl=100
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
set rlim_fd_cur=1024

Error Conditions

(Steve got an error stating it could not find the Java directory input, so clicked the "Ignore" button on the popup. Installation proceeded. Looked in "/home/oracle" and there is a "jre" directory there. Looked in documentation and it states Oracle lays down it's own JRE 1.1.8.7.

Got the following error when you dont follow the procedure for Installing Filesets Manually, SO DO IT!

Got several errors like "Error in invoking target relink of makefile /home/oracle/ORA817/precomp/lib/ins_precomp/lib/ins_precomp.mk.". File is there and it's mode is executable. Clicked "Ignore".

The following table includes the addional invocation errors which occurred. The table includes only the "target" and directory reflected in the error message. In each case the author clicked "Ignore" on the pop-up.

TARGET DIRECTORY and MAKEFILE

install              otrace/lib/ins_otrace.mk
install              sqlplus/lib/ins_sqlplus.mk
install                network/lib/ins_net_client.mk
install                network/lib/ins_comagent.mk
toolinstall          ldap/lib/ins_ldap.mk
install                plsql/lib/ins_plsql.mk
install                network/lib/ins_net_server.mk
install                rdbms/lib/ins_rdbms.mk
install                network/lib/ins_nau.mk
utilities             rdbms/lib/ins_rdbms.mk
ihsodbc            rdbms/lib/ins_rdbms.mk
ioracle              rdbms/lib/ins_rdbms.mk
install               ctx/lib/inx_ctx.mk