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

1. Create a directory

$ORACLE_BASE/admin/

$ORACLE_BASE/oradata

$ORACLE_BASE/flash_recovery_area

2. Create initialization parameter file

cd $ORACLE_HOME/dbs

db_name=orcl

memory_target=1G

processes = 150

audit_file_dest='/oracle/app/product/admin/orcl/adump'

audit_trail ='db'

db_block_size=8192

db_domain=''

db_recovery_file_dest='/oracle/app/product/flash_recovery_area'

db_recovery_file_dest_size=2G

diagnostic_dest='/oracle/app/product'

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

open_cursors=300

remote_login_passwordfile='EXCLUSIVE'

undo_tablespace='UNDOTBS1'

control_files = (/oracle/app/product/oradata/ora_control1,/oracle/app/product/oradata/ora_control2,/oracle/app/product/oradata/ora_control3)

compatible ='11.2.0'

undo_management=AUTO

3. Create a password file

orapwd file=$ORACLE_HOME/dbs/orapworcl password=oracle force=y

4. Building a library

A. Create spfile

$ sqlplus '/as sysdba'

SQL> create spfile from pfile;(automatically reads pfile: $ORACLE_HOME/dbs/init$ORACLE_SID.ora)

b. Automatic creation of control files during startup to nomount state creation database-----

SQL> startup nomount;

SQL> @/home/oracle/createdb.sql-------------------

Create View Script

create database orcl CONTROLFILE REUSE

MAXINSTANCES 8 MAXDATAFILES 2000

MAXLOGHISTORY 2 MAXLOGFILES 64 MAXLOGMEMBERS 5

character set ZHS16GBK national character set AL16UTF16

logfile group 1 ('/oracle/app/product/oradata/orcl/redo1.log') size 50M reuse,

group 2 ('/oracle/app/product/oradata/orcl/redo2.log') size 50M reuse,

group 3 ('/oracle/app/product/oradata/orcl/redo3.log') size 50M reuse

datafile '/oracle/app/product/oradata/orcl/system.dbf' size 1024M reuse autoextend on next 100M maxsize unlimited extent management local

sysaux datafile '/oracle/app/product/oradata/orcl/sysaux.dbf' size 1024M autoextend on next 100M maxsize unlimited

default temporary tablespace temp tempfile '/oracle/app/product/oradata/orcl/temp01.dbf' size 100M reuse autoextend on next 10M maxsize unlimited

undo tablespace undotbs1 datafile '/oracle/app/product/oradata/orcl/undotbs1.dbf' size 100M reuse autoextend on next 10M maxsize unlimited

USER SYS IDENTIFIED BY "oracle" USER SYSTEM IDENTIFIED BY "oracle";

c. Run the data dictionary script, in which catalog and catproc are required, and others are optional: (running time is relatively long)

SQL> spool /opt/oradata/cat_testdb.log

SQL> @?/ rdbms/admin/catalog.sql------------------------------------Required

SQL> @?/ rdbms/admin/catproc.sql-----------------------------------

SQL> @?/ rdbms/admin/catblock.sql -----------(Several views related to lock creation)

SQL> @?/ rdbms/admin/catoctk.sql ----------(dbms_crypto_toolkit)

SQL> @?/ rdbms/admin/owminst.plb---------------

SQL> spool off

d. New sqlplus attribute and help, USERS table space

SQL> connect system/oracle

SQL> @?/ sqlplus/admin/pupbld.sql

SQL> @?/ sqlplus/admin/help/hlpbld.sql helpus.sql

SQL> connect /as sysdba

SQL> CREATE TABLESPACE USERS LOGGING DATAFILE '/oracle/app/product/oradata/orcl/users01.dbf' SIZE 1024M REUSE AUTOEXTEND ON NEXT 100m MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

SQL> ALTER DATABASE DEFAULT TABLESPACE USERS;

SQL> execute utl_recomp.recomp_serial();

Configure network listener sqlnet.ora tnsname.ora

Set up and configure EM (omit this step):

SQL> @?/ sysman/admin/emdrep/sql/emreposcre /oracle/product/10.2 SYSMAN oracle TEMP ON;

SQL> alter user SYSMAN identified by "sysman" account unlock;

SQL> alter user DBSNMP identified by "dbsnmp" account unlock;

SQL> host emca -config dbcontrol db -silent -DB_UNIQUE_NAME ypyhtb -PORT 1521 -EM_HOME /oracle/product/10.2/bin -LISTENER LISTENER -SERVICE_NAME ypythb.LK -SYS_PWD "oracle" -SID ypythb -ORACLE_HOME /oracle/product/10.2 -DBSNMP_PWD "dbsnmp" -HOST "172.19.201.184" -LISTENER_OH /oracle/product/10.2 -LOG_FILE /oradata/ypythb/emConfig.log -SYSMAN_PWD "sysman";

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.