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

This article will explain in detail how to build the library manually in oracle. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

1.-- View the server ORA environment variables

[oracle@orastb ~] $env | grep ORA

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

2.-create a parameter file

[oracle@orastb ~] $cd / u01/app/oracle/product/11.2.0/dbhome_1/dbs

[oracle@orastb dbs] $ls

Afiedt.buf hc_testdb.dat lkTESTDB2 spfiletestdb1.ora

Hc_boncstb.dat inittestdb1.ora orapwboncstb spfiletestdb2.ora

Hc_OMS.dat inittestdb2.ora orapwtestdb1

Hc_testdb1.dat lkBONCSTB orapwtestdb2

Hc_testdb2.dat lkTESTDB1 spfileboncstb.ora

[oracle@orastb dbs] $touch initqixindb.ora

[oracle@orastb dbs] $cat initqixindb.ora

Memory_target=17179870000

* .db_name='QIXINDB'

*. Processes = 300

* .audit_file_dest='/u01/app/oracle/admin/qixindb/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=10G

* .diagnostic_dest='/u01/app/oracle'

* .dispatchers=' (PROTOCOL=TCP) (SERVICE=ORCLXDB)'

* .open_cursors=300

* .remote_login_passwordfile='EXCLUSIVE'

* .undo_tablespace='undotbs01'

# You may want to ensure that control files are created on separate physical

# devices

* .control_files='/oradata/qixindb/control01.ctl','/oradata/flash_recovery_area_qixindb/qixindb/control02.ctl'

* .compatible = '11.2.0'

3.-- create parameter files and directories needed to build the database

[oracle@orastb dbs] $mkdir-p / u01/app/oracle/admin/qixindb/adump

[oracle@orastb dbs] $mkdir-p / u01/app/oracle/flash_recovery_area

[oracle@orastb dbs] $mkdir-p / oradata/qixindb/

[oracle@orastb dbs] $mkdir-p / oradata/flash_recovery_area_qixindb/qixindb/

[oracle@orastb dbs] $mkdir-p / oradata/qixindb/redolog/

4. Log in, start the database to nomount, and execute the script to build the database manually.

[oracle@orastb ~] $sqlplus / as sysdba

Connected to an idle instance.

(11G) SYS@qixindb > startup nomount

ORACLE instance started.

Total System Global Area 1.7170E+10 bytes

Fixed Size 2260128 bytes

Variable Size 9261024096 bytes

Database Buffers 7851737088 bytes

Redo Buffers 54951936 bytes

(11G) SYS@qixindb > show parameter memory_

NAME TYPE VALUE

-

Hi_shared_memory_address integer 0

Memory_max_target big integer 16448M

Memory_target big integer 16448M

Shared_memory_address integer 0

(11G) SYS@qixindb >

CREATE DATABASE qixindb

USER SYS IDENTIFIED BY BOnc#oracle123

USER SYSTEM IDENTIFIED BY BOnc#oracle123

LOGFILE GROUP 1 ('/ oradata/qixindb/redolog/redo01a.log','/oradata/qixindb/redolog/redo01b.log') SIZE 1G BLOCKSIZE 512

GROUP 2 ('/ oradata/qixindb/redolog/redo02a.log','/oradata/qixindb/redolog/redo02b.log') SIZE 1G BLOCKSIZE 512

GROUP 3 ('/ oradata/qixindb/redolog/redo03a.log','/oradata/qixindb/redolog/redo03b.log') SIZE 1G BLOCKSIZE 512

GROUP 4 ('/ oradata/qixindb/redolog/redo04a.log','/oradata/qixindb/redolog/redo04b.log') SIZE 1G BLOCKSIZE 512

GROUP 5 ('/ oradata/qixindb/redolog/redo05a.log','/oradata/qixindb/redolog/redo05b.log') SIZE 1G BLOCKSIZE 512

GROUP 6 ('/ oradata/qixindb/redolog/redo06a.log','/oradata/qixindb/redolog/redo06b.log') SIZE 1G BLOCKSIZE 512

MAXLOGFILES 15

MAXLOGMEMBERS 3

MAXLOGHISTORY 1

MAXDATAFILES 300

CHARACTER SET AL32UTF8

NATIONAL CHARACTER SET AL16UTF16

EXTENT MANAGEMENT LOCAL

DATAFILE'/ oradata/qixindb/system01.dbf' SIZE 8G REUSE

SYSAUX DATAFILE'/ oradata/qixindb/sysaux01.dbf' SIZE 8G REUSE

DEFAULT TABLESPACE users

DATAFILE'/ oradata/qixindb/users01.dbf'

SIZE 500M REUSE AUTOEXTEND OFF

DEFAULT TEMPORARY TABLESPACE tempts01

TEMPFILE'/ oradata/qixindb/temp01.dbf'

SIZE 30G REUSE

UNDO TABLESPACE undotbs01

DATAFILE'/ oradata/qixindb/undotbs01.dbf'

SIZE 30G REUSE AUTOEXTEND OFF

Database created.

(11G) SYS@qixindb > select open_mode from v$database

OPEN_MODE

-

READ WRITE

(11G) SYS@qixindb > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

(11G) SYS@qixindb > startup

ORACLE instance started.

Total System Global Area 1.7170E+10 bytes

Fixed Size 2260128 bytes

Variable Size 9261024096 bytes

Database Buffers 7851737088 bytes

Redo Buffers 54951936 bytes

Database mounted.

Database opened.

[oracle@orastb dbs] $orapwd file=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwqixindb password=BOnc#oracle123

[oracle@orastb dbs] $ll orapwqixindb

-rw-r-. 1 oracle oinstall 1536 Aug 30 16:09 orapwqixindb

(11G) SYS@qixindb > show parameter pfile

NAME TYPE VALUE

-

Spfile string

(11G) SYS@qixindb > create spfile from pfile

File created.

(11G) SYS@qixindb > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

(11G) SYS@qixindb > startup

ORACLE instance started.

Total System Global Area 1.7170E+10 bytes

Fixed Size 2260128 bytes

Variable Size 9261024096 bytes

Database Buffers 7851737088 bytes

Redo Buffers 54951936 bytes

Database mounted.

Database opened.

-- run three scripts after building the library

-- sys user login

In SQL*Plus, connect to your Oracle Database instance with the SYSDBA administrative privilege:

@? / rdbms/admin/catalog.sql

@? / rdbms/admin/catproc.sql

-- system user login

In SQL*Plus, connect to your Oracle Database instance as SYSTEM user:

@? / sqlplus/admin/pupbld.sql

This is the end of the article on "how to build an oracle library manually". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out 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.