oradbatips.blogspot.com
Oracle DBA tipsOracle Adminstration tips
http://oradbatips.blogspot.com/
Oracle Adminstration tips
http://oradbatips.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Sunday
LOAD TIME
0.3 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
20
SSL
EXTERNAL LINKS
115
SITE IP
172.217.11.33
LOAD TIME
0.344 sec
SCORE
6.2
Oracle DBA tips | oradbatips.blogspot.com Reviews
https://oradbatips.blogspot.com
Oracle Adminstration tips
oradbatips.blogspot.com
Oracle DBA tips: TIP 116# : Oracle Database Appliance - 3 Observations and 3 Resolutions
http://oradbatips.blogspot.com/2015/03/oracle-database-appliance-observations.html
TIP 116# : Oracle Database Appliance - 3 Observations and 3 Resolutions. During last couple weeks, I have been involved in various ODA activities from patching of an existing ODA to latest version to setting up new environments on ODA X5-2. I thought to share some lesson learnt :. If you encounter in a situation which ODA patch fails and reports the following error. Unable to get the nodenumber in the chassis. The resolution is to. Create /opt/oracle/oak/conf/node num.conf. 3) Some oakcli commands fail.
Oracle DBA tips: November 2012
http://oradbatips.blogspot.com/2012_11_01_archive.html
TIP 103# : GoldenGate and statistics. After having GoldenGate setup in your environment, the main question you most likely face is whether or not GoldenGate is working and if so, how much work is done. GoldenGate provides stats command to report the work which is done, the following present how to use it properly and effectively. To get stats from now on wards, follow the below steps :. Hope this helps for those who may find numbers misleading/incorrect. Subscribe to: Posts (Atom). Ottawa, Ontario, Canada.
Oracle DBA tips: December 2012
http://oradbatips.blogspot.com/2012_12_01_archive.html
TIP 104#: Node Eviction in RAC 11gr2 due to temporary network hiccups on heartbeat communication. In next couple months, I will examine different eviction scenarios in RAC 11gR2 and when I see some strange behavior, I will do my best to inform it in this blog, so RAC lover, please stay tuned and here is the scenario number 1 :. AS you know, in 11gR2, oracle uses UDP protocol for heartbeats between the nodes. The test is done on two node RAC in 11.2.0.3PSU3 version on Linux. To break heartbeat communicati...
Oracle DBA tips: March 2015
http://oradbatips.blogspot.com/2015_03_01_archive.html
TIP 116# : Oracle Database Appliance - 3 Observations and 3 Resolutions. During last couple weeks, I have been involved in various ODA activities from patching of an existing ODA to latest version to setting up new environments on ODA X5-2. I thought to share some lesson learnt :. If you encounter in a situation which ODA patch fails and reports the following error. Unable to get the nodenumber in the chassis. The resolution is to. Create /opt/oracle/oak/conf/node num.conf. 3) Some oakcli commands fail.
Oracle DBA tips: TIP #65 : 10g listener.
http://oradbatips.blogspot.com/2007/11/tip-65-10g-listener.html
TIP #65 : 10g listener. Today, a client came up with a question on whether or not password protected listener is safer than non-password protected listener in 10g. To answer, In Oracle 10g, listener is secure by itself and there is no need to set a password for listener as in older version to protect listener. By default, listener uses local OS authentication. Which means that only the user who owned listener can admin it. This feature is enabled by default. STATUS of the LISTENER. STATUS of the LISTENER.
TOTAL PAGES IN THIS WEBSITE
20
Sfaturi Oracle / Tips and tricks OracleDBA: migrate table data from oracle to sql server
http://oradbastuff.blogspot.com/2015/06/migrate-table-data-from-oracle-to-sql.html
Sfaturi Oracle / Tips and tricks OracleDBA. You've got to have a dream. When you lose your dreams, you die. Migrate table data from oracle to sql server. Sqlinesdata30 http:/ www.sqlines.com/. Abonați-vă la: Postare comentarii (Atom). Oracle RMAN tool backup. Primul post pe blogul Sfaturi Oracle. Recover sa microsoft sqlserver. How to export import using oracle datapump externa. Migrate table data from oracle to sql server. Vizualizați profilul meu complet. Lista mea de bloguri. In Part I, we looked at h...
One more Oracle DBA: Transporatable Tablesapces
http://kris-oradba.blogspot.com/2008/04/transporatable-tablesapces.html
One more Oracle DBA. Thursday, April 17, 2008. For the last 10 days, I have spent a great amount of time doing R&D on TTS, reading Metalink articles, whitepapers and oracle docs. I have compiled some notes extracting information from all these docs so that I can use it as reference. The transportable tablespace mechanism consists in the combination of 2 things:. An export of the metadata (instead of the data) of a tablespace. A copy of the files belonging to the tablespace. These 2 parts can then be tran...
One more Oracle DBA: 2008-02-17
http://kris-oradba.blogspot.com/2008_02_17_archive.html
One more Oracle DBA. Monday, February 18, 2008. We sync four of our System Testing DBs with Prod DBs data once in two months. I have come up witht he below notes based on my experience and also from the notes I have collected from various sites and forums. Change DB to No Archive Log Mode. Create large redo log files and drop existing redo logs. ( 2gb each or more.). Increase the size of LOG BUFFERS, DB CACHE SIZE considerably in the init$SID.ora file. Create a large Undo tablespace. Doc ID: Note:93763&#...
Oracle DBA | Center Point for Oracle DBA & Kuwait Info
https://mubeenmd.wordpress.com/2010/04/28/oracle-dba-blogs
Center Point for Oracle DBA and Kuwait Info. Oracle Database Administrator’s Guide 11g Release 2. The Tom Kyte blog. Inside the Oracle Optimizer. Tanel Poder’s blog. DBA scripts and procedures. Ixora – oracle internals. Oracle blogs – home page. Oracle Scratchpad – Jonathan levis. Hemant’s Oracle DBA Blog. Ronny Egner’s blog. Akadia – scripts, tips, articles. Database Performance and Scalability blog. Oracle database internals by Riyaz. Simple DBA on complex system. The Arup Nanda blog.
One more Oracle DBA: ORA-12801 ORA-01114 ORA-27072 and Linux Error: 25
http://kris-oradba.blogspot.com/2008/05/ora-12801-ora-01114-ora-27072-and-linux.html
One more Oracle DBA. Monday, May 12, 2008. ORA-12801 ORA-01114 ORA-27072 and Linux Error: 25. We have recently experienced below issue while running some long running recon scripts. These scripts demand about 70 GB of temp space and failed with below error after running for 1.5 hours. Javasql.SQLException: ORA-12801: error signaled in parallel query server P011. ORA-01114: IO error writing block to file 1004 (block # 413969). ORA-27072: skgfdisp: I/O error. Linux Error: 25: Inappropriate ioctl for device.
One more Oracle DBA: 2008-05-11
http://kris-oradba.blogspot.com/2008_05_11_archive.html
One more Oracle DBA. Monday, May 12, 2008. ORA-12801 ORA-01114 ORA-27072 and Linux Error: 25. We have recently experienced below issue while running some long running recon scripts. These scripts demand about 70 GB of temp space and failed with below error after running for 1.5 hours. Javasql.SQLException: ORA-12801: error signaled in parallel query server P011. ORA-01114: IO error writing block to file 1004 (block # 413969). ORA-27072: skgfdisp: I/O error. Linux Error: 25: Inappropriate ioctl for device.
lukestipsandtricks.blogspot.com
Luke's Tips and Tricks: March 2010
http://lukestipsandtricks.blogspot.com/2010_03_01_archive.html
Luke's Tips and Tricks. Wednesday, March 31, 2010. To find out which events you have set in your 10g oracle database use the following from SQL*Plus when connected as sysdba. Oradebug setmypid oradebug dump events 4. Find the trace file in the user dump destination and it will contain something like this. Here we have set event 10298 at level 32 like so. Alter system set events '10298 trace name context forever, level 32';. To do the same in 11g use the following. Subscribe to: Posts (Atom).
lukestipsandtricks.blogspot.com
Luke's Tips and Tricks: How to disable the DBMS_SCHEDULER
http://lukestipsandtricks.blogspot.com/2010/04/how-to-disable-dbmsscheduler.html
Luke's Tips and Tricks. Wednesday, April 28, 2010. How to disable the DBMS SCHEDULER. I discovered this after searching all over the web and am putting it here so that I do not have to do that again. To turn the scheduler off use. Exec dbms scheduler.set scheduler attribute('SCHEDULER DISABLED', 'TRUE'). Note that the TRUE is not a BOOLEAN but text. To check the status. Select * from DBA SCHEDULER GLOBAL ATTRIBUTE;. To turn the scheduler back on again. February 12, 2016 at 7:05 AM. Thanks, you are a star.
TOTAL LINKS TO THIS WEBSITE
115
Sfaturi Oracle / Tips and tricks OracleDBA
Sfaturi Oracle / Tips and tricks OracleDBA. You've got to have a dream. When you lose your dreams, you die. 8222;Învăţaţi, mamă, că o să plecaţi la casele voastre, şi-o să creşteţi copii şi o să trăiţi şi voi în lume printre oameni şi să vă aveţi bine cu ei". Asta e adevărata tragedie a României generației noastre. Nu așa-zisa "persecuție" a miliardarilor și a politicienilor cu televizoare la butonieră. Sau cine știe ce alte tembelisme bune de amețit poporul. Asta e, asta e țara noastră:. Vă știu pe unii...
Oracle DBA tips
TIP 119 - Why some ODA commands hang? If you are an ODA customer and you see that "oakcli show version -detail" hangs or some patch command does run forever with no output, I think you might need to make sure .bash profile is not customized for user input. Please see below :. Oakcli Commands All Hang, Do Not Complete (Doc ID 1981186.1). Lesson learned - Do not change .bash profile in ODA. TIP 118# : Virtualized Exadata-Adding new local disk to DomU. Here is the first post :. Xvda 202:0 0 25G 0 disk.
Oracle Tips Tricks
Necessary Little Things Every DBA should know. Saturday, August 29, 2009. SET SQLPROMPT 'MYNAME '. It can be set dynamically by adding code to a login.sql file in the executable path. This is what I use:. Http:/ www.oracle-base.com/dba/miscellaneous/login.sql. This script is only called at connect time in 10g, or startup time in 9i, so it's not dynamic, like when the statement has run. If you wnt the time in addition to your custom SQLPROMPT you need to do this:. How to find the tablespace of a table?
ORADBCA | 百尺竿头更进一步
2017 年 9 月 22 日. Wri$ optstat tab history. Wri$ optstat ind history. Wri$ optstat histhead history. Wri$ optstat histgrm history. Slow Statistics purging (SYSAUX grows). Bug 14373728 – Old statistics not purged from SYSAUX tablespace. Improvements to archived statistics purging / SYSAUX tablespace grows. For i in reverse 10.100. Dbms stats.purge stats(sysdate-i);. Exec DBMS STATS.PURGE STATS(DBMS STATS.PURGE ALL). 2017 年 3 月 30 日. RMAN-06820 During Backup at dataguard. 2016 年 3 月 15 日. 2015 年 9 月 15 日.
Hébergement, enregistrement de nom de domaine et services internet par 1&1 Internet
CE NOM DE DOMAINE VIENT D'ÊTRE ENREGISTRÉ POUR L'UN DE NOS CLIENTS. Avez-vous besoin, vous aussi, d'une VRAIE solution d'hébergement VRAIMENT accessible? Vous propose les solutions les moins chères du Net pour réaliser votre site web en toute simplicité, que vous soyez débutant ou expérimenté. Des solutions d'hébergement complètes. Une large gamme de logiciels offerts. Un espace de configuration intuitif. Une assistance technique efficace. Aucun engagement de durée. Garantie satisfait ou remboursé.
SOCIAL ENGAGEMENT