

When you specify an Oracle Home for a particular Spotlight connection, the connection-based Oracle Home overrides any default values.You cannot change this value while an active Spotlight connection is already using an Oracle Home.For example, when using Spotlight to diagnose an Oracle 11g connection, use an Oracle Home that contains a sufficiently recent version of the Oracle client. Select a location where Oracle client software is installed.Ĭhoose a home that contains a version of the Oracle client that is compatible with the Oracle server.

Note: ( Oracle 12c) As per Oracle guidelines, the Spotlight Oracle user needs to be of the form c# when connecting to an Oracle 12c Container database.Įnter the Spotlight Oracle user password. Tip: If you enter a Username that does not exist, Spotlight will prompt you when you complete this dialog to create a new Spotlight user. You can then edit the Connection name field if required.Įnter the Spotlight Oracle user name. Note: When selected, the Connection name field resets to this value. If using Oracle names directory services (LDAP or Oracle OID), then type the name of the database into this field.Įnter the connection details of the database in the following format: HOST:PORT/SERVICE_NAME. Spotlight populates the Connection String field with all entries from the TNS Names file, if configured, and you can select a database from this drop-down list. This field can be entered in one of the following ways: TNSNAMES.ORA entry Select the name of the database that you wish to connect to. Tip: Fill in the Connection String first. This is the display name for the connection in Spotlight.

Information Archiving & Storage Management.Hybrid Active Directory Security and Governance.Starling Identity Analytics & Risk Intelligence.One Identity Safeguard for Privileged Passwords.
