升级oracle RAC后出现ORA-12520错误
来源:互联网 发布:淘宝日刷2000单黑技术 编辑:程序博客网 时间:2024/05/23 13:34
2011-06-04
【转】 升级oracle RAC后出现ORA-12520错误
OracleSQLSQL ServerHTML
现象:
oracle10gR2.0.0.1升级后,现在客户端连接时报ORA-12520错误
12520, 00000, "TNS:listener could not find available handler for requested type of server"
// *Cause: None of the known and available service handlers for requested type
// of server (dedicated or shared) are appropriate for the client connection.
// *Action: Run "lsnrctl services" to ensure that the instance(s) have
// registered with the listener and that the appropriate handlers are
// accepting connections.
解决:
在网上找了资料后修改了下面的参数后正常:
SQL> alter system set local_listener = '(ADDRESS=(PROTOCOL=TCP)(HOST=172.0.2.62)(PORT=1521))'
2 scope = spfile sid = 'rac11g1';
系统已更改。
SQL> alter system set local_listener = '(ADDRESS=(PROTOCOL=TCP)(HOST=172.0.2.63)(PORT=1521))'
2 scope = spfile sid = 'rac11g2';
系统已更改。
SQL> shutdown immediate数据库已经关闭。已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 1.7108E+10 bytes
Fixed Size 2101632 bytes
Variable Size 3814182528 bytes
Database Buffers 1.3288E+10 bytes
Redo Buffers 4431872 bytes数据库装载完毕。数据库已经打开。
另外的节点也重启数据库服务器。
SQL> conn system/test@rac已连接。
问题解决。
参考:http://www.svn8.com/sql/Oracle/2009110712446_3.html
另外:在打数据库补丁后,在启动数据库时遇到了下面的错误:
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_GE02'
解决方法如下:
1、关闭数据库;
SQL> shutdown abort
ORACLE instance shut down.
2、然后在修改/opt/oracle/product/10.2.0/network/admin/tnsnames.ora文件,添加下面的语句:
LISTENER_GE02 =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
3、然后重新启动数据库
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 92276304 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
oracle10gR2.0.0.1升级后,现在客户端连接时报ORA-12520错误
12520, 00000, "TNS:listener could not find available handler for requested type of server"
// *Cause: None of the known and available service handlers for requested type
// of server (dedicated or shared) are appropriate for the client connection.
// *Action: Run "lsnrctl services" to ensure that the instance(s) have
// registered with the listener and that the appropriate handlers are
// accepting connections.
解决:
在网上找了资料后修改了下面的参数后正常:
SQL> alter system set local_listener = '(ADDRESS=(PROTOCOL=TCP)(HOST=172.0.2.62)(PORT=1521))'
2 scope = spfile sid = 'rac11g1';
系统已更改。
SQL> alter system set local_listener = '(ADDRESS=(PROTOCOL=TCP)(HOST=172.0.2.63)(PORT=1521))'
2 scope = spfile sid = 'rac11g2';
系统已更改。
SQL> shutdown immediate数据库已经关闭。已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 1.7108E+10 bytes
Fixed Size 2101632 bytes
Variable Size 3814182528 bytes
Database Buffers 1.3288E+10 bytes
Redo Buffers 4431872 bytes数据库装载完毕。数据库已经打开。
另外的节点也重启数据库服务器。
SQL> conn system/test@rac已连接。
问题解决。
参考:http://www.svn8.com/sql/Oracle/2009110712446_3.html
另外:在打数据库补丁后,在启动数据库时遇到了下面的错误:
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_GE02'
解决方法如下:
1、关闭数据库;
SQL> shutdown abort
ORACLE instance shut down.
2、然后在修改/opt/oracle/product/10.2.0/network/admin/tnsnames.ora文件,添加下面的语句:
LISTENER_GE02 =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
3、然后重新启动数据库
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 92276304 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
- 升级oracle RAC后出现ORA-12520错误
- Oracle 11g RAC 补丁升级时报ORA-01565: error in identifying spfileprod.ora 错误处理
- RAC建立DATA GUARD环境后出现的ORA-01105和ORA-01677错误
- oracle升级后exp出现oracle 942错误
- 安装Oracle后数据库不能启动,出现ORA-27125错误
- Oracle数据库升级后报ORA-00704和ORA-39700错误
- oracle RAC ORA-03113 错误解决
- oracle从10.2.0.1升级到10.2.0.5出现ORA-01092,并且OEM出现ora-01035错误,提示状态失败
- linux(suse)oracle服务器,改变网络后,不能通过监听启动,ora-12514错误,修改listener.ora后,出现ora-01034 ora-27101
- oracle 12c rac关闭pdb出现ORA-01155异常
- Oracle安装后命令行中运行sqlplus / as sysdba出现错误ora-01031:insufficient privileges
- oracle 10G r2 RAC连接ORA-12545错误
- Oracle 11.2.0.3 RAC环境 ORA-29280 错误解决办法
- Oracle RAC 登录archive error ora-00257错误处理方法
- oracle 12c rac ora-12545错误解决
- oracle 8.1.7 升级到 8.1.7.4.1后出现exp导出错误的问题
- Oracle RAC升级第四步,清理错误节点名
- nhibernate 连接 oracle 出现 ORA-01461 错误
- hibernate hql 详解
- 打败system,自己监听Home键
- ASP.NET 按钮添加确认框
- java 学习感受(转载)
- 使用Intel编译器(0)基础(1)内联
- 升级oracle RAC后出现ORA-12520错误
- C/C++定义全局变量/常量几种方法的区别
- Android调用天气预报的WebService简单例子
- python操作excel之xlrd
- shape 渐变!描边!圆角!漂亮的自定义背景
- Netfilter分析 (Linux内核版本:2.4.21)
- Android 解屏幕锁与点亮屏幕
- Function Reference/the post thumbnail
- 基于PNP自动映射分区的安全USB技术研究与实现