Starting and stopping the reporting database
Consider restarting the Reporting Database every 4-8 weeks.
To start the Reporting Database on Windows
- 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 allcomponents 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
- Verify the following services have started using the Windows Services Control panel:
Oracle Service SCDB
OracleSCDBTNSListener
To stop the Reporting Database on Windows
- 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 allcomponents 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
- 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