Creating multiple Oracle databases on Windows
Complete these steps for each instance that you plan to create:
- Create a new user and add it to the Administrators group.
- Remove the user account from the Users group.
- Grant rights to the new user:
- Click Start > Run and enter secpol.msc.
- Expand Local Policies and click User Rights Assignment.
- Open each of the following rights, click Add User or Groupand add the new user:
- Act as part of the operating system
- Adjust memory quotas|Increase quotas for a process
- Create a token object
- Debug programs
- Lock pages in memory
- Log on as a service
- Replace a process level token
Tip: The new account uses the local system as the domain.
-
Each database is a database instance. To create Oracle databases on Windows, use the Oracle Database Configuration Assistant (DBCA) to complete these steps:
-
To open the DBCA tool, click Start. Select Oracle > Oracle_directory > Configuration and Migration Tools > Database Configuration Assistantwhere Oracle_directory is the Oracle home on your system.
-
On the Database Operation page, accept the default option to Create database and click Next.
- Select Advanced Mode.
-
On the Database Templates page, accept the General Purpose or Transaction Processing default option and click Next.
-
On the Database Identification page, enter LSCONN in the Global Database Name and SID fields and click Next.
Do not select Create As Container Database.
-
On the Management Options page, accept the default option to Configure Enterprise Manager (EM) Database Express and click Next.
-
On the Database Credentials page, create the database password and click Next.
-
On the Network Configuration page, select a listener you created from the list, or create a listener.
-
On the Storage Locations page, accept the File System storage option and click Next.
-
Accept the Database File Locations, which is the default.
-
Accept the Specify Fast Recovery Area, which is the default.
-
Click Next.
-
-
On the Database Options page, accept the unselected defaults and click Next.
-
On the Initialization Parameters page, select Use Automatic Memory Management.
-
Click the Character Sets tab and select the Use Unicode (AL32UTF8).
-
Click the Connection Mode tab and select Dedicated Server Mode.
-
Click Next.
-
-
On the Creation Options page, accept the Create Database default option and select Generate Database Creation Scripts. Click Next.
-
Review the summary and click Finish.
Parent topic:Creating multiple Oracle databases