Hello,
I'm using XE 11g on a Windows 7 platform. I also have Microsoft Office 2013.
I have a macro in Excel that runs on a regular basis to load a small amount of data into Oracle tables. It worked fine for years.
Recently, for another reason, I had to update TNSNAMES.ORA on both the client and the server. I had to change the (SERVER = DEDICATED) setting to (SERVER = SHARED).
Since I made that change, the macro no longer works. If I change TNSNAMES.ORA back to DEDICATED on the client, all is well again, but my other new functions fail.
I get the following error from Microsoft VBA when I Open the connection from the client:
[Oracle][ODBC][Ora]ORA-12520: TNS Listener could not find available handler for requested type of server.
I'm posting the question here since the TNSNAMES.ORA setting seems to be the critical difference.
Thanks for looking at this.
Phil