Starting an Oracle Database and listener

 Requirement

You're not a DBA. 

You haven't got a DBA. You've been given an IP address and unix user and asked to get Apex going.

The database and listeners are pre-configured but all down as the box has been restarted.

Guide

1. Is Oracle installed?

Look for a file /etc/oratab.
Its content should reveal all ORACLE_HOMEs present at your box.

 

 2. Start the database

Your DBA will probably have this all scripted, but in the absence of a pro, do this manually

sqlplus / as sysdba

startup


 

3. Start the listener for Apex

If you went to Apex now, your browser would time out. 

In Unix type

lsnrctl start
 

4. Navigate to Apex

http://????.????.????.????:8085/apex/

Acknowledgement

https://www.unix.com/unix-for-dummies-questions-and-answers/61102-how-know-if-oracle-installed.html
https://docs.oracle.com/database/121/ADMQS/GUID-AFAED9DB-56F5-4F49-B37A-54739790716A.htm#ADMQS044 
https://www.ibm.com/docs/en/opw/8.2.0?topic=ssds-starting-stopping-oracle-database-server-in-linux-environments-1
 
 

Comments