Skip to content

Teradata database backup job failed and is not running since last failure.

ISSUE:

Teradata database backup job failed and is not running since last failure.

Job Execution Errors and Warnings:
Error Code: 1005
Error Message:
224: CLISQL Exception: CLI reported error 224: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.

RESOLUTION:

You may see this issue if Teradata backup job is not able to resolve the host name in /etc/hosts. In order to fix the issue make sure the below entry in /etc/hosts file in all the COP nodes:

127.0.0.1 localhost tdatcop1 SERVERNAMEcop1

To verify this entry on all the nodes by just logging in to one node:

# psh “cat /etc/hosts | grep cop1”
all 4 nodes:
127.0.0.1 localhost tdatcop1 SERVERNAMEcop1
11.11.22.22 byn201-8 dbccop1

How to check when was the last time any local user password was changed in Unix?

How to check when was the last time any local user password was changed in Unix?

When ever any local user account password is changed the file /etc/shadow is updated.
So, if you want to check when was the last time any local user password was changed then just run:

[root@TestServer ~]# ls -lrt /etc/shadow
-r——– 1 root root 1035 Oct 11 11:11 /etc/shadow

From above output, its clear that last time any local user password was changed was on 11th Oct of this year.

For example, if you want to see when was the last time root user password was changed, just run below command:

[root@TestServer ~]# chage -l root
Last password change : Oct 11, 2016
Password expires : never
Password inactive : never
Account expires : never
Minimum number of days between password change : -1
Maximum number of days between password change : -1
Number of days of warning before password expires : -1