Tuesday, March 21, 2017

Bteq login fails with "Warning RDBMS CRASHED OR SESIONS RESET.RECOVERY IN PROGRESS"



Problem :

Database is up on DSADSC .But,Bteq login fails with "Warning: RDBMS CRASHED OR SESIONS
RESET.RECOVERY IN PROGRESS"

bar15a:~ # bteq
Teradata BTEQ 14.10.00.13 for LINUX. PID: 14084
Copyright 19842015,
Teradata Corporation. ALL RIGHTS RESERVED.
Enter your logon or BTEQ command:
.logon systemfe
.logon systemfe
Password:
*** Warning: RDBMS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS.


Cause :

Issue with hosts file


Solution :

##In hosts file the localhosts doesn't have alias name dbccop1.So,If we connect to database without mentioning TDPID.Then By default it tries to connect to dbccop1.As it doesn't have entries in hosts file.It's getting from DNS.But,the Entries in DNS returning different Ip address where database not running on those systems and resulting in failure.

/etc/hosts file
Before change:
127.0.0.1 localhost barcop1
After change:
127.0.0.1 localhost dbccop1


3 comments: