Mithilesh Jambhulkar ORACLE dba

DBA_SCHEDULER_JOB_RUN_DETAILS DBA_SCHEDULER_JOBS exec dbms_scheduler.disable('"ETCSSP"."CUSTOMER_UNIFIED_JOB2"'); EXEC DBMS_SCHEDULER.DROP_PROGRAM(program_name=>'"ETCSSP"."SP_UNVERIFIEDLOANS_MAPPED_JOB1"',FORCE=>TRUE); EXEC DBMS_SCHEDULER.DROP_JOB (job_name => 'CUSTOMER_UNIFIED_JOB2'); SELECT OWNER,JOB_NAME,STATUS,ERROR# FROM DBA_SCHEDULER_JOB_RUN_DETAILS WHERE JOB_NAME='CUSTOMER_UNIFIED_JOB2'; BEGIN sys.dbms_scheduler.create_job( job_name => '"ETCSSP"."SP_UNVERIFIEDLOANS_MAPPED_JOB1"', job_type => 'STORED_PROCEDURE', job_action => '"ETCSSP"."SP_UNVERIFIEDLOANS_MAPPED"', repeat_interval => 'FREQ=DAILY; BYHOUR=22; BYMINUTE=30; BYSECOND=0;', start_date => systimestamp at time zone 'Asia/Calcutta', job_class => '"DEFAULT_JOB_CLASS"', comments => 'UNVERIFIED LOAN MAPPE

HOW TO CREATE THE HETROGENEOUS SERVICE =======================================================microfinance========================================== CREAT TEH INI*.ORA FILE /u02/app/oracle/product/12.1.0.2/gatewayhome_1/dg4msql/admin   --PWD [oracle@rcdbdbadm01 admin]$ cat initReliance.ora HS_FDS_CONNECT_INFO=10.65.7.229:1865//Reliance HS_FDS_TRACE_LEVEL=OFF HS_FDS_RECOVERY_ACCOUNT=RECOVER HS_FDS_RECOVERY_PWD=RECOVER [oracle@rcdbdbadm01 admin]$ [oracle@rcdbdbadm01 admin]$ pwd /u02/app/oracle/product/12.1.0.2/gatewayhome_1/network/admin [oracle@rcdbdbadm01 admin]$ cat tnsnames.ora Reliance_conn =     (DESCRIPTION=         (ADDRESS=(PROTOCOL=tcp)(HOST=rcdbdbadm01.reliancecapital.com)(PORT=1881))         (CONNECT_DATA=(SID=Reliance))         (HS=OK)      )         [oracle@rcdbdbadm01 admin]$ cat listener.ora # listener.ora Network Configuration File: /u02/app/oracle/product/12.1.0.2/gatewayhome_1/network/admin/listener.ora # Generated by Oracle configuration t

Copy archive log from file system to +ASM diskgroup on Standby database catalog archivelog '/tmp/thread_1_seq_372969.12335.973281287'; copy archivelog  '/tmp/thread_1_seq_372969.12335.973281287' to '+RECO_RCDB'; ======================================================================================= RMAN-06571: datafile 301 does not have recoverable copy catalog datafilecopy '+DATA_RCDW/rhfdr/datafile/ggs_data01.dbf'; ============================================================================================ to clear cache at os level sync; echo 3 > /proc/sys/vm/drop_caches =================================================================================================== SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREA

export ORACLE_HOME=/u02/app/oracle/product/12.1.0.2/dbhome_1 export PATH=/u02/app/oracle/product/12.1.0.2/dbhome_1/bin export ORACLE_SID=RCFDLP Step1 : Create init file for new database *.compatible='11.2.0.3.0' *.CONTROL_FILES='+DATA_RCDB','+RECO_RCDB' *.db_block_size=8192 *.db_domain='' *.db_name='RCFDLP' *.DB_UNIQUE_NAME='RCFDLP' *.diagnostic_dest='/u02/app/oracle/' *.audit_file_dest='/u02/app/oracle/admin/RCFDLP/adump' *.db_recovery_file_dest='+RECO_RCDB' *.db_recovery_file_dest_size=2G *.db_create_file_dest='+DATA_RCDB' *.sga_max_size= 2G *.sga_target=1500M *.open_cursors=300 *.pga_aggregate_target=100M *.processes=300 *.REMOTE_LOGIN_PASSWORDFILE='EXCLUSIVE' Step 2: Create pwd file for new database orapwd file=$ORACLE_HOME/dbs/orapwRCFDLP password=sys123 ---orapwd file=orapwRCFDLP2 password=sys123 entries=10 ---orapwd file=orapwRCFDLP1 password=sys123 entries=10