ASMCMD +ASM 例項 Connected to an idle instance. 一個 / 導致的問題
[grid@bcc2 ~]$ sql
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 7 15:26:21 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> exit
Disconnected
[grid@bcc2 ~]$ vi .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export PATH
export ORACLE_SID=+ASM2
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.0//grid/ --多了一個 / 刪除並儲存
export JAVA_HOME=$ORACLE_HOME/jdk
export PATH=$ORACLE_HOME/bin:$JAVA_HOME/bin/:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
#export NLS_LANG=AMERICAN_AMERICA.ZHS16GB
alias sql='sqlplus / as sysasm'
~
~
~
".bash_profile" 22L, 494C written
[grid@bcc2 ~]$ sql
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 7 15:27:28 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> exit
Disconnected
[grid@bcc2 ~]$ . .bash_profile --重新生效
[grid@bcc2 ~]$ sql
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 7 15:27:38 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
有時候問題就發生在一個小的細節中,仔細的發現異常,沒有不可解的問題。
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 7 15:26:21 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> exit
Disconnected
[grid@bcc2 ~]$ vi .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export PATH
export ORACLE_SID=+ASM2
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.0//grid/ --多了一個 / 刪除並儲存
export JAVA_HOME=$ORACLE_HOME/jdk
export PATH=$ORACLE_HOME/bin:$JAVA_HOME/bin/:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
#export NLS_LANG=AMERICAN_AMERICA.ZHS16GB
alias sql='sqlplus / as sysasm'
~
~
~
".bash_profile" 22L, 494C written
[grid@bcc2 ~]$ sql
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 7 15:27:28 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> exit
Disconnected
[grid@bcc2 ~]$ . .bash_profile --重新生效
[grid@bcc2 ~]$ sql
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 7 15:27:38 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
有時候問題就發生在一個小的細節中,仔細的發現異常,沒有不可解的問題。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26474945/viewspace-1393509/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- asmcmd:connected to an idle instance ORA12705ASM
- 通過asmcmd進入asm例項時可能會遇到的一些問題ASM
- asm例項自動dismount導致rac一個節點當機ASM
- asmcmd的一個問題ASM
- (原創)windowns系統下 透過asmcmd進入asm例項時可能會遇到的一些問題ASM
- ASM例項出現ORA-4031錯誤導致例項崩潰ASM
- 【RAC】處理因ASM例項異常導致RAC第一節點例項異常終止故障ASM
- oracle10.2.0.1 (rhel4)rac刪除asm例項不乾淨導致重建asm例項出錯OracleASM
- MySQL Case-時間問題導致MySQL例項批次當機MySql
- 【RAC】因清理不完整導致RAC ASM例項建立失敗ASM
- 【問題處理】因ASM磁碟組空間不足導致資料庫例項無法啟動的故障處理ASM資料庫
- 15、MySQL Case-時間問題導致MySQL例項批次當機MySql
- ASM例項出現ORA-04031導致Instance terminated by ASMBASM
- 【asmcmd】使用asmcmd工具管理ASMASM
- 修改系統時間導致RAC環境的一個例項重啟
- oracle asm asmcmdOracleASM
- ASM工具asmcmdASM
- ASMCMD處理問題一則ASM
- 請教一個關於JdonFrameworkTest例項的問題Framework
- Connected to an idle instance – while database is runningWhileDatabase
- 一個拷貝操作導致的潛在監聽類問題
- 一個簡單的MySQL引數導致的連線問題解惑MySql
- 有關修改作業系統時間導致例項down掉的一個案例作業系統
- 【ASM】ASMCMD cp 命令ASM
- ASM之建立ASM例項ASM
- 【ASM】ASMCMD chtmpl 更改ASM 模版的屬性ASM
- rac環境 asmcmd用法;首先設定oracle_home oracle_sid(asm例項)ASMOracle
- 通過驗證訪問ASM例項ASM
- 單例項刪除ASM例項單例ASM
- 管理 ASM 例項ASM
- 停止ASM例項ASM
- ANALYZE導致的阻塞問題分析
- MySQL Flush導致的等待問題MySql
- IP地址被清空導致例項重啟
- 最近遇到的RAC的一個例項無法連線的問題
- oracle:一臺主機多個例項,sqlplus 預設連線到哪個例項的問題OracleSQL
- 一次oracle行級鎖導致的問題Oracle
- 問一個基礎的用例問題?