我已经创建了一个名为netcoolc的Oracle 21 CDB，但由于某种原因，我无法使用正确的连接字符串与sys用户连接。

[reporter@iqlinkxg02 ~]$ sqlplus sys/"PW"@netcoolc as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on Wed Nov 15 12:51:39 2023
Version 21.3.0.0.0

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

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Enter user-name:

字符串
..

[reporter@iqlinkxg02 ~]$ tnsping netcoolc

TNS Ping Utility for Linux: Version 21.0.0.0.0 - Production on 15-NOV-2023 12:52:38

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

Used parameter files:
/opt/oracle/product/21c/dbhome_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = iqlinkxg02)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = netcoolc)))
OK (0 msec)
[reporter@iqlinkxg02 ~]$

型
.和最奇怪的事情，我可以登录与以下字符串.

[reporter@iqlinkxg02 ~]$ sqlplus / as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on Wed Nov 15 12:53:49 2023
Version 21.3.0.0.0

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

Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL>

型
下面您可以找到操作系统用户.bash_profile文件的内容.

# Oracle 21c netcool  Environment Variables - START
ORACLE_BASE=/opt/oracle; export ORACLE_BASE
ORACLE_HOME=${ORACLE_BASE}/product/21c/dbhome_1; export ORACLE_HOME
ORACLE_SID=netcoolc; export ORACLE_SID
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$PATH; export PATH
NLS_LANG=american_america.WE8ISO8859P1; export NLS_LANG
# Oracle 21c netcool Environment Variables - END

型
.我在这里附加的内容的tnsnames.ora文件.

netcoolc =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = iqlinkxg02)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = netcoolc)
    )
  )

型
任何建议，顶部或帮助将不胜感激！
我试图通过另一个CDB环境进行故障排除，在那里我有相同的设置，但有不同的CDB和用户名。那里一切正常，我找不到小故障。