Site icon IT Tutorial

TNS-01191: Failed to initialize the local OS authentication subsystem

Hi,

Sometimes You can get “TNS-01191: Failed to initialize the local OS authentication subsystem ” error.

 

Details of error are as follows.

TNS-01191: Failed to initialize the local OS authentication subsystem
Cause: Initialization of the security subsystem failed during listener startup or reload.
The listener could not obtain system resources (memory, or file descriptors) needed for local OS authentication security mechanism.
Action: Make sure that system resources like shared memory and heap memory are available for listener to execute properly.
For further details, turn on tracing and execute the operation again. If the error persists, contact Oracle Support Services.
TNS-01191: Failed to initiate the local OS authentication subsystem

 TNS-12560: TNS:protocol adapter error

 TNS-00583: Valid node checking: unable to parse configuration parameters

 

Check and get the loopback interface up and running and restart the listener. If it is not up, then enable it as follows.

#ifup lo  (this brings up the loopback interface)

 

[root@msdbadm01 ~]# ifconfig -a

lo        Link encap:Local Loopback
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:2413323 errors:0 dropped:0 overruns:0 frame:0
          TX packets:2413323 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:165596646 (157.9 MiB)  TX bytes:165596646 (157.9 MiB)

When you got this error, check your /etc/hosts file, if the following entry don’t exist in the /etc/hosts file,

127.0.0.1 localhost.localdomain localhost



 

Or  If you use oracle wallet , then remove manually added entries and set it up using ‘owm’ utility, which exist in $ORACLE_HOME/bin.

 

Do you want to learn more details about RMAN, then read the following articles.

https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/

 

Exit mobile version