aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

PGA-20948: unable to prepare the statement for transaction logging

PGA-20948: unable to prepare the statement for transaction logging
Cause: The gateway server was unable to prepare the statement to be used to call the transaction logging PL/SQL stored procedure. An Oracle server message will follow this message.
Action: Ensure that the Oracle server and its TNS listener are both operational. 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. Verify that the transaction logging PL/SQL procedure has been properly installed into the Oracle server under the userid and password specified by PGA_LOG_USER and PGA_LOG_PASS and that it is executable. Refer to the Oracle Server Messages and Codes Manual for information on the Oracle server message.

请先 登录 后评论

1 个回答

小智
PGA-20948:无法准备事务日志记录的语句,
.原因:网关服务器无法准备用于调用事务日志PL / SQL存储过程的语句。Oracle服务器消息将跟随此消息。,
.操作:确保Oracle服务器及其TNS侦听器都可以运行。还要检查网关init文件中的PGA_LOG_DB,PGA_LOG_USER和PGA_LOG_PASS参数,并确保它们分别指定正确的数据库字符串,userid和密码。验证事务记录PL / SQL过程是否已经按照PGA_LOG_USER和PGA_LOG_PASS指定的userid和密码正确安装到Oracle服务器中,并且它是可执行的。有关Oracle服务器消息的信息,请参阅Oracle Server消息和代码手册。,
.
请先 登录 后评论