LoveUnix » ORACLE等数据库 » startup后报错
让LU留住您的每

一天 让LU博客留住您的每一天
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]
查看完整版本: startup后报错


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.