- 浏览: 5098736 次
- 性别:
- 来自: 北京
文章分类
最新评论
-
silence19841230:
先拿走看看
SpringBoot2.0开发WebSocket应用完整示例 -
wallimn:
masuweng 写道发下源码下载地址吧!三个相关文件打了个包 ...
SpringBoot2.0开发WebSocket应用完整示例 -
masuweng:
发下源码下载地址吧!
SpringBoot2.0开发WebSocket应用完整示例 -
masuweng:
SpringBoot2.0开发WebSocket应用完整示例 -
wallimn:
水淼火 写道你好,我使用以后,图标不显示,应该怎么引用呢,谢谢 ...
前端框架iviewui使用示例之菜单+多Tab页布局
默认情况下,监控器是不接受从别的节点联入ASM实例的。
因此为ASM创建的服务,状态是"BLOCKED",表示此实例不能接受连接。
Ora10gASM-> lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-JUN-2008 07:39:03
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Ora10gASM)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 08-JUN-2008 07:14:45
Uptime 0 days 0 hr. 24 min. 18 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Ora10gASM)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Ora10gASM)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...Service "+ASM" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "benbo" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
Service "benboXDB" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
Service "benbo_XPT" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
The command completed successfully
BLOCKED:表示此实例不能接受连接
UNKNOWN:表示此实例在listener.ora文件中注册而不是通过动态服务注册,因而不知道其状态
READY:表示此实例可接受连接
可以通过修改listener.ora文件,通过静态注册ASM实例,可使得从别的主机上可进行客户端登陆。
Ora10gASM-> vi /oracle/product/10.2.0/db_1/network/admin/listener.ora
(PROGRAM = extproc)
# listener.ora Network Configuration File: /oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
) (SID_DESC =
(SID_NAME = +ASM)
(ORACLE_HOME = /oracle/product/10.2.0/db_1)
) )
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Ora10gASM)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
"product/10.2.0/db_1/network/admin/listener.ora" 24L, 583C written
重新载入监听信息
Ora10gASM-> lsnrctl reload
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-JUN-2008 07:40:40
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Ora10gASM)(PORT=1521)))
The command completed successfully
Ora10gASM-> lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-JUN-2008 07:40:51
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Ora10gASM)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 08-JUN-2008 07:14:45
Uptime 0 days 0 hr. 26 min. 6 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Ora10gASM)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Ora10gASM)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "+ASM" has 2 instance(s).
Instance "+ASM", status UNKNOWN, has 1 handler(s) for this service...
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "benbo" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
Service "benboXDB" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
Service "benbo_XPT" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
The command completed successfully
配置好客户端tnsnames.ora,加入到ASM的连接标识符。
asm =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.111)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM)
)
)
C:>sqlplus sys/oracle@asm as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on 星期日 6月 8 10:38:14 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
转自:http://benbo.itpub.net/post/26034/463936
因此为ASM创建的服务,状态是"BLOCKED",表示此实例不能接受连接。
Ora10gASM-> lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-JUN-2008 07:39:03
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Ora10gASM)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 08-JUN-2008 07:14:45
Uptime 0 days 0 hr. 24 min. 18 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Ora10gASM)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Ora10gASM)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...Service "+ASM" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "benbo" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
Service "benboXDB" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
Service "benbo_XPT" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
The command completed successfully
BLOCKED:表示此实例不能接受连接
UNKNOWN:表示此实例在listener.ora文件中注册而不是通过动态服务注册,因而不知道其状态
READY:表示此实例可接受连接
可以通过修改listener.ora文件,通过静态注册ASM实例,可使得从别的主机上可进行客户端登陆。
Ora10gASM-> vi /oracle/product/10.2.0/db_1/network/admin/listener.ora
(PROGRAM = extproc)
# listener.ora Network Configuration File: /oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
) (SID_DESC =
(SID_NAME = +ASM)
(ORACLE_HOME = /oracle/product/10.2.0/db_1)
) )
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Ora10gASM)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
"product/10.2.0/db_1/network/admin/listener.ora" 24L, 583C written
重新载入监听信息
Ora10gASM-> lsnrctl reload
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-JUN-2008 07:40:40
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Ora10gASM)(PORT=1521)))
The command completed successfully
Ora10gASM-> lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-JUN-2008 07:40:51
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Ora10gASM)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 08-JUN-2008 07:14:45
Uptime 0 days 0 hr. 26 min. 6 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Ora10gASM)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Ora10gASM)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "+ASM" has 2 instance(s).
Instance "+ASM", status UNKNOWN, has 1 handler(s) for this service...
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "benbo" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
Service "benboXDB" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
Service "benbo_XPT" has 1 instance(s).
Instance "benbo", status READY, has 1 handler(s) for this service...
The command completed successfully
配置好客户端tnsnames.ora,加入到ASM的连接标识符。
asm =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.111)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM)
)
)
C:>sqlplus sys/oracle@asm as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on 星期日 6月 8 10:38:14 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
转自:http://benbo.itpub.net/post/26034/463936
发表评论
-
Oracle数据库相关系统突然提示“SQLException:违反协议”
2024-02-19 15:50 330SQLException:违反协议这个异常可能由很多的 ... -
CentOS在Docker中安装Oracle
2024-02-06 12:13 4471.拉取Oracle镜像,并检 ... -
Windows Server安装oracle数据库一直停在82%
2023-02-04 12:01 404网上有个说法:服务器超过一定数量的CPU后,将不能正常安装 ... -
ORA-04030错误处理
2023-02-04 11:52 2174【错误描述】 错误信息如下: ORA-04030:在尝 ... -
ORA-04030错误处理
2023-02-04 11:45 403【错误描述】 错误信息如下: ORA-04030:在尝 ... -
Linux安装MySQL数据库
2019-06-10 22:27 16101.进入安装包所在目录,解压: tar zxvf mysql- ... -
确定MySQL在Linux系统中配置文件的位置
2019-04-14 19:30 26171.通过which mysql命令来查看mysql的安装位置。 ... -
mysql set names 命令和 mysql 字符编码问题
2019-04-12 00:34 1004转自:https://www.cnblogs.com/digd ... -
MYSQL中取当前周/月/季/年的第一天与最后一天
2018-11-17 23:16 2085转自:https://blog.csdn.net/ ... -
Oracle删除大量数据的实践
2016-11-07 18:03 5667一、引言 从来没有 ... -
Oracle 数据库简明教程 V0.1
2016-03-23 21:01 1907供初学者入门学习使用,以开发者常见、常用的知识为主,基本上 ... -
Oracle拆分字符串函数
2016-03-23 10:58 3227create or replace type string ... -
Oracle数据库远程连接无响应
2016-03-21 10:20 4142故障现象: 服务器本机使用sqlplus / as s ... -
Oracle PGA详解
2015-10-21 15:34 11263转自:http://yanguz123.iteye.com/b ... -
Oracle12C导入dmp数据
2015-10-08 23:43 20411Oracle12C,发生了较大的变化。以前熟悉的东西变得陌 ... -
SQLLDR数据导入小结
2015-07-25 22:06 73851.创建数据表 CREATE TABLE ... -
Window7安装Oracle10
2015-03-06 12:14 1503每次安装都要百度,转到自己的博客上,找起来方便,还能增加访 ... -
Oracle SQL Developer 连接 Mysql 数据库
2015-02-25 19:36 3554下载JDBC包,解压缩这里只要mysql-connector- ... -
Mysql数据备份与恢复
2015-02-25 19:15 1248备份/恢复策略 1. 要定期做 mysql备份,并考虑系统可以 ... -
Oracle中merge into的使用
2015-01-23 22:57 3912引自:http://www.cnblogs.com/highr ...
相关推荐
这是接口课程设计的接口报警亮灯程序asm+c语言,请大家享用~~
流水灯 流水灯 单片机程序 asm编写at89s52
汇编写的生日快乐歌,输出端口为p0.7,文件格式为asm
英文打字 ASM 源程序 英文打字 ASM 源程序
ASM330陀螺仪例程 (嵌入式开发 程序 )
asm-1.3.3.jar, asm-1.3.4.jar, asm-1.3.5.jar, asm-1.4.1.jar, asm-1.4.2.jar, asm-1.4.3.jar, asm-1.4.jar, asm-1.5.1.jar, asm-1.5.2.jar, asm-1.5.3.jar, asm-2.0.jar, asm-2.1.jar, asm-2.2.1-sources.jar, asm...
3.6 检查asm disk的状态以及diskgroup的使用率 14 3.7 把asm diskgroup加入到初始化文件中 14 第四篇 创建使用ASM存储管理的数据库 16 4.1 在存储机制选择中选择ASM 16 4.2 ASM磁盘组信息 17 4.3 指定数据库区 18 ...
c32asm_反汇编程序,供学习用,感谢吾爱破解,提供谢谢
汇编工具ASM汇编工具ASM汇编工具ASM汇编工具ASM汇编工具ASM
c32asm 代码编辑程序更改标题图标c32asm 代码编辑程序更改标题图标c32asm 代码编辑程序更改标题图标c32asm 代码编辑程序更改标题图标c32asm 代码编辑程序更改标题图标c32asm 代码编辑程序更改标题图标c32asm 代码...
ASM51程序设计 汇编语言程序设计 51单片机
循环排序汇编排序程序循汇编排序程序循环asm文件环asm文件
NULL 博文链接:https://xkorey.iteye.com/blog/1667944
单片机矩形按键汇编程序
本程序是一个ASM+haar人脸检测,手动标注的MFC程序,可以自动标注人脸的眼睛,鼻子,嘴巴位置信息,并保存为txt文件,使用详情请看readme
KEIL环境下ASM演示程序 KEIL环境下ASM演示程序 KEIL环境下ASM演示程序
很好的资源,ASM汇编语言程序设计自学教程
包含如下oracleasm包: kmod-oracleasm-2.0.6.rh1-3.el6.x86_64.rpm oracleasm-2.0.8-4.el6_6.src.rpm oracleasm-2.0.8-6.el6_7.src.rpm oracleasm-2.0.8-8.el7.src.rpm oracleasm-2.0.8-15.el7.centos.src.rpm ...
EditPlus是很好用的编辑软件 但网上下的很多EP版本需要自己添加asm.acp,asm.stx,不是很方便 这个里面附带了asm.acp,asm.stx
最终程序.asm