Skip to content
CA Business Service Insight - 8.3.5
Documentation powered by DocOps

Configure Oracle Network

Last update July 20, 2015

To prepare the environment to run CA Business Service Insight, set up the Oracle network.

Configure Oracle Database Server

Environment settings

  • ORACLE_HOME environment variable must be defined.
  • For Oracle version 11, verify that the _optimizer_group_by_placement parameter is FALSE.

Verify the Listener

  1. To verify that the service is active, run the following command:

    lsnrctl status 

    A list of services summary appears.

    Note: If the list does not appear, run the following command:

    lsnrctl start 

    A confirmation message appears.

  2.  Verify that $ORACLE_HOME\network\admin\SQLNET.ORA contains the following line:

    SQLNET.AUTHENTICATION_SERVICES = (NTS)

Configure the Listener

If an active listener does not exist, create and configure a listener. To configure the local Net Service Name, use the Net Configuration Assistant.

Follow these Steps:

  1. Start the Oracle Net Configuration Assistant.
  2. Select Listener configuration.
  3. Select Add, and click Next.
  4. Type LISTENER, and click Next.
  5. Move TCP to Selected Protocols, and click Next.
  6. Select Use the standard port number of 1521, and click Next.
    The active listener is created.
  7. Verify that the listener is active in the Oracle Net Manager.

Alternatively, manually edit the Oracle network files:

Verify that the listener configuration file is configured correctly and that the file recognizes the instance to be created.
Filename: $ORACLE_HOME\network\admin\LISTENER.ORA
Example:

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = OBLICORE)

      (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)

      (SID_NAME = oblicore)

    )

  )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = server12.ca.com)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

  )

Configure Oracle Client Machines

For the application server and web server

Environment settings

  • The TNS_ADMIN key must be present in the registry. On Windows 32-bit systems, the path is HKLM\SOFTWARE\. On Windows 64-bit systems, the path is HKLM\SOFTWARE\Wow6432Node\.

  • The client server NLS_LANG settings must be identical to the database server NLS_LANG settings.

  • Oracle OLEDB Provider version must be the same or a later version of the Oracle database software.
    • If you are adding the Oracle OLEDB Provider to an existing Oracle client, install it to the existing Oracle home. For assistance with the Oracle OLEDB Provider installation, contact the CA Technologies support team.
  • Run the following command to install ODAC 11.2 Release 6 32 bit (ODAC112040Xcopy_32bit):

    Install.bat all c:\unique_installation_path\odac myhome true

    Create TNSnames.ora file in the odac installation directory:

    Filename: C:\unique_installation_path\odac\TNSNAMES.ORA
    Default Port: 1521
    Example:

    OBLICORE =

      (DESCRIPTION =

        (ADDRESS = (PROTOCOL = TCP)(HOST = server12.ca.com)(PORT = 1521))

        (CONNECT_DATA =

          (SERVER = DEDICATED)

          (SERVICE_NAME = oblicore)

        )

      )

    You can download ODAC112040Xcopy_32bit.zip from Oracle web site at http://www.oracle.com/us/sitemaps/utilsoft-087491.html

Verify Communication

Verify the Oracle client and the database connection configuration components.

To test communication between the Oracle client and the Oracle server, run the following command:

Tnsping  <tns_entry_name>

The following example shows the expected return:

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 21 - AUG - 2013 15:31:07

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:

/opt/oracle/product/11.2/DB_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (SESCRIPTION = (ADDRESS = (Protocol = TCP) (HOST = 6201 - lab350- sp) (PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = oblicore)))

OK (10 msec)

The system responds with "OK" followed by the response time.

Configure the Network

If the verification failed, establish a connection to the database. To configure the local Net Service Name, use the Net Configuration Assistant.

Follow these Steps:

  1. Start the Oracle Net Configuration Assistant.
  2. Select Local Net Service Name configuration, and click Next.
  3. Select Add, and click Next.
  4. In Service Name, type oblicore, and click Next.
  5. Select TCP for the communication, and click Next.
  6. In Host name, specify the name of the Oracle server, select Use the standard port number of 1521, and click Next.
  7. Select No, do not test, and click Next.
  8. In Net Service Name, type oblicore, and click Next.
  9. Click Next.
  10. TNSname.ora is created under $ORACLE_HOME/network/admin.

Alternatively, manually edit the Oracle network files:

Verify that the local naming configuration file contains the service alias with the correct host name and port:
Filename: $ORACLE_HOME\network\admin\TNSNAMES.ORA
Default Port: 1521
Example:

OBLICORE =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = server12.ca.com)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = oblicore)

    )

  )

Was this helpful?

Please log in to post comments.