ora - 12514 and ora - 12505 tns listener error fixed

Here's how to fix this ora.

Open SQL Plus

run SYS/SYS as SYSDBA

then write the following lines :


show parameter local_listener


alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=LOCALHOST)(PORT=1521))'  scope=both;


alter system register;


show parameter local_listener


enjoy watching video...