If you are a Managed Hosting customer, this topic doesn't apply to you.

After the Blackboard Learn and content management export, the databases are ready to be imported into the Oracle instance on the new database server. The Blackboard Learn databases must be imported before the content management databases.

Import and configure Blackboard Learn databases

bblearn_admin database

  1. Login as system and drop the bblearn_admin user. Not necessary on a fresh database.

    DROP USER bblearn_admin CASCADE;
    ALTER TABLESPACE bblearn_admin_data COALESCE;
    ALTER TABLESPACE bblearn_admin_indx COALESCE;

  2. Login as system and re-create user bblearn_admin, the correct password must replace bbpassword.

    CREATE USER bblearn_admin IDENTIFIED BY "bbpassword" DEFAULT TABLESPACE bblearn_admin_data TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON bblearn_admin_data QUOTA UNLIMITED ON bblearn_admin_indx;
    GRANT connect, resource TO bblearn_admin;
    GRANT alter user TO bblearn_admin;
    GRANT select any table TO bblearn_admin;
    GRANT analyze any TO bblearn_admin;
    GRANT drop any table TO bblearn_admin;
    GRANT query rewrite TO bblearn_admin;
    GRANT alter tablespace TO bblearn_admin;
    GRANT create sequence TO bblearn_admin;

  3. Login as system and re-create the user bblearn_report, the correct password must replace bbpassword.

    CREATE USER bblearn_report identified BY "bbpassword" DEFAULT TABLESPACE bblearn_data TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON bblearn_data QUOTA UNLIMITED ON bblearn_indx;
    GRANT connect, resource to bblearn_report;
    GRANT alter user TO bblearn_report;
    GRANT select any table TO bblearn_report;
    GRANT analyze any TO bblearn_report;
    GRANT drop any table TO bblearn_report;
    GRANT query rewrite TO bblearn_report;
    GRANT alter tablespace TO bblearn_report;
    GRANT create sequence TO bblearn_report;

  4. Unzip and import the bblearn_admin schema.

    imp system/manager file=bblearn_admin.dmp fromuser=bblearn_admin touser=bblearn_admin commit=Y buffer=2048000

  5. Update the db_host, db_pass, stat_db_host, and stat_db_pass for each BBUID. The first BBUID is called bblearn by default. If the port numbers are different, these must also be updated. Replace NEW_PASSWORD with the password that was documented in Setting Up Target System for Import in an Oracle Environment.

    UPDATE bb_instance SET db_host = 'NEW_DB_HOST_NAME', db_pass = 'NEW_PASSWORD ', db_instance = 'NEW_ORACLE_SID', stat_db_host = 'NEW_STAT_DB_HOST_NAME', stat_db_pass = 'NEW_STAT_DB_PASSWORD' where bbuid = 'bblearn';
    COMMIT;

bblearn_stats database

  1. Login as system and drop the bblearn_stats user. Not necessary on a fresh database.

    DROP USER bblearn_stats CASCADE;
    ALTER TABLESPACE bblearn_stats_data COALESCE;
    ALTER TABLESPACE bblearn_stats_indx COALESCE;

  2. Login as system and re-create user bblearn_stats, the correct password must replace bbpassword.

    CREATE USER bblearn_stats IDENTIFIED BY "bbpasswd" DEFAULT TABLESPACE bblearn_stats_data TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON bblearn_stats_data QUOTA UNLIMITED ON bblearn_stats_indx;
    GRANT connect, resource to bblearn_stats;
    GRANT alter user TO bblearn_stats;
    GRANT select any table TO bblearn_stats;
    GRANT analyze any TO bblearn_stats;
    GRANT drop any table TO bblearn_stats;
    GRANT query rewrite TO bblearn_stats;
    GRANT alter tablespace TO bblearn_stats;
    GRANT create sequence TO bblearn_stats;

  3. Import the bblearn_stats schema.

    imp system/manager file=bblearn_stats.dmp fromuser=bblearn_stats touser=bblearn_stats commit=Y buffer=2048000

bblearn database

  1. Login as system and drop the bblearn user. Not necessary on a fresh database.

    DROP USER bblearn CASCADE;
    ALTER TABLESPACE bblearn_data COALESCE;
    ALTER TABLESPACE bblearn_indx COALESCE;

  2. Login as system and re-create user bblearn, the correct password must replace bbpassword.

    CREATE USER bblearn identified BY "bbpasswd" DEFAULT TABLESPACE bblearn_data TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON bblearn_data QUOTA UNLIMITED ON bblearn_indx;
    GRANT connect, resource to bblearn;
    GRANT alter user TO bblearn;
    GRANT select any table TO bblearn;
    GRANT analyze any TO bblearn;
    GRANT drop any table TO bblearn;
    GRANT query rewrite TO bblearn;
    GRANT alter tablespace TO bblearn;
    GRANT create sequence TO bblearn;

  3. Import the bblearn schema:

    imp system/manager file=bblearn.dmp fromuser=bblearn touser=bblearn commit=Y buffer=2048000

  4. Connect as bblearn and perform the following grants.

    GRANT select on users TO bblearn_stats;
    GRANT select on course_main TO bblearn_stats;
    GRANT select on cartridge TO bblearn_stats;
    GRANT select on course_users TO bblearn_stats;
    GRANT select on system_tracking TO bblearn_stats;
    GRANT select on activity_accumulator TO bblearn_stats;

Troubleshoot

If the error message, ORA-00001: unique constraint (SYS.I_JOB_JOB) violated appears, login as bblearn_admin, bblearn,or bblearn_stats depending on which database encountered the error, and run the following command to resubmit the job.

VARIABLE jobnum1 NUMBER;
BEGIN
DBMS_JOB.SUBMIT(
:jobnum1,
'analyze_my.bbtabs;',
SYSDATE,
'TRUNC(SYSDATE)+26/24'
);
COMMIT;
END;
/

Import and configure content management databases

bblearn_cms main database

  1. Login as system and drop the bblearn_cms user:

    DROP USER bblearn_cms CASCADE;
    ALTER TABLESPACE bblearn_cms_data COALESCE;
    ALTER TABLESPACE bblearn_cms_indx COALESCE;

  2. Login as system and re-create user bblearn_cms, the correct password must replace bbpassword.

    CREATE USER bblearn_cms IDENTIFIED BY "bbpasswd" DEFAULT TABLESPACE bblearn_cms_data TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON bblearn_cms_data QUOTA UNLIMITED ON bblearn_cms_indx;
    GRANT connect, resource to bblearn_cms;
    GRANT alter user TO bblearn_cms;
    GRANT select any table TO bblearn_cms;
    GRANT analyze any TO bblearn_cms;
    GRANT drop any table TO bblearn_cms;
    GRANT query rewrite TO bblearn_cms;
    GRANT alter tablespace TO bblearn_cms;
    GRANT create sequence TO bblearn_cms;

  3. Import the bblearn_cms schema.

    imp system/manager file=bblearn_cms.dmp fromuser=bblearn_cms touser=bblearn_cms commit=Y buffer=2048000

bblearn_cms_doc database

  1. Login as system and drop the bblearn_cms_doc user:

    DROP USER bblearn_cms_doc CASCADE;
    ALTER TABLESPACE bblearn_cms_doc_data COALESCE;
    ALTER TABLESPACE bblearn_cms_doc_indx COALESCE;

  2. Login as system and re-create user bblearn_cms_doc, the correct password must replace bbpassword.

    CREATE USER bblearn_cms_doc IDENTIFIED BY "bbpassword" DEFAULT TABLESPACE bblearn_cms_doc_data TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON bblearn_cms_doc_data QUOTA UNLIMITED ON bblearn_cms_doc_indx;
    GRANT connect, resource to bblearn_cms_doc;
    GRANT alter user TO bblearn_cms_doc;
    GRANT select any table TO bblearn_cms_doc;
    GRANT analyze any TO bblearn_cms_doc;
    GRANT drop any table TO bblearn_cms_doc;
    GRANT query rewrite TO bblearn_cms_doc;
    GRANT alter tablespace TO bblearn_cms_doc;
    GRANT create sequence TO bblearn_cms_doc;

  3. Import the bblearn_cms_doc schema.

    imp system/manager file=bblearn_cms_doc.dmp fromuser=bblearn_cms_doc touser=bblearn_cms_doc commit=Y buffer=2048000

  4. The following will grant two privileges that are required to install Blackboard on Oracle:

    SQL> @$ORACLE_HOME/rdbms/admin/rstrconn.sql
    SQL> commit;
    SQL> exit

If any errors appear during the database import, contact Blackboard Client Support. Provide them with the terminal output along with database version information, operating system information, and environment settings.