Upgrading In Oracle

-
                                 Upgrading from Oracle 9i to Oracle Database 11g


Comments

Post a Comment

Popular posts from this blog

ORACLE GOLDENGATE

-
Image
1)  GoldenGate Setup & Configuration On Source & Target Hosts Perform the Following On Source: Unzip the GG Software and Perform the installation & Configuration [oracle@targethost]/data # unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip [oracle@targethost]/data # tar -xvf ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip [oracle@sourcehost]/data/ggate # ./ggsci GGSCI (targethost) 1> create subdirs 1. Ensure The database is in archive log mode 2. Create Necessary tablespace and goldengate user in database SQL> create tablespace ggs_data datafile '/data/GGS/Base/ggs_data01.dbf' size 200m; SQL> create user ggs_owner identified by ggs_owner default tablespace ggs_data temporary tablespace temp; SQL> grant connect,resource to ggs_owner; SQL> grant select any dictionary, select any table to ggs_owner; SQL> grant create table to ggs_owner; SQL> grant flashback any table to ggs_owner; SQL> grant execute on dbms_flashback to...
Read more

EXADATA ARCHITECTURE IN ORACLE

-
Image
OVERVIEW :                You can use Exadata to consolidate your storage environment Using Exadata multiple  databases can use storage from a single pool. Exadata uses Oracle Automatic Storage Management (ASM) to evenly distribute the storage load for every database across every available disk in the storage pool. Every database can use all the available disks to maximize performance. Exadata requires the use of Oracle Database 11g Release 2. Exadata works equally well with single-instance or Oracle Real Application Clusters (RAC) databases. Users and database administrators use the same tools and knowledge they are already familiar with. Being based on industry-standard components and technologies, Exadata is inexpensive to deploy. In addition, tight integration with the full suite of Oracle Database high-availability features, ensures that the reliability and integrity needs of mission-critical environ...
Read more

CREATING SCHEDULER JOBS

-
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...
Read more