ORA-28029: could not authorize remote server for user string ORACLE 报错 故障修复 远程处理

文档解释

ORA-28029: could not authorize remote server for user string

Cause: During the course of opening a privileged database link, the remote server was found to lack the necessary authorizations to connect as the current global user. This may be because the server was not authorized by the network security service. Or it may be because the local server is restricting access by the remote server using the DBMS_SECURITY_DOMAINS_ADMIN package.

Action: Grant the remote server the proper authorization to connect as the given global user, and check that the local server is not restricting access.

ORA-28029错误是在Oracle数据库中连接远程服务器时发生的错误。

官方解释

常见案例

一般处理方法及步骤

1、确保远程服务器上的账号有权访问Oracle数据库。

2、在Oracle数据库中，给予远程服务器上的账号使用对应对象的权限。

3、检查远程服务器上的TNS_ADMIN环境变量指向的路径是否存在，并且文件名正确。

4、如果远程服务器上使用的是Listener，检查该Listener是否能和Oracle数据库正常通讯。

5、检查remote_os_authent参数是否设置为true，如果不是，就将其设置为true。