Free Essay

Oracle

In:

Submitted By maria1986
Words 1320
Pages 6
Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6
This article describes the installation of Oracle Database 11g Release 2 (11.2) (64-bit) on Oracle Linux 6 (64-bit). The article is based on a server installation with a minimum of 2G swap, with both SELinux and the firewall disabled. The following package groups were included for this installation. * Base System * Base * Debugging Tools * Directory Client * Hardware monitoring Client * Large Systems Performance * Network file system client * Performance Tools * Perl Support * Servers * Server Platform * System administration tools * Desktops * Desktop * Desktop Platform * Fonts * General Purpose Desktop * Graphical Administration Tools * X Windows System * Applications * Internet Browser * Development * Development Tools
An example of this type of Linux installations can be seen here. Alternative installations may require more packages to be loaded, in addition to the ones listed below.
Note. At the time of writing Oracle have not certified any of their database products on OL6 or RHEL6, so you shouldn't use these operating systems for anything important until the certification is complete. * Download Software * Unpack Files * Hosts File * Set Kernel Parameters * Setup * Installation * Post Installation
Download Software
Download the Oracle software from OTN or MOS depending on your support status. * OTN: Oracle Database 11g Release 2 (11.2.0.1) Software (64-bit) * MOS: Oracle Database 11g Release 2 (11.2.0.2) Software (64-bit)
Unpack Files
Unzip the files.
-------------------------------------------------
# 11.2.0.1
-------------------------------------------------
unzip linux.x64_11gR2_database_1of2.zip
-------------------------------------------------
unzip linux.x64_11gR2_database_2of2.zip
-------------------------------------------------

------------------------------------------------- #11.2.0.2
-------------------------------------------------
unzip p10098816_112020_Linux-x86-64_1of7.zip
-------------------------------------------------
unzip p10098816_112020_Linux-x86-64_2of7.zip
You should now have a single directory called "database" containing installation files.
Hosts File
The "/etc/hosts" file must contain a fully qualified name for the server. (with Root)
-------------------------------------------------
<IP-address> <fully-qualified-machine-name> <machine-name>
For example.
-------------------------------------------------
127.0.0.1 localhost.localdomain localhost
-------------------------------------------------
192.168.0.181 ol6-112.localdomain ol6-112
Set Kernel Parameters
Oracle recommend the following minimum parameter settings.
-------------------------------------------------
fs.suid_dumpable = 1
-------------------------------------------------
fs.aio-max-nr = 1048576
-------------------------------------------------
fs.file-max = 6815744
-------------------------------------------------
kernel.shmall = 2097152
-------------------------------------------------
kernel.shmmax = 536870912
-------------------------------------------------
kernel.shmmni = 4096
-------------------------------------------------
kernel.sem = 250 32000 100 128
-------------------------------------------------
net.ipv4.ip_local_port_range = 9000 65500
-------------------------------------------------
net.core.rmem_default = 262144
-------------------------------------------------
net.core.rmem_max = 4194304
-------------------------------------------------
net.core.wmem_default = 262144
-------------------------------------------------
net.core.wmem_max = 1048586
The current values can be tested using the following command.
-------------------------------------------------
/sbin/sysctl -a | grep <param-name>
Add or amend the following lines in the "/etc/sysctl.conf" file.
-------------------------------------------------
fs.suid_dumpable = 1
-------------------------------------------------
fs.aio-max-nr = 1048576
-------------------------------------------------
fs.file-max = 6815744
-------------------------------------------------
kernel.shmall = 2097152
-------------------------------------------------
kernel.shmmax = 536870912
-------------------------------------------------
kernel.shmmni = 4096
-------------------------------------------------
# semaphores: semmsl, semmns, semopm, semmni
-------------------------------------------------
kernel.sem = 250 32000 100 128
-------------------------------------------------
net.ipv4.ip_local_port_range = 9000 65500
-------------------------------------------------
net.core.rmem_default=4194304
-------------------------------------------------
net.core.rmem_max=4194304
-------------------------------------------------
net.core.wmem_default=262144
-------------------------------------------------
net.core.wmem_max=1048586
Run the following command to change the current kernel parameters.
-------------------------------------------------
/sbin/sysctl -p
Add the following lines to the "/etc/security/limits.conf" file.
-------------------------------------------------
oracle soft nproc 2047
-------------------------------------------------
oracle hard nproc 16384
-------------------------------------------------
oracle soft nofile 1024
-------------------------------------------------
oracle hard nofile 65536
-------------------------------------------------
oracle soft tack 10240
Disable secure linux by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.
-------------------------------------------------
SELINUX=disabled
Once the change is complete, restart the server.
Setup
Install the following packages if they are not already present.
-------------------------------------------------
# From Oracle Linux 6 DVD
-------------------------------------------------
cd /media/cdrom/Server/Packages
-------------------------------------------------
rpm -Uvh binutils-2*x86_64*
-------------------------------------------------
rpm -Uvh glibc-2*x86_64* nss-softokn-freebl-3*x86_64*
-------------------------------------------------
rpm -Uvh glibc-2*i686* nss-softokn-freebl-3*i686*
-------------------------------------------------
rpm -Uvh compat-libstdc++-33*x86_64*
-------------------------------------------------
rpm -Uvh glibc-common-2*x86_64*
-------------------------------------------------
rpm -Uvh glibc-devel-2*x86_64*
-------------------------------------------------
rpm -Uvh glibc-devel-2*i686*
-------------------------------------------------
rpm -Uvh glibc-headers-2*x86_64*
-------------------------------------------------
rpm -Uvh elfutils-libelf-0*x86_64*
-------------------------------------------------
rpm -Uvh elfutils-libelf-devel-0*x86_64*
-------------------------------------------------
rpm -Uvh gcc-4*x86_64*
-------------------------------------------------
rpm -Uvh gcc-c++-4*x86_64*
-------------------------------------------------
rpm -Uvh ksh-*x86_64*
-------------------------------------------------
rpm -Uvh libaio-0*x86_64*
-------------------------------------------------
rpm -Uvh libaio-devel-0*x86_64*
-------------------------------------------------
rpm -Uvh libaio-0*i686*
-------------------------------------------------
rpm -Uvh libaio-devel-0*i686*
-------------------------------------------------
rpm -Uvh libgcc-4*x86_64*
-------------------------------------------------
rpm -Uvh libgcc-4*i686*
-------------------------------------------------
rpm -Uvh libstdc++-4*x86_64*
-------------------------------------------------
rpm -Uvh libstdc++-4*i686*
-------------------------------------------------
rpm -Uvh libstdc++-devel-4*x86_64*
-------------------------------------------------
rpm -Uvh make-3.81*x86_64*
-------------------------------------------------
rpm -Uvh numactl-devel-2*x86_64*
-------------------------------------------------
rpm -Uvh sysstat-9*x86_64*
-------------------------------------------------
rpm -Uvh compat-libstdc++-33*i686*
-------------------------------------------------
cd /
-------------------------------------------------
eject
Note. This will install all the necessary 32-bit packages for 11.2.0.1. From 11.2.0.2 onwards many of these are unnecessary, but hing them present does not cause a problem.
Create the new groups and users. (Guardado no ficheiro /etc/group)
-------------------------------------------------
groupadd -g 501 oinstall
-------------------------------------------------
groupadd -g 502 dba
-------------------------------------------------
groupadd -g 503 oper
-------------------------------------------------
groupadd -g 504 asmadmin
-------------------------------------------------
groupadd -g 506 asmdba
-------------------------------------------------
groupadd -g 505 asmoper
-------------------------------------------------

------------------------------------------------- useradd -u 502 -g oinstall -G dba,asmdba,oper oracle
-------------------------------------------------

------------------------------------------------- passwd oracle
Note. We are not going to use the "asm" groups, since this installation will not use ASM.
Create the directories in which the Oracle software will be installed.
-------------------------------------------------
mkdir -p /u01/app/oracle/product/11.2.0/db_1
-------------------------------------------------
chown -R oracle:oinstall /u01
-------------------------------------------------
chmod -R 775 /u01
NB:
* Para ver grupos de um determinado usuário:

id <user>

* Para adicionar usuário existente a um novo grupo (suplementar): Usermod –a -G <new group> <user>
Para modificar grupo (primário) de um usuário Usermod -g <primary group> <user>
Login as root and issue the following command.
-------------------------------------------------
xhost +<machine-name>
Login as the oracle user and add the following lines at the end of the ".bash_profile" file. # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH export ORACLE_HOSTNAME=nosidev01.gov.cv export ORACLE_BASE=/u01/app/oracle export ORACLE_SID=nosidev export ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1 export PATH=$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib

------------------------------------------------- # Oracle Settings
-------------------------------------------------
TMP=/tmp; export TMP
-------------------------------------------------
TMPDIR=$TMP; export TMPDIR
-------------------------------------------------

------------------------------------------------- ORACLE_HOSTNAME=ol6-112.localdomain; export ORACLE_HOSTNAME
-------------------------------------------------
ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
-------------------------------------------------
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
-------------------------------------------------
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
-------------------------------------------------
ORACLE_SID=DB11G; export ORACLE_SID
-------------------------------------------------

------------------------------------------------- PATH=/usr/sbin:$PATH; export PATH
-------------------------------------------------
PATH=$ORACLE_HOME/bin:$PATH; export PATH
-------------------------------------------------

------------------------------------------------- LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
-------------------------------------------------
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
Installation
Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.
-------------------------------------------------
DISPLAY=<machine-name>:0.0; export DISPLAY (IMPORTANT !!!)
Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.
-------------------------------------------------
./runInstaller
Proceed with the installation of your choice. The prerequisites checks will fail for the following version-dependent reasons: * 11.2.0.1: The installer shows multiple "missing package" failures because it does not recognize several of the newer version packages that were installed. These "missing package" failures can be ignored as the packages are present. The failure for the "pdksh" package can be ignored because we installed the "ksh" package in its place. * 11.2.0.2: The installer should only show a single "missing package" failure for the "pdksh" package. It can be ignored because we installed the "ksh" package in its place.
You can see the installation I performed by clicking on the links below to see screen shots of each stage. 1. Configure Security Updates 2. Select Install Option 3. System Class 4. Node Selection 5. Select Install Type 6. Typical Install Configuration 7. Create Inventory 8. Perform Prerequisite Checks 9. Summary 10. Install Product 11. Database Configuration Assistant 12. Database Configuration Assistant 2 13. Execute Configuration Scripts 14. Finish
Post Installation
Edit the "/etc/oratab" file setting the restart flag for each instance to 'Y'.
-------------------------------------------------
DB11G:/u01/app/oracle/product/11.2.0/db_1:Y

NB: o ficheiro /et/oratab é criado com a execução do script <ORACLE_HOME>/root.sh antes de se iniciar a criação da BD.
Serve para indicar quais as instancias a serem levantadas automaticamente usando o script “dbstart” com o reebot da máquina.

Similar Documents

Free Essay

Oracle

...The History of Oracle | Founded in August 1977 by Larry Ellison, Bob Miner, Ed Oates and Bruce Scott, Oracle was initially named after "Project Oracle" a project for one of their clients, the C.I.A, and the company that developed Oracle was dubbed "Systems Development Labs", or SDL.   Although they may not have realized it at the time, these four men would change the history of database management forever. In 1978 SDL was renamed Relational Software Inc (RSI) to market their new database.  1979 - Oracle release 2 The first commercial RDBMS was built using PDP-11 assembler language. Although they created a commercial version of RDBMS in 1977, it wasn't available for sale until 1979 with the launch of Oracle version 2. The company decided against starting with version 1 because they were afraid that the term "version 1" might be viewed negatively in the marketplace.  USA Air Force and then CIA were the first customers to use Oracle 2. In 1982 there was another change of the company’s name, from RSI to Oracle Systems Corporation so as to match its popular database name.  The current company name comes from a CIA project that Larry Ellison had previously worked on code named Oracle. 1983 - Oracle release 3 The Oracle version 3 was developed in 1983. This version was assembled using C programming language and could run in mainframes, minicomputers, and PCs or any hardware with a C compiler. It supported the execution of SQL statements and transactions. This version also included...

Words: 1424 - Pages: 6

Free Essay

Oracle

...COMPANY PROFILE Oracle Corporation REFERENCE CODE: C0CB6D9E-4EFE-4621-B998-73B241B46317 PUBLICATION DATE: 23 May 2014 www.marketline.com COPYRIGHT MARKETLINE. THIS CONTENT IS A LICENSED PRODUCT AND IS NOT TO BE PHOTOCOPIED OR DISTRIBUTED. Oracle Corporation TABLE OF CONTENTS TABLE OF CONTENTS Company Overview..............................................................................................3 Key Facts...............................................................................................................3 SWOT Analysis.....................................................................................................4 Oracle Corporation © MarketLine Page 2 Oracle Corporation Company Overview COMPANY OVERVIEW Oracle Corporation (Oracle or “the company”) is a provider of enterprise software, computer hardware products and services. The company operates in more than 145 countries across the world. Oracle is headquartered in Redwood Shores, California and employed 120,000 people as of May 31, 2013. The company recorded revenues of $37,180 million during the financial year ended May 2013 (FY2013), an increase of 0.2% over FY2012. The increase in revenues was due to an increase in Oracle’s software business revenues. The operating profit of the company was $14,684 million in FY2013, an increase of 7.1% over FY2012. The net profit was $10,925 million in FY2013, an increase of 9.5% over FY2012. KEY FACTS Head Office Oracle Corporation 500...

Words: 3160 - Pages: 13

Free Essay

Oracle Rac

...A white paper prepared with Oracle and IBM technical collaboration March 2010 Oracle Real Application Clusters on IBM AIX Best practices in memory tuning and configuring for system stability Oracle White Paper — Oracle Real Application Clusters on IBM AIX - Best practices for system stability Executive Overview ........................................................................... 2 Introduction ....................................................................................... 2 Problem validation ......................................................................... 3 Examining the AIX Error Logging................................................... 3 Examining the Oracle oprocd logging ............................................ 4 Recommendations for system stability............................................... 5 1. Implement AIX tuning recommendations for Oracle ................... 5 2. Modify Oracle ‘diagwait’ parameter............................................ 6 3. Install the required updates and patches ................................... 8 4. Reduce heavy paging activity. ................................................. 11 Appendix A: Oprocd logging examples ............................................ 14 Clean oprocd log files .................................................................. 14 Oprocd log files showing scheduling delays................................. 14 Oprocd log files after a node reboot or CRS restart .................

Words: 4075 - Pages: 17

Free Essay

Dell and Oracle

...Oracle Corporation It’s a huge company that provides enterprise software and computer hardware products and services. It develops, manufactures, markets, hosts, and supports database and middleware software, applications software, and hardware systems. It is organized into three businesses: software, hardware systems and services. Its software business consists of two segments: new software licenses and software license updates and product support. It’s hardware systems business consists of two segments: hardware systems products and hardware systems support. It authorizes database and middleware software, including database and database management, application server and cloud application, service-oriented architecture and business process management, business intelligence, identity and access management, data integration, Web experience management, portals, and content management and social network software, as well as development tools and Java, a software development platform; and applications software comprising enterprise resource planning, customer relationship management, financials, governance, risk and compliance, procurement, supply chain management, enterprise portfolio project and enterprise performance management, business intelligence analytic applications, Web commerce, and industry-specific applications software. It also provides customers with rights to unspecified software product upgrades and maintenance releases; Internet access to technical content; and...

Words: 2530 - Pages: 11

Free Essay

Oracle Database

...types of bases to get the job done. The one database used more by logistics personnel is the Oracle Discoverer Plus database. In this paper will discuss what is Discoverer Plus, we will breakdown some of its function areas like End User layer (EUL), Business Area, and Folders. We will discuss some feature of Discoverer Plus database, and last, we will provide the dated problems of Discoverer’s Plus database. Discoverer Plus is one of five parts of the Air Force Supply Central Database (AFSCD). According to AFM 23-110 “Discoverer Plus is an oracle database that provides supply technician and analyst with a user friendly ad hoc data retrieval tool. It gives the user capability of retrieving, organizing, and displaying data when they want it, in the way they want it” (USAF 2009). Discoverer Plus also gives user the choice of creating their own queries from scratch with the help of a friendly wizard. In addition a number of standard ad hoc queries are provided to each user under their user-ids. Although standard ad hoc queries contain a predefined set of data, they also have flexibility of applying conditions, change sort order, and modifying the display. Discoverer Plus is also invaluable to Air Staff, Headquarter, and supply managers as it help makes important decisions with the deep-rooted analytical function. EUL is a part of Discoverer Plus, it is a layer of information used by Oracle Discoverer to hide the complexities and details of the underlying database. EUL provides a...

Words: 624 - Pages: 3

Free Essay

Oracle 10g Forms

...Oracle Forms 10g : Demos, Tips and Techniques Oracle Forms 10g release 2 : Demos, Tips and Techniques Home page 1. Introduction Here is a collection of Oracle Forms 10g sample dialogs extracted from a complete Oracle Forms tutorial. This tutorial has been written in French and it would be too time consuming to translate it all in English. This is the reason why I have only extracted and translated these sample dialogs. The purpose of this article is not to teach how to build a new form from scratch. It intends to show some of the main advanced features of the product. To clearly understand in details how these dialogs work, you will have to open them in the Forms Builder and examine them thoroughly. However, in this article, I am going to explain the best I can the most important mechanisms of each sample. These sample have been tested with an Oracle Forms 10g release 10.1.2.0.2 on an Oracle Database 10g Express Edition Release 10.2.0.1.0. 2. Description of the sample dialogs 2.1 Main screen TUTO_FORMS.FMB This dialog is the entry point of the samples. Click on a button to start the corresponding dialog. file:///D|/Cours/tuto_forms/paper/PDFtutoforms10g.htm (1 sur 24)29/05/2006 23:09:57 Oracle Forms 10g : Demos, Tips and Techniques 2.2 Canvases TEST_CANVAS.FMB This sample shows three types of canvas : § § § The content canvas (light green) The stacked canvas (white) The tab canvas (dark green) Stacked canvas A stacked canvas is displayed atop—or stacked on—the content...

Words: 3526 - Pages: 15

Premium Essay

Oracle Sql Tutorial

...Oracle/SQL Tutorial1 Michael Gertz Database and Information Systems Group Department of Computer Science University of California, Davis gertz@cs.ucdavis.edu http://www.db.cs.ucdavis.edu This Oracle/SQL tutorial provides a detailed introduction to the SQL query language and the Oracle Relational Database Management System. Further information about Oracle and SQL can be found on the web site www.db.cs.ucdavis.edu/dbs. Comments, corrections, or additions to these notes are welcome. Many thanks to Christina Chung for comments on the previous version. Recommended Literature George Koch and Kevin Loney: Oracle8 The Complete Reference (The Single Most Comprehensive Sourcebook for Oracle Server, Includes CD with electronic version of the book), 1299 pages, McGraw-Hill/Osborne, 1997. Michael Abbey and Michael Corey: Oracle8 : A Beginner’s Guide [A Thorough Introduction for First-time Users], 767 pages, McGraw-Hill/Osborne, 1997. Steven Feuerstein, Bill Pribyl, Debby Russell: Oracle PL/SQL Programming (2nd Edition), O’Reilly & Associates, 1028 pages, 1997. C.J. Date and Hugh Darwen: A Guide to the SQL Standard (4th Edition), Addison-Wesley, 1997. Jim Melton and Alan R. Simon: Understanding the New SQL: A Complete Guide (2nd Edition, Dec 2000), The Morgan Kaufmann Series in Data Management Systems, 2000. 1 revised Version 1.01, January 2000, Michael Gertz, Copyright 2000. Contents 1. SQL – Structured Query Language 1.1. Tables 1.2. Queries (Part I) 1.3. Data Definition...

Words: 21631 - Pages: 87

Free Essay

Oracle Ebs

...to Oracle EBS 1.1 About EBS 1.2 EBS Application Products 2. The EBS architecture 2.1 Desktop Tier 2.2 Application Tier 2.3 Database Tier 3. Oracle EBS database features 3.1 Monitoring Features 3.2 Performance Features 3.3 Scalability Features 3.4 Business Intelligence Features 3.5 Security Features 4. Oracle EBS user list 5. Oracle EBS success stories 5.1 Home Box Office (HBO) 5.2 Mallcom limited 5.3 AT&T INC. 5.4 Facebook 5.5 HCL 1.1 ORACLE EBS Oracle's E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management(CRM), and supply-chain management (SCM) computer applications either developed or acquired by Oracle. The software utilizes Oracle's core Oracle relational database management system technology. The E-Business Suite contains several product lines often known by short acronyms. Significant technologies incorporated into the applications include the Oracle database technologies, (engines for RDBMS, PL/SQL, Java, .NET, HTML and XML), the "technology stack" (Oracle Forms Server, Oracle Reports Server, Apache Web Server, Oracle Discoverer, Jinitiator and Sun's Java). Oracle Corporation brands the on-line technical documentation of E-Business Suite as eTRM — "E-Business Suite Technical Reference Manuals". The applications found in the Oracle EBS include: * Oracle CRM ...

Words: 7162 - Pages: 29

Free Essay

Oracle for Dummies

...™ Everything Easier! Making cle 11g Ora ® Learn to: • Set up and manage an Oracle database • Maintain and protect your data • Understand Oracle database architecture • Troubleshoot your database and keep it running smoothly Chris Zeis Chris Ruel Michael Wessler www.it-ebooks.info www.it-ebooks.info Oracle 11g ® FOR DUMmIES ‰ www.it-ebooks.info www.it-ebooks.info Oracle 11g ® FOR DUMmIES by Chris Zeis, Chris Ruel, and Michael Wessler ‰ www.it-ebooks.info Oracle® 11g For Dummies® Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2009 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online...

Words: 106399 - Pages: 426

Premium Essay

Accessing Oracle

...Running head: ACCESSING ORACLE Accessing Oracle Intro to Relational Database Management Systems CIS111 Professor Rachelle Howard October 21, 2012 Accessing Oracle Accessing Strayer University UNIX server is an information technology tool that assists the completion of curricula activities and student lab assignments designed to expand the knowledge base in relational database management systems. For the first assignment, the following steps were taken to accomplish access to Oracle: 1. The first step to get to the Oracle server, Click on Start-> Programs -> Putty, was simple and easy. 2. After typing in the host name, UNIX-online.strayer.edu, I ensured the port was set to 22 and that the radio button was set for SSH. After entering Student Unix Server in the Saved Sessions box I selected “open” instead of going to the next step of selecting Category, which caused me to have to start over. 3. In the Category area on the left I selected Window. In the Columns and Rows boxes I entered 120 and 60 respectively to set the initial window size when opening the terminal window. Under Lines of scrollback, I enter 20000 and verified the remaining boxes. 4. I experienced dificulty with setting the colours. Under the Categories\Window to select Colours I selected ANSI Blue and typed in the values in the illustration before I selected Modify. I changed the colour to yellow and selected OK. This caused me to start the initial setup from step 1. I repeated this...

Words: 471 - Pages: 2

Free Essay

Oracle Dba

...Golden rules of RAC diagnostics By Riyaj Shamsudeen ©OraInternals Riyaj Shamsudeen Me n  n  n  n  n  n  n  n  n  20+ years using Oracle products/DBA OakTable member, Oracle ACE Director Certified DBA -7.0,7.3,8,8i,9i &10g Specializes in RAC, performance tuning, EBS, & Exadata Chief DBA with OraInternals Co-author a few books Email: rshamsud@orainternals.com Blog : orainternals.wordpress.com Web: www.orainternals.com ©OraInternals Riyaj Shamsudeen 2 Golden rules of RAC diagnostics 1. Beware of top event tunnel vision. 2. Eliminate infrastructure as an issue. 3. Identify problem instance(s). 4. Review Send side metrics, and not just Receive side metrics. 5. Use histograms to identify any abnormalities, and not just averages. ©OraInternals Riyaj Shamsudeen Top event tunnel vision n  In RAC, the root cause can be hidden in other node and might not show up in the Top-5 wait events. Impact of side effect events can be much, much worse then actual root cause event itself. Performance of the instances are intertwined. Performance of background processes in one node, can affect the application performance in the all other nodes. n  n  n  ©OraInternals Riyaj Shamsudeen Top event tunnel vision ..2 Example 1 ©OraInternals Riyaj Shamsudeen 5 Top event tunnel vision ..3 Example 2 ©OraInternals Riyaj Shamsudeen 6 Top event tunnel vision ..4 Example 3 ©OraInternals Riyaj Shamsudeen 7 ...

Words: 964 - Pages: 4

Free Essay

Oracle vs Peoplesoft

...Oracle  –  PeopleSo-  Takeover   Contents   •  •  •  •  •  •  •  •  •  •  •  Introduc-on   Products   Market  Structure   Why  PeopleSo8   Oracle’s  /  PeopleSo8’s  View   Timeline  of  the  Acquisi-on   Pre-­‐Merger   Post-­‐Merger   Defense  /  An-defense  Strategies   A8er  Takeover   Conclusion   Oracle  -­‐  PeopleSo8  Takeover   2   Introduc-on   •  The  acquisi-on  would  enable  Oracle  to   capture  the  Enterprise  Applica-on  so8ware   business,  used  by  large  companies.   •  Merger  would  be  a  legi-mate  rival  to  SAP.   •  Oracle  made  a  hos-le  bid  of  $10.3  billion  for   PeopleSo8  in  June  2003   •  Lasted  for  18  months   Oracle  -­‐  PeopleSo8  Takeover   3   Oracle   •  Founded  in  1977  by  Larry   Ellison  (CEO)   •  One  of  largest   developers  of  “Database   Management  Systems” •  More  than  41,000   employees  and  reported   revenue  of  more  than   $10.2  billion  in  2003   Oracle  -­‐  PeopleSo8  Takeover   4   PeopleSo8   •  Founded  in  1987  by   David  Duffield  &Ken   Morris   •  Craig  Conway  is  CEO   •  Specializes...

Words: 1427 - Pages: 6

Free Essay

Oracle Apps

...|Current Location |Hyderabad | |Current Employer |Tata Consultancy Services | Executive Summary: My ambition is to work for the leading consulting firms within the IT industry as I believe I am skilled and have much to offer potential employers and their clients. Currently, I am a System Engineer with Tata Consultancy Services Limited. Primary Skills: 2years & 9 Months of experience as Technical Consultant in Oracle E-Business Suite Applications. Resume Details: • 2 years and 9 month of analysis, design, development and support experience in Oracle apps. • Has exposure in working with Onsite – Offshore models. • Experience in all phases of the system development /implementation life cycle. • Experience in Oracle Apps...

Words: 1310 - Pages: 6

Free Essay

Oracle Database Trends

...researched on database understood database used by ORACLE. INTRODUCTION The definition of a database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of records well, but be accessed easily. In addition, new information and changes should also be fairly easy to input. In order to have a highly efficient database system, you need to incorporate a program that manages the queries and information stored on the system. This is usually referred to as DBMS or a Database Management System. Besides these features, all databases that are created should be built with high data integrity and the ability to recover data if hardware fails. (What is a Database?, 2010) AIM The aim of the study is many folded such as, understanding database, go in detail and understand and research on database, understand the technology used by ORACLE, derive conclusions on the development in the field of database. LIMITATIONS This study is descriptive in nature and the research is done on published secondary materials. Logical conclusions are made based on our experience and the results done by the previous researchers. However, the time constraint is considered as a big obstacle in completing the project to our best satisfaction. Our project will mainly concentrate on database trends in general. However, we will make a short mention to ORACLE whom adopted new trends in database. DEFINITION...

Words: 3078 - Pages: 13

Free Essay

Oracle Process Manufacturing

...Process Execution User’s Guide Release 11i June 2002 Part No. A97685-01  Oracle Process Manufacturing Oracle Process Manufacturing Process Execution User’s Guide, Release 11i Part No. A97685-01 Copyright © 1996, 2002, Oracle Corporation. All rights reserved. Primary Author: Richard D. Persen Glenn Ruhl, Gina Walsh Contributing Authors: Contributors: Paul Schofield, Karen Theel The Programs (which include both the software and documentation) contain proprietary information of Oracle Corporation; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent and other intellectual and industrial property laws. Reverse engineering, disassembly or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited. The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this document is error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation. If the Programs are delivered to the U.S. Government or anyone licensing...

Words: 68434 - Pages: 274