In order to set LOCAL_LISTENER parameter for non-default port, Which one is recommended method?
SQL>alter system set LOCAL_LISTENER="(address=(protocol=tcp)(host=yourhost)(port=1522))" SCOPE=SPFILE;
Or
1.Create a tns entry in the tnsnames.ora file
2.Set LOCAL_LISTENER to point to tnsnames.ora file to resolve tns name