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

book

Article ID: 100003683

calendar_today

Updated On:

Description

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 occur if the Linux account used to browse the RAC or Linux server does not have access to the Oracle Binaries. Oracle binaries are located in the Oracle install directory (Eg: /u01/Oracle).

Resolution

1. Confirm that the account used for browsing the selections is the 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 the Oracle directory.

 

 

Issue/Introduction

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