Oracle system identifier(SID) "xxx" alread exits. Specify another SID

简介:

案例环境:

               操作系统    :Oracle Linux Server release 5.7 64 bit

               数据库版本:Oracle Database 10g Release 10.2.0.4.0 - 64bit Production

案例介绍: 在一个刚刚安装实例的服务器,使用dbca创建新的数据库时,在指定全局数据库名(Global Database Name)后,点击下一步时。报如下错误:The Oracle system identifier(SID) "SCM2" alread exits. Specify another SID

 

clip_image001

 

 

clip_image002

出现这个错误,是因为在/etc /oratab文件中已经指定了$ORACLE_SID(上次删除数据库时,没有彻底清除/etc/oratab),此时只需要将SCM2:/u01 /app/oracle/product/10.2.0/db_1:N 这一行删除或注释即可。

[root@DB-Server ~]# more /etc/oratab

#

# This file is used by ORACLE utilities. It is created by root.sh

# and updated by the Database Configuration Assistant when creating

# a database.

# A colon, ':', is used as the field terminator. A new line terminates

# the entry. Lines beginning with a pound sign, '#', are comments.

#

# Entries are of the form:

# $ORACLE_SID:$ORACLE_HOME:<N|Y>:

#

# The first and second fields are the system identifier and home

# directory of the database respectively. The third filed indicates

# to the dbstart utility that the database should , "Y", or should not,

# "N", be brought up at system boot time.

#

# Multiple entries with the same $ORACLE_SID are not allowed.

#

#

SCM2:/u01/app/oracle/product/10.2.0/db_1:N

 

相关文章
|
SQL Oracle 安全
Oracle 修改SYS、system用户密码
Oracle 修改SYS、system用户密码
1951 0
|
存储 Oracle 关系型数据库
【数据库】解决 oracle: ORA-01653: unable to extend table *.LINEORDER by 1024 in tablespace SYSTEM
【数据库】解决 oracle: ORA-01653: unable to extend table *.LINEORDER by 1024 in tablespace SYSTEM
576 0
【数据库】解决 oracle: ORA-01653: unable to extend table *.LINEORDER by 1024 in tablespace SYSTEM
|
Oracle 关系型数据库 Linux
linux下oracle数据库由于参数文件丢失导致的数据库服务启动失败,报“failure in processing system parameters“错误问题解决
linux下oracle数据库由于参数文件丢失导致的数据库服务启动失败,报“failure in processing system parameters“错误问题解决
540 0
linux下oracle数据库由于参数文件丢失导致的数据库服务启动失败,报“failure in processing system parameters“错误问题解决
|
Oracle 关系型数据库 数据库
Oracle 数据库管理员SYS/SYSTEM密码忘记了,怎么破?
Oracle 数据库在创建之初,就默认有两个管理员用户,权限之大,无人能及,分别为 SYS/SYSTEM!
|
Oracle 关系型数据库 数据库
|
Oracle 关系型数据库 数据安全/隐私保护