Planning › Installation Planning › Configure Oracle › Configure the Net Service Name for CA MDB

Configure the Net Service Name for CA MDB

The Net Service Name is a simple name for the Oracle database service that maps to the database network address and database service name. This service enables the client server to connect to the Oracle database.

Before you begin the CA APM installation, configure the Oracle Net Service Name on each CA APM server where a component will be installed, including the Central Configuration Controller (CCC), the web servers, and the application servers. Consider the following information when configuring the Oracle Net Service Name:

• All CA APM servers must have the same Net Service Name, which you specify for the database component during the CA APM installation.
• The CA Business Intelligence server Net Service Name is independent of CA APM and can be the same as, or different from, the CA APM Net Service Name.

Note: You must have Oracle Client Tools installed on all servers where the CA APM components will be installed.

To configure the Net Service Name

1. Gather the following information from your Oracle database administrator:
   • The Oracle database Service Name, which is the logical representation of the Oracle database. The Service Name is typically the global database name or the database server SID.
   • The host name of the Oracle database server where the CA MDB for CA APM resides.
   • The TCP/IP address of the Oracle database server where the CA MDB for CA APM resides. If you have access to Oracle, you can log in to the Oracle server and use the ipconfig command to obtain the TCP/IP Address.

     Note: To determine whether the host name or the TCP/IP address resolves to the Oracle database server, use the ping command on the database server. If CA APM can resolve by name, use the host name of the server. If you are unable to resolve by name, enter the TCP/IP address to configure the Net Service Name, in the following steps.

   • The port number of the Oracle database server where the CA MDB for CA APM resides. The default is 1521.
   • The username and password for a valid Oracle DBMS user account.
2. Click Start, Programs, Oracle, Configuration and Migration Tools, Net Configuration Assistant.

   The Oracle Net Configuration Assistant window opens.

3. Select Local Net Service Name configuration.
4. Select Add.
5. Enter the Oracle Service Name.
6. Select TCP.
7. Enter the host name or the TCP/IP of the CA APM database server where the Oracle CA MDB resides.
8. Select Use the standard port number of 1521 or enter the Oracle database server port number.

   The Net Configuration Assistant prompts you to verify that you can connect to the Oracle database.

9. Select Yes, perform a test.

   The Net Configuration Assistant tests the connection to the Oracle database from the CA APM server, using the connection information that you provided. The test fails because a valid Oracle database management system username and password are required.

10. Click Change Login.
11. Enter the Oracle system username and password that your Oracle database administrator provided.

    The Net Configuration Assistant tests the connection to the Oracle database from the CA APM server. The test is successful.

    Note: If the test fails, verify that the Oracle DBMS is operating and the connection information is correct.

12. Enter the Net Service Name for the Oracle database. We recommend using Service Name_host name for the Net Service Name.

    The Net Configuration Assistant prompts you to configure another Net Service Name.

13. Select No.

    The Net Service Name is defined and stored in the local CA APM server tnsnames.ora file.

Note: After you install CA APM, you do not need the Oracle system username and password that you used to test the connection to the database server. Database login credentials (mdbadmin) are provided to the CA APM installation during the Oracle installation.