Jul 29, 2013

How to remove the password expiry for DB users in Oracle DB.

DDLs to unlock the db user
ALTER USER sys IDENTIFIED BY new_password account unlock;
ALTER USER dbsnmp IDENTIFIED BY new_password account unlock;
ALTER USER sysman IDENTIFIED BY new_password account unlock;
ALTER USER system IDENTIFIED BY new_password account unlock;

DDL to remove users password expiry.
ALTER PROFILE DEFAULT LIMIT password_life_time UNLIMITED;

Statement to verify the User account status and expiry date.
SELECT username,ACCOUNT_STATUS,EXPIRY_DATE FROM dba_users;

Jul 11, 2013

Enabling Weblogic Server for debug

After the line ${JAVA_HOME}/bin/java ${JAVA_VM} –version, add the following two lines in $DOMAIN_HOME/bin/startWeblogic.sh
 
echo "Launching Java with debug port: 11171" 

export JAVA_OPTIONS="-Xdebug -Djava.compiler=NONE -Xnoagent -Xrunjdwp:transport=dt_socket,server=y,address=11171,suspend=n $JAVA_OPTIONS" (for Linux)

set JAVA_OPTIONS=-Xdebug -Djava.compiler=NONE -Xnoagent -Xrunjdwp:transport=dt_socket,server=y,address=11171,suspend=n %JAVA_OPTIONS% (for Windows)
 
Note: The debug port 11171 specified should be available.