在之前的博客我们介绍了手工创建Oracle 实例的方法，如下：

Oracle 11g 单实例 中手工建库 示例
http://www.cndba.cn/dave/article/209http://www.cndba.cn/dave/article/4274http://www.cndba.cn/dave/article/4274

在创建过程中发现一个新的错误，如下：

[oracle@www.cndba.cn ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Oct 15 19:02:12 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 5344731136 bytes
Fixed Size                  2262656 bytes
Variable Size            2885683584 bytes
Database Buffers         2449473536 bytes
Redo Buffers                7311360 bytes
SQL> CREATE DATABASE cndba
  2  USER SYS IDENTIFIED BY cndba
USER SYSTEM IDENTIFIED BY cndba
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/cndba/redo1.log') SIZE 200M BLOCKSIZE 512,
  3    4    5          GROUP 2 ('/u01/app/oracle/oradata/cndba/redo2.log') SIZE 200M BLOCKSIZE 512,
        GROUP 3 ('/u01/app/oracle/oradata/cndba/redo3.log') SIZE 200M 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/cndba/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/app/oracle/oradata/cndba/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
   DATAFILE '/u01/app/oracle/oradata/cndba/users01.dbf'
   SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
   TEMPFILE '/u01/app/oracle/oradata/cndba/temp01.dbf'
   SIZE 20M REUSE
UNDO TABLESPACE undotbs1
   DATAFILE '/u01/app/oracle/oradata/cndba/undotbs01.dbf'
   SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; 
CREATE DATABASE cndba
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01101: database being created currently mounted by some other instance

这里报ORA-01101的错误，实际上这里是一个全新的环境，不存在这里错误的问题：http://www.cndba.cn/dave/article/4274

ORA-01501: CREATE DATABASE failed
ORA-01101: database being created currently mounted by some other instancehttp://www.cndba.cn/dave/article/4274

http://www.cndba.cn/dave/article/4274

实际上导致这个错误的原因在$ORACLE_HOME/dbs 目录下，因为我是直接将其他环境的dbs中的文件复制过来的，这里包含了2个文件：hc_cndba.dat 和 lkcndba。 我们删除这2个文件后，在重新执行，就没有报错了。http://www.cndba.cn/dave/article/4274

[oracle@www.cndba.cn ~]$ cd /u01/app/oracle/oradata/cndba/
[oracle@www.cndba.cn cndba]$ ls
[oracle@www.cndba.cn cndba]$ cd $ORACLE_HOME/dbs
[oracle@www.cndba.cn dbs]$ ls
hc_cndba.dat  initcndba.ora  init.ora  lkcndba
[oracle@www.cndba.cn dbs]$ rm -rf hc_cndba.dat
[oracle@www.cndba.cn dbs]$ rm -rf lkcndba
[oracle@www.cndba.cn dbs]$ ls
initcndba.ora  init.ora
[oracle@www.cndba.cn dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Oct 15 19:03:52 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> CREATE DATABASE cndba
USER SYS IDENTIFIED BY cndba
USER SYSTEM IDENTIFIED BY cndba
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/cndba/redo1.log') SIZE 200M BLOCKSIZE 512,
        GROUP 2 ('/u01/app/oracle/oradata/cndba/redo2.log') SIZE 200M BLOCKSIZE 512,
        GROUP 3 ('/u01/app/oracle/oradata/cndba/redo3.log') SIZE 200M 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/cndba/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/app/oracle/oradata/cndba/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
   DATAFILE '/u01/app/oracle/oradata/cndba/users01.dbf'
   SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
   TEMPFILE '/u01/app/oracle/oradata/cndba/temp01.dbf'
   SIZE 20M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/u01/app/oracle/oradata/cndba/undotbs01.dbf'
   SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; 

Database created.

SQL>

版权声明：本文为博主原创文章，未经博主允许不得转载。