Prerequisite
Check
Get The
Oracle Software
Installation
Preparation
Installing
Oracle Software
Oracle
Configuration and Usage for WAS/WEA
Installing
WAS With Oracle Installation Instructions
Installing
Oracle Database Application User Client
Installing
Oracle Database Administrator Client
Installing
Filesets Manually
Manual Setup
Procedure
Creating
And Using An Oracle Database
Miscellaneous
Oracle Utilities and Commands
Other
Oracle Installation Information
Installation
of Windows Oracle Client
Oracle
Automatic Install Script
Oracle Administrator
Profile (.profile)
Installing
Java 1.1.8 Manually
Error Conditions
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". Three Gigabytes should be sufficient).
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"). Also, the command "oslevel
-r" should reflect "5100-03"
The software can be installed from the WEA Test Dept "/WEA/inst.images"
mounted disk, from CDs, downloaded from Oracle's web site, as well as resides
on several internal IBM servers which can be mounted for your use.
From /WEA/inst.images
The software currently resides on the network mounted drive directory "/WEA/inst.images/Oracle/oracle.817.aix32.bit" as 2 disks, "Disk1" and "Disk2". (which is normally already mounted in the WEA Test Dept NIM images).
(OR)
Installing Oracle From CD's
1) Install the Oracle CD1 in the CD drive and then mount the CD (i.e.
"mkdir /mntOracle && mount -o ro -v
cdrfs /dev/cd0 /mntOracle"). Note, IT IS IMPORTANT that if you use
this method you execute the installer from the root directory (i.e. "/mntOracle/runInstaller"),
otherwise, when you are instructed to change disks, and you have executed
a program that is still running from that disk, you will not be able to
unmount the CD 1 to insert CD 2..
(OR)
Download Oracle From Oracle Site
1) Create and change to a directory to perform your installation from (i.e. /tmp/installOracle").
2) Connect to "www.oracle.com" (or "http://otn.oracle.com/software/products/oracle8i/content.html").
3) Create an account, then logon as the created account (the authore used "shayden@ipass.net" with the appropriate password), and then download the 8.1.7.0.0 version of Oracle to the directory you created in step 1. It is actually 4 files, "aix64_db_817_32_Disk1.cpio.gz" and "aix64_db_817_32_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_32_Disk1.cpio.gz
gunzip aix64_db_817_32_Disk2.cpio.gz
cpio -idcmv < aix64_db_817_32_Disk1.cpio
cpio -idcmv < aix64_db_817_32_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"
These instructions assume you are connected to a network, have the "/WEA" disk mounted, and are using a WEA Test Dept NIM AIX OS image. 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.
Although these instructions assume you are installing from the "/WEA" disk, you can also perform the installation from a mounted CD. They also assume you are at the console for the machine, or are using DSView (if not, you must execute the command "xhost +" at the console for this machine). Whether installing from a network server or CD, there are two methods available for your installation of Oracle, a "Oracle Automatic Install", and a "Manual Setup Procedure". For the "Oracle Automatic Install", there are AIX commands contained in an Oracle Automatic Install Script (file "OracleRootWEA" located at "/WEA/inst.images/Oracle/oracle.817.aix32.bit"), which automatically perform the majority of the setup required by the root user (if using the CD method, insert the CD before executing the Automatic Setup Script). Also, the script (as well as the Manual Setup Procedure) copies over a ".profile" file which contains the "SID" for your database. You must assure that after copying this file, the file is updated to the appropriate DISPLAY variable, and your SID (if you do not use the example SID in the following instructions). You can modify this script to reflect which method you use for accessing the Oracle installation software (web, CD, or mounted network drive). If you wish to performs all of these steps manually, see the section Manual Setup Procedure.
Once the Automatic Setup Script has been run, or you perform the steps
manually, 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 (i.e. if the "Oracle Universal Installer" window pops up informing you to execute the "orainstRoot.sh" script, follow the instructions and do so, then click "Retry").
1) Switch users to "oracle" (i.e. "su - oracle"), and from the AIX command line, if you have not modified your ".profile" to reflect the correct machine to output the Oracle installation GUI, export your DISPLAY variable, reflecting your machine (i.e. "export DISPLAY=wea2aix1.raleigh.ibm.com:0.0").
2) If installing from the "/WEA/inst.images" mounted disk, change directories to "/WEA/inst.images/Oracle/oracle.817.aix32.bit/Disk1" and from the command line execute the script "./runInstaller". If installing from CD, from the root ("/") directory, run the script "runInstaller" (i.e. "/mntOracle/runInstaller"). If installing from the wessun450 server, change directories to "/mntOracle/oracle817/aix/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 = "/home/oracle/ORA817", (or whatever you specifed as your Oracle Home, which is currently set by the .profile which was copied from /WEA/inst.images/Oracle/oracle.817.aix32.bit).
6) In the "UNIX Group Name" panel, enter the value "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 "Retry"). (Output of this execution is "Creating Oracle Inventory ponter file (/etc/oraInst.loc) Changing groupname of /home/oracle/oraInventory to oinstall.)
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 (which states it takes 1.33 GB of space!).
10) In the "Choose JDK Home Directory", enter "/usr/bin/java" click "Next" (JDK Home was "/opt/java".)
11) In the "Database Identification" panel, in the 'Global Database Name" field, enter "ORA817." followed by the fully qualified name of the host you are installing on (i.e. "ORA817.wea2aix1.raleigh.ibm.com" (the "SID" field should reflect "ORA817"), then click "Next". (see note above about the SID value in the Automatic Setup Script)
12) In the "Database File Location" panel, in the "Directory for Database Files" field, enter "/home/oracle/dbfiles", then click "Next".
13) In the "Summary" panel, review your installation specifics (149 products, including "Starter Database", total of 1.27GB) 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 popup.
14) 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/ORA817/root.sh as root from another window, then come back here and click OK to continue". When you execute "root.sh", you will be queried to "Enter the full pathname of the local bin directory: [/usr/local/bin]:", accept the default and press Enter. Back in the Oracle installer GUI "Setup Privileges" popup, click "OK" ("/usr/local/bin" was then created by the installer).
The dialog from this step was:
#root.sh
Running Oracle8 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /home/oracle/OraHome1
ORACLE_SID= ORA817
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.
#
Eventually you will be presented with the ""Net8 Configuration Assistant:
Welcome" window. You can select "Perform typical
configuration" (recommended) or 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".
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: ORA817.wea2aix1.raleigh.ibm.com
database
system Identifier (SID):ORA817
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 Oracle8i Enterprise Edition was successful.".
3) If you install additional components, the file "root.sh" will be overwritten. Change directories to "/home/oracle/ORA817", and execute the command "cp root.sh root.sh.afterinstall".
At this point you can either exit the installer and perform the Oracle
Configuration and Usage for WAS/WEA 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: ORA817.wea2aix1.raleigh.ibm.com
database
system Identifier (SID):ORA817
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 Oracle8i 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/ORA817", and execute the command "cp root.sh root.sh.afterinstall".
At this point you can either exit the installer and perform the Oracle
Configuration and Usage for WAS/WEA 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.
Oracle Configuration and Usage for WAS/WEA
This section might be changed as the design matures for WEA installation on AIX using Oracle database. The following describes the full set of accounts required for a full WEA installation.
1) You must modify the file "/etc/environment" file to include the following line:
ORACLE_HOME=/home/oracle/ORA817
2) Once this file has been modified you must log off and back on your
machine to instantiate this environment variable
1) Switch user to the oracle account (i.e. "su - oracle").
The following users and priviliges can be created manually (see Creating
WEA Users Automatically), or all can be added automajically by
using the appropriate script (see Creating
WEA Users Manually)
Creating WEA Users Automatically
1) Change directories to "/WEA/inst.images/Oracle/oracle.817.aix32.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/manager". (this results in the text "SQL*Plus: Release 8.1.7.0.0 - Production on (date/time stamp of installation) (c) Copyright 2000 Oracle Corporation. All rights reserved".
3) ) 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, then type "quit".
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.
Content Of WEAUsers.sql
The following is the content of the file which you can use to automatically add all users necessary for a full install of WEA:
-- SQL script file to create users in the Oracle
DB
-- Can be used by WEA to create, users for all
WEA components
-- and grant appropriate privileges
-- From SQL*PLUS run this script as "@user.sql"
--
create user EJSADMIN identified by EJSADMIN;
grant connect,resource,dba to EJSADMIN;
create user EJB identified by EJB;
grant connect,resource,dba to EJB;
create user WPS identified by WPS;
grant connect,resource,dba to WPS;
create user WMS identified by WMS;
grant connect,resource,dba to WMS;
create user WEA identified by WEa;
grant connect,resource,dba to WEA;
create user WPSPCO identified by WPSPCO;
grant connect,resource,dba to WPSPCO;
create user ESSADMIN identified by ESSADMIN;
grant connect,resource,dba to ESSADMIN;
create user INSUSER identified by INSUSER;
grant connect,resource,dba to INSUSER;
create user DMS identified by DMS;
grant connect,resource,dba to DMS;
create user ATLAS identified by ATLAS;
grant connect,resource,dba to ATLAS;
1) From the command prompt execute the command "sqlplus". (this results
in the text "SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jan 8
10:53:26 2003 (c) Copyright 2000 Oracle Corporation. All
rights reserved".
2) When prompted by "Enter user-name", enter "SYSTEM", and for the "Enter password", enter "manager".
(OR)
(alternatively, from the Oracle user's command line type "sqlplus SYSTEM/manager")
3) Execute the following commands, each followed by pressing the "Enter"
key:
create user EJSADMIN identified by EJSADMIN;
grant connect,resource,dba to EJSADMIN;
create user EJB identified by EJB;
grant connect,resource,dba to EJB;
create user WPS identified by WPS;
grant connect,resource,dba to WPS;
create user WMS identified by WMS;
grant connect,resource,dba to WMS;
create user WEA identified by WEA;
grant connect,resource,dba to WEA;
create user WPSPCO identified by WPSPCO;
grant connect,resource,dba to WPSPCO;
create user ESSADMIN identified by ESSADMIN;
grant connect,resource,dba to ESSADMIN;
create user INSUSER identified by INSUSER;
grant connect,resource,dba to INSUSER;
create user DMS identified by DMS;
grant connect,resource,dba to DMS;
create user ATLAS identified by ATLAS;
grant connect,resource,dba to ATLAS;
4) Exit from the sqlplus utility by typing "quit" and press "Enter".
5) Test access to the new database with the EJSADMIN user ID by entering the following commands.
$ sqlplus EJSADMIN/ejsadmin
SQL> quit
6) Your users have been successfully created and tested. Proceed with
WEA installation.
Installing WAS With Oracle Installation Instructions
You must first create the appropriate users with associated priviledges before performing this installation. Follow the instructions in the section Oracle Configuration and Usage for WAS/WEA.
When installing WAS, if you are using Oracle, perform the following steps in the Database Options dialog:
1). In the Database Type field, select Oracle from the pull-down menu.
2) Ensure that Remote DB is not selected. For this example, the database and WebSphere Application Server are installed on the same node.
3). In the Database Name (Database SID) field, type the name of the Oracle database you created. For example, ORA817. machine_name.
4) In the DB Home field, type the full pathname of the directory you created to contain the Oracle software and to be the home directory of the user named oracle, or specify the full path name of the directory by using the Browse button. This path should also be the value of the ORACLE_HOME environment variable.
5) In the DB URL field, accept the default value jdbc:oracle:thin:@fully_qualified_domain_name : port_number : database_name, or specify a different URL for accessing the database.
6) In the Server Name field, type the name of the machine on which the database is installed.
7) In the Port Number field, type the port number used to access the database.
8) In the Database User ID field, type the name of the database owner, EJSADMIN .
9) In the Database Password field, type the current password for the database owner.
10) Click Next to continue.
Installing Oracle Database Application User Client
You will need to have followed the appropriate above previous instructions for setting up the Oracle environment for installation, i.e. Prerequisite Check, Installation Preparation, Get the Oracle Software, and steps 1-6 of Install Oracle Software for the following steps to succeed (Or, if you have already installed Oracle and are still in the GUI, from another AIX window, as root, unmount the CD 2, mount the CD1, and then click the "Next Install" button).
1) In the "File Locations" panel, accept the defaults, and click "Next" (Source = "(yourinstalldisk)/stage/products.jar", and Destination = "/home/oracle/ORA817", (or whatever you specifed as your Oracle Home, which is currently set by the .profile you copied from "/WEA/inst.images/Oracle/oracle.817.aix32.bit". 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 = "/home/oracle/ORA817", (or whatever you specifed as your Oracle Home, which is currently set by the .profile you copied from "/WEA/inst.images/Oracle/oracle.817.aix32.bit").
2) In the "Available Products" panel, select "Oracle8i Client 8.1.7.0.0", then click "Next".
3) In the "Installation Types" panel, select "Administrator", then click "Next".
4) In the "Summary" panel, click "Install". (note a message was displayed "Deinstalling Client".)
5) In the "End of Installation" panel, click "Exit" (OR, choose to install
other Oracle software)
Creating And Using An Oracle Database
1) After performing the "Logon to Oracle as SYSTEM", execute the command "dbassist", which will invoke the Oracle Database Configuration Assistant.
2) In the Welcome panel, select the "Create a database" option, then click "Next".
3) In the "Select the type of database to create" panel, select "Typical" and click "Next".
4) Select "Copy Existing database files from the
CD", then click "Next".
Option 1 - Copy Existing database files from the CD"
1) In the "An Oracle8i databases is uniquely identified by a Global Database Name...", "Global Database Name" field enter "slapit.raleigh.ibm.com" (which will automatically create the SID as "slapit"), then click "Finish".
2) An alert will be displayed reflecting "The datafiles will be copied from the CD to /home/oracle/ORA817/oradata/slapit.(STEVE?) The Oracle Database Configuration Assistant wil begin creating the database. Do you want to proceed", click "Yes".
3) An additional alert will be displayed "An Oracle databse will be created for you. The database name will be slapit. The system identifier for the database will be slapit. The password for the SYS account will be change_on_install and the SYSTEM account will be manager" click "OK".
4) Final alert will be displayed in dialog box "Oracle Database Configuration Assistant Alert" containing:
Database creation completed.
Database Information:
global database name:
slapit.wea2aix1.raleigh.ibm.com
database system identifier
(SID): slapit
SYS account password"
change_on_install
SYSTEM account password:
manager
5) Click "OK" in the alert box.
6) From command prompt type "sqlplus system/manager@STEVEZ" and press "Enter".
7) Your database has been created and should be available for population
of tables, etc.
Using an Oracle Database
1) When the database creation utility had completed, from the AIX command prompt, type "su - oracle".
2) From the Oracle prompt ("$"), executed the sqlplus command giving the appropriate id/password and SID (i.e. "sqlplus system/manager@slapit").
(Note that "Ctrl" and Backspace key are the delete/rubout key.)
3) From the SQLPLUS command prompt, list data from your tables (i.e. "select * from scott.emp") which will display all rows in the SCOTT schema's "emp" table. (Note that whenever you use DBASSIST to create a database and select "Copy Existing database files from the CD", it automatically creates a "SCOTT" schema.
4) To describe the columns of an table, use the "describe" command (i.e. "describe scott.emp").
5) Do normal creation of tables, insert rows, etc.
6) To list the tables, use the command "select * from tab". This will list all tables, as well as your tables should be in the list.
7) To list only the tables for a particular user/owner (i.e. "SCOTT"),
type the command "select TABLE_NAME from ALL_TABLES where OWNER='SCOTT'"
(do not include the beginning and ending double quote (")).
(Schema Table Scott emp)
Using The NetAssist Utility
1) From the Oracle command prompt ("$"), type "netasst".
2) In the Net8 Assistant GUI, scope down through "Net8 Configuration",
"Local", "Service Naming", and select your "slapit" service. The right
panel will display details of this service, (including Port Number).
Miscellaneous
Oracle Utilities and Commands
Start/Stop the Database
1.To start or stop the Oracle database:
Log in as the
user oracle by entering the following command:
su - oracle
If not set in
the .profile, enter export ORACLE_SID=was40
To start the
database, enter the following commands:
$ svrmgrl
SVRMGR> connect internal
SVRMGR> startup SVRMGR
SVRMGR> quit
To stop the database, enter the following commands:
$ svrmgrl
SVRMGR> connect
internal
SVRMGR> shutdown
SVRMGR> quit
Starting Database
Start the database by entering the following commands:
$ svrmgrl SVRMGR
> connect internal SVRMGR
> startup SVRMGR
> quit
(OR, Starting Database)
$ svrmgrl
SVRMGR> connect internal
Connected.
SVRMGR> startup
ORACLE instance started.
Total System Global Area
7275404 bytes
Fixed Size
73620 bytes
Variable Size
55730176 bytes
Database Buffers
16777216 bytes
Redo Buffers
172032 bytes
Database mounted.
Database opened.
SVRMGR> help blah blah.....
SVRMGR> quit
(OR, a script which performs this contains:)
#!/bin/ksh
su - oracle -c '
echo "Enter sid name (like ispb): "
read sid
PMON=`ps -ef | egrep pmon_${sid} | grep -v grep`
if [ "${PMON}" = "" ]
then
echo "starting Oracle"
# database still running, shut it down first
ORACLE_SID=$sid
sqlplus /nolog <<!
connect internal
startup
!
else
echo "Oracle already running"
fi
'
Stopping Database
$ svrmgrl
SVRMGR> connect internal
Connected.
SVRMGR> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
(OR, a script which performs this contains:)
#!/bin/ksh
su - oracle -c '
echo "Enter sid name (like ispb):"
read sid
PMON=`ps -ef | egrep pmon_${sid} | grep -v grep`
if [ "${PMON}" != "" ]
then
echo "stopping Oracle"
# database still running, so we can shut it down
ORACLE_SID=$sid
sqlplus /nolog <<!
connect internal
shutdown immediate
!
else
echo "Oracle not running"
fi
'
Starting and Stopping Listener
Starting and stopping the listener is done by the utility "lsnrctl". Usage follows (note the author occasionally had to go the the directory lsnrctl was in and execute it there first (/home/oracle/ORA817/bin/lsnrctl):
1) Log in as the user oracle by entering the command "su - oracle"
2) If not set in the .profile, enter export ORACLE_SID=was40
3) To stop/start the listener, enter the following commands:
$ lsnrctl
LSNRCTL for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production
on 17-JAN-2003 17:29:26
blah blah blah
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=wea2aix2.raleigh.ibm.com)(PORT=1521)))
-------------------------------------
Alias
LISTENER
Version
TNSLSNR for IBM/AIX blah
Start Date blah blah
LSNRCTL> stop
LSNRCTL> start
LSNRCTL> quit
(OR, a script file which does it should contain:)
#!/bin/ksh
su - oracle -c "lsnrctl stop"
#!/bin/ksh
su - oracle -c "lsnrctl start"
(OR, a script file which restarts it should contain:)
#!/bin/ksh
su - oracle -c "lsnrctl reload"
Adding Oracle Automatic Startup To "inittab"
From command line type:
mkitab "oradb:2:wait:/bin/su oradb -c|/$ORACLE_HOMES/bin/dbstart"
Deleting the WebSphere Application Server Database
1) Ensure that you have run the xhost command and have exported your DISPLAY. See above for details.
2) Log in as the user oracle by entering the following command "su - oracle".
3) If not set in the .profile, enter "export ORACLE_SID=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 oracle by entering the command "su - oracle".
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 "ORA817"
2.Configure the database (see above)
Setup Manager Information
1.On the WebSphere Application Database configuration screen:
Database Name:
was40 (STEVE?)
Database Server
Name: (local/remote hostname).raleigh.ibm.com
Database Home:
(value of $ORACLE_HOME
Usually /home/oracle/OraHome1
Database URL:
jdbc:oracle:thin:@(local/remote
hostname).raleigh.ibm.com:1521:was40
Database Port:
1521
EJSADMIN Password:
ejsadmin
Miscellaneous sqlplus Commands
ALTER USER USERNAME IDENTIFIED BY PASSWORD;
Change password for "USERNAME" to "PASSWORD"
Miscellaneous SQL Commands
show all
Show Oracle environment settings
show user
Displays the current user
To use sqlplus on the client machine, type:
su - oracle (or whatever your oracle username is)
sqlplus stage_user/oracle@alias (alias is your database
name, it could be something like WEA)
(i.e. "sqlplus system/manager@wea430")
List tables: select table_name from user_tables;
Describe columns in table: describe <table_name>;
Output to command line: echo "SELECT trxn_status FROM tsmtransaction
where username='X';" | sqlplus stage_user/oracle@WEA
(The column and table names mentioned throughout this section were
actuals from a previous test)
Example: echo "select order_state, auth_status from cust_order where
user_id in (select user_id from piauthuser where username='KMC3_IN');"
| sqlplus stage_user/oracle@wea
List connections to database (like list applications on DB2):
sqlplus stage_master/oracle@wea
SQL> SELECT username, status FROM v$session;
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 filsets 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" 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 "Install Software" panel, the cursor should be positioned at the "Software to Install" field, press the F4 key.
6) 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 8.17, 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.
7) 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"), 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 "/home" and "/tmp" directory file sizes by executing the commands "chfs -a size='+4700000' /home", and "chfs -a size='+300000' /tmp" (do not include the double quotes!).
3) Create directories "/home/oracle" and "/usr/bin/java" for Oracle installation (i.e "mkdir -p /home/oracle", "mkdir -p /usr/bin/java")/
4) Create Oracle "dba" and "oinstall" groups by typing the commands "mkgroup -'A' users='root' adms='root' dba", and "mkgroup -'A' users='root' adms='root' oinstall".
5) Create user "oracle", by typing the command "mkuser -a pgrp='oinstall' groups='dba' home=/home/oracle shell=/usr/bin/ksh oracle".
6) Change the Oracle user password by executing the command "passwd oracle". You will be queried for new password and confirmation, enter "oracle" for both.
7) Copy the file ".profile" from /WEA/inst.images/Oracle/oracle.817.aix32.bit" to the oracle users's home directory (i.e. "/home/oracle") as ".profile", and update your DISPLAY variable and your SID if necessary in the copied file.
8) As root, change the "/home/oracle" directory structure permissions ("chmod -R 777 /home/oracle"), and change it's ownership (i.e. "chown -R oracle:dba /home/oracle").
At this point you should have confirmed you have the prerequisite software, and have obtained the Oracle software using the technique you desire. As mentioned before, the software can be installed from CDs, downloaded from Oracle's web site, as well as resides on several internal IBM servers which can be mounted for your use.
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: 0x201965c (or something
similar)
Successfully configured /etc/pw-syscall
with kmid: 0x201965c (or something similar)
Configuring Asynchronous I/O...
aio0 Available
aio0 changed
#
Other Oracle Installation Information
http://wespoint/wes/wes_tpsmoracle.html
http://shayden/instorawas.html
Installation of Windows Oracle Client
1) From Oracle web site "http://otn.oracle.com/software/products/oracle8i/htdocs/winsoft.html" (or Steves folder "D:\Oracle Installation\OracleClient\OracleUnzipped\autorun" double click on "autorun.exe" (tried running "setup.exe" in the folder above it but it did not seem to anything). The Oracle8i Client GUI will appear.
2) Click "Install/Deinstall Products".
3) In the "Oracle Universal Installer", "Welcome" panel, click "Next".
4) In the "File Locations" panel, accept the default for the "Source" ("D:\Oracle Installation\OracleClient\OracleUnzipped\stage\products.jar"), and "Destination" ("Name" = "OraHome81" and "Path:" = "D:\oracle\ora81"), then click "Next".
5) In the "Installation Types" panel, select "Administrator (356MB)", then click "Next". Wait a minth.
6) In the "Net8 Configuration Assistant: Welcome" window, DO NOT select "Perform typical configuration", click "Next".
7) In the "Net8 Configuration Assistant: Directory Service Access", select "No,..." and click "Next".
8) In the "Net8 Configuration Assistant: Naming Methods Configuration" panel, accept the default "Selected Naming Methods" of "Local", and click "Next".
9) In the "Net8 Configuration Assistant: Net Service Name Configuration" panel, select "Oracle8i database or service", then click "Next".
10) In the "Net8 Configuration Assistant: Net Service Name Configuration, Service Name" panel, in the "Service Name:" field, enter "STEVEZ", then click "Next".
11) In the "Net8 Configuration Assistant: Net Service Name Configuration, Select Protocols" panel, select "TCP" and click "Next".
12) In the "Net8 Configuration Assistant: Net Service Name Configuration, TCP/IP Protocol" panel, for the "Host Name" field enter your Oracle database machine (i.e. "wea2aix2.raleigh.ibm.com", get this right or it wont work!), and for the "TCP/IP Port Number..." field, accept the default "Use the standard port number of 1521", then click "Next".
13) In the "Net8 Configuration Assistant: Net Service Name Configuration, Test" panel, select "Yes, perform a test", then click "Next". The "Details:" panel should reflect "Connecting....Test Successful", then click "Next".
14) In the "Net8 Configuration Assistant: Net Service Name Configuration, Net Service Name" panel, accept the "Net Service Name:" value (i.e. "STEVEZ"), then press "Next".
15) In the "Net8 Configuration Assistant: Net Service Name Configuration, Another Net ServiceName" panel, select "No", then click "Next".
16) In the "Net8 Configuration Assistant: Net Service Name Configuration Done" panel, click "Next".
17) In the "Net8 Configuration Assistant: Naming Configuration Done" panel, click "Next".
18) In the "Net8 Configuration Assistant: Done" panel, click "Finish".
19) Back in the "Oracle Universal Installer" pane "End of Installation"
panel, click "Exit", and in the "Do you relly want to exit", click "Yes".
Starting and Using DBA Studio GUI
1) To execute the DBA Studio GUI for viewing the remote database, from the Windows "Start" menu item, select "Programs", "Oracle - OraHome81", "Database Administration", "DBA Studio",
2) In the "Oracle Enterprise Manager Logon", select "Launch DB Studio standalone", then click "OK". The "Oracle DBA Studio" GUI window should appear.
3) If/when queried for a Username and Password, enter the appropriate values (i.e. "SYSTEM" and "manager"), then click "OK".
4) In the Oracle DBA Studio GUI select the database you wish to explore (i.e. "STEVEZ"), and scope down to "Schema", "Table", and select the table you wish to explore (i.e. "SCOTT").
5) In the right side panel of the GUI, select a table you wish to explore,
right mouse click and select "Table Data Editor". The "Table Editor" should
appear reflecting the data in the associated table. You can manually change
data by going to the appropriate data cell and modifying the value, or
go to the last row (which should be empty), and inputting a new row of
data into the cells.
Oracle Administrator Profile (.profile)
The following is the ".profile" for the Oracle user, which must reside
in "/home/oracle" (if you have followed the above instructions and used
the automatic or manual method of configuration).
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
export PATH
set -o vi
#DISPLAY=wea2aix1.raleigh.ibm.com:0.0
#export DISPLAY
ORACLE_BASE=/home/oracle
export ORACLE_BASE
ORACLE_SID=ORA817
export ORACLE_SID
ORACLE_HOME=$ORACLE_BASE/$ORACLE_SID
export ORACLE_HOME
PATH=$PATH:$ORACLE_HOME/bin
export PATH
LIBPATH=$LIBPATH:$ORACLE_HOME/lib
export LIBPATH
ORA_CLIENT_LIB=shared
export ORA_CLIENT_LIB
echo 'The oracle 8.1.7 environment is set'
set -o vi
if [ -s "$MAIL" ]
# This is at Shell startup. In normal
then echo "$MAILMSG" # operation,
the Shell checks
fi
# periodically.
Oracle Automatic Install Script
The following is the script which automatically sets up your AIX environment for an Oracle 8.17 installation for a subsequent WEA installation"
#-----------------------------------
# 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.
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
echo 'Increased File size of /home directory
by 4700000 512 Byte blocks,'
echo 'and directory /tmp by 390000 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.817.aix32.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.817.aix32.bit/Disk1'
cd /WEA/inst.images/Oracle/oracle.817.aix32.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
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
(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