This content has been marked as final. Show 3 replies
Welcome to the forums !
Pl elaborate on what you mean by "dba activities". Traditional DBA activities (creating custo schemas, maintenance of datafiles/tablespaces etc) need to be performed using the SYSTEM account, as usual. There are very few (if any) DBA-type activities that require the use of the APPS account. The APPS account (by default) does not have the DBA role. All EBS maintenance activities have various executables (e.g. adpatch, adadmin etc) that require the SYSTEM and APPS passwords.
I was told that I must use the APPS account for all dba activities for our Oracle 11.5.10 release on Oracle10g on SunSolaris 10.5. I was told this was recommended by Oracle.What is your source?
I was trained that we should use the sysdba account for dba stuff and the application id for usertable stuff.The sysdba/system accounts should be used for the DBA activities (maintain the database) and the apps account should be used to maintain apps/applsys and other modules tables, and run the main utilities at the application tier level.