Oracle uses port 1521 by default SQL Server uses port 1433 W

Oracle uses port 1521 by default. SQL Server uses port 1433.

Why? What is a port? What is a socket? How would you limit access to ports?

Solution

Port is an end point connection. This is used for h/w terms. and it is logical construct which identifies processes in s/w. A port will always associated with IP address of the host and the protocol type.As any client program wants to use server program, it must request with the help of this port.

Port numbers are from 0 to 65535. o to 1024 are reserved. For example 80 is used for HTTP service. and telnet uses 23. like wise.

Socket allows comminication between proces on same/different m/c\'s. Used in client / server applicatin programs, known as socket programming. IP address with a port is called socket. (Ex: 10.11.3.5:1234)->socket and 1234 is port.

We use 1521 as port because to configure installation.(Oracle SQL Net Listener and Data Gaurd)

We use 1433 as port beacuse to open firewall to acess SQL Server database engine.

We can limit the acess to ports by analysis services and internet information services(IIS)