How to find the serial ports on Mac OS X?

This example is for Trendnet USB to serial adapter v2

After install del driver for your Mac and restart the Mac.

Open a terminal session and type.

#ls /dev/tty.*

note the list of the usb-serial com port per example

/dev/tty.usbserial (in my case)

Then use screen commandon the terminal in order to access your serial appliance, per example

#screen /dev/tty.usbserial {baudrate}

USEFUL ORACLE SQL QUERIES ON TNS

Oracle 11g how to get tables names that contain a columns name

SELECT TABLE_NAME
FROM ALL_TAB_COLUMNS
WHERE COLUMN_NAME = 'STRING THAT YOU ARE LOOKING FOR'

Find out IP addresses for CRUs

SELECT *
FROM SCEMAIN;