Bugra Canbakal's Oracle Blog

  • Home
  • Contact
  • SITE MAP
You are here: Home / Archives for Oracle / Single Node

Flashback database

12:04 PM By Bugra Canbakal 4 Comments

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.

[Read more…]

Share this:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Filed Under: RMAN, Single Node Tagged With: flashback, oracle flashback, resetlogs

UTL MAIL: Installation of package which helps to send email through database

08:45 AM By Bugra Canbakal 2 Comments

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

[Read more…]

Share this:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Filed Under: Oracle, Single Node Tagged With: CES, database email, ORA-06502, ORA-06512, UTL_MAIL

Add a new disk to asm diskgroup

12:43 PM By Bugra Canbakal 4 Comments

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)

[Read more…]

Share this:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Filed Under: Oracle, RAC - Real Application Cluster, Single Node Tagged With: asm, disk, diskgroup, new diskgroup

Moving datafile local disk to ASM

11:36 AM By Bugra Canbakal 2 Comments

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.

[Read more…]

Share this:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Filed Under: Oracle, RAC - Real Application Cluster, Single Node Tagged With: asm, move local datafile to asm, oracle, rman

Export alirken alinan EXP-00003 hatasınin çözümü

09:45 AM By Bugra Canbakal Leave a Comment

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)

[Read more…]

Share this:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Filed Under: Oracle, Single Node Tagged With: EXP-00003, export, oracle

Datapump da ASM alanını kullanmak

11:09 PM By Bugra Canbakal Leave a Comment

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

[Read more…]

Share this:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Filed Under: Oracle, Single Node Tagged With: asm, ASM DATAPUMP, ORA-06512, ORA-29283, ORA-39002, ORA-39070

Asm Disk Üstüne Oracle Veritabanı Kurulumu

07:20 PM By Bugra Canbakal 17 Comments

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…]

Share this:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Filed Under: Oracle, Single Node Tagged With: asm, asm disk, oracle, oracle asm, oracle asm database

Oracle Grid ve Weblogic Kurulumu

05:15 AM By Bugra Canbakal Leave a Comment

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.

[Read more…]

Share this:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Filed Under: Oracle, RAC - Real Application Cluster, Single Node Tagged With: database, oracle, oracle grid, rac, weblogic

Vmware Redhat üstüne Oracle kurulumu

01:50 PM By Bugra Canbakal 17 Comments

I. Red Hati Oracle kurulumu için hazırlıyoruz.

 

a) Vmware Tools kurulumu

 

  • Sisteme root olarak giriş yapıyoruz ve kurulumda belirlediğimiz root şifresini yazıyoruz.
  • Ilk yapacağımız iş Vmware toolsu kurmak olacak bunun için yukardaki sekmelerden VM tıklıyoruz ve gelen menuden Install VM Tools seçiyoruz.
  • Linux yeni bir cd tanıyacaktır cdyi açmasına izin verin , bu cdnin içinde Vmware toolsun bulunduğu zip bulunmakta.Bunu sürükle bırak mantığıyla desktopa taşıyalım bu işlemi gerçekleştirirken ne yapmak istediğinizi size soracaktır bu menuden Move here işaretleyin.
  • Desktopda sağ click yapıp en ustte bulunan Konsole yi tıklayın.Şimdi karşınıza shell konsol gelecektir.buraya sırayla aşağıdakileri yazın.

Cd /root/Desktop/

Tar zxpf VMwareTools*

Cd vmware*

./vmware-*

  • Vmware Tools kurmaya başladık size lokasyonlarla ilgili bazı sorular soracaktır [Read more…]

Share this:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Filed Under: Oracle, Single Node Tagged With: oracle, oracle kurulumu, oracle veritabanı kurulumu, vmware oracle, vmware oracle kurulumu

Adım adım vmware üstüne RedHat 5 kurulumu (Oracle kurulumu icin on hazirlik)

11:31 AM By Bugra Canbakal 1 Comment

1.AMAÇ VE KAPSAM

Vmware Workstation 7.0.0 üstüne Red Hat Enterprise Linux 5.4 kurulumu.

2.UYGULAMA

  • Vmware workstation 7’yi açıp New Virtual Machine seçip yeni bir sanal makine yaratıyoruz.
  • Gelen ekrandan Custom(advenced)’ı seçiyoruz.
  • Yeni ekranda Workstation 6.5-7.0 ibaresi seçili kalıyor.
  • “I will install operation system later” ibaresini seçiyoruz.(Eğer bu kısımda linux cdsini veya isosunu gösterip ilerletirsek vmware fast install özelliğini kullanıp, linux partitionlarını seçmenize izin vermiyor)
  • Guest operation systemsda Linuxu Version olarakda Red Hat Enterprise Linux 5 i seçiyoruz.
  • [Read more…]

Share this:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Filed Under: Linux, Oracle, OS, Single Node Tagged With: adım adım oracle kurulumu, oracle, oracle kurulum, redhat, redhat kurulumu

Next Page »

About Me



Language:

  • English
  • Turkish

Categories

  • Oracle
    • RAC – Real Application Cluster
    • RMAN
    • Single Node
    • Standby – Dataguard
  • OS
    • Linux

Blogroll

  • Emre Baransel
  • Gökhan Atıl
  • H. Tonguc Yılmaz
  • Kamil Türkyılmaz
  • Tanel Poder
  • Turkce Oracle
  • Turkish Oracle User Group
  • Uwe Hesse
  • Zekeriya Beşiroğlu

Archives

  • April 2014
  • March 2014
  • August 2013
  • June 2013
  • March 2013
  • January 2013
  • December 2012
  • November 2012
  • July 2012
  • June 2012
  • May 2012
  • January 2012
  • November 2011
  • October 2011
  • August 2011
  • July 2011
  • June 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • June 2010
OCP
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

[footer_backtotop]

Copyright © 2010-2014 Bugra Canbakal. All rights reserved.