listener.log

[big]

Hi,

I installed Oracle C19 on AIX.

There is no listener.log.

How should we enable it?

Thank you.

[ErmanArslansOracleBlog]

No listener log?

Are you sure?
Please check with lsnrctl status <listener_name> .. There should be log.xml path listed there..
Also in diagnostic_dest, there should be your listener log..

Example path:

/u01/dbebs/product/19.0.0/admin/PROD_ebsclone/diag/tnslsnr/ebsclone/listener/trace/listener.log

[big]

Hi,
Thank you Erman.
Yes lsnrctl status <listener_name> .. gives log.xml .
But in
/u01/mydbs/product/19.0.0/admin/xxxe/diag/tnslsnr/listener/trace/

I do not have listener.log.

Regards.

[ErmanArslansOracleBlog]

What do you get when you search the file by name?

cd /u01

find . -name listener*.log

On Sat, 10 Apr 2021 at 09:01, big [via Erman Arslan's Oracle Forum] <[hidden email]> wrote:

Hi,
Thank you Erman.
Yes lsnrctl status <listener_name> .. gives log.xml .
But in
/u01/mydbs/product/19.0.0/admin/xxxe/diag/tnslsnr/listener/trace/

I do not have listener.log.

Regards.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/listener-log-tp9588p9593.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

[big]

Hi,
Thanks.
$cd /u01
find . -name listener*.log
$

Nothing found.

Regards.

[ErmanArslansOracleBlog]

You are on AIX right..

Try with the following;

cd /u01
find .  -name '*listener*' -print

What is the output?

Also check the listener's config.. Maybe, logging to listener.log is disable there..

Connect  to the listener with lsnrctl and check the config..

LSNRCTL>set current_listener <listener_name> (if not using default LISTENER)
LSNRCTL>show log_status

If not enabled you can enable logging with the following;

LSNRCTL>set current_listener <listener_name> (if not using default LISTENER)
LSNRCTL>set LOG_STATUS on
LSNRTCTL>save_config

You can also try disabling and enabling the log_status..
LSNRCTL>set LOG_STATUS off
LSNRCTL>set LOG_STATUS on
LSNRCTL>save_config

You can try this as well..

[big]

Hi,
Thank you.

find .  -name '*listener*' -print

./config/listener.ora
./config/listener.ora_28jan21

LSNRCTL> set current_listener MYDB
Current Listener is MYDB

LSNRCTL> show log_status
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=MYDB_key))

MYDB parameter "log_status" set to ON

The command completed successfully

Thanks and regards.

[ErmanArslansOracleBlog]

If the log_status is already on, then disable and enable it..

Try disabling and enabling the log_status..
LSNRCTL>set LOG_STATUS off
LSNRCTL>set LOG_STATUS on
LSNRCTL>save_config

Once you do the that, check the listener log again..

Also try to find the listener log by searching through / directory..

$cd /
find .  -name '*listener*' -print

execute the above command with root and lets see..

[ErmanArslansOracleBlog]

what is your listener name?

Also try the search with;

cd /
find .  -name '*<your_listener_name>*' -print

[ErmanArslansOracleBlog]

Also, you can check the files opened by a process..
I mean listener process should have already opened its log so you can check it..
/proc is our friend in these types of cases..
You are on IBM AIX , right?

Check the following ->

https://www.ibm.com/support/pages/how-list-files-opened-process

[big]

Thanks. Yes we are on AIX.

In u0//diag/tnslsnr/xxx2/yyy/trace

We have

mydb.log

With WARNING: Subscription for node down event still pending
 in it.

It should be that?

Regards.

[ErmanArslansOracleBlog]

What is the name of your listener?

13 Nis 2021 Sal 20:18 tarihinde big [via Erman Arslan's Oracle Forum] <[hidden email]> şunu yazdı:

Thanks. Yes we are on AIX.

In u0//diag/tnslsnr/xxx2/yyy/trace

We have

mydb.log

With WARNING: Subscription for node down event still pending
 in it.

It should be that?

Regards.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/listener-log-tp9588p9622.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

... [show rest of quote]

[big]

Thank you.

It should be MYDB since for status I run:

lsnrctl status MYDB

Regards.

[ErmanArslansOracleBlog]

Then your listener name is mydb and your listener log name is accurate.
So what is the problem here? :)

[big]

Hi,
Thanks Erman.
The problem is that we have the following in alertlog and I would like to know where does it come from:

Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for IBM/AIX RISC System/6000: Version 19.0.0.0.0 - Production
        TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 19.0.0.0.0 - Production
        Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 19.0.0.0.0 - Production
  Version 19.7.0.0.0
  Time: 21-APR-2021 09:18:42
  Tracing to file:
  Tns error struct:
    ns main err code: 12535

TNS-12535: TNS:operation timed out
    ns secondary err code: 12609
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=xxxxx)(PORT=xxx))

Even if we can connect from Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=xxxxx)(PORT=xxx)) without problem.

Best regards.

[ErmanArslansOracleBlog]

This seems like a network issue.
Might be related with the SQLNET.RECV_TIMEOUT and / or SQLNET.SEND_TIMEOUT set in the client / server SQLNET.ORA files..

Still, you need to trace a failing connection.. Level 16 Oracle Net works.. MOS Note : SQL*Net & Oracle Net Services - Tracing and Logging at a Glance (Doc ID 219968.1)

Also see :

Troubleshooting Guide for TNS-12535 or ORA-12535 or ORA-12170 Errors (Doc ID 119706.1)
racle Net SQLNET.SEND_TIMEOUT and SQLNET.RECV_TIMEOUT Parameters and errors ORA-12170 TNS-12535 ORA-12609 ORA-12608 (Doc ID 1335630.1)

[big]

Hi,
Thank you.
I commented these two in sqlnet.ora :
SQLNET.RECV_TIMEOUT and  SQLNET.SEND_TIMEOUT

And no more :
Fatal NI connect error 12170.

Message in alertlog.

Best regards.

[ErmanArslansOracleBlog]

Good :)

23 Nis 2021 Cum 17:35 tarihinde big [via Erman Arslan's Oracle Forum] <[hidden email]> şunu yazdı:

Hi,
Thank you.
I commented these two in sqlnet.ora :
SQLNET.RECV_TIMEOUT and  SQLNET.SEND_TIMEOUT

And no more :
Fatal NI connect error 12170.

Message in alertlog.

Best regards.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/listener-log-tp9588p9665.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

... [show rest of quote]