Encrypted SqlNET with 2Listeners

[LGTObug]

Hello Everybody,

My company gave me the task to encrypt SQL queries from and to the Oracle database.
I´ve allready configured SqlNet with encryption but only for 1 Listener.
I need to set up one Listener which is encrypted and one Listener which is normal(unencrypted).
Does anyone know how i can solve this problem? Is it even possible to do this?
When i create a second Listener, this one is also Encrypted cause he takes like LISTENER_1 the settings from sqlnet.ora

Any help is appreciated.

 

[karluk]

I think you're right that there is no way for one sqlnet.ora file to specify that one listener is encrypted and the other isn't.

To get this to work, you will have to create a second TNS administration directory with separate listener.ora and sqlnet.ora files. Then, before starting the second listener, set the TNS_ADMIN environmental variable. The command to do this varies by o/s. On HP-UX it is

export TNS_ADMIN={full path of alternate TNS admin directory}

Then, when you start the second listener, it will take the sqlnet.ora parameters from the alternate directory.

 

[LGTObug]

Hello,

Thanks very much.
Your solution helped me a lot and it worked.
No my database is running 1 Listener normal and the 2nd Listener is encrypted.

gracia´s
regards