Download:
In order to work with database server we need database software. Many companies provide DataBase server software, we can download any one. Now let us see how to download and install Oracle Database. This Oracle Database software is of two types:Enterprize Edition may cost some hundreds of dollars, where as Xpress Edition is free of cost. We can download the Xpress Edition from the following link.
Go to the above link, just accept the license agreement and click on windows version.
Installation:
Hope you all know how to install the software into your pc. Just go to the setup file and double click on it. In the process of installation it asks for username and password. You can give anything,but you should make a note of this username and password, to use in programming.
After downloading, to work with the database we need an url. This url consists of mainly three things, they are:
- IP address
- Port Number
- Service Name
When we use Enterprize Edition we need IP address of the server system to communicate with it. But here our own pc is acting as server system, so the IP address is "localhost" or 127.0.0.1(this is the default IP address of every pc). In Enterprize Edition the port number and Service name can be any thing, but here in Xpress Edition the port number is "1521" and the service name is "xe". Hence, the url of Oracle database 11g Xpress Edition is as follows:
- jdbc:oracle:thin:@localhost:1521:xe
No comments:
Post a Comment