Server login details like who and when logged in OCI server
Option 1: We shall schedule this periodically to get the report cat /var/log/secure* | grep Accepted Option2: We shall use last or lastb command. This will give login and…
Read MoreCreating a Swap File in OCI
To add a swap file: Determine the size of the new swap file in megabytes and multiply by 1024 to determine the number of blocks. For example, the block size…
Read MoreHow to fix an “out of Sync”:repair table Shareplex replication in oracle database
How to fix an “out of Sync”:repair table Shareplex replication in oracle database ================================================== please first note that we have SOURCE and TARGET i will provide commands to run with…
Read MoreSharePlex tips
–setup shareplex steps 1. install shareplex software at source and target2. startup shareplex at source and target3. stop post at target4. activate config config_file at source5. select current_scn from v$database;…
Read MoreHow to Add LDAP Users and Groups in OpenLDAP on Linux
To add something to the LDAP directory, you need to first create a LDIF file. The ldif file should contain definitions for all attributes that are required for the entries…
Read More"Verify Access Signing Certificate in Settings" in OCI when running curl REST calls
Those days I was trying to retrieve some OCI Json data using REST calls via curl. However, even though I’ve set up an application and Client ID and Secret accordingly,…
Read MoreThe best upcoming features in Oracle Database 19c
As we DBA’s are always excited about the upcoming features, I will share below some of the main things that I’ve spotted on OOW. Please note that this can change,…
Read MoreREST API for Oracle Database Cloud Service:
Start a Backup Operation POST /paas/service/dbcs/api/v1.1/instances/{identityDomainId}/{serviceId}/backups Starts an on-demand backup for a Database Cloud Service instance. Request Supported Media Types application/json Path Parameters identityDomainId: string serviceId: string Header Parameters Authorization:…
Read MoreThe server is asking for your user name and password. The server reports that it is from XDB.
Issue: “The server” “is asking for your user name and password”. “The server reports that it is from XDB” Got the above error while accessing the apex application page and…
Read MoreInternal Concurrent Manager logfile Error : Routine &ROUTINE has attempted to start the internal concurrent manager.
Internal Concurrent Manager logfile Error : Routine &ROUTINE has attempted to start the internal concurrent manager. Issue : Users encounter the following error in the Internal Concurrent Manager logfile: Routine…
Read More