Tuesday, August 19, 2014

Useful AIX commands for Oracle DBA


Change oracle user password
root@server:/admin > echo oracle:password | chpasswd 

Clear the prompt for change
root@server:/admin > pwdadm -c oracle

Change user maxage setting to never expire for oracle
root@server:/admin > chuser maxage=0 oracle

Check current settings for oracle -user
root@server:/admin > grep -p "oracle:" /etc/security/user
oracle:
        admin = false
        loginretries = 0
        histsize = 0
        maxage = 0
        umask = 22




No comments:

Post a Comment