各位大侠:
小弟是oracle初学者,在hp-unix上安装oracle时出现一个错误,请各位大侠帮忙。
hp-unix B.11.23 U 64位 16C 48G内存 安装oracle 10.2.0.1.0版本数据库。在安装到configuragion assistant页面时,第二项出现(应该是在dbca创建数据库时)一个错误:
ORA-3113 "end of file on communication channel"查看安装日志中提示:
System parameters with non-default values:
processes = 150
sga_target = 15418261504
control_files = /oracle/app/oracle/oradata/dm/control01.ctl, /oracle/app/oracle/oradata/dm/control02.ctl, /oracle/app/oracle/oradata/dm/control03.ctl
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /oracle/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=dmXDB)
job_queue_processes = 10
background_dump_dest = /oracle/app/oracle/admin/dm/bdump
user_dump_dest = /oracle/app/oracle/admin/dm/udump
core_dump_dest = /oracle/app/oracle/admin/dm/cdump
audit_file_dest = /oracle/app/oracle/admin/dm/adump
db_name = dm
open_cursors = 300
pga_aggregate_target = 5139070976
Sat Feb 27 16:53:54 2010
Errors in file /oracle/app/oracle/admin/dm/bdump/dm_pmon_19359.trc:
ORA-27061: waiting for async I/Os failed
PMON: terminating instance due to error 27061
Instance terminated by PMON, pid = 19359不知道此错误应该如何解决???此机器之前配置过双机也安装过oracle9206,不过我已经将安装的9206删除了,且已经清空了/etc和/tmp中关于oracle的内容。不知道是否与配置的双机有关???
小弟是oracle初学者,在hp-unix上安装oracle时出现一个错误,请各位大侠帮忙。
hp-unix B.11.23 U 64位 16C 48G内存 安装oracle 10.2.0.1.0版本数据库。在安装到configuragion assistant页面时,第二项出现(应该是在dbca创建数据库时)一个错误:
ORA-3113 "end of file on communication channel"查看安装日志中提示:
System parameters with non-default values:
processes = 150
sga_target = 15418261504
control_files = /oracle/app/oracle/oradata/dm/control01.ctl, /oracle/app/oracle/oradata/dm/control02.ctl, /oracle/app/oracle/oradata/dm/control03.ctl
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /oracle/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=dmXDB)
job_queue_processes = 10
background_dump_dest = /oracle/app/oracle/admin/dm/bdump
user_dump_dest = /oracle/app/oracle/admin/dm/udump
core_dump_dest = /oracle/app/oracle/admin/dm/cdump
audit_file_dest = /oracle/app/oracle/admin/dm/adump
db_name = dm
open_cursors = 300
pga_aggregate_target = 5139070976
Sat Feb 27 16:53:54 2010
Errors in file /oracle/app/oracle/admin/dm/bdump/dm_pmon_19359.trc:
ORA-27061: waiting for async I/Os failed
PMON: terminating instance due to error 27061
Instance terminated by PMON, pid = 19359不知道此错误应该如何解决???此机器之前配置过双机也安装过oracle9206,不过我已经将安装的9206删除了,且已经清空了/etc和/tmp中关于oracle的内容。不知道是否与配置的双机有关???
ORA-03113: end-of-file on communication channel
Cause: The connection between Client and Server process was broken.
Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.
你是手动删除Oracle的吗?可以尝试用dbca命令, 在界面上把已经安装的Oracle 删除掉。 在重新安装一下看看。 安装软件要确保没有问题先。
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
虽然在创建数据时,一直出现ora-04031的错误,但是对安装完之后,使用了几天发现也没有出现过问题。
现在想要把SGA调大,现在为500M,当调到大于1.7G时,发现oracle无法启动了。
又想办法把oracle启动之后,把SGA调到了1.5G,现在没有出现过问题。请问SGA应该如何设置,为什么我的不能大于1.7G