ORACLE

C:\NARI>cd D:\oracle\mw\oms12c\oms\BIN C:\NARI>D: D:\oracle\mw\oms12c\oms\BIN> emcli login -username=sysman Enter password : Login successful D:\oracle\mw\oms12c\oms\BIN> emcli sync Synchronized successfully D:\oracle\mw\oms12c\oms\BIN> emcli get_supported_platforms ----------------------------------------------- Version = 12.1.0.4.0  Platform = Microsoft Windows (32-bit) ----------------------------------------------- Version = 12.1.0.4.0  Platform = Microsoft Windows x64 (64-bit) ----------------------------------------------- Platforms list displayed successfully. D:\oracle\mw\oms12c\oms\BIN>. \emcli get_agentimage -destination=D:\temp\12cAgent -platform="Microsoft Windows (32-bit)" -version=12.1.0.4.0  === Partition Detail === Space free : 61 GB Space required : 1 GB Check the logs at D:\oracle\mw\oms12c\gc_inst\em\EMGC_OMS1\sysman\emcli\setup/.emcli/get_agentimage_2017-06-28_08-34-02-AM.log Downloading D:\temp\12cAgent\12.1.0.4.0_AgentCore_912.zip File

Create New oracle database service on Windows: oradim -NEW -SID nari -STARTMODE manual -PFILE "C:\Nari\Oracle\product\11.2.0\dbhome_1\database\INITnari.ora" Delete oracle database service on Windows oradim -delete -sid SID ================================================ I have tried with inst , It is not working. It will work only if service is started. If using pfile: C:\Windows\system32>oradim -STARTUP -SID RAM -STARTTYPE inst -PFILE C:\Nari\Oracle\product\11.2.0.4\dbhome\database\initRAM.ora ORA-12560: TNS:protocol adapter error If using spfile: C:\Windows\system32>oradim -STARTUP -SID RAM -STARTTYPE inst -SPFILE ORA-12560: TNS:protocol adapter error Below is working, But it will start database as well. If using spfile: oradim -STARTUP -SID RAM -STARTTYPE srvc – SPFILE If using pfile: C:\Windows\system32>oradim -STARTUP -SID RAM -STARTTYPE srvc - PFILE C:\Nari\Oracle\product\11.2.0.4\dbhome\database\initRAM.ora C:\Windows\system32>sqlplus / as sysdba S

1) Configure and setup new database. 2) Export RMAN catalog schema from existing catalog database. expdp directory=DATA_PUMP dumpfile=rman_catalog_NARI.dmp logfile=rman_catalog_NARI.log schemas=rman 3) Import into new database impdp directory=DATA_PUMP dumpfile=rman_catalog_NARI.dmp logfile=Imp_rman_catalog_MPS7538.log schemas=rman Note: Before improt make sure of enough space (Tablespace size and drive space) 4) Modify all your backup jobs to point new catalog database. If you are using OEM for backups: Database Instance > Avalability > Backup & Recovery > Recovery Catalog Settings > modify recovery catalog

======================================================================== OMS server: 1) Download 13c Agent software from OMS server (Note: We can not get seperate Agent software from Oracle) Microsoft Windows [Version 6.3.9600] (c) 2013 Microsoft Corporation. All rights reserved. C:\NARI>D: D:\>cd D:\oracle\OEM\MW\bin D:\oracle\OEM\MW\bin>emcli login -username=sysman Enter password : Login successful D:\oracle\OEM\MW\bin>emcli sync Synchronized successfully D:\oracle\OEM\MW\bin>emcli get_supported_platforms ----------------------------------------------- Version = 13.2.0.0.0  Platform = Microsoft Windows x64 (64-bit) ----------------------------------------------- Platforms list displayed successfully.                   Command to get 13c agent: *** <emcli_install_location>/emcli get_agentimage -destination=<download_directory> -platform="<platform>" -version=<version> *** D:\oracle\OEM\MW\bin>.\emcli get_agentimage -destination=C:\te

col name for a55 col program for a20 col username for a15 select s.sid, n.name, s.value, sn.username, sn.program, sn.type, sn.module from v$sesstat s   join v$statname n on n.statistic# = s.statistic#   join v$session sn on sn.sid = s.sid where name like '%redo entries%' order by value desc; Based on above sid run below query: select username,status,state,event,sql_id,prev_sql_id from v$session where sid=1;

Start>>All Programs>>Accessories>>System Tools>>Resource Monitor  - Listening  port  -- To find the Services that uses the port in the system