How to alter table add column oracle

Last updated on April 1st, 2017 at 08:11 am-You Add a new column using the ALTER TABLE statement. – The table must be contained in your schema To alter a table, or you should either have  ALTER object privilege for the table or the ALTER ANY TABLE system privilege. -If a view, materialized view, trigger,  function-based index, check constraint, function, procedure of package depends on a base table, the … Continue reading How to alter table add column oracle »

Top AWR useful queries for R12.2/R12.1 Upgrade

R12.1/R12.2 are pretty big  and time consuming upgrade. We need to find all the long running sql in order to resolve the  R12.2 upgrade performance issues. Since each iteration takes lot of time,it is important ,we tried to find out the performances issues in less iterations. Here are Top AWR useful queries to solve R12.2 upgrade performance issues If SQL is still in memory (cursor cache) the following … Continue reading Top AWR useful queries for R12.2/R12.1 Upgrade »

R12.2 RapidWiz Installed Components and System Requirements

R12.2 is the latest release of Oracle EBS. Here are R12.2 RapidWiz  Installed Components and System Requirements Technology Stack Components For a new Release 12.2 installation, Rapid Install automatically installs and configures the required technology stack components for both the database tier and the application tier. On the database tier, the technology stack includes: Oracle Database 12c Release 1 (12.1.0.2)  (  This is when we don’t … Continue reading R12.2 RapidWiz Installed Components and System Requirements »

Awesome Information on HOTPATCH mode in adop

What is Hotpatch mode in R12.0/R12.1 We add hotpatch to the adpatch option list to apply the patches in the environment without putting it into Maintainance Mode.  This  was quite widely used by the customer to apply the small patches to the environment. This seems to have worked in many cases with out issues. Customer upgrading to R12.2 may tend to use the same practice. … Continue reading Awesome Information on HOTPATCH mode in adop »

How to change the Web Port in EBS 12.2

As we all  know,httpd.conf configuration is managed by FMW  in R12.2, the method to change the webport is quite different in R12.2 Here are the steps to change Web Port in EBS 12.2 – Launch EM Console http://<s_wls_admin_host>.<s_wls_admin_domain>:<s_wls_adminport>/em) – Login as weblogic admin user (s_wls_admin_user) – Select the webtier instance from the Web Tier drop down – Select the Oracle HTTP server component and Advanced Configuration … Continue reading How to change the Web Port in EBS 12.2 »

Solaris OS parameter required for R12.2 Upgrade

R12.2 Upgrade on Solaris Operating requires the below prerequisites to be in place before starting with any upgrade steps Operating System Supported Versions The following table lists the supported operating system versions. Operating System Name Supported Version Oracle Solaris on SPARC (64-bit) 10 (5.10) – 9/10 (Update 9) or higher 1,2,6 Oracle Solaris on SPARC (64-bit) 11 (5.11) – 11.1, SRU 7, Build 5 (11.1.7.5.0) … Continue reading Solaris OS parameter required for R12.2 Upgrade »

EBS Data Model Comparison Report

Oracle provides the  EBS data model comparison report to view the static database object definition changes between two EBS releases Applicable Releases •Release 12.1.3 •Release 12.2.2 •Release 12.2.3 •Release 12.2.4 •Release 12.2.5 •Release 12.2.6 Benefits of EBS Data Model Comparison Report it help users to preview the database object definition changes before upgrading their instances from one release to another we can understand the impact of … Continue reading EBS Data Model Comparison Report »

How to resolve ORA-00904: invalid identifier

ORA-00904: invalid identifier is one of the common error seen. Reference: Oracle documentation One of the most common cause of this error Invalid identifier means the column name entered is either missing or invalid. It also Some time comes  when you used reserved word in Oracle database. Check List to resolve the ORA error  It comes when you put extra comma in the create table … Continue reading How to resolve ORA-00904: invalid identifier »

Best copy directory linux command examples

Last updated on April 22nd, 2017 at 07:13 amWhile working on development projector support activities  in Linux operation system , I often need to  backup the current working folder /directory before many any changes. Let’s see how we can do accomplished that. How to copy Files/folder from One place to another in Linux Operating system Linux Operating system provides cp command to copy the files/directory … Continue reading Best copy directory linux command examples »

ORA-00001 unique constraint violated

Last updated on April 1st, 2017 at 08:29 amORA-0001 unique constraint violated is one of the common message we often get while loading data. This error occurs when You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index. We can perform following action items for this error  You can look at the error and … Continue reading ORA-00001 unique constraint violated »

How to work with date in Oracle sql

Last updated on April 1st, 2017 at 10:02 amThis post I am trying to explain many things  about oracle date datatype like oracle sql date functions,oracle sql date format, oracle sql date comparison, oracle date difference in  years,oracle date difference in  days, oracle date difference in  months Oracle has provided date and timestamp type for storing the date and time information in the database. Date Type DATE is … Continue reading How to work with date in Oracle sql »

How to resolve the ORA-00936 missing expression

ORA-00936 missing expression is one of the common error everybody working in Oracle sql must have faced some time. This generally happens when you omit important thing in the sql statement i.e you left out an important chunk of what you were trying to run Reference : Oracle documentation This Oracle error is mainly related to the SQL SELECT statements. One obvious reason is select column … Continue reading How to resolve the ORA-00936 missing expression »