-
Hi,
i have a DB 8.1.7 on Linux. For resolution name i use local naming, and on my client I edit my tnsnames.ora standardly (sid = "sid", protocol = tcp, port= 1521).
It's all ok, I connect and there isn't any problem. But when I go to edit llistener.ora on my server I don't try it. I search it with command find, ma it isn't. After that I stop listner and I start It, this is the output prompt me:
Starting /home/oracle/OraHome1/product/8.1.7/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 8.1.7.0.0 - Production
Log messages written to /home/oracle/OraHome1/product/8.1.7/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=data.sinapsi.net.com)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 8.1.7.0.0 - Production
Start Date 27-SEP-2001 15:41:40
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /home/oracle/OraHome1/product/8.1.7/network/log/listener.log
The listener supports no services
The command completed successfully
Ther isn't nothing about system parameter file.
Why? If there is, where is my listener.ora?
Thank you,
MaX
-
if there is no TNS_ADMIN variable defined, it should be in $ORACLE_HOME/network/admin
alse do :
find / -name listener.ora -exec grep -il 'data.sinapsi.net.com' {} \;
and you'll get the file that is used ...
-
...
I have already verified, environemnt variable TNS_ADMIN ther isn't. On $ORACLE_HOME/network/admin there isn't listener.ora and nor with command find I find this file :-(
Thank you for your help
-
in this case, try to take listener.ora file in $ORACLE_HOME/network/admin/samples, copy it in network/admin, and just change it to match your configuration. If 'lsnrctl start' still gives the same thing, then there is something strange ;)
