when trying to deploy extract on source database (10gr2) while asm password is passwor*d.
logon by
sqlplus sys/passwor*d@asm as sysdba
successfully.
However start extract with parameter file as follows:
EXTRACT extte
SETENV (ORACLE_HOME=/oracle/app)
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID ogg@test,PASSWORD oggpassword
TRANLOGOPTIONS ASMUSER sys@OGGASM,ASMPASSWORD passwor*d
EXTTRAIL /data/oggdata/dirdat/te
TABLE TEST.*;
extract complained:
2013-12-24 14:13:09 ERROR OGG-00868 Establishing ASM session for login user sys: (1017) ORA-01017: invalid username/password
; logon denied.
2013-12-24 14:13:09 ERROR OGG-01668 PROCESS ABENDING.
According to MOS,changing password for asm requires shutdown database and asm instance,it's unacceptable in product database.So I have to escape the asterisk in asm password.
Thank you so much for reading and appreciate any advice.