1. Database Installation Guide
  2. Setup and Configuration of the Database Server
  3. Create Database
  4. Creation of the Database

1.1.2 Creation of the Database

Create a database as per corporate standards and/or Oracle best practices with the following recommendations/guidelines.

  • Set NLS Characterset as AL32UTF8.
  • Ensure that the external procedure listener has been configured. Set the EXTPROC_DLLS environment variable so that the external procedure listener can access the Oracle Financial Services Lending and Leasing external procedure shared libraries. A section from a listener.ora file and a tnsnames.ora file is given below as an example. This sets up the external procedure listener as a separate listener named LEXT. See the Oracle Net Services documentation for more information on setting up an external procedure listener.

listener.ora

Figure 1-1 For Unix


Description of Figure 1-1 follows
Description of "Figure 1-1 For Unix"

For 19c database, go to $ORACLE_HOME/hs/admin/extproc.ora and set the parameter:- SET EXTPROC_DLLS=ANY

Parent topic: Create Database