查看当前服务名:
SQL>show parameter service_name
更新服务名:
SQL>update system set service_names='new_orcl';
修改listener.ora
将GLOBAL_DBNAME=new_orcl
修改tnsnames.ora
SERVICE_NAME=new_orcl
重启监听
lsnrctl stop
lsnrctl start
Powered by: 博客园 Copyright © 2024 凉水代码 Powered by .NET 8.0 on Kubernetes