Manual Oracle database creation in Linux

Platform: CentOS 5.3, Oracle 10.2.0.1
Plan: db_name = risotest. You can also use risotest for the global database name.

The directory structure is roughly divided into the following structure: You can do whatever you like: You need to have a concept in your mind in the early stage, so you won't make any mistakes during configuration.

/Admin/udump some people like to build pfile in admin, so I won't do that anymore. Haha
/Admin/bdump
/Admin/cdump
/Admin/adump
/Admin/dpdump
/Export/oracle/product/10.2.0/db_1
/Archive
/Oradata
/Flash_recovery_area
1. create the required directory
Mkdir-p export/oracle/product/10.2.0/admin/bdump
Mkdir-p export/oracle/product/10.2.0/admin/cdump
Mkdir-p export/oracle/product/10.2.0/admin/dpdump
Mkdir-p export/oracle/product/10.2.0/admin/udump
Mkdir-p export/oracle/product/10.2.0/admin/adump
Mkdir-p export/oracle/product/10.2.0/archive
Mkdir-p export/oracle/product/10.2.0/oradata
Mkdir-p export/oracle/product/10.2.0/flash_recovery_area

2. Set the environment variable and add it to the user environment variable.
$ Export ORACLE_BASE =/export/oracle
$ Export ORACLE_HOME = $ ORACLE_BASE/product/10.2.0/db_1
$ Export ORACLE_SID = risotest

3. Create an initialization parameter file
$ Vi $ ORACLE_HOME/dbs/initrisotest. ora do not write the instancename size here as the environment variable definition is inconsistent.
# The following are required parameters for creating a database:
Control_files = '/epxort/oracle/product/10.2.0/oradata/control1.ctl', '/epxort/oracle/product/10.2.0/oradata/control2.ctl ', '/epxort/oracle/product/10.2.0/oradata/control3.ctl'
Undo_management = 'auto'
Undo_tablespace = 'undotbs1'
Db_name = 'risotest'
DB _ block_size = 8192
Sga_max_size = 167 M
Sga_target = 167 M
Audit_file_dest = 'export/oracle/product/10.2.0/admin/adump '# default $ ORACLE_HOME/rdbms/adump is not set
Background_dump_dest = 'export/oracle/product/10.2.0/admin/bdump '# default $ ORACLE_HOME/rdbms/log is not set
Core_dump_dest = 'export/oracle/product/10.2.0/admin/cdump '# default $ ORACLE_HOME/rdbms/dbs is not set
User_dump_dest = 'export/oracle/product/10.2.0/admin/udump '# default $ ORACLE_HOME/rdbms/log is not set
Db_domain = ''# null by default when not set
Open_cursors = 1500 # do not set the default value of 50
Processes = 250 # If the default value is not set, 40 is used. Set the size based on the specific service quantity. It can be changed. It doesn't matter.
Log_archive_dest_1 = 'export/oracle/product/10.2.0/admin/archive '# If this parameter is not set, the default value is null. the archive is stored in $ ORACLE_HOME/rdbms/dbs/arch.
Log_archive_format = 'Log _ % t _ % s _ % r. arc' # The default value % t _ % s _ % r. dbf is not set.
Job_queue_processes = 10 # do not set the default value to 0
Undo_retention = 10800 # default 900 is not set
# Audit_sys_operations = 'true' # To enable the audit function, set the following parameters:
# Audit_trail = db, extended # Note: if the database is converted to a physical standby database in the future, the database cannot be set here; otherwise, the read only mode cannot be enabled for the physical standby database in the future.
Db_recovery_file_dest = 'export/oracle/product/10.2.0/admin/flash_recovery_area '# required in OMF Mode
Db_recovery_file_dest_size = 2G # required for OMF Mode

# If you use OMF to manage database files, you need to set the following parameters:
Db_create_file_dest = 'export/oracle/product/10.2.0/admin/oradata' # automatically create the./{db_name}/datafile directory under this directory.
Db_create_online_log_dest_1 = 'export/oracle/product/10.2.0/admin/oradata' # automatically create the./{db_name}/onlinelog directory in this directory.

4. Create a password file. Do not use the following line for operating system verification. Use this line for port file verification: see settings in sqlnet.
$ ORACLE_HOME/bin/orapwd file = $ ORACLE_HOME/dbs/orapw $ ORACLE_SID password = 123456 force = y

1 2 Next Page