ORACLEwallet configuration/management/Use

When we configured the database yesterday, we added a new database to wallet. In reality, we do not need to enter the user name and password to log on to the database, the whole monitoring system reports a user name and password error.

When we configured the database yesterday, we added a new database to wallet. In reality, we do not need to enter the user name and password to log on to the database, the whole monitoring system reports a user name and password error.

When we configured the database yesterday, we added a new database to wallet. In reality, we do not need to enter the username and password to log on to the database. After adding the database, as a result, the whole monitoring system reports a user name and password error and cannot log on to the database. However, ORACLE users can log on to the database normally without entering a password. In fact, the reason is very simple, because our monitoring system is nagios, and the default permission for wallet-related files is 600, other users except ORACLE cannot read or write, under normal circumstances, we changed the permission to 777 so that other users can use the wallet function. When I add a new database to the wallet, wallet will add the cwallet. sso and ewallet. change the permission of the p12 file to 600. This has led to my tragedy today.

The following is a simulation of wallet's configuration, management, maintenance, and symptom.

1. Create a wallet

2. Configure wallet to sqlnet. ora

3. view the wallet command for help

Wallet is good, because you can see the help of the command by using help. You don't need to record complicated parameters, just remember the mkstore command to manage wallet.

4. Add the database to the wallet and test whether the server space is successful.

5. view the entry

6. Create a default user and password

In this way, you can use the default user and password to log on to the database.

7. When the Default User and manually added database information are sent to the wallet, what will take effect?

Next let's test: When the wallet creates the Default User and password, when the Hong Kong Space is added to the wallet manually, does the default user or manual addition take effect? In fact, the manual addition takes effect.

8. The following test shows that after modifying the content in the wallet through mkstore, the permission of the wallet-related files is automatically changed to 600.

9. When the user's password changes, you need to change the password in the wallet.

10. Check the authentication information in the wallet.

11. Delete the configuration information of a net service from wallet.

12. Modify the Default User Name

The same is true for modifying the password of the default user name.

13. Delete the Default User Name

We usually have so much maintenance.

This article is from the "seriously lose" blog. Please keep this source