oracle一些常识

1、重新安装grid

删除grid目录所有文件，删除oracle目录所有文件，然后在做如下清理：

[root@rac_1 grid]# rm -rf /etc/ora*

[root@rac_1 grid]# rm -rf /opt/app/grid/*

[root@rac_1 grid]# rm -rf /usr/local/bin/dbhome

[root@rac_1 grid]# rm -rf /usr/local/bin/oraenv

[root@rac_1 grid]# rm -rf /usr/local/bin/coraenv

[root@rac_1 grid]# rm -rf /opt/app/oraInventory

 

2、dd命令

             dd if=从哪里来  of=到哪里去  bs=块大小   count=块数量

 

 

3、安装节点执行脚本root.sh的时候，注意实时监控日志文件，文件的路径：$ORACLE_HOME/log，然后执行命令： tail –f alert*.log

 

 

 

 

4、数据库集群配置

4.1、添加数据库到集群

srvctl add database –d rac –o [$OACLE_HOME]

4.2、添加实例

srvctl add instance –d rac –i rac1

srvctl add instance –d rac –i rac2

4.3、启动数据库

srvctl start database –d rac

启动过程中实时监控告警日志：

cd $ORACLE_BASE/diag/rdbms/rac/rac1/rac1/trace

tail –f alert*.log

4.4、启动实例

srvctl start instance –d rac –i rac1

srvctl start instance –d rac –i rac2

4.5、查看数据库状态

srvctl status database –d rac

 

 

 

5、命令行里查看磁盘组的挂载情况

$asmcmd

ASMCMD>lsdg

 

 

 

6、创建目录

mkdir -p /data/app/oracle/admin/rac/adump

mkdir -p /data/app/oracle/admin/rac/bdump

mkdir -p /data/app/oracle/admin/rac/dump

 

 

 

select status from v$instance;

 

 

 

expdp system/oracle directory=datadump dumpfile=fumao_zh.dmp logfile=fumao_zh.log schemas=fumao_zh

SQL> create directory datadump as '/home/oracle/088'; 

SQL> grant read,write on directory datadump to system;

可能会报错：

ORA-39006: internal error

ORA-39213: Metadata processing is no

可以用命令试一试如下：

1.select * from dba_objects where object_name='DBMS_DATAPUMP'; 

没有内容就执行以下包 

2.exec sys.dbms_metadata_util.load_stylesheets 

还有一种可能，就是恢复目标表空间不够大。大于原空间大小试试。 

 

 

impdp system/oracle directory=datadump dumpfile=fumao_zh.dmp logfile=fumao_zh.log remap_schema=fumao_zh:fumao_zh table_exists_action=replace

 

2013-08-08 18:20:49 Phoenix

[grid@rac01 rac01]$ oerr ora 28000

28000, 00000, "the account is locked"

// *Cause:   The user has entered wrong password consequently for maximum

//           number of times specified by the user's profile parameter

//           FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account

// *Action:  Wait for PASSWORD_LOCK_TIME or contact DBA

 

 

select 'expdp system/oracle directory=datadump dumpfile=' ||username||'.dmp' || ' logfile='||username||'.log'

from dba_users where username ='&username';