Ameer Khan

As of now, you need to manually refresh a refreshable clone of an autonomous database every seven days to keep it up to date by logging into Oracle Cloud Infrastructure (OCI) Console. In this post, I call a REST API to refresh an autonomous database clone. By scheduling the bash script in crontab, you can… Continue Reading

Before you implement a web application firewall (WAF) in Oracle Cloud Infrastructure (OCI), you need to configure your web server to accept traffic from the WAF servers. The WAF documentation gives a list of CIDR range that you need to add into your security list. So, how can you add all these entries to your… Continue Reading

Database link is useful for allowing data queries from one database to another instantly without needing to schedule batch activity that pulls the data together. You can also pull data into a staging table and perform transformation in an extract, load, and transform (ELT) process. Database link helps secure your data too. Imagine an employee… Continue Reading

List of database parameters that should be removed from database initialization parameter file in oracle 19c  Following are the parameters that can be removed if found present in a parameter file. kks_use_mutex_pin_shared_pool_reserved_min_alloc_sqlexec_progression_costalways_anti_joinalways_semi_joinbackground_dump_destcore_dump_destdb_block_buffersdb_cache_sizedb_file_multiblock_read_countdrs_startenqueue_resourcesevent=”10932 trace name context level 32768″event=”10933 trace name context level 512″event=”10943 trace name context forever, level 2″event=”10943 trace name context level 16384″event=”38004 trace name… Continue Reading

MySQL Database service in Oracle Cloud Infrastructure (OCI) are highly secure. We can’t connect directly to the MySQL endpoints stated in the console through a public network. To connect to MySQL Database service in OCI, we can either connect from within an OCI tenancy or establish a VPN or FastConnect and connect from other cloud… Continue Reading

Every application that runs in a server environment generates logs automatically. These logs provide important information about how a system is operating and how it operated in the past. By searching through log data, you can pinpoint issues and act before something goes wrong. However, looking at hundreds or thousands of different logs across different… Continue Reading

Convert database to physical standby command errored with ORA-01017: invalid username/password; logon denied So during execution of convert to physical standby using dgbroker utility , an error of ORA-01017: invalid username/password; logon denied is observed. [oracle@server1]$ dgmgrl /DGMGRL for Linux: Release 19.0.0.0.0 – Production on Thu Jan 19 02:11:48 2023Version 19.16.0.0.0 Copyright (c) 1982, 2019, Oracle… Continue Reading

Many organizations today are relying on finance and sales business users to provide business forecast for upcoming seasons. You might have historical data for past few quarters or even past few years. Forecast is part of predictive analytics. Predictive analytics is used to make estimations about unknown future events, based on many techniques from machine… Continue Reading

We had a situation where in multi standby database environment , one of the standby database was lagging behind from the primary database. The log gap between primary and standby database was pretty huge. However, in primary we had the archives present so eventually after disabling/enabling LOG_ARCHIVE_DEST_3(As this was pointing to the 2nd standby site) the… Continue Reading

The movement of workloads to the cloud is unstoppable. But, this movement means that you have to monitor more workloads than ever to ensure that they’re safe for external and internal users. According to Oracle and KPMG Cloud Threat Report 2020, 92% of organizations have a cloud security readiness gap, and 59% of them have… Continue Reading