1 Reply Latest reply on Apr 5, 2013 11:46 AM by EdStevens

    2-way encryption between a client odbc driver and the database

    KlausMogensen
      Hello

      Can someone point me towards the correct documentation for setting up 2-way encryption between a client odbc driver and the database prosuably using Oracle Net along the way?

      I'm not sure what to search for, or if I'm using the correct phrases for describing the problem

      Thanks in advanced

      Klaus Mogensen
        • 1. Re: 2-way encryption between a client odbc driver and the database
          EdStevens
          KlausMogensen wrote:
          Hello

          Can someone point me towards the correct documentation for setting up 2-way encryption between a client odbc driver and the database prosuably using Oracle Net along the way?

          I'm not sure what to search for, or if I'm using the correct phrases for describing the problem

          Thanks in advanced

          Klaus Mogensen
          I've never done it ,but I would start here: http://docs.oracle.com/cd/E11882_01/network.112/e10746/asoconfg.htm#ASOAG020

          As the encryption is done in the sqlnet layer, then yes, your "possibly (?) using Oracle Net along the way" is exactly what it's doing.

          Consider the overall architecture:
          1. application 
               |
               |
               V
          2. odbc driver 
               |
               |
               V
          3. oracle OCI client 
               |
               |
               V
          4. sqlnet
               |
               |
               V
          5. OS Network stack
               |
               |
               V
          6.  NIC
               |
               |
               V
          7. cables and routers  
               |
               |
               V
          8.  NIC
               |
               |
               V
          9. OS Network stack
               |
               |
               V
          10. oracle server
          Since the encryption described is done by sqlnet, that is occurring between steps 3 and 9