Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SCO ORACLE 7.3.2 (long)

Re: SCO ORACLE 7.3.2 (long)

From: Ben Ryan <ben_ryan_at_vancity.com>
Date: 1997/03/25
Message-ID: <5h9bin$eir@sisyphus.tvinet.com> 







timhung_at_vcn.bc.ca (Tim Hung) wrote:





>Does any have any experience installing SCO ORACLE 7.3.2 on SCO 5.0.2c ???
 


>I followed the oracle installation instructions to the letter but 
>the WGSTART script just hangs after creating the 2 user accounts.
 


>What am I doing wrong ???
 


>Are there any known bugs with the install script ???
 


>thanks for any help...



I have installed Oracle 7.3.2.1.0 a number of times on SCO OS5.0.2.



This is part of an MS-Word Document so the formatting here will be
bad.



It is assumed here the SCO Development System is not present.
It does not create a database. (I regard that as part of the
application install).



I have skipped over the WebServer options in the notes.



I do not install documentation.



You will also need patch 375930, to prevent the TNS listener hanging
every couple of hours.



Here are the notes I use.




5	Installing Oracle 7.3.2
5.1	Pre-Installation
The Oracle server requires SCO to be configured prior to installation.
5.1.1	Configuring SCO Unix Kernel parameters


As root.


cd /etc/conf/cf.d


./configure


Select 15 for Semaphores and set SEMMNI to 20.
Select 16 for Shared Memory and set SHMMAX to 20971520
5.1.2	Installing additional SCO software
Insert SCO OpenServer CD-ROM into the drive.
scoadmin soft


software->Install New…->From localhost->SCSI CD-ROM Drive 0
Select Application Development Libraries and Linker (ver 5.0.2b)
5.1.3	Creating a Unix filesystem for Oracle
As root


divvy


Create a 1,024,000 block (1000Mb) HTFS division named oracle. Once
created the division table should be as follows

Name	Type	NewFS	#	First Block	Last Block
boot	EAFS	no	0	0	14999
swap	NONFS	no	1	15000	76999
root	HTFS	no	2	77000	691399
u	HTFS	no	3	4042870	4145269
oracle	HTFS	yes	4	691400	1715399
	NOT USED	no	5	-	-
recover	NON FS	no	6	4145270	4145279
d1057all	WHOLE DISK	no	7	0	4149359
					





Create a mount point and mount the new filesystem.
mkdir /oracle


chmod 777 /oracle


chgrp root /oracle


/etc/mount /dev/oracle /oracle



So that the filesystem is mounted at boot time edit


/etc/default/filesys and add to the end of the file the following:-

bdev=/dev/oracle cdev=/dev/roracle \

        mountdir=/oracle mount=yes fstyp=HTFS \
        fsck=no fsckflags= rcmount=yes \
        rcfsck=no mountflags=
5.1.4	Setting up the Oracle Unix account


As root invoke


scoadmin account


Create a new group called ‘dba’.


Groups -> Add New Group


Set group name to dba


Create a new Unix user called oracle with a home directory in the root
filesystem.


Users ->Add New User…


Set ‘login’ to oracle


Set ‘comment’ to ‘Oracle Software Account Owner’
Set ‘login shell’ to ‘ksh’


Set ‘Add Shell Environment Files to Home directory’ to yes
Set home directory to ‘/usr/oracle’


Set ‘login group’ to ‘dba’


Set ‘Member of’ List box to contain ‘dba,group’.
Exit from scoadmin.


Login as oracle and delete the welcome mail message. Edit .profile by
add the following lines, at the end of the file:-

ORACLE_BASE=/oracle/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/7.3.2
ORACLE_SID=<oracle sid>
ORACLE_TERM=$TERM
ORACLE_DOC=$ORACLE_BASE/doc




LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
PATH=$PATH:$ORACLE_HOME/bin


export ORACLE_BASE ORACLE_HOME PATH ORACLE_SID ORACLE_TERM
Remove the following line from .profile

set -o ignoreeof                     # don't let control-d logout


Edit .kshrc and add the following lines:-
alias ls='ls -C'


setps1() {


id | grep 'uid=0(root)' >/dev/null


if [ $? -eq 0 ]


then


PS1="`uname -n`:$PWD# "


else


PS1="`uname -n`:$PWD> "


fi


}


chdir() {


cd $*


setps1


}


setps1


alias cd=chdir


Logout and then login again as oracle.


Create the oracle install directory using:-
mkdir -p /oracle/app/oracle/product/7.3.2/orainst
5.2	Oracle Installation


As root create a mount point for CD disks called /cdrom and mount the
disk.


mkdir /cdrom


chmod 777 /cdrom


/etc/mount -f RCKRDG,lower /dev/cd0 /cdrom

The Oracle makefile script $ORACLE_HOME/rdbms/lib/ins_rdbms.mk makes a
call to the Unix command ‘ar’ which is part of the SCO Development
System. This appears to be an error script. ar should be replace with
$(AR) which is set to /bin/idar. As a work around to this bug link


/bin/ar to /bin/idar, and after the installation remove /bin/ar.

ln /bin/idar /bin/ar


5.2.1	rootpre.sh


Login as oracle and then su to root and run rootpre.sh from the


/cdrom/orainst directory.



su


cd /cdrom/orainst


./rootpre.sh


Say yes to ‘Are you installing Oracle from CDROM?’.
Say yes to ‘Do you want to install Oracle Icons for SCO ODT System?
(Y/N)’


Say yes to ‘Continue with rootpre.sh ? (Y/N)’
Enter oracle to ‘Please enter the name of oracle user:’
Enter dba to ‘Please enter the group the oracle user belongs to:’
The following text will now appear:-


The following files will be created:

Filename	Owner	Group	Mode


/usr/lbin/oraenv	oracle	dba	644

/usr/lbin/coraenv	oracle	dba	644

/usr/lbin/dbhome	oracle	dba	755

/etc/oratab	oracle	dba	644

/etc/sqlnet	oracle	dba	644

/etc/tnsnames.ora	oracle	dba	644

/etc/listener.ora	oracle	dba	644






Continue with the above settings? (Y/N)


Answer yes.


Say no to ‘Are you installing Oracle through a floppy device? (Y/N)’
After rootpre.sh has completed remove the two files in
$ORACLE_HOME/orainst, otherwise they will create a problem later in
the installation process.


cd $ORACLE_HOME/orainst


rm iconfiles orafiles


And then exit the root sub-shell to become the oracle user again.
5.2.2	Running Oracle Installer


As oracle run the oracle installer program from the cdrom’s orainst
directory in character mode.


cd /cdrom/orainst


./orainst /c


Installation Activity Choice


Select the Installer activity:


(o)	Install, Upgrade, or De-Install Software
( )	Create/Upgrade Database Objects
( )	Perfrom Adminstrative Tasks





Select ‘Install, Upgrade, or De-Install Software’.
Installation Options


Select the Installer option:



Install New Product


Add/Upgrade Software


Build Oracle7 Staging Area


Install Documentation Only


De-Install Software


Migrate from Oracle v6 to Oracle7


Select ‘Install New Product’


Installation Options: Home Locator


Complete $ORACLE_HOME location:


/oracle/app/oracle/product/




7.3.2


Select OK


DB Objects


Do you want to create DB objects also?



Select NO


Logging and Status


Confirm (or Change) Log File Location:


If current versions of these log files exist in these locations,they
will be archived and reinitialized.  Select Help for moredetails.


Installer Log:	/oracle/app/oracle/product/7.3.2/orainst/install.log
SQL Log:	/oracle/app/oracle/product/7.3.2/orainst/sql.log
Makefile Log:	/oracle/app/oracle/product/7.3.2/orainst/make.log
OS Log:	/oracle/app/oracle/product/7.3.2/orainst/os.log





Select OK.


Select OK when the README.FIRST file is shown.
Select OK in the ‘Skip README’ screen.
Select YES in the ‘Pre-Installation OS Preparation’ screen.
Select ‘Install from CD-ROM’ in the ‘Install Source’ screen.
Select ‘American/English’ in the ‘NLS’ screen.
Select ‘No’ in the ‘Relink All Executables?’ screen.
Information



Post-installation steps that need to be run by root willbe written to


/oracle/app/oracle/product/7.3.2/orainst/root.sh.




Select OK.


Select ‘No Products’ in the ‘Online Help Load’ screen.
Select ‘No’ in the ‘UNIX Documentation’ screen.
Select ‘No Products’ in the ‘Product Documentation Library CD-ROM
Install’ screen.


In the Software Asset Manager screen select:-
ORACLE7 Server (RDBMS) 7.3.2.1.0


SQL*Plus 3.3.2.0.0


Select OK for warning about ULIMIT not being set.
Once Oracle Installer has finished, as root remove /bin/ar.
su


rm /bin/ar


5.2.3	Running root.sh


From the oracle account, su to root and run the root.sh from the
$ORACLE_HOME/orainst directory.


cd $ORACLE_HOME/orainst


./root.sh


Running ORACLE7 root.sh script...



The following environment variables are set as:

ORACLE_OWNER= oracle
ORACLE_HOME=  /oracle/app/oracle/product/7.3.2
ORACLE_SID=   <Oracle SID>




Are these settings correct (Y/N)? [Y]:


Say yes.


Enter the full pathname of the local bin directory [/usr/lbin]:
Accept the default.


Checking for "oracle" user id...


ORACLE_HOME does not match the home directory for oracle.
Okay to continue? [N]:


Say yes.


Say no to installing Oracle manual pages.

5.2.4	Applying Oracle patch for bug 375930
5.2.4	Running PUPBLD.SQL for SQL*Plus




For more information on PUPBLD.SQL see


SQL*Plus User’s Guide and Reference Release 3.3 page E-2
Oracle 7 Administrator’s Reference for Unix Release 7.3 - page 7-2
Start sql*plus as system and run the script
$ORACLE_HOME/sqlplus/admin/pupbld.sql


sqlplus system


@/oracle/app/oracle/product/7.3.2/sqlplus/admin/pupbld.sql




Ben Ryan - VanCity C.U.


Vancouver, B.C.


Canada
Received on Tue Mar 25 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US