Hi,
We have done gateway setup for RAC DB 11.2.0 to MYSQL DB.
Performed below steps for Hetrogeneous setup :-
- Installed 11G gateway on separate machine.
-Installed GatewayConfig utitlity.
-Performed post steps as mentioned in SQLServerSetup.rtf file.
getting message in alert log :-
ERROR, tran=31.33.891584, session#=1, ose=0:
ORA-01017: invalid username/password; logon denied
[Oracle][ODBC SQL Server Wire Protocol driver][SQL Server]Login failed for user 'dbo'. {28000,NativeErr = 18456}
ORA-02063: preceding 2 lines from HN_PROD
in initUN_PROD.ora
HS_FDS_RECOVERY_ACCOUNT=dbo
where dbo is our SQL server db name.
What is use of HS_FDS_RECOVERY_ACCOUNT parameter. Is it mendatory to provide this parameter ? Do we need to create recovery user in SQL DB or we can give DB name as recovery user.
Please suggest !!!
Regards,
Mukesh.