内容发布更新时间 : 2025/1/11 13:04:57星期一 下面是文章的全部内容请认真阅读。
yum -y install binutilscompat-libstdc++-33 compat-libstdc++-33.i686 elfutils-libelfelfutils-libelf-develgccgcc-c++ glibc glibc.i686 glibc-common glibc-devel glibc-devel.i686 glibc-headers kshlibaio
libaio.i686 libaio-devel libaio-devel.i686 libgcc libgcc.i686 libstdc++ libstdc++.i686 libstdc++-devel make sysstatunixODBCunixODBC-devel 如果没有直接在google搜索，下载对应版本就可以了 最后别忘了：
$ORACLE_HOME/bin/relink all 然后重新执行网络配置
[oracle@DB_2 database]$ $ORACLE_HOME/bin/netca /silent /responseFile /opt/database/response/netca.rsp Parsing command line arguments: Parameter \
Parameter\Done parsing command line arguments. Oracle Net Services Configuration: Profile configuration complete. Oracle Net Listener Startup: Running Listener Control:
/opt/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctlstart LISTENER
Listener Control complete. Listener started successfully. Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
启动监听程序:
$ /opt/app/oracle/product/11.2.0/db_1/bin/lsnrctlstart LISTENER 或$ORACLE_BASE//opt/app/oracle/product/11.2.0/db_1/bin/lsnrctlstart LISTENER
[oracle@DB_m2database]$ /opt/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start LISTENER
LSNRCTLfor Linux: Version 11.2.0.1.0 - Production on 06-MAR-2016 15:18:49
Copyright(c) 1991, 2009, Oracle. All rightsreserved.
Starting/opt/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNRfor Linux: Version 11.2.0.1.0 - Production
Systemparameter file is
/opt/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Logmessages written to
/opt/app/oracle/diag/tnslsnr/DB_2/listener/alert/log.xml
Listeningon: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Listeningon:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DB_2)(PORT=1521)))
Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS ofthe LISTENER ------------------------
Alias LISTENER Version TNSLSNR for Linux: Version11.2.0.1.0 - Production
StartDate 06-MAR-2016 15:18:51
Uptime 0 days 0 hr. 0 min. 0 sec TraceLevel off
Security ON: Local OS Authentication SNMP OFF
ListenerParameter
File /opt/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
ListenerLog
File /opt/app/oracle/diag/tnslsnr/DB_2/listener/alert/log.xml
ListeningEndpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DB_m2)(PORT=1521))) Thelistener supports no services Thecommand completed successfully 启动成功
静默dbca建库:
[oracle@DB_m2~]# vi /opt/database/response/dbca.rsp
GDBNAME = \ //78行全局数据库的名字=SID+主机域名 SID = \ //149行 SID
CHARACTERSET = \ //415行编码 NATIONALCHARACTERSET= \ //425行编码 SYSPASSWORD=\ //190行密码可自己设置
SYSTEMPASSWORE=\ //200行密码可自己设置
[oracle@DB_m2 database]$ $ORACLE_HOME/bin/dbca -silent -responseFile /opt/database/response/dbca.rsp EnterSYSTEM user password:
Copyingdatabase files 1%complete 3%complete 11%complete 18%complete 26%complete 37%complete
Creatingand starting Oracle instance 40%complete 45%complete 50%complete 55%complete 56%complete 60%complete 62%complete
CompletingDatabase Creation 66%complete 70%complete 73%complete 85%complete 96%complete 100%complete
Look atthe log file
\details. 建库后实例检查：
ps -ef | grepora_ | grep -v grep| wc -l 21
[oracle@DB_m2 database]$ ps -ef | grepora_ |grep -v grep oracle 15924 1 0 15:50 ? 00:00:00 ora_pmon_ora11g
oracle 15926 1 0 15:50 ? 00:00:01 ora_vktm_ora11g
oracle 15930 1 0 15:50 ? 00:00:00 ora_gen0_ora11g
oracle 15932 1 0 15:50 ? 00:00:00 ora_diag_ora11g
oracle 15934 1 0 15:50 ? 00:00:00 ora_dbrm_ora11g
oracle 15936 1 0 15:50 ? 00:00:00 ora_psp0_ora11g
oracle 15938 1 0 15:50 ? 00:00:00 ora_dia0_ora11g
oracle 15940 1 0 15:50 ? 00:00:00 ora_mman_ora11g
oracle 15942 1 0 15:50 ? 00:00:00 ora_dbw0_ora11g
oracle 15944 1 0 15:50 ? 00:00:00 ora_lgwr_ora11g
oracle 15946 1 0 15:50 ? 00:00:00 ora_ckpt_ora11g
oracle 15948 1 0 15:50 ? 00:00:00 ora_smon_ora11g