Providing su access to group of users in Oracle Cloud. Add below line in /etc/sudoers.d/90-cloud-init-users %dba ALL=(ALL) NOPASSWD: /bin/su – oracloud And then restart ssh daemon services #/sbin/service sshd restart…
Read MoreOption 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 MoreTo 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 ================================================== please first note that we have SOURCE and TARGET i will provide commands to run with…
Read More–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 MoreTo 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 MoreThose 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 MoreAs 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 MoreStart 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 MoreIssue: “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 More