PinnedLinux File PermissionsPermission Groups owner — The Owner permissions apply only to the owner of the file or directory, they will not impact the actions of…Jul 18, 2023Jul 18, 2023
ICM is still not down. Waiting for another minuteIn the adop patch cycle cutover phase, the adop log shows the below message.Dec 26, 2024Dec 26, 2024
ORA-19913: unable to decrypt backupWhen restoring the controlfile as a step of the database restoration, the following error occurred due to the wallet not being opened.Oct 8, 2024Oct 8, 2024
a database link connected to a database with a different name. The connection is rejected.I’ve created a database link between the on-premise database and OCI DBCS(19c). A database link is created successfully, but an error…Aug 9, 2024Aug 9, 2024
How to automatically copy files to object storage using OCI CLI commands.(oci: command not found)I've scheduled an RMAN backup on an OCI Database server and need to copy all those backup pieces to the Object Storage daily. So, I've…Jul 18, 2024Jul 18, 2024
How to export ORACLE_SID,ORACLE_HOME and PATH correctlyI keep receiving the following error messages when trying to log in to the Oracle database.May 18, 2024May 18, 2024
How to create Weblogic URL and find Ports from R12.2 Context File1. Go to Application Tier 2. Set the RUN file system environment. 3. ExecuteMar 25, 2024Mar 25, 2024
Create a profile and add usersWhen attempting to change the password for the TEST user, I encountered the following error.Feb 17, 2024Feb 17, 2024
How to reset schema password without any length restriction criteria in Oracle Database?alter user DBO identified by DBO;Feb 17, 2024Feb 17, 2024
ORA-12529: TNS:connect request rejected based on current filtering rulesTry to connect to the Autonomous DB using CMD through the Oracle client tool.Jan 20, 2024Jan 20, 2024
Connecting to Autonomous Database using 19c Oracle Client toolsInstall the Oracle client Administrator type.Jan 19, 2024Jan 19, 2024
How To Connect SQL Developer to the Serverless Autonomous DBDownload the wallet file.Jan 17, 2024Jan 17, 2024
ORA-01110,ORA-01111,ORA-01565,ORA-27037,ORA-01274There are numerous errors in the alert log during these occurrences. Here's a summary of the problem.Dec 7, 2023Dec 7, 2023
ORA-10456: cannot open standby database; media recovery session may be in progressSQL> SELECT INST_ID,NAME,LOG_MODE,OPEN_MODE FROM GV$DATABASE;Oct 16, 2023Oct 16, 2023
How to find the Oracle database password file’s fingerprintSyntax: md5sum <file_name> md5sum <orapwSID>Sep 25, 2023Sep 25, 2023
How to change password file location and verify in Oracle ClusterwareTo verify the location execute below.Sep 22, 2023Sep 22, 2023
How to copy password file from OS level to ASM levelSyntax: pwcopy — asm <OS level passwd file location & file> <ASM Location>Sep 22, 2023Sep 22, 2023
ORA-44787: Service cannot be switched into.The Easiest way to resolve this issue is to restart the PDB.Sep 21, 2023Sep 21, 2023
Creating a Password File with ORAPWDThe syntax of the ORAPWD command is as follows:Sep 19, 2023Sep 19, 2023