-
Open a terminal window, and run the following command:
mount -t tmpfs shmfs -o size=XXg /dev/shm
XX is the size of <Memory_Max_Target> + 5g, and XX is less than the physical memory
size.
-
In the terminal window, run the following command to edit the fstab file:
gedit /etc/fstab
-
In the file editor, append the line below to the end of the file, and then save the changes:
shmfs /dev/shm tmpfs size=XXg 0
XX is the size of <Memory_Max_Target> + 5g, and XX is less than the physical memory
size.
-
In the terminal window, run the following command:
dbca
The Database Configuration Assistant window displays.
If you receive an error about the proxy setting having an incorrect value, run these
two commands:
$ unset https_proxy
$ unset no_proxy
-
Select Create Database, and then click Next.
-
Select Advanced configuration, and then click Next.
-
Select Custom Database, and then click Next.
-
Define the global database name and the Oracle system identifier (SID), clear the Create as Container database check box, and then click Next.
-
Select Use following for the database storage attributes. Then, select File System for Database files storage type. Browse to and select the appropriate database files location.
-
Clear the Specify Fast Recovery Area and Enable archiving check boxes.
-
Select Create a New Listener and type a name and port number. Click Next.
-
On the Database Components tab, clear all the check boxes. Click Next.
-
On the Memory tab, select Use Automatic Shared Memory Management.
-
On the Sizing tab, verify that Block Size is set to 8192 and Processes is set to 300.
-
On the Character Sets tab, select Use Unicode (AL32UTFB).
-
On the Connection Mode tab, select Dedicated Server Mode, and then click All Initialization Parameters.
-
Select Configure Enterprise Manager (EM) Database Express, and then type 5500 in the EM Database Express Port box. Click Next.
-
Select Use the Same Administrator Password for All Accounts. Enter and confirm the password, and then click Next.
-
Select Create database check box, and then click All Initialization Parameters.
-
Select Show advanced parameters check box. Set these values.
Press ENTER after typing the values to display the check mark in the Override Default column.
-
Click OK, and then click Customize Storage Locations.
-
Create an additional Redo log file, and set the size of the four Redo Log Groups to 500 MB.
-
To improve performance, we recommend that you increase the file size of temp and undotbs1 to 200 MB. Set the AUTOEXTEND increment to 100 MB.
-
Click OK, and then click Next.
-
Click Finish on the Create Database Summary window.
Wait for the database to be created.
-
Click Close.