重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: ORA-28545 - When Oracle Is Installed Using Windows Virtual Account [打印本页]

作者: 刘泽宇    时间: 3 天前
标题: ORA-28545 - When Oracle Is Installed Using Windows Virtual Account
现象:
When Oracle Database is installed using Windows Virtual Account, the oracle database link referencing Oracle Database Gateway defined in the listener.ora file will fail with below error:

==============================================================
SQL> SELECT * FROM DUAL@db_link;
SELECT * FROM DUAL@db_link
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from DB_LINK
==============================================================


原因:
Oracle installed on Windows using Virtual Account


处理方法:
Do not install Oracle Database using "Windows Virtual Account".

Two actions to fix:

- Reinstall the Oracle database by selecting anything other than "Use Virtual Account".

or

- Change the Oracle database and listener services logon user to "local system account" using the procedure below

1. Open services from the Windows Administration Tool.
2. Show properties by right-clicking the corresponding database and listener Windows services.
3. Change to "Local System Account" from the "Logon" tab and click "Apply" then "OK".
4. Restart the Windows services for database and listener and then see if DB_LINK can connect.






欢迎光临 重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2