?
Solved

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

Posted on 2007-07-31
4
Medium Priority
?
1,878 Views
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 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
Comment
Question by:LindaC
  • 2
  • 2
4 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1500 total points
ID: 19600159
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
 
LVL 8

Author Comment

by:LindaC
ID: 19600196
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
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 19602367
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
 
LVL 8

Author Comment

by:LindaC
ID: 19602393
Thanks.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup
Suggested Courses
Course of the Month16 days, 14 hours left to enroll

864 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