数据库版本:oracle 8.1.7.0.0
os: HU-UX11.0
用sysdba角色的用户进入,执行startup 提示:
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel这是什么问题呢?
os: HU-UX11.0
用sysdba角色的用户进入,执行startup 提示:
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel这是什么问题呢?
解决方案 »
- 解决OracleDBConsoleorcl服务无法启动问题
- 求一天中每小时的数据量-----这个SQL如何写,请牛人提供思路。
- 如何根据周数和年份算出该周的第一天的日期?
- 求一句SQL语句的写法
- 请教一个oracle怪异问题(在google上都没能搜到)
- 这个SQL该如何写?
- 请指教一个修改记录的问题!!!急!!!
- oracle 怎么实现bulk insert 方法?
- 请问在ORACLE中如何列出所有用户创建的表存储过程等?
- 小白求简略说明一下Oracle APEX 怎样进行开发?我想做一个和sample差不多的应用程序
- 想考“数据库应用技术”方向的研究生,请问这个方向的研究生?
- 用crontabl自动执行exp为何出错?
然后再mount
open
单步走一下
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel
连启动到nomount 状态都不行,所以我觉得要么是os的守护进程有问题,要么是init文件有问题,大家往这个思路上多想想。
试试
arch1_65886.dbf arch1_65900.dbf core
arch1_65887.dbf arch1_65901.dbf init.ora
arch1_65888.dbf arch1_65902.dbf init.ora.old
arch1_65889.dbf arch1_65903.dbf initdw.ora
arch1_65890.dbf arch1_65904.dbf initest.ora
arch1_65891.dbf arch1_65905.dbf initora817.ora
arch1_65892.dbf arch1_65906.dbf initora817.ora.96
arch1_65893.dbf arch1_65907.dbf lkO817
arch1_65894.dbf arch1_65908.dbf lkORA817
arch1_65895.dbf arch1_65909.dbf lumbak510426764_s4_p1
arch1_65896.dbf arch1_65910.dbf orapwora817
arch1_65897.dbf arch1_65911.dbf parameter.lst
arch1_65898.dbf arch1_65912.dbf snapcf_ora817.f
arch1_65899.dbf arch1_65913.dbf
62 cqxxj2/usr1/ora817/product/8.1.7/dbs:>sqlplusSQL*Plus: Release 8.1.7.0.0 - Production on 星期五 1月 30 15:21:09 2004(c) Copyright 2000 Oracle Corporation. All rights reserved.Enter user-name: internal
Connected to an idle instance.SQL> startup nomount pfile=/usr1/ora817/product/8.1.7/dbs/init.ora
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel
另外不排除oracle的bug. 你如果有metalink的帐号,可以进入搜索一下,有专门的文章.
我在console上试了一下,还是不行,是不是可以认为和网络没有关系了呢,另外,这个数据库在春节前还在使用,也不会是bug吧,由于启动到nomount状态都不行我认为只有可能是init文件有问题,或者是系统的守护进程有问题,现在看来init文件的可能性小一些,守护进程有问题的嫌疑大一些。现在我觉得是不是和相应的“服务”没有开启有关,windows下有相应的服务,UNIX环境下呢?有没有对UNIX环境熟悉点的达人帮忙想想
control_files = ("/usr1/ora817/product/8.1.7/oradata/ora817/control01.ctl", "/usr1/ora817/product/8.1.7/oradata/ora817/control02.ctl", "/usr1/ora817/product/8.1.7/oradata/ora817/control03.ctl")open_cursors = 500
max_enabled_roles = 30
db_block_buffers = 20480shared_pool_size = 524288000large_pool_size = 15728640
java_pool_size = 41933040log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800processes = 170log_buffer = 163840# audit_trail = false # if you want auditing
# timed_statistics = false # if you want timed statistics
# max_dump_file_size = 10000 # limit trace file size to 5M each# Uncommenting the lines below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
# log_archive_start = true
# log_archive_dest_1 = "location=/usr1/ora817/product/8.1.7/admin/ora817/arch"
# log_archive_format = arch_%t_%s.arc# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
#rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )# Global Naming -- enforce that a dblink has same name as the db it connects to
# global_names = false# Uncomment the following line if you wish to enable the Oracle Trace product
# to trace server activity. This enables scheduling of server collections
# from the Oracle Enterprise Manager Console.
# Also, if the oracle_trace_collection_name parameter is non-null,
# every session will write to the named collection, as well as enabling you
# to schedule future collections from the console.
# oracle_trace_enable = true# define directories to store trace and alert files
background_dump_dest = /usr1/ora817/product/8.1.7/admin/ora817/bdump
core_dump_dest = /usr1/ora817/product/8.1.7/admin/ora817/cdump
#Uncomment this parameter to enable resource management for your database.
#The SYSTEM_PLAN is provided by default with the database.
#Change the plan name if you have created your own resource plan.# resource_manager_plan = system_plan
user_dump_dest = /usr1/ora817/product/8.1.7/admin/ora817/udumpdb_block_size = 8192remote_login_passwordfile = exclusiveos_authent_prefix = ""mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
# Uncomment the following line when your listener is configured for SSL
# (listener.ora and sqlnet.ora)
# mts_dispatchers = "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"mts_dispatchers = "(protocol=TCP)(tick=15)(pool=true)"compatible = "8.1.0"
sort_area_size = 65536
sort_area_retained_size = 65536UTL_FILE_DIR=/usr1/jp01/backup
UTL_FILE_DIR=/usr1/jp01/dataup
UTL_FILE_DIR=/usr1/jp01/dic
mts_dispatchers="ipc,1"