Using iSql in Oracle

Can u tell me how do v connect using Isql?? and is this connection
possible over the internet?? Say I am in Us and my server is in India, so
is this connection possible and if yes how do v configure to do this
connection??

Thnx in advance

Regards,

Ravin Kayasth

I never did anything by accident, nor did any of my inventions come by
accident; they came by work.
Thomas A. Edison

Learn from yesterday, live for today, hope for tomorrow. The important
thing is not to stop questioning.
Albert Einstein

<html><div style='background-color:'><P>Hi Ravin,</P>
<P>Yes give the server (machine name) name (not the database name).No you dont need any oracle component at the client side.You need a browser only.Using this you can query the database just like the sql plus.If you can pass ur mail id i can attach a html page of the output </P>
<P>Cheers !<br />
<br />
</P>
<DIV><STRONG><EM>Regards,</EM>< /STRONG></DIV>
<DIV><EM></EM> </DIV>
<DIV><FONT color=#000066><STRONG><EM>Prasanth.</EM>& lt;/STRONG></FONT></DIV>

I've seen several incidents refering the 'Isql'. I am wondering which
version Oracle this is available? We have 8.1.7, is it available in
this one? If so, do I need to have anything installed (server or
client)?
thanks.

Sometimes Oracle/Apache configures a non-standard port. If you have
difficulty, check the contents of ORACLE_HOME\Apache\apache\setupinfo.txt.
This will tell you the ports configured for iSQL*Plus and iSQL*Plusdba on
installation.

Additionally, in a Win2K environment, you might want to check that Windows
IIS is not taking over the web server role, because it does not know about
the iSQLPlus site.

ISQL*Plus was I think available in 8i (I for internet?) and I also believe
the default port is 7778.

In the Windows installation, the port for iSQL*Plus is defined in
%ORACLE_HOME%\oem_webstage\oem.conf via the listen and VirtualHost
directives. On my machine, the value for those directives is set to 3339.

The contents of the setupinfo.txt on my Windows machine refer only to the
HTTP (80) and HTTPS (443) ports. There is no reference to either 3339 or
7778 in there.

a.. Oracle9i Release 9.0.1.1 for Windows only
b.. Oracle9i Release 9.2.0.1 on most operating systems, including Windows,
Solaris, HP-UX, and Linux ."
As for the default port being either 7778 or 3339, there does not appear to
be a definitive answer in the Oracle documentation. The only thing they say
is to use
http://your-computer-name/isqlplus - this works for me without doing any
extra configuration. I guess the port issue is irrelevant for a standard
installation of Oracle 9.2. So I have been doing far more work than
necessary by specifying a port number.

I am glad the question was asked because I learnt something by trying to
answer it.

The Apache web server is needed for iSQL*Plus but you can access the
database directly via port 8080. This will take you to the Oracle HTTP
server (if installed) of the default database. However, this may not be
what you want because this port is used for the XML database services.

I tried your suggestin also, but its not working,same "page not found"
error, tell me one thing ajay, machine-name is just the "machine name' or
the fully qualified host name i.e "machine name.domain name", for me it
cud be just cpc-35 (machine name) or cpc-35.infotech.com (machine
name.domain name)?? any ideas??

Regards,

Ravin Kayasth

I never did anything by accident, nor did any of my inventions come by
accident; they came by work.
Thomas A. Edison

Learn from yesterday, live for today, hope for tomorrow. The important
thing is not to stop questioning.
Albert Einstein

but I did not install the apache in the oracle installation, but have an
external Apache running as needed for my application i.e PLM.... but I
dont think that cud be the issue, as it needs the apache and it is thr....
and tough I dint select the web server during the installation, it still
creates the Apache directory.... and its contains 4 files, but not the one
u mentioned.... any idea how do v confiure my external Apache to run
isql??

Regards,

Ravin Kayasth

I never did anything by accident, nor did any of my inventions come by
accident; they came by work.
Thomas A. Edison

Learn from yesterday, live for today, hope for tomorrow. The important
thing is not to stop questioning.
Albert Einstein

I tried using just the "http://your-computer-name/isqlplus" but still it
is giving the same error "Page Not Found" , tell is it necessary to have
Oracle HTTP server running, when I am having an external web server
'Apache" Running??

and u r right, thr is no mention of port numbers in the documentation.....

Douglas, I think u have oracle http server, so its not a problem for
you.... and u have the directory created , but I do not have
"%ORACLE_HOME%\oem_webstage\oem.conf" directory, i.e oem_webstage
created?? any ideas??

Regards,

Ravin Kayasth

I never did anything by accident, nor did any of my inventions come by
accident; they came by work.
Thomas A. Edison

Learn from yesterday, live for today, hope for tomorrow. The important
thing is not to stop questioning.
Albert Einstein

For Professional help with Careers and Training from entry level to Career
Changes

********************************************** *************************
The content of this e-mail, including attachments is a confidential
communication between Terasys Australia Holdings and the
intended addressee.
Any unauthorised use of the contents is expressly prohibited. If you have
received this e-mail in error please contact the sender immediately and then
delete the message and any attachment(s).
********************************************** *************************

Douglas,
Thanks for your informative response. This is just a quick reply as I
haven't had a chance to research, but I think the configuration information
including ports is contained in the httpd.conf file in
ORACLE_HOME\apache\apache\

I did find your reference to port 3339 however, and I could connect using
that - interesting!
I cannot connect without a port number.

I apologise for not being clearer in my reply. You would need to replace the
your-computer-name with either the IP address of your server or its global
name (e.g. server.company.com.in). I use http://10.0.0.1/isqlplus to
access my iSQL*Plus server.

From your description, it looks like you will need to install to the
iSQL*Plus component to get all of the required files. But this will install
another Apache server and this may complicate matters. From examining my
Apache configuration, I find there are CGI-bin files as well as
configuration and data files. There does not appear to be an easy way of
merging your external web server with the iSQL*Plus one unless you are an
Apache expert or are willing to become one.

With iSQL*Plus installed, you would have two (2) HTTP servers: the Apache
server and the Oracle HTTPD server. Both of these servers are needed for
iSQL*Plus to work.

Yeah Douglas, u r right, I did not have the full components for the iSQL,
only loaded partially and that was giving problems... it was when soemone
mentioned to check a particular file that I realised that this full
component is missing......

Thnx again for your informative reply, and now everything is working
perfectly.....

Regards,

Ravin Kayasth

I never did anything by accident, nor did any of my inventions come by
accident; they came by work.
Thomas A. Edison

Learn from yesterday, live for today, hope for tomorrow. The important
thing is not to stop questioning.
Albert Einstein

If you get no output from netstat -a -o | find "3339", this means that there
is no TCP/IP listener on port 3339 (and also there is no task with process
id of 3339). You can try the command with 3339 replaced by 7778 to see if
you can get any output. Or you can just use "netstat -a -o | more" to see
all of the opened ports and connections. The piping to the find command was
a shortcut to make searching for the text "3339" easier.

In the tasklist command, the 1460 is the Windows process ID that is
displayed in the last column of the "netstat -a -o" command. When I ran the
command on my machine, the process ID of the Apache web server was 1460.

I started doing some experimenting also after reading all the info from
everyone. As for me, I can connect from my workstation to my NT
server(s) both inside and outside the firewall just by using <A
href="http://http://<service_name>/isqlplus . I remember when I
installed the http server it asked for a port and I took the default,
but don't have to use anything. Below is my
oracle_home\oem_webstage\oem.conf file. Note that I am using
<service_name>, not <host_name> :

Port 3339 is configured as you say in the oem.conf file in the oem_webstage
directory. This folder seems to support a web-based version of the Oracle
Enterprise Manager rather than iSQL*Plus, though. A plug-in must be
downloaded to make this work, and I have not had a chance to do that yet.

I can't find anything in any of my logs to indicate a problem connecting
with http://<machine_name>/isqlplus. The browser is just unable to find the
server without specifying a port. Netstat shows ports 7778 and 4443 as
Listening. Do you know a way to check PIDs under Win 2K? I don't have the
additional functionality with Netstat and TaskList that you do with XP.

I have sometimes noticed on other installations that different ports are
chosen for some reason. I had assumed that it was because the defaults were
already assigned, but never checked into it. Most installations I have done
have used these ports.

I include below contents of the setupinfo.txt file and the relevant section
of the httpd.conf file, which specifies the ports apache is listening on:

SETUPINFO.TXT
****************************************
The following information is available in:
D:\OraHome90\Apache\Apache\setupinfo.txt

I tried researching the netstat command for Win2K without success for
getting the process id. I believe there is a tlist.exe on the Win2K CD-ROM.
tlist.exe has 'similar' functionality to tasklist.

I came across the ScriptAliasMatch directive in the Apache 1.3
documentation. These directives can be found in the
%ORACLE_HOME%\sqlplus\admin\isqlplus.conf which is included from the
%ORACLE_HOME%\APACHE\APACHE\CONF\ORACLE_APACHE .CONF file.
ScriptAliasMatch ^/isqlplus(.*) C:\oracle\ora92\bin\isqlplus
ScriptAliasMatch ^/isqlplusdba(.*) C:\oracle\ora92\bin\isqlplus

This directive maps /isqlplus to a CGI-BIN program which runs iSQL*Plus.
Removing these directives disabled iSQL*Plus completely.

In the $ORACLE_HOME\Apache\Apache\conf\httpd.conf file "Port" is set to
"7778". So my URL is like "http://10.0.0.89:7778/isqlplus". This one worked.
But it prompts for username/password. I tried scott, sys, my os account, and
another db account. None of them worked. Is there any thing I should change?
In the SQL*Plus, from the SQL prompt, "conn scott/tiger" connects to the
database.

What is happening is that the Apache server is asking you for a userid and
password that are stored in the file identified by the AuthUserFile
directive because you set Authtype to Basic for URLs containing '/isqlplus'.
You will have to use the htpasswd utility (the manual page is on your Apache
server under /manual). This means that you have a separate userid and
password from that of the Oracle server.

In my Apache setup, I only have these options set for the /isqlplusdba
location which is the default.

You are correct. I created the iplus.pw and iplusdba.pw files using the
htpasswd. Now when I tried http://10.0.0.89:7773/isqlplus it waits for
almost half an hour and returns page not found error. And I am getting the
below error message in the error_log file in the
$ORACLE_HOME/apache/apache/logs directory.

I have Oracle 9i Rel 1 in another WinXP machine. iSQLPlus is working fine
from that machine. isqlplus.conf file in 9i Rel 1 is entirely different from
Rel 2. Can someone send a copy of isqlplus.conf from Oracle 9i Rel 2? My id
is email@removed

Then stop the service. Go to the command prompt. CD to
%ORACLE_HOME%\Apache\Apache. Execute "apache -t". This checks the syntax of
all the config files and reports if any errors. If there are no errors, then
start the HTTP Server from Program groups or from the Run command box
(Start -> Run) execute "%ORACLE_HOME%\Apache\Apache\apache -k startup"

Note: Replace the %ORACLE_HOME% with the hard coded directory path. Execute
the commands without the double quotes.

I get the same error whenever I do an "apache -t" or "apache -k stop" when
the iSQL*Plus web server was started as a service (via the Services control
panel or by the 'sc' command in WinXP Pro). If I open a DOS box and start
the service via the apache command after shutting down the service, I do not
get the error when I use the apache command in other DOS boxes.

My conclusion is to either use services exclusively or use the apache
command exclusively - do not try to mix them.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.