Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to install a single instance of the character interface in the ORACLE-LINUX environment. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Single instance installation of ORACLE character interface

Vi / etc/sysconfig/network-scripts/ifcfg-eth2

Vi / etc/yum.repos.d/520.repo

(6) create an installation directory

Mkdir / u01/app/oraInventory

Chown-R oracle.oinstall / U01

(7) set oracle environment variable

Cp / mnt/usb/ linux.x64_11gR2_database* / u01/

Decompress:

Unzip linux.x64_11gR2_database_1of2.zip

Unzip linux.x64_11gR2_database_2of2.zip

Cp / u01/database/response/db_install.rsp / u01/database/response/db_install.rsp.bak

Set response file permissions

Su-root

Chmod 700 / u01/database/response/*.rsp (note owner, oinstall)

Chown oracle.oinstall / u01/database/response/*.rsp

2. Install Oracle software silently

Su-oracle

Modify the response file / u01/database/response/db_install.rsp for installing Oracle software

Oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

Oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=ciptest6

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/u01/app/oraInventory

SELECTED_LANGUAGES=en

ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

ORACLE_BASE=/u01/app/oracle

Oracle.install.db.InstallEdition=EE

Oracle.install.db.isCustomInstall=false

Oracle.install.db.customComponents=

Oracle.install.db.DBA_GROUP=dba

Oracle.install.db.OPER_GROUP=dba

Oracle.install.db.CLUSTER_NODES=

Oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

Oracle.install.db.config.starterdb.globalDBName=ciptest6

Oracle.install.db.config.starterdb.SID=ciptest6

Oracle.install.db.config.starterdb.memoryLimit=

Oracle.install.db.config.starterdb.memoryOption=false

Oracle.install.db.config.starterdb.installExampleSchemas=false

Oracle.install.db.config.starterdb.enableSecuritySettings=true

Oracle.install.db.config.starterdb.password.ALL=

Oracle.install.db.config.starterdb.password.SYS=

Oracle.install.db.config.starterdb.password.SYSTEM=

Oracle.install.db.config.starterdb.password.SYSMAN=

Oracle.install.db.config.starterdb.password.DBSNMP=

Oracle.install.db.config.starterdb.control=DB_CONTROL

Oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=

Oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false

Oracle.install.db.config.starterdb.dbcontrol.emailAddress=

Oracle.install.db.config.starterdb.dbcontrol.SMTPServer=

Oracle.install.db.config.starterdb.automatedBackup.enable=false

Oracle.install.db.config.starterdb.automatedBackup.osuid=

Oracle.install.db.config.starterdb.automatedBackup.ospwd=

Oracle.install.db.config.starterdb.storageType=

Oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=

Oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=

Oracle.install.db.config.asm.diskGroup=

Oracle.install.db.config.asm.ASMSNMPPassword=

MYORACLESUPPORT_USERNAME=

MYORACLESUPPORT_PASSWORD=

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

DECLINE_SECURITY_UPDATES=true

PROXY_HOST=

PROXY_PORT=

Db_name='ciptest6'

Memory_target=3500M

Processes = 3000

Audit_file_dest='/u01/app/oracle/admin/ciptest6/adump'

Audit_trail = 'db'

Db_block_size=8192

Db_domain=''

Db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'

Db_recovery_file_dest_size=5G

Diagnostic_dest='/u01/app/oracle'

Dispatchers=' (PROTOCOL=TCP) (SERVICE=CIPTEST6XDB)'

Open_cursors=3000

Remote_login_passwordfile='EXCLUSIVE'

Undo_tablespace='UNDOTBS1'

# You may want to ensure that control files are created on separate physical

# devices

Control_files = (ora_control1,ora_control2, ora_control3)

Compatible = '11.2.0'

Then you can start the oracle instance, log in with sqlplus "/ as sysdba", and then startup nomount

If the MEMORY_TARGET is too large, you can change it a little smaller in the parameter file (here you set it to 81960M, 80g), or change the size of the shm,

The size of / dev/shm can be seen with df-h

Use mount-o size=102400M-o nrinodes=1000000-o noatime,nodiratime-o remount / dev/shm to modify the size of shm

Then create a spfile

Create spfile from pfile

CREATE DATABASE ciptest6

USER SYS IDENTIFIED BY sys

USER SYSTEM IDENTIFIED BY system

Logfile

Group 1 ('/ u01max size size 256m)

Group 2 ('/ u01amp size size 256m)

Group 3 ('/ u01amp size size 256m)

Group 4 ('/ u01amp size size 256m)

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXLOGHISTORY 200

MAXDATAFILES 10000

MAXINSTANCES 1

CHARACTER SET ZHS16GBK

NATIONAL CHARACTER SET AL16UTF16

Datafile'/ u01 size size 01.dbf' oradata REUSE

EXTENT MANAGEMENT LOCAL

Sysaux datafile'/ u01 size REUSE

Default temporary tablespace temp

Tempfile'/ u01 size REUSE

Undo tablespace UNDOTBS1

Datafile'/ u01 size REUSE undotbs01.dbf' oradata

AUTOEXTEND off

Default tablespace DATA

Datafile'/ u01 size REUSE

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO

If there is no problem, then create the data dictionary and the pl/sql package

(you can cd to the corresponding directory on the operating system)

Cd / u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin

Sqlplus "/ as sysdba"

@ catalog.sql

@ catproc.sql

@ utlrp.sql

Exit

(you can cd to the corresponding directory on the operating system)

Cd / u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin

Sqlplus "/ as sysdba"

Alter user system identified by manager

Conn system/manager

@ pupbld.sql

(these scripts are placed under $ORACLE_HOME/rdbms/admin, or you can advance to this directory, and then directly @ script.)

Finally, shutdown immediate and then startup.

Alter database datafile'/ u01 autoextend on next maxsize maxsize 32767m

Alter database datafile'/ u01 autoextend on next maxsize maxsize 32767m

Alter database datafile'/ u01 autoextend on next maxsize maxsize 32767m

Alter database datafile'/ u01 autoextend on next maxsize maxsize 32767m

(4) before silent configuration monitoring, you should pay attention to:

Hostname

/ etc/hosts

/ etc/sysconfig/network

The host of several files should be configured.

Su-oracle

Cd / u01/app/oracle/product/11.2.0/dbhome_1/bin

Netca / silent / responsefile / u01/database/response/netca.rsp

Feedback on successful configuration information is as follows:

Parsing command line arguments:

Parameter "silent" = true

Parameter "responsefile" = / opt/database/response/netca.rsp

Complete the syntax analysis of the command line parameters.

Oracle Net Services configuration:

Complete the profile configuration.

The Oracle Net listener starts:

Running listener controls:

/ u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start LISTENER

Listener control complete.

The listener started successfully.

The listener configuration is complete.

Oracle Net Services configuration completed successfully. The exit code is 0

Note: the server's firewall should be turned off before the client connects to the database

Setenforce 0

Service iptables stop

This is the end of the article on "how to install single instance of character interface in ORACLE-LINUX environment". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.