connect to a pluggable database without password .. 

connect to a pluggable database without password 

This note explains how one can configure SEPS ( Secure External Password Store) to connect to a pluggable database. 

This is useful when creating passwordless connections for expdp. 

on sqlnet.ora

Example ...

WALLET_LOCATION =

(SOURCE =

(METHOD = FILE)

(METHOD_DATA =

(DIRECTORY =<wallet location directory>)

)

)

SQLNET.WALLET_OVERRIDE = TRUE

SSL_CLIENT_AUTHENTICATION = FALSE

SSL_VERSION = 0

---- 

WALLET_LOCATION = (SOURCE =(METHOD = FILE) (METHOD_DATA = (DIRECTORY =/u01/app/oracle/wallet)))

SQLNET.WALLET_OVERRIDE = TRUE

SSL_CLIENT_AUTHENTICATION = FALSE

SSL_VERSION = 0

 mkstore -wrl . -create

Oracle Secret Store Tool : Version 12.1.0.2

Copyright (c) 2004, 2014, Oracle and/or its affiliates. All rights reserved.

Enter password:

Enter password again:

mkstore -wrl "/u01/app/oracle/wallet" -createCredential vihaan anuj vihaan

mkstore -wrl "<wallet location directory>" -createCredential <Pluggable DB service name> <username> <password>

mkstore -wrl "/u01/app/oracle/wallet" -createCredential vihaan anuj vihaan

Oracle Secret Store Tool : Version 12.1.0.2

Copyright (c) 2004, 2014, Oracle and/or its affiliates. All rights reserved.

Enter wallet password:

Create credential oracle.security.client.connect_string1

on tnsnames.ora

Example ..

<Pluggable DB service name> =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = <port#>))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = <Pluggable DB SID>)

)

)

vihaan =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.71)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = vihaan)

      (SERVER = dedicated)

    )

  )

[oracle@ora-prim wallet]$ tnsping vihaan

TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 08-DEC-2016 17:40:47

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:

/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.71)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = vihaan) (SERVER = dedicated)))

OK (10 msec)

[oracle@ora-prim admin]$ sqlplus /@vihaan

SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 8 17:41:57 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Last Successful login time: Thu Dec 08 2016 17:34:26 +00:00

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

expdp /@vihaan dumpfile=INT1.DMP directory=anujdir logfile=INT1.LOG tables='INTERVAL_SALES' CONSISTENT=Y  ESTIMATE=STATISTICS reuse_dumpfiles=y

Export: Release 12.1.0.2.0 - Production on Thu Dec 8 18:20:00 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Legacy Mode Active due to the following parameters:

Legacy Mode Parameter: "consistent=TRUE" Location: Command Line, Replaced with: "flashback_time=TO_TIMESTAMP('2016-12-08 18:20:00', 'YYYY-MM-DD HH24:MI:SS')"

Legacy Mode has set reuse_dumpfiles=true parameter.

Starting "ANUJ"."SYS_EXPORT_TABLE_01":  /********@vihaan dumpfile=INT1.DMP directory=anujdir logfile=INT1.LOG tables=INTERVAL_SALES flashback_time=TO_TIMESTAMP('2016-12-08 18:20:00', 'YYYY-MM-DD HH24:MI:SS') ESTIMATE=STATISTICS reuse_dumpfiles=y

Estimate in progress using STATISTICS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

.  estimated "ANUJ"."INTERVAL_SALES":"P0"                4.683 KB

.  estimated "ANUJ"."INTERVAL_SALES":"P1"                4.683 KB

.  estimated "ANUJ"."INTERVAL_SALES":"P2"                4.683 KB

.  estimated "ANUJ"."INTERVAL_SALES":"P3"                4.683 KB

.  estimated "ANUJ"."INTERVAL_SALES":"SYS_P261"          4.683 KB

.  estimated "ANUJ"."INTERVAL_SALES":"SYS_P262"          4.683 KB

.  estimated "ANUJ"."INTERVAL_SALES":"SYS_P263"          4.683 KB

.  estimated "ANUJ"."INTERVAL_SALES":"SYS_P264"          4.683 KB

.  estimated "ANUJ"."INTERVAL_SALES":"SYS_P265"          4.683 KB

.  estimated "ANUJ"."INTERVAL_SALES":"SYS_P266"          4.683 KB

.  estimated "ANUJ"."INTERVAL_SALES":"SYS_P267"          4.683 KB

Total estimation using STATISTICS method: 51.51 KB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER

. . exported "ANUJ"."INTERVAL_SALES":"P0"                7.773 KB       0 rows

. . exported "ANUJ"."INTERVAL_SALES":"P1"                7.773 KB       0 rows

. . exported "ANUJ"."INTERVAL_SALES":"P2"                7.773 KB       0 rows

. . exported "ANUJ"."INTERVAL_SALES":"P3"                7.773 KB       0 rows

. . exported "ANUJ"."INTERVAL_SALES":"SYS_P261"          7.812 KB       1 rows

. . exported "ANUJ"."INTERVAL_SALES":"SYS_P262"          7.812 KB       1 rows

. . exported "ANUJ"."INTERVAL_SALES":"SYS_P263"          7.812 KB       1 rows

. . exported "ANUJ"."INTERVAL_SALES":"SYS_P264"          7.812 KB       1 rows

. . exported "ANUJ"."INTERVAL_SALES":"SYS_P265"          7.812 KB       1 rows

. . exported "ANUJ"."INTERVAL_SALES":"SYS_P266"          7.812 KB       1 rows

. . exported "ANUJ"."INTERVAL_SALES":"SYS_P267"          7.812 KB       1 rows

Master table "ANUJ"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for ANUJ.SYS_EXPORT_TABLE_01 is:

  /home/oracle/INT1.DMP

Job "ANUJ"."SYS_EXPORT_TABLE_01" successfully completed at Thu Dec 8 18:21:07 2016 elapsed 0 00:00:51