Implementing tcps in windows - windows server and unix(aix and solaris) listener.ora

Posted on 2007-07-31
Last Modified: 2013-12-19
I want to change the listener.ora so that the protocol would be tcps and not tcp.
I want to know what is required in Windows and Unix (Aix - Solaris) so that this can be achieved.
I was trying to change it in database in my xp machine that I use daily bu it gave me this error:

ORA-28759: Failed to open file
 TNS-12560: TNS:protocol adapter error
  TNS-00540: SSL protocol adapter failure

The listener.ora is the following:

        (ADDRESS = (PROTOCOL = TCPS)(HOST = <my host name>)(PORT = <my port number>))

    (SID_DESC =
      (ORACLE_HOME = C:\oracle\ora92)
Question by:LindaC
    LVL 76

    Accepted Solution

    First, I've never done this so I probably won't be much help but the question made me wonder what was happening so I researched it a little.

    I assume that you've installed Advanced Security?

    I also assume you've already created the wallet?
    Excerpt from:

    "Do not attempt to start the listener until you have set up a wallet for SSL connections."

    LVL 8

    Author Comment

    No Advance Security and no wallet.

    I have to change it because of "higher autority" says so, because of this document:

    I 'am currently on page 16.
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    It was nice of Oracle to not give you everything you needed in that white paper.

    I read it the same way you did.  Just change the config file and away you go.  The other docs seem to say it's not that easy.

    I'll have to let other experts chime in since I've never messed with it.
    LVL 8

    Author Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now