Verifying Oracle connection

Owned by Copy Space for Confluence
Jan 22, 2017
1 min read

To verify a valid Oracle connection and to verify which Oracle environment Dbvisit Replicate uses when the processes are running, the following command can be used to list the Oracle settings. This includes the ORACLE_HOME, TNS_ADMIN, NLS_LANG, PATH and LD_LIBRARY_PATH.

dbvrep> ENGINE TEST_CONNECTION_ORACLE SYSTEM/<system_password>@<tns_connect_string>

The values in <> are user supplied. Do not include the <>

The output is as follows:

dbvrep> ENGINE TEST_CONNECTION_ORACLE SYSTEM/*******@RPRD
Connection OK (now try to execute alter session). Environment settings: 
_FORCE_LD_PATH_ALL="NO" 
_FORCE_LD_PATH_SYSDBA="NO" 
TNS_ADMIN="/ORACLE/tns_admin" 
ORACLE_HOME="/ORACLE/product/10.2.0" 
ORACLE_SID="RPRD" 
NLS_LANG="AMERICAN_AMERICA.WE8ISO8859P15" 
ORA_NLS=<not defined> 
ORA_NLS32=<not defined> 
ORA_NLS33=<not defined> 
ORA_NLS10=<not defined> 
LD_LIBRARY_PATH="/var/tmp/par-6f7261636c65/cache-f88e62f581c7a016b552f2cd9695df1fd10688bb" 
PATH="/var/tmp/par-6f7261636c65/cache-f88e62f581c7a016b552f2cd9695df1fd10688bb:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/ipf/bin:/opt/gvsd/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/sas/bin:/opt/graphics/common/bin:/opt/atok/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/sec_mgmt/bastille/bin:/opt/caliper/bin:/opt/drd/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/resmon/bin:/opt/firefox:/opt/gnome/bin:/opt/propplus/bin:/usr/contrib/kwdb/bin:/opt/mozilla:/opt/perl_32/bin:/opt/perl_64/bin:/opt/prm/bin:/opt/sfm/bin:/opt/swm/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/sentinel/bin:/opt/swa/bin:/opt/hpsmh/bin:/opt/thunderbird:/opt/langtools/bin:/opt/gwlm/bin:/opt/ignite/bin:/opt/cfg2html:/opt/networker/bin:/opt/perf/bin:/usr/local/bin:/usr/sbin:.:/ORACLE/product/10.2.0/bin" 
TWO_TASK=<not defined> 
ORA_TZFILE=<not defined> 
ORACLE_BASE="/oracle" 
ORACLE_PATH=".:/oracle/admin/RPRD/scripts:/oracle/admin/RPRD/backup/rman/scripts/refresh:/oracle/product/10.2.0/rdbms/admin" 
ORACLE_TRACE=<not defined> 
ORAENV_ASK=<not defined> 
SQLPATH=<not defined>

The /var/tmp/par-xxxx directory is the cache directory of Dbvisit Replicate where the bundled Oracle Client will be unpacked.

On Linux and other systems this directory maybe /usr/tmp/par-xxxx or /tmp/par-xxxx