Thursday, October 10, 2013

Changing Blackboard 9.1 SP13 Oracle Passwords

As of Blackboard Learn 9.1 SP13 CP6


Change SYS password
SQL> alter user sys identified by newsyspassword;


Change SYSTEM password

SQL>alter user system identified by newsystempassword;

bbconfig.database.server.systemuserpassword=newsystempassword
bbconfig.cs.db.systemuser.pass=newsystempassword



Change BBLEARN_REPORT Password

SQL>alter user BBLEARN_REPORT identified by newreportpassword;
antargs.default.vi.report.user.password=newreportpassword


Change BBLEARN_STATS Password
SQL>alter user BBLEARN_STATS identified by newstatspassword;
SQL>update BBLEARN_ADMIN.bb_instance set STAT_DB_PASS='newstatspassword';

antargs.default.vi.stats.db.password=newstatspassword


Change BBLEARN & BBLEARN_ADMIN password must have the SAME password

SQL>alter user BBLEARN_ADMIN identified by adminpassword;
SQL>update BBLEARN_ADMIN.bb_instance set db_pass='adminpassword';

bbconfig.database.admin.password=adminpassword


SQL>alter user BBLEARN identified by adminpassword;
antargs.default.vi.db.password=adminpassword


CMS_USER && BBLEARN_CMS_DOC  must have the SAME Password

SQL>alter user BBLEARN_CMS identified by newcmspassword;
bbconfig.cs.db.cms-user.pass=newcmspassword


SQL>alter user BBLEARN_CMS_DOC identified by newcmspassword;
SQL>update BBLEARN_CMS.xy_file_systems set db_password='newcmspassword';





No comments:

Post a Comment