Topics

All topics

Use Oracle or Oracle XE database

PREREQUISITES:

Perform the following:

  1. Prepare the Oracle server by creating the following:
    • Database
      You can use an existing one.
    • Username and password for the database.
    • Database schema for the user part of the database.
      The supported version is Oracle's 11.2.0.1.0 or above.
    • If you are running Oracle XE, you must make sure that the connections limitations are increased to the minimum required by Sitefinity CMS (processes = 100, sessions = 120, transactions = 150).
      For more information about increasing connections, see http://www.fatlemon.co.uk/2009/06/increasing-processes-sessions-and-transactions-in-oracle-xe/.
  2. Install Open Data Access Components for Oracle Client (ODAC) on the machine where your site will be running.
    You must install Oracle 11g ODAC 11.1.0.7.20 version or higher.
    You can download ODAC from http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html.
  3. Open file tnsnames.ora, which is located in your ~\Network\Admin subfolders of your ODAC's client directory.
  4. Include in the file the connection string for your Oracle database.
    For more information, see http://www.orafaq.com/wiki/Tnsnames.ora.

    If the file is not located in folder ~\Network\Admin, you can take the sample file from folder ~\Network\Admin\Sample and modify it.

  5. In Sitefinity’s Project Startup wizard, perform the following:
    • In DataSource input field, enter the name of the connection string for your Oracle database, as you have entered it in the tnsnames.ora file.
    • In Username and Password input fields, enter the credentials for the database that you created in Step 2.

Increase your Sitefinity skills by signing up for our free trainings. Get Sitefinity-certified at Progress Education Community to boost your credentials.

Get started with Integration Hub | Sitefinity Cloud | Sitefinity SaaS

This free lesson teaches administrators, marketers, and other business professionals how to use the Integration hub service to create automated workflows between Sitefinity and other business systems.

Web Security for Sitefinity Administrators

This free lesson teaches administrators the basics about protecting yor Sitefinity instance and its sites from external threats. Configure HTTPS, SSL, allow lists for trusted sites, and cookie security, among others.

Foundations of Sitefinity ASP.NET Core Development

The free on-demand video course teaches developers how to use Sitefinity .NET Core and leverage its decoupled architecture and new way of coding against the platform.

Was this article helpful?