1 person found this helpful
If you are referring to the port present in the JDBC URL that SQL Developer uses to connect, then that depends on how the database listener is configured. Using SQL Developer to connect to a default install of Oracle 11g XE, then running
from the worksheet, you should see
CONNECTION: SCOTT@jdbc:oracle:thin:@localhost:1521:xe UNKNOWN CONNECTION_IDENTIFIER: XE CONNECTION_DB_VERSION: Oracle Database 11g Express Edition Release 18.104.22.168.0 - 64bit Production NOLOG: false PRELIMAUTH: false
which is similar to what appears in tnsnames.ora used by sqlplus or sqlcl:
XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) )
So, as shown in Glen's answer, the default port is 1521 which is also the value initially displayed by sqldeveloper when creating a new connection. If that dos not work for you, you need to ask your dba which port your listener is configured for.
What is the default TCP port used by SQL Developer?
Sql Dev does NOT have a 'default TCP port.
If you want to connect Sql Dev to a database you have to TELL IT what type of connection to make and, if you want to use TCP you need to specify the port used by that databases configuration spec in the listener.
You can use almost any port you want if the listener and database are configured properly.
Start over and tell us:
1. WHAT you are trying to do
2. WHAT version of sql developer you are trying to do it with
3. WHAT version and type of database you are trying to connect to
4. WHAT platform you are doing it on