ORA-01988: remote os logon is not allowed

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

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/