news 2026/4/23 17:39:41

多租户库19c修改服务名后pdb监听失效

作者头像

张小明

前端开发工程师

1.2k 24
文章封面图
多租户库19c修改服务名后pdb监听失效

多租户库19c修改服务名后pdb监听失效,需重启数据库才能生效恢复。只重启监听不起作用。

ORA-12514: TNS:listener does not currently know of service requested in connect

SQL> alter session set container=pdb;
ERROR:
ORA-44787: Service cannot be switched into.

重启库:

[grid@rac1:/home/grid]$ srvctl stop database -d jyc -o immediate
[grid@rac1:/home/grid]$ srvctl start database -d jyc

测试过程:

[oracle@rac1:/home/oracle]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-DEC-2025 14:55:09 Copyright (c) 1991, 2020, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 29-DEC-2025 14:52:14 Uptime 0 days 0 hr. 2 min. 54 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19.3.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.76)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.26)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "42b133224fc259cde0634ccfa8c0b908" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "dgjyc" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jyc" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jycXDB" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "pdb" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@rac1:/home/oracle]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-DEC-2025 14:55:12 Copyright (c) 1991, 2020, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 29-DEC-2025 14:52:14 Uptime 0 days 0 hr. 2 min. 57 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19.3.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.76)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.26)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "42b133224fc259cde0634ccfa8c0b908" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "dgjyc" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jyc" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jycXDB" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "pdb" has 1 instance(s).--修改service之前可以看到存在pdb Instance "jyc1", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@rac1:/home/oracle]$ sqlplus sys/oracle@192.168.207.25:1521/pdb as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 29 14:55:21 2025 Version 19.9.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 [oracle@rac1:/home/oracle]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-DEC-2025 14:55:28 Copyright (c) 1991, 2020, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 29-DEC-2025 14:52:14 Uptime 0 days 0 hr. 3 min. 14 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19.3.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.76)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.26)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "42b133224fc259cde0634ccfa8c0b908" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "dgjyc" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jyc" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jycXDB" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "pdb" has 1 instance(s).--修改service之前可以看到存在pdb Instance "jyc1", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@rac1:/home/oracle]$ sqlplus sys/oracle@192.168.207.25:1521/jyc as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 29 14:55:36 2025 Version 19.9.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 ^[[A[oracle@rac1:/home/oracle]$ sqlplus sys/oracle@192.168.207.25:1521/dgjyc as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 29 14:55:41 2025 Version 19.9.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 SQL> show parameter service; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ service_names string jyc,dgjyc SQL> alter system set service_names='jyc' scope=both sid='*';--做修改 System altered. SQL> show parameter name; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ cdb_cluster_name string cell_offloadgroup_name string db_file_name_convert string db_name string jyc db_unique_name string jyc global_names boolean FALSE instance_name string jyc1 lock_name_space string log_file_name_convert string pdb_file_name_convert string processor_group_name string NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ service_names string jyc SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 [oracle@rac1:/home/oracle]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-DEC-2025 14:56:24 Copyright (c) 1991, 2020, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 29-DEC-2025 14:52:14 Uptime 0 days 0 hr. 4 min. 9 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19.3.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.76)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.26)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jyc" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jycXDB" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... The command completed successfully --此时发现没有pdb服务了 [oracle@rac1:/home/oracle]$ sqlplus sys/oracle@192.168.207.25:1521/dgjyc as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 29 14:56:35 2025 Version 19.9.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Enter user-name: ^C [oracle@rac1:/home/oracle]$ sqlplus sys/oracle@192.168.207.25:1521/jyc as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 29 14:56:41 2025 Version 19.9.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 [oracle@rac1:/home/oracle]$ sqlplus sys/oracle@192.168.207.25:1521/pdb as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 29 14:56:48 2025 Version 19.9.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Enter user-name: ^C ---pdb无法连接 [oracle@rac1:/home/oracle]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 29 14:56:54 2025 Version 19.9.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB READ WRITE NO SQL> alter session set container=pdb; ERROR: ORA-44787: Service cannot be switched into. SQL> !oerr ora 44787 44787, 0000, "Service cannot be switched into." // *Document: Yes // *Cause: The service did not exist in the new pluggable database or the service was not started in the pluggable database. // *Action: Use a valid service name for the pluggable database or start the service in the pluggable database first. SQL> alter session set container=pdb service=jyc;--需指定service才能进入,不重启数据库的情况下监听无法监听 Session altered. SQL> alter system register; System altered. SQL> !lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-DEC-2025 14:59:50 Copyright (c) 1991, 2020, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 29-DEC-2025 14:52:14 Uptime 0 days 0 hr. 7 min. 35 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19.3.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.76)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.26)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jyc" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jycXDB" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... The command completed successfully SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 [oracle@rac1:/home/oracle]$ [oracle@rac1:/home/oracle]$ [oracle@rac1:/home/oracle]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-DEC-2025 15:00:54 Copyright (c) 1991, 2020, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 29-DEC-2025 15:00:45 Uptime 0 days 0 hr. 0 min. 9 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19.3.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.76)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.26)(PORT=1521))) Services Summary... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jyc" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jycXDB" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@rac1:/home/oracle]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-DEC-2025 15:00:55 Copyright (c) 1991, 2020, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 29-DEC-2025 15:00:45 Uptime 0 days 0 hr. 0 min. 10 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19.3.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.76)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.26)(PORT=1521))) Services Summary... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jyc" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jycXDB" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@rac1:/home/oracle]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-DEC-2025 15:01:36 Copyright (c) 1991, 2020, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 29-DEC-2025 15:00:45 Uptime 0 days 0 hr. 0 min. 51 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19.3.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.76)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.26)(PORT=1521))) Services Summary... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jyc" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jycXDB" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@rac1:/home/oracle]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-DEC-2025 15:01:38 Copyright (c) 1991, 2020, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 29-DEC-2025 15:00:45 Uptime 0 days 0 hr. 0 min. 52 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19.3.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.76)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.26)(PORT=1521))) Services Summary... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jyc" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jycXDB" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@rac1:/home/oracle]$ [oracle@rac1:/home/oracle]$ [oracle@rac1:/home/oracle]$ [oracle@rac1:/home/oracle]$ ---restart database -bash: ---restart: command not found [oracle@rac1:/home/oracle]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-DEC-2025 15:04:48 Copyright (c) 1991, 2020, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 29-DEC-2025 15:00:45 Uptime 0 days 0 hr. 4 min. 2 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19.3.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.76)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.207.26)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "42b133224fc259cde0634ccfa8c0b908" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jyc" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "jycXDB" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... Service "pdb" has 1 instance(s). Instance "jyc1", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@rac1:/home/oracle]$ sqlplus sys/oracle@192.168.207.25:1521/pdb as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 29 15:05:01 2025 Version 19.9.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 [oracle@rac1:/home/oracle]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 29 15:05:08 2025 Version 19.9.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB READ WRITE NO SQL> alter session set container=pdb; Session altered. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0 [oracle@rac1:/home/oracle]$

相关参考:

https://blog.csdn.net/cowboy90/article/details/119753891

版权声明: 本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若内容造成侵权/违法违规/事实不符,请联系邮箱:809451989@qq.com进行投诉反馈,一经查实,立即删除!
网站建设 2026/4/22 23:41:46

先睹为快 | 2026年1月国际学术会议一览表

2026年1月,多场大型国际学术盛会即将启幕。会议将在中国及海外多个城市同步举办超过30场分会,广泛涵盖人工智能、大数据、电子信息、智能制造、计算机科学、能源环境、交通运输、土木建筑及人文社科等前沿与交叉学科领域。本次会议旨在构建高水平的全球学…

作者头像 李华
网站建设 2026/4/23 9:45:25

拆解桥博士的“波浪带鱼理论”:如何像过滤器一样提纯交易信号?

交易瓶颈:无效信号的阻碍在金融交易的道路上,许多交易者都遇到了瓶颈。无论我们如何努力学习各种交易技术和理论,总是难以摆脱无效信号的困扰。这些无效信号就像一道道无形的墙壁,阻挡着我们前进的步伐,让我们的交易陷…

作者头像 李华
网站建设 2026/4/23 9:45:27

lower_bound(a#x2B;1, a#x2B;n#x2B;1, b) - a

这段代码 /* by 01022.hk - online tools website : 01022.hk/zh/generatebchwallets.html */ lower_bound(a1, an1, b) - a 是 C 中一种常见的查找数组元素位置的写法。我们来逐步拆解它: 🔍 代码组成部分解析/* by 01022.hk - online tools website : …

作者头像 李华
网站建设 2026/4/22 12:12:49

Token计费模式揭秘:如何在PyTorch镜像中高效调用API

Token计费模式揭秘:如何在PyTorch镜像中高效调用API 在大模型服务日益普及的今天,越来越多开发者面临一个现实问题:为什么一次看似简单的API调用,账单却悄然攀升?答案往往藏在那个不起眼的计量单位——Token里。 当你在…

作者头像 李华
网站建设 2026/4/23 6:59:04

【开题答辩全过程】以 基于Springboot的社区二手物品回收平台为例,包含答辩的问题和答案

个人简介一名14年经验的资深毕设内行人,语言擅长Java、php、微信小程序、Python、Golang、安卓Android等开发项目包括大数据、深度学习、网站、小程序、安卓、算法。平常会做一些项目定制化开发、代码讲解、答辩教学、文档编写、也懂一些降重方面的技巧。感谢大家的…

作者头像 李华
网站建设 2026/4/23 11:15:38

辉视智慧信息发布系统:赋能多场景,开启信息传播新范式

在数字化浪潮席卷各行业的当下,信息的高效、精准传递成为提升管理效能与服务品质的关键。辉视智慧信息发布系统凭借其稳定可靠的性能、灵活多样的功能以及个性化的场景适配能力,打破传统信息传播壁垒,在酒店、学校、监狱等多个领域展现出卓越…

作者头像 李华