Linux Services Check

svcs -a

svcs -a | grep online

svcs -a | grep offline

svcs -a | grep disabled

Oracle Instance Running Check

Oracle Instances:
----------------

ps -ef | grep pmon

ps -ef | grep smon

ps -ef | grep ckpt

TSQL Linux Utility

rpm -qa |grep free

/user/bin/tsql –H XXX.XX.XX.XX –p 1433 –U username –P Password -D dbname

nano /etc/freetds.conf --- to edit file

To view the freetds.conf file
-----------------------------

cd /etc
ls
less freetds.conf

Reference:

https://zxtech.wordpress.com/2013/06/22/how-to-connect-to-microsoft-sql-server-from-ubuntu-using-odbc-part-3-of-3/

RPM

rpm -ql unixodbc - To see whether it is installed or not

rpm -qa |grep free or rpm -qa |grep traceroute

How to see the executable Files:
--------------------------------

control C

control R

Then type naming to look for previous commands

type ts and then tab it gives the executable file start with ts

Message appears tsql utility

Linux Network Troubleshooting

Network Troubleshooting:
------------------------

Trace Route:
------------

-bash-3.2$traceroute IPAddress

command not found

-bash-3.2$echo $PATH
/usr/bin:/bin:/usr/local/bin

-bash-3.2$/usr/sbin/traceroute IPAddress

IPConfig:
--------

/usr/sbin/ifconfig -a -- To see the ip address of solaris system


Trace to certain activities
---------------------------

tcpdump -i eth1 host xxx.xx.xxx.xx ---- Try this in source system. It will give the information when we telnet or connect to other server. xxx.xx.xxx.xx is the IP (Example VIP IP of the RAC server) where we are trying to trace. That is the destination IP.


Telnet:
-------
telnet IP 1433

Netcat or nc is a networking utility for debugging and investigating the network:
--------------------------------------------------------------------------------

nc -v -z IP 1433

Routing Table Information

Routing Table
--------------

Route print

route -n -- Linux

netstat -nr --- Solaris