by Ramesh Natarajan on August 20, 2010
Question: How do I lookup the wwn address of my HBA card installed on the Linux system. I need this information to create zoning on my fiber channel switch.
Answer: Use one of the following methods to view the HBA WWN address on Linux.
(more…)
by Ramesh Natarajan on August 12, 2010
By default, MySQL does not allow remote clients to connect to the MySQL database.
If you try to connect to a remote MySQL database from your client system, you will get “ERROR 1130: Host is not allowed to connect to this MySQL server” message as shown below.
(more…)
by Ramesh Natarajan on August 6, 2010
Question: I have purchased Linux support for RHEL and OEL from Oracle corporation. How do I register my Linux system to Oracle support network to download and update packages? Can you explain me with step-by-step instruction?
Answer: After purchasing Linux support from Oracle, you should register your Linux system with Oracle’s Unbreakable Linux Network using up2date utility as explained in this article.
(more…)
by Sasikala on July 30, 2010
Question: Can you provide me a shell script that will accept oracle credentials, sql query to be executed and displays the output?
Answer: The shell script given below prompts some basic information and displays the output of the SQL.
You can use the same concept and hard-code some of these values in the shell-script itself and even run this script in the background to generate the output of an oracle sql query automatically (or use the oracle shell script from cron job).
This script accepts following values from the user:
- Oracle username
- Oracle password
- Oracle SQL Query to be executed.
Script validates the $ORACLE_HOME and $ORACLE_SID set in environment.
(more…)
by SathiyaMoorthy on July 23, 2010
Question: While downloading using wget, I get the following error “Connecting to <URL>.. failed: Connection refused.”. I’m behind a proxy server. How do I fix it?
Answer: Export the http_proxy variable with your proxy server name or ip address and then try downloading as explained below.
(more…)
by Ramesh Natarajan on July 16, 2010
Question: When I’m trying to ssh to a remote server, after I enter the username, it takes a lot of time before it displays the password prompt. Basically, my SSH ( openSSH ) is slow during authentication process. How do I solve this problem?
Answer: If your ssh login from localhost to remotehost is slow, enable the ssh debugging while starting the ssh connection using option -v as shown below.
After it displays the “debug1: SSH2_MSG_SERVICE_ACCEPT received” message, ssh session will be hanging for almost a minute before it continues to the next debug statement.
(more…)
by SathiyaMoorthy on July 16, 2010
Question: How do I view all the current iptables rules? Once I view it, is there a way to delete all the current rules and start from scratch?
Answer: Use the iptables list option to view, and iptables flush option to delete all the rules as shown below. You should have root permission to perform this operation.
(more…)
by SathiyaMoorthy on July 9, 2010
You may want to disable ping replies for many reasons, may be for a security reason, or to avoid network congestion.
Someone can flood the network with ping -f as shown in “Ping Example 5″ in our earlier Ping Tutorial article. If ping reply is disabled we can avoid this flooding.
(more…)