Prerequisite
Check
Get The
Oracle Software
Installation
Preparation
Installing
Oracle Software
Installing
Oracle Database Application User Client
Installing
Oracle Database Administrator Client
Oracle
Configuration and Usage for WAS/WEA
Creating
And Using 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)
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"
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.
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/oracle8i/content.html").
3) Logon as "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 4 files, "aix64_db_817_64_Disk1.cpio.gz" and "aix64_db_817_64_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 aix64_db_817_64_Disk1.cpio.gz
gunzip aix64_db_817_64_Disk2.cpio.gz
cpio -idcmv < aix64_db_817_64_Disk1.cpio
cpio -idcmv < aix64_db_817_64_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"
(OR)
From shayden
The software currently resides on the network mounted drive directory
"/WEA/inst.images/Oracle" as 2 disks, "Disk1" and "Disk2".
The majority of the remainder of these instructions assume you are connected to a network server, however, you can also perform the installation from a mounted CD. 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"), 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, CD, or mounted network drive). If you wish to perform all of these steps manually, see the section Manual Setup Procedures.
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
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.
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 - oracle8"), 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 CD, from the root ("/") directory, run the script "runInstaller" (i.e. "/mntOracle/runInstaller"). If installing from the wessun450 server, change directories to "/mntOracle/oracle817/aix/Disk1" and from the command line execute the script "runInstaller". If installing from shayden directory, change directories to "/WEA/inst.images/Oracle/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) 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 "File Locations" panel, accept the defaults, and click "Next" (Source = "(yourinstalldisk)/stage/products.jar", and Destination = "/db/app/oracle/products/8.1.7/OraHome1", (or whatever you specifed as your Oracle Home, which is currently set by the .profile which was copied from /WEA/inst.images/Oracle).
6) In the "UNIX Group Name" panel, enter the value "dba", then click "Next". (a pop should appear stating do something as root, follow the instructions, and click "Retry").
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 "Retry").
8) In the "Available Products" panel, select "Oracle8i Enterprise Edition 8.1.7.0.0", then click "Next".
9) In the "Installation Types", select "Typical", then click "Next", and wait a minth (this takes 1.30 GB of space!).
10) In the "Choose JDK Home Directory", enter "/usr/bin/java" click "Next" (JDK Home was "/opt/java".)
12) In the "Database Identification" panel, in the 'Global Database Name" field, enter "wes430." followed by the fully qualified name of the host you are installing on (i.e. "wes430.wea2aix2.raleigh.ibm.com" (the "SID" field should reflect "wes430"), then click "Next". (see note above about the SID value in the Automatic Setup Script)
13) In the "Database File Location" panel, in the "Directory for Database Files" field, enter "/db/dbfiles", then click "Next".
14) In the "Summary" panel, review your installation specifics (149 products, including "Starter Database") and click "Install". Wait a minth.(note, the installer says it is going to install the JRE 1.1.8, as well as later, the progress panels reflected it was installing it).
A summary log will be created in "/home/oracle/oraInventory/logs/installActions.log". If another Oracle product or upgrade is installed, this file will be copied to "/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
15) 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 /db/app/oracle/products/8.1.7/OraHome1/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 Oracle8 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /home/oracle/OraHome1
ORACLE_SID= WEA430
Enter the full pathname of the local bin directory: [/usr/local/bin]: (author pressed "Enter")
Creating /etc/oratab file...
Entry will be added to the /etc/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.
#
16) In the "Net8 Configuration Assistant: Welcome" window, DO NOT select "Perform typical configuration", click "Next".
17) In the "Net8 Configuration Assistant: Directory Service Access", select "No,..." and click "Next".
18) In the "Net8 Configuration Assistant: Listener Configuration, Listener Name" panel, accept the default "Listener Name: LISTENER", and click "Next".
19) In the "Net8 Configuration Assistant: Listener Configuration, Select Protocols" panel, accept the default "Selected Protocols" "TCP", then click "Next".
20) In the "Net8 Configuration Assistant: Listener Configuration, TCP/IP Protocol" panel, accept the default "Use the standard port number of 1521", then click "Next".
21) In the "Net8 Configuration Assistant: Listener Configuration, More Listeners?" panel, select "No" and click "Next".
22) In the "Net8 Configuration Assistant: Listener Configuration, Configuration Done" panel, click "Next".
23) In the "Net8 Configuration Assistant: Naming Methods Configuration" panel, select "No" and click "Next".
24) In the "Net8 Configuration Assistant: Done" panel, click "Finish".
25) 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: was40.raleigh.ibm.com
database
system Identifier (SID):was40
SYS
account password: change_on_install.
SYSTEM
account password: manager"
Click "OK".
26) In the "End of Installation" panel, the display should reflect "The installation of Oracle8i Enterprise Edition was successful.".
27) Make a backup copy of the "root.sh" file. If you install additional components, this file will be overwritten. Change directories to "/db/app/oracle/products/8.1.7/OraHome1", 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 (recommended) 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 Databse 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 = "/db/app/oracle/products/8.1.7/OraHome1", (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 "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).
1) In the "File Locations" panel, accept the defaults, and click "Next" (Source = "(yourinstalldisk)/stage/products.jar", and Destination = "/db/app/oracle/products/8.1.7/OraHome1", (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 "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)
Oracle Configuration and Usage for WAS/WEA
This section will undoubtedly be changed as the design matures for WEA installation on AIX using Oracle database. 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) Switch user to the oracle account (i.e. "su - oracle").
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", "Enter user-name:"
3) When prompted by "Enter user-name", enter "SYSTEM", and for the "Enter
password", enter "manager".
Create Users for WAS
Create users with dba athority
1) After performing the "Logon to Oracle as SYSTEM", execute the command "create user EJSADMIN identified by ejsadmin;" and press "Enter". (This will create the user "EJSADMIN" with password "ejsadmin".)
2) From the command line type "grant connect, resource, dba to EJSADMIN;" and press "Enter" (This will grant rights to this account).
3) From the command line type "create user EJB identified by ejb;" then press "Enter" (This will create the user "EJB" with password "ejb").
4) From the command line type "grant connect, resource to EJB;" (This will grant rights to this account).
5) Exit from the sqlplus utility by typing "quit" and press "Enter".
6) Test access to the new database with the EJSADMIN user ID by entering the following commands.
$ sqlplus EJSADMIN/ejsadmin
SQL> quit
7) Your user has been successfully created and tested.
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 /db/app/oracle/oradata/slapit. 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 - oracle8".
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).
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.
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 - oracle8 -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 - oracle8 -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 directory lsnrctl was in and execute it there first (/db/app/oracle/products/8.1.7/OraHome1/bin/lsnrctl):
$ 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
(OR, a script file which does it should contain:)
#!/bin/ksh
su - oracle8 -c "lsnrctl stop"
#!/bin/ksh
su - oracle8 -c "lsnrctl start"
(OR, a script file which restarts it should contain:)
#!/bin/ksh
su - oracle8 -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 - oracle8 (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;
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_GA", 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 "X11.adt", "bos.adt" (which includes "bos.adt.libm"), and "bos.compat", 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
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 "/" and "/db" directory file size by executing the commands "chfs -a size='12000000' /" and "chfs -a size='6000000' /db" (Steve there was no /db, so changed / by 12000000) (do not type the double quotes!)
3) Create directories "/db/dbfiles", "/db/app/oracle/products/8.1.7/OraHome1", and "/usr/bin/java" for Oracle installation (i.e "mkdir -p /db/dbfiles", "mkdir -p /db/app/oracle/products/8.1.7/OraHome1", and "mkdir -p /usr/bin/java")/
4) Create Oracle group by typing the command "mkgroup -a dba"
5) Create user "oracle8", by typing the command "mkuser -a pgrp=dba home=/db/app/oracle shell=/usr/bin/ksh oracle8".
) As root, change the " /db/app/oracle" directory structure permissions ("chmod 777 ."), and change it's ownership (i.e. "chown -R oracle:dba /db/app/oracle".
5) Copy the ".profile.wea" file from /WEA/inst.images/Oracle" to the
oracle users's home directory as ".profile", and update your SID if necessary
in your copied file.
Setup Root Environment For Oracle
A group and a user must be set up for the Oracle installation
Manually Create Groups and Users for Oracle
1) Create the group "dba" (i.e. "mkgroup -a dba" at command line)
2) Using the "smitty" tool, add a user. "User NAME" is "oracle8", "Primary Group" is "dba", "HOME directory" is "/db/app/oracle", and "Initial Program" is "/usr/bin/ksh".. (or from thecommand line execute the command "mkuser -a pgrp=dba home=/db/app/oracle shell=/usr/bin/ksh oracle8").
3) Change the oracle8 password by typing "passwd oracle8" at the AIX
command line. When queried for new and confirm password enter "oracle"
(no quotes) at the prompt.
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/oracle817/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
(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
http://wespoint/wes/wes_tpsmoracle.html
http://shayden/instorawas.html
#-----------------------------------
# Oracle environment "root" user setup ONLY EXECUTE THIS ONCE!
#-----------------------------------
#
echo 'If you have not installed the prerequisite AIX filesets (bos.compat,
'
echo 'bos.adt, and X11.adt), from another AIX window DO SO NOW. Filesets
are'
echo 'mounted at /sesni/inst.images/aix/5.1/510_lpp_source_GA'
echo 'When these filesets are installed, press Enter'
echo ' '
cd /;mkdir sesni;mount sesni1:/: /sesni
read word1?""
# Setup xhost to allow windowing to behave properly
xhost +
echo 'Windowing (xhost) has been set up'
# Change "/" file size and create directories for Oracle installation
chfs -a size='6000000' /
chfs -a size='6000000' /db
echo 'Changed File size of / and /db directories to 6000000'
mkdir -p /db/dbfiles
mkdir -p /db/app/oracle/products/8.1.7/OraHome1
mkdir -p /usr/bin/java
echo 'Created directories app and dbfile in /db directory and /usr/bin/java'
# Create and configure Oracle group and user
mkgroup -a dba
echo 'The Oracle group dba has been created'
mkuser -a pgrp=dba home=/db/app/oracle shell=/usr/bin/ksh oracle8
echo ' '
echo 'Changing the oracle8 password, when queried for new and confirm
password'
echo 'type in the string "oracle" (no quotes) at the prompt'
echo ' '
passwd oracle8
echo 'The Oracle user oracle8 has been created and password set'
# Copy a new .profile to /db/app/oracle and change it's file mode,
# change file mode for directories in "/db/app/oracle", and change
# owner of /db directory
cd /db/app/oracle
mv .profile .profile.orig
cp /WEA/inst.images/Oracle/.profile.wea .profile
chmod 755 .profile
echo 'File mode has been changed for /db/app/oracle/.profile'
chown -R oracle8:dba /db
echo 'Changed Owner of /db directory'
echo ' '
echo ' '
# There are three options on installing the software, wessun450,
# /WEA/inst.images/Oracle/Disk1, and from CDs. Uncomment the lines
for desired method
mkdir /mntOracle
# Option 1 - Mount the /export/home5 directory on wessun450 to access
Oracle software
# The following 3 lines are for when you wish to install from wessun450
## echo 'Running utility rootpre.sh from the Oracle build on wessun450'
## mount -o ro wessun450:/export/home5 /mntOracle
## cd /mntOracle/oracle817/aix/Disk1
# Option 2 - Install the software from /WEA/inst.images/Oracle/Disk1
# The following 2 lines are for when you wish to install from /WEA/inst.images/Oracle
## echo 'Running utility rootpre.sh from the Oracle build on /WEA/inst.images/Oracle/Disk1'
## cd /WEA/inst.images/Oracle/Disk1
# Option 3 - Install the software from CDs
# The following 2 lines are for when you wish to install from CDs
echo 'Running utility rootpre.sh from the Oracle build on CDs'
mount -o ro -v cdrfs /dev/cd0 /mntOracle
cd /mntOracle
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
(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
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/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 Oracle8 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=was40
export ORACLE_SID
ORACLE_BASE=/db/app/oracle
export ORACLE_BASE
ORACLE_HOME=/db/app/oracle/products/8.1.7/OraHome1
export ORACLE_HOME
ORACLE_OWNER=oracle8
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 oracle8 by entering the following command "su - oracle8".
3) If not set in the .profile, enter "export ORACLE_SID=was40".
4) Invoke the Database Assistant from the command prompt (i.e. enter "dbassist").
5) When prompted, select Delete a database.
6) When prompted, select was40.
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 oracle8 by entering the command "su - oracle8".
3) If not set in the .profile, enter "export ORACLE_SID=was40".
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 "was40.(fully qualified hostname) (i.e. " was40.wea2aix2.raleigh.ibm.com").
9) For Oracle SID, enter "was40"
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 oracle8 by entering the following command:
su - oracle8
If not set in
the .profile, enter export ORACLE_SID=was40
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 oracle8 by entering the following command:
su - oracle8
If not set in
the .profile, enter export ORACLE_SID=was40
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:
was40
Database Server
Name: (local/remote hostname).raleigh.ibm.com
Database Home:
(value of $ORACLE_HOME
Usually /db/app/oracle/products/8.1.7/OraHome1
Database URL:
jdbc:oracle:thin:@(local/remote
hostname).raleigh.ibm.com:1521:was40
Database Port:
1521
EJSADMIN Password:
ejsadmin