Creating multiple Oracle databases on Windows
Before you begin
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 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.
Procedure
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 where 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.