http://www.cndba.cn/dave/article/226
http://www.cndba.cn/dave/article/226
在上篇中,我们看了11g中的手工建库:
Oracle 11g 单实例 中手工建库 示例
http://www.cndba.cn/dave/article/209
这篇我们看看12c中如何手工建库。
在12c中,建库之后需要执行脚本,那么在12c中也建议使用catcon.pl 脚本:
Oracle 12c 中推荐使用 catcon.pl 执行SQL脚本
http://www.cndba.cn/dave/article/225
下面看具体操作。
1 创建初始化文件
从其他环境上复制过来,修改一下。
http://www.cndba.cn/dave/article/226
[oracle@cndba.cn dbs]$ pwd
/u01/app/oracle/product/12.1.0/db_1/dbs[oracle@cndba.cn dbs]$ cp initdave.ora initanqing.ora[oracle@cndba.cn dbs]$ vim initanqing.ora[oracle@cndba.cn dbs]$ cat initanqing.ora
*.audit_file_dest='/u01/app/oracle/admin/anqing/adump'
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='/u01/app/oracle/oradata/anqing/control01.ctl','/u01/app/oracle/fast_recovery_area/anqing/control02.ctl'
*.db_block_size=8192
*.db_create_file_dest=''
*.db_domain=''
*.db_name='anqing'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4560m
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=anqingXDB)'
*.enable_pluggable_database=true
*.memory_target=546m
*.open_cursors=300
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'[oracle@cndba.cn dbs]$
2 创建相关目录
在pfile里出现的目录,都是我们需要创建的。
[oracle@cndba.cn dbs]$ mkdir -p /u01/app/oracle/oradata/anqing[oracle@cndba.cn dbs]$ mkdir -p /u01/app/oracle/fast_recovery_area/anqing[oracle@cndba.cn dbs]$ mkdir -p /u01/app/oracle/admin/anqing/adump[oracle@cndba.cn dbs]$ mkdir -p /u01/app/oracle/oradata/anqing/pdbseed
3 使用pfile 将DB启动到nomounthttp://www.cndba.cn/dave/article/226http://www.cndba.cn/dave/article/226
[oracle@cndba.cn dbs]$ export ORACLE_SID=anqing[oracle@cndba.cn dbs]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sat Nov 7 11:02:39 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 574619648 bytes
Fixed Size 2926904 bytes
Variable Size 440403656 bytes
Database Buffers 125829120 bytes
Redo Buffers 5459968 bytes
SQL>
4 执行创建脚本
CREATE DATABASE anqing
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/anqing/redo1.log') SIZE 50M BLOCKSIZE 512,
GROUP 2 ('/u01/app/oracle/oradata/anqing/redo2.log') SIZE 50M BLOCKSIZE 512,
GROUP 3 ('/u01/app/oracle/oradata/anqing/redo3.log') SIZE 50M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/app/oracle/oradata/anqing/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/app/oracle/oradata/anqing/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/anqing/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/anqing/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/u01/app/oracle/oradata/anqing/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
ENABLE PLUGGABLE DATABASE
SEED FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/anqing','/u01/app/oracle/oradata/anqing/pdbseed');
创建完成后检查文件:
http://www.cndba.cn/dave/article/226
http://www.cndba.cn/dave/article/226
[oracle@cndba.cn anqing]$ pwd
/u01/app/oracle/oradata/anqing[oracle@cndba.cn anqing]$ ll -lh
total 1.5G
-rw-r-----. 1 oracle oinstall 9.4M Nov 7 11:11 control01.ctl
drwxr-xr-x. 2 oracle oinstall 4.0K Nov 7 11:10 pdbseed
-rw-r-----. 1 oracle oinstall 51M Nov 7 11:10 redo1.log
-rw-r-----. 1 oracle oinstall 51M Nov 7 11:11 redo2.log
-rw-r-----. 1 oracle oinstall 51M Nov 7 11:09 redo3.log
-rw-r-----. 1 oracle oinstall 326M Nov 7 11:11 sysaux01.dbf
-rw-r-----. 1 oracle oinstall 326M Nov 7 11:11 system01.dbf
-rw-r-----. 1 oracle oinstall 21M Nov 7 11:10 temp01.dbf
-rw-r-----. 1 oracle oinstall 201M Nov 7 11:11 undotbs01.dbf
-rw-r-----. 1 oracle oinstall 501M Nov 7 11:11 users01.dbf[oracle@cndba.cn anqing]$
5 执行组件创建脚本
--建库完成后库会自动变成读写模式:
SQL> select name,open_mode,cdb from v$database;
NAME OPEN_MODE CDB
------------------ ---------------------------------------- ------
ANQING READ WRITE YES
SQL> col comp_name for a40
SQL> col version for a20
SQL> col status for a20
SQL> select comp_name,version,status from sys.dba_registry;
select comp_name,version,status from sys.dba_registry
*
ERROR at line 1:
ORA-00942: table or view does not exist
但是现在一个组件没有,所以相关的对象也没有,需要执行脚本来创建。
使用catcon.pl 执行catalog.sql 来创建数据字典:--约4分钟http://www.cndba.cn/dave/article/226
[oracle@cndba.cn dbs]$ cd $ORACLE_HOME/rdbms/admin[oracle@cndba.cn admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -u sys/oracle -s -e -d $ORACLE_HOME/rdbms/admin -b catalog1 catalog.sql
catcon: ALL catcon-related output will be written to catalog1_catcon_29563.lst
catcon: See catalog1*.log files for output generated by scripts
catcon: See catalog1_*.lst files for spool files, if any
catcon.pl: completed successfully[oracle@cndba.cn admin]$
使用catcon.pl 执行catproc.sql 来创建创建存储过程和包:--约26分钟http://www.cndba.cn/dave/article/226
[oracle@cndba.cn admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -u sys/oracle -s -e -d $ORACLE_HOME/rdbms/admin -b catproc1 catproc.sql
catcon: ALL catcon-related output will be written to catproc1_catcon_29689.lst
catcon: See catproc1*.log files for output generated by scripts
catcon: See catproc1_*.lst files for spool files, if any
catcon.pl: completed successfully
使用catcon.pl 执行pupbld.sql来创建SQLPLUS_PRODUCT_PROFILE表,并在表上建立相关的视图和同义词,如果不执行pupbld.sql,那么使用普通用户登录数据库时可能会出现User Profile information not loaded错误。
注意这里执行需要使用SYSTEM用户,不是SYS。
[oracle@cndba.cn admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -u system/oracle -s -e -d $ORACLE_HOME/sqlplus/admin -b pupbld1 pupbld.sql
catcon: ALL catcon-related output will be written to pupbld1_catcon_30333.lst
catcon: See pupbld1*.log files for output generated by scripts
catcon: See pupbld1_*.lst files for spool files, if any
catcon.pl: completed successfully
6 验证
SQL> col comp_name for a40
SQL> col version for a20
SQL> col status for a20
SQL> set lin 120
SQL> select comp_name,version,status from sys.dba_registry;
COMP_NAME VERSION STATUS
---------------------------------------- -------------------- --------------------
Oracle XML Database 12.1.0.2.0 LOADED
Oracle Database Catalog Views 12.1.0.2.0 LOADED
Oracle Database Packages and Types 12.1.0.2.0 LOADED
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
SQL> col name for a30
SQL> select con_id, name,open_mode from v$containers;
CON_ID NAME OPEN_MODE
---------- ------------------------------ --------------------
1 CDB$ROOT READ WRITE
2 PDB$SEED READ ONLY
SQL> set lin 120
SQL> col file_name for a50
SQL> select con_id,file_name from cdb_data_files order by 1;
CON_ID FILE_NAME
---------- --------------------------------------------------
1 /u01/app/oracle/oradata/anqing/system01.dbf
1 /u01/app/oracle/oradata/anqing/users01.dbf
1 /u01/app/oracle/oradata/anqing/undotbs01.dbf
1 /u01/app/oracle/oradata/anqing/sysaux01.dbf
手工创建完毕。http://www.cndba.cn/dave/article/226
版权声明:本文为博主原创文章,未经博主允许不得转载。