XBio:D Database Server Management

From xBio:D Wiki
Revision as of 13:50, 7 September 2012 by Jcora (talk | contribs) (Protected "Startup OSUC Database" ([edit=osuc_user] (indefinite) [move=osuc_user] (indefinite) [read=osuc_user] (indefinite)))
Jump to navigation Jump to search


Startup OSUC Database

This section is present to provide a step-by-step manner to restarting the OSUC database. The assumption is that the user is already logged into the OSUC server.

  1. Switch to superuser for the oracle account: $su - oracle
  2. Navigate to the Oracle home binary directory: $cd $ORACLE_HOME/bin
  3. Log into Oracle SQL Plus: $sqlplus /nolog
  4. Connect as a DBA to the database: SQL>connect / as sysdba
  5. Startup the database: SQL>startup pfile='/u01/app/oracle/admin/oracle/pfile/init.ora.852008113657'
  6. Leave Oracle SQL Plus: SQL>quit
  7. Start the database listener: $lsnrctl start
  8. Navigate to the Oracle application server network binary directory: $cd $ORACLE_BASE/oraHTTP/opmn/bin
  9. Start up networked Oracle application server: $opmnctl startall
Retrieved from "https://xbiod.osu.edu/index.php?title=XBio:D_Database_Server_Management&oldid=334"