Full Process of 10 Gb manual Oracle database creation

In normal Oracle databases, we generally use GUI to create databases. Therefore, it is relatively difficult to manually create databases. This is also a concern for OCM tests, the main version is 9i and 10g.

1. Modify/etc/oratab

Oral:/opt/Oracle/Database: N

2. Create a sys Password Authentication File

Orapwd file = $ ORACLE_HOME/dbs/orapworal Password = system entries = 5

3. Set the Oracle user environment variable Instance name

Vi. bash_profile

Export oracle_sid = oral

Export oracle_base =/opt/Oracle

Export ORACLE_HOME =/opt/Oracle/Database

Export Path = $ path: $ oralce_home/bin :.

4. Create a directory
Oracle @ marvelyu :~ /> Mkdir
-P/opt/Oracle/admin/oral/bdump
Oracle @ marvelyu :~ /> Mkdir
-P/opt/Oracle/admin/oral/udump
Oracle @ marvelyu :~ /> Mkdir
-P/opt/Oracle/admin/oral/cdump
Oracle @ marvelyu :~ /> Mkdir
-P/opt/Oracle/admin/oral/adump

5. Create a pfile

CD $ ORACLE_HOME/dbs

Cat init. ora | grep-V ^ # | grep-V ^ $> initoral. ora

Modify the parameter file and modify some key parameters.

*. Audit_file_dest = '/opt/Oracle/admin/oral/adump'

*. Background_dump_dest = '/opt/Oracle/admin/oral/bdump'

*. Compatible = '9. 2.0.2 ′

*. Control_files = '/opt/Oracle/oradata/control01.ctl', '/opt/Oracle/oradata/control02.ctl'

*. Core_dump_dest = '/opt/Oracle/admin/oral/cdump'

*. Db_cache_size = 80 m

*. Db_name = 'oral'

*. Global_names = true

*. Log_buffer = 32768

*. Shared_pool_size = 3500000

*. Undo_management = 'auto'

*. User_dump_dest = '/opt/Oracle/admin/oral/udump'

Remember to create spfile from pfile; To create the spfile.

6. Run the database creation script

Start the database to nomount

> Sqlplus "/As sysdba"

> Stratup nomount pfile = '$ ORACLE_HOME/dbs/initoral. ora'

Create Database oral

User SYS identified by System

User system identified by System

Logfile

Group 1 ('/opt/Oracle/oradata/redo01.log') size 100 m,

Group 2 ('/opt/Oracle/oradata/redo02.log') size 100 m,

Group 3 ('/opt/Oracle/oradata/redo03.log') size 100 m

Maxlogfiles 5

Maxlogmembers 5

Maxloghistory 1

Maxdatafiles 100

Maxinstances 1

Character Set zhs16gbk

National Character Set al16utf16

Datafile '/opt/Oracle/oradata/system01.dbf' size 325 m

Extent management local

Default temporary tablespace temp

Tempfile '/opt/Oracle/oradata/temp01.dbf'

Size 20 m

Undo tablespace undotbs

Datafile '/opt/Oracle/oradata/undotbs01.dbf'

Size 200 m autoextend on maxsize unlimited;

7. create other system tablespaces

Create tablespace users logging

Datafile '/opt/Oracle/oradata/users01.dbf'

Size 25 m reuse autoextend on next 1280 K maxsize Unlimited

Extent management local;

Create tablespace indx Logging

Datafile '/opt/Oracle/oradata/indx01.dbf'

Size 25 m reuse autoextend on next 1280 K maxsize Unlimited

Extent management local;

8. Run the data dictionary creation script.

$ ORACLE_HOME/rdbms/admin/CATALOG. SQL

$ ORACLE_HOME/rdbms/admin/catproc. SQL

For 10 Gb files, there is only one sysaux file added:

Create Database mynewdb

User SYS identified by System

User system identified by System

Logfile group 1 ('/opt/Oracle/oradata/redo01.log') size 100 m,

Group 2 ('/opt/Oracle/oradata/redo02.log') size 100 m,

Group 3 ('/opt/Oracle/oradata/redo03.log') size 100 m

Maxlogfiles 5

Maxlogmembers 5

Maxloghistory 1

Maxdatafiles 100

Maxinstances 1

Character Set zhs16gbk

National Character Set al16utf16

Datafile '/opt/Oracle/oradata/system01.dbf' size 325 m Reuse

Extent management local

Sysaux datafile '/opt/Oracle/oradata/oral/sysaux01.dbf' size 325 m Reuse

Default tablespace user

Default temporary tablespace tempts1

Datafile '/opt/Oracle/oradata/temp01.dbf'

Size 20 m Reuse

Undo tablespace undotbs

Datafile '/opt/Oracle/oradata/undotbs01.dbf'

Size 200 m reuse autoextend on next 5120 K maxsize unlimited;