Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to create a database in oracle. The content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Steps for manually creating a database

1. Create instance steps

① prepares parameter file pfile/spfile (refer to database software installation init file)

② starts the instance instance

two。 Create a database database

① prepares create database statements

② executes create database statement

③ executes post script

④ validates the database creation result

The steps begin:

Create an instance instance

-- adjust to pfile parameter file according to init.ora file in $ORACLE_HOME/dbs directory

$cd $ORACLE_HOME/dbs

$cat init.ora | grep-v ^ # | grep-v ^ $> initORCL.ora

Where-v ^ # removes all comments

-v ^ $is to remove all blank lines

-- adjust the contents of the pfile parameter file

$vi initORCL.ora

Db_name= 'ORCL'

Memory_target=1G

Processes = 150

Audit_file_dest='/ admin/orcl/adump'

Audit_trail = 'db'

Db_block_size=8192

Db_domain=''

Db_recovery_file_dest='/ flash_recovery_area'

Db_recovery_file_dest_size=2G

Diagnostic_dest=''

Dispatchers=' (PROTOCOL=TCP) (SERVICE=ORCLXDB)'

Open_cursors=300

Remote_login_passwordfile='EXCLUSIVE'

Undo_tablespace='UNDOTBS1'

Control_files = (ora_control1, ora_control2)

Compatible = '11.2.0'

-- the final results are as follows:

Db_name=' ORCL'

Memory_target=1G

Processes = 150

Audit_file_dest=' / u01/app/oracle/admin/ORCL/adump'

Audit_trail = 'db'

Db_block_size=8192

Db_domain=''

Db_recovery_file_dest=' / u01/app/oracle / flash_recovery_area'

Db_recovery_file_dest_size=2G

Diagnostic_dest='/u01/app/oracle'

Dispatchers=' (PROTOCOL=TCP) (SERVICE=ORCLXDB)'

Open_cursors=300

Remote_login_passwordfile='EXCLUSIVE'

Undo_tablespace='UNDOTBS1'

Control_files = (/ u01qapax oraclecontrol oradata / u01Accord oradata control 01.ctljigmage u01apapplicoraclecontrol oradata / orcl control 02.ctl)

Compatible = '11.2.0'

-- .bash _ profile file adds the following

$vi .bash _ profile

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

Export ORACLE_SID=ORCL

Export PATH=$ORACLE_HOME/bin:$PATH

-- change the variable to take effect

$. . / .bash _ profile

Or

$source .bash _ profile

-- validate environment variables

$echo $ORACLE_HOME

$echo $ORACLE_SID

-enter the ORACLE_BASE directory

$cd $ORACLE_BASE

-create directories (create all directories in pfile)

$mkdir-p admin/ORCL/adump

$mkdir-p flash_recovery_area

$mkdir-p oradata/ORCL

-- generate spfile based on pfile parameter file

$sqlplus / as sysdba

SQL > create spfile from pfile

-- Boot to nomount state

SQL > startup nomount

2. Prepare database database

-- write the following

$vi create_db.sql

CREATE DATABASE ORCL

USER S YS IDENTIFIED BY oracle

USER SYSTEM IDENTIFIED BY oracle

LOGFILE GROUP 1 ('/ u01/app/oracle/oradata/ ORCL / redo01.log') SIZE 100m BLOCKSIZE 512

GROUP 2 ('/ u01/app/oracle/oradata/ ORCL / redo02.log') SIZE 100m BLOCKSIZE 512

GROUP 3 ('/ u01/app/oracle/oradata/ ORCL / redo03.log') SIZE 100m BLOCKSIZE 512

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 100

CHARACTER SET AL32UTF8

NATIONAL CHARACTER SET AL16UTF16

EXTENT MANAGEMENT LOCAL

DATAFILE'/ u01/app/oracle/oradata/ ORCL / system01.dbf 'SIZE 325m REUSE

SYSAUX DATAFILE'/ u01/app/oracle/oradata/ ORCL / sysaux01.dbf 'SIZE 325m REUSE

DEFAULT TABLESPACE users

DATAFILE'/ u01/app/oracle/oradata/ ORCL / users01.dbf'

SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE'/ u01/app/oracle/oradata/ ORCL / temp01.dbf'

SIZE 20M REUSE

UNDO TABLESPACE undotbs1

DATAFILE'/ u01/app/oracle/oradata/ ORCL / undotbs01.dbf'

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

Note that the name of the undo tablespace should be the same as the file name in spfile.

-list of content to be adjusted

1) change the database name to ORCL

2) change the password of SYS and SYSTEM users to oracle

3) modify the path of data file and log file

-- execute the above script

SQL > @ / home/oracle/create_db.sql

-- execute post script file (SYS user)

SQL > @? / rdbms/admin/catalog.sql-data dictionary, dynamic view

SQL > @? / rdbms/admin/catproc.sql-- PL/SQL stored procedure related code

SQL > @? / rdbms/admin/utlrp.sql-- compile the object

-- execute the following script (system user)

SQL > @? / sqlplus/admin/pupbld.sql-- SQL*Plus related scripts

Verify database availability

SQL > select status from v$instance

SQL > select * from v$version

On how to create a database in oracle to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.