AWG Blogs

Thursday, March 10, 2011

After DLP DB install, start database if necessary

Was getting errors when verifying the Symantec Data Loss Prevention database. When I would type the command $ORACLE_HOME/bin/lsnrctl services LISTENER I would get The listener supports no services

This can happen if for some reason the database has not started.

Try starting the database:

$ sqlplus '/ as sysdba'
Then, enter
startup at the SQL prompt.

Once the database has started, verification succeeds!

See http://www.thegeekstuff.com/2009/01/oracle-database-startup-and-shutdown-procedure/

Notes:

If you get "TNS-12541: TNS:no listener" when running the first command above, try doing: $ORACLE_HOME/bin/lsnrctl start :)
After that, you may need to restart the Vontu services. Then you should be able to login to https://vontuIP/ or https://vontuIP:8443

Here's a quick script to restart the services on the Enforce server. Add VontuMonitor.sh if single-tier:
cd /opt/Vontu/Protect/bin

./VontuUpdate.sh stop
./VontuIncidentPersister.sh stop
./VontuManager.sh stop
./VontuMonitorController.sh stop
./VontuNotifier.sh stop
./VontuNotifier.sh start
./VontuManager.sh start
./VontuIncidentPersister.sh start
./VontuUpdate.sh start
./VontuMonitorController.sh start