Let’s discuss the processes running in Oracle database and their functions. DBW`: Database Writer, this process writes the data from buffer cache to the DB file and this operation of reading and writing is done in blocks. The default block size in Oracle is 8192 bytes, however it can be modified as required. Starting from […]
Usually, we use the SCOTT/tiger account to login to the system after installing the database but that account is locked in the beginning for security reasons. So, if you try to enter using that user, you get the following error: C:\Documents and Settings\Administrator>sqlplus SQL*Plus: Release 10.1.0.2.0 – Production on Sun Feb 20 21:15:21 2011 Copyright […]
The function of short message center is to receive, store and schedule messages for delivery. There are mainly three network flows involved in the message receiving and delivery. They are as follows: 1) Mobile Origination 2) Mobile Termination 3) Alert Message Flow Lets analyze the flows one by one. 1) Mobile Origination Most of the […]
The default port to access iSQL*PLUS is 5560. You can access iSQL*PLUS with the following URL given that the oracle is installed on the local host ‘http://localhost:5560/isqlplus/’ To change the port number, modify the file “http-web-site.xml” as given below:
Continue reading about How to change the port number for iSQL*PLUS in Oracle