These steps guide you through the database creation process. You must log on to the server as a local administrator to create the Oracle database.
-
On the Start menu, open the Oracle Database Configuration Assistant wizard as an administrator.
-
On the Database Operation page, select Create Database, and click Next.
-
On the Creation Mode page, select Advanced Mode, and click Next.
-
On the Database Template page, select the Custom Database option, and click Next.
-
On the Database Identification page, enter the Global Database Name and the SID for the database. These names are generally identical and can be no longer than eight characters.
-
If you want to create a container database, select Create As Container Database.
-
Enter the Global Database Name and SID. Clear the Create As Container Database option. Smart 3D does not support pluggable databases. Click Next.
-
On the Management Options page, click Next without changing the default selections. Configure Enterprise Manager (EM) Database Express and port 5500 are the default options.
-
On the Database Credentials page, select a security option and provide the appropriate information. Click Next.
Do not use the @ character in the password.
-
On the Network Configuration page, select Create a New Listener, and then enter a name and port number. Click Next.
-
On the Storage Locations page, select File System and Use Common Location for All Database Files. Browse to and select the appropriate files location.
A subfolder is created in the folder you specified and is named with the SID you provided in step 4.
-
If the database will not be used in a Global Workshare Configuration, select Specify Flash Recovery Area in the Recovery Configuration screen, and click Next.
If the database will be used in a Global Workshare Configuration, select Enable Archiving, and click Edit Archive Mode Parameters.
The Archive log parameters dialog box displays.
-
Select Automatic Archiving to specify the location of the archive log files. Click OK.
-
Click Next.
-
On the Database Options page, clear all database component selections under the Database Components tab. Click Next.
All the database components are selected by default if you are creating a container instance. Leave them all selected if that is the case.
-
On the Initialization Parameters page, select the Memory tab.
-
Select the Typical Settings option. The percentage of memory allowed for an instance of Oracle should not exceed 40%. If you have more than one Oracle instance on this server, the allocated memory should not exceed 40% of the system memory.
-
Click All Initialization Parameters.
-
Change the parameters values as shown. Make sure a check mark () is displayed in the Override Default column.
db_files 1000
distributed_lock_timeout 180
open_cursors 3000
os_authent_prefix ""
processes 1000
session_cached_cursors 200
undo_retention 3600 -
On the Sizing tab, configure the Processes option based on this formula.
Processes » (Maximum Number of Users * 10) + (Number of Oracle System Processes)
The number of Oracle system processes can vary based on the number of background processes that are running. This number is a high estimate. Overestimate the number to ensure Oracle will only use the number of processes that the instance needs.
-
Select the Character Sets tab, and select the Use Unicode (AL32UTF8) option.
-
All Hexagon Asset Lifecycle Intelligence products that participate in integration should set their encodings to Use Unicode (AL32UTF8) for the Database Character Set option, and to AL16UTF16 - Unicode UTF-16 Universal character set for the National Character Set option.
-
For more information about the Character Set options, see your Oracle installation documentation.
-
-
Select the Connection Mode tab, and select Dedicated Server Mode.
-
Click Next.
-
On the Creation Options page, click Customize Storage Locations.
The control files should be divided among multiple physical hard drives. This file is needed by the database to start.
-
Verify that the path in the Tablespaces folder is correct for SYSAUX, SYSTEM, TEMP, UNDOTBS1, and USERS.
The information in the Datafiles and Redo Log Groups folders can retain the default settings as long as the folder path does not need updating.
-
Create an additional Redo log file, and set the Redo log file size for each group to 512000 K.
-
Click OK.
-
Click Next.
The Creation Options page allows you to save your database configuration as a template file, and also allows you to generate database creation scripts.
Not every setting is preserved in the template file. If you re-use template files, check the parameters carefully to verify that the settings are correct.
-
Click Next.
-
Click Finish.
The first 15% of the creation process validates the configuration settings. After the first 15% of the process has successfully passed, the database creation succeeds without any errors.
-
After the Database Configuration Assistant completes the database creation, click Close.