How to fix the Oracle error PGA-20945: unable to log on to Oracle for transaction logging?
In this post, you’ll learn more about the Oracle ErrorPGA-20945: unable to log on to Oracle for transaction logging with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PGA-20945: unable to log on to Oracle for transaction logging
Reason for the Error PGA-20945: unable to log on to Oracle for transaction logging
Cause: The gateway server was unable to connect to the Oracle server where the transaction log table is stored. An Oracle server message will follow this message.
How to fix the Error PGA-20945: unable to log on to Oracle for transaction logging ?
You can fix this error in Oracle by following the below steps
Action: Ensure that the Oracle server and its TNS listener are both operational. If the protocol is SNA: also check the PGA_LOG_DB, PGA_LOG_USER, and PGA_LOG_PASS parameters in the gateway init file and ensure that they specify the correct database string, userid, and password, respectively. If the protocol is TCP/IP: also check the PGA_TCP_DB, PGA_TCP_USER, and PGA_LOG_PASS parameters in the gateway init file and ensure that they specify the correct database string, userid, and password, respectively. Refer to the Oracle Server Messages and Codes Manual for information on the Oracle server message.
Leave Your Comment