Prepare for a Report Manager Upgrade

2 Prepare for a Report Manager Upgrade

Use this task if you are upgrading Oracle® Communications Report Manager from a previous version. The BI Publisher database, and OCSDMDW database and its listeners (LISTENER and LISTENER2) need to be running and properly connected when you use the Oracle Communications Session Delivery Manager setup installation application.

If you have a software version of Oracle Communications Session Delivery Manager that is installed on your system that is older than SDM Release 7.5M3, you must upgrade to SDM Release 7.5M3 before you can install this SDM release.
From your Linux system, run the following commands to check if the BI Publisher database, Oracle database, and the listeners are running:
- Verify that the BI Publisher database is running:
```
ps -ef|grep <my-bi-publiser-db-name>
```
- Verify that the ocsdmdw databases are running:
```
ps -ef|grep ocsdmdw
```
- Verify that the listeners (LISTENER and LISTENER2) are running:
```
ps –ef | grep lsnr
```
Use the following options to start the BI Publisher database, Oracle database, or the listeners if OCSDMDW and BI Publisher is down:

Note:
Ensure that the Oracle home path (ORACLE_HOME environment variable) is specified to the correct directory path for each option.
- Start the BI Publisher database:
```
export ORACLE_SID=AcmeBIPublis
cd $ORACLE_HOME/bin
./sqlplus / as sysdba
SQL> startup;
```
- Start the ocsdmdw database:
```
export ORACLE_SID=ocsdmdw
cd $ORACLE_HOME/bin
./sqlplus / as sysdba
SQL> startup;
```
- Start the listeners (LISTENER and LISTENER2):
```
cd $ORACLE_HOME/bin
./lsnrctl start
./lsnrctl start LISTENER2
```
  Note:
  You must wait a minute for the listener process to start listening to their respective database services.

Use the following commands to check the status of the listeners (LISTENER and LISTENER2):

./lsnrctl status LISTENER
./lsnrctl status LISTENER2

For example, the following output displays:

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-AUG-2016 16:32:38

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nms-vm14)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER2
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                16-AUG-2016 14:52:46
Uptime                    2 days 1 hr. 39 min. 52 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /app/oracle/diag/tnslsnr/nms-vm14/listener2/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nms-vm14)(PORT=1522)))
Services Summary...
Service "ocsdmdw" has 1 instance(s).
  Instance "ocsdmdw", status READY, has 1 handler(s) for this service...
Service "ocsdmdwXDB" has 1 instance(s).
  Instance "ocsdmdw", status READY, has 1 handler(s) for this service...
The command completed successfully