Default Port number
- MSSQL: 1433
- Oracle: 1521
- DB2: 50001
- Sybase: 5000
How to find the current port number
MSSQL
The listen port can be found in the error log and sql server configuration manage
You can also get it by running the below query
select local_tcp_port from sys.dm_exec_connections where local_tcp_port is not null
Oracle
The port number is defined in the local listener.
lsnrctl status
DB2
db2 get dbm cfg |grep SVCE
grep db2c_db2inst1 /etc/services
Sybase
I don’t have Sybase ASE install in my lab yet. As far as I know, you can check the SQL.ini/Interface.ini to find the current Port number. The ini file is locate in the $SYBASE\ini directory.
How to find the error log
MSSQL
SELECT SERVERPROPERTY(‘ErrorLogFileName’);
We can also find it in the SQL Server configuration manager or register key
reg query "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSSQLSERVER"
Oracle
select value from v$parameter where name = 'background_dump_dest';
DB2
db2 get dbm cfg | grep DIAGPATH
Sybase
$SYBASE/$SYBASE_ASE/install/servername.log
Reference:
- http://www.orafaq.com/node/30
- http://pic.dhe.ibm.com/infocenter/pim/v9r0m0/index.jsp?topic=%2Fcom.ibm.pim.ins.doc%2Fpim_ref_defaultportnumbers.html
- http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.config.doc%2Fdoc%2Fr0000299.html
- http://www.adp-gmbh.ch/ora/concepts/alert_log.html
- http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc35890_1500/html/instalhp/X41897.htm
Alexander McQueen's performance is known for its emotional power, primitive energy,Replica ALEXANDER MCQUEEN and romantic but replica mens ALEXANDER MCQUEEN sandal determined contemporary nature. An essential element of McQueen's culture is the juxtaposition of contrasting elements: vulnerability and strength, tradition and modernity, fluidity and seriousness. In respecting the craftsmanship tradition, an open and even passionate view was realized. McQueen's collection combines an in-depth knowledge of British custom sewing, superb craftsmanship and impeccable craftsmanship made in Italy.
ReplyDelete