Thursday, February 27, 2014

Oracle EBS R12.2 – Key Features – Revisited


As we get closer to EBS 12.2 release, I had to revisit my earlier post on R12.2 key features to ensure its up to date. Here are some of the stand-out feature set that may help you to get a quick glimpse at.
Native Technology Stack Installation
• Now tech. stack has better integration with Oracle Universal Installer
• Another big one. Yes, Faster Technology Stack Installation. At least 25% much faster.
• Silent-mode calls to install and configure Oracle Database 11.2, WebLogic Server (WLS) and Oracle HTTP Server (OHS)
• AutoConfig is tightly integrated with native technology stack installation
 Database RMAN Restore
• Simplifies Integration with Grid Infrastructure.
• Seamless integration with different storage methods (OCFS2, NFS, etc)
• Faster integration with Automatic Storage Management (ASM)
 Dual File System
• A must needed feaure,  dual file system capability is instrumental for 12.2’s Online Patching feature that allows users to continue using the application while patching.
• Dual File System allows replacing files with minimum downtime that leads to improved High Availability

Dual Port Configuration
As part of online patching feature, Oracle requires DPC (Dual Port Configuration)
• Dual Port Pool configuration
• Easier port assignments
• Allows port customization in run-time and patching file systems

Optional 11g Home for Upgrades
I always wonder why we can’t simply try to use an existing Oracle home during configuration. Well, Oracle incorporated this capability in 12.2.
• Allow integration with an existing 11gR2 Oracle Home
• Simplified Technology Stack Upgrade
• Reduced Upgrade time
WebLogic Server Features
As middleware technology stack is based on the new improved Weblogic that has atleast the following key capabilities to help manage the EBS environment better. As WLST 11gR2 is what is slated to get bundled with 12.2, its interesting to know if Oracle will WLST 12c into the mix over 11gR2
• • WebLogic Scripting Tool (WLST)
• High Availability & Failover
• Consolidated Administration, Configuration and Deployment
• Enhanced Monitoring & Messaging via centralized service administration.
• Troubleshooting framework
• Integration with OAM
• WLS-Specific configuration setups
• Proactive Management via Server & Performance Monitoring
• Easier Problem Solving & Performance Tuning
• Better resource planning via historical reporting
 Online Patching
In 12.2 all patching operations are online. In other words, Oracle E‐Business Suite will remain available to users during patching operations.  EBS 12.2 will take advantage of 11gR2 Database’s Edition-Based Redefinition features to provide support for Online Patching.  Edition-Based Redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time.
• Downtime will be measured in minutes not hours or days
• Downtime windows will be very predictable
• Patches are applied while the Production Application remains online
• Allows an application to efficiently store multiple editions of its Application Definition in the same database
• Provides an isolation mechanism (The Edition) that allows pre-upgrade and post-upgrade schemas to co-exist
• Client code chooses the particular “Edition” that it wants to connect to.
Posted by at No comments:

R12.2 Online Patching Cycle

With five phases R12.2 Online Patching Cycle is a Revolutionary Feature and gives the flexibility on defining downtime. The five interesting phases are Prepare, Apply , Finalize, Cutover and Cleanup. They are achieved with the new architectural changes.

The Online Patching solution involves the usage of two main file systems.

These file systems rotate the role of "run" file system and "patch" file system. The file system playing the role of "run" stores the code used by the running application. The file system playing the role of "patch" is a copy of the "run" file system that could be either in stage mode (ready for the next patching cycle) or being patched during a patching cycle. After patching is complete, the "patch" file system it will be promoted to take the role of "run".

An additional non-editioned file system is introduced to store some code and log files, common to both file systems, in a single location so they can be easily located.

So what exactly is possible with the new feature ?

On the first short this picture will look confusing and once there is a clear understanding on the different phases then this picture is meaningful.

Posted by at No comments:

Oracle e-Business Suite Release R12.2 (.2) Upgrade – New Features Summary

Because my company asked for this, and I couldn’t find a readily available My Oracle Support document that is concise enough.
Based primarly upon:
Oracle E-Business Suite Release 12.2 Release Value Propositions (Doc ID 1580742.1)
With additions from notes by Steve Sutphin on LearningWerks.
Modules Being Covered in this Summary
  • Application Technology
  • Asset Lifecycle Management
  • Customer Relationship Management
  • Financials
  • Procurement
  • Human Capital Management
Not all modules are covered herein (e.g. Supply Chain, Project Billing, Project Management, Value Chain) simply because we don’t have them in-use, so I couldn’t validate the accuracy of those modules.
Applications Technology - User Interfaces, Infrastructure
Oracle EBS Release 12.2 Technology Stack
Oracle EBS Release 12.2 Technology Stack
  • WebLogic Server (11.1.1.6) replacing iAS (10.1.3)
    • [10.1.2 stays for Forms and Reports]
  • Mobile Certification for OA Framework
    • iPad, iPhone, Android
  • Report Manager and Web ADI
    • Certified for MS Office 2010/32-bit
  • Integrated SOA Gateway
    • Now on WebLogic for improved integration
  • Online Patching
    • Editioned filesystem and DB objects allow side-by-side Production and Test codesets with minimal switchover downtime.
Oracle EBS Release 12.2 Online Patching Process
  • Numerous OAFramework User Interface Cosmetic and Usability Improvements
Assets (Asset Lifecycle Management,  not FA) - Workflow, Productivity
  • Support for Asset Moves
    • Transactable Assets Allows Users To Move Assets In And Out Of Inventory, Transfer Assets From One Inventory Organization To Another, And Transfer Assets From One External Location To Another External Location
  • Enhanced Integration/Ease of Use
    • Asset Sale
    • Asset Retirements
    • Project-to-Project Material Transfers
    • Grouping of Serialized Items
  • Asset Tracking Mass Update
Customer Relationship Management - Revenue Tracking
  • Channel Revenue Management
    • Increased Automation in AR Deductions Settlement
    • Accrual Accounting with Trade Profiles
    • Extended Business Processes for Supplier Ship and Debit
    • Price Protection Agreements
  • Oracle Telesales
    • Visibility to Activities across Operating Units
    • Competitor Tracking at Product Level
Financials - Productivity, Controls
  • Cross-Module Enhancements
    • Multi-Org Access Control Security profiles that now support a list of operating units
    • Ledger Sets Ledgers sharing the same Chart of Accounts, Calendar and Period Type
    • Advanced Global Intercompany System (AGIS)
    • New Bank Account Model Single access point for defining and maintaining bank accounts in AP, AR, Collections, Payroll, CashMgt, & Treasury
  • Advanced Collections
    • Party (Customer) Level Bankruptcy Tracking
    • Support for Partial Disputed Transaction Amounts
  • Assets
    • Enh. Mass Additions I/F for Legacy Conversions
    • Automated Depr. Rollback for Selected Assets
    • Impairments/Unplanned Depreciation Visibility
    • Addl. BI Publisher Reports
  • Cash Management
    • Simplified Setup and Streamlined Bank Account Reconciliation
    • Reconciliation Success Rates for First Notice Items (FlexMatch)
    • Centrally-stored Balance History – Trends and Cash Positions
    • Flexible Cash Pooling
    • Maintain and Report on Authorized Signatories
  • Customer Data Hub
    • Tax Validation Management with Tax Geography Hierarchy
    • DQM Overview Dashboard
    • DQM public Application Programming Interface
    • Real-time Address Validation for Tax Purposes
  • e-Business Tax
    • Application of Specific Tax Configs to Business Entities
    • Tax Simulator and Determination Services
    • Customer Tax Information Import
  • General Ledger
    • Allocate Financial Data From One Or More Ledgers To A Different Target Ledger
    • Data Access Sets and Ledger Sets
    • Journal Batch Copy
    • Alternate Account UI
    • New Web-based Account Analysis & Drilldown
    • Flaggable As Non-Reversable Journal Sources
    • Integration to Hyperion DRM and Fusion Acctg Hub
  • Internet Expenses (iExpense)
    • Global Per Diem and Mileage Rates
    • Mileage Accumulation
    • Automatic Matching of Advance Payments
    • Flexible Application of Cash Advances
    • Payment Holds and Automatic Notifications
    • Enhanced Itemization Controls
    • New Audit Expense Report
    • Auto-Itemization of Expenses from Visa/AMEX
    • Parallel Approvals
    • New Header-level Document Attachments
    • Support for new iOS/Android Mobile Expenses
  • Payables
    • New User Interface For Supplier Entry And Maintenance
    • Centralized Bank Account Definitions (see Summary)
    • Improved Invoice Processing with Invoice Lines
    • Contract Financing, Retainage, and Progress Terms
    • Line-Level Invoice Approval Workflows
    • Self-Service Entry for Non-PO Invoices
    • Improved iSupplier Portal
    • Scheduled AP/AR Netting Batches
  • Receivables
    • Partial Period Revenue Recognition
    • Event-based Revenue Management
    • New Credit Card Error Handling
    • Improved Chargeback Reconciliation
    • Oracle Bill Presentment Architecture (BPA)
    • Customer Communication – Auto PDF Printing
    • New Sweep Invalid Distributions Report Details of the accounting exceptions that are holding the period close for review and action. If the amount involved is not material from the reporting perspective and resolving the accounting exceptions is likely to delay the period close, then the transactions with invalid accounting can be swept to the next open period.
    • Automated Auto Lockbox Processing (via CP)
    • API Support for Unidentified Receipt Assignments
  • Subledger Accounting
    • Enhanced Multi-Reporting Currency Functionality
    • Improved Reporting and Analysis with Supporting References
  • Treasury
    • New Automatic Floating Rate Reset for Bonds
    • Automated Cash Pooling Across Legal Entities
    • Automatic Bank Account Update for Redirecting Payments to a New Bank Account
Projects - Efficiencies
  • Project Costing
    • Labor Rate Schedules by Criteria
    • Enhanced Payroll Integration
    • Total Time Costing
    • Increased Control and Visibility for Multi-Funded Contingent Workers
    • Allocate Funding Based On Time And Expense Entry
    • Batch Processing of Mass Adjustments
Procurement - Efficiencies
  • iProcurement
    • Automatic Updates of Encumbrance Dates
    • Eligible Information Template Information Stored as Attachments
    • Override Employee Charge Account Preference
    • Dual Budgetary Controls (Encumbrance Acctg)
    • Item Master Attachments Support
    • Post-Approved PO Requisition Attachment Support
    • PO Import Process Can Use Account Generator Auto-generate Charge Accounts during Requisition Import (blank charge accounts)
  • iSupplier Portal
    • Enhanced Prospective Supplier Registration – Adaptive Supplier Onboarding
    • E-Kanban Support (Flow Manufacturing)
    • Enh. Supplier Contact Information Data URL, Alt. Contact Name/Phone
  • Purchasing
    • Automatic Updates of Encumbrance Dates
    • Additional WF Extensions for Custom Validations
  • Procurement Contracts
    • Multiple Templates Applied to Purchasing Docs
    • New API’s for Templates, Questions and Constants
    • New Clause Descriptor Field
    • Clause Mandatory Attribute at Rule Level
    • Clause Section Placement by Contract Expert
    • Deletion of Provisional Sections from Solicitation to Award
    • Instruction Text including URLs
    • Multi-Row Contract Clause Variables
    • Display and Sort by Clause Number
    • Enh. Repository Contracts License Agreements, Nondisclosure Agreements, Merger Contracts, Misc. Agreements (user-defined)
    • User Defined Attribute support for Deliverables
    • Sync/Down/Upload: MS Word 2010 Certification
    • Contract Expert Performance Improvements
  • Sourcing
    • Add Requisition lines to a Draft Negotiation
    • Ability To Withdraw Responses Submitted On An RFI/RFQ
    • Track Supplier Amendment Acknowledgements
    • Staggered Awards on Split Negotiations
    • Import of Price Breaks and Tiers via Excel
    • Negative Cost Factor Support
    • New API’s to Create RFIs, RFQs, Auctions and Negotiations
    • Online Discussions Attachments and Messaging
    • Terms and Conditions Display Controls
    • Lot Pricing Summaries (also by Lot Line)
  • Spend Classification
    • Reclassify Historical Data
    • Asynchronous Classified Batch Approval Flows
    • Enhanced Training Data Upload (up to 100MB)
    • Enhanced Knowledge Base Tracking Capability
    • Improvements in Analyzing KPI Batches with Excel Export
    • Classification Code Reset by Ranges
Human Capital Management - Streamlining, Efficiency
  • Cross-Module Enhancements
    • 30 Country Localization Support
    • Managerial Task Checklists
    • Bulk Synchronization -> Incremental Sync API
    • Future-Dated Terminations, Reversals, Rehires
  • Payroll
    • Purge Process Events
    • Quick Retro Pay (single assignment)
    • Self-Service Element Entry (w/WF approvals)
  • Human Resources
    • Streamlined Re-hire Processes
    • Self-Service Internal Hire Support
Posted by at No comments:

Monday, February 24, 2014

Oracle Critical Patch Update (CPU) for January 2014

By PCat-Oracle on Jan 14, 2014

The January 2014 Oracle Critical Patch Update (CPU) has been released.  Please see Oracle Critical Patch Update Advisory - January 2014 for more details.


Critical Patch Updates are released on the Tuesday closest to the 17th day of January, April, July and October. The next four dates are:
  • 15 April 2014
  • 15 July 2014
  • 14 October 2014
  • 20 January 2015

References






Affected Products and Versions Patch Availability
Oracle Database 11g Release 1, version 11.1.0.7 Database
Oracle Database 11g Release 2, versions 11.2.0.3, 11.2.0.4 Database
Oracle Database 12c Release 1, version 12.1.0.1 Database
Oracle Fusion Middleware 11g Release 1, versions 11.1.1.6, 11.1.1.7 Fusion Middleware
Oracle Fusion Middleware 11g Release 2, versions 11.1.2.0, 11.1.2.1 Fusion Middleware
Oracle Fusion Middleware 12c Release 2, version 12.1.2 Fusion Middleware
Oracle Containers for J2EE, version 10.1.3.5 Fusion Middleware
Oracle Enterprise Data Quality, versions 8.1, 9.0.8 Fusion Middleware
Oracle Forms and Reports 11g, Release 2, version 11.1.2.1 Fusion Middleware
Oracle GlassFish Server, version 2.1.1, Sun Java Application Server, versions 8.1, 8.2 Fusion Middleware
Oracle HTTP Server 11g, versions 11.1.1.6, 11.1.1.7 Fusion Middleware
Oracle HTTP Server 12c, version 12.1.2 Fusion Middleware
Oracle Identity Manager, versions 11.1.1.5, 11.1.1.7, 11.1.2.0, 11.1.2.1 Fusion Middleware
Oracle Internet Directory, versions 11.1.1.6, 11.1.1.7 Fusion Middleware
Oracle iPlanet Web Proxy Server, version 4.0 Fusion Middleware
Oracle iPlanet Web Server, versions 6.1, 7.0 Fusion Middleware
Oracle Outside In Technology, versions 8.4.0, 8.4.1 Fusion Middleware
Oracle Portal, version 11.1.1.6 Fusion Middleware
Oracle Reports Developer, versions 11.1.1.6, 11.1.1.7, 11.1.2.1 Fusion Middleware
Oracle Traffic Director, versions 11.1.1.6, 11.1.1.7 Fusion Middleware
Oracle WebCenter Portal versions 11.1.1.6.0, 11.1.1.7.0, 11.1.1.8.0 Fusion Middleware
Oracle WebCenter Sites versions 11.1.1.6.1, 11.1.1.8.0 Fusion Middleware
Oracle Hyperion Essbase Administration Services, versions 11.1.2.1, 11.1.2.2, 11.1.2.3 Fusion Middleware
Oracle Hyperion Strategic Finance, versions 11.1.2.1, 11.1.2.2 Fusion Middleware
Oracle E-Business Suite Release 11i, version 11.5.10.2 E-Business Suite
Oracle E-Business Suite Release 12i, versions 12.0.6, 12.1.1, 12.1.2, 12.1.3 E-Business Suite
Oracle Agile Product Lifecycle Management for Process, versions 6.0, 6.1, 6.1.1 Oracle Supply Chain
Oracle AutoVue Electro-Mechanical Professional, versions 20.1.1 Oracle Supply Chain
Oracle Demantra Demand Management, versions 7.2.0.3 SQL-Server, 7.3.0, 7.3.1, 12.2.0, 12.2.1, 12.2.2, 12.2.3 Oracle Supply Chain
Oracle Transportation Management, versions 5.5.06, 6.0, 6.1, 6.2, 6.3, 6.3.1, 6.3.2 Oracle Supply Chain
Oracle PeopleSoft Enterprise HRMS, versions 9.1.0, 9.2.0 PeopleSoft
Oracle PeopleSoft Enterprise HRMS Human Resources, versions 9.1, 9.2 PeopleSoft
Oracle PeopleSoft Enterprise PeopleTools, versions 8.52, 8.53 PeopleSoft
Oracle PeopleSoft Enterprise SCM Services Procurement, version 9.2 PeopleSoft
Oracle Siebel Core, versions 8.1.1, 8.2.2 Siebel
Oracle Siebel Life Sciences, versions 8.1.1, 8.2.2 Siebel
Oracle iLearning, version 6.0 iLearning
Oracle FLEXCUBE Private Banking, versions 1.7, 2.0, 2.0.1, 2.2.0.1, 3.0, 12.0.1, 12.0.2 Oracle FLEXCUBE
Oracle JavaFX, versions 2.2.45 and earlier Oracle Java SE
Oracle Java JDK and JRE, versions 5.0u55 and earlier, 6u65 and earlier, 7u45 and earlier Oracle Java SE
Oracle Java SE Embedded, versions 7u45 and earlier Oracle Java SE
Oracle JRockit, versions R27.7.7 and earlier, R28.2.9 and earlier Oracle Java SE
Oracle Solaris versions 8, 9, 10, 11.1 Oracle and Sun Systems Products Suite
Oracle Secure Global Desktop, versions 4.63.x, 4.71.x, 5.0.x, 5.10 Oracle Linux and Virtualization
Oracle VM VirtualBox, versions prior to 3.2.20, 4.0.22, 4.1.30, 4.2.20, 4.3.6 Oracle Linux and Virtualization
Oracle MySQL Enterprise Monitor, versions 2.3, 3.0 Oracle MySQL Product Suite
Oracle MySQL Server, versions 5.1, 5.5, 5.6 Oracle MySQL Product Suite
Posted by at No comments:

Sunday, February 23, 2014

Install Oracle E-Business Suite 12.2 on Linux – Part I : Download, Stage & Start Oracle Apps 12.2 software installation

 

 

I discussed about availability of  Oracle E-Business Suite (Oracle Apps) version 12.2, in today’s post I am going to cover installation steps.
Installation is more or less similar to previous R12 version (with few additional screens for WebLogic Server).

Document you must read :
  • Oracle E-Business Suite 12.2 Installation Guide is available here
  • 1320300.1 Oracle E-Business Suite Release Notes, Release 12.2
  • 1376487.1  Oracle E-Business Suite Applications DBA (AD) Release Notes for Release 12.2.2
.
Oracle Apps (E-Business Suite) 12.2 installation steps 
1. Download software from eDelivery .


1.1 Download following zip files for Linux
V29764-01.zip V35231-01_4of5.zip V35806-01_1of3.zip V37515-01_1of6.zip V29856-01.zip V35231-01_5of5.zip V35806-01_2of3.zip V37515-01_2of6.zip V35215-01_1of3.zip V35802-01.zip V35806-01_3of3.zip V37515-01_3of6.zip V35215-01_2of3.zip V35803-01_1of3.zip V35807-01.zip V37515-01_4of6.zip V35215-01_3of3.zip V35803-01_2of3.zip V35808-01.zip V37515-01_5of6.zip V35230-01_1of2.zip V35803-01_3of3.zip V35809-01.zip V37515-01_6of6.zip V35230-01_2of2.zip V35804-01_1of2.zip V35810-01.zip V39615-01.zip V35231-01_1of5.zip V35804-01_2of2.zip V35811-01.zip V35231-01_2of5.zip V35805-01_1of2.zip V35812-01.zip V35231-01_3of5.zip V35805-01_2of2.zip V35813-01.zip

2. Setup staging area (You can either unzip all files downloaded earlier or follow below process)
2.1 unzip StratHere DVD (for Linux)
unzip V35215-01_1of3.zip
2.2 Start buildStage script
[R12.2_SOFTWARE]/startCD/Disk1/rapidwiz/bin
./buildStage.sh
2.3 select option 1 i.e. Create New Stage
2.3 Select Option 2 Linux x86-64
2.4 Please enter the directory containing the zipped installation media: [Enter directory location where all the zip files are downloaded]
/stage/oracle/r12/12.2/
You should see output like
__________
Unzipping V35810-01.zip
Unzipping V35803-01_3of3.zip
Unzipping V35231-01_5of5.zip
.
.
.
Verifying stage area…
Directory /stage/oracle/r12/12.2/TechInstallMedia is valid
Directory /stage/oracle/r12/12.2/TechPatches/DB is valid
Directory /stage/oracle/r12/12.2/TechPatches/MiddleTier is valid
Directory /stage/oracle/r12/12.2/EBSInstallMedia/AppDB is valid
Directory /stage/oracle/r12/12.2/EBSInstallMedia/Apps is valid
Directory /stage/oracle/r12/12.2/EBSInstallMedia/AS10.1.2 is valid
Directory /stage/oracle/r12/12.2/TechInstallMedia/database is valid
Directory /stage/oracle/r12/12.2/TechInstallMedia/ohs11116 is valid
Directory /stage/oracle/r12/12.2/TechInstallMedia/wls1036_generic is valid
__________

2.5 Staging Area should look like below


3. Create Operating System User depending on Single User or Multi User Installation :
You can do
a) Single -User  Installation : oracle where both Application Tier and Database Tier are owned by single user
b) Multi-User Installation : oracle & applmgr where Application Tier is owned by one user (applmgr) and Database Tier by another (oracle)
Note: I am doing multi-user installation and using applmgr & oracle both member of group dba
groupadd dba
useradd -g dba applmgr
useradd -g dba oracle

4. Start Installer from root user
cd $R12.2_SOFTWARE/startCD/Disk1/rapidwiz/
./rapidwiz
5. In Wizard Operation screen select : Install Oracle E-Business Suite Release 12.2.0











Posted by at No comments:

Install Oracle E-Business Suite 12.2 on Linux – Part II :




1. Start EBS 12.2.x Installer from root user as
cd $R12.2_SOFTWARE/startCD/Disk1/rapidwiz/
./rapidwiz



2. Select Port Pool : Select port pool for services as you used to do in previous versions 12.1.x or 11i
Note: Oracle Apps 12.2 uses dual file system . more on dual file system in 12.2 later.


3. Select Database Type
a) Fresh Database : Use this for production or where you don’t need vision environment.
b) Vision Database : Use this option if you need vision data in R12.



Note: Base directory (/d01/oracle/prod) mentioned above should already be created and owned by Database user (oracle:dba) defined above.

4. License Additional Products : If you need any additional products you can license it now .
Note: You can license addtional products after installation as well.





5. If you are planning to use multi-language (language other than american english) then recommendation is to select Databse character set as AL32UTF8


6. Provide Application Tier details
Note: Apps OS user (applmgr:dba) should be able to create directory under Base directory (/d01/oracle/prod) .
Note: I created application tier user applmgr and database tier user oracle using same group i.e. dba



More on dual file system i.e. File System 1 & File System 2 later.
7. Provide Application Tier & database user password .
Note: WLS Admin User is WebLogic Server Administrator user used to login to WebLogic Console . WebLogic Server is newly introduced in Oracle Apps 12.2



8. If you plan to deploy application tier on multiple nodes then click on Add Server button at bottom.
Note: I am doing single node installation i.e. Application Tier and Database Tier on single host/machine.

9. Installer will validate system configuration and if any check fails then click on ! next to check .
Note: In my case Port Availablity and File Space checks failed. After fixing failed check click on Retry button

a) Port Availaibity check : In my case port 8899 was in use
To Identify which process is using port 8899 in linux run “netstat -tulpn | grep [Port_no]“
[atul@innowave21 ~]$ netstat -tulpn | grep 8899
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 :::8899 :::* LISTEN 4536/java
In my case Process ID 4536 was using port 8899, stop the process using 8899 or use different port pool in previous screen. 




10. Click Next and then Install when all checks complete successfully.



11. After installation , access Application as http://host:port where port number is 8000+ port pool, as I use port pool 10 URL should be http://host:8010
Posted by at No comments:

Kill Oracle Sessions



(a) SQL* PLUS:      
In order to use SQL*PLUS Approach, first we need to find out the SID, SERIAL# of the Session which we want to kill. Then issue the following command to kill the session
SQL> alter system kill session ‘SID, SERIAL#’;
 When we issue the above statement, It terminates a session, rolls back ongoing transactions, releases all session locks, frees all session resources.  If the session is performing some activity that must be completed (e.g. waiting for a reply from a remote database or rolling back a transaction), Oracle waits for this activity to complete, kills the session then returns control. If the wait lasts for 60 seconds then Oracle marks the session to be killed, and returns control with a message that the session is marked to be killed. It then gets killed when the activity is complete.
  (b) Using KILL Command (Unix/Linux)     
    To kill the sessions using KILL Command, we need to find out the SPID ( Server Process ID) of the Oracle Session. Then issue the KILL Command
 $ kill -9 <SPID> 
(c) Using ORAKILL Command ( Windows)     
To kill the sessions using ORAKILL Command ( Windows), we need to find out the SPID of Session and ORACLE_SID of your Oracle Database. Then issue ORAKILL Command 
C:\> orakill <ORACLE_SID>  <SPID> 
Here find the practical approach 
 Using SQL*PLUS
 SQL> select username,sid,serial#,terminal from v$session;
USERNAME    SID    SERIAL# TERMINAL
—————————— ———- ————-
SCOTT                           134      47747 BSR      
SYS                                   147      46965 pts/0                    
                                          150          2 UNKNOWN                     
                                          151          4 UNKNOWN                             
                                          154          1 UNKNOWN                                     
                                          167          1 UNKNOWN                               
                                          168          1 UNKNOWN                             
                                          169          1 UNKNOWN                                 
                                          170          1 UNKNOWN
18 rows selected.
SQL> alter system kill session ’134,47747′ immediate;
System altered.
================================================================ 
Using Unix KILL Command:
 ==============================
SQL> SELECT s.sid,       p.spid,       s.osuser,       s.programFROM   v$process p,       v$session sWHERE  p.addr = s.paddr;
SID SPID         OSUSER                         PROGRAM
———- ———— ——————————    
170 15771        oracle                         oracle@oraprod (PMON)     
 169 15773        oracle                         oracle@oraprod (PSP0)   
 168 15775        oracle                         oracle@oraprod (MMAN)     
167 15777        oracle                         oracle@oraprod (DBW0)     
 166 15779        oracle                         oracle@oraprod (LGWR)   
 165 15781        oracle                         oracle@oraprod (CKPT)    
 164 15783        oracle                         oracle@oraprod (SMON)   
 163 15785        oracle                         oracle@oraprod (RECO)    
 162 15787        oracle                         oracle@oraprod (CJQ0)     
 161 15789        oracle                         oracle@oraprod (MMON)    
 160 15791        oracle                         oracle@oraprod (MMNL)   
 138 16425        oracle                         oracle@oraprod (J000)    
 154 15799        oracle                         oracle@oraprod (QMNC)   
 147 16259        oracle                         sqlplus@oraprod (TNS V1-V3)     
 150 15807        oracle                         oracle@oraprod (q000)     
 151 15809        oracle                         oracle@oraprod (q001)     
 137 16329        oracle                         sqlplus@oraprod (TNS V1-V3)   
 134 16380        BSR                           sqlplus.exe
 18 rows selected.
$ ps -ef|grep 16380 
 oracle 16436 16236  0 17:30:37 pts/0     0:00 grep 16380
oracle 16380     1  0 17:28:32 ?         0:00 oracleORCL  (LOCAL=NO)
$ kill -9 16380$
 ======================================================================
Using Windows ORAKILL Command:
========================================
SQL> select sid,username,program from v$session;    
   SID USERNAME                       PROGRAM
———- ——————————
  1                                ORACLE.EXE    
 2                                ORACLE.EXE  
 3                                ORACLE.EXE  
 4                                ORACLE.EXE    
 5                                ORACLE.EXE      
6                                ORACLE.EXE  
7                                ORACLE.EXE     
8                                ORACLE.EXE      
9    SCOTT              sqlplus.exe      
10    SYS                    sqlplus.exe 
Find out the SPID related to SCOTT Session (Session ID 9):
SQL> select  s.sid,p.spid,s.osuser,s.program from v$session s, v$process p   where p.addr=s.paddr;      
 SID SPID         OSUSER                         PROGRAM
———- ———— ——————————
  1 1744         SYSTEM                         ORACLE.EXE     
  2 3716         SYSTEM                         ORACLE.EXE     
   3 3644         SYSTEM                         ORACLE.EXE     
   4 3888         SYSTEM                         ORACLE.EXE      
  5 1992         SYSTEM                         ORACLE.EXE     
   6 2092         SYSTEM                         ORACLE.EXE       
   7 2148         SYSTEM                         ORACLE.EXE     
   8 2224         SYSTEM                         ORACLE.EXE      
   9 2720         BSR                                sqlplus.exe      
10 2144        BSR                                sqlplus.exe
10 rows selected.
 Kill the  SPID 2720 related to SCOTT SID 9 session using orakill command 
C:\>orakill TEST 2720
 Kill of thread id 2720 in instance TEST successfully signaled.
 C:\> SQL>  select sid,username,program from v$session      
 SID USERNAME                       PROGRAM
———- ——————————
    1                                ORACLE.EXE     
   2                                ORACLE.EXE      
  3                                ORACLE.EXE     
   4                                ORACLE.EXE      
  5                                ORACLE.EXE     
   6                                ORACLE.EXE     
   7                                ORACLE.EXE      
  8                                ORACLE.EXE      
10 SYS                        sqlplus.exe
9 rows selected
Note:  Do not kill the sessions at the OS level as per Oracle Recommendation. As per understanding i have given the above approaches
 Reference:
(1) Should Sessions be Killed in OS or Using Alter System Kill Session? Doc ID: Note:161794.1
Posted by at No comments:

Oracle® E-Business Suite Installation Guide: Using Rapid Install Release 12.2 (12.2.0) Part No. E22950-14

Posted by at No comments:

 Oracle Critical Patch Update Advisory - January 2014

Purpose

The purpose of this advisory is to bring attention to the following critical patch update released for Oracle.

Assessment

Oracle has issued a Critical Patch Update (CPU) which addresses 144 new security fixes across multiple Oracle products.
Affected products and versions:
Oracle Database 11g Release 1, version 11.1.0.7
Oracle Database 11g Release 2, versions 11.2.0.3, 11.2.0.4
Oracle Database 12c Release 1, version 12.1.0.1
Oracle Fusion Middleware 11g Release 1, versions 11.1.1.6, 11.1.1.7
Oracle Fusion Middleware 11g Release 2, versions 11.1.2.0, 11.1.2.1
Oracle Fusion Middleware 12c Release 2, version 12.1.2
Oracle Containers for J2EE, version 10.1.3.5
Oracle Enterprise Data Quality, versions 8.1, 9.0.8
Oracle Forms and Reports 11g, Release 2, version 11.1.2.1
Oracle GlassFish Server, version 2.1.1, Sun Java Application Server, versions 8.1, 8.2
Oracle HTTP Server 11g, versions 11.1.1.6, 11.1.1.7
Oracle HTTP Server 12c, version 12.1.2
Oracle Identity Manager, versions 11.1.1.5, 11.1.1.7, 11.1.2.0, 11.1.2.1
Oracle Internet Directory, versions 11.1.1.6, 11.1.1.7
Oracle iPlanet Web Proxy Server, version 4.0
Oracle iPlanet Web Server, versions 6.1, 7.0
Oracle Outside In Technology, versions 8.4.0, 8.4.1
Oracle Portal, version 11.1.1.6
Oracle Reports Developer, versions 11.1.1.6, 11.1.1.7, 11.1.2.1
Oracle Traffic Director, versions 11.1.1.6, 11.1.1.7
Oracle WebCenter Portal versions 11.1.1.6.0, 11.1.1.7.0, 11.1.1.8.0
Oracle WebCenter Sites versions 11.1.1.6.1, 11.1.1.8.0
Oracle Hyperion Essbase Administration Services, versions 11.1.2.1, 11.1.2.2, 11.1.2.3
Oracle Hyperion Strategic Finance, versions 11.1.2.1, 11.1.2.2
Oracle E-Business Suite Release 11i, version 11.5.10.2
Oracle E-Business Suite Release 12i, versions 12.0.6, 12.1.1, 12.1.2, 12.1.3
Oracle Agile Product Lifecycle Management for Process, versions 6.0, 6.1, 6.1.1
Oracle AutoVue, versions 20.1.1
Oracle Demantra Demand Management, versions 7.2.0.3 SQL-Server, 7.3.0, 7.3.1, 12.2.0, 12.2.1, 12.2.2, 12.2.3
Oracle Transportation Management, versions 6.0, 6.1, 6.2, 6.3, 6.3.1, 6.3.2
Oracle PeopleSoft Enterprise HRMS, versions 9.1.0, 9.2.0
Oracle PeopleSoft Enterprise HRMS Human Resources, versions 9.1, 9.2
Oracle PeopleSoft Enterprise PeopleTools, versions 8.52, 8.53
Oracle PeopleSoft Enterprise SCM Services Procurement, version 9.2
Oracle Siebel Core, versions 8.1.1, 8.2.2
Oracle Siebel Life Sciences, versions 8.1.1, 8.2.2
Oracle iLearning, version 6.0
Oracle FLEXCUBE Private Banking, versions 1.7, 2.0, 2.0.1, 2.2.0.1, 3.0, 12.0.1, 12.0.2
Oracle JavaFX, versions 2.2.45 and earlier
Oracle Java JDK and JRE, versions 5.0u55 and earlier, 6u65 and earlier, 7u45 and earlier
Oracle Java SE Embedded, versions 7u45 and earlier
Oracle JRockit, versions R27.7.7 and earlier, R28.2.9 and earlier
Oracle Solaris versions 8, 9, 10, 11.1
Oracle Secure Global Desktop, versions 4.63.x, 4.71.x, 5.0.x, 5.10
Oracle VM VirtualBox, versions prior to 3.2.20, 4.0.22, 4.1.30, 4.2.20, 4.3.6
Oracle MySQL Enterprise Monitor, versions 2.3, 3.0
Oracle MySQL Server, versions 5.1, 5.5, 5.6

Suggested action

Due to the threat posed by a successful attack, Oracle strongly recommends that customers apply CPU fixes as soon as possible. CCIRC recommends that system administrators identify their affected assets and potential interdependencies with their organization's critical services, and follow their patch management process accordingly.

References

http://www.oracle.com/technetwork/topics/security/cpujan2014-1972949.html

Note to Readers

The Canadian Cyber Incident Response Centre (CCIRC) operates within Public Safety Canada, and works with partners inside and outside Canada to mitigate cyber threats to vital networks outside the federal government. These include systems that keep Canada's critical infrastructure functioning properly, such as the electrical grid and financial networks, or contain valuable commercial information that underpins our economic prosperity. CCIRC supports the owners and operators of systems of national importance, including critical infrastructure, and is responsible for coordinating the national response to any serious cyber security incident.
Posted by at No comments:

Oracle Database 12c (12.1.0.1.0) installation on OEL6.

Oracle Database 12c (12.1.0.1.0) installation on OEL6.



I’m installing the Oracle Database 12c Release 1 (12.1.0.1.0) software on Oracle Linux6.  Only the software is being installed at this point, in preparation for a single database installation.

 Linux server meets the minimum hardware requirements.
  • 1GB of RAM (plus appropriately sized swap space)
  • 6.4GB of disk space for the software installation
  • 1GB of disk space for your /tmp directory


Package and OS requirements

In this example, I’m meeting the package and Operating System requirements by running the following yum command (as root):
yum install oracle-rdbms-server-12cR1-preinstall
 
[root@sujeet newrpms]# ls

 
binutils-2.17.50.0.6-6.0.1.el5.i386.rpm

binutils-2.17.50.0.6-9.0.1.el5.i386.rpm

compat-binutils215-2.15.92.0.2-24.i386.rpm

compat-libcwait-2.0-2.i386.rpm

compat-libstdc++-3.2-1.i386.rpm

compat-libstdc++-egcs-1.1.2-1.i386.rpm

compat-oracle-el5-1.0-5.i386.rpm

fonts-chinese-3.02-12.el5.noarch.rpm

openmotif21-2.1.30-11.EL5.i386.rpm

openmotif21-debuginfo-2.1.30-11.EL5.i386.rpm

xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

 
 
INSTALL RPM COMMAND:-
[root@sujeet ~]#  rpm –ivh  <rpmname> 
 
[root@sujeet ~]#  rpm –Uivh <rpmname>
 
Install rpm check:-
[root@sujeet ~]#  rpm -qa |grep <rpmname> 
 
(The “oracle-rdbms-server-11gR2-preinstall” RPM seems to work fine too though…)
If you don’t install the package bundle above, then you’ll have to meet all of the required prerequisites manually.

CHANGE HOSTNAME OR MACHINE NAME
 
[root@sujeet ~]#  vi  /etc/hosts
 
Make sure that there is an entry in /etc/hosts file for your 
machine like this:
127.0.0.1       localhost.localdomain  localhost
100.200.23.25   oracle.sujeet           oracle

GUI:-Create User and Group
 
System -> Administration -> Users and Groups -> 
i) Add user oracle
ii) Add Group dba
iii) Assign user to that group
 
        OR
 
COMMAND LINE:-
 
[root@sujeet ~]# useradd -g dba -m oracle
 
[root@sujeet ~]# passwd oracle
 
Changing password for user oracle.
New UNIX password: 
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password: 
passwd: all authentication tokens updated successfully.
 
Create directories where the Oracle Software and database 
will be installed.
 
[root@sujeet ~]#  Mkdir /u01 
[root@sujeet ~]#  chown -R oracle:dba  /u01
[root@sujeet ~]#  chmod -R 777 /u01
 
 
SELINUX=disabled
 
System -> Administration ->
 
If you leave SELINUX=enforcing then you may get an error later 
while starting sqlplus:
sqlplus: error while loading shared libraries:
/usr/lib/oracle/default/client64/lib/libclntsh.so.11.1: 
cannot restore segment
prot after reloc: Permission denied
 
 
 Linux Kernel Parameters to support Oracle.
 
Open /etc/sysctl.conf and add the following lines:
 
[root@sujeet ~]# vi /etc/sysconfig/network
 
# Oracle settings
fs.file-max = 65536
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65500
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
 
Make the kernel parameters changes effective immediately:
 
[root@sujeet ~]# /sbin/sysctl -p
 
[root@sujeet ~]#  /sbin/sysctl -a | grep <name of kernel>
 
 

Download the database 12c software

You need to download both Oracle Database 12c parts from the Oracle Technology Network (OTN).
Use Below Link:-

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Oracle Database Software Downloads

You must accept the OTN License Agreement to download this software.
Accept License Agreement | Decline License Agreement
Oracle Database 12c Release 1Standard Edition, Standard Edition One, and Enterprise Edition
(12.1.0.1.0)
Download Microsoft Windows x64 (64-bit) File 1, File 2  (2.5 GB)  See All
Download Linux x86-64 File 1, File 2  (2.3 GB)  See All
Download Oracle Solaris (SPARC systems, 64-bit) File 1, File 2  (2.6 GB)  See All
Download Oracle Solaris (x86 systems, 64-bit) File 1, File 2  (2.3 GB)  See All




Once you’ve downloaded the software, unzip both files to a staging area:
unzip /tmp/linuxamd64_12c_database_1of2.zip -d /u02/app/oracle/software
unzip /tmp/linuxamd64_12c_database_2of2.zip -d /u02/app/oracle/software
All of the contents from the above will be extracted to a “database” directory.

Restart system
 
[root@sujeet ~]# init 6   

Permission to connect any HOST
[root@sujeet ~]#  xhost +
access control disabled, clients can connect from any host

Start the installer

Open an X-Windows session to the server as the ‘oracle’ user.
Once you’ve met the requirements, and have unzipped the software, you can start the install:
/u02/app/oracle/software/database/runInstaller
Once the GUI starts, respond as follows:
  • Configure Security Updates
    • Unchecked ‘I wish to receive security updates via My Oracle Support’
    • Next
    • Confirm with ‘Yes’
  • Download Software Updates
    • Skip software updates
    • Next
  • Installation Option
    • Install database software only (you can opt to create a database instance at the same time, but I’m keeping the two separate here)
    • Next
  • Grid Installation Options
    • Single instance database installation
    • Next
  • Product Languages
    • Select any additional required languages and move across, otherwise leave just the default ‘English’ selected
    • Next
  • Database Edition  
    • Enterprise Edition (6.4GB) (…or as appropriate depending on which edition you’re licensed for!)
    • Next
  • Installation Location
    • Oracle Base: /u01/app/oracle
    • Software Location: /u01/app/oracle/product/12.1.0.1
    • Next
  • Create Inventory (first Oracle installation only)
    • Inventory Directory: /u01/app/oraInventory
    • oraInventory Group Name: oinstall
    • Next
  • Operating System Groups
    • Database Administrator (OSDBA) group: dba
    • Database Operator (OSOPER) group (Optional): dba
    • Leave all the other memberships as the default ‘dba’ group too.
    • Next
  • Prerequisites Checks
    • All prerequisite checks should complete successfully here, if not, then obviously they will need addressing before proceeding.  Assuming all database validation checks are successful, you shouldn’t actually see this page as the installer will automatically move onto the next screen.
  • Summary
    • Check everything is correct!
    • Click Install
  
 
 

Run the root.sh scripts

When prompted, run the following as root:
/u01/app/oraInventory/orainstRoot.sh (first Oracle installations only)

[root@linux06 ~]# /u01/app/oraInventory/orainstRoot.sh
 
 Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
 
/u01/app/oracle/product/12.1.0.1/root.sh

[root@linux06 ~]# /u01/app/oracle/product/12.1.0.1/root.sh
 
 Performing root user operation for Oracle 12c

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME= /u01/app/oracle/product/12.1.0.1

Enter the full pathname of the local bin directory: [/usr/local/bin]: <enter>
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
 
Finally, click close to finish

 Environment settings

Once the installation has finished, add the following variables to your ‘oracle’ user profile:

vi /home/oracle/.bash_profile

# Oracle variables
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=linux06.vbox; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/12.1.0.1; export ORACLE_HOME
#ORACLE_SID=SNAP12C; 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
Reload your profile with the new variables:
. ~/.bash_profile
 


How to Deinstall 12c

If you ever want to remove the software, simply run start the deinstall utility as follows, responding appropriately:

$ORACLE_HOME/deinstall/deinstall
Posted by at 2 comments:
Subscribe to: Posts (Atom)