How to Resolve ORA-12528

To fix this issue, we need to add a special parameter UR=A in connect descriptor to lift off the restriction. More specifically, we added (UR=A) for a connect identifier PRIM.

[oracle@prim ~]$ vi $ORACLE_HOME/network/admin/tnsnames.ora

PRIM =

    (DESCRIPTION =

        (ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))

        (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = PRIM)(UR=A)

        )

    )

Hope it Helps!