Bugra Canbakal's Oracle Blog

  • Home
  • Contact
  • SITE MAP
You are here: Home / 2010 / Archives for June 2010

Archives for June 2010

User Schemasının index yapısını çıkartmak

12:40 PM By Bugra Canbakal Leave a Comment

1.AMAÇ VE KAPSAM

Bir user schemasının butun ozellikleriyle index yapisini cikartmaya yarar.

2.UYGULAMA

2.1 Sqlscriptimizi yaratiyoruz.

vi /home/oracle/Desktop/olanindexlerigoster.sql
[Read more…]

Share this:

  • LinkedIn
  • Twitter

Filed Under: Oracle Tagged With: schema index, table index, user schema

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

05:41 AM By Bugra Canbakal 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.

 

Oracle PL/SQL
1
2
3
4
5
6
7
8
9
10
11
12
13
# 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

Oracle PL/SQL
1
2
#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.

Oracle PL/SQL
1
#export ORACLE_SID=+ASM

 

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

Oracle PL/SQL
1
2
3
4
5
6
7
8
9
10
11
12
13
# 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

Oracle PL/SQL
1
2
#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.

Oracle PL/SQL
1
2
echo $ORA_CRS_HOME
/u01/oracle/product/crs/

 

2.3.2 And we can reach Cluster logs with this command

Oracle PL/SQL
1
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.

Oracle PL/SQL
1
vi /var/log/dmesg

 

or

Oracle PL/SQL
1
dmesg | less

 

[Read more…]

Share this:

  • LinkedIn
  • Twitter

Filed Under: Oracle Tagged With: alert log, asm alert log, cluster alert log, os alert log, os log, sistem alert log

Creating AWR report using command line

08:47 PM By Bugra Canbakal 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…]

Share this:

  • LinkedIn
  • Twitter

Filed Under: Oracle Tagged With: awr, awr report

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.