Hi,
You can get ” ORA-01988: remote os logon is not allowed ” error during the drop any user.
Details of error are as follows.
ORA-01988: remote os logon is not allowed
Cause: Remote os login attempted when not allowed.
Action: Use a local client, or use the remote_os_authent system parameter to turn on remote os logon.
To solve this error, You should enable the remote_os_authent parameter as follows.
SQL> show parameter remote_os_authent NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ remote_os_authent boolean FALSE SQL> SQL> alter system set remote_os_authent=true scope=spfile sid='*';
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/