MICROSOFT WINDOWS 19C DATABASE CREATION
STEPS TO CREATE 19C DATABASE IN MICROSOFT WINDOWS STEP…
Read MoreScript to create trace at database schema level by using trigger
Please create the below and disable or drop the trigger once completed. create or replace trigger set_trace after logon on database begin if user not in (‘SYS’,’SYSTEM’,’SYSMAN’,’OLAPSYS’) then execute…
Read MoreMigrate to Oracle Cloud Database within “1-Click”
Introduction: Oracle provide a tool called MV2OCI(Move to Oracle Cloud Database) and it is a new tool is permitting the load data and migration from “on premises” to Oracle Cloud…
Read More11G to 19c autoupgrade failled with ORA-00904 Error
Introduction: During 11.2.0.4 database upgrade to 19c, Autoupgrade fails with error – NVL(bundle_series,’0′)||’#’|| * ERROR at line 3: ORA-00904: “BUNDLE_SERIES”: invalid identifier ] [ORCL] – ExecuteSql$SQLClient.run NVL(TO_CHAR(action_time, ‘DD-MM-YYYY HH24:MI:SS’),’0′) ||’#’|| NVL(action,’0′)||’#’||…
Read MoreTXK Delta 13 failed due to missing files
TXK Delta 13(32392507) plus critical TXK patches 33550674, 33535778 failed because of missing files adsign.txt and adkeystore.dat under $APPL_TOP_NE/ad/admin The Solution: The apply phase failed twice, once when looking for…
Read MoreAdop Phase=cutover Failing With AutoPatch – AidafoGetFileDbVersion: INFO: ORA-01403: No Data Found
AutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch Please follow below steps to overcome this issue Confirm that value for READ_ONLY_FLAG and ENABLED_FLAG…
Read MoreCost estimate with AWS Pricing Calculator
How to create a cost estimate with the AWS Pricing Calculator? Concepts: Create a logical pricing group. Create weekly, monthly, and yearly estimates for Amazon EC2 instances. Step 1: …
Read MoreWonders in AWS RDS – Good Deployment techniques
Introduction Amazon Web Service offers a diverse range of products and services to clients across the globe and shapes. Amazon RDS is one of the most popular and notable services…
Read MoreHUGE PAGES CONCEPTS
HUGE PAGES What are Huge Pages? Linux Manages memory in pages while loading data from disk to memory or writing back to disk from memory. Huge pages is a…
Read MoreOracle Blob and Clob Datatypes
CLOB and BLOB are two types of data types used in databases to store large amounts of data. BLOB: BLOB, or Binary Large Object, is used to store binary data such as images, audio, video, and other multimedia objects. It is an extension of the VARBINARY data type and can store up to 2GB of data.Using CLOB and BLOB data types can be beneficial in many situations. CLOB:CLOB, or Character Large Object, is used to store textual data and is used for large strings of text. It is an extension of the VARCHAR data type and can store up to 4GB of data if you have a large document or image you need to store, you can use a CLOB or BLOB data type to store it.storage space is occupied more in the database, so you should be careful about when and how you use them. To query for CLOB or BLOB datatypes,…
Read More