startup

[6liuy]

oracle817， os是solaris8
安装程序时安了一个数据库ora
用dbassist又安了一个数据库zjyOra
现在zjyOra能够startup
ora不能够startup
启动时出现下面错误
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel

ORA-24323 value not allowed
Cause: A null or invalid value was passed in for a mandatory parameter.

ORA-03113 end-of-file on communication channel
Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8 two-task software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.

[jiezhi]

check your command

[6liuy]

命令没有问题

[jiezhi]

restart your computer
then try again

sqlplus/nolog
connect system/manager@ora as sysdba
startup force

[hrb_qiuyb]

登陆以后更改一下ORACLE_SID环境变量
如下：
1、以oracle用户telnet至服务器.
2、oracle$ORACLE_SID=ora;export ORACLE_SID
3、oracle$sqlplus /nolog
sql>connect system/manager@ora as sysdba
sql>startup force

[6liuy]

谢谢你们，你们的方法我都试过不行，看错误信息应该是有mandatory parameter值为空或为无效值，我对zjyOra与ora这两个数据库的初始参数以及环境变量进行对比，感觉该设的已经都设了，我把他们贴出来，麻烦帮我看看；有的变量没写
ora
环境变量
HOME=/home/ly
HZ=100
LD_LIBRARY_PATH=/orahome/oracle/lib
LOGNAME=ly
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280
ORACLE_BASE=/orahome/oracle
ORACLE_HOME=/orahome/oracle
ORACLE_OWNER=oracle
ORACLE_SID=ora
ORACLE_TERM=sun
ORA_NLS33=/orahome/oracle/ocommon/nls/admin/data
PATH=/usr/bin:/usr/ucb:/etc:.:/orahome/oracle/bin
SHELL=/bin/sh
初始参数文件
db_name = "ora"
instance_name = ora
service_names = ora
db_block_buffers = 32000
db_block_size = 8192

zjyOra
环境变量
HOME=/home/ly
HZ=100
LD_LIBRARY_PATH=/orahome/oracle/lib
LOGNAME=ly
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280
ORACLE_BASE=/orahome/oracle
ORACLE_HOME=/orahome/oracle
ORACLE_OWNER=oracle
ORACLE_SID=zjyOra
ORACLE_TERM=sun
ORA_NLS33=/orahome/oracle/ocommon/nls/admin/data
PATH=/usr/bin:/usr/ucb:/etc:.:/orahome/oracle/bin
SHELL=/bin/sh
初始参数文件
db_name = "zjyOra"
instance_name = zjyOra
service_names = zjyOra
db_block_buffers = 38128
db_block_size = 8192