You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Every 6 months the password needs updating - the account is SpBureau. This account and its password are used by the Speakers Bureau web app, with the password stored in the Oracle database.


  1. change the password, account SpBureau via https://crowd.slac.stanford.edu/crowd/console/user/viewchangepassword.action
  2. Update the password in Oracle:

ssh glast@fermilnx-v14
glast@fermilnx-v14 $ pwd
/afs/slac.stanford.edu/u/gl/glast
glast@fermilnx-v14 $ source oracle/bin/setup-11g-j7.csh glast@fermilnx-v14 $ sqlpl
sqlplus sqlplus32 sqlplus32O sqlplusO
glast@fermilnx-v14 $ sqlplus /@glastgenprod

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Jan 7 17:18:33 2022

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

SQL> update application_variable set variable_value = 'NEW_PASSWORD_HERE' where variable_name = 'spBureauConfluencePasswd’;

SQL> select * from application_variable where variable_name='spBureauConfluencePasswd';

3. Bounce the SpBureau web app here: https://glast-ground.slac.stanford.edu/ServerMonitoring/exp/Fermi/applications.jsp

  • No labels