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

Review of Gartner Magic Quadrant for Business Intelligence Platforms - Feb 2012

By -
Image
Gartner spends a lot of time reviewing the major Business Intelligence platform vendors and talking to the users of BI to come up with the updates in the Magic Quadrant. Here is the latest one released in Feb 2012. As you can see the notables in the Leaders Quadrant are Oracle taking the top stop in ability to execute with OBIEE and BI Applications (OBIA)  and IBM establishing itself as the visionary with Cognos and related offerings. Look at my similar posting from Jan 2010 here (  http://oraclebiwasig.blogspot.com/2010/01/gartner-2010-magic-quadrant-for.html  )  The BI Platform leaders in Jan 2010 were Oracle, IBM, Microsoft, SAS, Microstrategy, SAP (Business Objects) and Information Builders. Compared to 2010, now QlikTech has entered the leaders quadrant. Gartner quotes "QlikTech is a marketing juggernaut; it has brand recognition many times more prominent than a firm with its current market share would expect." I have heard of QlikView when Oracle talks of visuali
Read more

BIWA SIG Techcast : Oracle Enterprise "R" Nov 30, noon EST

By -
Subject:  Webinar: Using Oracle R Enterprise -- Nov 30, noon EST Date:  November 22, 2011 11:55:15 AM EST Analytic friends: Happy Thanksgiving!! Oracle BIWA SIG is hosting a webinar next week that I think might interest many of you.  Here's the info about it. ============================== ============ Webinar: Using R within Oracle -- Nov 30, noon EST ============================== ============ Oracle now supports the R open source statistical programming language. Come to this webinar to learn more about using R within an Oracle environment. -- URL for TechCast:  https://stbeehive. oracle.com/bconf/confDetails? confID=334B:3BF0:owch: 38893C00F42F38A1E0404498C8A661 2B0004075AECF7&guest=true& confKey=608880 -- Web Conference ID: 303397 -- Web Conference Key: 608880 -- Dialup:  1-866-682-4770 , ID 5548204, passcode 1234 After a steady rise in the past few years, in 2010 the open source data mining software R overtook other tools to b
Read more

Down the Memory Lane - BIWA SIG to BIWA Users Community to Analytics & Data Summit 2018

By -
Image
Let us go down the memory lane, it all started in 2006, soon after Oracle acquired Siebel . While Siebel was well known for CRM, the Siebel Analytics helped to get Oracle on the BI map. Mid-2006, was a good time to start a Special Interest Group (SIG) with focus on Data Warehousing and Business Intelligence. Same year Oracle acquired Synopsis    (Oct 2006) and then Hyperion in 2007.  The Technology-centric User Group - IOUG  facilitated the start of the DWBI SIG. DBBI SIG's first public appearance was in NYOUG 's summer and fall events in New York. Then this SIG was invited to present a session at Oracle Openworld 2006, in the Sunday User Group Day. After Oracle Openworld, Charlie Berger joined hands with this SIG, and brought along his rich experiences from the Life Science Group called OLSUG . This was the time the SIG realized that its name needed to reflect Advanced Analytics (AA) so the new name BI + DW + AA condensed to BIWA SIGwas adopted and hence the url www.OracleB
Read more