----- tnsnames.ora  文件如下:
[oracle@o1930c admin]$ cat tnsnames.ora 
prod =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.52)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = prod)
    )
  )


-----使用网络远程登录 
sqlplus sys@prod as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 28 10:36:11 2024
Version 19.3.0.0.0

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

Enter password: 
ERROR:
ORA-01017: invalid username/password; logon denied



----重建密码文件orapwprod
cd $ORACLE_HOME/dbs
mv orapwprod orapwprod.bak 
orapwd file='orapwprod'  password=PROD_123_prod

sqlplus  sys@prod as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 28 11:11:42 2024
Version 19.3.0.0.0

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

Enter password: 

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

SYS@prod> 
SYS@prod> 
SYS@prod> 
SYS@prod> 
SYS@prod> 
SYS@prod> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           MOUNTED
SYS@prod> 


----登录成功

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐