sqlplus 连接到空实例。郁闷。求助

xcsars

cat listener.ora
# listener.ora Network Configuration File: /oracle/app/oracle/product/10.2//network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = mbsale)
      (ORACLE_HOME = /oracle/app/oracle/product/10.2/)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bs_statistics)(PORT = 3500))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

棉花糖ONE

问题解决了。profile 里面。ORACLE_HOME像下面这样写就可以了
ORACLE_HOME=$ORACLE_BASE/product/10.2/;export ORACLE_HOME


   (ORACLE_HOME = /oracle/app/oracle/product/10.2/)

Yong Huang

原帖由 xcsars 于 2009-8-11 23:24 发表
bs_statistics:/oracle$ ps -ef | grep ora_

You probably didn't understand what I mean by running process environment. On AIX, you can use the command
ps eww [pid]
to get it. Please read

http://yong321.freeshell.org/computer/ProcEnv.txt

Yong Huang

xcsars

bs_statistics:/oracle$ ps eww 442964
    PID    TTY STAT  TIME COMMAND
442964      - A     0:11 ora_arc0_mbsale _=/oracle/app/oracle/product/10.2//bin/sqlplus LANG=en_US LOGIN=oracle PATH= NLS_LANG=AMERICAN_AMERICA.ZHS16GBK ORACLE_BASE=/oracle/app/oracle LC__FASTMSG=true CLASSPATH=/oracle/app/oracle/product/10.2//jlib:/oracle/app/oracle/product/10.2//network/jlib LOGNAME=oracle MAIL=/usr/spool/mail/oracle ORACLE_SID=mbsale LOCPATH=/usr/lib/nls/loc PS1=bs_statistics:$PWD$  USER=oracle AUTHSTATE=files SHELL=/usr/bin/ksh ORACLE_TERM=vt100 ODMDIR=/etc/objrepos ORA_NLS33=//oracle/app/oracle/product/10.2//ocommon/nls/admin/data HOME=/oracle TERM=vt100 MAILMSG=[YOU HAVE NEW MAIL] ORACLE_HOME=/oracle/app/oracle/product/10.2/ PWD=/usr/local/bin TZ=BEIST-8 MI_ROOT_DIR_BILL=/oracle/chy/bill A__z=! LOGNAME ORA_NET2_DESC=8,11 ORACLE_SPAWNED_PROCESS=1 SKGP_HIDDEN_ARGS= NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat LIBPATH=/oracle/app/oracle/product/10.2//lib LD_LIBRARY_PATH=/oracle/app/oracle/product/10.2//lib://oracle/app/oracle/product/10.2//lib32:/oracle/app/oracle/product/10.2//network/lib

Coast_lichao

沉默

Yong Huang

原帖由 xcsars 于 2009-8-12 20:10 发表
bs_statistics:/oracle$ ps eww 442964
    PID    TTY STAT  TIME COMMAND
442964      - A     0:11 ora_arc0_mbsale _=/oracle/app/oracle/product/10.2//bin/sqlplus ... ORACLE_HOME=/oracle/app/oracle/product/10.2/ PWD=...

Now you see your trailing / for ORACLE_HOME? That has to match your ORACLE_HOME setting you use elsewhere.

Yong Huang