Oracle 10 Gb manual database creation, self-Experience Summary

I am a crazy fan of Oracle 10g manual database creation. I like Oracle 10g manual database creation very much. The following content is my summary, if you are a crazy fan of Oracle 10 Gb manual database creation, I believe the following articles will help you.

1. Create a directory

 
 

  
  
mkdir d:\oracle\product\10.1.0\database  
  
  
mkdir e:\oracle\admin\Ora10g\bdump  
  
  
mkdir e:\oracle\admin\Ora10g\cdump  
  
  
mkdir e:\oracle\admin\Ora10g\create  
  
  
mkdir e:\oracle\admin\Ora10g\pfile  
  
  
mkdir e:\oracle\admin\Ora10g\udump  
  
  
mkdir e:\oracle\flash_recovery_area  
  
  
mkdir e:\oracle\oradata  
  
  
mkdir e:\oracle\oradata\Ora10g  
 
 

2. Generate a windows Service, create a password file, and run the command in cmd.

Set ORACLE_SID = dbca green section set oracle Instance name to ora10g

 
 

  
  
d:\oracle\product\10.1.0\DB_1\bin\oradim.
exe -new -sid ORA10G -startmode manual -spfile 
d:\oracle\product\10.1.0\DB_1\bin\oradim.
exe -edit -sid ORA10G -startmode a -spfile 
 
 

Create an instance named dbca and change the Manual start mode to automatic start.

 
 

  
  
d:\oracle\product\10.1.0\DB_1\bin\orapwd.
exe file=d:\oracle\product\10.1.0\db_1\PWDOra10g.
ora password=sysPassword force=y 
 
 

Use oracle's built-in orapwd to create a sysPassword password for sys users.

3. In Oracle 10 Gb manual database creation, we need to execute the database creation script

The simhei part is the script to be called to create a database.

The above content describes the preparations for Oracle 10 Gb manual database creation. We hope to help you in this regard.