"Authentication failed on connection to server. Make sure that the user account has the appropriate permissions and that the password was typed correctly" occurs while trying to select the Oracle instance in the Backup Exec selection list.

Article:TECH64001  |  Created: 2008-01-13  |  Updated: 2013-07-12  |  Article URL http://www.symantec.com/docs/TECH64001
Article Type
Technical Solution


Issue



The error "Authentication failed on connection to server. Make sure that the user account has the appropriate permissions and that the password was typed correctly" occurs while trying to select Oracle instance for backup.


Error



The Backup Exec Remote Agent Debug Log on Oracle server shows:
  
[3068] OCISessionBegin() failed with database credentials.
 
[3068] OCI_ERROR: ORA-12557: TNS:protocol adapter not loadable
 
[3068] Failed to logon to database, other error: Error code (0x310d)
 
[3068] Returning E_RMAN_LOGON_OTHER error (0xe000fe29)
 
[3068] DSEnumerator failed with -536805847: "Authentication failed on connection to server. Make sure that the user account has the appropriate permissions and that the password was typed correctly" occurs while trying to select the Oracle instance in the Backup Exec selection list"
 
[3068] @@@@@@@MyCloseSocket called with sockfd = 1124(0x464) retval = 0
 
[3068] DS_CloseSelectionService
 
[3068] [no resource for 3894] 
 

Solution



Make sure that path to the "bin" folder of Oracle instance is the first value in the "Path" variable of the Environment variables of the Oracle Server.
  • Right  click on my computer go to Properties
  • Go to Advanced tab and click on Environmental variables button
  • Check the variable "path". It should contain the path to the Oracle bin directory. 
E.g.:  X:\oracle\ora92\bin  OR  X:\oracle\product\10.2.0\db_1\bin   (Where X: is the drive on which Oracle is installed)
 
The oracle server needs to be rebooted after changing the path variables as mentioned above.

Supplemental Materials

SourceError Code
Value536805847
Description

 DSEnumerator failed with -536805847: "Authentication failed on connection to server. Make sure that the user account has the appropriate permissions and that the password was typed correctly" occurs while trying to select the Oracle instance in the Backup Exec selection list"


SourceError Code
Value0xe000fe29
Description

  Returning E_RMAN_LOGON_OTHER error (0xe000fe29) 


Legacy ID



311549


Article URL http://www.symantec.com/docs/TECH64001


Terms of use for this information are found in Legal Notices