In the event the system user password has been lost there is a database level procedure to restore the password to the initial default, “manager”. This procedure requires your DBA’s assistance. This procedure is compatible with versions 5.X, 7.X and 9.X. There is an alternate procedure which is self contained in version 9.0. This is outlined within standard documentation.
Start SQLPLUS or other applicable DB admin tool and login as a user with admin access to the sourcing schema.
SQL> UPDATE <%SCHEMA%>.FCI_SYS_CONTEXT SET ADMIN_USER = 'bhFmMkXpUn5W2' WHERE OBJECTID = 0";
SQL> commit;
<%SCHEMA%> needs to be replaced with the proper schema name used to create the sourcing schema. If you or your DBA are not familiar with this it can be found in several ways:
1)From within the application: in the System Information --> Database tab. Any user with System Administrator
rights can see this information.
In the connection string you will see the full JDBC string followed by the user/schema names.
2) in the FCISYSTEM.PROPERTIES file. In FCI_HOME/config
# ==================================================================
#
# S Y S T E M P R O P E R T I E S
#
# ==================================================================
# ==================================================================
# Database Settings
# ==================================================================
popdb.database=oracle
popdb.driverClass=oracle.jdbc.driver.OracleDriver
popdb.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
popdb.user=sour70test2
popdb.password===ACrGl1J+0qZbgB2kA
popdb.displayName=System Database
à popdb.owner=sour70test2
popdb.tablespace=
popdb.indexspace=
Note: You may need to restart the application for this to take full effect..
You can now login to the sourcing system as the system user with password “manager”. This password should immediately be set to something other than the default as this is a well known password.
As the system user,
a) Navigate to the Enterprise Contexts link.
b) Select and open for edit the System Context.
c) Update the system password. Click Save/Done.
d) Store the new system password in a safe location for future reference