| installaing oracle 8i on sco unixware 7.1 [message #97711] |
Tue, 26 November 2002 00:27  |
thirumaran
Messages: 4
Registered: June 2002
|
Junior Member |
|
|
hi,
i require the installation documentation to install oracle 8i on sco-unixware 7.1 on h/w (advantech industrial grade machine or conversant v8 )
thanks in adv
regards
thirumaran
|
|
|
|
| Re: installaing oracle 8i on sco unixware 7.1 [message #97764 is a reply to message #97711] |
Sun, 12 January 2003 04:18  |
debjit mandal
Messages: 2
Registered: January 2003
|
Junior Member |
|
|
Escalation Bulletin September 2001 Page 3 of 19
ORACLE 8.1.6 (8i) INSTALLATION ON UNIXWARE 7.1.1
***Contributed By: Sudipto Das NIG,SSO, Delhi & Sumit Basu Mallick, IRC NOIDA***
Prerequisites:
1. System is installed with Unixware 7.1.1
2. Swap size has to be defined three times that of the physical RAM.
3. Define the /tmp filesystem and /var/tmp filesystem large enough which would be used to
store temporary files during installation of some database and application tools. (Here we
made each of 400MB)
4. Recommended Memory for Oracle 8I is 128MB.
5. Install the oracle software and database on a filesystem other than root for enhanced
performance and if possible on a different disk.
6. Ensure that the network card is configured and running.
No extra OS patches are required for the UnixWare 7.1.1 to install Oracle 8.1.6
Give privileges for the following directory / file:
#chmod 777 /tmp
#chmod 777 /mnt
#chmod 777 /dev/asyncഊEscalation Bulletin September 2001 Page 4 of 19
Create a Unix group and user:
Create a Unix group called ＆dba＊
Create a Unix user called ＆oracle＊ who is the software owner and he should belong to dba
group.
This can be done using scoadmin account manager utility by typing in the following and
selecting the appropriate fields.
[[# scoadmin account]]
Tips: Installation was successful using the following settings for oracle user
Login shell : /usr/bin/ksh
Home directory : /home/oracle
Login group : dba
Tips: the /etc/group file may have the following entry
Dba:102:others, oracle
Tune the Kernel parameters for Oracle database:
#scoadmin ↙System ↙System Tuner
Note: Select the following pull down menu and set the parameters accordingly
6.1. File System Parameter
NPBUF 100
6.2. InterProcess Communication Parameters
SHMMAX ( 0.5 * Physical memory )
SHMMNI 100
SHMSEG 10
SEMMNI 100
SEMMSL 150
SEMOPM 100
6.3. Process Limit Parameters
SCORLIM 0x7FFFFFFF
HCORLIM 0x7FFFFFFF
SDATLIM 0x7FFFFFFF
HDATLIM 0x7FFFFFFF
SVMMLIM 0x7FFFFFFF
HVMMLIM 0x7FFFFFFF
SFSZLIM 0x7FFFFFFF
HFNOLIM 2048
SFNOLIM 128
NPROC 1000
MAXUP 1000ഊEscalation Bulletin September 2001 Page 5 of 19
6.4 Streams Parameters
STRTHRESH 0x500000
6.5 Miscellaneous Parameters
ARG_MAX 1048576
Note: After setting these parameters, when promoted for rebuild, select it O.K. and carry out the
following step no. 6 and then reboot the system.
7. Setting Ulimit Parameter
Edit the /etc/default/login file and either comment the ULIMIT line or add the following:
ULIMIT = unlimited
8. Reboot the system & check the ulimit value
#ulimit
Note: The value returned should be 4194303
9. Create a directory called oracle under /var/opt and provide the read, write &
execute privileges to the same.
#cd /var/opt
#mkdir oracle
# chmod 777 oracle
10. Set the following environment variables in Oracle＊s .profile file.
Note: This file is present in oracle＊s home directory. For e.g. /home/oracle/.profile in this case.
ORACLE_HOME = /home/or8i/sw/8i; export ORACLE_HOME
PATH=$PATH: /usr/bin:/usr/java/bin :$ORACLE_HOME/bin; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
ORACLE_BASE= /home/or8i/sw; export ORACLE_BASE
ORACLE_OWNER=oracle; export ORACLE_OWNER
ORACLE_SID=<enter your Oracle SID>; export ORACLE_SID
ORACLE_TERM=386x; export ORACLE_TERM
JAVA_HOME=/usr/java; export JAVA_HOME
TMPDIR= /home/oratmp; export TMPDIR
Note: Enter the SID name specified by customer, say ※or8I§ in ORACLE_SID.
Note: The following directory has to be created and the owner has to be set as oracle and group
as dba.
As root user do following.
# cd /home
# mkdir or8i
# chown oracle:dba or8i
# cd / home
# mkdir oratmp
# chmod 777 oratmp
Exit from root user account and login as oracle and carry out the following
$ cd / home/or8iഊEscalation Bulletin September 2001 Page 6 of 19
$ cd or8i
$ mkdir sw db01 db02 db03
[[ sw is for oracle base directory and db01 till db03 can be database mount points]]
$ cd sw
$ mkdir 8i
Note: Ensure the umask returns 022 from oracle＊s home directory.
11. Set the parameters for dt profile
Check whether .dtprofile is present in oracle owner＊s home directory or not. If it is not present
then copy the file from the root directory (i.e. /) to the oracle＊s home directory.
After copying the file on to Oracle user＊s home directory and add the following lines to the file.
DTSOURCEPROFILE=true
ORACLE_HOME= /home/or8i/sw/8i; export ORACLE_HOME
PATH_$PATH:/usr/bin:/usr/java/bin:$ORACLE_HOME/bin; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
ORACLE_BASE=/home/or8i/sw; export ORACLE_BASE
ORACLE_OWNER=oracle; export ORACLE_OWNER
ORACLE_SID=OR8I; export ORACLE_SID
ORACLE_TERM=386x; export ORACLE_TERM
JAVA_HOME =/usr/java; export JAVA_HOME
TMPDIR= /home/oratmp; export TMPDIR
12. Mounting the cdrom
#mount 每F cdfs 每r /dev/cdrom/cdrom1 /mnt
13. Start the Oracle Universal Installer
Tip : To be strictly carried out as Oracle user
Go to the desktop (GUI) and login in as Oracle user and carry out the following by invoking a
terminal icon.
$ cd /mnt
$ ./runInstaller
Note: You will get different screens in OUI, asking some inputs to be provided. Give inputs as
per your organizational setup. Now following are the screen inputs given during this installation
carried at our technology center.
14. OUI 每 Welcome
Click <Next> button
15. OUI 每 File Locations
Source path : /mnt/stage/product.jar
Destination path: /home/or8i/sw/8i
Then click <Next> buttonഊEscalation Bulletin September 2001 Page 7 of 19
16. OUI - Unix group Name
Unix group Name : dba
Then click <Next> button
17. OUI 每 Available Products 每 Select a product to install
Select: Oracle 8I 8.1.6.0.0
Then click <Next> button
18. OUI 每 Installation Types
What type of installation do you want for Oracle 8I
Select : Typical (1.01 GB)
Then click < Next> button
19. OUI 每 Database identification
Global Database Name : or8I (as per the customer requirement)
SID : or8i (as per the customer requirement)
Then click < Next> button
20. OUI 每 Database File Location
Enter Directory for database files : /home/or8i/db01
Note: Log of installation session is at /home/or8i/sw/OraInventory/logs/installActions.log
21. OUI - Run root.sh Message
After installation is through, you might receive a message to run root.sh as root user.
Login in as root user from any other terminal.
Go to following directory and run the root.sh file as root user only.
# cd /home/or8i/sw/8i
# sh root.sh
22. OUI 每 End of installation
You might receive a message that installation of Oracle 8I was successful.
23. OUI 每 quit the installer
If you click on exit, it would prompt ※Do you really want to exit§ ?
Then click on <Yes> button.
23. Oracle 8I installation should have been done successfully now.
Conclusion
The above procedure was carried out to successfully install the Oracle 8I database on Unixware
7.1.1 without any interruption. Following are some of the utilities, which have got installed.ഊEscalation Bulletin September 2001 Page 8 of 19
Oracle server manager utility - svrmgrl
Oracle sqlplus - sqiplus
Oracle export - exp
Oracle import - sqlldr
Oracle database assistant (GUI) - dbassist
Net8 Configuration utilities (GUI) - netasst
Net8 Configuration utilities (GUI) - netca
Net8 Configuration utilities (GUI) - netec
To start the Oracle Database
Login as Oracle user and type the following
$ svrmgrl
svrmgrl > connect internal
svrmgrl > startup
svrmgrl > exit
To start the Oracle listener service for client access
login as Oracle user and type the following
$ lsnrctl start
To shutdown the Database & Listener
Login as Oracle user and type the following
$ svrmgrl
svrmgrl > connect internal
svrmgrl > shutdown
svrmgrl > exit
Note: Ensure that no users are connected to the system
To stop the Oracle listener service for client access
Login as Oracle user and type the following
$ lsnrctl stop
To start and stop through dbstart and dbshut script you need to do the following:
Copy the ※oratab§ file from /var/opt/oracle to /etc.
# cp /var/opt/oracle/oratab /etc/oratab
Edit the /etc/oratab file to include the ※Y§ parameter to start or stop the oracle through the script.
The Sample oratab file looks like the following:
ORACLE_SID:ORACLE_HOME:Y|N
As for the example here you need to edit it from
Or8I:/home/or8i/sw/8I:N
To
Or8I:/home/or8i/sw/8I:YഊEscalation Bulletin September 2001 Page 9 of 19
Patching Required to start the database through dbstart script.
After installing oracle 8.1.6 we had problems in starting the instance. The listener started without
problems, but the instance itself failed to start due to problems in getting the version number via
srvmgrl. The problem was, that dbstart tries to find the version number by looking for the
message PL/SQL server version, srvmgrl displayed JServer version, which was not matched by
the script. Through original dbstart script it will not actually start the oracle database. It gives ※or8I
warm started§
Pl. find the patched dbstart script. To implement this patched script do the following:
Login as oracle,
$ cd $ORACLE_HOME
$ cd bin
$ cp dbstart dbstart.org
Copy the patched dbstart script (below) in the same place with name dbstart.
--------------- CUT FROM HERE -----------------------
:
#
# $Header: dbstart.sh.pp 09-dec-99.09:51:46 mdenney Exp $ dbstart.sh.pp Copyr (c) 1991
Oracle
#
###################################
#
# usage: dbstart
#
# This script is used to start ORACLE from /etc/rc(.local).
# It should ONLY be executed as part of the system boot procedure.
#
#####################################
ORATAB=/etc/oratab
trap 'exit' 1 2 3
case $ORACLE_TRACE in
T) set -x ;;
esac
# Set path if path not set (if called from /etc/rc)
case $PATH in
"") PATH=/bin:/usr/bin:/etc
export PATH ;;
esac
#
# Loop for every entry in oratab file and and try to start
# that ORACLE
#
cat $ORATAB | while read LINE
do
case $LINE in
#*) ;; #comment-line in oratab
*)
# Proceed only if third field is 'Y'.
if [[ "`echo $LINE | awk -F: '{print $3}' -`" = "Y" ]] ; then
ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
if [[ "$ORACLE_SID" = '*' ]] ; thenഊEscalation Bulletin September 2001 Page 10 of 19
ORACLE_SID=""
fi
# Called programs use same database ID
export ORACLE_SID
ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
# Called scripts use same home directory
export ORACLE_HOME
# Put $ORACLE_HOME/bin into PATH and export.
PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/etc ; export PATH
# add for bug # 652997
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:${ORACLE_HOME}/lib ; export
LD_LIBRARY_PATH
PFILE=${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora
# Figure out if this is a V5, V6, or V7 database. Do we really need V5?
if [[ -f $ORACLE_HOME/bin/sqldba ]] ; then
VERSION=`$ORACLE_HOME/bin/sqldba command=exit | awk '
/SQL*DBA: (Release|Version)/ {split($3, V, ".") ;
print V[[1]]}'`
else
if test -f $ORACLE_HOME/bin/svrmgrl; then
VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk '
/(PL/SQL|JServer) (Release|Version)/ {substr($3,1,3) ;
print substr($3,1,3)}'`
else
VERSION="8.2"
fi
fi
STATUS=1
if [[ "$VERSION" = "8.1" ]]
then
pmon=`ps -ef | egrep pmon_$ORACLE_SID | grep -v grep`
if [[ "$pmon" != "" ]];
then
STATUS="-1"
echo "Database "${ORACLE_SID}" already started."
fi
else
if test -f $ORACLE_HOME/dbs/sgadef${ORACLE_SID}.dbf -o
-f $ORACLE_HOME/dbs/sgadef${ORACLE_SID}.ora
then
STATUS="-1"
else
STATUS=1
fi
fi
case $STATUS in
1) if [[ -f $PFILE ]] ; then
case $VERSION in
6) sqldba command=startup
;;
7) sqldba <<EOF
connect internal
startup
EOF
;;ഊEscalation Bulletin September 2001 Page 11 of 19
7.3) svrmgrl <<EOF
connect internal
startup
EOF
;;
8.0) svrmgrl <<EOF
connect internal
startup
EOF
;;
8.1) sqlplus /nolog <<EOF
connect internal
startup
EOF
;;
esac
if test $? -eq 0 ; then
echo ""
echo "Database "${ORACLE_SID}" warm started."
else
echo ""
echo "Database "${ORACLE_SID}" NOT started."
fi
else
echo ""
echo "Can't find init file for Database "${ORACLE_SID}"."
echo "Database "${ORACLE_SID}" NOT started."
fi
;;
-1) echo ""
echo "Database "${ORACLE_SID}" possibly left running when system went down (system
crash?)."
echo "Notify Database Administrator."
case $VERSION in
6) sqldba "command=shutdown abort"
;;
7) sqldba <<EOF
connect internal
shutdown abort
EOF
;;
7.3) svrmgrl <<EOF
connect internal
shutdown abort
EOF
;;
8.0) svrmgrl <<EOF
connect internal
shutdown abort
EOF
;;
8.1) sqlplus /nolog <<EOF
connect internal
shutdown abortഊEscalation Bulletin September 2001 Page 12 of 19
EOF
;;
esac
if test $? -eq 0 ; then
if [[ -f $PFILE ]] ; then
case $VERSION in
6) sqldba command=startup
;;
7) sqldba <<EOF
connect internal
startup
EOF
;;
7.3) svrmgrl <<EOF
connect internal
startup
EOF
;;
8.0) svrmgrl <<EOF
connect internal
startup
EOF
;;
8.1) sqlplus /nolog <<EOF
connect internal
startup
EOF
;;
esac
if test $? -eq 0 ; then
echo ""
echo "Database "${ORACLE_SID}" warm started."
else
echo ""
echo "Database "${ORACLE_SID}" NOT started."
fi
else
echo ""
echo "Can't find init file for Database "${ORACLE_SID}"."
echo "Database "${ORACLE_SID}" NOT started."
fi
else
echo "Database "${ORACLE_SID}" NOT started."
fi
;;
esac
fi
;;
esac
done
--------------- CUT ENDS HERE ---------------------
*
dear , if you can have a sco unixware 7.1.1 ins procedure please send me at my email id: dmondal@hclinsys.com
|
|
|
|
| Re: installaing oracle 8i on sco unixware 7.1 [message #98065 is a reply to message #97711] |
Fri, 16 January 2004 05:31 |
Abhirup
Messages: 2
Registered: January 2004
|
Junior Member |
|
|
Hi Thirumaran,
I hope when you are ready to install Oracle 8i on SCO UNIXWARE 7.1, then you must have the CDs with you. What Debjit has given you, is very nice and well if you have any confusion, then you can always go for the installation guide present in the CD itself. Put the CD in any Windows machine and open the following folders: CDROM drive--> doc --> Unixdoc --> server.817 --> a87437.pdf. The name of the installation guide may be different but this is the common path.
Hope this helps you a lot and for any further query you can always mail me.
With regards,
Abhirup Haldar.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
