Home » SQL & PL/SQL » Client Tools » Ora 12c & iSQLplus (windows server 2012)
Ora 12c & iSQLplus [message #620109] Mon, 28 July 2014 22:26 Go to next message
oragami
Messages: 15
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 Go to previous messageGo to next message
BlackSwan
Messages: 23059
Registered: January 2009
Senior Member
isqlplus has been obsoleted & non-existent since V10
Re: Ora 12c & iSQLplus [message #620111 is a reply to message #620110] Mon, 28 July 2014 22:31 Go to previous messageGo to next message
oragami
Messages: 15
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 Go to previous messageGo to next message
BlackSwan
Messages: 23059
Registered: January 2009
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/
Re: Ora 12c & iSQLplus [message #620113 is a reply to message #620112] Mon, 28 July 2014 22:40 Go to previous messageGo to next message
oragami
Messages: 15
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.
Re: Ora 12c & iSQLplus [message #620114 is a reply to message #620113] Mon, 28 July 2014 22:44 Go to previous messageGo to next message
BlackSwan
Messages: 23059
Registered: January 2009
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).
Re: Ora 12c & iSQLplus [message #620141 is a reply to message #620113] Tue, 29 July 2014 07:15 Go to previous messageGo to next message
EdStevens
Messages: 333
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".
Re: Ora 12c & iSQLplus [message #620231 is a reply to message #620141] Wed, 30 July 2014 07:07 Go to previous message
thatjeffsmith
Messages: 40
Registered: July 2009
Location: Raleigh, NC
Member

If you have APEX going, your users can run SQL via it's SQL Workshop feature.
Previous Topic: SQL Developer 4 -- DBMS Output not working
Next Topic: SQL Dev- connect to Win Server 2012
Goto Forum:
  


Current Time: Thu Nov 27 02:36:44 CST 2014

Total time taken to generate the page: 0.10781 seconds