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 a database and select Next.
-
On the Creation Mode page, select Advanced configuration and select Next.
-
On the Deployment Type page, set Database type to Oracle Single Instance database. In addition, select the Custom Database option under Template name and select 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.
-
Clear the Create As Container Database option. Smart 3D does not support pluggable databases. Select Next.
-
On the Storage Option page, select Use following for the database storage attributes. Then select File System for Database files storage type. Browse to and select the appropriate file location.
-
On the Fast Recovery page:
-
If the database will be not used in a Global Workshare Configuration, select Specify Fast Recovery Area in the Recovery Configuration screen, and then select Next.
-
If the database will be used in a Global Workshare Configuration, select Enable Archiving, and then select Edit Archive Mode Parameters.
-
-
Select Edit archive mode parameters to specify the location of the archive log files. Select OK.
-
Select Next.
-
On the Network Configuration page, select Create a New Listener, and type a name and port number. Select Next.
-
On the Database Options page, clear all database component selections under the Database Components tab. Select Next.
-
On the Specify Configuration page, select the Memory tab.
-
Select the Typical Settings option. The percentage of memory allowed for an instance of Oracle should not exceed 60 percent. If you have more than one Oracle instance on this server, the allocated memory should not exceed 60 percent of the system memory.
-
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 then 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 Sets options, see your Oracle installation documentation.
-
-
Select the Connection Mode tab and select Dedicated Server Mode.
-
Select Next.
-
On the Management Options page, select 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. Select Next.
Do not use the @ character in the password.
-
On the Database Creation page, select All Initialization Parameters and select Show advanced parameters.
-
Change the parameters values as shown. Make sure a check mark (
) displays in the Override Default column.
db_files 1000
open_cursors 3000
os_authent_prefix ""
processes 1000
undo_retention 3600 -
Select Close.
-
On the Creation Options page, select Customize Storage Locations.
The control files should be divided among multiple physical hard drives. The database
needs this file 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 500 MB.
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.
-
Select Next.
-
Select Finish.
The first 15 percent of the creation process validates the configuration settings.
After the first 15 percent of the process has successfully passed, the database creation
succeeds without any errors.
-
After the Database Configuration Assistant completes the database creation, select Close.