惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

L
LangChain Blog
V
V2EX
爱范儿
爱范儿
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
Martin Fowler
Martin Fowler
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
Apple Machine Learning Research
Apple Machine Learning Research
WordPress大学
WordPress大学
有赞技术团队
有赞技术团队
宝玉的分享
宝玉的分享
Last Week in AI
Last Week in AI
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
罗磊的独立博客
小众软件
小众软件
Vercel News
Vercel News
博客园 - 司徒正美
阮一峰的网络日志
阮一峰的网络日志
V
Visual Studio Blog
J
Java Code Geeks
P
Proofpoint News Feed
MongoDB | Blog
MongoDB | Blog
B
Blog
美团技术团队
量子位

博客园 - killkill

jar 冲突、class 冲突的检测脚本 Oracle User Calls 和 Executions 两个概念的区别 使用 dbms_xplan.display 按照 plan_hash_value 查执行计划的方法 oratop 各个指标项说明 [转] sql_id VS hash_value lsattr/chattr [转]节约内存:Instagram的Redis实践 [原]佛山-杭州自驾路书 [原] insert into … on duplicate key update / replace into 多行数据 [摘] python url decoder 一条霸气的分析binlog的命令 一句命令完成MySQL的数据迁移(轻量级) [转]Linux下SSH Session复制 使用taskset命令来限制进程的CPU MySQL重复记录删除 使用Screen抵御杯具 [摘]Oracle 11g Flashback_transaction_query的undo_sql为空? [摘]如何抓住蝴蝶效应中的那只蝴蝶 [原]将Oracle 中的blob导出到文件中
Duplicate Active Database 遇到 ORA-01017 invalid username...
killkill · 2011-05-29 · via 博客园 - killkill

      Oracle 11g 的新特性Duplicate Active Database可以在不备份target database的情况下构建 duplicate database,特别适合于为VLDB构建standby的场景。今天特意试一下,但是却让我遇上了 ORA-01017 invalid username/password,过程如下:

oracle@dev18:abank /home/oracle>rman target / auxiliary sys/__password__@abank_123 

Recovery Manager: Release 11.2.0.1.0 - Production on Sun May 29 14:16:08 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: abank (DBID=433589790)
connected to auxiliary database: abank (not mounted)

RMAN> duplicate target database for standby from active database ;  

Starting Duplicate Db at 2011-05-29 14:16:17
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=1149 device type=DISK

contents of Memory Script:
{
   backup as copy reuse
   targetfile  '/opt/app/oracle/product/11.2.0/db/dbs/orapwabank' auxiliary format 
 '/opt/app/oracle/product/11.2.0/db/dbs/orapwabank'   ;
}
executing Memory Script

Starting backup at 2011-05-29 14:16:18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=594 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/29/2011 14:16:19
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/29/2011 14:16:19
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server

      打开rman的时候已经进行了验证,理论上不应在有验证的问题,google得知使用Duplicate Active Database要这样登入rman:

rman target sys/__password__ auxiliary sys/__password__@abank_123