Configure Listener using TCPS
710236Mar 13 2012 — edited Apr 17 2012I am trying to test TCPS protocol to replace the TCP protocol. Been googling and reading with not much luck. Need help with folks who have setup TCPS and can point me to some links documents which provides this information and understanding about TCPS setup/configuration.
Few questions
- Any command line tool on Windows/Unix which I can run to verify if "Advance Security Option" is installed?
When Advance Security Option is installed, is this component just part of the binary installation or some packages gets installed inside the database as well?
After reading document, i ran "Universal Installer" and checked product installed, it lists "Enterprise Edition Options 11.2.0.1.0" but nothing under this option. To me this indicates "Advanced security option" is not installed, now how can i install it on an existing install?
- For TCPS connectivity setup, what configuration is needed on the Server side?
From reading and googling, i see listener.ora, sqlnet.ora needs to be changed to use TCPS. Listener needs to be restarted.
- For TCPS connectivity setup, what configuration is needed on the Client side?
From reading and googling, i see tnsnames.ora and sqlnet.ora needs to be changed to use TCPS
There is some "wallet" configuration which need to be done as well, can someone provide some guidelines on this.
I have installed enterprise edition 11.2.0.1.0 on my laptop, what else will be needed if I want to test this on my laptop.