OneRedHat AS4 System Installation:
Disk configuration:
Device type size
/ext3 39911
Swap 1024
Network Basic configuration:
Etho Ip/gateway:192.168.146.2/255.255.255.0
Host Name:Linuxsvr
Gateway:192.168.146.1
Main/TimesDns:202.103.96.68/202.103.96.112
Firewall Basic configuration:
⊙ No Firewall
⊙ is enabledSELinux: Disabled
Options for how to install:
⊙ customizing the packages to be installed (C
Desktop options:
（√X Window System (choose Default)
（√GNOME Desktop Environment (choose default)
（√KDE desktop Environment (choose default)
Application options:
() Engineering and science (choose Default)
() graphical Internet (choose default)
（√) text-based Internet (choose default)
() Office/productivity (choose Default)
Server options:
（√) Server Configuration tool (select All)
() World Wide Web server (select All)
（√Windows File Server (select All)
（ ）DNS server (select All)
Development options:
（√) Development tools (Select All)
System options:
（√) Administration Tool (choose Default)
（√) Print support (choose default)
Miscellaneous options:
Do not select all;
After installation, please locate the following file on the third installation disk and double-click Install. otherwise installedOracle will have an error.
libaio-devel-0.3.103-3.i386.rpm
Please be sure to install the packages listed above or install themOracle system, there will be some unnecessary error messages!
TwoPre-Installation for Oracle:
1. Configure the system kernel parameters toRoot user login, modify the/etc/sysctl.conf file, add the following parameters to the file:
Kernel.shmall = 2097152
Kernel.shmmax = 536870912
Kernel.shmmni = 4096
Kernel.sem = 250 32000 100 128
Fs.file-max = 65536
Net.ipv4.ip_local_port_range = 1024 65000
Net.core.rmem_default = 262144
Net.core.rmem_max = 262144
Net.core.wmem_default = 262144
Net.core.wmem_max = 262144
2. Create a user group to use when installing the databaseOINSTALL,DBA andOracle users, and willThe OINSTALL,DBA group is defined asPrimary and secondary groups for Oracle users. The command reference is as follows:
# Groupadd Oinstall
# Groupadd DBA
# useradd-g OINSTALL-G dba Oracle (setOracle users areOinstall,Members of the DBA user group)
# passwd Oracle (setThe password of the Oracle user)
3. ToRoot User Login System creationdirectory where the installation directory and database files for the Oracle system reside. For example:/oracle, and changing the properties of the above directory command refer to the following:
# mkdir-p/oracle/product/10.2.0 (Create data directory)
# Chown-r Oracle.oinstall/oracle (sets the user group and user to which the directory belongs)
# chmod-r 775/oracle (set directory Read and Write permissions)
4. ToOracle User Login system, copy and decompress10201_database_linux32.zip file to/home/oracle under:
# cp 10201_database_linux32.zip/home/oracle/(copy files toIn Oracle's personal directory)
# Unzip/home/oracle/10201_database_linux32.zip (UnzipZIP file)
5. ConfigurationOracle User Environment toOracle User Login, modifyUnder the Oracle User. bash_profile file. Add the following parameters:
Vi. Bash_profile (ExecutiveVI Command to modify. Bash_profile)
# Get the aliases and functions
If [-f ~/.BASHRC]; Then
. ~/.bashrc
Fi
# User specific environment and startup programs
Path= $PATH: $HOME/bin
Export PATH
Unset USERNAME
# Here's what we need to configure
Umask 022
tmp=/tmp; Export TMP
Tmpdir= $TMP; Export TMPDIR
Oracle_base=/oracle; Export Oracle_base
Oracle_home= $ORACLE _base/product/10.2.0/; Export Oracle_home
Oracle_sid=fstest; Export Oracle_sid
Oracle_term=xterm; Export Oracle_term
Path=/usr/sbin: $PATH; Export PATH
Path= $ORACLE _home/bin: $PATH; Export PATH
Ld_library_path= $ORACLE _home/lib:/lib:/usr/lib; Export Ld_library_path
Classpath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib; Export CLASSPATH
#LD_ASSUME_KERNEL =2.4.1; Export Ld_assume_kernel
6. Restart the operating system:
# reboot (restart command)
Special Note: Because the installationOracle software is not availableRoot (Superuser) to install, you can only use the newOracle users to install, please pay attention to everyone!
ThreeInstallation of oracle10g
1. After restarting the operating system, use theOracle user logs on to the operating systemCorrect installation of Oracle database:
User name:Oracle
The password is:******
ClickThe task bar"→The application"→The System Tools"→The terminal”：
PerformRuninstaller file, startInstallation of Oracle database:
$/home/oracle/database/./runinstaller (ExecuteRuninstaller file)
2, after a short period of time, will appear"Select the Installation method"The Information window;The Advanced installation (A, to continue with the installation, clickNextN"Press the key; enter"Specify the product inventory directory and proof of identitywindow: Confirm the full path to the product inventory directory (D):/oracle/orainventory; Specifies the operating system group name (S):Oinstall; To continue the installation, clickNextNbutton
3. Enter"Select the installation typewindow, clickThe Enterprise Edition (E) (1.26GB), to continue with the installation, clickNextN"Press the key; enter"Specify home directory details"Window; name (M):Oradb10g_home1 Path (A):/oracle/product/10.2.0/; To continue the installation, clickNextNbutton
4. Enter"Product-specific selection checkwindow, after a short period of time, the following inspection Information window will appear;"Checking network configuration needs"In the project, select the contents of the Status column, continue the installation, clickNextN"Press the key; enterThe Select configuration optionwindow, clickThe CREATE DATABASE (C, to continue with the installation, clickNextN"Press the key; enterThe Select Database configurationwindow, click"General purpose (G, to continue with the installation, clickNextN"Press the key; enter"Specify Database configuration options"window; settings in database naming; global database name:Fstest sid:fstest; database Character set: EnglishZHS16GBK; To continue the installation, clickNextNbutton
5. EnterThe Select database Management optionwindow, clickThe useDatabase control Management databases, to continue with the installation, clickNextN"Press the key; enterThe Specify database storage optionswindow, clickThe file system"; Specify the database file location:/oracle/product/10.2.0/oradata/; To continue the installation, clickNextN"Press the key; enter"Specify Backup and recovery optionswindow, click"Do not enable automatic backup, to continue with the installation, clickNextN"Press the key; enterThe password for the specified database schema"Window, click to select"All accounts use the same password, enter the password. To continue with the installation, clickNextN"Press the key; enter"Summary informationwindow, continue with the installation, clickNextN"Press the key; enterThe installation"Window, detailed installation is as follows:A, install part of the film;B, copy the file part;C, the connection Data system part;D, set up the data system part;
6. EnterThe Configuration Assistant"Window: Configuration:When Oracle Database Configuration assistant occurs,"Database Configuration Assistant" New window, detailed configuration process:A, the database file is being copied;B. Creating and startingOracle instance;C, the database is being created, complete the above three sections, a database creation Completion Information Prompt window appears, click"Determinebutton
7. Configuration:Isql*plus Configure the helper program. During the configuration process, an execution configuration script Information Prompt window will appear, run under Terminal, executeorainstroot.sh the process of scripting: clickThe task bar"→The application"→The System Tools"→The terminal”，
$ su root (converted toRoot Super User environment)Password: ****** (inputRoot user's password)
#/home/oracle/orainventory/./orainstroot.sh (Enter the detailed path of the execution script)
Detailed Operation:
#/home/oracle/oracle/product/10.2.0/./root.sh (Enter the detailed path of the execution script)
Execution completeOrainstroot.sh,root.sh script, close"Super User's Terminal", Back toThe Execute configuration scriptPrompt window, continue with the installation, click"Determine"Press the key; enter"End of installationwindow, exit the Setup program, clickExitX"Press the key; Special Note: Please be sure to record the followingWEB URL address (important): the followingThe Java EE application has been configured, and you can use the following list ofURL to access.Enterprise Manager 10g Control URL: clickIsY"button to complete the installation task;
Test the aboveThe WEB URL connection address is normal:
Isql*plus URL: Connection address:
[Url]http://linuxsvr01:11/isqlplus[/url]
Isql*plus DBA URL: Connection address:
[Url]http://linuxsvr01:5560/isqlplus/dba[/url]
Enterprise Manager 10g Database Control URL test:
Connection Address:
[Url]http://linuxsvr01:1158/em[/url]
User name:Sys
Password:******
Connection identity:SYSDBA
To continue logging in, click"I agreebutton
V. Testingoracle10g database:
1. launch oracle10g database Span lang= "en-us" >
$ sqlplus "Scott/tiger as Sysdba"
will appear the following connection database information:
Sql*plus:release 10.1.0.2.0-production on Wednesday 3 month 24 16:23:27 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connect to :
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-production
with the Partitioning, OLAP and Data Mining options
Sql>
indicates that the logon database system was successful, and the startup command was run to start the database.
Sql> startup
ORACLE instance started.
Total System Global area 336356520 bytes
Fixed size 279720 bytes
Variable Size 268435456 bytes
Database buffers 6 7108864 bytes
Redo buffers 532480 bytes
Database mounted.
Database opened.
Sql>
indicates that the database starts normally.
If you get an error at startup:1, #cd/oracle/product/10.2.0/dbs/2#fuser–k lkfstest3#fuser–u Lkfstest
2. Closeoracle10g Database
$ sqlplus "Scott/tiger as SYSDBA"//WithSYSDBA User Login Database
After successfully logging in to the database system, runThe Shudown command closes the database.
sql> shutdown
3. Startoracle10g Monitoring Program
The Listener for Oracle is primarily to provide interfaces for client connections, type the following commands in the console window:
$ lsnrctl
The following listener information will appear:
Lsnrctl for 32-bit windows:version 10.1.0.2.0-production on 2 April-March-2004 16
: 59:51
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Welcome here.Lsnrctl, Please type"Help" for information.
Lsnrctl>
Indicates that the login monitoring console is successful, runningThe start command starts the listener.
Lsnrctl> start
A list of boot and configuration information for the listener will appear.
The last line of the information line isThe "command completed successfully" word, the listener started successfully.
4. Closeoracle10g Monitoring Program
RunThe Stop command closes the listener.
Lsnrctl> stop
Six, setOracle Auto-start and shutdown
1. Editing/etc/oratab, put all theThe restart flag of the instance is set to' Y ', as:
Fstest:/oracle/product/10.2.0:y
2, do a startup script/etc/rc.d/init.d/dbora, as shown below:
#!/bin/bash
#
# chkconfig:35 1
# description:init script to Start/stop Oracle Datab ASE 10g, TNS Listener, EMS, Isqlplus
#
#
#
# Match these values to your environment:
E Xport oracle_home= $ORACLE _base/product/10.2.0
# export oracle_term=xterm
Export path= $PATH: $ORACLE _home/bin
Export nls_lang= ' American_america. ZHS16GBK '
Export oracle_sid=fstest
# export display=localhost:0
Export oracle_user=oracle
# See how We is called:
Case $ in
start)
Su-"$ORACLE _user" <<eoo
Lsnrctl start
Sqlplus/nolog<<eos
Connect/as sysdba
Startup
EOS
Emctl start dbconsole
isqlplusctl start
Eoo
;;
Stop)
Su-"$ORACLE _user" <<eoo
Lsnrctl stop
Sqlplus/nolog<<eos
Connect/as sysdba
Shutdown immediate
EOS
Emctl stop dbconsole
isqlplusctl stop
Eoo
;;
*)
Echo "Usage: $ {start|stop}"
;;
Esac Second, execute the following command with root user
chmod 755/etc/rc.d/init.d/dbora
Chkconfig--add dborachkconfig--level 345 dbora on restart computer see if it takes effect three, close the database: Sqlplus/nologconnect/as sysdbashutdown Immediate
Install oracle10g end version under Linux As4
