What is Not Null constraint in oracle Not Null constraints in oracle are used to enforce not null values in the column in the table. So if you try to insert null into that column, it will throw an error. How to create not null constraint Not null constraints are defined at the table creation […]
How to create not null constraint in oracle Read More »
Introduction Oracle Check constraint is used to enforce integrity rules based on logical expressions, such as comparisons. The logical expressions used should return the boolean value. Example A CHECK constraint on employee salaries so that no salary value is greater than 100000. A CHECK constraint on department locations so that only the locations “DELHI”, “PATNA”,
How to use check constraint in Oracle Read More »
We often get “Network Error: Software Caused Connection Abort” when the connection is idle for some time to the server. This happens because some network firewalls terminate the connection if no data is sent through the network through either direction after some time This issue can be very irritating as you have to log in
How to resolve Network Error: Software Caused Connection Abort Read More »
Introduction to NLS/MLS NLS : National language support. Being able to run an application in 1 language. This language can be any supported language.It basically means the ability to run an Applications instance in any one of the supported languages (other than American English), including certain region/territory specific numeric and date formats. Only the customer-facing
Multi Language Support in 11i/R12 Read More »
Upgrade to 19c Oracle database with EBS created a new service EBS_<PDB>. And all the connection from apps goes through that service. It is seen that this service disappear on server reboot and database reboot. $ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 – Production on 29-APR-2020 16:32:48 Copyright (c) 1991, 2019, Oracle. All rights
EBS PDB service name disappear from listener in 19c Read More »
R12.2 Upgrade consists of following part Pre Upgrade preparation steps Main upgrade using Main Upgrade Driver for R12.2.0 (merged with pre-installed Oracle E-Business Suite Consolidated Upgrade Patch for R12.2.0) Online Patching Enablement Applying the latest R12.AD.C.Delta.n and R12.TXK.C.Delta.n Applying 12.2.n Release Update Pack (RUP) We have already taken care of part 1 in previous Post
Step by step upgrade process to R12.2 Upgrade part -2(Main Upgrade Driver for R12.2.0) Read More »
