RAC RMAN 通道配置 RMAN-12001 RMAN-12001 RMAN-10008 RMAN-10003 ORA-01017 错误

zz/2024/4/20 0:15:32

 

RAC RMAN 测试,配置通道后,检验时报错。

 

RMAN> configure channel 1 device type disk connect 'sys/admin@orcl1';

new RMAN configuration parameters:

CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT  'sys/admin@orcl1';

new RMAN configuration parameters are successfully stored

 

RMAN> configure channel 2 device type disk connect 'sys/admin@orcl2';

new RMAN configuration parameters:

CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT  'sys/admin@orcl2';

new RMAN configuration parameters are successfully stored

 

RMAN> show channel;

RMAN configuration parameters are:

CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT  'sys/admin@rac1';

CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT  'sys/admin@rac2';

 

 

RMAN> delete expired archivelog all;

 

using target database control file instead of recovery catalog

configuration for DISK channel 2 is ignored

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of delete command at 09/20/2010 17:14:21

RMAN-12001: could not open channel ORA_DISK_1

RMAN-10008: could not create channel context

RMAN-10003: unable to connect to target database

ORA-01017: invalid username/password; logon denied

 

 

Tnsping 测试正常:

 

[oracle@rac1 u02]$ tnsping orcl1

 

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 20-SEP-2010 20:21:21

 

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

 

Used parameter files:

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) (INSTANCE_NAME = orcl1)))

OK (0 msec)

[oracle@rac1 u02]$ tnsping orcl2

 

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 20-SEP-2010 20:21:25

 

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

 

Used parameter files:

 

 

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) (INSTANCE_NAME = orcl2)))

OK (10 msec)

 

 

Oracle 官网对这个错误的说明:

 

Applies to: 
~~~~~~~~~~~
Oracle Server Enterprise Edition but may happen Standard Edition as well. 
 
 
Symptoms
~~~~~~~~~
A RMAN command such as "delete" results in errors like these:
 
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 09/05/2006 17:26:51
RMAN-12001: could not open channel ORA_DISK_1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database
ORA-01017: invalid username/password; logon denied
 
 
Changes
~~~~~~~~
Modification or addition of the persistent configuration parameter for 
connecting to the target database. 
 
 
Cause
~~~~~~
The RMAN "show all" command will show a setting like this one or with an incorrect 
password, incorrect userid, etc:
 
  CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
 
 
Solution
~~~~~~~~~
1) Return this persistent configuration parameter back to the default setting 
   as follows:
 
   RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK CLEAR;
 
   of change the configuration to a correct value
   RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK  connect '<username/password>';
 
2) Re-submit the failing operation. 

 

 

Google 的一个结果,是因为 REMOTE_LOGIN_PASSWORDFILE 被修改了。 但是我检查了这个参数没有问题:

 

In addition, check to ensure that your REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE for each instance. Your password file may not be available or incorrect.

 

 

折腾了三个小时的结果是: 把密码记错了,测试环境的的密码是oracle,不是admin. 居然杯具到这个地步.  汗啊….

 

 

 

------------------------------------------------------------------------------

QQ: 492913789
Email: ahdba@qq.com
Blog: http://www.cndba.cn/dave

网上资源: http://tianlesoftware.download.csdn.net

相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群:62697716(); DBA2 群:62697977()

DBA3 群:63306533;     聊天 群:40132017

--加群需要在备注说明SGA的组成部分,否则拒绝申请


http://www.ngui.cc/zz/2721261.html

相关文章

RAC 之 RMAN 恢复

之前整理的RMAN 有关还原的文章&#xff1a; RMAN 系列&#xff08;五&#xff09; ---- RMAN 还原 与 恢复 http://www.cndba.cn/Dave/article/1065 RMAN 备份与恢复 实例 http://www.cndba.cn/Dave/article/1073 Oracle Rman跨resetlogs版本恢复 http://www.cndba.cn/dave/ar…

RAC crs 卸载后,再次安装Oracle, crs 目录还存在的问题

今天在做RAC data Guard 的实验。 用了之前做RAC 添加节点的虚拟机。 即以前的rac3节点。 这个节点之前已经卸载过了。 卸载方法参考&#xff1a; RAC 卸载 说明 http://blog.csdn.net/tianlesoftware/archive/2010/09/18/5892225.aspx 但是在安装Oracle 软件的时候&#x…

oracle 11gR2 RAC root.sh 错误 ORA-15072 ORA-15018

Oracle 11gR2 RAC 安装Clusterware 结束&#xff0c; 在第二个节点执行root.sh脚本的是报如下错误&#xff1a; DiskGroup DATA1 creation failed with the following message: ORA-15018: diskgroup cannot be created ORA-15072: command requires at least 1 regular failu…

Oracle Data Guard ORA-16086: standby database does not contain available standby 处理方法

启动Data Guard 后&#xff0c; 查看同步情况&#xff1a; SQL> select error from v$archive_dest; ERROR ----------------------------------------------------------------- ORA-16086: standby database does not contain available standby log files ERROR ---…

Oracle Transparent Application Failover(TAF) 说明

前几天和一个朋友讨论到Oracle Net Services的高级特性的问题&#xff0c;就研究了下。 Oracle 官网上的说明参考&#xff1a; Enabling Advanced Features of Oracle Net Services http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/advcfg.htm#i473297 在这…

IBM AIX 5.3 系统管理 -- 监视和性能优化一

一. 监视文件系统增长 在 AIX 5L 系统上&#xff0c;管理员需要监视文件系统增长以防止文件系统装满。 基于“Berkeley 磁盘配额系统”(Berkeley Disk Quota System) 的磁盘配额系统提供了一种控制磁盘空间使用的有效方法。可以为各个用户或组定义配额系统&#xff0c;并且每…

IBM HACMP 系列 -- 基础知识

一. 什么是 HACMP(High Availability Cluster Multi-Processing) 1.1 高可用性 在当今的复杂环境中&#xff0c;为应用程序提供连续的服务是成功的 IT 实现的重要组成部分。高可用性屏蔽或消除计划内和计划外的系统和应用程序停机时间&#xff0c;是帮助为应用程序客户端提供…

浅谈 HACMP 心跳

一. 初识 HACMP 心跳 HACMP 软件主要监控 4 种故障&#xff1a;节点&#xff0c;网卡&#xff0c;网络&#xff0c;应用。其中前三种都是通过心跳来监控并产生事件响应的&#xff0c;我们可以看出使用 HACMP 集群&#xff0c;可谓玩的就是心跳。如果不了解心跳的过程和基本原理…

Oracle Golden Gate 简述

Oracle 在2009年收购了Golden Gate&#xff0c;之后Oracle 把Stream 的一些优点引入到了Golden Gate。 所以以后在数据复制这块&#xff0c;Oracle 肯定也是大力发展Golden Gate。 官网参考&#xff1a; http://www.oracle.com/us/corporate/Acquisitions/goldengate/index.h…

OEM 应用程序要求的数据库权限超出了您当前具有的权限 解决方法

当Oralce 访问OEM 出现如下错误时&#xff1a; 应用程序要求的数据库权限超出了您当前具有的权限 从如下2个方面检查&#xff1a; &#xff08;1&#xff09;给用户赋SELECT_CATALOG_ROLE grant SELECT_CATALOG_ROLE to user &#xff08;2&#xff09;DBSNMP&#xff0c;SYSMA…