2. Start the SQL*Net V2 or Net8 TNS listener by running the following on the
Oracle Server system:
UNIX:
ORACLE_HOME/bin/lsnrctl start
Windows:
ORACLE_HOME\bin\lsnrctl start
Checking the connection
To check the connection to the Oracle instance from the application system:
1. Log in to the application system as the Oracle OS user.
2. Export/set the ORACLE_HOME and ORACLE_SID variables.
3. Start sqlplus.
4. Connect to the Oracle target database as the Oracle database user, first with
the sysdba role and then with the sysoper role.
Example
For the following configuration:
Oracle instance: PRO ORACLE_HOME: /app/oracle816/product
run:
id
uid=102(oraprod) gid=101(dba)
export ORACLE_SID=PRO
export ORACLE_HOME=/app/oracle816/product
export SHLIB_PATH=/app/oracle816/product/lib:/opt/omni/lbin
sqlplus /nolog
SQLPLUS> connect system/manager@PRO as sysdba;
Connected.
SQLPLUS> connect system/manager@PRO as sysoper;
Connected.
Authentication password file
Enable the use of the authentication password file for the database administrator:
1. Shut down the Oracle target database on the application system.
2. In the initORACLE_SID.ora file, specify:
remote_login_passwordfile = exclusive
Data Protector SAP R/3 ZDB integration178
To Next Page
Loading...
Need help?
General