导航：首页 > 数据库 >

oracle11g手工建库

发表于：2025-01-20 作者：千家信息网编辑

千家信息网最后更新 2025年01月20日，1.设置环境变量[oracle@HE3~]$ vi .bash_profileexportPATHexportEDITOR=viexportORACLE_SID=orclexportORACLE_BA

千家信息网最后更新 2025年01月20日oracle11g手工建库

1.设置环境变量

[oracle@HE3~]$ vi .bash_profile

exportPATHexportEDITOR=viexportORACLE_SID=orclexportORACLE_BASE=/u01/app/oracleexportORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1exportnls_date_format="yyyy-mm-dd hh34:mi:ss"exportPATH=/u01/app/oracle/product/11.2.0/dbhome_1/bin:$PATHexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib#aliassqlplus='rlwrap sqlplus'#aliasrman='rlwrap rman'exportNLS_LANG=AMERICAN_AMERICA.ZHS16GBK

[oracle@HE3 ~]$ source .bash_profile

2.准备密码文件及初始化参数文件和创建数据库脚本

[oracle@HE3~]$ cd $ORACLE_HOME/dbs

[oracle@HE3dbs]$ ls

hc_orcl.dat init.ora initorcl.ora lkORCL

[oracle@HE3dbs]$ orapwd file=orapwdorcl password=oracle entries=30

[oracle@HE3dbs]$ ls

hc_orcl.dat init.ora initorcl.ora lkORCL orapwdorcl

[oracle@HE3 dbs]$ vi initorcl.ora

diagnostic_dest='/u01/app/oracle' db_name='orcl' memory_target=512M 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=512M diagnostic_dest='/u01/app/oracle' open_cursors=300 remote_login_passwordfile='EXCLUSIVE' undo_tablespace='UNDOTBS1' control_files=(/u01/app/oracle/oradata/orcl/control01.ctl,/u01/app/oracle/oradata/orcl/control02.ctl) compatible='11.2.0'

3.准备创建数据库需要的相关目录

[oracle@HE3dbs]$ mkdir -p /u01/app/oracle/admin/orcl/adump/

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

[oracle@HE3dbs]$ mkdir -p /u01/app/oracle/oradata/orcl

[oracle@HE3dbs]$ ls

hc_orcl.dat init.ora initorcl.ora lkORCL orapwdorcl

4.开始手工建库

[oracle@ENMOEDU ENMOEDU]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 10 00:39:10 2014

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> startup nomount

ORACLE instance started.

Total System Global Area 1071333376 bytes

Fixed Size 1349732 bytes

Variable Size 620758940 bytes

Database Buffers 444596224 bytes

Redo Buffers 4628480 bytes

[oracle@HE3~]$ vi create_db.sql

CREATEDATABASE orcl   USER SYS IDENTIFIED BY oracle   USER SYSTEM IDENTIFIED BY oracle   LOGFILE GROUP 1('/u01/app/oracle/oradata/orcl/redo01a.log','/u01/app/oracle/oradata/orcl/redo01b.log')SIZE 50M BLOCKSIZE 512,                  GROUP 2('/u01/app/oracle/oradata/orcl/redo02a.log','/u01/app/oracle/oradata/orcl/redo02b.log')SIZE 50M BLOCKSIZE 512,                  GROUP 3('/u01/app/oracle/oradata/orcl/redo03a.log','/u01/app/oracle/oradata/orcl/redo03b.log')SIZE 50M BLOCKSIZE 512          MAXLOGFILES 5   MAXLOGMEMBERS 5   MAXLOGHISTORY 1   MAXDATAFILES 100   CHARACTER SET ZHS16GBK   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 MAXSIZEUNLIMITED   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 MAXSIZEUNLIMITED;

[oracle@HE3~]$ tail -100f /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log

SQL>@/home/oracle/create_db.sql

Databasecreated.

SQL>@?/rdbms/admin/catalog.sql ----------------------------创建数据字典

……

PL/SQLprocedure successfully completed.

TIMESTAMP

--------------------------------------------------------------------------------

COMP_TIMESTAMPCATALOG 2016-01-26 00:07:42

SQL> @?/rdbms/admin/catproc.sql-----------------------------创建存储过程和数据库的包

......

SQL>