1.PURPOSE AND SCOPE
We need to install utlmail and prvtmail scripts to send email through databases,with help of these script we are going to create some synonyms and packages. After installation of script we need to set smtp server parameter and grants.
2.PRACTICE
2.1. Going to connect database through sqlplus and starting utlmail.sql script.
2.1.1. Content of utlmail.sql
1.PURPOSE AND SCOPE
At another article of mine ,I explained installation of Physical standby and this article we are going to convert physical standby database to logical standby.
2.PRACTICE
2.1. At primary database we need to execute a query to see which tables are not supported by logical standby
1.PURPOSE AND SCOPE
In this article i am going to explation how to add new disk to the diskgroup which used by database.Before starting i wanted to give some informations about our steps. In this practice we had got a disk named DISK4 and this isnt belong to single diskgroup.First of all i am going to check the stability of DISK4, if disk success i am going to create a different diskgroup and try to add it there.If this step also succeed we are going to add this disk to diskgroup which used by production diskgroup.
2.PRACTICE
2.1. Time to control stability of DISK4 . (If you have got RAC env, you need to do this every single node)
1.PURPOSE AND SCOPE
In some cases we accidentally forget and create datafiles on local disk while using.In this article i am going to explain how to move datafile local disk to ASM.
2.PRACTICE
2.1. I use 2 node RAC system for this practice. And create 2 tablespace on node 1 local disk.
1.PURPOSE AND SCOPE
When using RMAN for taking backup, database records to backup informations to controlfile. Oracle suggest to use RMAN catalog option because of probability to losing controlfile.With help of RMAN catalog we can save rman informations at catalog database.Also it can use for saving rman scripts and information about rman backups.For to use this product we also need another database which act like a catalog database.
In this artichle i am going to explain how to install oracle RMAN catalog,how to register your database to catalog database and how to control backups.
1.PURPOSE AND SCOPE
If the dumpfile located on non-shared area and dba try to start impdp operation with parallel on RAC servers (version 11gR2),dba would receive ORA-31693, ORA-29913, ORA-31640, ORA-19505, ORA-27037 errors. The reason behind it oracle try to import using all RAC nodes for this operation and if the dumpfile is located on non-shared place , it could no reach it.
1.AMAÇ VE KAPSAM
Productıon olarak çalışan veritabanlarında querylere göre index oluşturup performans testleri yapmak oldukça riskli bir çalışmadır, bundan dolayı oracle bize virtual index özelliğini sağlamış. Bu özellik sayesinde index oluşturmadan querylerinizin performanslarını kontrol edebilirsiniz ve bu esnada uygulamadan gelen quer
1.AMAÇ VE KAPSAM
Redefinition production ortamlarda veritabaninda kesinti yaratmadan tablo’nun storage parametrelerini degiştirmek,farkli bir tablespace taşimak veya yeni kolonlar eklemek,silmek ve degiştirmek için kullanilabilir.
Aşağıdaki çalışmamda bir tabloyu partition’li hale getirip 2009,2010,2011 yıllarına ayit partition’larını exadatanin özelliği olan “archive high” compress’liyecem,2012 yılının aylarınıda OLTP compress yapicam.Bu esnada veritabanı operasyonel olarak çalişmaya devam edicek.
Kisaca redefinition nasil çalıştığını anlatayım: yeni tablonuzu redefinitiona tanımladığınızda redef. bu tablonuzu materialized view çeviriyor ve datayı bu mv’un içine aktarıyor bu esnada orjinal tablonuzda da materialized view log olusturup tablonuza gelen insert,delete ve update işlemlerini kayit altina aliyor.
1.AMAÇ VE KAPSAM
Tablo ve Partitionlı tablolarda export alınırken alınan EXP-00003: no storage definition found for segment(0, 0) hatasının çözümü.
2.UYGULAMA
2.1. Tablo ve partitionlı tablo üstünde exportu başlatıyoruz.
bash-3.2$ exp bcanbakal/bcanbakal TABLES=('BCANBAKAL.BIG_TABLE', 'BCANBAKAL.BIG_TABLE2:BIG_TABLE_2003') file=/home/oracle/big_table_exp.dmp log=/home/oracle/big_table_exp.log
Export: Release 11.2.0.1.0 - Production on Wed Jan 25 11:28:22 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining,
Export done in WE8MSWIN1252 character set and UTF8 NCHAR character set
server uses WE8ISO8859P9 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table BIG_TABLE
EXP-00003: no storage definition found for segment(0, 0)