Installation of Oracle 9.2.0.1 on AIX

Steve, clean up scripts, and you might need to additionally create a link for the thread stuff, by creating an environment variable  LINK_CNTRL=L_PTHREADS_D7 (see installation guide, page 1-21)

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

Prerequisite Check
 

1) Assure you have enough memory (To confirm amount of memory on your box "lsattr -El mem0").

2) Assure you have enough paging space (To list the amount of paging space "lsps -a")

3) Assure you have the correct version of the AIX operating system (AIX 5.1) (To list the version of operating system "uname -a" (results will look like "AIX wea2aix1 1 5 0007386C4C00"

4)  Assure you have enough file space.
 

Get The Oracle Software

The software can be installed from CDs (see Installing Oracle From CD's), downloaded from Oracle's web site (see Download Oracle From Oracle Site ), as well as resides on several internal IBM servers which can be mounted for your use (see Get the Software From one of the IBM Internal Sites).

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").
 

(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/oracle9i/htdocs/aixsoft.html").

3) Logon as "shayden@ipass.net" with the appropriate password, and then download the 9.2.0.1 version of Oracle to the directory you created in step 1. It is actually 4 files, "server_9201_AIX64_Disk1.cpio.gz" and "server_9201_AIX64_Disk2.cpio.gz", "server_9201_AIX64_Disk3.cpio.gz", and "server_9201_AIX64_Disk4.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 server_9201_AIX64_Disk1.cpio.gz
gunzip server_9201_AIX64_Disk2.cpio.gz
gunzip server_9201_AIX64_Disk3.cpio.gz
gunzip server_9201_AIX64_Disk4.cpio.gz

cpio -idcmv < server_9201_AIX64__Disk1.cpio
cpio -idcmv < server_9201_AIX64__Disk2.cpio
cpio -idcmv < server_9201_AIX64__Disk3.cpio
cpio -idcmv < server_9201_AIX64__Disk4.cpio
 

(OR)

Get the Software From one of the IBM Internal Sites

From shayden

The software currently resides on the network mounted drive on machine "wea2aix6" in directory "/WEA/inst.images/Oracle/oracle.9201.aix5L.64.bit" as 4 disks, "Disk1", "Disk2", "Disk3", and "Disk4".
 
 
 

Installation Preparation

The majority of these instructions assume you are connected to a network server, however, you can also perform the installation from a mounted CD.

Before installing Oracle you must update your AIX operating system. Install bundle "App-Dev" and filesets "bos.adt" (that includes "bos.adt.libm"), "bos.compat", "X11.adt", on your system (Note that the normal NIM build only has part of these file sets installed, so you MUST complete all of this portion!) To install them follow the instructions in the section Installing Filesets Manually.

Whether installing from a network server or CD, there are AIX commands contained in an Automatic Setup Script (file "OracleRootWEA" located at "/WEA/inst.images/Oracle/oracle.9201.aix5L.64.bit"), which automatically performs 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 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 your SID (if you do not use the example SID in the following instructions), as well as (un)comment the appropriate lines of this script to reflect the method of installation you are using (comments in the script file tell you what you should do). You can copy and modify this script to reflect which  method you use for accessing the Oracle installation software (web, or mounted network drive). If you wish to perform all of these steps manually, see the section Manual Setup Procedures.

Once the Automatic Setup Script has been run, or you perform the steps manually, and you have installed the aforementioned AIX filesets, 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

If any time during the installation the installer states you should execute anything as root, do so (ie.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, export your DISPLAY variable, reflecting your machine (i.e. "export DISPLAY=id10t69.raleigh.ibm.com:0.0").

2) If installing from shayden directory, change directories to "/WEA/inst.images/Oracle/oracle.9201.aix5L.64.bit/Disk1" and from the command line execute the script "runInstaller".  If installing using the Oracle software you obtained from the web, from your "Disk1" directory, run the script "runInstaller" (i.e. "/yourinstalldirectoryname/Disk1/runInstaller").

3) When queried as to whether you have run the "rootpre.sh" script as root, type "y" and press "Enter" (assuming you have run the automatic script or the manual method for preparation).

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

5) In the "Inventory Location" panel, accept the default, and click "OK" ("Base Directory" is "/home/oracle/oraInventory").

6) In the "Unix Group Name" panel, enter "oinstall", then click "Next".

7) When the "Oracle Universal Installer" window pops up informing you to execute the "orainstRoot.sh" script, follow the instructions and do so, then click "Continue").

8) In the "File Locations" panel, accept the defaults, and click "Next", and this step takes several seconds (Source =
"(yourinstalldisk)/stage/products.jar", and Destination "Name" = "OUIHome", and "Path" = "/home/oracle/ORA9201", (or whatever you specified as your Oracle Home, which is currently set by the .profile which was copied from /WEA/inst.images/Oracle).

9) In the "Available Products" panel, select "Oracle9i Database 9.2.0.1.0", then click "Next".

10) In the "Installation Types", select "Enterprise Edition", then click "Next", and wait a minth (this takes 3.21 GB of space! If you dont have enough defined, either define some more (i.e. "chfs -a size='+2400000'"), press "Previous", then "Next", or perform step the next step and distribute your installation however you want).

11)  In the "Database Configuration" panel, select "General Purpose", then click "Next" (options also include "Transaction Processing", "Data Warehouse", "Customized", and "Software Only").

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

14) In the "Database File Location" panel, in the "Directory for Database Files" field, accept the default "/home/oracle/oradata", then click "Next".

15)  In the "Database Character Set" panel, accept the default "Use the default character set", then click "Next".

16) In the "Choose JDK Home Directory",for the "Enter JDK Home" field, enter "/usr/java130", and click "Next".

17) In the "Summary" panel, review your installation specifics (plus or minus 199 products, including "Starter Database") and click "Install". Wait a minth.

A summary log will be created in "/home/oracle/oraInventory/logs". The filename will be "installActions/YADAYADA.log" where "YADAYADA" represents a date/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

18) 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 /home/oracle/ORA9201/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 click "OK" ("/usr/local/bin" was then created by the installer).

The dialog from this step was:

#root.sh
Running Oracle9 root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /home/oracle/ORA9201

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

Creating /usr/local/bin directory...
    Copying dbhome to /usr/local/bin ...
    Copying oraenv to /usr/local/bin ...
    Copying coraenv to /usr/local/bin ...
 

Creating  /etc/oratab file ...
Adding entry to /etc/oratab file...
Entries will be added tot he /etc/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.

#

19) In the "Database Configuration Assistant" popup dialog box, for the "SYS Password" and "Confirm SYS Password" fields, enter "smanager", and for the "SYSTEM Password" and "Confirm SYSTEM Password" fields enter "mangler", then click "OK".

(note the "Agent Configuration Assistant" might fail, but is not needed, so you can ignore this).

20) In the "End of Installation" panel, click "Exit".

(In this panel the following text was displayed:)

"The following information is available in:
/Home/oracle/ORA9201/Apache/Apache/setupinfo.txt
------------------------------------
The HTTP Server can be accessed using the following URLS:

Non SSL Mode (executed at install time):
http://wea2aix20:7777

SSL Mode:
http://wea2aix20:7778
https://wea2aix20:443
 
 
 
 

Oracle Configuration and Usage for WAS/WEA

The following describes the minimal set of accounts required for WAS installation. WEA might require additional accounts created, as well as possibly desire these accounts to be created without dba priviledges and with different or additional configurations.
 

1) You must modify the file "/etc/environment" file to include the following line:

    ORACLE_HOME=/home/oracle/ORA9201

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

3) You must modify (or include in) the Oracle user's ".profile" the correct value for the DISPLAY environment variable. Set this value for the machine name you are on or are exporting the SUM GUI to (i.e. "wea2aix5.raleigh.ibm.com:0.0").
 
 

Logon to Oracle as SYSTEM

1) Switch user to the oracle account (i.e. "su - oracle").

2) You must now create users with appropriate proviledges for a WEA installation. These users and priviliges can be created manually (see Creating WEA Users Manually), or all can be added automajically by using the appropriate script (see Creating WEA Users Automatically)
 
 

Creating WEA Users Automatically

1) Change directories to "/WEA/inst.images/Oracle/oracle.9201.aix5L.64.bit". 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  system/mangler". (this results in the text "SQL*Plus: Release 9.2.9.1.0 - Production on Sun July 20 10:53:26 2003   (c) Copyright 2002 Oracle Corporation. All rights reserved").

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 "@WEAUsers.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  system/mangler". (this results in the text "SQL*Plus: Release 9.2.9.1.0 - Production on Sun July 20 10:53:26 2003   (c) Copyright 2002 Oracle Corporation. All rights reserved").

2) 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;
 

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

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

          $ sqlplus EJSADMIN/ejsadmin

          SQL> quit

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

(Steve you were not presented with the following!)

Eventually you will be presented with the "Net8 Configuration Assistant: Welcome" window. You can select "Perform
typical configuration" to have the Oracle installer create this (see Typical Configuration Checked), or optionally step
through the process manually (see Perform Typical Configuration Not Checked), make your choice and click
"Next".
 
 

Typical Configuration Checked

1) 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: ORA9201.wea2aix1.raleigh.ibm.com
        database system Identifier (SID):ORA9201
        SYS account password: change_on_install.
        SYSTEM account password: manager"

Click "OK".

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

3) If you install additional components, the file "root.sh" will be overwritten. Change directories to
"/home/oracle/ORA9201", 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.
 
 

Perform Typical Configuration Not Checked

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

2) In the "Net8 Configuration Assistant: Listener Configuration, Listener Name" panel, accept the default "Listener
Name: LISTENER", and click "Next".

3) In the "Net8 Configuration Assistant: Listener Configuration, Select Protocols" panel, accept the default "Selected
Protocols" "TCP", then click "Next".

4) In the "Net8 Configuration Assistant: Listener Configuration, TCP/IP Protocol" panel, accept the default "Use the
standard port number of 1521", then click "Next".

5) In the "Net8 Configuration Assistant: Listener Configuration, More Listeners?" panel, select "No" and click "Next".

6) In the "Net8 Configuration Assistant: Listener Configuration, Configuration Done" panel, click "Next".

7) In the "Net8 Configuration Assistant: Naming Methods Configuration" panel, select "No" and click "Next".

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

9) 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: ORA9201.wea2aix1.raleigh.ibm.com
        database system Identifier (SID):ORA9201
        SYS account password: change_on_install.
        SYSTEM account password: manager"

Click "OK".

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

11) Make a backup copy of the "root.sh" file. If you install additional components, this file will be overwritten. Change
directories to "/home/oracle/ORA9201", 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.
 

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 = "/home/oracle/ORA9201", (or whatever you specifed as your Oracle Home, which is currently set by the .profile you copied from /WEA/inst.images/Oracle. You must also perform this with Oracle CD1 if using the CD method of installation).

2) In the "Available Products" panel, select "Oracle9i Client 9.2.0.1.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).

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

2) In the "Available Products" panel, select "Oracle9i Client 9.2.0.1.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 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 Oracle9i databases is uniquely identified by a Global Database Name...", "Global Database Name" field enter "STEVEZ.playing" (which will automatically create the SID as "STEVEZ"), then click "Finish".

2) An alert will be displayed reflecting "The datafiles will be copied from the CD to /hom/oracle/oradata/STEVEZ. 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 STEVEZ. The system identifier for the database will be STEVEZ. 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: STEVEZ.PLAYING
    database system identifier (SID):  STEVEZ.
    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.
 
 
 
 

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, ORA9201. 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.
 
 
 

Miscellaneous Oracle Utilities and Commands

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/ORA9201/bin/lsnrctl):

$  lsnrctl
LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.1.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

(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"
 
 

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)
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;
 
 
 

Installing Filesets Manually

Installing From NIM Server

This section describes the process required to install additional filesets on AIX using NIM rather than using the CD's.

1) From the machine you want to install additional filesets on, from the AIX command prompt, type "smitty nim".

2) From the "Network Installation Management" panel, select "Install and Update Software", then press "Enter".

3) From the "Install and Update Software" panel, select "Install Software Bundle" then press "Enter".

4) In the "Select the LPP_SOURCE containing the install images" section of the panel, select the lpp source for the AIX maintenance level you wish to install (i.e. "lpp_source_gvt_aix513"), then press "Enter".

5) In the "Select the BUNDLE to use" portion of the panel, position the cursor at the "App-Dev" resource and press the "Enter" key.

6) In the "Install Software Bundle" panel, for the parameters on the left, input/select the values on the right (see example below), (note the example below reflects values to commit the software installation, you might want to simply "PREVIEW only" first to assure installation will succeed. (For the faint of heart)), then press "Enter". In the "ARE YOU SURE?" confirmation window press "Enter". Wait a minth, and when the install finishes an reflects "OK", press the F3 key until you return to the command prompt.

*********************  SMITTY SCREEN ******************************
 

                                Install Software

Type or select values in entry fields.
Press Enter AFTER making all desired changes.

                                                                                        [Entry Fields]
* LPP_SOURCE                                                          [lpp_source_gvt_aix513> +
* SOFTWARE to install                                                App-Dev

    Customization SCRIPT to run after installation            []
        (not applicable to SPOTs)

installp Flags
  PREVIEW only? (install operation will NOT occur)           no                      +
  Preview new LICENSE agreements?                                no                      +
  ACCEPT new license agreements?                                   no                      +
  COMMIT software updates?                                            yes                     +
  SAVE replaced files?                                                        yes                     +
  AUTOMATICALLY install requisite software?                 yes                      +
  EXTEND file systems if space needed?                             yes                     +
  OVERWRITE same or newer versions?                            no                      +
  VERIFY install and check file sizes?                                  yes                     +
 

F1=Help             F2=Refresh          F3=Cancel           F4=List
F5=Reset            F6=Command          F7=Edit             F8=Image
F9=Shell            F10=Exit            Enter=Do
 

(note: the fileset "java.adt" will probably fail as it is not on the lppsource image)

7) Press the "F3" key until you return to the "Network Installation Management" panel, select "Install and Update Software".

8) From the "Install and Update Software" panel, select "Install Software" then press "Enter".

9) In the "Select the LPP_SOURCE containing the install images" section of the panel, select the lpp source for the
AIX maintenance level you wish to install (i.e. "lpp_source_gvt_aix513"), then press "Enter".

10) In the "Install Software" panel, the cursor should be positioned at the "Software to Install" field, press the F4 key.

11) A "Software to Install" panel will appear. Using the up/down keys, move to the item(s) you wish to install and press
the F7 key. For Oracle 9.2.0.1, choose all filesets associated with "X11.adt", "bos.adt" (which includes "bos.adt.libm"),
 and "bos.compat".  After choosing all of your selections, press the "Enter" key.

12) Back in the "Install Software" panel, for the parameters on the left, input/select the values on the right (see example
below), (note the example below reflects values to commit the software installation, you might want to simply
"PREVIEW only" first to assure installation will succeed. (For the faint of heart)), then press "Enter". In the "ARE
YOU SURE?" confirmation window press "Enter". Wait a minth, and when the install finishes an reflects "OK", press
the F3 key until you return to the command prompt.

*********************  SMITTY SCREEN ******************************
 

                                Install Software

Type or select values in entry fields.
Press Enter AFTER making all desired changes.

                                                                                        [Entry Fields]
* LPP_SOURCE                                                          [lpp_source_gvt_aix513> +
* SOFTWARE to install                                                [X11.adt                      > +

    Customization SCRIPT to run after installation            []
        (not applicable to SPOTs)

installp Flags
  PREVIEW only? (install operation will NOT occur)           no                      +
  Preview new LICENSE agreements?                                no                      +
  ACCEPT new license agreements?                                   no                      +
  COMMIT software updates?                                            yes                     +
  SAVE replaced files?                                                        yes                     +
  AUTOMATICALLY install requisite software?                 yes                      +
  EXTEND file systems if space needed?                             yes                     +
  OVERWRITE same or newer versions?                            no                      +
  VERIFY install and check file sizes?                                  yes                     +
 

F1=Help             F2=Refresh          F3=Cancel           F4=List
F5=Reset            F6=Command          F7=Edit             F8=Image
F9=Shell            F10=Exit            Enter=Do
 
 
 
 
 

Installing From Machine sesni1

1) Create directory "/sesni" in root directory (i.e. "mkdir /sesni") and then mount a disk on sesni1 (i.e. "mount sesni1:/: /sesni"), change directories to "/sesni/inst.images/aix/5.1/510_lpp_source_MAINT3", and execute the command "smitty install_latest".

2) In the "Install Software" smitty panel, in the "INPUT device" field, enter a period ("."), and press "Enter".

3) In the next "Install Software" panel, in the "SOFWARE to install" field, press the F4 key (then wait a minth).

4) In the next panel, scroll down, and use the F7 key to select all filesets associated with "X11.adt", "bos.adt" (which includes "bos.adt.libm"), "bos.compat", and "App_Dev", then press "Enter".

5) For the parameters on the left, input/select the values on the right (see example below), then press "Enter". In the "ARE YOU SURE?" confirmation window press "Enter". Wait a minth, and when the install finishes "OK", press the F3 key until you return to the command prompt.

*********************  SMITTY SCREEN ******************************
 

                                Install Software

Type or select values in entry fields.
Press Enter AFTER making all desired changes.

                                                        [Entry Fields]
* INPUT device / directory for software               .
* SOFTWARE to install                                                [bos.compat]           +
  PREVIEW only? (install operation will NOT occur)           no                      +
  COMMIT software updates?                                            yes                     +
  SAVE replaced files?                                                        yes                     +
  AUTOMATICALLY install requisite software?                 yes                      +
  EXTEND file systems if space needed?                             yes                     +
  OVERWRITE same or newer versions?                            no                      +
  VERIFY install and check file sizes?                                  yes                     +
  Include corresponding LANGUAGE filesets?                    yes                     +
  DETAILED output?                                                         yes                     +
  Process multiple volumes?                                                yes                     +
  ACCEPT new license agreements?                                   no                      +
  Preview new LICENSE agreements?                                no                      +

F1=Help             F2=Refresh          F3=Cancel           F4=List
F5=Reset            F6=Command          F7=Edit             F8=Image
F9=Shell            F10=Exit            Enter=Do
 

6) Press the "F3" key until you return to the "Network Installation Management" panel, and  select "Install Software Bundle", then press "Enter".

7) From the "Install and Update Software" panel, select "Install Software" then press "Enter".

8) In the "Select the LPP_SOURCE containing the install images" section of the panel, select the lpp source for the
AIX maintenance level you wish to install (i.e. "lpp_source_gvt_aix513"), then press "Enter".

9) In the "Select the BUNDLE to use" portion of the panel, position the cursor at the "App-Dev" resource and press the "Enter" key.

10) In the "Install Software Bundle" panel, for the parameters on the left, input/select the values on the right (see example below), (note the example below reflects values to commit the software installation, you might want to simply "PREVIEW only" first to assure installation will succeed. (For the faint of heart)), then press "Enter". In the "ARE YOU SURE?" confirmation window press "Enter". Wait a minth, and when the install finishes an reflects "OK", press the F3 key until you return to the command prompt.

*********************  SMITTY SCREEN ******************************
 

                                Install Software

Type or select values in entry fields.
Press Enter AFTER making all desired changes.

                                                                                        [Entry Fields]
* LPP_SOURCE                                                          [lpp_source_gvt_aix513> +
* SOFTWARE to install                                                App-Dev

    Customization SCRIPT to run after installation            []
        (not applicable to SPOTs)

installp Flags
  PREVIEW only? (install operation will NOT occur)           no                      +
  Preview new LICENSE agreements?                                no                      +
  ACCEPT new license agreements?                                   no                      +
  COMMIT software updates?                                            yes                     +
  SAVE replaced files?                                                        yes                     +
  AUTOMATICALLY install requisite software?                 yes                      +
  EXTEND file systems if space needed?                             yes                     +
  OVERWRITE same or newer versions?                            no                      +
  VERIFY install and check file sizes?                                  yes                     +
 

F1=Help             F2=Refresh          F3=Cancel           F4=List
F5=Reset            F6=Command          F7=Edit             F8=Image
F9=Shell            F10=Exit            Enter=Do

(Note that currently, the "java.adt" fileset will fail due to it not being available).
 
 
 
 

Manual Setup Procedure

Before installing Oracle you must update your AIX operating system. Install filesets "bos.adt" (that includes "bos.adt.libm"), "bos.compat", and "X11.adt" on your system (Note that the normal NIM build only has part of these file sets installed, so you MUST complete all of this portion!) To install them follow the instructions in the section Installing Filesets Manually

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) Change "/home", "/tmp", and "/var" directory file sizes by executing the commands "chfs  -a  size='+4700000'  /home" and "chfs  -a  size='+300000'  /tmp", and chfs -a size='+1186950' /var (do not type the double quotes!)

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

4) Create the group "dba" (i.e. from the AIX command line, type "mkgroup -'A' users='root' adms='root' dba")

5) Create the group "oinstall" (i.e. from the AIX command line, type "mkgroup -'A' users='root' adms='root' oinstall")

6) Create the user "oracle" (i.e. from the AIX command line, type "mkuser -a pgrp='oinstall' groups='dba' home=/home/oracle shell=/usr/bin/ksh oracle"

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

8) Change the oracle password by typing "passwd oracle" at the AIX command line. When queried for new and confirm password enter "oracle" (no quotes) at the prompt.

9) Copy the ".profile.wea" file from "/WEA/inst.images/Oracle/oracle.9201.aix5L.64.bit/.profile" to the oracle users's home directory (i.e. "/home/oracle") as ".profile", and update your SID and DISPLAY variable -if necessary in your copied file.

10) Also from the AIX command prompt, change the file mode of the "/home/oracle" directory to "777" (i.e. "chmod 777 /home/oracle"), and change the group/owner of the oracle directory (i.e. "chown -R oracle:oinstall /home/oracle").

11) If installing from "/WEA/inst.images/Oracle", from the AIX command prompt, run the utility "rootpre.sh" which is in the Oracle installation directory at "WEA.inst.images/Oracle/oracle.9201.aix5L.64.bit/Disk1" (i.e. "./rootpre.sh"), then continue at Installing Oracle Software,otherwise, follow the following instructions for your particular installation source.

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.

If Installing Oracle From CD's

1) Change directories to the mounted disk and execute the command "rootpre.sh" (this should result in the display of output similar to Normal rootpre Output).

2) Continue at Installing Oracle Software
 

(OR)

If You Downloaded Oracle From Oracle Site

1) Change directories to the "Disk1" directory and execute the command "rootpre.sh" (this should result in the display of output similar to Normal rootpre Output).

2) Continue at Installing Oracle Software
 

(OR)

If You Got the Software From An IBM Internal Site

Mounted From wessun450

1) Change to the installation directory (i.e. "cd /mntOracle/oracle.9201.aix5L.64.bit/aix/Disk1") and execute the command "rootpre.sh" (this should result in the display of output similar to Normal rootpre Output).

2) Continue at Installing Oracle Software
 

(OR)

Mounted From shayden

The software currently resides on the network mounted drive directory "/WEA/inst.images/Oracle" as 2 disks, "Disk1" and "Disk2".

1) Change directories to "/WEA/inst.images/Oracle/Disk1" and execute the command "rootpre.sh" (this should result in the display of output similar to Normal rootpre Output).

2) Continue at Installing Oracle Software
 
 
 

Normal rootpre Output
 
 

(Note the following is the output of the execution of this command from SW from web site, and that the utility "crash" did not exist on this system, but something like the following should be displayed)

# ./rootpre.sh

Installing kernel extension...

 Oracle Kernel Extension Loader for AIX
       Copyright (c) 1998,1999 Oracle Corporation
 

Kernel Extension Version: 3

nkext ver: 3
./rootpre.sh[199]: crash:  not found.

 is not loaded : 1
No post-wait kernel is loaded on the machine.

          Copying new kernel extension.

 Oracle Kernel Extension Loader for AIX
       Copyright (c) 1998,1999 Oracle Corporation
 

Kernel Extension Version: 3

 Successfully loaded /etc/pw-syscall with kmid: 0x1b900e4
 Successfully configured /etc/pw-syscall with kmid: 0x1b900e4

Configuring Asynchronous I/O...
aio0 Available
aio0 changed
#
 
 
 
 

Other Oracle Installation Information

Oracle Apache Web Site Information
Oracle Information Web Sites
 

Oracle Apache Web Site Information

From Oracle9i panel:

The following information is available in:
/home/oracle/ORA9201/Apache/Apache/setupinfo.txt
----------------------------------------------------
The HTTPServer can be accessed using the following URLs

Non SSL Mode (executed at install time)
http://wea2aix7:7777

SSL Mode
http://wea2aix5:7778
https://wea2aix5:443

Logs on install in: "/home/oracle/oraInventory/logs/installActions2003......"
 

Oracle Information Web Sites

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

Automatic Setup Script

#-----------------------------------
# Oracle environment "root" user setup ONLY EXECUTE THIS ONCE!
#-----------------------------------
#
echo 'If you have not installed the prerequisite AIX software bundle "App-Dev", and filesets'
echo '(bos.compat, bos.adt, X11.adt), from another AIX window DO SO NOW.'
echo ' '
echo 'When these filesets are installed, press Enter'
echo ' '
read word1?""

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

# Change "/home" and "/tmp" file size and create directories for Oracle installation

chfs -a size='+4700000' /home
chfs -a size='+300000' /tmp
chfs -a size='+1186950' /var
echo 'Increased File size of /home directory by 4700000 512 Byte blocks,'
echo 'directory /tmp by 390000 512 Byte blocks, and /var by 1186950 512 Byte blocks'

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

# Create and configure Oracle group and user
mkgroup -'A' users='root' adms='root' dba
mkgroup -'A' users='root' adms='root' oinstall
echo 'The Oracle group dba has been created'
mkuser -a pgrp='oinstall' groups='dba' home=/home/oracle shell=/usr/bin/ksh oracle
echo ' '
echo 'Please change the oracle password, When queried for new and confirm password'
echo '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 /home/oracle directory
cd /home/oracle
mv .profile .profile.orig
cp /WEA/inst.images/Oracle/oracle.9201.aix5L.64.bit/.profile  .profile
chmod 777 /home/oracle
echo 'File mode has been changed for /home/oracle/.profile'
chown -R oracle:oinstall /home/oracle
echo 'Changed Owner of /home/oracle directory'
echo ' '

echo 'Running utility rootpre.sh from the Oracle installation directory at /WEA.inst.images/Oracle/oracle.9201.aix5L.64.bit/Disk1'
cd /WEA/inst.images/Oracle/oracle.9201.aix5L.64.bit/Disk1
./rootpre.sh
cd /

# 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
 
 
 
 
 

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 ctx_on of makefile /home/oracle/ORA9201/rdbms/lib/ins_rdbms.mk". File is there and it's mode is executable, and you had run the Install Filesets Manually. 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

sda.on              rdbms/lib/ins_rdbms.mk
dm.on               rdbms/lib/ins_rdbms.mk
olap.on               rdbms/lib/ins_rdbms.mk

And approx 20 others!
 
 
 
 

Installing Java 1.1.8 Manually

(Steve, I aint sure this has to happen. When you perform the following, there is no clear reflection of where the actual java is placed, so where do you tell the Oracle installer that the JRE/JDK is? When you last attempted to install Oracle, and told it "/usr/jdk1.1.8", it said it couldnt find it so you said to ignore it. Did Oracle install it anyway, even though you performed the following and the manual install of Java was successful?)

1) Change directories to "/WEA/inst.images/jdk1.1.8", and execute the command "smitty install_latest".

2) In the "Install Software" smitty panel, in the "INPUT device" field, enter a period ("."), and press "Enter".

3) In the next "Install Software" panel, press the F4 key, which will return a list of software packages.

4) Move the cursor to the "Java.rte" field and press the F7 key to select it, then press "Enter".

5) In the resulting smitty screen, for the parameters on the left, input/select the values on the right (see example below), then press "Enter". In the confirmation window press "Enter". Wait a minth, and when the install finishes "OK", press the F3 key until you return to the command prompt.
 

*********************  SMITTY SCREEN ******************************
 

                                Install Software

Type or select values in entry fields.
Press Enter AFTER making all desired changes.

                                                        [Entry Fields]
* INPUT device / directory for software               .
* SOFTWARE to install                                [Java.rte              > +
  PREVIEW only? (install operation will NOT occur)    no                      +
  COMMIT software updates?                            yes                     +
  SAVE replaced files?                                yes                     +
  AUTOMATICALLY install requisite software?           no                      +
  EXTEND file systems if space needed?                yes                     +
  OVERWRITE same or newer versions?                   no                      +
  VERIFY install and check file sizes?                yes                     +
  Include corresponding LANGUAGE filesets?            yes                    +
  DETAILED output?                                    yes                     +
  Process multiple volumes?                           yes                     +
  ACCEPT new license agreements?                      no                      +
  Preview new LICENSE agreements?                     no                      +

F1=Help             F2=Refresh          F3=Cancel           F4=List
F5=Reset            F6=Command          F7=Edit             F8=Image
F9=Shell            F10=Exit            Enter=Do
 
 
 
 

Installation of Windows Oracle Client

1) From Oracle web site "http://otn.oracle.com/software/products/oracle9i/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 Oracle9i 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 "Oracle9i 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 resides in "/db/app/oracle" (if you have followed the above instructions and used the automatic method of configuration).

#!/bin/ksh
PATH=/usr/ccs/bin:$PATH:/usr/local/bin
LIBPATH=:/usr/ccs/lib
LD_LIBRARY_PATH=:/usr/ccs/lib
DISPLAY=localhost:0.0
export DISPLAY
ORACLE_SID=ORA9201
export ORACLE_SID
ORACLE_BASE=/home/oracle
export ORACLE_BASE
ORACLE_HOME=/home/oracle
export ORACLE_HOME
ORACLE_OWNER=oracle
export ORACLE_OWNER
PATH=$ORACLE_HOME/bin:$PATH
LIBPATH=$ORACLE_HOME/lib:$LIBPATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
NLS_LANG=american_america.UTF8
export LIBPATH
export LD_LIBRARY_PATH
export PATH
export NLS_LANG
 
 
 
 

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=ORA9210".

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

5) When prompted, select Delete a database.

6) When prompted, select ORA9201.
 
 
 
 

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=ORA9201".

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 "ORA9201.(fully qualified hostname) (i.e. " ORA9201.wea2aix2.raleigh.ibm.com").

9) For Oracle SID, enter "ORA9201"

   2.Configure the database (see above)
 
 
 

Start/Stop the Database and Listener

   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=ORA9201
          To start the database, enter the following commands:

          $ svrmgrl

          SVRMGR> connect internal

          SVRMGR> startup

          SVRMGR> quit

          To stop the database, enter the following commands:

          $ svrmgrl

          SVRMGR> connect internal

          SVRMGR> shutdown

          SVRMGR> quit

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

          $ lsnrctl

          LSNRCTL> start

          LSNRCTL> quit

          To stop the listener, enter the following commands:

          $ lsnrctl

          LSNRCTL> stop

          LSNRCTL> quit

Setup Manager Information

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

Get Maintenance Level 2 Filesets

Oracle Prerequisites require "bos.adt.base", "bos.adt.lib", "bos.adt.libm",  and "bos.perf.perfstat".

Installed Maintenance Level 2 from /sesni/inst.images/aix/5.1/510_lpp_source_MAINT2
smitty install_latest

Or for AIX Mainentance level 1, the following fixes must be installed:

IY28111

AIX 5L release 5.1 ML01+ (IY22854), IY26778, IY28766, IY28949,
                 IY29965, IY30150
 
 
 

Or Get Maintenance Level 2 from Gary

Gary ftp'd the software from wea2aix6?, unzipped and untarred it, then created a table of contents (.toc), then installed the software.

"inutoc /usr/sys/inst.images"   (to create the table of contens from
"installp -axgXd /usr/sys/inst.images bos.rte.install"