[oracle @ tqzdb003 ~] $cat dup - 2. Sh
# clone using RMAN script
The $ORACLE_HOME/bin/rman target sys/root * 123 @ TQZ auxiliary sys/rfvgy @ TQZDB003 & lt;
The run {
Duplicate the target database to TQZDB003 from the active database nofilenamecheck
Spfile
Parameter_value_convert 'TQZ', 'tqzdb003'
The set db_name='tqzdb003'
The 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/'
The 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'
The set diagnostic_dest='/u01/app/oracle'
The set sga_target '16 g'
The set sga_max_size '16 g'
The set pga_aggregate_target '2 g'
The set shared_pool_size '800 m'
Set local_listener='(the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=10.100.6.167) (1521) PORT=))'
Set remote_listener='(the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=10.100.6.167) (1521) PORT=))'
The set instance_name 'TQZDB003'
The set services an instance belongs' TQZDB003 '
The set cluster_database 'FALSE'
Set utl_file_dir='/usr/TMP', '/u01/tqzdb003/TQZDBTMP'
;
}
EOF
Cloning to run the script error:
[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 the target database: TQZ (DBID=2609219291)
Connected to auxiliary database: TQZDB003 (not mounted)
RMAN>
RMAN> 2> 3> 4> 5> 6 & gt; 7 & gt; 8 & gt; 9 & gt; 10 & gt; 11 & gt; 12 & gt; 13 & gt; 14 & gt; 15 & gt; 16 & gt; 17 & gt; 18 & gt; 19 & gt; 20 & gt; 21 & gt; 22 & gt; 23 & gt; 24 & gt;
Starting the Duplicate Db at 11 JUL - 18
Home using target database control file recovery catalog
Allocated channel: ORA_AUX_DISK_1
The channel ORA_AUX_DISK_1: SID=19 device type=DISK
The contents of the Memory Script:
{
As backup 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 "the alter system set spfile='/u01/app/oracle/product/11.2.0/db_home/DBS/spfiletqzdb003 ora'";
}
Executing the Memory Script
Starting backup at 11 JUL - 18
Allocated channel: ORA_DISK_1
The 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: an error occurred in stored script script Memory
RMAN - 03009: failure of backup command on ORA_DISK_1 channel at 07/11/2018 10:54:31
ORA - 17629: always connect to the remote database server
ORA - 17627: ORA - 01017: invalid username/password. Logon denied
ORA - 17629: always connect to the remote database server
RMAN>
Recovery Manager complete.
Baidu for a long time did not find a solution, tnsnames. Ora target end and the source end configuration to confirm there is no problem, what is your reason?
CodePudding user response:
ORA - 17629: always connect to the remote database serverORA - 17627: ORA - 01017: invalid username/password. Logon denied
ORA - 17629: always connect to the remote database server
This quote is, indeed, ora error, it is suggested that go to confirm these
CodePudding user response:
Where should or configuration issues, suggest to oracle community to see,"Https://community.oracle.com/thread/3940562"
CodePudding user response:
Password mistake,The root of * * is the password of the 123 a? If it is, use \ escape