Oracle

In: Computers and Technology

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…...

Similar Documents

Oracle

...', 'UL','User-defined Locks', 'UN','User Name', 'US','Undo segment Serialization', 'WL','Writing redo Log', 'XA','Instance Attribute Lock', 'XI','Instance Registration Lock') TYPE FROM gv$session s, sys.gv$lock c, sys.gv$locked_object l, dba_objects o, sys.gv$lock k, gv$lock v WHERE o.object_id = l.object_id AND l.session_id = s.sid AND k.sid = s.sid AND s.saddr = c.saddr AND k.kaddr = c.kaddr AND k.kaddr = v.kaddr AND v.saddr = s.saddr AND k.lmode = l.locked_mode AND k.lmode = c.lmode AND k.request = c.request ORDER BY object; ***************** 11G TO 10G (XE) 1. expdp ETAG_CHTBW/etag@vw FULL=N VERSION=10.2 DIRECTORY=data_pump_dir DUMPFILE=ETAG_CHTBW.dmp LOGFILE=ETAG_CHTBW.log dump generated in : D:\app\Administrator\admin\vw\dpdump in 10g (XE for eg) put the dump generated above in this location (where 10g is installed) before running the below command: c:\oraclexe\app\oracle\admin\XE\dpdump 1.1 GRANT read, write on directory data_pump_dir to ETAG_CHTBW 2. impdp etag_chtbw/etag_chtbw FULL=Y DIRECTORY=data_pump_dir DUMPFILE=ETAG_CHTBW.DMP LOGFILE=ETAG_CHTBW.DMP_imp.log ***** TABLESPACE (MINEXTENTS) ERROR RESOLUTION (IN CASE U GET IT): ALTER TABLESPACE ETAG_DAT01 ADD DATAFILE 'C:\oraclexe\oradata\XE\MY_TS2.DBF' SIZE 90M AUTOEXTEND ON NEXT 200K MAXSIZE 200M; **************************** REF CURSOR **************************** Passing REF CURSOR as parameters to sub-programs...

Words: 1277 - Pages: 6

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...

Words: 471 - Pages: 2

Oracle Payables

...Critical Details about EBS R12 Upgrades Presented By Susan Behn VP, Oracle Practice Objectives/Agenda  Provide a high level view of topics to consider when upgrading to R12  When is a “technical” upgrade possible  What do I need to research more  When is the right time for training  What do I include in my budget/timeline  Functional Topics  Technical Topics 2 Overview  Are you aware that…  There are over 1500 new features in R12    A responsibility can now access data in multiple organizations R12.1 was released in April 2009    How does this impact custom Responsibilities How will all these new features be “discovered” Quicker data entry for shared services organizations   The user interface to the Oracle Diagnostics scripts was rewritten in OA Framework in R12.0.6   12.0 focused on Financials 12.1 focused on everything else including HR Utilizes role-based access control requiring role grants from the user management responsibility Setup reports in diagnostics can help you find missing setups 3 FINANCIALS - GL 4 Financials - GL  Legal Entities have significant functionality in R12  Should reflect legal corporate structure  Utilized by Accounting Functions, E-Business Tax, Intercompany, and Bank Account  Balancing segment is associated with legal entity – not ledger  Bank account is owned by legal entity  Align your Ledger structure with your business plan  Operating units are...

Words: 3253 - Pages: 14

Oracle Apps

... 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 R12,11i,Fusion • Worked in projects having R12 Implementation, Upgrades and Oracle Fusion • Experience of Development Data Conversions and Implementation • Proficient in, Packages writing stored procedures and functions using SQL & PL/SQL.  • Experience of Developing Reports (PL/SQL Reports). • Have good Knowledge on BI Publisher Reports • Have knowledge on Oracle Reports • Self-motivated, excellent team player with proven leadership skills. • Excellent communication and interpersonal skills. Project Summary: CIGNA HEALTH CARE |Description |Cigna is a Re-implementation or Oracle EBS Applications from R11.5.10.2 to R12.1.3. Like to Like Re-Implementation, with no | | |business process changes, except for standard functionalities that come with R12 – SLA. The main work includes the | | |Re-implementation of Finance module which includes AR,AP,Gl...

Words: 1310 - Pages: 6

Oracle Database

...Discoverer Plus Database The Air Force is changing in unique way to make the critical mission more obtainable to logistics technicians. The Air Force has evolved into using more web based systems to process transaction, track assets, and obtain pertinent information. Users have become accustomed to working with different 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...

Words: 624 - Pages: 3

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

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...

Words: 1424 - Pages: 6

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...

Words: 3160 - Pages: 13

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...

Words: 964 - Pages: 4

Oracle Backup

...Oracle Backup There are two type of back • Cold backup (Offline) • Hot Backup (Export) Cold backup Procedure Setup 1. Copy backup from Source Check the Oracle version & Path Open Comd Prompt and typecomd Tnsping [database_name] Then type Sqlplus Type username /password @ DB name as sysdba Check the How many DB install on system Click on Start Button and type services.msc and press enter this screen display Press O and search Oracleservice[DB name] Stop the service Now press the stop button on the left side Now go to your Oracle home directory and open it . Go to DB directory and Copy the Folder and past to the backup path After finish the copy then start service of “Orlaceservice[DB Name] Your cold/hard back Complete. Restore the Backup (On Same Version and installation Path) Step 2. Create New DB Click Start Button and type dbca and press next Select Create Database and Press Next Select General Purpose and Press Next Type Globaldatabase and SID and Press Next Uncheck Configure the database with Enterprise Manager Enter the Password for Sys and System and press Next Select File System and Press Next Select Use Common Location for all database and click Browser Select the Path and Press Ok and then Next Uncheck Specify Flash Recovery Area Press next on simple Schemas Press Next Press Finish Press Ok Press Finish Database...

Words: 662 - Pages: 3

Oracle Ebs

...TABLE OF CONTENTS 1. Introduction 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...

Words: 7162 - Pages: 29

Oracle

...Israel Garcia Professor Neil Librock Finance 3300 21 October 2014 Oracle Corporation Most widely known for their Java software, the #1 development platform, Oracle is the so called leader in database software. Their business expands, however, from software to hardware with products such as storage equipment, servers, operating systems, virtualization software, middleware, and many more. It was founded in 1977 and today it is headquartered in our very own Golden state in Redwood City. We look first at measures of financial leverage, which is important because debt can increase or decrease returns to shareholders. Financial leverage is usually measured by the ratio of long-term debt to total long-term capital. Oracles long-term debt ratio for 2014 is 33%, an increase from 29% in 2013. This number tells us that for every dollar in the form of long-term capital, 33 cents is in the form of debt. This measure, however, ignores Oracle’s short-term debt. To take short-term debt into account we measure its total debt ratio, in this case Oracle’s total debt ratio is 47%. Ultimately, these numbers tell us that Oracle is financed 47% with long-term and short-term debt and 53% with equity. We want equity here to be higher than debt since the less money the company borrows, the less interest it pays. Next, we take a look at Oracle’s liquidity ratios. Liquid assets can be converted into cash quickly, which is why it is important to measure to see how quickly a company can bring...

Words: 652 - Pages: 3

Oracle

...Oracle Systems Corporation is a database management software company that found success in the 1980’s from being an innovator in multiplatform software development. Oracle’s business strategy focused on building its technical expertise and customer service to provide performance standards that could not be matched by competitors. Oracle adopted a first mover competitive advantage when it was the first company to deliver multiple-interface software along with a range of accounting applications - all at record-setting speeds. An incentive-driven sales force was established in order to market to large corporations that would benefit the most from its software. In return, Oracle saw growth rates as sales increased by nearly 700 million dollars from 1988 to 1990. Oracle’s key successes and risk factors can both be traced to their marketing and R&D costs, as well as expanding licensing agreements with hardware manufacturers and value-added resellers (VARs). The first mover advantage that Oracle established with its software allowed the company to venture into a wide arrange of services such as maintenance, consulting, and systems integration before its competitors. These services created a company that could specialize in both product quality and customer service. This instant expansion also came with its own set of problems. Customer satisfaction dropped due to an inability of the sales force to adapt to new territories and new software was being criticized for a number...

Words: 580 - Pages: 3

Oracle

...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...

Words: 1320 - Pages: 6

Oracle

...Oracle 11g PL/SQL New Features PL/SQL "continue" keyword - This will allow a "C-Like" continue in a loop, skipping an iteration to bypass any "else" Boolean conditions. A nasty PL/SQL GOTO statement is no longer required to exit a Boolean within a loop. Oracle professional Jurgen Kemmelings has an excellent PL/SQL example of the PL/SQL continue clause in-action: begin for i in 1..3 loop dbms_output.put_line(’i=’||to_char(i)); if ( i = 2 ) then continue; end if; dbms_output.put_line(’Only if i is not equal to 2′); end loop; end; Disabled state for PL/SQL - Another 11g new feature is a "disabled" state for PL/SQL (as opposed to "enabled" and "invalid" in dba_objects). Easy PL/SQL compiling - Native Compilation no longer requires a C compiler to compile your PL/SQL. Your code goes directly to a shared library. Source: Lewis Cunningham Improved PL/SQL stored procedure invalidation mechanism - A new 11g features will be fine grained dependency tracking, reducing the number of objects which become invalid as a result of DDL. Scalable PL/SQL - The next scalable execution feature is automatic creation of "native" PL/SQL (and Java code), with just one parameter for each type with an "on/off" value. This apparently provides a 100% performance boost for pure PL/SQL code, and a 10%-30% performance boost for code containing SQL. Mark Rittman Enhanced PL/SQL warnings - The 11g PL/SQL compiler will issue a......

Words: 269 - Pages: 2