ORA-12685: Native service required remotely but disabled locally ORACLE 报错 故障修复 远程处理

文档解释

ORA-12685: Native service required remotely but disabled locally

Cause: A native service is required by the remote process but native services have been disabled locally.

Action: Enable native services locally or change the configuration parameters on the remote host so that no native services are required.

这个ORA-12685错误是Oracle数据库中的一个常见错误。它表明服务器没有启用外部连接但是客户端却试图进行远程连接,从而导致了连接失败。

Oracle官方对此错误的描述:

ORA-12685:Native service required remotely but disabled locally

它是用来指示客户端发出了远程服务调用,但是服务器未启用它本地的native service。具体来说,任何的native service的请求都需要有效的远程服务(remote service)来识别其来自的来源,但不能乱用,否则可能会出现ORA-12685错误。

常见案例

在连接Oracle数据库时,可能会发生ORA-12685错误,主要是因为服务器没有启用外部连接,而客户端又想要连接特定的端口。

正常处理方法及步骤

1.用SQL*Plus连接到Oracle数据库服务器,并运行以下命令以获取活动数据库服务名称:

select dbms_service.servicename from dual;

2.使用以下命令启用它:

alter system set native_service_name=’service_name’ scope=both;

3.最后,用以下命令提交你的更改:

commit;


数据运维技术 » ORA-12685: Native service required remotely but disabled locally ORACLE 报错 故障修复 远程处理