PPM - Oracle password expiry problem and making the oracle password never expire.

In Project and Portfolio Management (PPM) DEV or Test instance, We may consistenly face an issue that the PPM password frequently expire at regular intervals. When ever we start the PPM application, we will be getting the below error message.

C:\PPM5\bin>sh kStart.sh
JAVA_HOME = C:/Java/jdk1.6.0_07
java version "1.6.0_07"
Java(TM) SE Runtime Environment (build 1.6.0_07-b06)
Java HotSpot(TM) Client VM (build 10.0-b23, mixed mode, sharing)
Server will start in cluster mode...
JAVA_HOME = C:/Java/jdk1.6.0_07
java version "1.6.0_07"
Java(TM) SE Runtime Environment (build 1.6.0_07-b06)
Java HotSpot(TM) Client VM (build 10.0-b23, mixed mode, sharing)
java.sql.SQLException: ORA-28001: the password has expired

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
        at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:794)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:391)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:474)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at com.kintana.core.util.DBUtils.createJdbcConnection(DBUtils.java:843)
        at com.kintana.core.util.DBUtils.createJdbcConnection(DBUtils.java:803)
        at com.kintana.core.server.ServerConfigAgent.getDefaultClusterName(ServerConfigAgent.java:2825)
        at com.kintana.core.server.ServerConfigAgent.configure(ServerConfigAgent.java:779)
        at com.kintana.core.server.ServerConfigAgent.configure(ServerConfigAgent.java:642)
        at com.kintana.core.server.Server.basicInit(Server.java:950)
        at com.kintana.core.server.ServerStartupSanity.initServer(ServerStartupSanity.java:433)
        at com.kintana.core.server.ServerStartupSanity.doPreStartupChecks(ServerStartupSanity.java:137)
        at com.kintana.core.server.ServerStartupSanity.main(ServerStartupSanity.java:111)
Checking: C:\PPM5\server.conf

================================================================================
The following errors were found which prevent this node starting
server.conf: java.lang.NullPointerException
Node HPPPM sanity failed.  See server log for detail.
PPM failed the pre-startup sanity checks and will not start

The below steps will make sure that the Oracle password never expire.

Run the below query.

SQL> select profile from dba_users where username = 'SYSTEM';

In most cases it should  be ‘default’, then run the below query.

SQL> alter profile default limit password_life_time unlimited;

Profile altered.

After doing this, Reset the password of the PPM user and System user again.

SQL> alter user ppm identified by ppm;

User altered.

SQL> alter user system identified by ppm;

User altered.

By doing this, the password will never expire again.