Why is it possible to log on to the oracle database as sysdba and enter your username and password ?, Sysdbaoracle
This is actually a problem with oracle database authentication.
In the sqlnet. ora file
SQLNET. AUTHENTICATION_SERVICES = (CNT)
Change
SQLNET. AUTHENTICATION_SERVICES = (NONE)
That is, you cannot use the system authentication method.
Why can I log on to Oracle using the Connect as sysdba username and password ??
As sysdba is used to log on AS a system administrator. The username and password are ignored. Even if you use SQLPLUS/as sysdba, you can use it without a user name or password.
Is the password in oracle the same as the user name? But why can I log on to the ORACLE database using sys/sys as sysdba?
The profile can be used to set the password style, but it can be set to the same name as the user name by default;
In addition, the sys/sys as sysdba logon method generally uses the operating system authentication method, but does not verify the password. You can try it, just enter a password or simply do not enter the password. For example:
Sqlplus sys/123 as sysdba
Sqlplus/as sysdba
Run the show user command and you will see that all of them are sys users.