Creating a Database Connection for Oracle

To use Aurea CRM web with an Oracle database, the Oracle Client and the Oracle Data Provider for .NET must be installed in the same Oracle Home on your web server.

Note: The Aurea CRM web identity account must have Modify, Read & Execute, List Folder Contents, Read and Write access to the Oracle Client directories and subdirectories, see Determining the Web Application Identity Account.

Define the connection with Oracle Net Configuration Assistant.

To configure Oracle Net:

  1. Start the Net Configuration Assistant.


  2. Select Local Net Service Name configuration.
  3. Click Next.


  4. Select Add to define a new net service name.
  5. Click Next.


  6. Enter the Service Name, usually the global database name. Contact your Oracle Database administrator for the service name.
  7. Click Next.


  8. Select the network protocol, usually TCP.
  9. Click Next.


  10. Enter the Host Name. The host name is the name or the IP address of the Oracle database server.
  11. Select an IP port. Usually, you can use the standard port number.
  12. Click Next.


  13. Enter the Net Service Name (e.g. "AureaCRM"). The Net Service Name must be the same as the HOSTSTRING specified in the mmdb.ini file. For further details, see mmdb.ini File for Oracle Databases in the CRM.core Administrator Guide.
  14. Click Next to finish the configuration.