oracledba.blogspot.com
Oracle DBA PlaceA blog about Oracle database on Linux environment
http://oracledba.blogspot.com/
A blog about Oracle database on Linux environment
http://oracledba.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Wednesday
LOAD TIME
1.3 seconds
16x16
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
0
SITE IP
172.217.11.33
LOAD TIME
1.313 sec
SCORE
6.2
Oracle DBA Place | oracledba.blogspot.com Reviews
https://oracledba.blogspot.com
A blog about Oracle database on Linux environment
oracledba.blogspot.com
Oracle DBA Place: Data Pump, the unix command line
https://oracledba.blogspot.com/2012/05/data-pump-import-as-sysdba-and-several.html
Wednesday, May 16, 2012. Data Pump, the unix command line. Data Pump import as sysdba and several indexes, the unix way . Impdp "'sys/dba as sysdba'" schemas=SCOTT INCLUDE=INDEX: "in ( 'PK DEPT ', 'EMPIDX ' ) " directory=TMP DIR dumpfile=scott.dmp job name=importing scott.log. Subscribe to: Post Comments (Atom). Fixing and Registering ORACLE HOMES in Central Inventory. SQL Tuning Advisor - The commands. All about ORA-600 lookup tool. RDA - Health Check (HCVE). Importing just 1 view via impdp. Background:...
Oracle DBA Place: Undelete Files in Linux
https://oracledba.blogspot.com/2013/01/undelete-files-in-linux.html
Thursday, January 24, 2013. Undelete Files in Linux. Usually I take care for backups, but the first time I tempted to neglect this habit - I just have met Morphy's law :(. Fortunately there is a solution:. To recover files simply type:. And follow the instructions. It is very good blog.I am also looking for this from a long time.Many people like to visit here.I have seen many things over here.It is very good. March 20, 2013 at 11:20 AM. Subscribe to: Post Comments (Atom). SQL Tuning Advisor - The commands.
Oracle DBA Place: February 2012
https://oracledba.blogspot.com/2012_02_01_archive.html
Tuesday, February 28, 2012. All about ORA-600 lookup tool. ORA-600/ORA-7445 are generic internal error numbers for Oracle program exceptions. Sometimes these errors are unique for your specific. Problem and cannot be found via search engines. Using "ORA-600 lookup tool" may point your specific problem, faster and accurate. The tool can be found in ORA-600 lookup tool. Metalink Document ID 153788.1. The flowing video will guide you the usage of the LookUp Tool. 11:12) - Metalink Document ID 1082674.1.
Oracle DBA Place: December 2012
https://oracledba.blogspot.com/2012_12_01_archive.html
Monday, December 03, 2012. Format scripts in awk, csh, ksh, perl, sh. I am used to relay on tools for formatting and indenting SQL or PL/SQL code. Looking for the same for linux scripts (especially bash) I found the following code. Fixing and Registering ORACLE HOMES in Central Inventory. Central Inventory location is determined by oraInst.loc located in: HP/Solaris /var/opt/oracle/oraInst.loc Linux /etc/oraInst.loc Windows . SQL Tuning Advisor - The commands. All about ORA-600 lookup tool. Background: U...
Oracle DBA Place: April 2011
https://oracledba.blogspot.com/2011_04_01_archive.html
Monday, April 11, 2011. Block Recovery using RMAN – on Oracle 11g. The purpose of this article is to simulate a block level corruption using BBED utility (block browser and editor) and recover using RMAN. In this situation the data file remains online throughout the recovery operation and hence other segments within the tablespace remain accessible. Since BBED exists from Oracle7 to Oracle10g, we will have to copy some files from earlier version and compile it. Message files (list may differ):. File: /u0...
TOTAL PAGES IN THIS WEBSITE
19
oracledba-valentin.blogspot.com
oracle apps dba
Четверг, 2 декабря 2010 г. Way to connect to APPS or how to bypass default Login screen. Вторник, 9 ноября 2010 г. FAILED: file FNDNLINS.sql on worker 1 for product fnd username APPLSYS. If you use ADADMIN utility and get ERROR. FAILED: file FNDNLINS.sql on worker 1 for product fnd username APPLSYS. PACKAGE=FND LOOKUP VALUES PKG. SQLERRM=ORA-00001: unique constraint(APPLSYS.FND LOOKUP VALUES U2) violated. Redwood Shores, California, USA. Version 11.5.0. Review the README for pre-requisite information.
Oracle DBA Videos
This blog presents Oracle DBA Videos.An Audio visual Demo of some of the operations a DBA encounters in his day to day life. All the videos in this blog are High Definition Videos most with Audio. The videos are best watched in full screen with "HD option enabled". You would also find screenshots and some handy scripts for DBAs. Wednesday, November 22, 2017. This video gives an introduction to Oracle Database patches. Posted by Ritesh Das. Links to this post. Labels: oracle database patches. The current ...
Oracle Database Administration
Thursday, August 1, 2013. What is a Latch. Oracle SGA consists of numerous data structures such as Buffer Cache, Shared pool, Library cache, Dictionary cache, redo log buffer etc. Many oracle processes need to access these SGA data structures concurrently. Though these SGA components are shared, only one process must be able to modify it at any particular point in time. Oracle achieves this by protecting the SGA data structures with latches. When do Oracle Process obtain a latch? A process acquires a lat...
SQL & PL/SQL :: Reorder The Rows Based On 3 Parameters
SQL and PL/SQL : Reorder The Rows Based On 3 Parameters. Aug 29, 2012. I have a requirement (procedure) to reorder the rows based on 3 parameters. My table looks like:. 1st parameter will be EMPID, 2nd parameter is orderID's (any combination comma separated) and 3rd is Position after. Ie proc call will be like REORDER(101, '1,3', 4);. So that, 1,3 should come after 4th position and everything should get reorder. CREATE TABLE TEST TABLE(EMPID NUMBER, ORDERID NUMBER, ENAME VARCHAR2(20) ;. SQL and PL/SQL : ...
Oracle DBA Place
Skip to main content. Subscribe to this blog. Extract Data Guard Commands on Oracle 12.2. February 08, 2018. Hi, These days I am starting to work on Oracle 12.2, leaving behind the old versions. Since my main domain is Oracle Data Guard, I posted a blog about Oracle 12c Release 2 New Features for Active Data Guard. One of a big new feature I missed is that the internal Data Guard broker configuration was changed dramatically on 12.2. Last week, I tried to Extract Data Guard Commands. January 29, 2018.
www.oracledba.co.uk
This web page uses frames, but your browser doesn't support them.
2Com Consulting
Atender as necessidades de nossos clientes, suprindo as expectativas através da qualidade e bom atendimento. Atuamos em diversos segmentos do mercado e estamos prontos para atender as demandas de TI de sua empresa. Nossos especialistas analisam e recomendam os melhores serviços e investimentos. Armazenamento de informações online é uma maneira simples e segura para fazer o backup de todos os dados contidos nos servidores de sua empresa. Permite a rápida coleta de dados, com mais eficiência e precisão....
Oracle DBA
Přehled pozic v oblasti databázový adminitrátor (DBA) www.databazovy-administrator.cz. Http:/ docs.oracle.com/cd/B10501 01/server.920/a96521/dba.htm. The job of the DBA seems to be everything that everyone else either doesn't want to do, or doesn't have the ability to do. DBAs get the enviable task of figuring out all of the things no one else can figure out. More seriously though, here is a list of typical DBA responsibilities:. Evaluate Oracle features and Oracle related products. Ability to perform bo...
OracleDBAExpert.com: Oracle DBA and Web Development Consulting
Internet Marketing for Independent Musicians. Subscribe to Internet Marketing for Musicians by EZPowell. Subscribe to Internet Marketing for Musicians by Email. My Creative Writing Blog. The EZPowell Band: Bedroom Eyes (Amazon) (Nov 2006). Bedroom Eyes CD (Nov 2006). EZPowell's Radio Station Air-Play (Nov 2006). Database Modeling from 0 to 60 in 4 Seconds (Jan 2011). Oracle Enterprise Linux Administrator Certified Associate Exam Guide (Exams 1Z0-402 and 1Z0-403) (May 2009). Access 2007 Bible (Jan 2007).
Oracle Database Administration
Oracle on/and UNIX Reference…. How to Apply Oracle Patch 9974223 (Multicast) for 11.2.0.2 Oracle Clustered Grid Infrasture home? November 22, 2011. Tags: 11.2.0.2 grid infrastructure. 11202 real application cluster Installation. How to apply patch 9974223. Root script failed on second node. How to Apply Oracle Patch 9974223 (Multicast) for 11.2.0.2 Oracle Clustered Grid Infrasture home? Why you need to apply this patch? Some relevant information for my demonstration:. Create a directory /. 7 Now security...
