Home > database >  Oracle using sys or sysdba login shows insufficient permissions
Oracle using sys or sysdba login shows insufficient permissions

Time:09-23

After I installed the oracle11g built a former library, this is normal, but the experiment 2 in addition to create a database, set up is completed with the sysdba unable to connect to the database, tried uninstalling database software, delete the database, the new database, all not line, but in the up sqlplus using the system + password can log in the database, but we require the underlying some of the operation, not only spend system, group I baidu said there is a problem to upgrade to win10 enterprise edition, in addition to this, there is no other way it TAT

CodePudding user response:



The first figure is not login password displayed when insufficient permissions, the second figure is used up sqlplus login scenario
The solution genuflect is begged

CodePudding user response:

You use up sqlplus sys/password as sysdba on this board is not?

CodePudding user response:

1, export or set corresponding sid
2, check the sqlnet. Ora configuration inside

CodePudding user response:

Operating system user join ora_dba group

CodePudding user response:

Windows also have to see the sqlnet. Ora file
  • Related