Oracle多个监听多个实例.docx
- 文档编号:10045140
- 上传时间:2023-05-23
- 格式:DOCX
- 页数:17
- 大小:1.07MB
Oracle多个监听多个实例.docx
《Oracle多个监听多个实例.docx》由会员分享,可在线阅读,更多相关《Oracle多个监听多个实例.docx(17页珍藏版)》请在冰点文库上搜索。
Oracle多个监听多个实例
Oracle多个监听对应多个实例
EditByshuyun
前面我贴了一个监听对应多个数据库的文档,现在再来看看多个监听对应多个数据库的情况。
同样,我们安装好数据库软件后,我们就可以建库、建监听了。
1.用oracle用户运行netmgr命令进入配置界面
2.建俩服务名,如图:
俩个服务名,一个dccb,另一个dccb1,IP地址相同,端口不同,一个是1521,另一个是1621。
3.再建俩监听,如图:
Listener的数据库服务选择dccb
再建一个listener1
Listener1的数据库服务是dccb1
OK,到此监听和TNSNAME设置完成。
4.下面来建库了,用dbca命令,如图:
5.建实例dccb
选第一项,
输入dccb
设置sys及system用户的密码。
下面来选择该实例注册到哪个监听,dccb选择listner,等会儿再建一个dccb1注册到listner1。
选择字符集(要注意,字符集要选对),
此处点击finish创建数据库,
6.按照创建dccb的方法再建一个dccb1。
7.如何连接数据库?
8.启动监听
[oracle@dbhost~]$lsnrctlstart
LSNRCTLforLinux:
Version11.2.0.1.0-Productionon11-NOV-201523:
10:
58
Copyright(c)1991,2009,Oracle.Allrightsreserved.
Starting/u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr:
pleasewait...
TNSLSNRforLinux:
Version11.2.0.1.0-Production
Systemparameterfileis/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Logmessageswrittento/u01/app/oracle/diag/tnslsnr/dbhost/listener/alert/log.xml
Listeningon:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=173.0.2.113)(PORT=1521)))
Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=173.0.2.113)(PORT=1521)))
STATUSoftheLISTENER
------------------------
AliasLISTENER
VersionTNSLSNRforLinux:
Version11.2.0.1.0-Production
StartDate11-NOV-201523:
10:
59
Uptime0days0hr.0min.0sec
TraceLeveloff
SecurityON:
LocalOSAuthentication
SNMPOFF
ListenerParameterFile/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
ListenerLogFile/u01/app/oracle/diag/tnslsnr/dbhost/listener/alert/log.xml
ListeningEndpointsSummary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=173.0.2.113)(PORT=1521)))
ServicesSummary...
Service"dccb"has1instance(s).
Instance"dccb",statusUNKNOWN,has1handler(s)forthisservice...
Thecommandcompletedsuccessfully
9.打开dccb并连接
[oracle@dbhost~]$sqlplus/nolog
SQL*Plus:
Release11.2.0.1.0ProductiononWedNov1123:
12:
032015
Copyright(c)1982,2009,Oracle.Allrightsreserved.
SQL>connsys/system@dccbassysdba
Connectedtoanidleinstance.
SQL>startup
ORACLEinstancestarted.
TotalSystemGlobalArea1603411968bytes
FixedSize2213776bytes
VariableSize989857904bytes
DatabaseBuffers603979776bytes
RedoBuffers7360512bytes
Databasemounted.
Databaseopened.
SQL>connsys/system@dccbassysdba
Connected.
SQL>
连接成功
10.再试试,dccb1.
SQL>connsys/system@dccb1assysdba
ERROR:
ORA-12541:
TNS:
nolistener
发现以上报错信息!
!
!
!
11.启动listner1
[oracle@dbhost~]$lsnrctl
LSNRCTLforLinux:
Version11.2.0.1.0-Productionon11-NOV-201523:
15:
00
Copyright(c)1991,2009,Oracle.Allrightsreserved.
WelcometoLSNRCTL,type"help"forinformation.
LSNRCTL>startlistener1
Starting/u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr:
pleasewait...
TNSLSNRforLinux:
Version11.2.0.1.0-Production
Systemparameterfileis/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Logmessageswrittento/u01/app/oracle/diag/tnslsnr/dbhost/listener1/alert/log.xml
Listeningon:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=173.0.2.113)(PORT=1621)))
Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=173.0.2.113)(PORT=1621)))
STATUSoftheLISTENER
------------------------
Aliaslistener1
VersionTNSLSNRforLinux:
Version11.2.0.1.0-Production
StartDate11-NOV-201523:
15:
06
Uptime0days0hr.0min.0sec
TraceLeveloff
SecurityON:
LocalOSAuthentication
SNMPOFF
ListenerParameterFile/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
ListenerLogFile/u01/app/oracle/diag/tnslsnr/dbhost/listener1/alert/log.xml
ListeningEndpointsSummary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=173.0.2.113)(PORT=1621)))
ServicesSummary...
Service"dccb1"has1instance(s).
Instance"dccb1",statusUNKNOWN,has1handler(s)forthisservice...
Thecommandcompletedsuccessfully
12.连接dccb1
SQL>connsys/system@dccb1assysdba
Connectedtoanidleinstance.
SQL>startup
ORACLEinstancestarted.
TotalSystemGlobalArea1202556928bytes
FixedSize2212816bytes
VariableSize369101872bytes
DatabaseBuffers822083584bytes
RedoBuffers9158656bytes
Databasemounted.
Databaseopened.
SQL>connsys/system@dccb1assysdba
Connected.
OK连接上了。
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle 监听 实例