- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
ORA-12547 TNS:lost contact after SUCCESSFULL switchover
i've got a setup of 2 instances in dataguard. First one primary and secondary standby.
There's a broker working and when i do switchover by command:
SWITCHOVER to standby
it gives me output that it is successful (no error, no gaps, everything works, even redo apply on standby). But there's the problem.
From now i cannot login "sqlplus / as sysdba" on standby host. Remote connections trough tns connect identifier works great but locally it gives me an error ORA-12547. Only reboot of host helps me to get rid of that error.
Also - the same error exists when i switch from standby to primary - and from now i cannot login without password to instance because of ora-12547 and i need to reboot.
So it's basically like: every instance that has been switched to be standby has the ora-12547 error.
I checked file permissions, relinking oracle binaries, soft limits and nothing helps me but reboot of actual standby host.
Where's the problem? Any ideas?
Oracle 19c, RHEL 8.5