克隆 跑脚本 报ora-17629:ora-01017

后知后觉12345 2018-07-11 11:06:40
脚本内容:
[oracle@tqzdb003 ~]$ cat dup-2.sh
# clone using RMAN script
$ORACLE_HOME/bin/rman target sys/root*123@TQZ auxiliary sys/rfvgy@TQZDB003 << EOF

run {
duplicate target database to TQZDB003 from active database nofilenamecheck
spfile
parameter_value_convert 'TQZ','tqzdb003'
set db_name='tqzdb003'
set db_unique_name='tqzdb003'
set control_files='/u01/app/oracle/oradata/tqzdb003/control01.ctl','/u01/app/oracle/oradata/tqzdb003/control02.ctl'
set log_file_name_convert='/u01/app/oraqz/oraqzdata/TQZ/redo*','/u01/app/oracle/oradata/tqzdb003/','/u01/oraqzdata/TQZ/arch/','/u01/oradata/tqzdb003/arch/'
set db_file_name_convert='/u01/app/oraqz/oraqzdata/TQZ/*.dbf','/u01/app/oracle/oradata/tqzdb003/', '/u01/app/oraqz/oraqzdata/TQZ/*.ctl','/u01/app/oracle/oradata/tqzdb003/'
set log_archive_dest_1='location="/u01/oradata/tqzdb003/arch/"'
set audit_file_dest='/u01/app/oracle/product/11.2.0/db_home/rdbms/audit'
set diagnostic_dest='/u01/app/oracle'
set sga_target '16G'
set sga_max_size '16G'
set pga_aggregate_target '2G'
set shared_pool_size '800M'
set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.100.6.167)(PORT=1521)))'
set remote_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.100.6.167)(PORT=1521)))'
set instance_name 'TQZDB003'
set service_names 'TQZDB003'
set cluster_database 'FALSE'
set utl_file_dir='/usr/tmp','/u01/tqzdb003/tqzdbtmp'
;
}
EOF

克隆 跑跑脚本报错:
[oracle@tqzdb003 ~]$ sh dup-2.sh

Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jul 11 10:54:27 2018

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

connected to target database: TQZ (DBID=2609219291)
connected to auxiliary database: TQZDB003 (not mounted)

RMAN>
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24>
Starting Duplicate Db at 11-JUL-18
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK

contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oraqz/product/11.2.0/dbhome_1/dbs/spfileTQZ.ora' auxiliary format
'/u01/app/oracle/product/11.2.0/db_home/dbs/spfiletqzdb003.ora' ;
sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/db_home/dbs/spfiletqzdb003.ora''";
}
executing Memory Script

Starting backup at 11-JUL-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=16 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/11/2018 10:54:31
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/11/2018 10:54:31
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>

Recovery Manager complete.


百度了很久 也没有找到解决的办法,tnsnames.ora 目标端和源端配置确认没有问题,请问各位是什么原因?
...全文
249 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
minsic78 2018-07-12
  • 打赏
  • 举报
回复
密码错误。

那个root*123中的*是密码中确实的一位?如果是,用\转义掉吧
  • 打赏
  • 举报
回复
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
这报的确实是ora错误的,建议还是再确认这些
啊大1号 2018-07-11
  • 打赏
  • 举报
回复
应该还是哪里配置问题,建议去oracle社区看看。
“https://community.oracle.com/thread/3940562”

17,377

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧