IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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 subsystemCause: 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/
