5 Oracle Database Client Postinstallation Tasks

Complete configuration task after you install Oracle Database Client.

You must complete some configuration tasks after Oracle Database Client is installed. In addition, Oracle recommends that you complete additional tasks immediately after installation. You must also complete product-specific configuration tasks before you use those products.

• Required Postinstallation Tasks
  Download and apply required patches for your software release after completing your initial installation.
• Recommended Postinstallation Tasks
  Oracle recommends that you perform the tasks in the following sections after completing an installation:
• Required Product-Specific Postinstallation Task – Configuring Oracle Net Services
  You can configure Oracle Database Client to communicate with Oracle Net Services by adding the appropriate entries to the tnsnames.ora and listener.ora files.
• Postinstallation Tasks for SQL Developer
  Review the postinstallation tasks for SQL Developer.
• 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.
• 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.
• Using Oracle Net Configuration Assistant
  Learn how to use Oracle Net Configuration Assistant.

Using Oracle Net Configuration Assistant

Learn how to use Oracle Net Configuration Assistant.

During an Oracle Database Client installation, the installer performs a typical Oracle Net configuration.

If you need to change the typical configuration, perform the following to configure the listener and naming methods using Oracle Net Configuration Assistant:

1. In the Welcome screen, click Next.

   Note:

   If you do not select Oracle Home User for installation or Oracle Net Listener as a component, then you can select Perform typical configuration for default network configuration.
2. In the Listener Configuration, Listener Name screen, enter a Listener name or accept the default value.

   The Oracle Home User Password field appears if you choose to install Oracle home using Oracle Home User. You must provide a password to run Windows services for the listener under the Oracle Home User account. Click Next.

3. In the Listener Configuration, Select Protocol screen, select one or more protocols from the Available Protocols list, and move it to the Selected Protocols list. Click Next.
4. In the Listener Configuration, TCP/IP Protocol screen, select the standard port number, or enter a different port number. Click Next.
5. In the Listener Configuration, More Listeners? screen, select No if you do not want to configure an additional listener, and click Next.
6. The listener configuration is now complete, click Next to proceed.

   Note:

   If you have more than one listener, then you can select and start a listener from the list provided in the Listener Configuration, Select Listener screen.
7. In the Naming Methods Configuration screen, select Yes to configure naming methods. Click Next.
8. In the Naming Methods Configuration, Select Naming Methods screen, select the naming method you want from the Available Naming Methods list, and move it to the Selected Naming Methods list. Click Next.

   Typically, Local Naming is sufficient.

9. In the Net Service Name Configuration, Service Name screen, enter Service Name, and click Next.
10. In the Net Service Name Configuration, Select Protocols screen, select the protocol for the database you want to access, and click Next.
11. In the Net Service Name Configuration, TCP/IP Protocol screen, enter the Host name of the computer where the Oracle database is installed. Use the standard port number, or specify a different port number, and click Next.
12. In the Net Service Name Configuration, Test screen, click Yes, perform a test to test the database connection. Click Next.
13. In the Net Service Name Configuration, Connecting screen, click Next.

    In most cases, the test fails only because the default user name and password Oracle Universal Installer supplies in the dialog box do not match the user name and password for the target database. Click Change Login, reenter the user name and password, and then click OK.

14. In the Net Service Name Configuration, Net Service Name screen, enter the name of the Net Service Name, and click Next.
15. Answer the remaining prompts to complete the configuration.
16. In the Finish screen, click Close, to exit from Oracle Universal Installer.

    You can also run Oracle Net Configuration Assistant after the installation in standalone mode to configure the listener, naming methods, net service names, and directory server usage.

    To start Oracle Net Configuration Assistant in standalone mode, select Programs from the Start menu, and then select Oracle - HOME_NAME. Next, select Configuration and Migration Tools, and then Oracle Net Configuration Assistant.

    See Also:

    Oracle Database Net Services Administrator's Guide