With a little side of applesauce...

Monday, September 17, 2012

Using EMACS sql-oracle without a tnsnames.ora

I am an Oracle wimp, and so when I couldn't get EMACS sql-oracle to find the tnsnames.ora on my Mac, I brought the tnsnames.ora to EMACS :)
M-x sql-oracle
User: myusername
Password: mypassword
Database: (description=(address_list=(address=(protocol=TCP)(host=myhost.example.com)(port=1521)))(connect_data=(SERVICE_NAME=myservicename)))

Just place the description information that you find in the tnsnames.ora into the Database: prompt, (remove all whitespace and newlines).

No comments: