Manual method for creating a database in Oracle

In addition to the built-in DBCA for creating databases, the Oracle database also has another related creation solution, that is, manual Oracle database creation. This technology is also required by DBA personnel. The following describes how to manually create a database:

To manually create a database, follow these 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 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. BKJIA database recommends Oracle Database debugging and Performance Optimization