免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1211 | 回复: 2
打印 上一主题 下一主题

one lsnrctl question when install oracal8.17 on redhat9 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2004-02-27 13:28 |只看该作者 |倒序浏览
参照这篇文章安装的oracle
http://www3.sympatico.ca/arothmel/oracle/817.html#lsnrctl1
安装完后
svrmgrl正常
sqlplus正常
但是在运行:
lsnrctl
LSNRCTL>;strat 后提示:
starting /u01/oracle/product/8.1.7/bin/tnslsnr:please wait...
TNS-12545:connect failed because target host or object does not exist
  TNS-12550:TNS:protocol adapter error
    TNS-00515:connect failed beacuse target host or object does not exist
      LINUX Error:2:No such file or directory

谁遇到过这种问题?

论坛徽章:
0
2 [报告]
发表于 2004-02-27 14:01 |只看该作者

one lsnrctl question when install oracal8.17 on redhat9

这个问题我遇到过,原因是
关于TNS的环境变量设置有误造成。

论坛徽章:
0
3 [报告]
发表于 2004-02-27 14:31 |只看该作者

one lsnrctl question when install oracal8.17 on redhat9

我也感觉是这里有问题,但是实在是找不到问题出在那里.
我的设置是,谢谢帮忙
vi ~oracle/.bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATHHOME/bin

export PATH
unset USERNAME
# Stuff for 8.1.7 Install
export LD_ASSUME_KERNEL=2.2.5
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/product/8.1.7
export PATH=$PATHORACLE_HOME/bin
unset  LANG

# Java Development Kit for 8.1.7
JAVA_HOME=/usr/local/java;export JAVA_HOME
CLASSPATH=${JAVA_HOME}/lib/classes.zip;export CLASSPATH

# Need to point to init*.ora
ORACLE_SID=yyl; export ORACLE_SID

# Need Shared libraries ie for lsnrctl
if ["${LD_LIBRARY_PATH:-}" == ""]; then
    LD_LIBRARY_PATH=${ORACLE_HOME}/lib:/usr/lib:/usr/local/lib
else
    LD_LIBRARY_PATH=${ORACLE_HOME}/lib{LD_LIBRARY_PATH}
fi
export LD_LIBRARY_PATH

LISTENER.ORA内容:
# LISTENER.ORA Network Configuration File: /u01/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ora)(PORT = 1521))
      )
    )
    (DESCRIPTION =
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
      (ADDRESS = (PROTOCOL = TCP)(HOST = ora)(PORT = 2481))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/oracle/product/8.1.7)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = yyl.hengmei.cn)
      (ORACLE_HOME = /u01/oracle/product/8.1.7)
      (SID_NAME = yyl)
    )
  )
tnsnames.ora文件内容:
# TNSNAMES.ORA Network Configuration File: /u01/oracle/product/8.1.7/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ora)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = yyl.hengmei.cn)
      (PRESENTATION = http://admin)
    )
  )

YYL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ora)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = yyl.hengmei.cn)
    )
  )
运行adapters:
Installed Net8 Tranport Protocols are:

    IPC
    TCP/IP
    BEQueath
    SSL
    RAW

Installed Net8 Naming Adapters are:

    TNSnames.ora
    OracleNames
    LDAP
    Hostname

Installed Oracle Advanced Security products are:

    RC4 40-bit encryption algorithm
    RC4 56-bit encryption algorithm
    RC4 128-bit encryption algorithm
    RC4 256-bit encryption algorithm
    DES40 40-bit encryption algorithm
    DES 56-bit encryption algorithm
    3DES 112-bit encryption algorithm
    3DES 168-bit encryption algorithm
    MD5 crypto-checksumming algorithm
    SHA-1 crypto-checksumming algorithm
    SecurID Authentication Adapter
    Kerberos v5 Authentication Adapter
    Identix Authentication Adapter
    RADIUS Authentication Adapter
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP