2008-8-5 10:15
lpq_1_5
startup后报错
大家好
我在装完数据库后启动时报错请大家指教一下
$ sqlplus /nolog;
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Aug 5 10:06:07 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect /as sysdba;
Connected to an idle instance.
SQL> show user;
USER is "SYS"
SQL> startup
ORA-27504: Message 27504 not found; product=RDBMS; facility=ORA
ORA-27300: OS system dependent operation:socket failed with status: 68
ORA-27301: OS failure message: Can't assign requested address
ORA-27302: failure occurred at: sskgxpcre1
这是哪里配置出问题了吗?listen
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =128.32.97.221 )(PORT = 1521)(IP=FIRST))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = cs)
(ORACLE_HOME = /home/ora/product/9.2.0)
)
)
tnsnames.ora
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
cs=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL =TCP)(HOST=ap1)(PORT=1521))
)
(CONNECT_DATA =
(SERVICE_NAME=cs
)
)
2008-8-5 10:16
lpq_1_5
.profile 文件
ORACLE_BASE=/home/ora
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_HOME
ORACLE_SID=cs
NLS_LANG=american_america.zhs16cgb231280
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
export ORACLE_SID NLS_LANG LD_LIBRARY_PATH LIBPATH
PATH=$ORACLE_HOME/bin:$PATH
export PATH
DISPLAY=128.32.187.206:0.0
export DISPLAY
2008-8-5 13:02
燕狂徒
no -r -o rfc1323=1然后重启下看看
2008-8-5 13:05
燕狂徒
[url]http://bbs.loveunix.net/thread-79481-1-1.html[/url]
2008-8-5 13:48
lpq_1_5
我查看了一下rfc1323=1啊
2008-8-5 14:22
lpq_1_5
刚才说错了,我在startup nomount 时就报错
SQL> startup nomount;
ORA-27504: Message 27504 not found; product=RDBMS; facility=ORA
ORA-27300: OS system dependent operation:socket failed with status: 68
ORA-27301: OS failure message: Can't assign requested address
ORA-27302: failure occurred at: sskgxpcre1
页:
[1]
Powered by Discuz! Archiver 5.5.0
© 2001-2006 Comsenz Inc.