Oracle Wallet login without a password
-- 1. check the oracle home System variable c :\> echo % ORACLE_HOME % C: \ Oracle \ product \ 11.2.0 \ dbhome_1 -- 2. find the appropriate location to create the wallet folder c: \> cd % ORACLE_HOME % \ NETWORK \ ADMINC: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN> mkdir wallet -- 3. run the mkstore command to create oracle's wallet (wallet) c :\> cd % ORACLE_HOME % \ BINC: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ BIN> mkstore-wrl % ORACLE_HOME %/network/admin/wallet-create enter the wallet password: Wallet123 (disable echo, not display, note that the password is case sensitive and the password strength is too weak.) confirm the wallet password: Wallet123 (disable echo, do not display, make sure it is exactly the same as the first input) -- 4. view the created oracle wallet (wallet) c :\> cd % ORACLE_HOME % \ NETWORK \ ADMIN \ walletC: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ wallet> dir2013/08/08 3,941 cwallet. sso2013/08/08 3,864 ewallet. p12 -- 5. edit % ORACLE_HOME % \ NETWORK \ ADMIN \ tnsnames. ora file, as follows ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = fhx-THINK) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) -- 6. add User authentication information to wallet, indicating that ORCL is the database name, HR is the user name, HR is the logon password of HR user c: \> cd % ORACLE_HOME % \ BINC: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ BIN> mkstore-wrl % ORACLE_HOME %/network/admin/wallet-createCredential orcl hr HREnter walletpassword: Wallet123 (disable echo, do not display, make sure it is consistent with the previous settings) Create credentialoracle. security. client. connect_string1mkstore-wrl % ORACLE_HOME %/network/admin/wallet-listCredentialEnter walletpassword: Wallet123 (turn off echo, do not display, make sure it is consistent with the previous setting) orcl hr HR--7. edit ORACLE_HOME \ network \ admin \ sqlnet. add the following content to the ora FILE: WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = C: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ wallet) SQLNET. WALLET_OVERRIDE = TRUE---8. the verification result adopts sqlplus logon verification (provided that both the listener and oracle Database Service are enabled) C: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ BIN> sqlplus/@ orclSQL> show userUSER is "HR" C: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ BIN> sqlplus/nologSQL> conn/@ orclSQL> show userUSER is "HR" -- prove that wallet can allow HR users to successfully log on without a password