First, preparation before installation
1. Tasks performed by root (login with root users)
1.1 Set system variables
1) Open "/ etc / system" file with text editor
# VI / ETC / SYSTEM
2) Insert the following lines at the end of the "/ etc / system" file
Set shmsys: shminfo_shmmax = 4294967295 set shmsys: shminfo_shmmin = 1 set shmsys: shminfo_shmmni = 512 set shmsys: shminfo_shmseg = 128
set semsys: seminfo_semmap = 64 set semsys: seminfo_semmni = 4096 set semsys: seminfo_semmns = 4096 set semsys: seminfo_semmsl = 4096 set semsys: seminfo_semmnu = 4096 set semsys: seminfo_semume = 64 set semsys: seminfo_semopm = 100
NOTE: SHMMAX maximum size of a shared memory segment (the maximum number of bytes of shared memory segment) SHMMIN minimum size of shared memory segment (the minimum size of the shared memory segment) SHMMNI maximum number of shared memory identifiers in the system (system shared memory Maximum number of identifiers) SHMSEG Maximum Number of Shared Memory Segments A User Process Can Attach (maximum shared memory segment of each user process) Semmni Maximum Number of Semaphore IdentifierS in the system (maximum number of signal light indicators in the system) ) Semmsl Maximum Number of Semaphores In A Set (Maximum number of signal lights in each (signal light) collection) SemMns Maximum Number of Semaphores in the system (maximum number of signal lights in the system) Semopm Maximum Number of Operations Per Semop Call (each The maximum number of signal lights called by SemoP) SEMVMX Semaphore Maximum Value (the maximum value of the signal light)
note! The above mentioned SEMMSL and SEMMNs is only available for the initial installation. After the installation is complete, the application should be adjusted according to the actual situation of the application.
★ Semmsl's value can be calculated in the following way: "Init [SID]. OA" file in all Oracle instances 10
★ The value of SEMMNS can be calculated in the following way: the sum of the processes value in the "Init [SID]. OA" file in the system, the maximum processes value) the largest processes value * 2 10 * The number of Oracle instances.
Note: [SID] is a specific database instance name, for example, a system with three Oracle instances, set to the following values in the PROCESS parameter in the respective "initsid.ora" file: oracle_sid = a, processes = 100 oracle_sid = B , Processes = 100 Oracle_SID = C, Processes = 200
Then the Semmsl value is calculated as follows: SEMMSL = [(c = 200) 10] = 210 The method of the SEMMNS value is as follows: SEMMNS = [(a = 100) (b = 100)] [(c = 200 ) * 2] [(# of instances = 3) * 10] = 630
For operating systems, the set parameter value will cause the machine to be unable to start, and for parameters, see the Sun SPARC Solaris System Management Document.
3) Restart the system to make the new kernel parameters to take effect # sync; sync; reboot
4) After the system is restarted, the value of "Maximum Shared Memory" and "MINIMUM Shared Memory" can be checked by the SYSDEF command ("Shared Memory Area" section at the bottom of the list) # sysdef
1.2 Establish group, users and related catalogs
1) Create "DBA" and "OInstall" group, add user name "Oracle", and set passwords for it # groupadd dba # groupadd oinstall (optional) # uERADD -G DBA -G OinsTall -d / export / Home / Oracle -M-S / Bin / Sh Oracle # Passwd Oracle
The above operations can also be implemented with the Admin Tool management tools. # Admin.
2) Creating a related directory # mkdir -p /u01/oracle/Product/8.1.7 # chown -r oracle: DBA / U01 / Oracle # chmod -r 775 / u01 / oracle # mkdir / var / opt / oracle # chown - R Oracle: DBA / VAR / OPT / ORACLE
2, task executed by "Oracle User"
1) Exit the root login, log in with the previously created Oracle user
2) Modify the ".profile" profile of Oracle users, the default is not .profile, but can generate .profile this file via the local.profile under Oracle users .Profile
# mv local.profile.profile
#v.profile
Add the following DISPLAY = 192.168.0.28: 0.0ORACLE_BASE = / u01 / oracleORACLE_HOME = / u01 / oracle / product / 8.1.7ORACLE_SID = oracle8ORA_NLS33 = $ ORACLE_HOME / ocommon / nls / admin / dataCLASSPATH = $ ORACLE_HOME / JRE / lib: $ ORACLE_HOME /jlib:$ORACLE_HOME/product/jlib:$ORACLE_HOME/network/jlib:$ORACLE_HOME/rdbms/jlibLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libNLS_LANG=american_america.ZHS16GBKPATH=/usr/bin:/usr/ucb : / etc: / usr / local / bin: / usr / ccs / bin: / usr / openwin / binPATH = $ ORACLE_HOME / bin: $ PATHexport PATHexport DISPLAY ORACLE_HOME ORACLE_BASE ORACLE_SID ORA_NLS33 LD_LIBRARY_PATH NLS_LANG CLASSPATH3) oracle user to log in again, so that before Modified ".profile" file configuration takes effect 4) Check if the configured configuration takes effect through the ENV command.
5) Enter the directory where the Oracle installation file is located and start installation (assuming the Oracle817 installation file is existing in "/ export / home / oracle / ora817 / disk1")
$ cd / export / home / oracle / ora817 / disk1 $ ./runinstaller
Note: 1. The unlocking method of downloading the Oracle CPIO file is: cpio -idcmv
2. During the installation process, when prompted to run the root.sh ($ ORACLE_HOUT.SH) script, you should manually open a new Console (console) to perform as root user.
3. If the installation is complete, the database is initialized during the database, and the NOT Connected to Oracle error is encountered, the values of parameters such as SEMMSL, SEMMNS should be appropriately increased.
6) Simple test after installation
The default is already the Oracle user login, and the LSNRCTL Start is executed to start Oracle Listener.
$ LSNRCTL START
When the monitor is successful, you will see the following similar information:
LSNRCTL for Intel Svr4 UNIX: Version 8.1.7.0.0 - Production On 23-Jun-2002 04:02:46 (c) Copyright 1998 Oracle Corporation. All Rights Reserved. Starting /u01/oracle/Product/8.1.7/bin / tnslsnr: please wait ... TNSLSNR for Intel SVR4 UNIX: Version 8.1.7.0.0 - Production System Parameter File is /u01/oracle/product/8.1.7/neetwork/admin/listener.ora log message Written To / U01 / Oracle/Product/8.1.7/network/log/listener.log listening on: (deScription = (address = (protocol = ipc)) Listening ON: (description = (address = (protocol = tcp (Host = Gokmen.Selcuk.edu.tr)) (port = 1521))) Listening ON: (deScription = (protocol = tcp) (host = gokmen.selcuk.edu.tr) (port = 2481))) (Protocol_stack = (session = raw))) Connecting to (deSCription = (protocol = ipc)) status of the listener ----------- ------------- Alias Listener Version TNSLSNR for Intel Svr4 Unix: Version 8.1.7.0.0 - Production Start Date 23-Jun-2002 04:02 : 47 Uptime 0 Days 0 HR. 0 min. 0 Sec Trace Level Off Security Off SNMP Off Listener Parameter File /u01/oracle/product/8.1.7/neetwork/admin/listener.ora listner log file / u01 / oracle / Product / 8.1.7/neetwork/log/listener.log Services Summary ... PLSextProc HAS 1 Service Handler (s) Orcl HAS 1 Service Handler (s) The Command Complated SUCCESSFULLY If you see like information, the monitor has started :
LSNRCTL for Intel SVR4 UNIX: Version 8.1.7.0.0 - Production on 24-JUN-2002 05:02:46 (c) Copyright 1998 Oracle Corporation All rights reserved TNS-01106:.. Listener using listener name LISTENER has already been started
7) Write the database boot script
Since it comes with the launch script, I have a simple script here.
Start and close the script
1), start the script (dBStart)
#! / bin / bash
Su - Oracle . /Home/oracle/.bash_profile Lsnrctl Start SVRMGRL Connect Internal Startup Exit Eoe Exit EOF 2), turn off the script (dBSTOP) #! / bin / bash Su - Oracle . /Home/oracle/.bash_profile LSNRCTL Stop SVRMGRL Connect Internal Shutdown immediate Exit Eoe Exit EOF Then assign permissions and copy it to /etc/init.d CHMOD X DBSTART CHMOD X DBSTOP Do connection ln -s /etc/init.d/dbstart /etc/rc2.d/s99dbstart ln -s /etc/init.d/dbstop /etc/rc0.d/k10dbstop This Oracle can run normally under Solaris.
