Database Administration (MOSC)

MOSC Banner

Oracle EBS database system accounts password change

in Database Administration (MOSC) 3 commentsAnswered ✓

Hi team,


I have a task to apply a new security policy regarding our EBS database. Database version is 12.1 on Oracle Linux 7. My thoughts are to simply alter user sys and system with new password policy, recreate password file

using orapwd utility and then to run autoconfig on both tiers (application and database). Also, i have created dba_profile which suits our new password policy, and will assign it to them.


Is this the correct way regarding EBS database? I have done this plenty of times, but not sure would be enough when the database is part of EBS? 


One more thing as i can see dbsnmp user account is in open status, and there is no sysman nor OEM in use. So this mean that sometime in the past this database has OEM configured, so dbsnmp account is legacy here? I would like to change the password or that user as well, or maybe just to lock it?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center