when i try to logon bteq, i get the following error,
*** Warning: RDBMS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS.
and then i try to restart the database,
pdestate -a
status:
PDE state: DOWN/HARDSTOP
start:
/etc/init.d/tpa start
result:
Teradata Database Initiator service is starting...
Teradata Database Initiator service started successfully.
then check the status again:
PDE state: DOWN/HARDSTOP
i tried many times, but still can not start database, don't know the reason,
From the "Messages" manual:
Remove file
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
To start Teradata DBMS use
/etc/init.d/tpa start
To confirm that the database has come up, type
pdestate -a

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With