Changing Oracle User Passwords in Blackboard 9.1

Here's the list of usernames used by Blackboard in Oracle

BBLEARN_REPORT
BBLEARN_CMS
BBLEARN_CMS_DOC
BBLEARN_STATS
BBLEARN
BBLEARN_ADMIN
SYSTEM
SYS

if you changed the oracle SYS password, the following must be changed:
====>bbconfig.database.server.systemuserpassword


if you changed the oracle SYSTEM password, change the following:
====>bbconfig.cs.db.systemuser.pass=



if you change the Oracle BBLEARN_ADMIN, change the following:
====>bbconfig.database.admin.password=


if you change the Oracle BBLEARN_REPORT, change the following:
====>antargs.default.vi.report.user.password=



If you change Oracle BBLEARN password, remember to update the bbadmin.bb_instance table.

===>alter user BBLEARN identified by ;
===>update BBLEARN_ADMIN.bb_instance set db_pass='';
===> antargs.default.vi.db.password=



If you change Oracle BBLEARN_STATS password, remember to update the bbadmin.bb_instance table.

===>alter user bb_bb60_stats identified by ;
===> update BBLEARN_ADMIN.bb_instance set stat_db_pass='';
===>antargs.default.vi.stats.db.password



/* Change CMS password does not work. currently encountered the following error */

Caused by: com.xythos.common.InternalException: JDBCConnectionPool:190 - (ORA-01017: invalid username/password; logon denied

) InvocationTargetException: check database configuration settings for store 'XYTHOS_POOL', DB username 'BBLEARN_cms', at URL jdbc:oracle:thin:@bb.bee-net.com:1521:bb60

To change the CMS and CMS_DOC passwords

SQL> SELECT USERNAME FROM DBA_USERS WHERE USERNAME LIKE '%CMS%';

USERNAME
------------------------------
BBLEARN_CMS_DOC
BBLEARN_CMS

SQL> alter user bblearn_cms identified by newpassword;

User altered.

SQL> alter user bblearn_cms_doc identified by newpassword;

User altered.

SQL> update bblearn_cms.xy_file_systems set db_password='newpassword';

1 row updated.

SQL> commit;

Commit complete.


Edit the bb-config.properties file. Change the bbconfig.cs.db.cms-user.pass=newpassword
Run PushConfigUpdates.sh