Questions about Sysoper This system privilege in Oracle

We all know that after the Oracle database installation is complete. By default, there are several system roles or permissions. Nomal,sysdba,sysoper Wait, every time you log in to Oracle. are directly logged in as Conn/as sysdba. But I never know what sysoper is for, just know it's a system operator.

Then, log in with Conn/as Sysoper in Sqlplus today. Insufficient prompt permission.

Then I went to look up some information about it. But still did not understand, finally still in a database QQ group inside asked this question, a Daniel taught me. It's really a long time, so I decided to write it down.

SYSDBA and Sysoper two system permissions differences

"Sysdba" and "Sysoper" belong to the system privilege. Also known as administrative privilege. Have access to some system administration levels, such as database turn-off. SYSDBA and Sysoper detailed permissions such as the following:

"Sysoper" permissions, that is, database operator permissions. Permissions include:
1. Open Database Server
2. Close the database server
3. Backing Up the database
4. Restore the database
5. Log Archive
6. Session Limit

"SYSDBA" permissions, that is, database administrator permissions, permissions include:
1. Open Database Server
2. Close the database server
3. Backing Up the database
4. Restore the database
5. Log Archive
6. Session Limit
7. Management function
8. Create a Database

We know that "normal" is a normal user, while the other two. Inspection of their rights to know: "SYSDBA" has the highest system permissions, after logging on is the SYS "Sysoper" is mainly used to start, close the database, Sysoper login after the user is public.

Under normal circumstances. We pass this conn sys/** as SYSDBA (sysoper) is verified by the operating system at all without losing Usernamepassword your login statement and Conn/as SYSDBA (sysoper) is an effect in linux/ Conn/as Sysdba (sysoper) in a UNIX environment can log in to Windows where only Conn/as sysdba can log in Conn/as Sysoper

This is because of a default configuration problem in Windows environment, theoretically there should be ORA_DBA group and ora_oper Two user groups are assigned to administrator but it only established ORA_DBA group without Ora_oper Group ...

So you can't log in with Sysoper. This requires that we create the Ora_oper group ourselves, and then add the Administrator user to the Ora_oper group.

By default there is only ora_dba this group

Procedures such as the following:
1, right button "computer"-"management"-"Local Users and Groups"-"group".

2. Right button "group"-"new group ...".

3. Enter the group name "Ora_oper" and join the member. Then select "Advanced" in the "Select User" pop-up box below.

4, then select "Find Now". Select Administrator This member. Then click "OK".

5.

6.

7.

8, OK, done. Use Conn/as Sysoper again in Sqlplus to connect properly.

Questions about Sysoper This system privilege in Oracle