' oicbasics: Download Oracle Database 11g XE (Express Edition)
January 25, 2020

Download Oracle Database 11g XE (Express Edition)



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!

- Advertisment -



Now lets see the Steps to download and configure database in localhost i.e. in your personal laptop :

  • Download πŸ ‹ the Oracle database XE 11g software in your system by clicking on the below link


  • Unzip the file and run setup.exe




  •  Click Next 


  •  Accept the license agreement and click Next




- Advertisment -




  • 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 in below steps.





- Advertisment -


  • 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.







- Advertisment -



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)); 






Now follow the Next blog to create an OIC Integration using the above database. If you requirement is just to install database then your job is done, you can ignore the next article. Thanks !! πŸ‘



- Advertisment -


40 comments:

  1. Thanks a lot buddy .. You have done a great job..

    ReplyDelete
  2. i couldnt create a database ....its not connecting...an error occurs while testing

    ReplyDelete
    Replies
    1. please connect me by email (kabiryadavinbox@gmail.com)

      Delete
  3. my lap old version centrino 1420 dell lap not connect for oracle how to connect

    ReplyDelete
    Replies
    1. change the laptop :) it's a very old model, decades have passed after its launch in market

      Delete
  4. Is it working on Windows 10 Home?
    Coz Oracle Databse 21c XE is now working on Win10 Home

    ReplyDelete
  5. Hi when i try to connect through sql command line i get a error
    tns could not resolve the connect identifier.can you suggest something.

    ReplyDelete
    Replies
    1. connect me through email 'kabiryadavinbox@gmail.com'

      Delete
  6. Thank's a lot broh....

    ReplyDelete
  7. How to login a system in oracle 11g.
    If we create user fron any other user it says insufficient previlages.

    ReplyDelete
  8. its not downloading . zip failed. could you help me to fix this. thanks in advance

    ReplyDelete
    Replies
    1. Dear, it is downloading. Check your internet bandwidth.
      or connect me through email 'thekabiryadav@gmail.com'

      Delete
  9. helped me a lot! thanks man!!!

    ReplyDelete
  10. You are so helpful. Everything was a roller coaster ride.
    Thank you so much!

    ReplyDelete
  11. thanks
    please I need to send me the link to download the SQL Developer tool

    ReplyDelete
    Replies
    1. https://www.oracle.com/tools/downloads/sqldev-downloads.html

      Delete
  12. Thank God Bless You from Kachin

    ReplyDelete
  13. Great my brother from Dominican Republic

    ReplyDelete
  14. I am still having trouble downloading and setting up my oracle database can I email you?

    ReplyDelete
  15. thank you very much

    ReplyDelete
  16. Thank you so much brother. Saved lot of time

    ReplyDelete

If you have any doubts, Please let me know.

Top