Notice (8): file_put_contents(): Write of 274 bytes failed with errno=28 No space left on device [CORE/src/Log/Engine/FileLog.php, line 140]

Notice: file_put_contents() [function.file-put-contents]: Write of 1108 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Notice (8): unserialize() [<a href='https://secure.php.net/function.unserialize'>function.unserialize</a>]: Error at offset 16363 of 16373 bytes [APP/Controller/NewsController.php, line 5571]

Notice: file_put_contents() [function.file-put-contents]: Write of 2757 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Warning (2): Undefined array key "nsort" [APP/Controller/NewsController.php, line 3613]

Notice: file_put_contents() [function.file-put-contents]: Write of 2071 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Warning (2): Trying to access array offset on value of type null [APP/Controller/NewsController.php, line 3613]

Notice: file_put_contents() [function.file-put-contents]: Write of 2095 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Warning (2): Undefined array key "nsort" [APP/Controller/NewsController.php, line 3613]

Notice: file_put_contents() [function.file-put-contents]: Write of 2071 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Warning (2): Trying to access array offset on value of type null [APP/Controller/NewsController.php, line 3613]

Notice: file_put_contents() [function.file-put-contents]: Write of 2095 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Oracle找回密码方法 - 站长搜索
首页 > 资讯列表 > 编程/数据库 >>

Oracle找回密码方法

Warning (2): Undefined array key "nsort" [ROOT/plugins/Kuhuang/templates/Websites/view.php, line 430]
Notice: file_put_contents() [function.file-put-contents]: Write of 2419 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Warning (2): Trying to access array offset on value of type null [ROOT/plugins/Kuhuang/templates/Websites/view.php, line 430]

Notice: file_put_contents() [function.file-put-contents]: Write of 2443 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
">
Warning (2): Undefined array key "nsort" [ROOT/plugins/Kuhuang/templates/Websites/view.php, line 430]

Notice: file_put_contents() [function.file-put-contents]: Write of 2419 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
Warning (2): Trying to access array offset on value of type null [ROOT/plugins/Kuhuang/templates/Websites/view.php, line 430]

Notice: file_put_contents() [function.file-put-contents]: Write of 2443 bytes failed with errno=28 No space left on device in /www/wwwroot/www.adminso.com/vendor/cakephp/cakephp/src/Log/Engine/FileLog.php on line 140
2014-11-29 05:35:45 转载来源: 网络整理/侵权必删

首先他会让你输入用户名:你只要输入connect/as sysdba,注意as 和sysdba之间有空格 。然后他会叫你输入  口令

首先他会让你输入用户名:你只要输入connect/as sysdba,注意as 和sysdba之间有空格 。然后他会叫你输入 
口令。但是不要理他,点击enter。OK 链接成功了。接下来你就要 


1 创建用户/密码并授权  


Oracle创建用户/密码并授权 


(1)       创建用户 


Create user 用户名 identified by 密码;(如果是数字则要加双引号”111111”,如果是字母就不用) 


(2)       授权给某个用户 


Grant connect,resource to 用户名;(只有用户有了connect 和 resource后才能操作其他表) 


(3)       授DBA 权限 


Grant dba to 用户名; 


(4)       给用户创建会话的权限: 


grant create session to DB_USER     


(3)       授DBA 权限 


Grant dba to 用户名; 


(4) 撤权:    
       revoke   权限...   from 用户名; 


(5)删除用户: 
2  修改用户名和密码 
   修改用户密码(例:修改sys用户密码为123):alter user sys identified by 123; 


1、windows 平台下运行 cmd 


2、sqlplus /nolog 


3、SQL> connsys/lmis@lmisdx_localas sysdba 连接到数据库。通常可以用sys用户登陆。 


4、SQL> select * from user$; 找到 name为需要修改的用户的user#。 


5、SQL> UPDATE USER$ SET NAME='新用户名' WHERE USER#=38; 
   已更新 1 行。 


6、SQL> COMMIT;提交完成。 


7、SQL> ALTER SYSTEM CHECKPOINT; 
   系统已更改。 


8、SQL> ALTER USER 新用户名 IDENTIFIED BY 新密码; 
   此时会提示新用户不存在。 


SQL> ALTER USER 新用户名 IDENTIFIED BY 新密码         


*ERROR 位于第 1 行:ORA-01918: 用户'新用户'不存在 


SQL> ALTER USER 新用户名 IDENTIFIED BY 新密码         


*ERROR 位于第 1 行:ORA-01918: 用户'新用户'不存在 
9、SQL> ALTER SYSTEM FLUSH SHARED_POOL; 
   系统已更改。 


10、SQL> ALTER USER 新用户 IDENTIFIED BY 新密码; 

    用户已更改。


标签: Oracle 找回 密码 方法


声明:本文内容来源自网络,文字、图片等素材版权属于原作者,平台转载素材出于传递更多信息,文章内容仅供参考与学习,切勿作为商业目的使用。如果侵害了您的合法权益,请您及时与我们联系,我们会在第一时间进行处理!我们尊重版权,也致力于保护版权,站搜网感谢您的分享!

站长搜索

http://www.adminso.com

Copyright @ 2007~2025 All Rights Reserved.

Powered By 站长搜索

打开手机扫描上面的二维码打开手机版


使用手机软件扫描微信二维码

关注我们可获取更多热点资讯

站长搜索目录系统技术支持