OraFAQ Forum: Client Tools » How to access database with Toad , No Oracle Software Installed

Home » SQL & PL/SQL » Client Tools » How to access database with Toad , No Oracle Software Installed (Oracle 10g Toad )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to access database with Toad , No Oracle Software Installed [message #635142]

Mon, 23 March 2015 00:59

jgjeetu
Messages: 365
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

Lalit Kumar B
Messages: 3149
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

Littlefoot
Messages: 21507
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.

Report message to a moderator

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

EdStevens
Messages: 1125
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.

Report message to a moderator

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

gazzag
Messages: 1082
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

BlackSwan
Messages: 26607
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

Report message to a moderator

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

EdStevens
Messages: 1125
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.

Report message to a moderator