Shulou(Shulou.com)06/01 Report--

Today, there is an ORA-01031 error (in essence, insufficient authority) when logging in to oracle. By querying the login authentication mode of Oracle, using sysdba identity to connect to the database instance, the authentication method used is operating system authentication, and this authentication operation process is the process that the operating system verifies whether the user can connect to the database according to the information it manages.

So, I added the users I logged into the operating system to the ora_dba group.

What to do: run the input compmgmt.msc, then find ora_dba in the groups of local users and groups, right-click Properties-add-Advanced-find now-SenLinChen (find users logged into your own operating system)-OK.

It can be solved through the above methods.

-- operating environment:

OS:windows10_x64 Education Edition

Oracle:Oracle_11g_x32

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.