发布时间：2015-05-22 15:04:23
rac ha服务ip问题导致rac无法启动
解决方法1.
#cd /u01/app/11.2.0/grid_home/bin......【阅读全文】
发布时间：2014-12-12 17:37:57
sql>SELECT username,PROFILE FROM dba_users;
2、查看指定概要文件（如default）的密码有效期设置：
sql>SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
3、将密码有效期由默认的180天修改成“无限制”：
......【阅读全文】
发布时间：2014-12-12 17:36:23
select sql_text,a.sql_id,sample_time,sql_opname,machine from v$sql a ,dba_hist_active_sess_history b where a.sql_id = b.sql_id
查询历史sql
select utl_inaddr.get_host_address('dbpay') from dual;
把主机名转换成ip
(主机名需要在hosts文件内)......【阅读全文】
发布时间：2014-10-10 09:34:20
#!/bin/bash
time=`date +%Y%m%d`
#echo "rman_backup_$time.log"
cat /home/oracle/logs/rman_backup_$time.log | mail -s "This is 141 rman logs" xuzhaowei@paypalm.cn......【阅读全文】
发布时间：2014-10-09 15:25:02
select a.owner Owner,
a.tablespace_name Tablespace,
a.segment_type Type,
a.segment_name Name,
ROUND(a.bytes / 1048676) "Size/M"
from dba_segments a
where a.owner not in
('SCOTT', 'ORACLE_OCM', 'XS$NULL', 'MDDATA', 'DIP',
'APEX_PUBLIC_USER', 'SPATIAL_CSW_ADMIN_USR', 'SPATIAL_WFS_ADMIN_USR',
'FLOWS_FILES', 'MDSYS', 'ORDSYS', 'EXFSYS', 'DBSNMP', 'WMSYS',
'APPQOSSYS', 'APEX_030200', 'OWBSYS_AUDIT', 'ORD......【阅读全文】
