Bugra Canbakal's Oracle Blog

You are here: Home / Archives for Oracle

Oracle 10g database vault kurulumu

By Leave a Comment

1.AMAÇ VE KAPSAM

Oracle 10g 2.0.4 veritabanı üstüne database vault kurulumu

2.UYGULAMA

2.1. En kötü ihtimale karşı veritabanının full backup’ını alıyoruz.

2.2. Özel profil ayarları ve şifreleme metotları kullanıldıysa önce bunları default değerlere alıp vault kurulumundan sonra geriye çevirebiliriz. Bunun için aşağıdaki scripti çalıştırıyoruz, bu script sayesinde bizim veritabanımızdaki profile ayarlarını sql scripte dönüştürecez ki kurulum bittikten sonra eski haline getirebilelim.myprofiles.sql isimli bir dosya oluşturacaktır.
[Read more…]

Duplicate komutuyla primary asm database’inden non-asm standby database kurulumu

By Leave a Comment

1.AMAÇ VE KAPSAM
ASM kurulu bir veritabanına duplicate komutuyla non-ASM standby yaratmak.

2.UYGULAMA

Database Özellikleri
Database Name :- bugra
Primary db_unique_name : bugra // ASM
Standby db_unique_name : stdby // non-ASM
Primary Hostname :- bugra.localdomain // 192.168.2.101
Standby Hostname :- stdby.localdomain // 192.168.2.102

2.1 Oluşturacağımız dosyalar için primaryde ve standbyda lokasyonları yaratıyoruz.
[Read more…]

Finding the location of database Alert log, ASM Alert log, Cluster log and OS logs

By Leave a Comment

1.PURPOSE AND SCOPE

Finding the location of Alert log, ASM Alert log, Cluster log and OS logs

2.PRACTICE

2.1 Finding location of Alert log.

2.1.1 Need to connect sqlplus and check the parameter of background_dump_dest.

 

# sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 21 09:53:17 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> show parameter background
NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
background_dump_dest                 string                           /u01/app/oracle/diag/rdbms/stdby/stdby/trace

 

2.1.2 And our alert log is in that location

#ls /u01/app/oracle/diag/rdbms/stdby/stdby/trace/a*.log
-rw-r-----   1 oracle     dba           5006 Aug 21 09:08 /u01/app/oracle/diag/rdbms/stdby/stdby/trace/alert_AA.log

 

2.2 Finding the ASM Alert log location

2.2.1 To connect ASM instance we need to change our  ORACLE_SID.If our enviroment is cluster we need to set it like +ASM1 or +ASM2 etc.. it depends on node number.

#export ORACLE_SID=+ASM

 

2.2.2 Need to connect sqlplus and check the parameter of background_dump_dest .

# sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 21 09:53:17 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> show parameter background
NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
background_dump_dest                 string                           /u01/app/oracle/product/11.1.0/db_1/rdbms/asm/+asm/log/

 

2.2.3 And our alert log is in that location

#ls /u01/app/oracle/product/11.1.0/db_1/rdbms/asm/+asm/log/a*.log
-rw-r-----   1 oracle     dba           5006 Aug 21 09:08 /u01/app/oracle/product/11.1.0/db_1/rdbms/asm/+asm/log/alert_ASM.log

 

2.3 Location of Cluster logs

2.3.1 First we need to check is our Cluster home enviroment setted or not.

echo $ORA_CRS_HOME
/u01/oracle/product/crs/

 

2.3.2 And we can reach Cluster logs with this command

ls $ORAC_CRS_HOME/log/aler*

 

2.4 Os log locationSistem log lokasyonu

2.4.1 It would be much better to connect OS with root acc.

vi /var/log/dmesg

 

or

dmesg | less

 

[Read more…]

Creating AWR report using command line

By Leave a Comment

1.UYGULAMA
1.1 To create awr reports using command line.
• We need to connect OS to Oracle user.
• We need to enter spesific directory where some oracle basic scripts are avaliable “cd $ORACLE_HOME/rdbms/admin/” .
• Now time to connect sqlplus  “sqlplus / as sysdba” .
• And now we need to execute awr script “@$ORACLE_HOME/rdbms/admin/awrrpt.sql” .
[Read more…]