Oracle之DBCA中看不到已啟動instance與處理方法

來源:互聯網
上載者:User

Oracle之DBCA中看不到已啟動instance與處理方法

一、問題描述:單位一套測試Oracle資料庫,本想用DBCA看看資料庫配置資訊,當然也是手閑得慌,誰想到竟然出現下面的畫面。建立新的資料,設定資料庫操作按鍵是灰色,不讓點擊。這是什麼情況,執行個體沒有啟動,不可能啊 ,剛剛還登入過呢。好吧,開始處理過程之旅。

二、處理方法:

1. 檢查/etc/oratab檔案 ,發現關於路徑的資訊都是之前安裝的ORACLE軟體目錄(/u01/.....)與現在的軟體目錄(/home/oracle/app/.....)不一致。

修改前:

[oracle@tora01 etc]$ cat oratab
#

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

# and updated by either Database Configuration Assistant while creating

# a database or ASM Configuration Assistant while creating ASM instance.

# 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::

#

# 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.

#

#

holytest:/u01/app/oracle/product/11.2.0/db_1:N

修改後:

[oracle@tora01 etc]$ cat oratab

#

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

# and updated by either Database Configuration Assistant while creating

# a database or ASM Configuration Assistant while creating ASM instance.

# 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::

#

# 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.

#

#

holytest:/home/oracle/app/oracle/product/11.2.0/dbhome_1:N

2. 再次啟動DBCA進行驗證,發現恢複正常

三、總結:一次小小的發現,對oratab檔案的瞭解又深入了一點點。該檔案最後那個N,如果你需要資料自動啟動的話,要改為Y,這些都是經驗啊,還要繼續努力學習。

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.