oracle817, os是solaris8
安装程序时安了一个数据库ora
用dbassist又安了一个数据库zjyOra
现在zjyOra能够startup
ora不能够startup
启动时出现下面错误
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channelORA-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.
安装程序时安了一个数据库ora
用dbassist又安了一个数据库zjyOra
现在zjyOra能够startup
ora不能够startup
启动时出现下面错误
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channelORA-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.
解决方案 »
- 执行select * from v$controlfile;为什么结果是未选定行?
- oracle 把一个字段的几个值连接起来
- plsql查看字段报错 Access violation at address 0042
- Oracle 有错了!
- 高分求答:游标问题
- oracle可以一台机子上安装吗?
- 简单Oracle备份问题!送分啊!
- enterprise manager console(OEM)的linux配置问题!特急!100分相送!!
- 同样的过程在NT+ORACLE7.3上可以通过,但是在linux+ORACLE8.1.7上就通不过啊
- MERGE INTO效率很低
- ORACLE, SYBASE ANYWHERE, SQL Server的比较
- 小妹请教:怎样在java中实现dos命令中的exp调用(数据库备份命令),急!!!
then try againsqlplus/nolog
connect system/manager@ora as sysdba
startup force
如下:
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
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 = 8192zjyOra
环境变量
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