In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Official document: http://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm#BHCCADGD
Required installation package:
Binutils-2.23.52.0.1-12.el7.x86_64
Compat-libcap1-1.10-3.el7.x86_64
Compat-libstdc++-33-3.2.3-71.el7.i686
Compat-libstdc++-33-3.2.3-71.el7.x86_64
Gcc-4.8.2-3.el7.x86_64
Gcc-c++-4.8.2-3.el7.x86_64
Glibc-2.17-36.el7.i686
Glibc-2.17-36.el7.x86_64
Glibc-devel-2.17-36.el7.i686
Glibc-devel-2.17-36.el7.x86_64
Ksh
Libaio-0.3.109-9.el7.i686
Libaio-0.3.109-9.el7.x86_64
Libaio-devel-0.3.109-9.el7.i686
Libaio-devel-0.3.109-9.el7.x86_64
Libgcc-4.8.2-3.el7.i686
Libgcc-4.8.2-3.el7.x86_64
Libstdc++-4.8.2-3.el7.i686
Libstdc++-4.8.2-3.el7.x86_64
Libstdc++-devel-4.8.2-3.el7.i686
Libstdc++-devel-4.8.2-3.el7.x86_64
LibXi-1.7.2-1.el7.i686
LibXi-1.7.2-1.el7.x86_64
LibXtst-1.2.2-1.el7.i686
LibXtst-1.2.2-1.el7.x86_64
Make-3.82-19.el7.x86_64
Sysstat-10.1.5-1.el7.x86_64
UnixODBC-2.3.1-6.el7.x86_64 or later
UnixODBC-2.3.1-6.el7.i686 or later
UnixODBC-devel-2.3.1-6.el7.x86_64 or later
UnixODBC-devel-2.3.1-6.el7.i686 or later
Yum to install:
Yum-y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*i686 compat-libstdc++-33*.devel compat-libstdc++-33 compat-libstdc++-33*.devel gcc gcc-c++ glibc glibc*.i686 glibc-devel glibc-devel*.i686 ksh libaio libaio*.i686 libaio-devel libaio-devel*.devel libgcc libgcc*.i686 libstdc++ libstdc++*.i686 libstdc++-devel libstdc++-devel*.devel libXi libXi*.i686 libXtst libXtst*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686
Create oinstall and dba groups
/ usr/sbin/groupadd oinstall
/ usr/sbin/groupadd dba
Create an oracle user
/ usr/sbin/useradd-g oinstall-G dba oracle
Set the oracle user password
Passwd oracle
Verify that the creation is correct
[root@node1001 ~] # id oracle
Uid=1000 (oracle) gid=1000 (oinstall) group = 1000 (oinstall), 1001 (dba)
Configure kernel parameters
[root@docker ~] # vim / etc/sysctl.conf
# System default settings live in / usr/lib/sysctl.d/00-system.conf.
# To override those settings, enter new settings here, or in an / etc/sysctl.d/.conf file
#
# For more information, see sysctl.conf (5) and sysctl.d (5).
Fs.aio-max-nr = 1048576
Fs.file-max = 6815744
Kernel.shmall = 2097152
Kernel.shmmax = 536870912
Kernel.shmmni = 4096
Kernel.sem = 250 32000 100 128
Net.ipv4.ip_local_port_range = 9000 65500
Net.core.rmem_default = 262144
Net.core.rmem_max = 4194304
Net.core.wmem_default = 262144
Net.core.wmem_max = 1048576
The value of the parameters cannot be less than the above configuration, which is the minimum recommended by oracle. The production environment recommends that you adjust these parameters to optimize system performance.
Modify it to make it effective
/ sbin/sysctl-p
Modify user restrictions
Vim / etc/security/limits.conf
# add at the end
Oracle soft nproc 2047
Oracle hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536
Oracle soft stack 10240
Create an installation directory
Mkdir-p / u01/app/
Chown-R oracle:oinstall / u01/app/
Chmod-R 775 / u01/app/
Configure environment variables
Su-oracle
Vim .bash _ profile
# append to the end of the file:
# oracle database installation directory
Export ORACLE_BASE=/u01/app
# oracle database path
Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/dbhome_1
# oracle launch database instance name
Export ORACLE_SID=orcl
# add system environment variables
Export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
# add system environment variables
Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
To make bash_profile effective:
Source .bash _ profile
Extract the oracle database installation package
Unzip p13390677_112040_Linux-x86-64_1of7.zip
Unzip p13390677_112040_Linux-x86-64_2of7.zip
Modify the silent installation configuration file / home/oracle to the oracle installation file directory
Vim / home/oracle/database/response/db_install.rsp
The configuration is as follows:
Oracle.install.option=INSTALL_DB_SWONLY / / installation type
ORACLE_HOSTNAME=node1001// host name (hostname query)
UNIX_GROUP_NAME=oinstall / / installation group
INVENTORY_LOCATION=/u01/app/oraInventory / / INVENTORY directory (left empty is the default)
SELECTED_LANGUAGES=en,zh_CN,zh_TW / / Select language
ORACLE_HOME=/u01/app/product/11.2.0.4/dbhome_1 / / oracle_home
ORACLE_BASE=/u01/app / / oracle_base
Oracle.install.db.InstallEdition=EE / / oracle version
Oracle.install.db.isCustomInstall=false / / Custom installation, No, use default components
Oracle.install.db.DBA_GROUP=dba / / dba user group
Oracle.install.db.OPER_GROUP=oinstall / / oper user group
Oracle.install.db.config.starterdb.type=GENERAL_PURPOSE / / database type
Oracle.install.db.config.starterdb.globalDBName=orcl / / globalDBName
Oracle.install.db.config.starterdb.SID=orcl / / SID
Oracle.install.db.config.starterdb.memoryLimit=81920 / / automatically manage memory (M)
Oracle.install.db.config.starterdb.password.ALL=oracle / / set all database users to use the same password
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false / / (false is manually written)
DECLINE_SECURITY_UPDATES=true / / set security update (there seems to be bug, this must be selected true, otherwise it will infinitely remind you that there is a problem with the email address and terminate the installation. PS: no matter whether the address is correct or not)
Start silent installation
[oracle@node1001 database] $. / runInstaller-silent-responseFile / home/oracle/database/response/db_install.rsp
View the installation directory
Tail-f / u01/app/oraInventory/logs/installActions2016-08-31, 06-56-29PM.log
A prompt similar to the following indicates that the installation is complete:
The following configuration scripts need to be executed as the "root" user.
#! / bin/sh
# Root scripts to run
/ u01/app/oraInventory/orainstRoot.sh
/ u01/app/product/11.2.0/db_1/root.sh
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts
4. Return to this window and hit "Enter" key to continue
Successfully Setup Software.
Switch to root user to execute sh script
Su-root
/ u01/app/oraInventory/orainstRoot.sh
/ u01/app/product/11.2.0.4/dbhome_1/root.sh
Switch to the oracle user and configure the listener
Su-oracle
Netca / silent / responsefile / home/oracle/database/response/netca.rsp
Edit the listening file manually
Vim $ORACLE_HOME/network/admin/listener.ora
Monitor the contents of the file
# listener.ora Network Configuration File:
/ u01/app/product/11.2.0.4/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
# LISTENER =
# (DESCRIPTION_LIST =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
# (ADDRESS = (PROTOCOL = TCP) (HOST = node1003) (PORT = 1521)
#)
#)
# ADR_BASE_LISTENER = / u01/app
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = / u01/app/product/11.2.0.4/dbhome_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.64.4) (PORT = 1521))
)
Start the listener
Lsnrctl start
Edit the database control file according to the actual situation
Vim $ORACLE_HOME/dbs/initorcl.ora
* .audit_file_dest='/u01/app/admin/orcl/adump'
* .audit_trail='db'
* .compatible='11.2.0.4'
* .control_files='/u01/app/oradata/orcl/ora_control1'
* .db_block_size=8192
* .db_domain=''
* .db_name='orcl'
* .db_recovery_file_dest_size=2G
* .db_recovery_file_dest='/u01/app/fast_recovery_area'
* .diagnostic_dest='/u01/app'
* .memory_target=8G
* .open_cursors=150
* .processes=300
* .remote_login_passwordfile='EXCLUSIVE'
* .undo_tablespace='UNDOTBS1'
Start the database, ready to create the database
Sqlplus / as sysdba
Startup mount
= manually create the database statement as follows: =
Make adjustments according to the actual situation
Create database orcl
Maxlogfiles 5
Maxlogmembers 5
Maxdatafiles 100
Maxinstances 1
Logfile
Group 1 ('/ u01max size size 200m)
Group 2 ('/ u01 size size 200m)
Group 3 ('/ u01max size size 200m)
Datafile
'/ u01applash size oradata reuse system. Dbf' oradata 200m
Sysaux datafile'/ u01 size
Default tablespace users
Datafile'/ u01 size
Undo tablespace undotbs1
Datafile'/ u01 size applash oradata size undo1.dbf'
Default temporary tablespace temp1
Tempfile'/ u01qapqapram oradatamax orclplettemp01.dbf'
Size 100m reuse
Character set al32utf8
After manually creating the database, the relevant script files are executed successively under sqlplus
@ $ORACLE_HOME/rdbms/admin/catalog.sql
@ $ORACLE_HOME/rdbms/admin/catproc.sql
After the execution is complete, the database is created and the database status is checked.
Select status from v$instance
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.