search cancel

For EEM report tool configuration can Oracle TNS Service Name be used instead of Oracle SID

book

Article ID: 223711

calendar_today

Updated On:

Products

CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

Hi Team,

Need your expertise on EEM reporting tool configuration. 

DBA just completed the new tablespace creation and an id for this purpose, also below steps has been completed. 

Please let me know the next steps. 

To configure the Oracle database for the Service name, follow these steps:
  • Create a user named eemserveruser with CONNECT and RESOURCE privileges.
  • Verify that the permissions are defined correctly by running the following commands:
     
    connect eemserveruser/password@schema;
    select * from USER_ROLE_PRIVS;
  • Use the
    eemserveruser user for setup with the service.

Environment

Release : 11.3.6

Component : WA AE/AUTOSYS RELATED EEM

Resolution

The Oracle service name can be used instead of the Oracle SID beginning with the AutoSys 11.3.6 SP6 release.