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


所有评论(0)