Visualizer Connecting to Only a Single Server in an Oracle RAC (Doc ID 1963122.1)

Last updated on JANUARY 26, 2015

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.3.2.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to launch Visualizer against an Oracle Database configured for a Real Application Cluster (RAC)

ACTUAL BEHAVIOR
---------------------------------
Visualizer only connects to a single server in the RAC, and if the host in the RAC goes down it will not reconnect to the other hosts and continually fail with "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor" in the Visualizer.log (found in the user's %temp% directory) until the server is brought back online.

EXPECTED BEHAVIOR
---------------------------------
Visualizer should be able to connect to an alternate server in the Oracle RAC if one of the hosts go down.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms