Often we wonder what is the default port number of various databases that we work excessively on since we don’t keep in touch with these stuff often, hence I thought it would be good idea to post that stuff here for quick review when required rather checking here and there.
(There are just too many things to remember, and the things we don't use everyday get lost in brain cells.)
What is the default port number of Oracle Database:
1521
The more information can be seen in listener.ora (server) and tnsnames.ora (client & server) files.
Other database utilities port numbers:
The port number of iSQLPLUS and EM control etc can been seen in /ORACLE_HOME/install/portlist.ini file.
usually EM control port number is 1158 or 5500
http://hp-pc:1158/em
iSQL*Plus number =5560
http://<
DBA iSQL *Plus access:
http://hp-pc:5560/isqlplus/dba
What is the default port number of MySQL database:
3306
Command to know whether port is listening with netstat -ln | grep mysql
What is the default port number of MSSQL 2005 Database:
1433
the port numbers are remain intact unless one change.
Cheers.......
