We all know we can access database using SQL*plus or any other third party software like tora toad etc. Using Oracle Enterprise Manager we can also do the same task.
Oracle provides a web-based version of the SQL*Plus tool called iSQL*Plus.iSQL*Plus has a server-side listener process that must be started in order for clients to connect to a database through the browser interface.
In order to access database using iSQL*Plus we need to go through following steps.
1)Invoke lsnrctl status and ensure that listener service is running.
2)Invoke emctl status and ensure that Ddatabase Control agent is running. If not running then invoke emctl start dbconsole.
3)See the url after invoking emctl status.
4)Start the server-side listener process of iSQL*Plus.
isqlplusctl start
5)Enter the Enterprise Manager and use iSQL*Plus.
In general you can invoke the url found after invoking emctl status dbconsole
Or, http://machine_name.domain_name:port/isqlplus
The default port number is 5560.
6)Now eneter user name and password, a box will come where you can invoke regular SQL commands.
No comments:
Post a Comment