ebs克隆后必须步骤。

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/