ISQLPLUS is a new function provided by Oracle9i and is released in the web form of sqlplus. It is based on a three-tier structure.
Its client, middle, and server can be located on the same machine or on different machines. ISQLPLUS does not need to be installed separately. Access ISQLPLUS
You only need to know the address and port of the intermediate layer server. You can log in as a standard user or sysdba or sysoper.
ISQL * Plus provides a fast browser-based interface. It uses the SQL * Plus processing engine through a three-tier model. This model includes:
Client layer (iSQL * Plus user interface, usually a web browser ).
Middle Layer (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 on the same computer as the Oracle HTTP Server.
The middle layer coordinates the interaction and resources between the client layer and the database layer. The database layer is Oracle9i and can be accessed through Oracle Net.
The following is a detailed introduction.
1. Start the HTTP server on the server
Start HTTP server powered by Apache
2. Access the HTTP server through a browser
Generally, our port and protocol are set by default:
HTTP 7778 port/HTTPS 4443 Port
Note: different versions may use different ports. You can view the default port settings in the ports. ini file under $ ORACLE_HOME/Apache.
If you need to change the port, you can modify the port settings by adjusting the $ ORACLE_HOME/Apache/CONF/httpd. conf file.
In this example, set:
Http: // ggqiang: 7778
Https: // ggqiang: 4443
After the browser is entered, the following information is displayed:
Or:
3. Start ISQLPLUS
Enter
Http: // machine_name.domain: Port/isqlplus
You can start ISQLPLUS:
Enter the username, password, and other information to log on to the database and execute SQL statements and script files.
It can also be loaded and called for execution:
4. log in as sysdba
To Log On As sysdba, run:
Http: // machine_name.domain: 7778/isqlplusdba
This requires you to enter the HTTP server password, which is different from database authentication.
Create an authentication password file:
D:/Oracle/ora92/Apache/bin> htpasswd:/Oracle/ora92/sqlplus/admin/iplusdba. Pw Admin
Automatically using MD5 format on Windows.
New Password :*****
Re-type new password :*****
Adding password for user admin
Then you can use this user to log on to the database as sysdba:
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.
