How to Resolve ORA-02020: too many database links

Oracle Software

15 April 2022   0 Comment

We have prepared a script to learn the fra status of database instances Oracle cloud control. It caused the ORA-02020 error because the open_links parameter was insufficient. SQL> select * from dual@dbllink; ORA-02020: too many database links in use This is because both the OPEN_LINKS and the OPEN_LINKS_PER_INSTANCE server parameter are too small. SQL> show […]

Read More

ORA-46952: standby database format mismatch for password file

oracle dataguard

8 April 2022   0 Comment

If there is a gap problem in your standby dataguard environment and you are getting this error, you are in the right post. This error is a generic error and your password file indicates a problem. It’s time to check your file. Let’s get started. First of check, do a bidirectional connection test and make […]

Read More

How to Install Oracle Trace File Analyzer (TFA)

Oracle Software

  0 Comment

TFA is now called the Autonomous Health Framework (AHF). After this installation you will have (TFA) & ORAchk/EXAchk service. Oracle Trace File Analyzer TFA setup is very simple, please follow the steps below. Download Here Then put the downloaded file in any folder. Login as root. You can run the file. ./ahf_setup Make a note […]

Read More