LINUX Oracle Installation Collection
Author: Lee Kun Cheng I use the Linux version of Oracle V8.1.6, installed on RedHat Linux 6.0. The installation of oracle includes two parts: the enterprise version of the server and the client, and the user can choose different parts installations according to the actual situation. Here is the main introduction of the enterprise, the client's installation method is relatively simple. Server-side installation is divided into: Typical installation, minimum installation, and custom installation. Client installation is divided into: administrator client, programmer client, application user client, custom installation client. ■ System Demand 1. Hardware Demand ● Memory Minimum Configuration is 128MB, it is recommended to use 256MB; ● The hard disk swap partition is at least more than 400MB or more than twice the memory; ● Hard disk size requirements: Server Typical installation 750MB minimum installation 675MB custom installation 1GB Client administrator 350MB programmer 260MB application user 150MB custom installation 470MB 2. Software requirements ● Linux system kernel requirements are V2.2 or above version; ● Java Runtime Environment (jre) requires V1.1.6 or above; ● System must Support X window. ■ Preparation before installation 1. Modify the system kernel to /usr/rc/linux/include/ASM/HMParam.h file as follows: The modified amount of modified value SHMMAX memory size * 0.5 shmmin 1 shmmni 100 shmseg 10 pair /usr/src/linux/include/linux/sem.h file as the following modification: modified modified value Semmni 100 Semmsl Processes parameter 10 segmns All Database Processes Parameters Total 10 Semopm 100 SemVMX 32767 Parameter After modification, "Make dep", "make clean", "make bzimage" command recompiled the kernel and launched the computer with a new kernel. 2. The system user and installation directory is built in Oracle's technical documentation. It is recommended to establish two groups -oinstall, DBA for the database, but in actual use of the pen, you can successfully install Oracle smoothly, without affecting the system Use; you need to add a user Oracle to the database, which belongs to the DBA group; builds the /u01/app/oracle/8.1.6 directory, and sets its owner to Oracle.dba. 3. Setting environment variables is not required for each environment variable, but setting them makes your installation and use more convenient, this can be seen during the back installation.
Edit the .bash_profile of the Oracle User's Home to Set Environment Variables: Oracle_Home = / U01 / App / Oracle / Product / 8.1.6 Export Oracle_Home / 包括 包括 Copy of Oracle Software / LD_Library_Path = / U01 / App / Oracle / Product / 8.1.6 / lib; Export LD_Library_Path Oracle_base = / u01 / App / Oracle EXPORT ORACLE_BASE / Include Oracle Software Directory and Management Software Directory / ORACLE_SID = ORCL EXPORT ORACLE_SID / Default Database / ORACLE_TERM = VT100 EXPORT Oracle_Term ORA_NLS33 = / U01 / App / Oracle / Product / 8.1.6 / Ocommon / NLS / Admin / Data Export ORA_NLS33 / Language Support / PATH = $ PATH: /U01/App/Orcle/Product/8.1.6/bin Export Path is a user who has a smaller memory, which may have insufficient memory when installing Oracle in X Window. At this time, it is necessary to set up the Display variable. Its role is to output the X Window installation interface that should be output locally to DISPLAY. On the host, the method is set, the method is as follows: display = 192.168.0.20: 0.0 Export Display Also set a variable on the output: XHOST ServerName; indicates that the server is allowed to send the X WINDOW display interface to the terminal, which can be lowered Server-end workloads saving system resources when installed. 4. Installing Java Runtime Environment (jre) Since the installation of the database is based on X Window graphical interface, it is a Java program, so it requires support for Java Runtime Environment (JRE). 5. Establish an installation source directory If the user is installed, you must first shoot the optical drive into a directory - "mount / dev / cdrom"; if the user uses the downloaded tar.gz file, you must first put this file first. Unzip into the / tmp directory and then authorize the generated installation directory to Oracle.dba.
■ Database installation 1. Run "./RunInstaller" with Oracle User Directory, run "./runinstaller", start installing; 2. Enter the installation interface "Next", display the interface of the setting directory; if the user's environment variable setting is correct The directory in this interface automatically completes the settings, otherwise you must select the directory through the "Browse" button, click "Next", go to the next step; 3. The remaining work is very simple, just follow the prompts No problem, but there are some places to pay attention to: ● Add "DBA" in the UNIX Group Name field; ● Select "Oracle8i Enterprise Edition"; ● Installation Type Select "Custom"; ● Do not choose Intermediate in the installation content Technical data introduction, this software is not very stable, why should we find trouble! ● When inquiring if the database is set up, select "NO" because we have to build a database with the special tool provided by Oracle; ● Do two files as root during the installation process - just use the su command to make an identity Convert it. 4. The key is that it is not a problem that it is not a problem. In fact, the process of installing the database system is still very simple. From the technical perspective, all the parameters set when setting the database can be modified after the database is built, so the user does not need to worry about what it is wrong, and it is only necessary to seriously see the prompt in each step. Here the author has a small suggestion: if the user is an initiator, it is best to choose a typical installation when establishing a database, which can avoid complex database settings, reduce trouble. But this option may cause some problems in use, such as: system table space is small, record files are not partitioned, and database files are too large or too small. If the user is very familiar with the basic concepts and functions in the Oracle database, it has a deep understanding of their needs, then the database installation type selection is a custom installation is the upright policy. If the computer used to install is not very high, the process of installing the database will grow long. There will be two default database administrator users after the installation is complete: SYS, the password is change_on_install; system, the password is Manager. From the perspective of system security, it is recommended that the first thing to do is to change the password of these two users. The method is to modify it in SQLPLUS after starting the database. The specific method will be mentioned later. ■ Let the database work 1. Start the database Start the database is very simple, just run the following command as long as the Oracle user is running.
