Oracle 7.2.3 installation on HP-UX 10 1996-10-28 ------------------------------------------------- Make sure the following kernel parameters have at least these values. semmni: 64 shmmax: 67108864 shmmni: 200 shmseg: 120 Rebuild the kernel & reboot the server. Create the group "dba" & the user "oracle7" Make sure the oracle7 user have "umask 022". Log out & back in to activate the umask. Create a 400 MB disk volume for Oracle binaries. /opt/oracle7 As root mount the CD-ROM if not mounted: > mount -r -F cdfs /dev/dsk/c0t2d0 /cdrom As root with "sam" create a temporary disk volume, of 50 MB, mounted on /oracle_link This temporary volume will contain a number of links to the CD-ROM disk. The START.SH script will NOT copy any files, just create links ! This means that is you reboot the machine you must make sure the CD-ROM is mounted for the "/oracle_link/orainst/orainst" program to work ! As oracle7: > cd /cdrom/ORAINST /cdrom/ORAINST > ./START.SH Please enter your oracle_link directory: /oracle_link /cdrom/ORAINST > cd /oracle_link/orainst Set your TERM variable. I.e. vt220: > export TERM=vt220 > export ORACLE_TERM=vt220 /oracle_link/orainst > ./orainst Select: COMPLETE SOFTWARE/DATABASE FRESH INSTALL Install from CD-ROM /oracle_link Oracle SID: DDM Install available documentation: For no products. ------------------------------------------- Products available on /oracle_link -------------------------------------------+ Advanced Replication Option 7.2.3.0.0 | LU62 Protocol Adapter (V2) 2.2.3.0.0 | Oracle Data Query 3.1.0.7.1 | Oracle Easy*SQL 2.2.26.0.4 | Oracle Names 1.1.1.0.0 | Oracle Server Manager 2.1.4.0.0 | * Oracle SQL*Calc 1.2.25.0.1 | Oracle Unix Installer and Documentation Vie| * ORACLE*Mail 1.1.3.9.3 | Oracle*Terminal 1.0.10.0.4 | ORACLE7 Distributed Database option 7.2.3.0| ORACLE7 Parallel Query option 7.2.3.0.0 | ORACLE7 Server (RDBMS) 7.2.3.0.0 | * ORACLE7 XA Library 1.1.1.0.0 | PL/SQL V2 2.2.3.0.0 | * Pro*Ada 1.7.3.0.0 | Pro*C 2.1.3.0.0 | Pro*C 1.6 1.6.9.0.0 | Pro*COBOL 1.7.3.0.0 | Pro*FORTRAN 1.7.3.0.0 | SNMP Database Subagent 7.2.3.0 | SPX/IPX Protocol Adapter (V2) 2.2.3.0. | SQL*Forms 3.0 3.0.16.12.9 | SQL*Menu 5.0 5.0.11.13.6 | SQL*Module 1.1.2.1.0 | SQL*Net Async (V1) 1.2.13.2.1 | SQL*Net SPX (V1) 1.2.7.9.1 | SQL*Net TCP (V1) 1.2.7.8.1 | SQL*Net V2 2.2.3.0.0 | * SQL*Plus 3.2.3.0.0 | * SQL*Report 1.1.10.3.1 | SQL*ReportWriter 1.1.14.16.1 | TCP/IP Protocol Adapter (V2) 2.2.3.0.0 | * ToolKit 2 Extra Printer Files 2.0.10.21.0 | V6 to V7 Migration Utility. 7.2.3.0.0 | -------------------------------------------- Please enter the Unix group name for the DBA group. dba Select the OSOPER group. dba Enter the database name associated with the DDM instance: DDM Select the character set for creating this database: US7ASCII Please enter the password for the 'SYSTEM' ORACLE userid: xxxxxxx Please enter the password for the 'SYS' ORACLE userid: xxxxxxx ... passwords for the internal users (viz.,'dba' and 'operator')? No Enter the password for the TNS listener: xxxxxxx MTS (Multi-Threaded Server) configured and the SQL*Net listener automatically started? No Would you like to load the SQL*Plus Help Facility? No Would you like to load the SQL*Plus Demo Tables? Yes ---------------------------------------------------------- | | | Installing... | | | | From: /oracle_link | | | | To: /opt/oracle7/bin | | | | SQL*Net V2 | | | | ############### | | 0 25 50 75 100 | | | | | | Loading SQL*Net V2 Executables... | | | | | | File: lsnrctl | | | ---------------------------------------------------------- ------------ Install Completed -----------+ | | | The | | requested action has been performed for | selected products. | | | | | | Certain product setup actions need to | be performed by the 'root' | | user after successful installation. | Upon completion of | | installation, please log in as 'root' | and run the root.sh script. | | | | | | Select (Help) for more details on what | you can do next. Select (OK) | | | | (OK) | +-----------------------------------------+ Exit orainst & as "root" run: > /opt/oracle7/orainst/root.sh Running ORACLE7 root.sh script... The following environment variables are set as: ORACLE_OWNER= oracle7 ORACLE_HOME= /opt/oracle7 ORACLE_SID= DDM Are these settings correct (Y/N)? [Y]: Y Enter the full pathname of the local bin directory [/usr/local/bin]: Checking for "oracle7" user id... Creating /etc/oratab file... Updating /etc/oratab file... Leaving common section of ORACLE7 root.sh. -------------------------------------------- Tre filer i "/usr/local/bin" skapas: coraenv, dbhome & oraenv Change /etc/oratab to "DDM:/opt/oracle7:Y" So the database will be brought up at system boot time. As "root" create startup/shutdown script: > cd /sbin/init.d > cp template oracle > vi oracle ---------------------------------------------------------- #!/sbin/sh # # Oracle startup & shutdown script. # # Allowed exit values: # 0 = success; causes "OK" to show up in checklist. # 1 = failure; causes "FAIL" to show up in checklist. # 2 = skip; causes "N/A" to show up in the checklist. # Use this value if execution of this script is overridden # by the use of a control variable, or if this script is not # appropriate to execute for some other reason. # 3 = reboot; causes the system to be rebooted after execution. # Input and output: # stdin is redirected from /dev/null # # stdout and stderr are redirected to the /etc/rc.log file # during checklist mode, or to the console in raw mode. PATH=/usr/sbin:/usr/bin:/sbin export PATH # NOTE: If your script executes in run state 0 or state 1, then /usr might # not be available. Do not attempt to access commands or files in # /usr unless your script executes in run state 2 or greater. Other # file systems typically not mounted until run state 2 include /var # and /opt. rval=0 # Check the exit value of a command run by this script. If non-zero, the # exit code is echoed to the log file and the return value of this script # is set to indicate failure. set_return() { x=$? if [ $x -ne 0 ]; then echo "EXIT CODE: $x" rval=1 # script FAILed fi } case $1 in 'start_msg') # Emit a _short_ message relating to running this script with # the "start" argument; this message appears as part of the checklist. echo "Starting Oracle" ;; 'stop_msg') # Emit a _short_ message relating to running this script with # the "stop" argument; this message appears as part of the checklist. echo "Stopping Oracle" ;; 'start') # source the system configuration variables if [ -f /etc/rc.config.d/oracle ] ; then . /etc/rc.config.d/oracle else echo "ERROR: /etc/rc.config.d/oracle MISSING" exit 2 fi # Check to see if this script is allowed to run... if [ ${ORACLE_START} -eq 1 ]; then echo "Starting Oracle" su - oracle7 -c dbstart set_return else rval=2 fi ;; 'stop') # source the system configuration variables if [ -f /etc/rc.config.d/oracle ] ; then . /etc/rc.config.d/oracle else echo "ERROR: /etc/rc.config.d/oracle MISSING" exit 2 fi # Check to see if this script is allowed to run... if [ ${ORACLE_STOP} -eq 1 ]; then echo "Stopping Oracle" su - oracle7 -c dbshut set_return else rval=2 fi ;; *) echo "usage: $0 {start|stop|start_msg|stop_msg}" # rval=1 ;; esac exit $rval ---------------------------------------------------------- > cd /sbin/rc1.d > ln -s /sbin/init.d/oracle K110oracle > cd /sbin/rc2.d > ln -s /sbin/init.d/oracle S990oracle > cd /etc/rc.config.d > vi oracle ----------------------- ORACLE_START=1 export ORACLE_START ORACLE_STOP=1 export ORACLE_STOP ----------------------- > chmod o+r oracle Try reboot the machine and see if Oracle is shutdown/started. Done!