Sqlplus and PLSQL in Windows 7 have some strange problems.

Recently, PLSQL was installed in windows, but it encountered a strange problem and was unable to connect to the database server.

However, using the tnsping command to test, my connection configuration is correct.

So I switched to an XP client to connect.

The final problem is that you need to run sqlplus or PLSQL as administrator. The method is:

Right-click on PLSQL and choose "Run as administrator ".

You can.

However, is this very troublesome? So I don't want to be so troublesome every time I run it. What should I do? The simplest way is to log on to the system using the administrator account ~

However, in Windows 7, the Administrator account is locked by default, and it is not difficult to open it:

Right-click "my computer" on the desktop, open "manage", double-click "local users and groups" on the left, click "user", and right-click the "Administrator" account on the right, open "properties", remove the check box before "Account Disabled", and log out after confirmation. you can log on with the administrator account.

 

Summary: If Windows 7 is changed, some operations may be different from the previous XP operations. If there is a strange problem, try another operating system ~