OraFAQ Forum: Client Tools » Ora 12c & iSQLplus

Home » Other » Client Tools » Ora 12c & iSQLplus (windows server 2012)

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

Ora 12c & iSQLplus [message #620109]

Mon, 28 July 2014 22:26

oragami
Messages: 16
Registered: July 2014

Junior Member

Hi.

Just wanted to know if it's possible to setup and run isqlplus for ora 12c. I am running win 2012 server that has iIS 8 load as well as fast cgi. I can load apache if necessary.
If you have any docs on how to set it up specific for my server/with ora 12c please give me some links on that . Also if 12c can't run isqlplus can 11g?

Many, many thanks.

oragami.

Cool

[Updated on: Mon, 28 July 2014 22:28]

Report message to a moderator

Re: Ora 12c & iSQLplus [message #620110 is a reply to message #620109]

Mon, 28 July 2014 22:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

isqlplus has been obsoleted & non-existent since V10

Report message to a moderator

Re: Ora 12c & iSQLplus [message #620111 is a reply to message #620110]

Mon, 28 July 2014 22:31

oragami
Messages: 16
Registered: July 2014

Junior Member

Wow thanks for such a quick response. So are there any alternatives to isqlplus so users can run sql commands on a browser over the web? Have wide area ip.

Also v10 would that be 10g?

Thank you.

[Updated on: Mon, 28 July 2014 22:36]

Report message to a moderator

Re: Ora 12c & iSQLplus [message #620112 is a reply to message #620111]

Mon, 28 July 2014 22:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

why must be browser based?

some clients use JDBC:thin & are self-contained not requiring any other "oracle" client software like below:

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

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

Report message to a moderator

Re: Ora 12c & iSQLplus [message #620113 is a reply to message #620112]

Mon, 28 July 2014 22:40

oragami
Messages: 16
Registered: July 2014

Junior Member

Thanks again.

Well I like users to simply log into my server and run sql commands including PLSQL. Telnet or ssh I suppose is fine if they can do it. They can perhaps use Java JDBC sure, but also I would like them to do command line perhaps. Any further thoughts on that?

Thank you.

Report message to a moderator

Re: Ora 12c & iSQLplus [message #620114 is a reply to message #620113]

Mon, 28 July 2014 22:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

if they are logged directly onto the DB Server itself, they can just run sqlplus & connect to the local DB.

if they are logged onto any system other than DB server either of the two clients I named can connect to DB from command line (or GUI shorcut).

Report message to a moderator

Re: Ora 12c & iSQLplus [message #620141 is a reply to message #620113]

Tue, 29 July 2014 07:15

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

oragami wrote on Mon, 28 July 2014 22:40

Thanks again.

Well I like users to simply log into my server and run sql commands including PLSQL. Telnet or ssh I suppose is fine if they can do it. They can perhaps use Java JDBC sure, but also I would like them to do command line perhaps. Any further thoughts on that?

Thank you.

No way would I be allowing users to log in directly to my database servers (telnet or ssh).

It would be nice if there were some purely browser-based solution like iSQL. Oracle abandoned it because it was too error prone and by their own admission was too complex to fix. The recommended replacement is SQL Developer. It's free. Installation is nothing more than downloading a zip file and unzipping it. It can use jdbc, so does not require the installation of the oracle client.

Without a browser-based solution, SOMETHING will have to be installed on the client machine. The only question is, "what".

Report message to a moderator

Re: Ora 12c & iSQLplus [message #620231 is a reply to message #620141]

Wed, 30 July 2014 07:07

thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC

Member

If you have APEX going, your users can run SQL via it's SQL Workshop feature.

Report message to a moderator

Previous Topic:	SQL Developer 4 -- DBMS Output not working
Next Topic:	SQL Dev- connect to Win Server 2012

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 04 22:01:05 CDT 2023