Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 19.13 ORA-12154: TNS:could not resolve the connect identifier specified with user SYSTEM

maxranzyMar 7 2022 — edited Mar 7 2022

Hello,
I have a problem when I try to connect with user system to a database version 19.13.0.0.0.
When I try I receive this error
sqlplus system/********@TNS
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Mar 7 16:15:47 2022
Version 19.13.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
If I try to other user or sys user I connect correctly
sqlplus sys/********@TNS as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Mar 7 16:16:32 2022
Version 19.13.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.13.0.0.0
SQL>
sqlplus fid_gf/********@TNS
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Mar 7 16:21:06 2022
Version 19.13.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Last Successful login time: Mon Mar 07 2022 13:02:48 +01:00
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.13.0.0.0
SQL>
Even using tnsping I have no problems
tnsping TNS
TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 07-MAR-2022 16:28:20
Copyright (c) 1997, 2021, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.92.18)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ARGFDBCL_fra126.snarcgfdbcl.arcgfnet.oraclevcn.com)))
OK (0 msec)
Where is the problem?
Regards
Massimo

This post has been answered by EdStevens on Mar 7 2022
Jump to Answer
Comments
Post Details
Added on Mar 7 2022
4 comments
4,257 views