求助：数据库创建时报03114错误

显示全部楼层 · 2009-10-9 08:28:00

我在solaris上创建oracle8i（第一次创建）,在创建实例进行到80%时，报03114错误(not connect to oracle),我仔细查看了下自己的参数配置，找不出具体原因，想请教一下各位大虾，给点建议

千问 · 2009-10-9 08:28:00

ORA-03114 not connected to ORACLE
CCause: 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 happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.
Action: Try again. If the message recurs and the program is user written, check the program.
** check you install oracle home***
1.chhown -fhR oracle:dba $ORACLE_HOME

user : group
2.chmod 755 $ORACLE_HOME

千问 · 2009-10-9 08:28:00

应当是你的核心参数配置有问题，你好好看一看

千问 · 2009-10-9 08:28:00

1.check /etc/system - file
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=16
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=500
set semsys:seminfo_semmsl=300
set semsys:seminfo_semmns=400
set semsys:seminfo_semopm=200
set semsys:seminfo_semvmx=32767
2.check /oracle/v817/.cshrcfile -if cshell
#ORACLE7 initialization environment variables
setenv ORACLE_HOME /oracle/v817 # ORACLE7 initialization
setenv ORACLE_SID xxxxxx # ORACLE7 initialization
setenv ORACLE_BASE /oracle/v817
setenv ORACLE_OWNER oracle
#setenv NLS_LANG american_america.ZHT16BIG5 # ORACLE7 initialization
setenv NLS_LANG american_america.US7ASCII # ORACLE7 initialization
#setenv NLS_LANG "traditional chinese"_taiwan.ZHT16BIG5 # choco modify
setenv ORA_NLS33$ORACLE_HOME/ocommon/nls/admin/data
setenv PATH $ORACLE_HOME/bin:/usr/ccs/bin:/usr/X/bin:/usr/openwin/bin:/usr/bin/X11:${PATH} # ORACLE7 initialization
#setenv LD_LIBRARY_PATH /usr/X/lib:/usr/openwin/lib:/usr/ucblib:/usr/dt/lib:$ORACLE_HOME/lib:/opt/postgres/lib # ORACLE7 initialization
setenv LD_LIBRARY_PATH /usr/local/lib:$ORACLE_HOME/lib:$ORACLE_HOME/libi64:/opt/postgres/lib:/usr/local/qt/lib:/u/pacs/src/image-compression
setenv LD_LIB_PATH_64 $ORACLE_HOME/lib64
setenv SSMPATH /u/pacs/src/image-compression/pictools/lib
setenv WGSHOST pacs-ctrl # ORACLE7 initialization
setenv WWW_HOME "http://pacs-ctrl:8000/WG73-bin/login"
setenv DISPLAY localhost:0.0 # ORACLE7 initialization

千问 · 2009-10-9 08:28:00

谢谢，我再试试看

千问 · 2009-10-9 08:28:00

我找到问题了，但不知该如何解决，是我创建的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查看，几项都为空
在启动实例时要利用共享内存，找不到，所以失败，请问有解决办法吗

千问 · 2009-10-9 08:28:00

对了，机器是solaris8,ultra 450，内存2G

千问 · 2009-10-9 08:28:00

看来很麻烦，我再研究一下，大虾有什么指点一定告诉小弟

千问 · 2009-10-9 08:28:00

set semsys:seminfo_semmns=200
set semsys:seminfo_semmns=512

千问 · 2009-10-9 08:28:00

真的就是这个问题
我也在创建数据库时候遇到这个问题的
现在改成512就ok了
起码目前看没问题
谢谢！