1.PURPOSE AND SCOPE
It is posible to fix the logical errors, with using flashback database technology but for sure time period of this kind of operations depends of flashback time of database.While using flashback technology we can use time,log sequence or SCN.
P.S: Disk failure and deletion of datafile/redo/control file cant be restored with technology.
2.PRACTICE
2.1. We are going to connect to closed db and open flashback option.
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
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.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)
1.AMAÇ VE KAPSAM
ASM alanın üstünde expdp ve impdp programlarının kullanımı.
2.UYGULAMA
2.1. Klasik komutları kullanarak ASM alanı üstüne expdp veya impdp çalıştırdığımızda aşağıdaki hataları alırız.
ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 536 ORA-29283: invalid file operation
1.AMAÇ VE KAPSAM
Asm disk alanı olusturup, ustunde veritabanını olusturmak.
2.UYGULAMA
2.1. Asm kurulumu ve yönetimi için 3 tane rpm gerekiyor , bu rpmleri oracle’in sayfasindan temin edebilirsiniz.
[root@oracle ~]# rpm -ivh Desktop/oracleasm-support-2.1.7-1.el5.i386.rpm
warning: Desktop/oracleasm-support-2.1.7-1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing… ########################################### [100%]
1:oracleasm-support ########################################### [100%]
[Read more…]
1.AMAÇ VE KAPSAM
Oracle Grid Oracle’ın nadir bedava ürünlerinden biridir, muhtemelen bununda sebebi kurulum da yaşayacağınız olası sorunlar ve buglardır, aşağıda en sorunsuz yapmış olduğum kurulum prosedürünü sizlerle paylaştım.Oracle grid kurulumuna başlamadan önce oracle veritabanı ve weblogic kurmamız gerekiyor.Daha sonrada grid kurulumuna geçeceğiz.
I. Red Hati Oracle kurulumu için hazırlıyoruz.
a) Vmware Tools kurulumu
Cd /root/Desktop/
Tar zxpf VMwareTools*
Cd vmware*
./vmware-*
1.AMAÇ VE KAPSAM
Vmware Workstation 7.0.0 üstüne Red Hat Enterprise Linux 5.4 kurulumu.
2.UYGULAMA