ORACLE not available,oracleavailable

來源:互聯網
上載者:User

ORACLE not available,oracleavailable
錯誤具體描述:ERROR:ORA-01034: ORACLE not availableORA-27101: shared memory realm does not exist進程 ID: 0會話 ID: 0 序號: 0

 

解決方式:

1.執行

[oracle@AY140316135826Z admin]$ sqlplus 'sys/Hello54987663@localhost:1521/orcl as sysdba'

 

2.執行:

SQL>startup

 

3.測試一下:

SQL>select * from user_tables;

ok顯示除了很多結果!

 

此時tnsnames.ora內容:

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.orcl =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    (CONNECT_DATA =      (SID = orcl)    )  )    


listener.ora內容:

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    )  )SID_LIST_LISTENER=  (SID_LIST=(SID_DESC=         (GLOBAL_DBNAME=orcl)         (SID_NAME=orcl)         (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/)       )      )


 

 

附錄:

oracle監聽啟動執行:

lsnrctl start


ORA-01034: ORACLE not available

正常,有時候虛擬機器在重啟後會不儲存你之前安裝的東西,偶爾會碰到,節哀,重裝。當然啊了如果你安裝的東西都在(特指oracle軟體),那麼檢查你的環境變數配置,這個錯誤大多是環境變數不對引起的。
 
oracle not available是什情況

你安裝的時候,是不是選擇了"僅安裝軟體" 這個選項?
一般這種報錯 , 是因為沒有建庫。
點擊 “開始” -> "所有程式" -> “Oracle-Db11g_home” -> "配置和移植工具"> "Database configuration Assistant (DBCA)" , 進入DBCA工具介面後,選擇“建立一個資料庫” 。按要求一步一步點擊“下一步”,最後點“完成”。
建立好資料庫後,就不會有這個報錯了。
 

相關文章

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.