Connect to Session Manager on Oracle

If you are using an Oracle database, make sure the Oracle Client software is installed on each machine that will be running Session Manager. If the client machine uses SDE Direct Connect, then the Oracle Client software is probably already installed. However in most cases, Oracle Client will need to be installed.

Oracle requires that a Net Service Name be defined in order to identify a database server on your network. Once a Net Service Name is defined, the Oracle provider can locate the database server. Use Oracle’s Net Configuration Assistant to define a Net Service Name for your database server.

When the Oracle Net Configuration Assistant starts, choose the Local Net Service Name configuration option.

A wizard will take you through the process of defining a Net Service Name, in which you will specify the name of the new Net Service Name (you’ll use this name in the login dialog), the server’s network host name, its database service name, and the port on which the database service is running. See your DBA for this specific information.

Once the Net Service Name is defined, you will be able to use the Oracle OLEDB Provider to connect to the Session Manager database.

Using the Oracle OLEDB Provider

On the connection dialog, select the Oracle OLEDB Provider to be your DBMS Provider. In the Datasource Name field, enter the name of the Net Service Name that you created with the Net Configuration Assistant.