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';

Oracle DEADLOCKS caused by ActiveMQ

Solution


Edit /usr/local/blackboard/config/internal/sql/discovery/peer_service_db_specific.sql.
Add the highlighted text and save.

## Update the last_seen timestamp for all services provided by this node

update.last.seen=\

UPDATE peer_service

  SET last_seen = sysdate, inactive_ind = 'N'

  WHERE node_id = ${param.node_id}

## Flags services that have not been seen recently

mark.inactive=\

UPDATE peer_service

  SET inactive_ind = 'Y'

  WHERE last_seen < (sysdate - ${timeout_inactive}/86400)

  AND inactive_ind = 'N'

## Removes services that have not been seen recently

delete.stale=\

DELETE FROM peer_service

DELETE BB database users and tablespaces after failed installation

1. Query the list of Blackboard users created in the database.

SELECT username, account_status FROM dba_users;

2. Delete the users

DROP USER BBLEARN CASCADE;

DROP USER BBLEARN_ADMIN CASCADE;

DROP USER BBLEARN_CMS_DOC CASCADE;

DROP USER BBLEARN_CMS CASCADE;

(*) just an example depending on the result for item (1).

3. Delete the tablespaces

DROP TABLESPACE BBLEARN_INDX INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE BBLEARN_ADMIN_DATA INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE BBLEARN_ADMIN_INDX INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE BBLEARN_DATA INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE BBLEARN_CMS_DOC_INDX INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE BBLEARN_CMS_INDX INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE BBLEARN_CMS_DATA INCLUDING CONTENTS AND DATAFILES;

DROP TABLESPACE BBLEARN_CMS_DOC_DATA INCLUDING CONTENTS AND DATAFILES;

(*) Depending on the tablespaces created by the installer.

4. Remove /usr/local/blackboard

Managing QUEUED_TASKS

Delete 'COMPLETED' and 'ERROR' QUEUED_TASKS every SUNDAY at 4.30am

DECLARE

    JobNo dba_jobs.job%TYPE;

BEGIN

  --schedule cleanup of QUEUED_TASKS each Sunday morning at 4:30am:

  DBMS_JOB.SUBMIT(JobNo, 'DELETE FROM queued_tasks WHERE status IN (''C'',''E'') AND end_date < sysdate - 7;',

    trunc(sysdate) + 4/24 + 1/48 + 8 - to_char(sysdate,'D'),

   'trunc(sysdate) + 4/24 + 1/48 + 7');

END;

/

Session count for the last 3 hours

SELECT COUNT(*) FROM bblearn.SESSIONS WHERE TIMESTAMP > SYSDATE - 3/24;


select SESSION_ID  ||'|'||  user_id ||'|'||  to_char(timestamp, 'Dy DD-Mon-YYYY HH24:MI:SS')  from bblearn.sessions where timestamp > sysdate - 3/24;

delete sessions more than 3 hours

exec BBLEARN.sessions_rm(minutes=>180);

How do I tell I have 64-bit Java installed on my Solaris Box

truss -t exec $JAVA_HOME/bin/java -d64 -version

Java Crash Report for JDK 1.6.0_13

Encountered the following error when using JVM Option

bbconfig.jvm.heaps.extra.tomcat=-XX:StackShadowPages=20 -XX:NewSize=300m -XX:MaxNewSize=300m -XX:SurvivorRatio=4 -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:+UseTLAB -XX:ParallelCMSThreads=2 -XX:ParallelGCThreads=2 -XX:+UseCompressedOops -XX:+PrintVMOptions -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -XX:+PrintGCTaskTimeStamps -XX:+PrintCommandLineFlags -XX:+PrintGCApplicationStoppedTime -XX:+PrintGCApplicationConcurrentTime -XX:+DisableExplicitGC

running JDK 1.6.0_13

INFO   | jvm 5    | 2012/04/03 17:33:26 | -XX:+DisableExplicitGC -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/usr/local/blackboard/logs/tomcat -XX:+ManagementServer -XX:MaxHeapSize=4041211904 -XX:MaxNewSize=314572800 -XX:MaxPermSize=268435456 -XX:NewSize=314572800 -XX:ParallelCMSThreads=2 -XX:ParallelGCThreads=2 -XX:+PrintCommandLineFlags -XX:+PrintGC -XX:+PrintGCApplicationConcurrentTime -XX:+PrintGCApplicationStoppedTime -XX:+PrintGCDateStamps -XX:+PrintGCDetails -XX:+PrintGCTaskTimeStamps -XX:+PrintGCTimeStamps -XX:+PrintVMOptions -XX:StackShadowPages=5 -XX:SurvivorRatio=4 -XX:ThreadStackSize=512 -XX:+TraceClassUnloading -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:+UseTLAB
INFO   | jvm 5    | 2012/04/03 17:33:26 | #
INFO   | jvm 5    | 2012/04/03 17:33:26 | # An unexpected error has been detected by Java Runtime Environment:
INFO   | jvm 5    | 2012/04/03 17:33:26 | #
INFO   | jvm 5    | 2012/04/03 17:33:26 | #  Internal Error (os_solaris.cpp:4677), pid=6869, tid=2
INFO   | jvm 5    | 2012/04/03 17:33:26 | #  Error: guarantee((Solaris::min_stack_allowed >= (StackYellowPages+StackRedPages+StackShadowPages+BytesPerWord +1) * page_size),"need to increase Solaris::min_stack_allowed on this platform")
INFO   | jvm 5    | 2012/04/03 17:33:26 | #
INFO   | jvm 5    | 2012/04/03 17:33:26 | # Java VM: Java HotSpot(TM) 64-Bit Server VM (11.3-b02 mixed mode solaris-sparc)
INFO   | jvm 5    | 2012/04/03 17:33:26 | # An error report file with more information is saved as:
INFO   | jvm 5    | 2012/04/03 17:33:26 | # /usr/local/blackboard/apps/service-wrapper/bin/hs_err_pid6869.log
INFO   | jvm 5    | 2012/04/03 17:33:26 | #
INFO   | jvm 5    | 2012/04/03 17:33:26 | # If you would like to submit a bug report, please visit:
INFO   | jvm 5    | 2012/04/03 17:33:26 | #   http://java.sun.com/webapps/bugreport/crash.jsp


Solution

Upgrade to JDK 1.6.0_31
In addition, set the stacksize to 512k.
i.e. bbconfig.max.stacksize.tomcat=512k

+UseCompressedOops is supported from JDK 1.6.0_14 onwards.