Planning › Installation Planning › Configure Oracle › Configure the Net Service Name for CA SAM Implementation

Configure the Net Service Name for CA SAM Implementation

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 the CA APM Central Configuration Controller (CCC) server and the web servers. The CA SAM 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: We recommend different Oracle instances for CA APM and CA SAM for performance and scalability reasons.

Note: You must have Oracle Client Tools installed on all servers where the Net Service Names will be configured.

Follow these steps:

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 database for CA SAM resides.
   • The TCP/IP address of the Oracle database server where the database for CA SAM 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 SAM 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 database for CA SAM 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 SAM database server where the Oracle database 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.