Oracle更改system和sys用户密码

    技术2022-05-11  7

    D:/oracle/ora92/bin>sqlplus /nolog 这句话是说不登陆数据库,只启动sqlplus

    SQL*Plus: Release 9.2.0.1.0 - Production on 星期四 8月 16 11:32:22 2007

    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

    SQL> conn /as sysdba已连接。SQL> alter user system identified by password;

    用户已更改。

    SQL> alter user sys identified by password;

    用户已更改。

    SQL> alter user system identified by manger;

    用户已更改。

    SQL> exit从Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production中断开

    D:/oracle/ora92/bin>sqlplus

    SQL*Plus: Release 9.2.0.1.0 - Production on 星期四 8月 16 11:40:37 2007

    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

    请输入用户名:  system请输入口令:

    连接到:Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production

    SQL> select instance_name from v$instance;

    INSTANCE_NAME----------------orcl


    最新回复(0)