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

Linux CentOS7 minimize installation environment silently install the Oracle11GR2 database (silently create an instance)

2025-02-24 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Perform preparatory work before installation:

1. Install operating system: https://blog.51cto.com/mflag/2300359

two。 Install dependency package: https://blog.51cto.com/mflag/2300909

3. Upload and extract the installation package; https://blog.51cto.com/mflag/2300912

4. Modify the configuration file: https://blog.51cto.com/mflag/2300914

Required skills of operation, maintenance and network management: linux centos7 command line silent installation oracle11GR2 video course video course: http://edu.51cto.com/course/15530.html

We have installed the software in the last section, and in this section we will create a database instance

Exit SQLPLUS: quit

Configuration response file: vim / home/oracle/response/dbca.rsp

Modify the content:

GDBNAME = "orcl"

SID = "orcl"

To delete the previous #, set the password corresponding to the user

SYSPASSWORD = "enter password"

SYSTEMPASSWORD = "enter password"

SYSMANPASSWORD = "enter password"

DBSNMPPASSWORD = "enter password"

To delete the previous #, set the directory corresponding to the user

DATAFILEDESTINATION = / data/u01/app/oracle/oradata

RECOVERYAREADESTINATION=/data/u01/app/oracle/fast_recovery_area

To delete the previous #, set the character set (usually changed when used in China)

Very important, set the character set: CHARACTERSET = "AL32UTF8"

Increase the memory size, generally 1.5-2 times the physical memory size

TOTALMEMORY = "2048"

: wq

Check configuration

Egrep-v "(^ # | ^ $)" / home/oracle/response/dbca.rsp

Installation creation:

Dbca-silent-responseFile / home/oracle/response/dbca.rsp

Complete

You can view the default instance

Env | grep ORACLE_UNQNAME

Enter sqlplus to start the instance

Startup

The above figure indicates that the instance has been set up and there is no need to start it again.

After shutdown, you can use startup.

Required skills of operation, maintenance and network management: linux centos7 command line silent installation oracle11GR2 video course video course: http://edu.51cto.com/course/15530.html

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