How to Resolve ORA-12528

Solution : 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)
        )
    )