• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

How to add the manage server in R12.2

November 12, 2020 by techgoeasy 1 Comment

I was working on R12.2 Test env and I was suppose to increase the JVM(add the manage server in R12.2) for the oacore to sustain  the load The procedure to increase JVM was quite simple in R12.1.X.  In Oracle E-Business Suite Release 12, the oacore, oafm, forms and forms-c4ws services were deployed as applications on […]

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: How to add the manage server in R12.2

How to run sql tuning advisor for a sql _id

November 12, 2020 by techgoeasy 1 Comment

Many times a sql may be running long and we may need to run sql tuning advisor to get the recommendation to resolve the long running issue.In this post, we would be looking at the steps to achieve it Steps for running  sql tuning  advisor on the particular sql -id in the Cursor cache Create […]

Filed Under: Oracle, Oracle Database Tagged With: sql tuning task

How to rollback the patch after failed cutover phase in R12.2

November 12, 2020 by techgoeasy Leave a Comment

There may be scenario  when  cutover phase failed . It is possible to go back to previous state of cutover(rollback the patch) ,if flashback database is either enabled in the database or we have taken full backup prior to cutover I would be explaining it with respect to Database Flashback to rollback the patch I am […]

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: How to rollback the patch after failed cutover phase in R12.2

How to upgrade EBS database to 19c: Step by Step

November 10, 2020 by techgoeasy 2 Comments

Here in this post , we wil checking out Upgrading Database to 19c with R12.1 Important points about 19c Upgrade When upgrading your Oracle E-Business Suite to Oracle Database 19c, your database will be converted to a multitenant architecture, which will consist of a Container Database (CDB) with a single Pluggable Database. Only multitenant architecture […]

Filed Under: Oracle, Oracle Ebuisness Suite

How to rollback the Oracle patch

November 10, 2020 by techgoeasy Leave a Comment

We apply lot of patches to Oracle product to add new feature, to rectify bugs. Sometime the patch do not work as expected and we need to rollback the oracle patch. I am presenting here the rollback cases for different type of Oracle patches Rollback of Database patches Database patches are applied using opatch. Each […]

Filed Under: Oracle, Oracle Database, Oracle Ebuisness Suite Tagged With: rollback of oracle patches

how to drop table in oracle

November 5, 2020 by techgoeasy Leave a Comment

The DROP TABLE oracle command is used to remove a table from the database. The dropped table and its data remain no longer available for selection. Dropping a table drops the index and triggers associated with it. Oracle Views, synonym are not dropped but they become invalid Dropped table can be recovered using FLASHBACK utility, if […]

Filed Under: Oracle, Oracle Sql

  • « Previous Page
  • Page 1
  • …
  • Page 4
  • Page 5
  • Page 6
  • Page 7
  • Page 8
  • …
  • Page 100
  • Next Page »

Primary Sidebar

Top Posts & Pages

  • Oracle Indexes and types of indexes in oracle with example
  • Top 30 Most Useful Concurrent Manager Queries
  • Top 46 Oracle ASM Interview Questions
  • Oracle dba interview questions and answers
  • 40 question you must know about R12.2



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to resolve Network Error: Software Caused Connection Abort
  • How to convert private key to ppk
  • how to import schema in oracle using impdp
  • how to check PSU patch version in oracle
  • How to migrate the schema from one database to another database using exp/imp

Copyright © 2021 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us