oracle 12c手工建库

一、删除原有的库

先关闭数据库
[oracle@localhost ~]$ rm -rf /u01/app/oracle/oradata/orcl      //此时连接数据库为空
[oracle@localhost ~]$ rm -rf /u01/app/oracle/diag/rdbms/orcl
[oracle@localhost ~]$ rm -rf /u01/app/oracle/cfgtoollogs/dbca/orcl
[oracle@localhost ~]$ rm -rf /u01/app/oracle/admin/orcl
[oracle@localhost ~]$ rm -rf /u01/app/oracle/audit/orcl
[oracle@localhost ~]$ cd /u01/app/oracle/product/12.2.0/dbhome_1/dbs
[oracle@localhost dbs]$ rm -rf *orcl*
[oracle@localhost dbs]$ rm -rf lkORCL 
[oracle@localhost dbs]$ vim /etc/oratab    //删除下面这一行内容
orcl:/u01/app/oracle/product/12.2.0/dbhome_1/:N
[oracle@localhost dbs]$ find /u01/app/ -name *orcl*   //删掉所有orcl相关的文件
..........
[oracle@localhost dbs]$ rm -rf /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/log/orcl*
[oracle@localhost dbs]$ rm -rf /u01/app/oracle/product/12.2.0/dbhome_1/rdbms/audit/orcl*
[oracle@localhost dbs]$ rm -rf /u01/app/oracle/product/12.2.0/dbhome_1/apex/images/*orcl*

二、手工建库

1.创建参数文件

[oracle@localhost dbs]$ cd $ORACLE_HOME/dbs
[oracle@localhost dbs]$ vim inittestdb.ora  //写入如下内容
db_name=testdb
control_files=/u01/app/oracle/oradata/testdb/control01.ctl
sga_target=500M

2.创建控制文件及对象

[oracle@localhost dbs]$ cd /u01/app/oracle/oradata/
[oracle@localhost oradata]$ mkdir testdb

[oracle@localhost ~]$ vim cont.sql   //生成控制文件，写入下列内容
CREATE DATABASE testdb
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/testdb/redo01a.log','/u01/app/oracle/oradata/testdb/redo01b.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/u01/app/oracle/oradata/testdb/redo02a.log','/u01/app/oracle/oradata/testdb/redo02b.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/u01/app/oracle/oradata/testdb/redo03a.log','/u01/app/oracle/oradata/testdb/redo03b.log') SIZE 100M BLOCKSIZE 512
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/app/oracle/oradata/testdb/system01.dbf'
  SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SYSAUX DATAFILE '/u01/app/oracle/oradata/testdb/sysaux01.dbf'
  SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TABLESPACE users
   DATAFILE '/u01/app/oracle/oradata/testdb/users01.dbf'
   SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
   TEMPFILE '/u01/app/oracle/oradata/testdb/temp01.dbf'
   SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE undotbs1
   DATAFILE '/u01/app/oracle/oradata/testdb/undotbs01.dbf'
   SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

启动数据库

[oracle@localhost ~]$ export ORACLE_SID=testdb
[oracle@localhost ~]$ sqlplus / as sysdba
SQL> startup
SQL> @cont.sql

查看实例

3. 初始化数据字典

[oracle@localhost ~]$ vim init_db.sql  
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

进入数据库开始初始化

SQL> @init_db.sql

出现下图即表示初始化完成

 查看实例