How to connect to database using sqldeveloper?
YouTube link for the demonstration
https://youtu.be/AxM3oh958jk
Steps:
+++++++
a. Make sure your are able to access the oracle server from your laptop / Desktop via any terminal software (Like putty or MobaXterm etc...)
b. Make sure that Oracle Database and Listeners are up and running on the Oracle server
- Validate that database has registered with listener
c. Make sure you have installed sqldeveloper software on your laptop / Desktop
Note:
Download the latest Oracle SQL developer from the below Oracle URL
https://www.oracle.com/in/database/sqldeveloper/technologies/download/
- Try connection with connection details like hostname/IP address, Port and Service Name
- Try connection with TNS entries from sqldeveloper software
- Try connection with TNS entries from client software
Note:
Download Oracle 19 client from the below Oracle URL
https://www.oracle.com/in/database/technologies/oracle19c-windows-downloads.html
lab Output:
+++++++++++
Microsoft Windows [Version 10.0.26200.7623]
(c) Microsoft Corporation. All rights reserved.
C:\Users\MallikarjunRamadurg>ping oraclelab1.localdomain.com
Pinging oraclelab1.localdomain.com [10.1.51.128] with 32 bytes of data:
Reply from 10.1.51.128: bytes=32 time=252ms TTL=61
Reply from 10.1.51.128: bytes=32 time=249ms TTL=61
Ping statistics for 10.1.51.128:
Packets: Sent = 2, Received = 2, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 249ms, Maximum = 252ms, Average = 250ms
Control-C
^C
C:\Users\MallikarjunRamadurg>ping 10.1.51.128
Pinging 10.1.51.128 with 32 bytes of data:
Reply from 10.1.51.128: bytes=32 time=250ms TTL=61
Reply from 10.1.51.128: bytes=32 time=251ms TTL=61
Ping statistics for 10.1.51.128:
Packets: Sent = 2, Received = 2, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 250ms, Maximum = 251ms, Average = 250ms
Control-C
^C
C:\Users\MallikarjunRamadurg>
[root@oraclelab1 ~]# clear
[root@oraclelab1 ~]# hostname
oraclelab1.localdomain.com
[root@oraclelab1 ~]# ps -ef|grep smon
oracle 10285 1 0 Jan12 ? 00:00:16 ora_smon_DEVDB
root 27536 25205 0 02:36 pts/1 00:00:00 grep --color=auto smon
[root@oraclelab1 ~]# su - oracle
Last login: Mon Jan 19 23:08:36 IST 2026 on pts/2
[oracle@oraclelab1 ~]$ . oraenv
ORACLE_SID = [oracle] ? DEVDB
The Oracle base has been set to /u01/app/oracle
[oracle@oraclelab1 ~]$
[oracle@oraclelab1 ~]$ env |grep ORA
ORACLE_SID=DEVDB
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
[oracle@oraclelab1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jan 21 02:37:32 2026
Version 19.17.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
SQL> select name, open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
DEVDB READ WRITE
SQL> select instance_name, status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
DEVDB OPEN
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
[oracle@oraclelab1 ~]$ ps -ef|grep tns
root 23 2 0 2025 ? 00:00:00 [netns]
oracle 27677 27564 0 02:38 pts/1 00:00:00 grep --color=auto tns
oracle 32171 1 0 Jan05 ? 00:00:20 /u01/app/oracle/product/19.0.0.0/dbhome_1/bin/tnslsnr LISTENER -inherit
[oracle@oraclelab1 ~]$ lsnrctl status LISTENER
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 21-JAN-2026 02:38:23
Copyright (c) 1991, 2022, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclelab1.localdomain.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 05-JAN-2026 09:32:21
Uptime 15 days 17 hr. 6 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oraclelab1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraclelab1.localdomain.com)(PORT=1521)))
Services Summary...
Service "DEVDB" has 1 instance(s).
Instance "DEVDB", status READY, has 1 handler(s) for this service...
Service "DEVDBXDB" has 1 instance(s).
Instance "DEVDB", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@oraclelab1 ~]$
[oracle@oraclelab1 ~]$
[oracle@oraclelab1 ~]$ cd /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/
[oracle@oraclelab1 admin]$
[oracle@oraclelab1 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
DEVCDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclelab1.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DEVCDB)
)
)
DEVPDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclelab1.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DEVPDB)
)
)
DEVDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclelab1.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = DEVDB)
)
)
TESTCDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclelab1.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTCDB)
)
)
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclelab1.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST)
)
)
[oracle@oraclelab1 admin]$ tnsping DEVDB
TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 21-JAN-2026 02:39:05
Copyright (c) 1997, 2022, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oraclelab1.localdomain.com)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = DEVDB)))
OK (0 msec)
[oracle@oraclelab1 admin]$
[oracle@oraclelab1 admin]$
[oracle@oraclelab1 admin]$ sqlplus mallik/mallik@DEVDB
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jan 21 02:39:27 2026
Version 19.17.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Last Successful login time: Wed Jan 21 2026 02:23:02 +05:30
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
SQL> show user
USER is "MALLIK"
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
[oracle@oraclelab1 admin]$
[oracle@oraclelab1 admin]$ sqlplus sys/Mallik123#@DEVDB as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jan 21 02:39:54 2026
Version 19.17.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Last Successful login time: Tue Jan 20 2026 20:23:27 +05:30
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
SQL> show user
USER is "SYS"
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
[oracle@oraclelab1 admin]$
"This is such a well-written article! I appreciate the effort and clarity in your explanation. Definitely sharing this with friends who might find it useful.
ReplyDeleteGoa Tour Package from Delhi
Goa Tour Packages for 4 Persons
Goa Packages with Flight from Delhi