ORACLE 7.2.3 INSTALLATION

ORACLE 7.2.3 INSTALLATION
ON AIX 4.1.4

Must go into SMIT and add the following :

group named dba
group named oper
user named oracle

Properties of dba:

named - dba
id is 11 (next available)
true for su

Properties of oper:

name - oper
id - system assigned
Admin group - no

Properties of oracle:

name - oracle
id - system assigned
groups - dba
admin user - yes
home - /oracle/orahome

NOTES:

1. Important to have files be group dba and owner oracle.

2. MUST have C compiler loaded before-hand or the make file in oracle will not work.

Create directory for installing software from cdroms.
/olink-rdbms for the database system engine
Helped to set term type to be 386u. This will display lines and allow access to menu from installer screens. Will not work on any WYSE terminal. PC worked best.
F4 key is cancel frame and CTRL-K is help
TERM files located in /oracle/orahome/rdbms/admin/terminal

LOADING OF C-COMPILER

Insert AIX 4.1 OS disk in CDRom drive
Create directory named /cdrom
Mount cdrom by typing from the root directory

mount -rv cdrfs /dev/cd0 /cdrom

Initiate SMIT by typing

smit install_latest

Find bos.adt.include 4.1.0.0

Select main group category and install

Exit SMIT
Unmount cdrom by typing from the root directory

unmount /cdrom

Remove AIX 4.1 OS disk

Insert AIX 4.1 support Utilities disk
Mount cdrom by typing from the root directory

mount -rv cdrfs /dev/cd0 /cdrom

Initiate SMIT by typing the following

smit install_latest

Find xlc.rte 3.1.3.0

Select main group category and install

Select xlc.C 3.1.3.0 and install
Exit SMIT
Unmount cdrom by typing from the root directory

unmount /cdrom

PARAMETERS FOR ORACLE INSTALLATION

Oracle Home directory is /oracle/orahome
X Files directory is /usr/lib/netls/ark/lib
__tk2ext seemed to be missing

PRODUCTS TO INSTALL (RDBMS 7.2.3)

Data Query 3.1.0.7.1
Easy SQL 2.2.26.0.4
Unix Installer and doc
Oracle*Mail 1.1.3.9.3
Oracle*Terminal 1.0.10.0.4
Distributed Database Option 7.2.3.0.0
Parallel Query Option 7.2.3.0.0
Server (RDBMS) 7.2.3.0.0
PL/SQL V2 2.2.3.0.0
SNMP Subagent 7.2.3.0.0
Oracle*Forms 3.0 3.0.16.12.9
Oracle*Menu 5.0 5.0.011.13.6
SQL*Net V2 2.2.3.0.0
SQL*Plus 3.2.3.0.0
SQL*Reports 1.1.10.3.1
SQL*Report Writer 1.1.14.16.1
TCP/IP V2 Protocol Adapter 2.2.3.0.0
Toolkit 2 2.0.10.22.0

Installing this many products at one time seemed to cause the paging space on the AIX Server to become low. Therefore install in stages. The only ones that would not work then were the Forms, and the Reports.

PRODUCTS TO INSTALL (DEVELOPER 2000 TOOLS)

Oracle*Tables for Tools
Oracle*Book 2.2.0.1.5
Oracle*Browser 2.0.7.4.3
Oracle*Forms 4.5.6.1.3
Oracle*Network Manager 2.1.6.0.0
(Seemed to cause problems would not install correctly.)
Oracle*Reports 2.5.3.6.3
Oracle PL/SQL Procedure Builder 1.5.4.5.3

All tools are installed on IBM server but are client side tools.

Had to increase logical volume and file system space to accomodate these files.
Originally created as 750Mb and it was not large enough. Increase to 1Gig.

Logical Volume Parameters:
Increased logical partitions from 186 to 239 ( 750Mb ) to ( 1 Gig )

File System Parameters:

Increased file system size from 1,523,712 to 1,953,125 ( 750Mb ) to ( 1 Gig )

ORACLE WINDOWS TOOLS

Options when install oracle server manager and other tools into windows:

Company name "Edu-Met Interactive Systems"
Directory c:\orawin
Allow to modify autoexec.bat file YES
Server Manager Directory Accept default destination settings
Copy Microsoft distributable files YES
TCP/IP Driver Microsoft VxD 32 bit TCP/IP drivers

NOTE: All of the client tools are actually going to be installed thru windows. Here is what needs to be done :

There is a directory on the server called 'install' and it holds all necessary stuff to set up a client installation.
Copy files from t:\dev2k\install\system to c:\windows\system directory. If the file is same size or newer on the pc, DONT replace !
Copy t:\dev2k\install\windows\oracle.ini to c:\windows
Make an entry in c:\autoexec.bat and in c:\windows\win.ini according to the t:\dev2k\README file instructions.

Run scripts to setup all forms/reports/graphics/sql according to Appendix A in dev2k book. Group on Pauls machine setup to do that allready. Also has grants and synonyms.

MODIFY FILES

Files which needed to be modified to get Oracle TNS Ping to work correctly:

WINDOWS:

c:\windows\services
c:\windows\hosts
c:\windows\vsl.ini
c:\windows\oracle.ini
c:\orawin\network\admin\sqlnet.ora copied from **location 1**
c:\orawin\network\admin\tnsnames.ora copied from **location 1**
c:\orawin\network\admin\listener.ora copied from **location 1**

UNIX:

/etc/hosts
/etc/services
/etc/tnsnames.ora copied from **location 1**
/etc/sqlnet.ora copied from **location 1**
/etc/listener.ora copied from **location 1**
/etc/rc.tcpip
/etc/inittab
/oracle/orahome/dbs/initsid1.ora
/oracle/orahome/network/admin/tnsnames.ora copied from **location 1**

NOTE: If files do not exist, they must be copied from elsewhere in the system.

**location 1** is c:\orawin\network\round4\edu_met_
where orawin is the directory the windows tools are installed into
where round4 is the name of the netmanager directory created by setup
where edu_met_ is the host name