Oracle9i released many new features in Oracle Open World on Oracle Open World, introduced many new features for Oracle Database, Application Server, and Development Tools. Oracle9i is the first integrity, simple, simply used for the Internet, and software infrastructure for various applications for the Internet. Oracle9i actually refers to the complete integration of Oracle9i Database, Oracle9i Application Server, and Oracle9i Developer Suite. As the software gradually begins to transition to a hosted service, high telescopic performance, intelligent, and reliable Oracle9i, which has an Internet, will become a key software implemented by high quality e-commerce services. This article will introduce Oracle Database 9i installation procedure under Linux, if you have experienced Oracle's experience This installation process can be powered quickly; if you have never installed Oracle database under Linux, then we are from this An article began to be familiar with Oracle installation process. System Requirements: The following system requirements apply to typical Oracle installation and create simple databases. Memory: Installing Oralce 9i software requires at least 512M memory, with the following command to view the memory size of the machine:
GREP MEMTOTAL / PROC / MEMINFO
Memtotal: 900252 KB
900252KB is your system's memory size. Exchange area: The size of the exchange area is generally twice the memory, at least 400m or more, and of course, the bigger the better, the following command can view the size of the system exchange area:
/ SBIN / SWAPON -S
Filename Type Size Used Priority
/ DEV / SDA6 Partition 105221 686976 -1
The 105221 is the size of the system exchange area. Optical drive: If you use CD to install Oracle9i, you need 8 speed or more CDROM on your machine. If you are downloaded Oracle9i package file, you don't need to use CDROM. Hard disk space: Installing the Oracle9i database at least 2.5GB of remaining space. Temporary hard disk space: Oracle installer requires more than 400M or more temporary hard disk space during installation, it is recommended to use the / TMP folder as a zero folder. If the / TMP file does not have enough hard drive, you can newly create a file clamp as a temporary Directory, then set environment variables TEMP and TMPDIR to point to the appropriate location, for example: use BASH
MKDIR / HOME / TEMP
Temp = / home / temp; Export Temp
TMPDIR = / home / temp; export tmpdir
Use CSH
MKDIR / HOME / TEMP
SetENV TEMP / HOME / TEMP
SetENV TMPDIR / HOME / TEMP
Operating system: Oracle officially published information to Oracle 9i only on Sususe 7.1, kernel 2.4.4 and glibc2.2 system test pass, through my test, Oracle in Linux Mandrake Release 8.0, core 2.4.3-20 And the version of GLIBC-2.2.2 can also be installed smoothly. This article will introduce Oracle9i installation processes with Linux Mandrake 8.0 as an example. Virtual X-Windows Software: This software is not necessary! The so-called virtual X-Windows software refers to virtual software that can allow server X-Windows on the remote terminal. Now there is an Exceed, X-Win32 software, if you are suspected of installing Oracle system in the console, you can Use virtual X-Windows software to install Oralce9i under the graphical interface under the graphical interface, which will be described as an example of installing Oracle9i with virtual X-Windows with X-WIN32 5.0. JDK If you want to install Oracle Http Server, you need to use BlackDown JDK1.3.1, please download ftp: //ftp.progsoc.uts.edu.au/pub/linux/java/jdk-1.3.0/i386 /rc1/j2sdk-1.3.0-rc1-linux-i386.tar.bz2 Configuring the kernel parameter Oracle9i uses Linux shared memory, exchange zones and other resources, if your kernel parameter setting does not meet the requirements of Oracle, then installation ORACEL9I or use procedure will eventually have problems, so configuring the parameters of the system kernel are especially important and critical. The configuration of the kernel parameters is generally configured under the / proc folder: 1. Allow the following commands in the root user; 2. Enter the directory / proc / sys / kernel; 3. Use the CAT command or more command to view the value of the Semaphore current parameter:
The Cat Sem command will appear as follows:
250 32000 32 128 Where 250 is the value of the parameter SEMMSL, 32000 is the value of the parameter SEMMNS, 32 is the value of the parameter SEMOPM, and 128 is the value of the parameter SEMMNI. 4. Use the following command to modify the above parameters
echo SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value> sem wherein SEMMSL_value, SEMMNS_value, SEMOPM_value, SEMMNI_value were replaced with the appropriate values, and the order of the values provided irreplaceable 5. The size of shared memory, the shared memory is usually set to half the size of physical memory, where We assume that the physical memory is 512m, the value of the shared memory is pushed. If your physical memory is 1G, the value here is 8589934590:
Echo 4294967295> SHMMAX Add User Oracle requires a specific user (non-root user) in installation and use, according to Oracle's standard description is to add three special users and user groups, in order to easily install and use our installation of Oracle And use the use of a specific user to do. First create an Oracle user group, we have set this user group to DBA: Log in to the system in the root user; run the groupAdd DBA command to add a DBA user group; add Oracle users: Log in to the system under the root user;
After running a useeradd -g dba -p password -d / oracle -s / bin / bash Oracle running the system, a user Oracle belonging to the DBA user group, the password is Password, the main directory / Oracle uses Bash this user will be used as the system Install and use the specified user, so keep it in a safe place! Creating an installation point (Mount Point) Oracle9i typical installation requires at least two installation points: a basic runner, requires at least 850m hard disk space; one is a stored database, at least 450m hard disk space. To simplify the installation, we can put the running program and database under the same installation point. Find a partition with enough space on your file system, create a folder under partition, we assume that this folder is / oracle. Configuring System Environment Variables Many netizens have installed Oracle failure because environmental variables are not configured correctly, and the configuration of environment variables directly affects the installation and configuration of Oracle9i later. It is especially careful when configuration! Configuring the X-Windows Variable Confirm whether Oracle9i uses local X-Windows installation during installation or remote virtual X-Windows installation, if you need a remote X-Windows installation, you need to configure the Display variable, this variable is used to tell the system screen. What location is output, by default, this is a machine, if you use virtual X-Windows installation, you indicate the display of remote terminals, such as your remote terminal's IP address is xxx.xxx.xxx.xxx DISPLAY The variable should be "xxx.xxx.xxx.xxx: 0" indicates the first display of the terminal. Determine the installation Temporary Directory We mention that Oracle9i installation requires a temporary writable space, where we are here for temporary writable directories. If you are not using / tmp as a temporary written directory, you need to configure the corresponding value TmpDir = / Path. Configuring Oracle Environment Variables The following is provided to provide you with reference to use export display = "192.9.200.24:0.0"
Export Bash_ENV = $ HOME / .BASHRC
Oracle_Home = / Oracle / Product / 9.0.1; Export Oracle_home
Oracle_sid = Oracle; Export Oracle_sid
Oracle_Term = xterm; Export Oracle_Term
TNS_ADMIN = / Home / Oracle / Config / 9.0.1; Export TNS_ADMIN
NLS_LANG = american_america.zhs16GBK; Export NLS_LANG
ORA_NLS33 = $ Oracle_Home / Ocommon / NLS / Admin / Data; Export ORA_NLS33
LD_LIBRARY_PATH = $ ORACLE_HOME / LIB; EXPORT LD_LIBRARY_PATH
Path = $ path: / bin: / usr / bin: / usr / sbin: / etc: / OPT / bin:
/ usr / ccs / bin: / usr / openwin
Path = $ path: / OPT / local / bin: / OPT / NSCPNAV / BIN: $ Oracle_Home / Bin
Path = $ path: / usr / local / samba / bin: / usr / ucb:
Export Path
ClassPath = $ oracle_home / jre: $ oracle_home / jlib:
$ Oracle_home / rdbms / jlib
ClassPath = $ ClassPath: $ oracle_home / network / jlibtmpdir = / tmp; export tmpdir
Umask 022
Among them: Oracle_Home is the installation directory of the system software; Oracle_sid is the SID of the database, here you can set it yourself; NLS_LANG is the character set of the database, in order to ensure that the database can output the input database, we need to set the character to American_America.zhs16GBK, where American_america English character set, zhs16gbk is a Chinese character set. Log in to the system with an Oracle user,
VI $ home / .bash_profile passes the settings of the above environment variables into the file, confirms the corresponding content and modifies, and the deployment exits. Re-landing Oracle users use the set | more command to see if the oracle user's environment variable takes effect
ClassPath = / Oracle / Product / 9.0.1 / jre: /oracle/product/9.0.1/jlib:
/Oracle/Product/9.0.1/rdbms/jlib:
/ Oracle/Product/9.0.1/neetwork/jlib
DISPLAY = 192.9.200.24: 0.0
LD_LIBRARY_PATH = / Oracle / Product / 9.0.1 / lib: / lib: / usr / lib:
NLS_LANG = American_America.zhs16GBK
Oracle_Home = / Oracle / Product / 9.0.1
Oracle_sid = Oracle
Oracle_Term = xterm
ORA_NLS33 = / Oracle / Product / 9.0.1 / Ocommon / NLS / Admin / Data
Ostype = Linux-GNU
Path = / usr / local / bin: / bot: / usr / bin: / usr / x11r6 / bin: / usr / games:
/ bin: / usr / bin: / usr / sbin: / etc: / OPT / bin: / usr / ccs / bin: / usr / openwin:
/ OPT / local / bin: / opt / nscpnav / bin:
/oracle/product/9.0.1/bin:/usr/local/samba/bin:/usr/UCB:
TNS_ADMIN = / Home / Oracle / Config / 9.0.1
Take a closer look at the above items, make sure it is set correctly. Install orract9i Install JDK1.3.1 Put the downloaded J2SDK-1.3.0-RC1-Linux-i386.tar.bz2 file to the server / usr / local / directory, log in with the root user, use BZIP-D J2SDK-1.3. 0-rc1-linux-i386.tar.bz2 command first solves the file into TAR format, then use TAR XVF J2SDK-1.3.0-RC1-Linux-i386.tar.bz2 to decompress it, to make a folder in order to facilitate operation Change to JDK .. Configure the installation of X-Windows Oracle9i to support all X-Windows, also support remote virtual X-Windows installation, if you want to be installed on the console on the console to log in with our previously created Oracle users (note must set it first Environment variables, and set the DISPLAY's value to EXPORT Display = "" "Run the startX command to enter X-Windows. If you need to install the remote terminal using virtual X-Windows, you need to install X-Win32 software in the customer, we don't introduce it, and then run the X-win32 command after the installation is completed in your taskbar. A X of the Peugeot will appear. Terminal attacks using NETERM Take the Oracle User Login System to confirm that the environment variable has taken effect and the value of the Display variable is the IP address of your terminal, run the startkde command to start X-windows, and then the system will have a lot of error message after running. Ignore no matter, after a few seconds, Linux's KDE interface will appear on your remote terminal. Download Oracle Installation Software Oracle Web Site (http://otn.racle.com) now provides Oracle9i for Linux software download, please read his License carefully before downloading, so there will be no copyright issues in future use. You need a OTN account before downloading, the application is free, as long as you answer a few questions, Oracle9i's installer has three file packages: Linux9i_disk1.cpio.gz (412,092kb)
Linux9i_disk2.cpio.gz (638,547kb)
Linux9i_disk3.cpio.gz (82,956kb)
After downloading these three files, upload these three files into the server / oracle directory and ensure that the host of these three files is Oracle users. If you have an Oracle9i installation CD that you can save a big download time. Installing the Oracle 9i database With Oracle User Login System, start local X-Windows or virtual X-Windows, open a console window, and enter the directory that has just been stored in the Oracle file, use
Gunzip Linux9i_disk1.cpio.gz
CPIO -IDMV
Command unpack, compress three files into three installation folders, DISK1, Disk2, Disk3, respectively. Enter Disk1 Directory
CD disk1 knock in the console window
./RunInstaller & run, an OUI graphical interface will appear, as shown below: The middle green window is the installation graphical interface of Oracle. Let's take the most basic installation of Oracle9i, after entering the installation interface, click Next: Source refers to the file containing Oracle product information, in general, he will automatically recognize, if you can't find the Browse button Manually specify the path. Destination refers to the path to which 9i will be installed here is $ ORACLE_HOME we set in the environment variable. If you are blank in this column, you have to retrieve whether the settings in the environment variable are incorrect. After confirming the correct, press Next: This step has three installation options for options: Oracle9i Database 9.0.1.0.0, install Oracle9i's database server version, management tools, network services, and basic client software; Oracle9i Client 9.0.1.0 .0, enterprise version of client software, network services, and development tools, etc. Oracle9i MANGEMENT AND INTEGRATION 9.0.1.0.0, Install Management Server, Management Tool Oracle's network directory, integrated service, network services, and basic client software. We selected the first install Oracle9i database service, then Annxt button; this step is to select the type of Oracle installation, three types to select Enterprise Edition, Enterprise Edition, StandStard Edition Peugeot Edition, Custom Custom Installation, We choose Enterprise Edition Installation, if you are more familiar with Oracle's products, you can choose Custom Custom Installation, press your own requirements to select components to install, confirm that the next step will enter the next step; here you can choose a database suitable for you Template, usually we choose the first universal database template. If you need to use a data warehouse, you can use the template to select the data warehouse to install. After confirming, press Next to enter the next step; this step is to confirm the name of Oracle9i's SID and global database, SID's value we have already set in environment variables, so here is automatically displayed, global database name (Global Database Name) You can also specify the same value as the SID. After confirmation, press Next to enter the next step; before we mentioned that the character type of the database is critical in the database superposed, this step is to set the character set of the database, we set up before we set up Is NLS_LANG = American_america.zHS16GBK, so we select SimplifiLled Chinese ZHS16GBK, press Next to enter the next step; The button specifies the directory of the previously installed JDK so that the system can find the required application during the installation process, and confirm that press next to enter the next step; after all the selection is performed, the system will give an installation summary. Here, you will listen to the installation. Components, confirm that what you want to install is in the list, An Install button is installed, if you do not need to install other programs, press EXIT to exit the installation interface.
Oracle's installation speed view server's performance is generally a 30-minute time. You may have a dialog box in the installation process. There will be some command to run in the dialog to ask you to execute, then open a control. Table window, SU into root and run the command in the prompt box. After running, press OK to continue installation; after installing the database, the system will run the configuration tool to network and database configurations for the system. After the configuration is complete, the system will automatically start the database and open Oracle Web Server. After all configuration is finished, press Next to complete the installation. If everything is normal, the OUI will appear the words of The Installation of Oracle9i Database Was Success, which indicates that your Oracle9i database is installed properly. If you need to install other content, press the NEXT Install button to make the installation of other content, otherwise, press EXIT to exit installation. After installing the Oracle 9i database, the Oracle database will start automatically. Here we use the actual superheet to indicate the launch and off of the Oracle 9i database. Log in to the database with Oracle users, open a console window; turn off the Oracle 9i database [Oracle @ Wing / Oracle] $ SQLPLUS "/ as sysdba" // Log in to the database with SYSDBA users
SQL * Plus: Release 9.0.1.0.0 - Production On Wed Jul 11 15:35:31 2001
(c) CopyRight 2001 Oracle Corporation. All Rights Reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
WITH THE PartInog Option
JServer Release 9.0.1.0.0 - Production
Run the shudown command to turn off the database
SQL> Shutdown
Database closed.
Database dismount.
Oracle Instance Shut Down.
SQL>
Launch Oracle 9i Database
[Oracle @ wing bin] $ SQLPLUS "/ as sysdba"
SQL * Plus: Release 9.0.1.0.0 - Production On Wed Jul 11 16:00:59 2001
(c) CopyRight 2001 Oracle Corporation. All Rights Reserved.
Connected to an iDLE Instance.
SQL> Startup
Oracle Instance Started.
Total System Global Area 336356520 Bytes
Fixed size 279720 bytes
Variable size 268435456 bytes
Database buffers 67108864 bytes
Redo buffers 532480 bytes
Database mounted.
Database opened.
SQL>
Launch Oracle 9i Listener Oracle's listener is mainly to provide interfaces for client connections
[Oracle @ wing bin] $ lsnrctl
Lsnrctl for Linux: Version 9.0.1.0.0 - Production On 11-Jul-2001 16:12:17
Copyright (C) 1991, 2001, Oracle Corporation. All Rights Reserved.welcome To Lsnrctl, Type "Help" for Information.
LSNRCTL> START
Starting /oracle/Product/9.0.1/bin/tnslsnr: please wait ...
TNSLSNR for Linux: Version 9.0.1.0.0 - Production
System parameter file is /racle/product/9.0.1/network/admin/listener.ora
Log Messages Written to /Oracle/Product/9.0.1/neetwork/log/listener.log
Listening on: (Description = (Address = (protocol = ipc)))))))) (key = extproc)))
Listening ON: (deScription = (address = (protocol = tcp) (port = 11)))))))
Connecting to (deScription = (address = (protocol = ipc))))
Status of the listener
---------------------------------------------------------------------------------------------------------------------------------------
Alias Listener
Version TNSLSNR for Linux: Version 9.0.1.0.0 - Production
Start Date 11-Jul-2001 16:12:58
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level Off
Security off
SNMP OFF
Listener parameter file /oracle/product/9.0.1/neetwork/admin/listener.ora
Listener log file /oracle/product/9.0.1/neetwork/log/listener.log
Listening Endpoints Summary ...
(Description = (Address = (protocol = ipc)))))
(Description = (Address = (protocol = tcp) (host = wing))))))))
Services Summary ...
Service "PLSextProc" HAS 1 Instance (s).
Instance "PLSextProc", Status Unknown, HAS 1 Handler (s) for this service ...
Service "Oracle" HAS 1 Instance (s).
Instance "Oracle", STATUS UNKNOWN, HAS 1 Handler (s) for this service ...
THE Command Complated SuccessFully
Lsnrctl>
Close Oracle 9i listener
[Oracle @ wing bin] $ lsnrctl
Lsnrctl for Linux: Version 9.0.1.0.0 - Production On 11-Jul-2001 16:12:17
CopyRight (C) 1991, 2001, Oracle Corporation. All Rights Reserved.
Welcome to lsnrctl, Type "Help" for Information.lsnrctl> STOP
Connecting to (deScription = (address = (protocol = ipc))))
THE Command Complated SuccessFully
Lsnrctl>
Close Oracle Web Server
CD $ Oracle_Home / Apache / Apache / Bin
./stopjServ.sh
/ Oracle/Product/9.0.1/apache/apache/bin/apachectl stop: httpd stopped
Launch Oracle Web Server
CD $ Oracle_Home / Apache / Apache / Bin
[Oracle @ wing bin] $ ./startjserv.sh
/ Oracle/Product/9.0.1/apache/apache/bin/apachectl start: httpd start
The default port number after launching Oracle Web Server is 7777 In the client browser address bar, enter http://xx.xx.xxx.xxx:7777/ If the browser appears the following interface, the Oracle Web Server is operating normally.
