264 total views, 9 views today

How to create Oracle SQL Developer connection 

This section we walk through on creating Oracle SQL Developer connection

 

1. Open SQL Developer as shown below. Click here for installing Oracle SQL developer in Windows.

 

Capture-74-300x264 How to create Oracle SQL Developer connection

 

2.  Oracle SQL Developer is for querying against Oracle database. We need an Oracle database connection details to connect to a database. Please click here for installing Oracle XE database in a local machine.  Below are the details of the XE database installed in the local machine.

Connection Name: Local (Any Name)
Username sys
Password: password (The password you entered for sys while installing Oracle database)
Port: 1521
Hostname: localhost 
SID: XE

 

Capture-75-300x204 How to create Oracle SQL Developer connection

 

The username ‘sys’ has sys dba privilege( like Administrator account in Windows machine ) If the username is other than SYS account or it does not have SYSDBA role then change this Role it to default in the combo box.Click Save to save the connection and click cancel to close this wizard.  Below are the other roles present in the Role combo box

SYSBACKUP – Administrative Privilege for Backup and Recovery Operations
SYSDG – Administrative  operation for Data Gaurd related operation
SYSKM  – Administrative operations for ‘Transparent Data Encryption’ and ‘Data vault’.
SYSASM –  Administrative operations for  ASM instance


3. The connection just we saved appears on the connection Window.

Capture-76-300x180 How to create Oracle SQL Developer connection

 

4. Edit connection property: To change the connection property details, Right click the connection name (local) and click ‘properties’

 

Capture-77-200x300 How to create Oracle SQL Developer connection

 

5. To add ‘Proxy details’ for the connection: 

 

 Capture-78-300x153 How to create Oracle SQL Developer connection

pgn How to create Oracle SQL Developer connection

Govindan

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
pgn How to create Oracle SQL Developer connection

Latest posts by Govindan

By | 2017-06-11T13:07:53+00:00 January 13th, 2016|Categories: Oracle|Tags: , |0 Comments
Like us on Facebook.
Connect!