Configuring the .NET Stored Procedures Environment

Purpose

This tutorial describes how to install and configure Oracle Database Extensions for .NET so that you can deploy a .NET Stored Function.

Time to Complete

Approximately 15 minutes

Topics

This tutorial covers the following topics:

Overview
Prerequisites
Installing the Oracle Database Extensions for .NET Option
Configuring Your Database to Use Oracle Database Extensions for .NET
Updating Your Net Service Configuration Files
Summary

Viewing Screenshots

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)

Note: Alternatively, you can place the cursor over an individual icon in the following steps to load and view only the screenshot associated with that step. You can hide an individual screenshot by clicking it.

Overview

With Oracle Database 10g Release 2 on Windows, Oracle now offers Oracle Database Extensions for .NET. This database option makes it possible to deploy stored procedures and functions written in a .NET managed language into the Oracle database on Windows. This database option is not installed by default -- you will need a custom install of the database to enable this option.

Back to Topic List

Prerequisites

Before you perform this tutorial, you should:

1.

Perform the Installing Oracle Database 10g on Windows tutorial.

2.

Perform the Installing Oracle Developer Tools for Visual Studio .NET tutorial.

Back to Topic List

Installing the Oracle Database Extensions for .NET Option

In order to deploy a .NET Stored Function, you must install the Oracle Database Extensions for .NET option. Perform the following steps:

1.

For this installation you need either the DVDs or a downloaded version of the DVDs. In this tutorial, you install from the downloaded version. From the directory where the Database DVD files were unzipped, double-click setup.exe.

 
2.

Click Advanced Installation and click Next.

 
3.

For Installation Type, select Custom and click Next.

 
4.

You will install the Oracle Database Extensions for .NET into the existing Oracle Home. Click Next.

 
5.

Scroll down and select Oracle Database Extensions for .NET and click Next.

 
6.

The prerequisites will be evaluated. Click Next.

 
7.

Click Next.

 
8.

Review the Summary window and click Install.

 
9.

The progress window will appear.

 
10.

The installation was successful. Click Exit. Then click Yes.

 

Back to Topic List

Configuring your Database to use Oracle Database Extensions for .NET

In order to deploy a .NET Stored Function , you must configure your database to use the Oracle Database Extensions for .NET option. Perform the following steps:

1.

Select Start > Programs > Oracle - OraDb10g_home1 > Configuration and Migration Tools > Database Configuration Assistant.

 
2.

At the Welcome window, click Next.

 
3.

Click Configure Database Options and click Next.

 
4.

Accept the default. Click Next.

 
5.

Select Oracle Database Extensions for .NET and click Next.

 
6.

Click Finish.

 
7.

Click OK to configure your database.

 
8.

The progress window appears.

 
9.

The database was configured successfully. Click No.

 

Back to Topic List

Updating your Net Service Configuration Files

You need to make sure the TNSNAMES.ORA and LISTENER.ORA files are set appropriately. Perform the following steps:

1.

Make sure your TNSNAMES.ORA file contains the following entry (this file is located in your <ORACLE_HOME>\NETWORK\ADMIN directory):

ORACLR_CONNECTION_DATA =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
   )
   (CONNECT_DATA =
     (SID = CLRExtProc)
     (PRESENTATION = RO)
   )
 )

 
2.

Make sure your LISTENER.ORA file contains the following entry (this file is located in your <ORACLE_HOME>\NETWORK\ADMIN directory):

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = c:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
     )
    (SID_DESC =
      (SID_NAME = ORCL)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
     )
  )

Note: Your ORACLE_HOME path maybe different.

 

3.

Stop and start the following Oracle Services. 

OracleOraDb10g_home1ClrAgent
OracleOraDb10g_home1TNSListener
OracleServiceORCL

 

Back to Topic List

Summary

In this tutorial, you learned how to install and configure the Oracle Database Extensions for .NET option.

Back to Topic List

Move your mouse over this icon to hide all screenshots.