Oracle 11g: Run SQL Developer from Windows - No Tnsnames.ora entry Required!

By -
Can you run SQLPLUS from Windows without a TNSNAMES.ora entry? Oracle 11g comes bundled with SQL Developer (just like OWB is part of the Oracle 11g database typical install). actually 11g is much more application centric and even the default folder for install is called apps.

Anyways, try out the SQL Developer that is bundled with the 11g RDBS install. It uses JDBC to connect to the database. You can run SQLPLUS as well from SQL Developer by pointing to the SQLPLUS.exe as the external executable and it will use the JDBC information to connect to the external database (even a 10G).

Comments

Post a Comment

Popular posts from this blog

Reboot of the In-Person Analytics and Data Summit ( Mar 14-16, 2023)

By -
Image
 The Analytics and Data Summit took place at Oracle Conference Center at Redwood City, CA from March 14-16. This in-person event restarted after a gap of 3 years. This event is organized by Analytics and Data Oracle User Community (AnDOUC). This event used to be called BIWA Summit and started in 2007, the first one was in the Oracle office at Reston, VA. It outgrew the size of the facility and moved to then Oracle HQ, at Redwood Shores in 2008. This year's Analytics and Data Summit, was spread over 3 days, with mainly the Hands on Labs and Product Manager feedback sessions on the 3rd day. This year the top level sponsors were Rittman Mead and Informatica. The event started on Tue with a Keynote titled "Gut Check - The True Value of Becoming a Data  Driven Organization" by Derek Hayden of OUTFRONT Media. Over the course of the event there were several sessions by presenters from companies like Siemens, Oracle and others. I was part of the opening Panel on Day 2. This Pane...
Read more

Analytics and Data Summit Mar 20-22, 2018 is Almost Here!

By -
Image
The Analytics and Data Summit starts next week on Tuesday, Mar 20th, 2018.  This event was formally called BIWA Summit. BIWA SIG started as IOUG SIG in 2016, and first BIWA Summit was held in 2007 in Reston, VA. Starting 2007, it moved to West Coast, to Redwood City. BIWA SIG is now an independent User Group of Oracle and is now called BIWA User Community . Checkout the Summit schedule here     It runs from Mar 20 to Mar 22, 2018. -------------------------------------------------------------------------------------------------------------------- Analytics and Data Summit Announces Oracle’s Andy Mendelsohn and Waqar Hasan as Keynote Speakers Redwood Shores, CA, March 16, 2018  – BIWA User Community announced today that Oracle senior executives Andy Mendelsohn, executive vice president, Database Server Technologies and Waqar Hasan, senior vice president, Big Data Analytics will deliver the opening keynote at the 2018 Analytics and Data Summit. The A...
Read more