Home » RDBMS Server » Security » secure external password does not prompt for password (oracle 10gr2, windows)
secure external password does not prompt for password [message #503331] Thu, 14 April 2011 11:53 Go to previous message
kytemanaic
Messages: 55
Registered: February 2009
Member
Hi,

I'm trying to hide the password for the batch programs that connect to the DB Server

as Cadot pointed out in http://www.orafaq.com/forum/?t=msg&goto=496262&137592/&srch=secure+external+password#msg_496262

Quote:

use secure external password store



with reference to http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/cnctslsh.htm

when I create wallet, the system does not prompt me for password

C:\>mkstore -wrl "C:\ora102\NETWORK\ADMIN" -create




when creating login credentials, again the system never prompts me for password

C:\>mkstore -wrl "C:\ora102\NETWORK\ADMIN" -createCredential db10g scott tiger



here's my sqlnet.ora configurations
WALLET_LOCATION =
   (SOURCE =
     (METHOD = FILE)
     (METHOD_DATA =
       (DIRECTORY =C:\ora102\NETWORK\ADMIN)
     )
    )

SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSESSL_VERSION = 0


here's my tnsname.ora settings

DB10G =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mike)
    )
  )



here's the outcome
C:\Documents and Settings\Administrator>sqlplus /@db10g

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Apr 13 22:53:06 2011

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

ERROR:
ORA-12534: TNS:operation not supported


Enter user-name:



so I google around for the solution to the ORA-12534 error, one of the site, http://ora-12514.ora-code.com/ suggest lsnrctl services

here's my lsnrctl services


Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "MIKEXDB" has 1 instance(s).
  Instance "mike", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1002 state:ready
         DISPATCHER <machine: LENG, pid: 3548>
         (ADDRESS=(PROTOCOL=tcp)(HOST=leng)(PORT=1172))
Service "MIKE_XPT" has 1 instance(s).
  Instance "mike", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:4 refused:0 state:ready
         LOCAL SERVER
Service "mike" has 1 instance(s).
  Instance "mike", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:4 refused:0 state:ready
         LOCAL SERVER
The command completed successfully



right now I think I will be a fool to think that the solution is to resolve the ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

so what is wrong with my setup, or is it some patch that I need to apply? Can someone enlighten me on how to resolve this buggy issue?

thanks a lot!
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: show labels from Oracle Label Security
Next Topic: How to use secure external password store in dot net
Goto Forum:
  


Current Time: Thu Mar 28 18:37:10 CDT 2024