• oracle重置dba用户密码


    1、进入sqlplus里面:

    [oracle@master ~]$ sqlplus / as sysdba

    SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 25 15:06:28 2018

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


    Connected to:
    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

    SQL> alter user sys identified by admin;

    User altered.

    SQL> conn sys/admin as sysdba;
    Connected.
    SQL> alter user system identified by admin;      

    User altered.
    连接plsql时,首要起监听

    [oracle@master ~]$ lsnrctl start

    查看监听状态:

    [oracle@master ~]$ lsnrctl status

    LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-DEC-2018 15:14:55

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=master)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
    Start Date                25-DEC-2018 15:03:27
    Uptime                    0 days 0 hr. 11 min. 28 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   /u01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora
    Listener Log File         /u01/app/oracle/diag/tnslsnr/master/listener/alert/log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=master)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=master)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))
    Services Summary...
    Service "orcl" has 2 instance(s).
      Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
      Instance "shenlan", status READY, has 1 handler(s) for this service...
    Service "pdborcl" has 1 instance(s).
      Instance "shenlan", status READY, has 1 handler(s) for this service...
    Service "shenlanXDB" has 1 instance(s).
      Instance "shenlan", status READY, has 1 handler(s) for this service...
    The command completed successfully

    《完》

  • 相关阅读:
    我爱Java系列之---【SpringBoot打成war包部署】
    279. Perfect Squares
    矩阵dfs--走回路
    112. Path Sum
    542. 01 Matrix
    106. Construct Binary Tree from Inorder and Postorder Traversal
    105. Construct Binary Tree from Preorder and Inorder Traversal
    Invert Binary Tree
    563 Binary Tree Tilt
    145 Binary Tree Postorder Traversal
  • 原文地址:https://www.cnblogs.com/hello-wei/p/10174106.html
Copyright © 2020-2023  润新知