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.