Friday, September 25, 2009

Default port numbers of various databases

Default port numbers of various databases:

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://<>:5560/isqlplus

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.......

Default port numbers of various databases

Default port numbers of various databases:

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://<>:5560/isqlplus

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.......