Digital UNIX Version 4.0 Under Oracle 8.0.5 Server installation
Shi Yu (China Soft Network Technology Co., Ltd., Beijing, 100081)
First, system requirements first check if the system satisfies the software and hardware requirements shown in Table 1 and Table 2 first before installing Oracle 8 servers. 1. Hardware demand
Table 1 Hardware Demand Hardware Project Demand CPU Digital Unpha System Memory 2-4 times Memory Size Disk Drive (Disk Drives) At least four devices: One for Oracle Software, and three other for creating A OFA (Optimal Flexibal Architech) Adaptable Database Disk Space At least 800M (Oracle 8 Server Full Instal) CD-ROM Device can be used to read UFS format CD-ROM devices Note: This article does not consider the installation of the Oracle 8 parallel server, if you want to install Parallel servers require some additional hardware and software requirements and software installation steps, not considered here.
2. Operating system software requirements
Table 2 Software Demand Software Project Demand Operating System DIGITAL UNIX, 4.0D Version UNIX operating system, the following command can be used to determine the installed operating system package: $ uname -a
Second, preparation before installation
Before performing an Oracle 8 server installation, you must first make the necessary environment settings, and you can perform the installation of Oracle 8 database in the case where the system meets the installation environment requirements. The following is introduced from three different aspects: (1) root user settings; (2) Oracle user settings and (3) settings of a single Oracle product. 1. Root User Settings Log in with root users, performs the following tasks, and sets the environment of the Oracle 8 server. (1) Configure the Unix kernel Configure the communication parameters (IPC, InterProcess Communication) to adapt to the SGA (System Global Area) structure of the Oracle8 server. If the system does not have enough shared memory with the SGA, it may cause the database that cannot be started. Modify the / etc / sysconfigtab file, fill in the following IPC parameters after this file. IPC: SHM-MAX = 2139095040 (2GB - 8MB) SHM-MNI = 128 SHM-SEG = 32DLM: DLM_DISABLE_GRPTX = 0 After saving, restart the system. (2) Creating an installation point When you create an OFA installation, the Oracle8 server requires at least four installation points: one for software, and other three of the database files. Software and database installation point names for Oracle must meet / PM, P is a fixed string, m is a fixed length key for distinguishing a different mounting point. Table 3 is an example of a mount point name. Table 3 Installation Point Name Sample Software Installation Point Database Mounting Point / U01 / U02 / U03 / U04
(3) Creating a database administrator group Oracle requires two UNIX user groups, one is OSDBA, and the other is OSOper. The users in these two groups have permissions for Oracle DBA and Operator, respectively. Under Digital UNIX, the syntax for creating these two groups is: $ addGroup DBA $ addGroup Oper, the system is installing OSDBA as the osoper group, if the default selection of the system is selected, then the Oper group can Not created, because it is a subset of group DBA. (4) Creating an Oracle user must create an Oracle user, and the Oracle database installation behind must be done under the Oracle account. The syntax is: $ addUser Oracle -g DBA (5) Creating a local bin directory To facilitate Oracle User Management System, you need to create a public environment. Part of the public environment is to create a partial bin directory outside an Oracle_Home directory as a shared software area. a. Create a local bin directory, such as / usr / local / bin; b. Set this directory in the Path path of each user and ensure that all users have permission to execute the directory. During the installation process, the system will Oraenv Oraenv (For C shell for Coraenv) and DBHOME two scripts are placed in the $ ORACLE_HOME / BIN directory. After the installation is complete, the root.sh script will copy these two files to the / usr / local / bin directory. (6) Creating the information of the ORATAB file Oracle instance is saved in the ORATAB file. This file is all of the Oracle account, but it resides in a ROOT permission directory when you create this file. Run the CDROM_MOUNT_POINT / ORAINST / ORATAB.SH script creates this file in the / etc / oratab directory and read settings. 2. Oracle user settings log in with Oracle users and performs the following tasks. (1) Setting the file Create Permissions Set UMASK to 022 to ensure that the group has permission to read and execute for the file created by the installer. a. Run the umask command to view the current settings; b. If the umask command does not return 022, set Umask 022 in the.profile or .login file of the Oracle account. (2) Set the environment variable before setting the following environment variables in the .profile or .login file before starting installation. ORACLE_HOME = / u01 / app / oracle / product / 8.0.5; export ORACLE_HOME LD_LIBRARY_PATH = / u01 / app / oracle / product / 8.0.5 / lib; export LD_LIBRARY_PATH ORACLE_BASE = / u01 / app / oracle; export ORACLE_BASEORACLE_SID = ORCL; export ORACLE_SIDORACLE_TERM = vt100; export ORACLE_TERMORA_NLS33 = / u01 / app / oracle / product / 8.0.5 / ocommon / nls / admin / data; export ORA_NLS33 PATH = $ PATH: $ ORACLE_HOME / bin; export PATH (3) update the current session context After setting the environment variable of the Oracle account, you need to update the current shell session. For Bourne and Korn shell: $. .Profile For c shell: $ source .login 3, install Oracle 8.0.5
Run the following steps to install the Oracle 8 server. 1. Installing the installation of the product CD-ROM (1) places the Oracle installation disc into the CD-ROM drive; (2) If you are an Oracle user, you will re-log in and create a CD-ROM installation point directory. $ su root # mkdir CDROM_MOUNT_POINT_DIRECTORY (3) Mount CD-ROM to Install Directory # mount -r / dev / cdrom / cdrom_mount_point_directory2. Start installation (1) Loading CD-ROM; (2) Log in with Oracle users and go to CD- Under the ORAINST directory of the ROM; $ CD CDROM_MOUNT_POINT_DIRECTORY / ORAINST (3) Determine Oracle_Term Set to the correct value (if the setting is incorrect, the installation screen display and function keys will run incorrectly); (4) Start installing a. Graphics interface ( Motif mode) $ setnv display machine_name: 0 $ ./orainst / mb. Character interface $ ./orainst / c Enter the installation interface After "Next", the interface settings appear; if the user's environment variable sets the correct interface The directory will automatically complete the settings, otherwise, click "NEXT" through the "Browse" button, click "Next", go to the next step; the rest of the work is very simple, just follow the prompts, basically no problem. Select "Custom Install", OK, "Install, UpGate or de-install software", "Install new product-do not create db objects" (select it, then create a database separately after the Oracle8 Server installation is successful, check "Oracle_Home" and "ORCALE_BASE" are correct, accept the default log file path, select the installation from the CDROM, select the appropriate language (recommended with American / English). The installer tells you "root.sh" where it is performed after installation. At this point, you can choose to install those software, if you have installed Java SDK and set the correct classpath, you can choose to install JDBC. If the TCL package is installed, you can select "Intelligent Agent", but it is recommended that you can do not install these options. Parts can be installed as needed in the future. Press "Install" to start installing. DBA and OPER groups can accept the default value during the installation process. After the installation software is installed, the system prompts "The Requested Action Has Been Performed for SELECTED Products", press "EXIT" to exit the installer, and finally see a prompt "Result: Success" on the screen, otherwise Will report where an error is reported during the installation process. Here, you can modify the file as follows before logging in to ROOT.SH files as root. Increase environment variables log = / tmp / oracle-root.sh.log, so that the script's run results will be recorded. Fourth, install the patch 8.0.5.2.1
This patch is for Oracle RDBMS, PL / SQL, Replication and Precompiler Products, can be obtained from Oracle official website, or you can get from some domestic Oracle sites. The installation of the patch and the installation of Oracle8 Server are similar, and a detailed installation instructions are provided in this patch, which is not described herein.
V. Create a database
The database is created and the Oracle 8 server and the installation of the patch are also from ORAINST, the steps are as follows: $ cd $ oracle_home / orapst $ ./orainst / c Select "CREATE / UPGRADE DATABASE Objects", "CREATE DATABASE Objects, check Oracle_Home and ORCALE_BASE, accept the default log file directory, you must select "Oracle 8 Standard Rdbms 8.0.5.0.0", press "Install", select "Create Product DB Objects", select "FileSystem-based Database". You can choose to distribute the control file in multiple installation points, or you can choose a single installation point. Oracle strongly recommends dispersion databases at at least three mounting points of each other. Select the appropriate "Character SET", since the appropriate character set has been set in the environment variable ORA_NLS33, you can choose the default is the character set specified by the environment variable, which is typically set to zHS16GBK. Then, the system prompts the password of the System and SYS account. If you need to specify an internal password for DBA and Operator, enter the password, otherwise select "NO", enter the "TNS Listener" password, configure "NO" at the time "Mis Listener" , Accept the default value of the control file, press OK to the next screen, and finally select "YES" to accept these default values. At this point, you will start to create a database, which takes a long time. Finally, after the system prompts "The Requested Action Has Been Performed for SELECTED Products", press "OK" to return to the installation main window and exit the installer. At this point the database is successfully created. 6. Start Oracle Database and Test
1. Start the database If the current user is not Oracle (WHOAMI), log in with the Orcale user after logging in. If you want to access Orcale from the GUI tool on another PC, you need to run TNS Listener, the default configuration is TCP / IP. Specify a port to the NET8 listener, add the following items in the file / etc / service. Listener 1521 / TCP #oracle Net8 Listener Here, Listener is the name of this special listener. This name can be specified by an administrator and must be filled in the file listner.ora. Start listener (Listener): lsnrctl start start an Oracle server: svrmgrl connect internal startup quit now start to create a user profile (profile) of the script with sqlplus: cd $ ORACLE_HOME / sqlplus / admin svrmgrl connect system /
Sqlplus sys / change_on_installsql> ALTER user system identified by new_password; sql> EXIT