Starting an Oracle Database and EM console (10g)

login/su as the user who installed the oracle software (i.e. oracle)
wins: [bash]set ORACLE_SID=sid_nameĀ  #the name SID given when creating database[/bash]
linx: [bash]export ORACLE_SID=sid_name
sqlplus /nolog #just log onto the sqlplus console
connect user/passw as sysdba #log-in as a sysdba with user | default: system/manager
#output: Connected to an idle instance. (within SQL console)
startup #to startup the DB
exit #to commit, disconnect and log-off from db-console
lsnrctl status #to show the status of the listener ( may need ./lsnrctl)
lsnrctl start #to start the listener, based on the SID set above
#output: The command completed successfully
emctl start dbconsole #to start the Oracle Enterprise Manager console (web)
#output: ….started.[/bash]

Notes:

  • listener.ora //the file that has the connection info for DBs
    path: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
    (or wherever the oracle DB product was installed)

Problems initializing:

  • Shutdown and restart both database(sqlplus) and listener(linx shell)
  • Try deleting and re-creating the database again (if this is a newly created db with no data, else BACK-IT-UP first!!!)