What are the steps to manually create a database in Oracle?

We all know that in addition to the built-in DBCA, Oracle can create databases. In addition, there is another way to create a database, that is, manually create a database in Oracle, this is what DBAs must master. The following describes how to manually create a database:

Manual Oracle database creation usually includes the following steps:

1. Confirm the new database name and Instance name;

2. Determine the authentication method of the database administrator;

3. Create an initialization parameter file;

4. Create an instance;

5. Connect and start the instance;

6. Use the create database statement to create a database in Oracle;

7. Create additional tablespaces;

8. Run the script to create a data dictionary view;

The following describes how to create a database named "MYNEWDB ".

1. Determine the Database Name and Instance name;

 
 

  
  
DB_NAME=MYNEWDB 
  
  
SID=MYNEWDB 
 
 

2. Determine the authentication method of the database administrator;

The Administrator authentication methods include operating system authentication and password authentication. In this example, operating system authentication is used.

3. Create an initialization parameter file;

The initialization parameter sample file provided by Oracle is located in initsmpl. ora in the $ ORACLE_HOME \ admin \ sample \ pfile directory.

We use the sample modification method. The name of the created parameter is initMYNEWDB. ora, which is stored in D: \ oracle \ ora92.

\ Database \ initMYNEWDB. ora. The main content is set as follows:

Shared Server Settings

 
 

  
  
dispatchers="(PROTOCOL=TCP)(SERVICE=MYNEWDBXDB) 
 
 

Database instance name settings

 
 

  
  
instance=MYNEWDB 
 
 

Security and audit settings

 
 

  
  
remote_login_passwordfile=EXCLUSIVE 
 
 

Sorting area size settings

 
 

  
  
pga_aggregate_target=25165824 
  
  
sort_area_size=524288 
 
 

Global Database Name settings

 
 

  
  
db_domain="" 
  
  
db_name=MYNEWDB 
 
 

Control File Settings

 
 

  
  
control_files=("D:\oracle\oradata\MYNEWDB\CONTROL01.CTL",  
  
  
"D:\oracle\oradata\MYNEWDB\CONTROL02.CTL",  
  
  
"D:\oracle\oradata\MYNEWDB\CONTROL03.CTL")  
 
 

SGA zone settings

 
 

  
  
java_pool_size =33554432 
  
  
large_pool_size=8388608 
  
  
shared_pool_size=50331648   
 
 

The above content is an introduction to the steps for creating a database in Oracle. I hope you will find some gains.