Skip to content

Archive for

How to change root password in all Teradata nodes?

TO change the default root password of Teradat nodes you can either login to each node and do it manually. But if you have a larger TD system then possibly this may not be feasible. To avoid loggin in to each TD node you cna make use of teradata utility called psh. Using which you can change password on all nodes by just connecting to one node.

Here are the steps to follow:
1) Login to node 1 (or any node) of your Teradat system as root

2) Run below command and follow the prompt. psh utility will first connect to all the nodes and will then prompt for new password twice.

# psh -i ‘passwd root’
all 4 nodes:
Changing password for root.
New Password:
passwd.0> MyNewRootPassword
all 4 nodes:
Reenter New Password:
passwd.1> MyNewRootPassword
all 4 nodes exited
all 4 nodes:
Password changed.

3) Type exit to exit the psh utility
psh.0> exit

Not able to approve datalab – Viewpoint


Cannot approve any new Datalabs request as well as cannot add any user to a datalab.

Your request has failed. The supplied string array has null, empty, or blank (all whitespace) elements, or is null or empty itself.
You may also see any Datalab approval just hanging and not completing or throwing any error.

When you look at viepoint log file located at /opt/teradata/viewpoint/portal/logs/viewpoint.log you will see errors like below:

2015-10-11 11:11:50,596 ERROR [http-nio-9080-exec-4] {context=/DataLabsPortlet, user=admin} impl.JaxbMessageSender.getHostName(336) – Could not get host name.
Just add the hostname to the host file (/etc/hosts) to resolve the issue: localhost ViewPointServername_VP
You will probably see this issue after upgrading to viewpoint version