Connect to Local 10g XE Server in Oracle

Q

How To Connect to a Local Oracle 10g XE Server in Oracle?

✍: FYIcenter.com

A

If you have your Oracle 10g XE server running on your local machine, you can connect your Oracle SQL Developer to the server with the following steps:

  • Start Oracle SQL Developer
  • Right-click on Connections
  • Select New Database Connection
  • Enter Connection Name as: Local_XE
  • Enter Username as: HR
  • Enter Password as: fyicenter
  • Enter Hostname as: 127.0.0.1
  • Enter SID as: XE
  • Click Test
  • Click Connect, if you see Status changed to Success

You will see the SQL Statement area opened ready to take any SQL statements.

 

Connect to a Remote Server in Oracle

Oracle SQL Developer Written in Java in Oracle

Introduction to Oracle SQL Developer

⇑⇑ Oracle Database Tutorials

2019-02-05, 1640🔥, 0💬