Oracle Auditing: fix_sysaux.bash: "Logon using _dba/aleph_dba as sysdba failed"

• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
In applying the changes per the news item "Oracle Auditing" on the CRM we have encountered an error:

...
root@alapp20 tmp]# bash fix_sysaux.bash aleph_dba
Logon using _dba/aleph_dba as sysdba failed
...

Resolution:
The attempt to run the script fix_sysaux.bash failed since the user ALEPH_DBA is not granted with the sysdba privilege.

In order to fix this, you should log on as sys and use the command:

SQL>grant sysdba to aleph_dba

• Article last edited: 10/8/2013