Home » SQL & PL/SQL » Client Tools » How to access database with Toad , No Oracle Software Installed (Oracle 10g Toad )
How to access database with Toad , No Oracle Software Installed [message #635142] Mon, 23 March 2015 00:59 Go to next message
jgjeetu
Messages: 363
Registered: July 2013
Location: www.Orafaq.com/Forum
Senior Member

I have to access oracle database on a system, but there is no oracle software installed on a system.
There is only Toad.
How can I access database through Toad. Please Help.
Both systems are in network.

Thanks

[Updated on: Mon, 23 March 2015 01:00]

Report message to a moderator

Re: How to access database with Toad , No Oracle Software Installed [message #635144 is a reply to message #635142] Mon, 23 March 2015 01:23 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3131
Registered: May 2013
Location: World Wide on the Web
Senior Member
jgjeetu wrote on Mon, 23 March 2015 11:29
I have to access oracle database on a system, but there is no oracle software installed on a system.


You mean to access a remote database?

Quote:
The remote computer must have Oracle client software installed. It is through Oracle client software that Oracle command-line utilities (and your applications) connect to the database.

[Updated on: Mon, 23 March 2015 01:25]

Report message to a moderator

Re: How to access database with Toad , No Oracle Software Installed [message #635148 is a reply to message #635142] Mon, 23 March 2015 02:54 Go to previous messageGo to next message
Littlefoot
Messages: 21446
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As TOAD is already installed, you'll have to establish connection to a database.

As far as I can tell, TOAD requires (at least) Oracle (instant) client in order to run. Therefore, modify TNSNAMES.ORA files and put a database (you'd want to connect to) into that TNSNAMES.ORA. Doing so, TOAD will recognize it and offer the database in TNS tab's select list item in its login window.

Alternatively, use "Direct" tab which enables you to manually insert all those information. That option is OK if you use it once or twice, but you might get tired if you use it all the time.

I never used LDAP option.
Re: How to access database with Toad , No Oracle Software Installed [message #635154 is a reply to message #635142] Mon, 23 March 2015 07:48 Go to previous messageGo to next message
EdStevens
Messages: 1005
Registered: September 2013
Senior Member
jgjeetu wrote on Mon, 23 March 2015 00:59
I have to access oracle database on a system, but there is no oracle software installed on a system.
There is only Toad.
How can I access database through Toad. Please Help.
Both systems are in network.

Thanks


If there is no oracle client installed, then you cannot access the database. Period. Full stop. It's the oracle client libraries that enable ANY front-end tool, (for example, Toad) to access the database.
Re: How to access database with Toad , No Oracle Software Installed [message #635156 is a reply to message #635142] Mon, 23 March 2015 08:05 Go to previous messageGo to next message
gazzag
Messages: 1034
Registered: November 2010
Location: Bristol, UK
Senior Member
As suggested, download and configure Instant Client and get back to us.

[Edit: typo]

[Updated on: Mon, 23 March 2015 08:06]

Report message to a moderator

Re: How to access database with Toad , No Oracle Software Installed [message #635157 is a reply to message #635154] Mon, 23 March 2015 08:49 Go to previous messageGo to next message
BlackSwan
Messages: 26274
Registered: January 2009
Location: SoCal
Senior Member
>If there is no oracle client installed, then you cannot access the database. Period. Full stop.

Except when client uses JDBC:thin like client below

http://squirrel-sql.sourceforge.net/

then no Oracle client libraries are required
Re: How to access database with Toad , No Oracle Software Installed [message #635198 is a reply to message #635157] Tue, 24 March 2015 08:14 Go to previous messageGo to next message
EdStevens
Messages: 1005
Registered: September 2013
Senior Member
BlackSwan wrote on Mon, 23 March 2015 08:49
>If there is no oracle client installed, then you cannot access the database. Period. Full stop.

Except when client uses JDBC:thin like client below

http://squirrel-sql.sourceforge.net/

then no Oracle client libraries are required


But doesn't that just mean the product is bundled with the necessary jar files, which themselves encapsulate the necessary oracle-specific libraries?

I'd say that with certain products it may not be necessary to do a separate install of an oracle client, but ultimately some form of an oracle client is going to be necessary.
Re: How to access database with Toad , No Oracle Software Installed [message #635199 is a reply to message #635198] Tue, 24 March 2015 08:21 Go to previous messageGo to next message
BlackSwan
Messages: 26274
Registered: January 2009
Location: SoCal
Senior Member
find $ORACLE_HOME -name \*jdbc\*jar -ls

Every Oracle version I have seen includes necessary jar file which can be used in CLASSPATH
Re: How to access database with Toad , No Oracle Software Installed [message #635633 is a reply to message #635199] Fri, 03 April 2015 12:58 Go to previous message
Bill B
Messages: 1813
Registered: December 2004
Senior Member
BlackSwan wrote on Tue, 24 March 2015 09:21
find $ORACLE_HOME -name \*jdbc\*jar -ls

Every Oracle version I have seen includes necessary jar file which can be used in CLASSPATH


Which assumes that a client/database has been installed.
Previous Topic: SQL*Plus not executing scripts, goes into an editor mode(!?) instead
Next Topic: debugging of trigger in sql developer
Goto Forum:
  


Current Time: Wed Nov 14 07:04:34 CST 2018