• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1955
  • Last Modified:

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

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 9.2.0.8 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:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCPS)(HOST = <my host name>)(PORT = <my port number>))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME = C:\oracle\ora92)
      (SID_NAME = PRUEBA)
    )
   )
0
LindaC
Asked:
LindaC
  • 2
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
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?
http://forums.oracle.com/forums/thread.jspa?threadID=288842

I also assume you've already created the wallet?
Excerpt from:
http://download.oracle.com/docs/cd/B10501_01/network.920/a96573/asomeus.htm#1005490

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

0
 
LindaCAuthor Commented:
No Advance Security and no wallet.

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

http://www.oracle.com/technology/deploy/security/pdf/twp_security_checklist_db_database.pdf

I 'am currently on page 16.
0
 
slightwv (䄆 Netminder) Commented:
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.
0
 
LindaCAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now