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.