1、修改oracle的管理员密码后,需要重启操作系统。
[oracle@dbserver ~]$ lsnrctl start
[oracle@dbserver ~]$ dbstart /opt/oracle/product/11.2.0/dbhome_1/
[oracle@dbserver ~]$ emctl start dbconsole
解锁用户:
用system或sys用户登陆,然后
ALTER USER username ACCOUNT UNLOCK
数据库的备份:
1>配置备份目录
mkdir /opt/mydbbackup
chown oracle:oinstall /opt/mydbbackup
SQL> create directory dmpdir as '/opt/mydbbackup';
Directory created.
SQL> grant read,write on directory dmpdir to sysman;
Grant succeeded.
注意:sysman是新创建的用户,默认是锁定状态,需要先解锁。
SQL> alter user sysman account unlock;
2>备份(导出)数据
expdp sysman directory=dmpdir dumpfile=orcl.dmp
ORACLE 中更改用户密码的方法 用OS认证方式登陆,即是CONNECT / AS SYSDBA 登陆,然后修改密码就是了 ALTER USER SYS IDENTIFIED BY ****, ALTER USER SYSTEM IDENTIFIED BY **** 然后你可以改变成密码文件认证。
alter user sysman identified by 123456;
阅读(1070) | 评论(0) | 转发(0) |