修改dbca.rsp文件:
###因内容过多,无法显示,详见附件###
执行命令创建数据库实例
$ dbca -silent-responseFile /u01/database/response/dbca.rsp
Copying database files
...
37% complete
Creating and starting Oracle instance
...
62% complete
Completing Database Creation
...
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCL/ORCL.log"for further details.
这一过程需要十分钟左右,一般会有进度条指示
修改netca.rsp文件,或直接执行创建监听
$ netca -silent-responsefile /u01/database/response/netca.rsp
Parsing command line arguments:
Parameter"silent" = true
Parameter"responsefile" = /u01/database/response/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
RunningListener Control:
/u01/app/oracle/product/11.2.0/db_1/bin/lsnrctl start LISTENER
ListenerControl complete.
Listenerstarted successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exitcode is 0
查看数据库网络监听状态
$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 05-SEP-201415:47:12
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version11.2.0.3.0 - Production
Start Date 05-SEP-2014 15:45:47
Uptime 0 days 0 hr. 1 min. 25 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/oracle/diag/tnslsnr/DS-153/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.52)(PORT=1521)))
The listener supports no services
The command completed successfully
登录数据库进行测试
$ sqlplus / as sysdba
SQL> SELECT SYSDATE FROM DUAL;
免责声明:
① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。
② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
软考中级精品资料免费领
- 历年真题答案解析
- 备考技巧名师总结
- 高频考点精准押题
- 资料下载
- 历年真题
193.9 KB下载数265
191.63 KB下载数245
143.91 KB下载数1148
183.71 KB下载数642
644.84 KB下载数2756