Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
bgColor#e6f0ff
titleBGColor#99c2ff
titleOracle PDB containers

For Oracle 12c and above, you should use a '/' instead of ':' before [SID], so that [SID] is treated as a SERVICE name rather than an SID. This is due to Oracle 12c introducing pluggable databases (PDB's).

There is also the option to add the line 'USE_SID_AS_SERVICE_listener=on' to the tnsnames.ora Oracle configuration file in order to treat SID's as service names by default. This is provided by Oracle as a workaround for users who have hard-coded connection strings that are difficult to change by hand, and so should not be necessary for phixflow configuration.

For more information, please see the following Oracle documentation links:

USE_SID_AS_SERVICE_listener

Introduction to the Multitenant Architecture (including an explanation of PDB's)

 


SQL Server:

Code Block
jdbc:sqlserver://hostname\myservice;databaseName=phixflow

...

For more information on how to configure for domain logins, see the PhixFlow ActiveDirectory Configuration userguidethe PhixFlow Active Directory Guide.

Configure log4j.properties

...

Find the line containing the call to window.open and change the 2nd parameter from ‘PhixFlow’ to ‘alternative_name’