台灣最大程式設計社群網站
線上人數
464
 
會員總數:245791
討論主題:189424
歡迎您免費加入會員
討論區列表 >> Oracle >> 用VMware跑linux+oracle11g出現的錯誤訊息.
[]  
[我要回覆]
1
回應主題 加入我的關注話題 檢舉此篇討論 將提問者加入個人黑名單
用VMware跑linux+oracle11g出現的錯誤訊息.
價值 : 100 QP  點閱數:2264 回應數:3
樓主

hongi
門外漢
0 1
13 1
發送站內信

請問一下
我現在在學oracle 11g
教學環境是在VMware的環境下跑linux + oracle 11g
在教室電腦(XP)用都很正常
但相關VM檔案在我電腦(vista 32bits)上面跑就出現問題
在startup或shutdown資料庫時會出現下列錯誤訊息:
SQL>startup
ORA-24324:service handle not initialized
ORA-24323:value not allowed
ORA-03113:end-of-file on communication channel
請問為何會這樣?該如何解決呢?
謝謝各位的幫忙~~

搜尋相關Tags的文章: [ oracle ] , [ 資料庫 ] , [ vm ] , [ linux ] ,
本篇文章發表於2011-06-29 23:25
1樓
回應

花旗蔘
檢舉此回應
先po 一下 相關的alert log的訊息吧!

我猜可能是 spfile/pfile 的問題

startup nomount
如果ok

alter database mount
還是ok
alter database open

看是那一階段的問題!!

先try try

本篇文章回覆於2011-06-30 10:17
== 簽名檔 ==
--未登入的會員無法查看對方簽名檔--
2樓
作者回應

hongi
檢舉此回應
先謝謝您的回應

它是連startup nomount都會出現一樣的錯誤

以下是alert log的內容
麻煩您了~
Thu Jun 30 23:22:16 2011
Trace dumping is performing id=[cdmp_20110630232216]
Thu Jun 30 23:22:20 2011
Sweep [inc][13388]: completed
Sweep [inc2][13388]: completed
Thu Jun 30 23:22:33 2011
License high water mark = 1
USER (ospid: 18017): terminating the instance
Instance terminated by USER, pid = 18017
Thu Jun 30 23:22:55 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /oracle/db11g/dbs/spfileorcl.ora
System parameters with non-default values:
processes = 150
memory_target = 352M
control_files = "/oracle/oradata/orcl/control01.ctl"
control_files = "/oracle/flash_recovery_area/orcl/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "/oracle/flash_recovery_area"
db_recovery_file_dest_size= 3852M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
audit_file_dest = "/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
open_cursors = 300
sec_max_failed_login_attempts= 5
diagnostic_dest = "/oracle"
Thu Jun 30 23:22:58 2011
PMON started with pid=2, OS id=18094
Thu Jun 30 23:22:58 2011
VKTM started with pid=3, OS id=18096 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Jun 30 23:22:58 2011
GEN0 started with pid=4, OS id=18100
Thu Jun 30 23:22:58 2011
DIAG started with pid=5, OS id=18102
Thu Jun 30 23:22:58 2011
DBRM started with pid=6, OS id=18104
Thu Jun 30 23:22:59 2011
PSP0 started with pid=7, OS id=18106
Thu Jun 30 23:22:59 2011
DIA0 started with pid=8, OS id=18108
Thu Jun 30 23:22:59 2011
MMAN started with pid=9, OS id=18110
Thu Jun 30 23:22:59 2011
DBW0 started with pid=10, OS id=18112
Thu Jun 30 23:22:59 2011
LGWR started with pid=11, OS id=18114
Thu Jun 30 23:22:59 2011
CKPT started with pid=12, OS id=18116
Thu Jun 30 23:22:59 2011
SMON started with pid=13, OS id=18118
Thu Jun 30 23:22:59 2011
RECO started with pid=14, OS id=18120
Thu Jun 30 23:22:59 2011
MMON started with pid=15, OS id=18122
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Jun 30 23:22:59 2011
MMNL started with pid=16, OS id=18124
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle
Thu Jun 30 23:23:00 2011
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x68747541] [PC:0x27A35E, {empty}] [flags: 0x0, count: 1]
Errors in file /oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_18132.trc (incident=14588):
ORA-07445: exception encountered: core dump [PC:0x27A35E] [SIGSEGV] [ADDR:0x68747541] [PC:0x27A35E] [Address not mapped to object] []
Incident details in: /oracle/diag/rdbms/orcl/orcl/incident/incdir_14588/orcl_ora_18132_i14588.trc
Thu Jun 30 23:23:03 2011
Sweep [inc][14588]: completed
Trace dumping is performing id=[cdmp_20110630232303]
本篇文章回覆於2011-06-30 23:27
== 簽名檔 ==
--未登入的會員無法查看對方簽名檔--
3樓
回應

花旗蔘
檢舉此回應
sorry~ 忘了有回應過,現在才想起 哈~

1、
先去看看 這兩個trace file裡對應的error訊息 po上來看看
/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_18132.trc
/oracle/diag/rdbms/orcl/orcl/incident/incdir_14588/orcl_ora_18132_i14588.trc

2、你是用pfile 還是spfile 啟動?
把pfile/spfile的內容 PO上來看看
若是SPFILE的話
先create pfile='完整路徑檔名" from spfile

3、pfile/spfile 預設是放在在/$ORACLE_HOME/dbs
win的話在\%ORACLE_HOME%\database 下,
裡面應該會有一些 舊的pfile 備份 找個來啟動看看
ex:
SQL> startup pfile='D:\app\Administrator\product\11.2.0\dbhome_1122\database\initORCL11Gben.ora'

本篇文章回覆於2011-07-08 09:48
== 簽名檔 ==
--未登入的會員無法查看對方簽名檔--
   
1

回覆
如要回應,請先登入.