Skip to main content

Posts

 1). finding the sid with request id == enter 10102224 select f.request_id,p.spid B_Process,s.sid,s.serial#,s.process F_Process,s.program, u.description  from v$session s, v$process p, apps.fnd_concurrent_requests f, apps.fnd_user u  where f.oracle_process_id = p.spid  and p.addr=s.paddr  and f.request_id=&request_id  and f.requested_by = u.user_id;  2: Find sid status. select username,osuser,status,sid,serial#,last_call_et/3600,machine,to_char(logon_time,'DD-MM-yyyy HH24:MI:ss') from v$session where sid=59 select phase_code, status_code from apps.fnd_concurrent_requests where request_id=10102224; select phase_code, status_code from apps.fnd_concurrent_requests where request_id=10102226; select username,osuser,status,sid,serial#,last_call_et/3600,machine,to_char(logon_time,'DD-MM-yyyy HH24:MI:ss') from v$session where sid in ('4472','17811','1172','6722','7809','6715'); select phase_code, status_code from apps.fnd_conc...
Post a Comment
Read more
Recent posts

CREATE A PHYSCIAL STANDBY DATABASE

CREATE A PHYSCIAL STANDBY DATABASE - ORACLE 10G DATAGUARD CONCEPT. 1. Os versions / Database Versions / Patchset Level should be same. 2. SID should be same , if not use convert parameter in pfile. · Here SID = CLONE is the same between two servers. Primary side Hostname : devr12.xoffice.com Sid : CLONE Ip : 192.168.0.209 a).Install the Linux Operating system , and #setup -à Disable Firewall at OS Level Mandatory b).Install the Oracle 10g Software System pwd : sadha ; Sys pwd : xxx ---à these two password should same into two nodes. Rman configuration -- if require. Database in the Archive log mode. c). configure ssh between two servers. ** Ssh configuration between to nodes ( servers ) 1 st Node side side : 192.168.0.209 Primary side. a). Login – oracle user b). mkdir ~/.ssh chmod 755 ~/.ssh $/usr/bin/ssh-keygen –t rsa $ /usr/bin/ssh-keygen –t -dsa $ cd .ssh $ cat id_rsa.pub > devr12 Cat id_dsa.pub >> devr12 2nd Node side: 192.168.0.99 Standby side. a). Login – or...
Post a Comment
Read more

Database up gradation from 10g ( 10.2.0.4 ) to 11g ( 11.1.0.7)

Database up gradation from 10g ( 10.2.0.4 ) to 11g ( 11.1.0.7) in Oracle Application 11i Metalink Note : 452783.1 Step 1 : Down Load the Database Software from (edelivery.oracle.com/ or. http://www.oracle.com/tehnology/software/products/database/index.html 1. 11g Database ( Base versions 11.1.0.6) --- V14215-01_1of2.zip 2. Oracle Database 11g Examples ( formerly Companion ) ---- aix.ppc64_11gR1_examples.zip 3. 11g Database (11.1.0.7) Patch set ---- p6890831_111070_AIX5L_1of2.zip Step 2: Stop the Oracle Application services , and Shutdown the Database and Db Listener. Take Full Cold Backup. Step 3: Create a New 11g Database Home : /B01/oracle $ mkdir test11gdb Step 4 : Install the 11g Database only Software only. $ export Oracle_Base = /B01/oracle/test11gdb …. Export Oracle_SID = TESTNW cd /t01/clone/others/patches/upgrd_db11g/database_11g/database$ $ ./runInstaller -invPtrLoc /B01/oracle/test11gdb /oraInst.loc Note: For oracle Inventory Location Create OraInst.loc file in the ( at New...
Post a Comment
Read more