Linux RHEL6 x64 命令行静默安装 Oracle 12c - 2
生活随笔
收集整理的這篇文章主要介紹了
Linux RHEL6 x64 命令行静默安装 Oracle 12c - 2
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
軟件安裝完,還要配置監聽,初始化數據庫。
這點和PostgreSQL類似。配置環境變量
vi ~/env_ora.sh
export ORACLE_BASE=/home/digoal/oracle/product
export ORACLE_HOME=$ORACLE_BASE/12.1.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_SID=orcl12c
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
export THREADS_FLAG=native安裝監聽服務
Net Configuration Assistant$cp database/response/netca.rsp ~/$grep -E "^[a-Z]|\[" netca.rsp
[GENERAL]
RESPONSEFILE_VERSION="12.1"
CREATE_TYPE="CUSTOM"
[oracle.net.ca]
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""typical""
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START=""LISTENER""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_SERVICE={"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}$ . ~/env_ora.sh$netca -silent -responsefile /home/digoal/netca.rsp Parsing command line arguments:Parameter "silent" = trueParameter "responsefile" = /home/digoal/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:Running Listener Control: /home/digoal/oracle/product/12.1.0/db_1/bin/lsnrctl start LISTENERListener Control complete.Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0查看監聽是否正常
$lsnrctl statusLSNRCTL for Linux: Version 12.1.0.2.0 - Production on 23-DEC-2015 14:09:28Copyright (c) 1991, 2014, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=digoal_host.sqa.zmf)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 23-DEC-2015 13:41:43
Uptime 0 days 0 hr. 27 min. 45 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/digoal/oracle/product/12.1.0/db_1/network/admin/listener.ora
Listener Log File /home/digoal/oracle/product/diag/tnslsnr/digoal_host/listener/alert/log.xml
Listening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=digoal_host.sqa.zmf)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "orcl12c" has 1 instance(s).Instance "orcl12c", status READY, has 1 handler(s) for this service...
Service "orcl12cXDB" has 1 instance(s).Instance "orcl12c", status READY, has 1 handler(s) for this service...
The command completed successfully
配置文件如下
$cat /home/digoal/oracle/product/12.1.0/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /home/digoal/oracle/product/12.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = digoal_host.sqa.zmf)(PORT = 1521))(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))))初始化數據庫
Database Configuration Assistant$ . ~/env_ora.sh$cp database/response/dbca.rsp ~/$ vi dbca.rsp$grep -E "^[a-Z]|\[" dbca.rsp
[GENERAL]
RESPONSEFILE_VERSION = "12.1.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "orcl12c"
DATABASECONFTYPE = "SI"
SID = "orcl12c"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "digoal"
SYSTEMPASSWORD = "digoal"
DATAFILEDESTINATION = /disk1/digoal/oradata
RECOVERYAREADESTINATION= /disk1/digoal/flash_recovery_area
STORAGETYPE=FS
CHARACTERSET = "UTF8"
NATIONALCHARACTERSET= "UTF8"
LISTENERS = "listener1,listener2"
MEMORYPERCENTAGE = "40"
DATABASETYPE = "MULTIPURPOSE"
AUTOMATICMEMORYMANAGEMENT = "TRUE"
TOTALMEMORY = "80000"
# 內存要足夠大
[createTemplateFromDB]
SOURCEDB = "myhost:1521:orcl"
SYSDBAUSERNAME = "system"
SYSDBAPASSWORD = "digoal"
TEMPLATENAME = "My Copy TEMPLATE"
[createCloneTemplate]
SOURCEDB = "orcl"
TEMPLATENAME = "My Clone TEMPLATE"
[DELETEDATABASE]
SOURCEDB = "orcl"
[generateScripts]
TEMPLATENAME = "New Database"
GDBNAME = "orcl12.us.oracle.com"
[CONFIGUREDATABASE]
[ADDINSTANCE]
DB_UNIQUE_NAME = "orcl12c.us.oracle.com"
NODENAME=
SYSDBAUSERNAME = "sys"
[DELETEINSTANCE]
DB_UNIQUE_NAME = "orcl12c.us.oracle.com"
INSTANCENAME = "orcl12c"
SYSDBAUSERNAME = "sys"$dbca -silent -responseFile /home/digoal/dbca.rsp
Cleaning up failed steps
5% complete
Copying database files
7% complete
9% complete
16% complete
23% complete
30% complete
41% complete
Creating and starting Oracle instance
43% complete
48% complete
53% complete
57% complete
58% complete
59% complete
62% complete
64% complete
Completing Database Creation
68% complete
71% complete
75% complete
85% complete
96% complete
100% complete
Look at the log file "/home/digoal/oracle/product/cfgtoollogs/dbca/orcl12c/orcl12c0.log" for further details.測試數據庫
sqlplus "/ as sysdba"
SQL> select * from dual;D
-
X
總結
以上是生活随笔為你收集整理的Linux RHEL6 x64 命令行静默安装 Oracle 12c - 2的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 利用logminer恢复delete误删
- 下一篇: Linux性能调优、Linux集群与存储