Posted in DB2, Firebird, Group Blog Posts, Informix, MySQL, Oracle, PostgreSQL, SQL Server, log buffer by: Shakir
Comments Off
21 Mar
Welcome to the 89th edition of Log Buffer, the weekly review of database blogs.
Welcome, welcome everyone.
In writing this week’s Log Buffer, I’ve had a chance to sit down and read some excellent posts on all sorts of platforms. The depth and breadth of what’s available to house and retrieve data is astonishing.
Many […]
Posted in SysAdmin, bash, ksh, shell, zsh by: Sheeri Cabral
Comments Off
21 Mar
Ah, the perils of working in a shared, client environment. One client has us using a login that is not exclusive to us. I prefer using bash; the client is set to use zsh. This is not a problem in and of itself.
However, there is a section in the .profile that is […]
Posted in Uncategorized by: Richard Foote
Comments Off
21 Mar
To all of you who celebrate Easter, I hope you have a truly wonderful Easter break.
Try not to eat too much chocolate and don’t waste too much of your precious time rebuilding indexes
Have fun !!
Posted in HP-UX by: Lee Lang
Comments Off
21 Mar
Some of the site administrators working with me installed few of the new Integrity HP-UX servers however during the installation process they have assigned the dynamic (dhcp) ip address and then i have to tell them How to change the ip address on HP-UX 11i v2 servers. Here is how you can change the ip address on the HP-UX 11iv2 servers without rebooting the machine.
Steps to change the ip address on HP-UX 11iv2 servers:
1. Check HP-UX current lan/network card ip address:
Login as root on HP-UX server and make sure no one is connected to the server. Check the current ip address assigned to HP-UX integrity machine and make sure you know the correct lan/network interface card for changing ip address:
|
# netstat -nr
Routing tables
Destination Gateway Flags Refs Interface Pmtu
127.0.0.1 127.0.0.1 UH 0 lo0 4136
192.168.1.29 192.168.1.29 UH 0 lan0 4136
192.168.0.0 192.168.1.29 U 2 lan0 1500
127.0.0.0 127.0.0.1 U 0 lo0 0
default 192.168.1.100 UG 0 lan0 0
|
The netstat –nr command prints the routing information and the active lan/network interface card. Here I have to change the ip address on the HP-UX server from 192.168.1.29 to 192.168.1.220.
2. change HP-UX ip address network configuration
Edit the HP-UX network configuration file under /etc/rc.config.d/. Using vi edit the /etc/rc.config.d/netconf file and search for string IP_ADDRESS (in vi use /IP_ADDRESS):
|
INTERFACE_NAME[0]=lan0
IP_ADDRESS[0]=192.168.1.29
SUBNET_MASK[0]=255.255.255.0
BROADCAST_ADDRESS[0]=”"
INTERFACE_STATE[0]=”"
DHCP_ENABLE[0]=0
INTERFACE_MODULES[0]=”"
|
Change the ip address from dhcp ip address to static/permanent ip address , make sure you have static ip address added to you DNS/BIND server. Also change the old ip address information to new ip address in /etc/hosts file:
|
# @(#)B11.23_LRhosts $Revision: 1.9.214.1 $ $Date: 96/10/08 13:20:01
#
# The form for each entry is:
# <internet address> <official hostname> <aliases>
#
# For example:
# 192.1.2.34 hpfcrm loghost
#
# See the hosts(4) manual page for more information.
# Note: The entries cannot be preceded by a space.
# The format described in this file is the correct format.
# The original Berkeley manual page contains an error in
# the format description.
#
192.168.1.220 mancdb.ribson.edu
127.0.0.1 localhost loopback
|
3. Restart the HP-UX server network configuration file:
Make sure you are connected to MP (Management Processor)/Console , you will loose your current session window once you restart the network configuration startup file
4. Verify the HP-UX lan/network changed ip address
Bingo you are back in business ip address is changed on the HP-UX server from dhcp top static , now you can verify the network lan card settings :