Standby Database: Remote Database Connect Requirements (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Standby Database: Remote Database Connect Requirements

Use

Certain conditions are required for the connection to a remote host with the Oracle Standby Database. You must be able to manage the primary Oracle instance from the standby instance, that is, you must be able to start up and shut down this instance from the standby instance. You must be able to perform these operations from a local SQLPLUS session.

Prerequisites

BRARCHIVE and BRBACKUP, which are started on the standby database server, connect remotely to the primary database. Therefore, make sure that the instance string in the primary_db parameter is defined to Oracle SQL*Net in the tsnnames.ora file.

Test the connection in SQLPLUS with the following command:

connect system/<password>@<value_of_primary_db>

Procedure

Create an Oracle password file:

orapwd file=<ORACLE_HOME>/dbs/orapw<DBSID> password=<sys_password> entries=100

Set the remote_login_passwordfile parameter in the init<DBSID>.ora as follows:

remote_login_passwordfile = exclusive

If the parameter is entered only after an instance has been started up, you must restart it, so that the parameter becomes effective.

Start as user SYS and execute the Oracle command:

grant sysoper to system;

This grants the system user SYSOPER authorization on the primary database instance.

If necessary, change the password for the system user:

alter user system identified by <password>;

Note

Starting with SAP Release 4.5B, it is no longer necessary to give the SYSTEM user SYSOPER authority in the Oracle password file of the production database.