Isqlplus is a new feature provided by Oracle9i and is a sqlplus Web-form release. is based on a three-tier structure.
Its client, middle, and server can be located on the same machine or on a different machine. Isqlplus does not require a separate installation to access Isqlplus
You only need to know the middle-tier server address and port, can be a standard user or SYSDBA, sysoper identity log.
Isql*plus provides a fast, browser-based interface that uses a three-tier model to use the Sql*plus processing engine, which includes:
The client layer (Isql*plus user interface, usually a Web browser).
Middle tier (Isql*plus server, Oracle Net, and Oracle HTTP server).
Database Layer (oracle9i).
These three layers can be located on the same computer or on different computers. The Isql*plus server must be located on the same computer as the Oracle HTTP server.
The middle layer is responsible for coordinating interaction and resources between the client layer and the database layer. The database layer is oracle9i and can be accessed through Oracle Net.
Here is a detailed introduction
1. Start the HTTP server
Start HTTP Server Powered by Apache
2. Access HTTP server via browser
General default settings Our ports and protocols are:
HTTP 7778 Port/HTTPS 4443 Port
Note: Different versions may use different ports, specifically you can view the default port settings by looking at the Ports.ini file under $oracle_home/apache/apache.
If you need more of this port, you can change the port settings by adjusting the $oracle_home/apache/conf/httpd.conf file.
As set out in this example:
http://ggqiang:7778
https://ggqiang:4443
The browser input appears as follows:
Or:
3. Start Isqlplus
By typing in the browser
Http://machine_name.domain:port/isqlplus
You can start Isqlplus:
Enter the username password and so on to log in to the database and execute the SQL statements and script files.
You can also load the call to execute:
4. Landing in SYSDBA's capacity
Log in as SYSDBA, need to run:
Http://machine_name.domain:7778/isqlplusdba
This requires you to first enter the HTTP server password, which is different from the database authentication.
SYSTEM 1712 1432 0 19:24:16 conin$ 0:00 "D:/oracle/ora92/bin/isqlplus"
C:\>
Others please refer to:
Sql*plus Quick Reference Release 9.2 part No. A90843-01
Isqlplus Online Help Manual
The author of this article:
Eygle,oracle technology concern, from China's largest Oracle technology forum Itpub.
Www.eygle.com is the author's personal site. You can contact the author by Guoqiang.Gai@gmail.com. Welcome technical discussions and exchange of links.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
