Oracle: DB Connectivity Test
Command for testing DB connectivity between XI system and a remote DB. [XI server]:sidadm > tnsping '(ADDRESS=(PROTOCOL=tcp)(HOST=[DB server])(PORT=[Listener Port on DB server]))' TNS Ping Utility for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 07-DEC-2008 07:17:25 Copyright (c) 1997, 2006, Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=tcp)(HOST=[DB server].[server domain])(PORT=[Listener Port on DB server])) OK (0 msec) If telnet is allowed, you can use this command: [XI server]:sidadm> telnet [DB server] [Listener Port] Trying... Connected to [DB server]. Escape character is '^]'. You can get the DB server and Port details from CC