oracle服务的启动|备份

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;