首页 > 解决方案 > 无法使用“tpa start”启动 teradata 数据库

问题描述

当我尝试登录 bteq 时,出现以下错误,

*** Warning: RDBMS CRASHED OR SESSIONS RESET.  RECOVERY IN PROGRESS.

然后我尝试重新启动数据库,

pdestate -a

地位:

PDE state: DOWN/HARDSTOP

开始:

/etc/init.d/tpa start

结果:

Teradata Database Initiator service is starting...
Teradata Database Initiator service started successfully.

然后再次检查状态:

PDE state: DOWN/HARDSTOP

试了很多次,还是无法启动数据库,不知道是什么原因,

标签: teradata

解决方案


从“消息”手册:

删除文件 13821 Crash loop detected during TPA initialization. Explanation: In order to prevent PDE initialization from looping forever when an error prevents it from completing, it is only automatically restarted three times. After three unsuccessful initialization attempts, this message is issued and restart attempts are discontinued, leaving PDE down.

rm /var/opt/teradata/tdtemp/PanicLoopDetected 

要启动 Teradata DBMS,请使用

/etc/init.d/tpa start

要确认数据库已启动,请键入

pdestate -a 

在此处输入图像描述


推荐阅读