1. Client Installation Guide
  2. Oracle Database Client Postinstallation Tasks
  3. Recommended Postinstallation Tasks

Recommended Postinstallation Tasks

Oracle recommends that you perform the tasks in the following sections after completing an installation:

Parent topic: Oracle Database Client Postinstallation Tasks

Configuring Instant Client Light

To configure Instant Client Light, you must make it the default instead of Instant Client.

To configure Instant Client Light:
  1. In the ORACLE_BASE\ORACLE_CLIENT_HOME directory, either rename or delete the oraociei12.dll file.

    The oraociei12.dll file is the main binary for Instant Client.

  2. From the ORACLE_BASE\ORACLE_CLIENT_HOME\install\instantclient\light directory, copy the oraociicus12.dll file to the ORACLE_BASE\ORACLE_CLIENT_HOME directory. .

    The oraociicus12.dll file is the binary for Instant Client Light.

  3. Ensure that the PATH environment variable points to the ORACLE_BASE\ORACLE_CLIENT_HOME directory.

    Note:

    If the Instant Client PATH is not set, then the applications attempt to load the regular Instant Client libraries first. If the applications cannot find these, then they attempt to load the Instant Client Light library next.

Parent topic: Recommended Postinstallation Tasks

Connecting Oracle Database Client to an Oracle Database

After you run Oracle Universal Installer to install Oracle Database Client, you must use Oracle Net Configuration Assistant (NETCA) to configure Oracle Database Client to connect to an Oracle database.

At the end of the installation, Oracle Universal Installer prompts you to configure the database connection. If you bypassed that option, or if you need to change the database connection later on, use the following procedure if you installed the Administrator, Runtime, or Custom installation types.
To connect Oracle Database Client to an Oracle Database:
  1. From the Start menu, choose Oracle - HOME_NAME, then Configuration and Migration Tools, then Oracle Net Configuration Assistant.
  2. In the Welcome window, select Local Net Service Name configuration and click Next.
  3. In the Net Service Name Configuration window, select Add and click Next.
  4. In the Service Name window, enter the name of the Oracle database to which you want to connect and click Next.
  5. In the Select Protocols window, select the protocol you want and click Next.
  6. In the Protocol window, depending on the protocol you selected, enter the appropriate information and click Next.
  7. In the Net Test window, select whether you want to test the connection, and click Next.
  8. In the Net Service Name window, enter a name for the net service and click Next.
  9. Answer the remaining prompts, which allow you to configure another net service name, and then click Finish to complete the configuration.

    Oracle Net Configuration Assistant creates the tnsnames.ora file in the following location:

    ORACLE_HOME\network\admin\tnsnames.ora

Parent topic: Recommended Postinstallation Tasks

Connecting Instant Client or Instant Client Light to an Oracle Database

Before you can connect Instant Client or Instant Client Light to an Oracle Database, ensure that the PATH environment variable specifies the directory that contains the Instant Client libraries.

Parent topic: Recommended Postinstallation Tasks

Specifying a Connection by Using the Easy Connect Naming Method

You can specify a connection address to an Oracle Database directly from a client application, without having to configure a tnsnames setting for the Instant Client.

This method is convenient in that you do not have to create and manage a tnsnames.ora file. However, your application users must specify the host name and port number when they want to log in to your application.

For example, suppose you are running SQL*Plus on the client computer and want to connect to the sales_us database, which is located on a server whose host name is shobeen and port number is 1521. If you launch SQL*Plus from the command line, then log in as follows:

sqlplus system/admin@//shobeen:1521/sales_us

Similarly, in your application code, you can use Oracle Call Interface net naming methods to create the Instant Client-to-Oracle Database connection. For example, the following formats in the OCIServerAttach() call specify the connection information:

  • Specify a SQL connect URL string using the following format:

    //host[:port][/service_name]

    For example:

    //shobeen:1521/sales_us

  • Alternatively, specify the SQL connect information as an Oracle Net keyword-value pair. For example:

    “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=shobeen) (PORT=1521))

    (CONNECT_DATA=(SERVICE_NAME=sales_us)))”

Parent topic: Connecting Instant Client or Instant Client Light to an Oracle Database

Specifying a Connection by Configuring a tnsnames.ora File

By default, when you install an Instant Client, Oracle Universal Installer does not include a sample tnsnames.ora file nor the Oracle Net Configuration Assistant utility normally used to create it.

However, if you want to shield users from having to specify actual host names and port numbers, you may want to consider using a tnsnames.ora file to set the Instant Client-to-Oracle Database connection.
You can create the tnsnames.ora file manually by copying and modifying a version of this file from another Oracle installation, or you can use Oracle Net Configuration Assistant to create and manage it for you.
To install Oracle Net Configuration Assistant:
  1. Run Oracle Universal Installer.
  2. Select the Custom installation type.
  3. In the Available Product Components list, select Oracle Network Utilities and click Next.
  4. In the Summary window, click Install, then click Exit and Yes to exit Oracle Universal Installer.

    Then, on each client computer, configure either of the following settings:

    • Set the TNS_ADMIN environment variable to specify the location of the tnsnames.ora file and specify a service name from that file.

    • Place the tnsnames.ora file in the ORACLE_HOME\network\admin directory, and ensure that the ORACLE_HOME environment has been set to this Oracle home.

Related Topics

Parent topic: Connecting Instant Client or Instant Client Light to an Oracle Database

Specifying a Connection by Using an Empty Connect String and the LOCAL Variable

Describes how to specify a connection to an empty connect string and set the LOCAL environment variable.

You can set the connect string to an empty connect string (""), and then set the LOCAL environment variable to one of the following values:

  • A direct address

  • Oracle Net keyword-value pair

  • A tnsnames.ora entry and TNS_ADMIN is set to the location of tnsnames.ora

  • A tnsnames.ora entry and the following:

    • tnsnames.ora file located in ORACLE_HOME/network/admin

    • The ORACLE_HOME environment variable set to this Oracle home

      This method allows your applications to specify internally a connection string if the application code uses an empty connection string. The benefit of an empty connect string is that the application does not need to specify the tnsnames.ora entry. Instead, when a user invokes the application, the location of the database is determined by a script or the environment, depending on where you have set the LOCAL environment variable. The disadvantage of using empty strings is that you must configure this additional information for your application to connect to the database.

Related Topics

Parent topic: Connecting Instant Client or Instant Client Light to an Oracle Database

Setting Up User Accounts

Learn how to setup user accounts.

Parent topic: Recommended Postinstallation Tasks

Changing the Oracle Home User Password

Oracle Home User Control is a command-line utility that allows an administrator to update the password for an Oracle Home User.

This tool updates the password for Windows services in the Oracle home. The input password must match the password for the Windows User Account used as the Oracle Home User. So, first use Windows operating system tools to change the Windows password and then use this tool to update the Windows services in the Oracle home to use the same password.

Note:

You must have Administrator privileges to run this Oracle Home User Control utility.

Syntax Overview:

The following is the command syntax:

orahomeuserctl list | updpwd [-user username] [-host hostname1, hostname2, . . .] [-log logfilename]

where:

  • orahomeuserctl is used to display the Oracle Home User name associated with the current Oracle home or to update the Oracle Home User password.

  • list displays the Oracle Home User name associated with the current Oracle home.

  • updpwd prompts for the new password and updates the password for the named Oracle Service User. The following are the options for updpwd:

    • -user username

      This option determines the Oracle Home User name. If this option is not present, then the user name associated with the current Oracle home is used. If the named user, be it the username or user of the current Oracle home, is an MSA or Windows Built-in account, then an error message is displayed and the command is terminated.

    • -host hostname1, hostname2,. . .

      When this option is present, the utility updates the passwords for all services belonging to the named Oracle Home User on the specified hosts. Otherwise, the Oracle Home User Control utility updates the passwords for all the services belonging to the named Oracle Home User on a specified host with single instance installation, or updates the passwords for all services belonging to the named Oracle Home User on all the specified hosts.

      When the update completes, the utility displays the number of successful updates and any services that failed to update with the new password.

    • -log logfilename

      This option adds the password update operation results to a log file for every service name receiving the new password. By default, the log files are located in the ORACLE_HOME\log directory. If logfilename specifies only a file name, then the log is stored in the named file in the default directory. However, if the logfilename contains a path, then that path is used without modification.

Parent topic: Recommended Postinstallation Tasks

Creating the OraMTS Service for Microsoft Transaction Server

Oracle Services for Microsoft Transaction Server (OraMTS) permit Oracle databases to be used as resource managers in Microsoft application coordinated transactions.

OraMTS acts as a proxy for the Oracle database to the Microsoft Distributed Transaction Coordinator (MSDTC). As a result, OraMTS provides client-side connection pooling and allows client components that leverage Oracle to participate in promotable and distributed transactions. In addition, OraMTS can operate with Oracle databases running on any operating system, given that the services themselves are run on Windows.

On releases before Oracle Database 12c, the OraMTS service was created as part of a software-only installation. Now, you must use a configuration tool to create this service.

To create the OraMTS service after performing a software-only installation for Oracle Database, perform the following steps:

  1. Open a command window.
  2. Change directories to ORACLE_HOME\bin.
  3. Run the OraMTSCtl utility to create the OraMTS Service:

Parent topic: Recommended Postinstallation Tasks

Creating the Scheduler Agent

The Oracle Scheduler Execution Agent permits Oracle Database clients to run Scheduler jobs at the request of an Oracle instance which can be located on a remote host.

This allows for centralized control over several hosts using Oracle Scheduler and can perform jobs at the operating system level and jobs that run on another Oracle Database.

The Oracle Scheduler Execution Agent is installed with the Oracle Database Client software.

The Oracle Scheduler Execution Agent permits Oracle Database clients to run Scheduler jobs at the request of an Oracle instance which can be located on a remote host. This allows for centralized control over several hosts using Oracle Scheduler and can perform jobs at the operating system level and jobs that run on another Oracle Database.
To create the Scheduler Agent service after performing a software-only installation for Oracle Database Client, perform the following steps:
  1. Open a command window.
  2. Change directories to ORACLE_HOME\bin.
  3. Run the executable utility, schagent to create the Scheduler Agent service:

    C:\ORACLE_HOME\bin> schagent.exe -new

Parent topic: Recommended Postinstallation Tasks