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...