0 Database Default Port/log file location

 

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