----- In Oracle 12.1.0.2, created the wallet by using below commands:
TEST$ orapki wallet create -wallet "/u01/app/oracle/admin/TEST/wallet" -pwd **** -auto_login_local
Oracle PKI Tool : Version 12.1.0.2
Copyright (c) 2004, 2014, Oracle and/or its affiliates. All rights reserved.
TEST$ mkstore -wrl "/u01/app/oracle/admin/TEST/wallet" -createCredential TEST2 sys ********
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
----- But when I logged into the database with sys user, the show user showed OPS$ORACLE user instead of sys:
TEST$ sqlplus /@TEST2
SQL*Plus: Release 12.1.0.2.0 Production on Thu Aug 9 13:09:38 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Thu Aug 09 2018 03:18:20 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> sho user
USER is "OPS$ORACLE"
SQL>
----- So made following changes and it worked fine:
Put following entry in sqlnet.ora file:
SQLNET.WALLET_OVERRIDE = TRUE
The SQLNET.WALLET_OVERRIDE entry allows this method to override any existing OS authentication configuration.
and used mkstore to create the wallet:
TEST$ mkstore -wrl "/u01/app/oracle/admin/TEST/wallet" -createCredential TEST2 sys
No comments:
Post a Comment