Basics about Oracle Database 11g XE (Express Edition) :
Free Oracle Database for Everyone
Whether you are a developer, a DBA, a data scientist, an educator, or just curious about databases, Oracle Database 18c Express Edition (XE) is the ideal way to get started. It is the same powerful Oracle Database that enterprises rely on worldwide, packaged for simple download, ease-of-use, and a full-featured experience. You get an Oracle Database to use in any environment, plus the ability to embed and redistribute – all completely free!
Steps to download and configure database in localhost (personal laptop) :
- Download the Oracle database Xe 11g software by clicking on below link
Download Oracle Database XE 11g
- Unzip the file and run setup.exe
- Click Next
- Accept the license agreement and click Next
- Make sure the destination folder is in ' C ' drive. Click Next
- Configure the password for the database. Save this password because you need it to connect with database.
- Save the summary . This is the connection details to connect with the database. We will use this to configuration details in SQL developer tool to connect with this database.
- Database installation is successful. Now the database is ready to use.
- Mostly database get started automatically after installation. But as this is the first time let's start the database manually.
Search for the Oracle Database 11g XE and click on Start Database.
Now open SQL Developer tool to connect the above configured database.
(If you don't have SQL developer tool , you can download it from internet.)
- Open SQL Developer and create a new connection by clicking '+' icon
Enter below details :
Connection Name : write any meaningful name
Username : SYSTEM
Password : enter the password which you created while
configuring oracle database in system.
Hostname : localhost
Port : 1522 (or 1511)
Host : xe
Click Save & then Test. If it's Status : Success, click to Connect
Now create a Table name "test_agent"
SQL Query : CREATE TABLE test_agent(message VARCHAR2(20));
Connection Name : write any meaningful name
Username : SYSTEM
Password : enter the password which you created while
configuring oracle database in system.
Hostname : localhost
Port : 1522 (or 1511)
Host : xe
Click Save & then Test. If it's Status : Success, click to Connect
Now create a Table name "test_agent"
SQL Query : CREATE TABLE test_agent(message VARCHAR2(20));
Now follow the Next blog to create an integration using the above database.
Thanks a lot buddy .. You have done a great job..
ReplyDeleteThanks 🙂..
DeleteThank You! Done...
ReplyDeletewelcome !
DeleteThank you so much
ReplyDeletewelcome !
Deletei couldnt create a database ....its not connecting...an error occurs while testing
ReplyDeleteplease connect me by email (kabiryadavinbox@gmail.com)
Deletemy lap old version centrino 1420 dell lap not connect for oracle how to connect
ReplyDeletechange the laptop :) it's a very old model, decades have passed after its launch in market
DeleteThanks a lot bhai...
ReplyDeleteWelcome brother 🙂
DeleteIs it working on Windows 10 Home?
ReplyDeleteCoz Oracle Databse 21c XE is now working on Win10 Home
yes
DeleteHi when i try to connect through sql command line i get a error
ReplyDeletetns could not resolve the connect identifier.can you suggest something.
connect me through email 'kabiryadavinbox@gmail.com'
DeleteThank's a lot broh....
ReplyDeletewelcome :)
DeleteHow to login a system in oracle 11g.
ReplyDeleteIf we create user fron any other user it says insufficient previlages.
only an admin user can create any other user.
DeleteThanks bro
ReplyDeletewelcome :)
Deleteits not downloading . zip failed. could you help me to fix this. thanks in advance
ReplyDeleteDear, it is downloading. Check your internet bandwidth.
Deleteor connect me through email 'thekabiryadav@gmail.com'
helped me a lot! thanks man!!!
ReplyDeleteWelcome Felipe :)
DeleteYou are so helpful. Everything was a roller coaster ride.
ReplyDeleteThank you so much!
welcome :)
Deletethanks
ReplyDeleteplease I need to send me the link to download the SQL Developer tool
https://www.oracle.com/tools/downloads/sqldev-downloads.html
Delete