Making progress... I turned off Virus protection, downloaded 12.2.0.2 32 bit client, and installed as Administrator, choosing 'Administration' option.
When I run SQL*Dev, I connect fine. (Connection type=basic, setting SID=orcl). When I run SQL*Plus, I now get a TNS Protocol error. I found that it is now using 32 bit SQL*Plus. When I use a fully pathed SQL*Plus (to 64 bit version), it connects fine as username/password. When I start Delphi Tokyo, I have set the ORACLE/PREFERENCES, and restarted. When I run the Deptemp demo, I enter my username/passwword, leaving database blank, and immediately get an ORA-12560: TNS:Protocol adapter error. I emptied out the ORACLE/PREFERENCES, restarted Delphi, ran the same DeptEmp, and get the same thing. If I put in 'orcl' as database, there is a long delay, and then I get ORA-12154:TNS: could not resolve the connect identifier specified. If I run 'lsnrctl services', I do show a service called 'orcl' with status of ready, and 14 established connections.
How do I debug this? How do I connect using DOA with a local connection from within Delphi?
Last edited by G Spears; 03/20/18 12:04 PM.