Questions about Sysoper This system privilege in Oracle

We all know that after the Oracle database installation, the default will have such a number of system roles or permissions, Nomal,sysdba,sysoper, and so on, each time you log in to Oracle, is directly logged in as Conn/as sysdba, But I never knew what Sysoper was for, only that it was a system operator.

Then, today in the Sqlplus with Conn/as sysoper login, prompting insufficient permissions.

Then I went to look up some information about it. But still do not understand, finally still in a database QQ group inside asked this question, a Daniel taught me, really is long insight, so decided to record down.

SYSDBA and Sysoper two system permissions differences

"Sysdba" and "Sysoper" belong to the system privilege, also known as administrative privilege, with some administrative level permissions such as database turn-off. The specific permissions of SYSDBA and Sysoper are as follows:

"Sysoper" permissions, which are database operator permissions, include:
1. Open the 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 rights, permissions include:
1. Open the 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, and the other two, to investigate the rights they have 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.

In general, we pass this conn sys/** as SYSDBA (sysoper) is verified by the operating system at all without losing the user name password your login statement and Conn/as SYSDBA (sysoper) is an effect in LINUX/UNIX environment conn /as SYSDBA (Sysoper) can log in to Windows only Conn/as sysdba can log in Conn/as sysoper login not

This is due to 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 it is not possible to log in with Sysoper, which requires us to create this ora_oper group ourselves, and then add administrator users to the Ora_oper group.

By default, only ora_dba this group

The steps are as follows:
1, right button "computer"-"management"-"Local Users and Groups"-"group".

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

3. Enter the group name "Ora_oper" and add the members. Then select "Advanced" below the "Select User" pop-up box.

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

5.

6.

7.

8, OK, finished, again in the Sqlplus use Conn/as sysoper can be normal connection.

Questions about Sysoper This system privilege in Oracle