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!