Thursday, April 22, 2010

Changing Oracle User Passwords in Blackboard 8

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

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


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

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


If you change the BBADMIN user password
==> bbconfig.database.bbadmin.db.password=



if you change BB_BB60_STATS
==>antargs.default.vi.stats.db.password
===>update BBADMIN.bb_instance set stat_db_pass='';



if you change BB_BB60_REPORT
==>antargs.default.vi.report.user.password



SQL> alter user cms identified by newcontent123; --all six database users for Content System
SQL> alter user cms_files_users identified by newcontent123; --must use the same password!!!
SQL> alter user cms_files_courses identified by newcontent123;
SQL> alter user cms_files_orgs identified by newcontent123;
SQL> alter user cms_files_inst identified by newcontent123;
SQL> alter user cms_files_library identified by newcontent123;
SQL> update cms.xy_file_systems set db_password='newcontent123';
SQL> commit;

==>bbconfig.cs.db.cms-user.pass=newcontent123

No comments:

Post a Comment