Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

CentOS 7 silently installs oracle 11R2 and manually creates the database createdatabase

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.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report