Hi Paula !
You have 2 options :
1) provide symlink to your "listener.ora"
file.
2) In case you start the listener process via sth like thata
"BASH_PROMPT> lsnrctl start " you can "fake" the
shell
with the command " TNS_ADMIN=/tmp lsnrctl start" ( no export of
TNS_ADMIN varaible ! ). thus the variable
TNS_ADMIN
will be used ONLY for the invocation of the
current command (in this case lsnrctl start) . Here is a
small proof of the concept ( under RHAS 2.1, Orac 9.2.0):)
-----------------------------------------------------------------------------------------------------------------
11338 access("/tmp/ldap.ora", F_OK) = -1 ENOENT
(No such file or directory)
11338 access("/oracle/o1/oracle/product/9.2.0/network/admin/ldap.ora", F_OK) = -1 ENOENT (No such fi
le or directory)
11338 access("/tmp/listener.ora", F_OK) = 0
11338 open("/tmp/listener.ora", O_RDONLY) = 3
11338 fcntl64(0x3, 0x2, 0x1, 0x2) = 0
11338 brk(0x81c2000) = 0x81c2000
11338 fstat64(3, {st_mode=S_IFREG|0644, st_size=713, ...}) = 0
11338 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40abc000
11338 read(3, "# LISTENER.ORA Network Configura"..., 4096) = 713
11338 access("/oracle/o1/oracle/product/9.2.0/network/admin/ldap.ora", F_OK) = -1 ENOENT (No such fi
le or directory)
11338 access("/tmp/listener.ora", F_OK) = 0
11338 open("/tmp/listener.ora", O_RDONLY) = 3
11338 fcntl64(0x3, 0x2, 0x1, 0x2) = 0
11338 brk(0x81c2000) = 0x81c2000
11338 fstat64(3, {st_mode=S_IFREG|0644, st_size=713, ...}) = 0
11338 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40abc000
11338 read(3, "# LISTENER.ORA Network Configura"..., 4096) = 713
.....
.....
11340 rt_sigaction(SIGRT_2, {SIG_DFL}, NULL, 8) = 0
11340 execve("/oracle/o1/oracle/product/9.2.0/bin/tnslsnr", ["/oracle/o1/oracle/product/9.2.0/"...,
"LISTENER", "-inherit"], [/* 36 vars */]) = 0
11340 uname({sys="Linux", node="as1", ...}) = 0
11340 execve("/oracle/o1/oracle/product/9.2.0/bin/tnslsnr", ["/oracle/o1/oracle/product/9.2.0/"...,
"LISTENER", "-inherit"], [/* 36 vars */]) = 0
11340 uname({sys="Linux", node="as1", ...}) = 0
-----------------------------------------------------------------------------------------------------------------
HTH. Milen
-----Ursprüngliche Nachricht-----
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 10. September 2003 16:45
An: Multiple recipients of list ORACLE-L
Betreff: RE: making me crazyDealing with 2 Oracle Homes - one if which I need to run the listener from and one in which I need to use the tnsnames.ora definitions from and no I can't just copy the tnsnames.ora to the 1st Oracle Home. Even when I set the oracle home from which to run lsnrctl it tries to use the listener.ora from the TNS_ADMIN home. How can I make sure to explicitly start the correct listener.ora?
Thanks,
Paula
