Site icon IT Tutorial

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

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/

Exit mobile version