Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

can not start teradata database using "tpa start"

Tags:

teradata

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,

like image 412
tonyibm Avatar asked Oct 15 '25 15:10

tonyibm


1 Answers

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 

enter image description here

like image 68
ben othman zied Avatar answered Oct 19 '25 13:10

ben othman zied



Donate For Us

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