When a password string is including [@] character, Oracle backups may fail with TNS error

Problem

When a password string is including [@] character, Oracle backups may fail with TNS error

Error Message

ORA-12154: TNS:could not resolve the connect identifier specified

OR

ORA-12543: TNS:destination host unreachable

Solution

Oracle backups can fail with TNS error when all the following conditions are met:
1. A logon account is specified for not only an oracle server but also an Oracle database. (Figure 1)
2. The logon account for the oracle database is including [@] character.

Figure 1
 

Cause:

The logon account for the oracle database is used for that RMAN connects to a target database.
For instance, when the user name is [scott] and the password is [t@iger], RMAN will connect to the database as follows:
C:> RAMN target scott/t@iger
In this scenario, RMAN will connect to [iger] database and fail in the TNS name resolution.

If the Oracle database has OS authentication, the account for RMAN is not needed. In this scenario, RMAN will connect to the database as follows:
C:> RAMN target /


Resolution:

To resolve this issue please perform one of the following:
A. Clear the logon account for the oracle database if the OS authentication is enabled.
B. Change the password without [@] character.
 

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)