首页 > itarticle > oracle数据库安装配置安装目录配置静默安装文件设置环境变量静默方式安装oracle 静默方式初始化数据库启动oracle监听进程启动数据库

oracle数据库安装配置安装目录配置静默安装文件设置环境变量静默方式安装oracle 静默方式初始化数据库启动oracle监听进程启动数据库

admin 1月 28, 2021 0

groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper
groupadd -g 601 asmadmin
groupadd -g 602 asmdba
groupadd -g 603 asmoper
useradd -u 1101 -g oinstall -G dba,oper  oracle

配置安装目录

1
2
3

mkdir -p /opt/oracle
chown -R oracle:oinstall /opt/oracle
chmod -R 775 /opt/oracle

配置静默安装文件

vi database/response/db_install.rsp

oracle.install.option=INSTALL_DB_AND_CONFIG
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/opt/oracle/oraInventory
ORACLE_HOME=/opt/oracle/oracle
ORACLE_BASE=/opt/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_GROUP=oper
oracle.install.db.OSBACKUPDBA_GROUP=dba
oracle.install.db.OSDGDBA_GROUP=dba
oracle.install.db.OSKMDBA_GROUP=dba
oracle.install.db.OSRACDBA_GROUP=dba
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=testdb
oracle.install.db.config.starterdb.SID=testdb
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryLimit=512
oracle.install.db.config.starterdb.password.ALL=Oracle123456
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/u01/app/oracle/oradata
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/u01/app/oracle/oradata_archive
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true

设置环境变量

export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/oracle
export ORACLE_UNQNAME=orc1
export ORACLE_SID=orcl

export SQLPATH=$ORACLE_HOME/sqlplus/admin:/home/oracle/admin/sql
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data

export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export [email protected]hostname:'$PWD>'

静默方式安装oracle

./runInstaller -force -silent -noconfig -responseFile /work/database/response/db_install.rsp

静默方式初始化数据库

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname testdb -sid testdb -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 30 -emConfiguration LOCAL

vi oracle/network/admin/listener.ora

SID_LIST_LISTENER =
(SID_LIST =
  (SID_DESC =
  ( SID_NAME = testdb )
  ( GLOBAL_DBNAME = testdb )
  ( ORACLE_HOME = /opt/oracle/oracle )
  )
)

LISTENER =
(DESCRIPTION_LIST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
  )
)

vi oracle/dbs/initorcl.ora

db_name='testdb'
memory_target=1G
processes = 150
audit_file_dest='/opt/oracle/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/opt/oracle/fast_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'

启动oracle监听进程

lsnrctl start
lsnrctl status

启动数据库

sqlplus / as sysdba

SQL> startup
ORACLE instance started.

Total System Global Area 1207959552 bytes
Fixed Size         8620080 bytes
Variable Size         838862800 bytes
Database Buffers      352321536 bytes
Redo Buffers            8155136 bytes
Database mounted.
Database opened.

SQL> show parameter service_names

NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
service_names                 string  testdb
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/opt/oracle/oradata/testdb/system01.dbf
/opt/oracle/oradata/testdb/sysaux01.dbf
/opt/oracle/oradata/testdb/undotbs01.dbf
/opt/oracle/oradata/testdb/users01.dbf