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 MoreProject wise PO details Reports
Project wise PO details Reports SELECT ipd.project_number PROJECT_NUMBER, ipda.asset_tag_id TAG_NUMBER, translate(ipd.description,’ä’,’a’) Project_Desc, Translate(ipda.asset_desc,’ä’,’a’) Asset_Desc, — prh.segment1 req_number, …
Read MoreHow to add expense items type in expense template
Add Expense type in Expense template Navigation AP setup user à Setup à Invoice à Expense Report Templates Name Expense Category Tax Code GL Account Projects Expenditure Type Policy Schedule…
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 More