1、配置环境变量.bash_profile
[oracle@yidb ~]$ cat .bash_profile
export ORACLE_BASE=/oracle/app
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=erdb
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
alias sqlplus='rlwrap sqlplus'
2、建立相应的路径
------------------------10g
rm -rf $ORACLE_BASE/admin/$ORACLE_SID
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/adump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/bdump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/cdump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/dpdump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/udump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/pfile
chmod -R 750 $ORACLE_BASE/admin
------------------------11g
rm -rf $ORACLE_BASE/admin/$ORACLE_SID
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/adump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/dpdump
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/pfile
mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/scripts
chmod -R 750 $ORACLE_BASE/admin
rm -rf $ORACLE_BASE/diag/rdbms/$ORACLE_SID
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/alert
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/cdump
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/hm
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/incident
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/incpkg
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/ir
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/lck
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/metadata
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/stage
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/sweep
mkdir -p $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace
chmod -R 750 $ORACLE_BASE/diag/rdbms/$ORACLE_SID
3、 建初始化参数文件pfile
------------------------10g
orcl.__db_cache_size=666894336
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=264241152
orcl.__streams_pool_size=0
*.audit_file_dest='/ora1/app/oracle/admin/beedb/adump'
*.background_dump_dest='/ora1/app/oracle/admin/beedb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/oradata/orcl/control01.ctl','/oradata/orcl/control02.ctl','/oradata/orcl/control03.ctl'
*.core_dump_dest='/ora1/app/oracle/admin/beedb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='beedb'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=297795584
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=943718400
*.sga_target=843718400
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/ora1/app/oracle/admin/beedb/udump'
------------------------11g
[oracle@yidb dbs]$ cat $ORACLE_HOME/dbs/initerdb.ora
erdb.__db_cache_size=348127232
erdb.__java_pool_size=4194304
erdb.__large_pool_size=4194304
erdb.__oracle_base='/oracle/app'
erdb.__pga_aggregate_target=43932928
erdb.__sga_target=315899392
erdb.__shared_io_pool_size=0
erdb.__shared_pool_size=150994944
erdb.__streams_pool_size=0
*.audit_file_dest='/oracle/app/admin/erdb/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/oracle/app/oradata/erdb/control01','/oracle/app/oradata/erdb/control02','/oracle/app/oradata/erdb/control03'
*.db_block_size=8192
*.db_domain=''
*.db_name='erdb'
*.diagnostic_dest='/oracle/app'
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
4、密码文件
[oracle@yidb dbs]$ orapwd file=orapwerdb password=oracle
5、启动到nomount,建立控制文件
[oracle@yidb ~]$ sqlplus / as sysdba
SQL> startup nomount
SQL>
create database erdb CONTROLFILE REUSE
MAXINSTANCES 8
MAXDATAFILES 2000
MAXLOGHISTORY 1024
MAXLOGFILES 64
MAXLOGMEMBERS 4
character set ZHS16GBK national character set AL16UTF16
logfile
group 1 ('/oracle/app/oradata/erdb/redo01.log') size 50M reuse,
group 2 ('/oracle/app/oradata/erdb/redo02.log') size 50M reuse,
group 3 ('/oracle/app/oradata/erdb/redo03.log') size 50M reuse
datafile '/oracle/app/oradata/erdb/system01.dbf' size 1000M reuse extent management local
sysaux datafile '/oracle/app/oradata/erdb/sysaux01.dbf' size 1000M
default temporary tablespace temp tempfile '/oracle/app/oradata/erdb/temp01.dbf' size 100M reuse
undo tablespace undotbs1 datafile '/oracle/app/oradata/erdb/undotbs01.dbf' size 100M reuse
USER SYS IDENTIFIED BY "oracle"
USER SYSTEM IDENTIFIED BY "oracle";
6、 运行数据字典脚本,其中catalog和catproc是必需的,其它可选:
SQL> spool /home/oracle/cat_erdb.log
SQL> @?/rdbms/admin/catalog.sql ; (建数据字典视图)
SQL> @?/rdbms/admin/catproc.sql ; (建存储过程包)
SQL> @?/rdbms/admin/catblock.sql ; (建锁相关的几个视图)
SQL> @?/rdbms/admin/catoctk.sql ; (建密码工具包dbms_crypto_toolkit)
SQL> @?/rdbms/admin/owminst.plb ; (建工作空间管理相关对象,如dmbs_wm)
SQL> spool off
执行完后检查/orahome/cat.log看看有什么不可接受的错误没有。
7、 新建sqlplus属性和帮助、USERS表空间为默认表空间
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 datafile '/oracle/app/oradata/erdb/user01.dbf' size 50m extent management local segment space management auto;
SQL> alter database default tablespace users;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30024909/viewspace-1335337/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30024909/viewspace-1335337/