1 现象说明

将11g 的库通过autoupgrade升级到了19.3，因为测试是升级到CDB 模式，所以升级成功后准备连接PDB 验证下，结果报错：

[dave@cndba.cn admin]$ sqlplus cndba/cndba@DAVE

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 30 19:45:47 2025
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 4376
Additional information: 505769663
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name: ^C
[dave@cndba.cn admin]$

查看相关指标，都正常：

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 DAVE                           READ WRITE NO
SQL> 


[dave@cndba.cn admin]$ cat tnsnames.ora 

DAVE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ora11g)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = dave)
    )
  )

[dave@cndba.cn admin]$ tnsping dave

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 30-JUN-2025 19:50:47

Copyright (c) 1997, 2019, Oracle.  All rights reserved.

Used parameter files:
/u02/app/oracle/product/19.0.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ora11g)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dave)))
OK (0 msec)
[dave@cndba.cn admin]$ 

SQL> select name,pdb from v$services order by 1;

NAME                           PDB
------------------------------ ------------------------------
SYS$BACKGROUND                 CDB$ROOT
SYS$USERS                      CDB$ROOT
cdb19c                         CDB$ROOT
cdb19cXDB                      CDB$ROOT
dave                           DAVE

2 解决方法

想到之前遇到的另一个连接错误，如下：

Oracle 18c 通过 service_name 连接PDB 报ORA-12514 错误解决方法
https://www.cndba.cn/cndba/dave/article/2997http://www.cndba.cn/dave/article/131665

虽然在后来的19c中也没有配置，也连接正常，就想这修改一下试试，结果修改之后就可以正常连接了，这里先记录一下，可能还有其他原因会导致这个问题：http://www.cndba.cn/dave/article/131665http://www.cndba.cn/dave/article/131665

[dave@cndba.cn admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u02/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

# end-delta orcl

# start-delta orcl

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = dave)
      (ORACLE_HOME = /u02/app/oracle/product/19.0.0/dbhome_1)
      (SID_NAME = cdb19c)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = cdb19c)
      (ORACLE_HOME = /u02/app/oracle/product/19.0.0/dbhome_1)
      (SID_NAME = cdb19c)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ora11g)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

[dave@cndba.cn admin]$ 

[dave@cndba.cn admin]$ lsnrctl reload

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 30-JUN-2025 19:47:37

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
[dave@cndba.cn admin]$ sqlplus cndba/cndba@DAVE

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 30 19:47:39 2025
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:
ORA-28002: the password will expire within 7 days



Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> show con_name

CON_NAME
------------------------------
DAVE
SQL>

版权声明：本文为博主原创文章，未经博主允许不得转载。