Re: Relocation error with listener

Looks like you havent configured U'r Listener process to listen to the DATABASE , but only to the External procedures.. The SID_LIST should include the SID ,for which it listens to..

Also, include TNS_ADMIN=$ORACLE_HOME/network/admin in u'r Shell..

Hope this helps

-Thiru

Michel Poleur wrote:

> Hi everybody,
>
> Last week, I installed Oracle 8.0.6 on a Solaris 2.6 box. Everything ran
> perfectly.
>
> I then tried to install Oracle 8.1.5 as a new ORACLE_HOME. The
> installation went right.
> But the listener give me a strange error:
>
> oracle - hillerin:/oracle/app/oracle/product/8.1.5/network/admin 23 >
> lsnrctl start CRP_815
>
> LSNRCTL for Solaris: Version 8.1.5.0.0 - Production on 13-SEP-99
> 15:32:10
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Starting /oracle/app/oracle/product/8.1.5/bin/tnslsnr: please wait...
>
> ld.so.1: /oracle/app/oracle/product/8.1.5/bin/tnslsnr: fatal: relocation
> error: file
> /oracle/app/oracle/product/8.1.5/bin/tnslsnr: symbol naemd5s: referenced
> symbol not found
> ld.so.1: lsnrctl: fatal: relocation error: file lsnrctl: symbol naemd5s:
> referenced symbol
> not found
> Killed
> oracle - hillerin:/oracle/app/oracle/product/8.1.5/network/admin 24 >
>
> I think the environnement variable settings are correct:
>
> HOME=/oracle/home
> SHELL=/usr/local/bin/tcsh
> PATH=/usr/bin:/usr/local/bin:/usr/ccs/bin:/usr/ucb:/usr/openwin/bin:/ora
> cle/app/oracle/product/8.1.5/bin:/opt/local/bin:/notes/v5/localbin
> USER=oracle
> HOSTTYPE=sun4
> VENDOR=sun
> OSTYPE=solaris
> MACHTYPE=sparc
> SHLVL=2
> PWD=/oracle/home
> LOGNAME=oracle
> GROUP=dba
> HOST=hillerin
> REMOTEHOST=cauvin.crpgl.lu
> ORACLE_BASE=/oracle/app/oracle
> ORACLE_HOME=/oracle/app/oracle/product/8.1.5
> ORACLE_SID=TST2
> NLS_LANG=english_luxembourg.we8dec
> ORA_NLS33=/oracle/app/oracle/product/8.1.5/ocommon/nls/admin/data
> LD_LIBRARY_PATH=/usr/openwin/lib:/usr/dt/lib:/usr/lib:/oracle/app/oracle
> /product/8.1.5/lib
> MANPATH=/usr/openwin/man:/usr/dt/man:/usr/man:/opt/local/emacs/emacs-19.
> 25/man
> CLASSPATH=/oracle/app/oracle/jre/1.1.7:/oracle/app/oracle/product/8.1.5/
> jlib:/oracle/app/oracle/product/8.1.5/oui/lib:/oracle/app/oracle/product
> /8.1.5/jdbc/lib/classes111.zip
> TMPDIR=/tmp
> EDITOR=emacs
> TERM=xterm
> WINDOWID=16777229
> DISPLAY=cauvin.crpgl.lu:0.0
>
> The listener file is in /oracle/app/oracle/product/8.1.5/network/admin
> and contains the following:
>
> # LISTENER.ORA Configuration
> File:/oracle/app/oracle/product/8.1.5/network/admin/listener.ora
> # Generated by Oracle Net8 Assistant
>
> CRP_815 =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = hillerin)(PORT = 1525))
> )
> )
> )
>
> SID_LIST_CRP_815 =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /oracle/app/oracle/product/8.1.5)
> (PROGRAM = extproc)
> )
> )
>
> Any help appreciated. Thanks.
>
> Michel Poleur
> poleur_at_crpgl.lu
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Sep 13 1999 - 10:16:04 CDT