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;