SQL query

 ALTER DATABASE BACKUP CONTROLFILE TO TRACE as '/oracle_data/d01/erpcln/oracln/db/tech_st/10.2.0/090911.ctl';

 
ALTER DATABASE DATAFILE '/erpcln/oracln/db/tech_st/10.2.0/dbs/MISSING00049' OFFLINE DROP;

ALTER TABLESPACE TEMP1 ADD TEMPFILE '/oracle_data/d01/data/clndata1/temp05.dbf' REUSE;

ALTER TABLESPACE TEMP2 ADD TEMPFILE '/oracle_data/d01/data/clndata1/temp06.dbf' SIZE 2048M REUSE AUTOEXTEND OFF;


ALTER TABLESPACE TEMP2 ADD TEMPFILE '/oracle_data/d01/data/clndata1/temp10.dbf'SIZE 10240M REUSE AUTOEXTEND OFF;

alter user apps account unlock



FNDCPASS apps/[oldpassword] 0 Y system/[system password] SYSTEM APPLSYS [new apps password]
FNDCPASS apps/password 0 Y system/password USER sysadmin new_password




FNDCPASS apps/apps 0 Y system/manager USER sysadmin dhanush123


FNDCPASS apps/r12clone 0 Y system/manager SYSTEM APPLSYS apps



FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS ma2010pesa

FNDCPASS apps/ma2010pesa 0 Y system/manager SYSTEM APPLSYS dhanush123
  FNDCPASS apps/r12clone 0 Y system/r12clone SYSTEM APPLSYS ma2010pesa

  FNDCPASS apps/r12clone 0 Y system/r12clone SYSTEM APPLSYS ma2010pesa


perl adcfgclone.pl appsTier /oracle_data/d02/inst/apps/CRP1_tdzain-cdr2b/appl/admin/CRP1_tdzain-cdr2b.xml


FNDCPASS apps/ 0 Y system/r12clone USER sysadmin dhanush123

SQL> apps/apps
SQL> exec FND_FILE.PUT_LINE(FND_FILE.LOG, ‘THIS IS A TEST’);




alter system set utl_file_dir='/erpcln/oracln/db/tech_st/admin' scope=spfile;
alter system set utl_file_dir='/erpcln/oracln/db/tech_st/admin' scope=both;


alter system set utl_file_dir='/erpcln/oracln/db/tech_st/admin/utl_file_dir' scope=spfile;


SELECT name, value FROM v$parameter WHERE name LIKE 'utl_file_dir';



FNDCPASS apps/ma2010pesa 0 Y system/r12clone USER sysadmin dhanush123



alter profile DEFAULT limit failed_login_attempts unlimited;
alter user apps account unlock;


isainfo -kv, ---to find bit version




EXEC FND_CONC_CLONE.SETUP_CLEAN


alter system set processes=700 scope=spfile;

alter system reset utl_file_dir scope=both sid='*' scope=spfile;

alter system set utl_file_dir='/erpcln/oracln/db/tech_st/admin/utl_file_dir' scope=spfile;

alter system set utl_file_dir='/oracle_data2/d01/erpcln/oracln/db/tech_st/admin/utl_file_dir' scope=spfile;

/oracle_data2/d01/erpcln/oracln/db/tech_st/





 create table FND_ORACLE_USERID_BAK as (select * from FND_ORACLE_USERID);

create table FND_USER_BAK as (select * from FND_USER);

FNDCPASS apps/r12clone 0 Y system/r12clone SYSTEM APPLSYS ma2010pesa

perl adcfgclone appsTier /oracle_data/d02/inst/apps/CRPGA1_erpdb-gabon/appl/adminCRPGA1_erpdb-gabon.xml




select PATH from FND_OAM_CONTEXT_FILES ;



alter system reset utl_file_dir scope=both sid='*';
1. shutdown appstier
2. shutdown db
3. startup nomount
4. sho parameter utl_file_dir
5. alter system set utl_file_dir='/usr/tmp'
6. sho parameter utl_file_dir (if change is not come, then ..
7. shut immediate
8. startup nomount
9. sho parameter utl_file_dir ( the changes must be applied now)
10. alter database mount;
alter database open;



alter system reset utl_file_dir scope=both sid='*';
1. shutdown appstier
2. shutdown db
3. startup nomount
4. sho parameter utl_file_dir
5. alter system set utl_file_dir='/oracle_data/d01/erpcln/oracln/db/tech_st/admin/utl_file_dir' scope=spfile;

6. sho parameter utl_file_dir (if change is not come, then ..
7. shut immediate
8. startup nomount
9. sho parameter utl_file_dir ( the changes must be applied now)
10. alter database mount;
alter database open;

sho parameter utl_file_dir;

XLIFFLoader.class


Applications Patching Knowledge Browser Product Page (Note ID: 268546.1)


///////////////////////////

SR
///////////

create table XDO_TEMPLATES_B_BKP as select * from XDO_TEMPLATES_B;


SQL> conn apps/ma2010pesa
Connected.
SQL> create table XDO_TEMPLATES_B_BKP as select * from XDO_TEMPLATES_B;

Table created.

SQL> Update XDO_TEMPLATES_B
Set mls_territory='US'
where application_id=200
and template_code='APPPBR';
  2    3    4
1 row updated.

SQL> commit;

Commit complete.

SQL>

/oracle_data/d01/erpcln/oracln/db/tech_st/admin/utl_file_dir


/oracle_data2/d01/erpcln/oracln/db/tech_st/admin/utl_file_dir
                                             

alter system reset utl_file_dir scope=spfile sid='*' ;



alter system set utl_file_dir='/oracle_data2/d01/erpcln/oracln/db/tech_st/admin/utl_file_dir' scope=spfile;


SQL> create spfile from pfile;

File created.

SQL> show parameter spfile ;





EXEC FND_CONC_CLONE.SETUP_CLEAN;
commit

autoconfig in DB then in apps