OraFAQ Forum: Client Tools » how to open my sql editor in browser

Home » Other » Client Tools » how to open my sql editor in browser

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

how to open my sql editor in browser [message #217373]

Thu, 01 February 2007 22:42

pavan27
Messages: 50
Registered: December 2006
Location: bangalore

Member

Hi to everyone,

i want to know how to open sql editor in the browser. i am using oracle version is Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production. can any one send me suggestions please.

regards,
pavan

Report message to a moderator

Re: how to open my sql editor in browser [message #217383 is a reply to message #217373]

Thu, 01 February 2007 23:29

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I believe you are talking about iSQL*Plus. If so, URL looks like this: http://127.0.0.1:5561/isqlplus. 127.0.0.1 is "localhost" (you'd use real name or IP address), 5561 is port number. If you don't know / forgot it, check "C:\oracle\product\10.2.0\db_1\install\portlist.ini" (or similar) file. If you were the one who installed the database, this information was presented to you during installation process.

Report message to a moderator

Re: how to open my sql editor in browser [message #217594 is a reply to message #217383]

Fri, 02 February 2007 23:00

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
also check ISQLPLUS services is start.

START --------- RUN ---- SERVICES.MSC <<ENTER>>

OracleOraDb10g_home1iSQL*Plus ( OR SIMILAR)

REGARDS
Taj

Report message to a moderator

Re: how to open my sql editor in browser [message #267516 is a reply to message #217383]

Thu, 13 September 2007 10:45

deepslol
Messages: 3
Registered: September 2007

Junior Member

Hii..,

HOw do we configure iSQL * plus in linux..?

My server is Redhat linux .

I want to access my database through iSQL*plus in windows clients..!!

THanks in advance

Deeps..

Report message to a moderator

Re: how to open my sql editor in browser [message #267606 is a reply to message #267516]

Thu, 13 September 2007 19:36

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You need to configure the tnsnames.ora on the Linux server and start the iSQL*Plus Application Server on the Linux server with:

$ORACLE_HOME/bin/isqlplusctl start

You also need to ensure that the listener is configured and started on the Linux server.

$ORACLE_HOME/install/portlist.ini should provide the port number for you. You can connect to iSQL*Plus using the information Littlefoot provided above.

[Updated on: Thu, 13 September 2007 19:39]

Report message to a moderator

Re: how to open my sql editor in browser [message #267776 is a reply to message #267606]

Fri, 14 September 2007 15:54

deepslol
Messages: 3
Registered: September 2007

Junior Member

HIi..

Thats Fine...

Let me try that...

Thanks a lot..

Deeps

Report message to a moderator

Previous Topic:	scroll page-wise in SQL Plus
Next Topic:	Generate Scripts For All Object

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 08:11:08 CST 2025