oracle体系架构--------手动建库
大家好,我是爱分享的数据库萌小白,是一名大三的在校学生,我的专业是物联网工程,就在今年我选择了学习oracle数据库 ,这是我的第一篇文章。希望我的分享能对你有所帮助,后期我也会积极分享我的学习笔记的哦。喜欢我的可以关注我噢~
oracle手动建库
以下是我在创建
---------------第一阶段nomount阶段-------------------
1.创建参数文件-------->参考init.ora
①cd KaTeX parse error: Expected group after '^' at position 63: …t.ora |grep -v ^̲# >initorcl100.…ORACLE_BASE#gi
修改控制文件路径:$ORACLE_BASE/oradata/ORACLE_SID/control01.ctl
$ORACLE_BASE/oradata/ORACLE_SID/control02.ctl
db_name=‘orcl100’
memory_target=800M
processes = 150
audit_file_dest=‘
O
R
A
C
L
E
B
A
S
E
/
a
d
m
i
n
/
o
r
c
l
100
/
a
d
u
m
p
′
a
u
d
i
t
t
r
a
i
l
=
′
d
b
′
d
b
b
l
o
c
k
s
i
z
e
=
8192
d
b
d
o
m
a
i
n
=
′
′
d
b
r
e
c
o
v
e
r
y
f
i
l
e
d
e
s
t
=
′
ORACLE_BASE/admin/orcl100/adump' audit_trail ='db' db_block_size=8192 db_domain='' db_recovery_file_dest='
ORACLEBASE/admin/orcl100/adump′audittrail=′db′dbblocksize=8192dbdomain=′′dbrecoveryfiledest=′ORACLE_BASE/flash_recovery_area’
db_recovery_file_dest_size=2G
diagnostic_dest='
O
R
A
C
L
E
B
A
S
E
′
d
i
s
p
a
t
c
h
e
r
s
=
′
(
P
R
O
T
O
C
O
L
=
T
C
P
)
(
S
E
R
V
I
C
E
=
o
r
c
l
100
X
D
B
)
′
o
p
e
n
c
u
r
s
o
r
s
=
300
r
e
m
o
t
e
l
o
g
i
n
p
a
s
s
w
o
r
d
f
i
l
e
=
′
E
X
C
L
U
S
I
V
E
′
u
n
d
o
t
a
b
l
e
s
p
a
c
e
=
′
U
N
D
O
T
B
S
1
′
c
o
n
t
r
o
l
f
i
l
e
s
=
(
ORACLE_BASE' dispatchers='(PROTOCOL=TCP) (SERVICE=orcl100XDB)' open_cursors=300 remote_login_passwordfile='EXCLUSIVE' undo_tablespace='UNDOTBS1' control_files = (
ORACLEBASE′dispatchers=′(PROTOCOL=TCP)(SERVICE=orcl100XDB)′opencursors=300remoteloginpasswordfile=′EXCLUSIVE′undotablespace=′UNDOTBS1′controlfiles=(ORACLE_BASE/oradata/$ORACLE_SID/control01.ctl,
O
R
A
C
L
E
B
A
S
E
/
o
r
a
d
a
t
a
/
ORACLE_BASE/oradata/
ORACLEBASE/oradata/ORACLE_SID/control02.ctl)
compatible =‘11.2.0’
确认参数文件中的所有路径目录都存在
[oracle@localhost dbs]$ mkdir -p
O
R
A
C
L
E
B
A
S
E
/
a
d
m
i
n
/
t
q
100
/
a
d
u
m
p
[
o
r
a
c
l
e
@
l
o
c
a
l
h
o
s
t
d
b
s
]
ORACLE_BASE/admin/tq100/adump [oracle@localhost dbs]
ORACLEBASE/admin/tq100/adump[oracle@localhostdbs] mkdir -p
O
R
A
C
L
E
B
A
S
E
/
f
l
a
s
h
r
e
c
o
v
e
r
y
a
r
e
a
[
o
r
a
c
l
e
@
l
o
c
a
l
h
o
s
t
d
b
s
]
ORACLE_BASE/flash_recovery_area [oracle@localhost dbs]
ORACLEBASE/flashrecoveryarea[oracle@localhostdbs] mkdir -p $ORACLE_BASE/oradata/ORACLE_SID
⑥export ORACLE_SID=tq100
sqlplus / as sysdba
出现如下问题:
SQL> startup nomount
ORA-01078: failure in processing system parameters
LRM-00109: ??? ‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/inittq100.ora’
解决方法:参数文件名称要跟数据库名称一致
ORA-00845: MEMORY_TARGET not supported on this system
解决方法:将参数文件中的MEMORY_IAGRET调小
重新startup nomount
-----------------------------第二阶段mount阶段------------------------------
1.创建口令文件
在cd $ORACLE_HOME/dbs下创建
orapwd file=orapwtq100 password=tq100 entries=10
2.控制文件+数据文件+日志文件----->参照官方文档一次性全部创建
vim cdb.sql
CREATE DATABASE orcl100
2 USER SYS IDENTIFIED BY sys_password
3 USER SYSTEM IDENTIFIED BY system_password
4 LOGFILE GROUP 1 (’/u01/app/oracle/oradata/orcl100/redo01a.log’) SIZE 100M BLOCKSIZE 512,
5 GROUP 2 (’/u01/app/oracle/oradata/orcl100/redo02a.log’) SIZE 100M BLOCKSIZE 512,
6 GROUP 3 (’/u01/app/oracle/oradata/orcl100/redo03a.log’) SIZE 100M BLOCKSIZE 512
7 MAXLOGFILES 5
8 MAXLOGMEMBERS 5
9 MAXLOGHISTORY 1
10 MAXDATAFILES 100
11 CHARACTER SET AL32UTF8
12 NATIONAL CHARACTER SET AL16UTF16
13 EXTENT MANAGEMENT LOCAL
14 DATAFILE ‘/u01/app/oracle/oradata/orcl100/system01.dbf’ SIZE 325M REUSE
15 SYSAUX DATAFILE ‘/u01/app/oracle/oradata/orcl100/sysaux01.dbf’ SIZE 325M REUSE
16 DEFAULT TABLESPACE users
17 DATAFILE ‘/u01/app/oracle/oradata/orcl100/users01.dbf’
18 SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
19 DEFAULT TEMPORARY TABLESPACE tempts1
20 TEMPFILE ‘/u01/app/oracle/oradata/orcl100/temp01.dbf’
21 SIZE 20M REUSE
22 UNDO TABLESPACE undotbs1
23 DATAFILE ‘/u01/app/oracle/oradata/orcl100/undotbs01.dbf’
24 SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
sqlplus / as sysdba
startup nomount
@/home/oracle/cdb.sql
SYS@连接到DB:orcl100>@/home/oracle/cdb.sql
CREATE DATABASE orcl100
*
第 1 行出现错误:
ORA-01501: CREATE DATABASE ??
ORA-00200: ???
ORA-00202: ???: ‘’/u01/app/oracle/oradata/orcl100/control01.ctl’’
ORA-27040: ???, ???
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
SYS@连接到DB:orcl100>exit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
[oracle@localhost ~]$ vim cdb.sql
[oracle@localhost ~]$ mkdir -p /u01/app/oracle/oradata/orcl100
重新启动
startup nomount
@/home/oracle/cdb.sql
运行四个脚本
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql 报错正常
@?/rdbms/admin/utlrp.sql
conn system/orcl100
@?/sqlplus/admin/pupbld.sql
以下是手工建库过程中的常见问题
以上就是小编给大家第一期分享的内容了,有什么不懂得欢迎评论问题哦。有问必答哦。嘻嘻,希望能对大家有所帮助~