2 Replies Latest reply on Jun 2, 2015 5:19 AM by Juan-Luis Ortega

    RDS - oracle xe password expired

    Hamish Marson



      I have a v8.6 RDS installed as a VMWare appliance. No config was necessary, it was install and run. So oracle-XE already onboard and setup etc.


      Trouble is, not 180 days have passed since it was installed, and the password the appserver uses to connect has apparently expired...


      com.bladelogic.om.infra.app.db.DBException: An error occurred while attempting to access the database:

      Message : ORA-28001: the password has expired

      SQLState: null ErrorCode: 0



      Now... I could reset it... if I knew the sys password to get into oracle-xe... All the RDS docs online seem to indicate you should have this when performing the database import. But my RDS downloaded as a VMWare image already configured. So I don't know the passwords.


      Anyone got any ideas?