My credentials – not an oracle tech nor a DBA
My issue – I have just got a new PC, on my old PC (windows XP) I used to have a tool to query our oracle database. This tool is similar to TOAD from bentic software:
I have installed the the quiery software fine. The full oracle client fine. I have also copied over tnsnames.ora file to the required directory.
Now, in the drop down box in the query tool it lists all available databases. However, when I supply the correct login credentials, I am met with a:
ORA 12154 error – could not resolve the connect identifier specified?
I am not sure if the database has IP restrictions which devices could connect – but if not – any idea where I am gong wrong.
Please keep your answers basic.