Adding a new TNS entry to tnsnames.ora
February 21, 2018
How can we predict whether a long running session is hang or just long running
How can we predict whether a long running session is hang or just long running?
October 15, 2018
Show all

How to set up a new connection in SQL Developer?

create-new-oracle-database-connection-in-sql-developer-using-sys-user

create-new-oracle-database-connection-in-sql-developer-using-sys-user

It is easy to set up the connection without any issues if the Oracle installation has completed without any issues.

Connection Name:

This can be any name with which you identify the connection. For example, DEV_HR, QA_HR, UAT_SCOTT, PROD_SCOTT.

Username:

If this is your personal PC, username can be SYS/SYSTEM or any user which has DBA grant permissions. If this is for a work environment, whatever the username and password are provided to you by your DBA.

Password:

Valid password for the above user.

Save password checkbox:

Check this box otherwise SQL Developer will ask you to enter the password every time you connect with this user.

Connection Type:

Choose Basic as a connection type here.

Role:

In role choose SYSDBA as sys is a high privileged user.

Hostname:

Write a valid hostname here. For valid hostname, you can check tnsnames.Ora file. For personal PC’s you can use localhost as shown in the image.

Port:

Write a valid port number here. For the valid port number, you can check tnsnames.Ora file. The default port number for Oracle is 1521.

SID:

SID stands for System Identifier which is a unique name for your database. By default its either ORCL or XE. For work environment, you can get these details from the tnsnames.ora file or the DBA.

By default, the TNSNames.ora file can be found at {oracle directory}\network\admin. For example, C:\Oracle_Client\network\admin.

Share
+1
Tweet
Pin
Share