Difference between revisions of "XBio:D Database Server Management"

From xBio:D Wiki
Jump to navigation Jump to search
m (Protected "Startup OSUC Database" ([edit=osuc_user] (indefinite) [move=osuc_user] (indefinite) [read=osuc_user] (indefinite)))
Line 4: Line 4:
 
'''Startup OSUC Database'''
 
'''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.
+
This section is present to provide a step-by-step manner to restarting the OSUC database. Although the database and all of the web services should automatically begin on startup, these instructions will be valuable if an error does occur. The assumption is that the user is already logged into the OSUC server.
  
−
# Switch to superuser for the oracle account: $'''su - oracle'''
+
# Startup the database: $'''dbstart $ORACLE_HOME'''
−
# Navigate to the Oracle home binary directory: $'''cd $ORACLE_HOME/bin'''
 
−
# Log into Oracle SQL Plus: $'''sqlplus /nolog'''
 
−
# Connect as a DBA to the database: SQL>'''connect / as sysdba'''
 
−
# Startup the database: SQL>'''<nowiki>startup pfile='/u01/app/oracle/admin/oracle/pfile/init.ora.852008113657'</nowiki>'''
 
−
# Leave Oracle SQL Plus:  SQL>'''quit'''
 
 
# Start the database listener: $'''lsnrctl start'''
 
# Start the database listener: $'''lsnrctl start'''
−
# Navigate to the Oracle application server network binary directory: $'''cd $ORACLE_BASE/oraHTTP/opmn/bin'''
+
# Start the database Enterprise Manager: $'''emctl start dbconsole'''
−
# Start up networked Oracle application server: $'''opmnctl startall'''
+
# Start up Oracle middleware applications: $'''$ORACLE_INSTANCE/bin/opmnctl startall'''
  
 
[[Category:OSUC Private]]
 
[[Category:OSUC Private]]

Revision as of 21:05, 13 December 2012


Startup OSUC Database

This section is present to provide a step-by-step manner to restarting the OSUC database. Although the database and all of the web services should automatically begin on startup, these instructions will be valuable if an error does occur. The assumption is that the user is already logged into the OSUC server.

  1. Startup the database: $dbstart $ORACLE_HOME
  2. Start the database listener: $lsnrctl start
  3. Start the database Enterprise Manager: $emctl start dbconsole
  4. Start up Oracle middleware applications: $$ORACLE_INSTANCE/bin/opmnctl startall
Retrieved from "https://xbiod.osu.edu/index.php?title=XBio:D_Database_Server_Management&oldid=353"