0

I have remove the oracle 11g (following How do I do a manual uninstall of Oracle?) Then install the oracle 12

However, I'm getting a ORA-12560: TNS:protocol adapter error, when I'm using new oracle. Its look like there are still some references to old oracle.

enter image description here As per picture above, how do I delete oraclient11g_home1 in windows?

Christopher Jones
  • 9,449
  • 3
  • 24
  • 48
BoomRamada
  • 121
  • 1
  • 2
  • 11

2 Answers2

0

You are dealing with the ODBC admin here. It's not about deleting the driver, it's about redefining your DSN to use the new driver.

As for actually removing the driver, if you uninstalled oracle, then the only thing to be removed is two entries in the Windows registry. Unfortunately, I don't have access to a system with Windblows, so cannot give you the details. If you are not experienced in mucking about in the registry, you could just leave that in place, as it is not hurting anything.

EdStevens
  • 3,708
  • 2
  • 10
  • 18
0

Open your Registry editor and navigate to

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle in OraClient11g_home1

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers\Oracle in OraClient11g_home1

Delete the keys/values. Then the ODBC driver is removed. However as mentioned by @EdStevens this may not solve your problem.

Wernfried Domscheit
  • 54,457
  • 9
  • 76
  • 110
  • Deleting the registry key fixed the Oracle 11 appearing on ODBC driver list but I'm still getting the ORA-12560: TNS:protocol adapter error. Which means, I need to redefining DSN to use the new drive. How I'm gonna do that? – BoomRamada Aug 15 '21 at 10:38
  • 3
    _" I need to redefining DSN to use the new drive. How I'm gonna do that?"_ In the ODBC admin (the one you gave the screen shot for, click on one of the 3 'DSN' tabs -- probably the System DSN. Click on the DSN in question. Click on 'Configure'. – EdStevens Aug 15 '21 at 22:56