17,380
社区成员
发帖
与我相关
我的任务
分享求助：创建oracle实例时报03114错误
我在solaris上创建oracle8i（第一次创建）,在创建实例进行到80%时，报03114错误(not connect to oracle),我仔细查看了下自己的参数配置，找不出具体原因，想请教一下各位大虾，给点建议
...全文
请发表友善的回复…
发表回复
ad_ad_ad 2003-02-11
- 打赏
- 举报
我找到问题了，但不知该如何解决，是我创建的oracle用户找不到共享内存导致，我的内核参数如下：
set shmsys:shminfo_shmmax=0x80000000
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=200
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
用sysdef -i命令查看已经生效，而
用ipcs查看，几项都为空
在启动实例时要利用共享内存，找不到，所以失败，请问有解决办法吗
set shmsys:shminfo_shmmax=0x80000000
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=200
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
用sysdef -i命令查看已经生效，而
用ipcs查看，几项都为空
在启动实例时要利用共享内存，找不到，所以失败，请问有解决办法吗
ad_ad_ad 2003-02-11
- 打赏
- 举报
我在国外的网站上查到了，真是厉害啊，一眼就找到问题
minkoming 2003-02-04
- 打赏
- 举报
ORA-03114 not connected to ORACLE
Cause: A call to Oracle was attempted when no connection was established.
Usually this happens because a user-written program has not logged on. It may
also happen if communication trouble causes a disconnection.
Action: Try again. If the message recurs and the program is user written, check the program.
Cause: A call to Oracle was attempted when no connection was established.
Usually this happens because a user-written program has not logged on. It may
also happen if communication trouble causes a disconnection.
Action: Try again. If the message recurs and the program is user written, check the program.
