oracle体系架构---------手动建库_create database创建数据库失败,第一行出现错误-优快云博客

博主分享Oracle数据库手动建库过程。包括nomount阶段创建参数文件、修改控制文件路径，以及mount阶段创建口令文件、创建控制文件等。同时记录建库中出现的问题，如参数文件名称与数据库名称不一致、MEMORY_TARGET不支持等，并给出解决方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

oracle体系架构--------手动建库

大家好，我是爱分享的数据库萌小白，是一名大三的在校学生，我的专业是物联网工程，就在今年我选择了学习oracle数据库，这是我的第一篇文章。希望我的分享能对你有所帮助，后期我也会积极分享我的学习笔记的哦。喜欢我的可以关注我噢~

oracle手动建库

以下是我在创建
---------------第一阶段nomount阶段-------------------
1.创建参数文件-------->参考init.ora
①cd $KaTeX parse error: Expected group after '^' at position 63: \dotst.ora |grep -v ^̲# >initorcl100.\dots$ 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=‘ $ORACLEBASE/admin/orcl100/adump′audittrail=′db′dbblocksize=8192dbdomain=′′dbrecoveryfiledest=′ORACLE_BASE/admin/orcl100/adump' audit_trail ='db' db_block_size=8192 db_domain='' db_recovery_file_dest='$ ORACLE_BASE/flash_recovery_area’
db_recovery_file_dest_size=2G
diagnostic_dest=' $ORACLEBASE′dispatchers=′(PROTOCOL=TCP)(SERVICE=orcl100XDB)′opencursors=300remoteloginpasswordfile=′EXCLUSIVE′undotablespace=′UNDOTBS1′controlfiles=(ORACLE_BASE' dispatchers='(PROTOCOL=TCP) (SERVICE=orcl100XDB)' open_cursors=300 remote_login_passwordfile='EXCLUSIVE' undo_tablespace='UNDOTBS1' control_files = ($ ORACLE_BASE/oradata/$ORACLE_SID/control01.ctl, $ORACLE_BASE/oradata/$ ORACLE_SID/control02.ctl)
compatible =‘11.2.0’

 确认参数文件中的所有路径目录都存在

[oracle@localhost dbs]$ mkdir -p $ORACLE_BASE/admin/tq100/adump [oracle@localhost dbs]$ mkdir -p $ORACLE_BASE/flash_recovery_area [oracle@localhost dbs]$ 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