Expert: Elliot Mak - 9/10/2009

Question
QUESTION: i install oracle 10g on my computer and connect it with another computer with LAN. on this computer i want to access the data base of the computer on which computer i install 10g through internet explorer. how do i?

ANSWER: Good day Muzammil

For you to access your 10g database via IE or any web browser, you will need to install ISQLPLUS.  If you did a default installation, it should already been installed.  

To check if it is installed, here is what you need
1. Go to Start->Settings->Control Panel->Administrative Tools->Services
2. If you have the ISQLPLUS installed, there will be a service name called "OracleOraDB10g_home1iSQL*Plus".  Make sure that this service is Started.  If it is not, highlight the service, right mouse click and select Start.
3. If you did a default installation, the iSQLPLUS port is 5560.  Or you can go to %ORACLE_HOME%/install/portlist.ini to find the port number
4. Once you have the port number, then in your web browser, enter
http://<hostname>:5560/isqlplus, and process with login.

Here is an tutorial from Oracle that you may find it useful
http://www.oracle.com/technology/obe/obe10gdb/install/isqlplus/isqlplus.htm

If you shall have additional questions, please don't hesitate to let me know

Cheers
Elliot

---------- FOLLOW-UP ----------

QUESTION: Thank you very much for your reply. After a long time any expert from this site gave the answer of my question. but problem strats after that http://<hostname>:5560/isqlplus. i gave the same address as u given but the main page is opening and im trying to connect the user but SQL editor is not connecting any user.

Answer
Hi Muzammil

Let me see if I understand that correctly.

You have entered http://<hostname>:5560/isqlplus, you got the logon screen.  At the logon screen, you have entered username, password, and connect identifier.  Then you clicked on "LOGIN" button.  you got the error message "ERROR - ORA-01017: invalid username/password; logon denied"?  

If this is the case, you may want to logon to the database using sqlplus with the user that you were trying and make sure that you can logon using sqlplus.  If you cannot, logon as sys or system and change the password of that user.  

If this is not the case, please let me know the exact error message or provide me the screen shot of what you have encountered, it will be easier to troubleshoot it for you.

Cheers
Elliot