Hi all,

We are getting ORA-12535: TNSperation timed
when trying to connect.

I have the parameter CONNECT_TIMEOUT_LISTENER = 10 set.

Thinking I need to change this to be 0 or higher than 10.
Any Advice?

Also, 8.1.5 database, will I have to bounce the listener for the value to be reset or does this happen with automatic instance registration.

If I have to bounce, will the currently connected users get kicked out. I am thinking not, since listener spawns a separate dedicated process. So listener has nothing to do with the currently connected users, right? Only the new users trying to connect will be affected, for a few minutes.

I am a little nervous about changing this on prod database, any advice helpful.

Thanks,
Kathy