遇到这样一个情况,之前做过将/u01/app/Oracle下所有文件拷备、还原的操作,现在想删除已存在的数据库时,发现dbca中delete database选项是灰色的。但实际是存在一个数据库的,因此我怀疑是配置文件没有匹配的原因。在网上找了些看,看到有说直接修改/etc/oratab内容就可以的,实际操作后也可以:以下为/etc/oratab中的原始内容:
$ cat /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.
#
#
# *:/u01/app/oracle/product/9.2:N
# *:/u01/app/oracle/product/9.2:N
# *:/u01/app/oracle/product/9.2:N
# *:/u01/app/oracle/product/9.2:N
# *:/u01/app/oracle/product/9.2:N
# *:/u01/app/oracle/product/9.2:N
# *:/u01/app/oracle/product/9.2:N
*:/u01/app/oracle/product/9.2:N只需要将最后一条前面的*号改成你所想删除的ORACLE_SID即可。更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12Oracle数据库使用NFS存储,启动报错提示无法锁定文件Oracle的SQL Tuning Advisor(STA) 到底做了什么?相关资讯 DBCA
- DBCA出错:ORA-19809: limit (10/27/2015 19:41:29)
- 如何不使用DBCA在Oracle 11中删除 (12/21/2014 17:32:23)
- Oracle 11g使用DBCA以非交互(静默) (04/09/2014 17:08:33)
| - DBCA创建数据库出现RPCR-1071, (01/11/2015 08:07:48)
- Oracle 使用DBCA安装数据库出现错 (08/08/2014 11:14:42)
- 运行DBCA Exception in thread “ (10/28/2013 17:46:41)
|
本文评论 查看全部评论 (0)