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