When selecting Oracle database under a RAC or Standalone Oracle Server the selection fails with "Authentication failed on connection to server"

Problem

This issue may occur when trying to select the Oracle database under a RAC node or Oracle standalone setup. A RALUS debug from the Linux server will show the following errors.

Error Message

7570ba0 Wed Nov 10 14:17:26 2010 : OCIServerAttach() Linux 1
7570ba0 Wed Nov 10 14:17:26 2010 : OCIServerAttach() Linux 2
7570ba0 Wed Nov 10 14:17:26 2010 : OCIServerAttach() failed
7570ba0 Wed Nov 10 14:17:26 2010 : OCISessionBegin() failed with database credentials.
7570ba0 Wed Nov 10 14:17:26 2010 : OCI_ERROR: ORA-12546: TNS:permission denied
7570ba0 Wed Nov 10 14:17:26 2010 : Failed to logon to database, other error: Error code (0x3102)
7570ba0 Wed Nov 10 14:17:26 2010 : Returning E_RMAN_LOGON_OTHER error (0xe000fe29)
7570ba0 Wed Nov 10 14:17:26 2010 : DSEnumerator failed with -536805847: 0

Cause

The above error can occurr if the Linux account used to browse the RAC or Linux server does not have the access to the Oracle Binaries. Oracle binaries are located in the Oracle install directory (Eg: /u01/Oracle).

Solution

1. Confirm that the account used for browsing the selections is same as used for Oracle install. (Usually on most setups this account name is "oracle")

2. The account and the group it belongs to should have permissions to Oracle directory.