Starting and Stopping the Reporting Database
Consider restarting the Reporting Database every 4-8 weeks.
To start the Reporting Database on Windows
1. Locate the scripts to start the Reporting Database:
C:\opt\aptare\utils\
If all components (Portal Server and Reporting Database) are on the same server and you want to start all components including the Reporting Database use:
startallservices.bat
If all components (Portal Server and Reporting Database) are on the same server and you want to only start the Reporting Database use:
startoracle.bat
If the Reporting Database is on a separate server use:
startoracle.bat
2. Verify the following services have started using the Windows Services Control panel:
• Oracle Service SCDB
• OracleSCDBTNSListener
To stop the Reporting Database on Windows
1. Locate the scripts to stop the Reporting Database:
C:\opt\aptare\utils\
If all components (Portal Server and Reporting Database) are on the same server and you want to stop all components including the Reporting Database use:
stopallservices.bat
If all components (Portal Server and Reporting Database) are on the same server and you want to only stop the Reporting Database use:
stoporacle.bat
If the Reporting Database is on a separate server use:
stoporacle.bat
2. Verify the following services have stopped using the Windows Services Control panel:
• Oracle Service SCDB
• OracleSCDBTNSListener
To start the Reporting Database on Linux
Do one of the following
• If all components (Portal Server and Reporting Database) are on the same server and you want to start all components including the Reporting Database, run the following command:
# cd /opt/aptare/bin
./aptare start|restart
• If all components (Portal Server and Reporting Database) are on the same server and you want to only start the Reporting Database, run the following command:
# cd /opt/aptare/bin
./oracle start
• If the Reporting Database is on a separate server, run the following command:
# cd /opt/aptare/bin
./oracle start