ORA-12514

===============================================================================================

SQL> ALTER SYSTEM SET LOCAL_LISTENER="(address=(protocol=TCP)(host=10.10.10.99)(port=1523))"SCOPE=BOTH;

SQL> ALTER SYSTEM SET LOCAL_LISTENER='EPMDB' SCOPE=BOTH;

For instance specific include the sid='instance_name' parameter:

SQL>ALTER SYSTEM SET LOCAL_LISTENER="(address=(protocol=TCP)(host=10.10.10.99)(port=1523))" SCOPE=BOTH SID='instance_name';
Where instance_name is the unique name for the instance.