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
nice Teradata dba Online course
ReplyDeleteThe installation creates that entry in the /etc/hosts. That is not the problem. I still get the same warning
ReplyDeletetuzla vestel klima servisi
ReplyDeletemaltepe bosch klima servisi
kadıköy bosch klima servisi
çekmeköy alarko carrier klima servisi
maltepe toshiba klima servisi
kadıköy toshiba klima servisi
beykoz beko klima servisi
üsküdar beko klima servisi
pendik lg klima servisi