1>编译无效的数据对象。
2>修改系统名称。
3>修改环境变量和adautocfg.sh
4>修改icx_parameter
5>修改邮件地址。
6>检查服务器状态。
select replace(logfile_name,'/u01/oracle/PROD/inst/apps/PROD_hdgesvapprd01','/u01/oracle/UAT/inst/apps/UAT_hdgesvapuat01') from fnd_concurrent_requests;
update fnd_concurrent_requests set
logfile_name=replace(logfile_name,'/u01/oracle/PROD/inst/apps/PROD_hdgesvapprd01','/u01/oracle/UAT/inst/apps/UAT_hdgesvapuat01');
update fnd_concurrent_requests set
outfile_name=replace(outfile_name,'/u01/oracle/PROD/inst/apps/PROD_hdgesvapprd01','/u01/oracle/UAT/inst/apps/UAT_hdgesvapuat01');
select outfile_name from fnd_concurrent_requests;
update fnd_concurrent_requests set
logfile_name=replace(logfile_name,'/u01/oracle/UAT/inst/apps/UAT_hdgesvapuat01','/u01/oracle/SIT/inst/apps/SIT_hdgesvaptest01')
WHERE ROWNUM<100000 and logfile_name like '/u01/oracle/UAT/inst/apps/UAT%';
update fnd_concurrent_requests set
outfile_name=replace(outfile_name,'/u01/oracle/UAT/inst/apps/UAT_hdgesvapuat01','/u01/oracle/SIT/inst/apps/SIT_hdgesvaptest01')
WHERE ROWNUM<100000 and outfile_name like '/u01/oracle/UAT/inst/apps/UAT%';
FNDCPASS apps/hdge20131011 0 Y system/hdgeuat20141011$ SYSTEM APPLSYS hdgeuat20141011
update fnd_concurrent_requests set
logfile_name=replace(logfile_name,'/u01/oracle/PROD/inst/apps/PROD_hdgesvapprd01','/u01/oracle/UAT/inst/apps/UAT_hdgesvapuat01');
update fnd_concurrent_requests set
outfile_name=replace(outfile_name,'/u01/oracle/PROD/inst/apps/PROD_hdgesvapprd01','/u01/oracle/UAT/inst/apps/UAT_hdgesvapuat01');
select outfile_name from fnd_concurrent_requests;
select * from ad_applied_patches order by patch_name
alter user system identified by "hdgeuat20141011$"
select * from apps.fnd_concurrent_requests where request_date>sysdate -5/60/24;
FNDCPASS apps/hdge20131011 0 Y system/hdgeuat20141011$ SYSTEM APPLSYS hdgeuat20141011
FNDCPASS apps/hdgeuat20141011 0 Y system/hdgeuat20141011$ USER SYSADMIN welcome$
declare
i_num number;
begin
select count(1) into i_num from fnd_concurrent_requests;
i_num := ceil(i_num/10000);
for i in 1..i_num loop
update fnd_concurrent_requests set
outfile_name=replace(outfile_name,'/u01/oracle/PROD/inst/apps/PROD_hdgesvapprd01','/u01/oracle/UAT/inst/apps/UAT_hdgesvapuat01'),
logfile_name=replace(logfile_name,'/u01/oracle/PROD/inst/apps/PROD_hdgesvapprd01','/u01/oracle/UAT/inst/apps/UAT_hdgesvapuat01')
WHERE ROWNUM<100001 and outfile_name like '/u01/oracle/PROD/inst/apps%';
commit;
end loop;
end;
UPDATE PER_PEOPLE_F set EMAIL_ADDRESS= '_'||EMAIL_ADDRESS
select a.completion_text,a.request_id,a.request_date,a.phase_code,a.status_code
from fnd_concurrent_requests a where a.request_date>sysdate -5/60/24;
select * from hr_employees
SELECT s.sid, s.serial#, s.username, s.program,
i.block_changes
FROM v$session s, v$sess_io i
WHERE s.sid = i.sid
ORDER BY 5 desc, 1, 2, 3, 4;
SELECT s.sid, s.serial#, s.username, s.program,
t.used_ublk, t.used_urec
FROM v$session s, v$transaction t
WHERE s.taddr = t.addr
ORDER BY 5 desc, 6 desc, 1, 2, 3, 4;
ALTER DATABASE ADD LOGFILE ('/u01/oracle/PROD/db/apps_st/data/log04a.dbf','/u01/oracle/PROD/db/apps_st/data/log04b.dbf')
SIZE 1000M;
ALTER DATABASE ADD LOGFILE MEMBER
'/u01/oracle/PROD/db/apps_st/data/log01c.dbf' TO GROUP 1,
'/u01/oracle/PROD/db/apps_st/data/log02c.dbf' TO GROUP 2,
'/u01/oracle/PROD/db/apps_st/data/log03c.dbf' TO GROUP 3,
'/u01/oracle/PROD/db/apps_st/data/log04c.dbf' TO GROUP 4;
log directory:
/u01/oracle/PROD/db/tech_st/11.1.0/admin/PROD_hdgesvapprd01/diag/rdbms/prod/PROD/trace
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8568259/viewspace-2120759/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8568259/viewspace-2120759/