Shulou(Shulou.com)06/01 Report--

First, the environment Oracle 11gjinghe Linux platform

Second, it is suitable for scenarios. In some cases, GUI environment cannot be provided. The library needs to be built manually.

Prerequisite: the operating system has installed the necessary packages and ORACLE software

3. General steps of manually building a database in the process

Set the environment variable .bash _ profile

Create a parameter file (location: $ORACLE_HOME/dbs)

Create a directory structure

Execute the database building script

4. Set the environment variable $cat .bash _ profile

ORACLE_SID=sdzy

ORACLE_BASE=/db/oracle

ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1

Export ORACLE_SID ORACLE_BASE ORACLE_HOME

PATH=$PATH:/$ORACLE_HOME/bin:$HOME/bin

Export PATH

Create a parameter file (location: $ORACLE_HOME/dbs) $cat $ORACLE_HOME/dbs/initsdzy.ora

Db_name='sdzy'

Memory_target=2500M

Processes = 1500

Sga_max_size=2000M

Shared_pool_size = 652428800

Large_pool_size = 778643200

Java_pool_size = 420971520

Audit_file_dest='/db/oracle/admin/adump'

Db_block_size=8192

Db_recovery_file_dest='/db/oracle/flash_recovery_area/sdzy'

Db_recovery_file_dest_size=2G

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

Open_cursors=300

Remote_login_passwordfile='EXCLUSIVE'

Undo_tablespace='UNDOTBS1'

Control_files = ('/ db/oracle/oradata/control01.ctl','/db/oracle/oradata/control02.ctl','/db/oracle/oradata/control03.ctl')

Compatible = '11.2.0'

Create a directory structure $mkdir-p / db/oracle/admin/adump

$mkdir-p / db/oracle/flash_recovery_area/sdzy

$mkdir-p / db/oracle/oradata

7. Use the parameter file to start the database to nomount status SQL > startup nomount pfile='/db/oracle/product/11.1.0/db_1/dbs/initsdzy.ora'

ORACLE instance started.

Total System Global Area 2087780352 bytes

Fixed Size 2214936 bytes

Variable Size 2063598568 bytes

Database Buffers 16777216 bytes

Redo Buffers 5189632 bytes

Prepare the script to create the library in the $ORACLE_BASE directory $cat create_db.sql

Create database sdzy

USER SYS IDENTIFIED BY change_on_install

USER SYSTEM IDENTIFIED BY manager

LOGFILE

GROUP 1 ('/ db/oracle/oradata/redo01.dbf') SIZE 100m

GROUP 2 ('/ db/oracle/oradata/redo02.dbf') SIZE 100m

GROUP 3 ('/ db/oracle/oradata/redo03.dbf') SIZE 100m

Maxlogfiles 15

Maxlogmembers 5

Maxdatafiles 100

Maxinstances 1

Datafile'/ db/oracle/oradata/system01.dbf' size 100m reuse

Sysaux datafile'/ db/oracle/oradata/sysaux01.dbf' size 100m

Default tablespace users datafile'/ db/oracle/oradata/user01.dbf' size 100m

Undo tablespace undotbs1 datafile'/ db/oracle/oradata/undo01.dbf' size 100m

Default temporary tablespace temp tempfile'/ db/oracle/oradata/temp01.dbf' size 100m reuse

Character set al32utf8

9. Execute the database creation script SQL > @ / db/oracle/create_db.sql

Database created.

SQL > select status from v$instance

STATUS

-

OPEN

Control files, data files, and log files are generated when the script is executed

After building the library, you need to run several scripts to install the data dictionary and so on to create the data dictionary view

SQL > @ / db/oracle/product/11.1.0/db_1/rdbms/admin/catalog.sql

Create ORACLE stored procedures and packages

SQL > @ / db/oracle/product/11.1.0/db_1/rdbms/admin/catproc.sql

Create an interface that requires the use of PL/ SQL encryption tools

SQL > @ / db/oracle/product/11.1.0/db_1/rdbms/admin/catoctk.sql

Create some views related to the locking mechanism in ORACLE

SQL > @ / db/oracle/product/11.1.0/db_1/rdbms/admin/catblock.sql:

Create the SPFILE file and restart the library

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.