CODEWITHSUNDEEP
teradata
tonyibm
tonyibm

Reputation: 651

can not start teradata database using "tpa start"

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,

Upvotes: 4

Views: 6766

Answers (2)

ben othman zied
ben othman zied

Reputation: 310

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

Upvotes: 3

Tejas Talele
Tejas Talele

Reputation: 1

After giving the command, wait a minute or so and give the same command again. Keep trying. After a few trails (minutes), the database will be started. Looks weird, but works :- )

Upvotes: 0

Related Questions