Today I have taken a topic of very basic tips and practices to be followed by an Oracle Apps DBA in day to day support. It might look like a silly topic but it makes sense to put these points in the list of DBA practices.
First and foremost thing a DBA must take care is to change the default passwords of all accounts, after installation or cloning. When I say all accounts, it does mean ALL. In most cases, the accounts like ap, ar, etc..accounts will be missing in their change password list. And especially sys will have the default password.
For more details refer metalink note ID: 419475.1.
Second tip is to avoid entering the apps password or any password on the bash shell prompt while running any commands or scripts. It can easily be traced from bash_history if any technical/admin have OS privileges. Oracle has implemented the hide password option for all scripts almost now.
Third even if someone forgets not to enter the password on the command prompt, one must remember not to send the screenshot of the session where you entered password to the functional/technical/client after completing the task :).
This list will continue....
deep knowledge about oracle.post new blog related to Remote DBA Support.
ReplyDelete