Oracle Database Discussions

hi,

This is regarding a problem which i'm facing while connecting from my sqlplus client to a server which is SSL enabled (Guess Oracle advanced security is the right term).

When i try connecting to the database i get the following error

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Jan 26 21:59:32 2010

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:

My tnsnames.ora looks something like this.

DB.WORLD =
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS) (HOST = <hostname>) (PORT = 1575)))
(CONNECT_DATA = (SID = <sid>) (SERVER = DEDICATED)))


Tried various options like creating a file called sqlnet.ora with the following entries to point to wallet files but to no effect.



SSL_VERSION = undetermined
SSL_CLIENT_AUTHENTICATION = FALSE
WALLET_LOCATION =
  (SOURCE =
    (METHOD = FILE)
    (METHOD_DATA =
      (DIRECTORY = <wallet file location>) //For this line, specify the location of the copied wallet files from the STS or repository DB on the local machine
    )
  )
ENCRYPTION_WALLET_LOCATION=
 (SOURCE=
   (METHOD=FILE)
     (METHOD_DATA=
      (DIRECTORY= <wallet file location>)
   )
  )
SSL_CIPHER_SUITES= (SSL_RSA_WITH_AES_128_CBC_SHA)


Any help in getting the standard steps to connect to the database using TCPS protocol would be great.

Regards,

Krishna