Unable to drop DBLink - Error: ORA-02082

ORA-02082: a loopback database link must have a connection qualifier

Reason is due to the global_name for the database:

1. select * from global_name;

2. note down the value

3. alter database rename global_name to some_new_name;

4. drop public database link linkname.whatever;

5. now change the global_name back using alter database rename global_name to original value;