Where is TNSNAMES.ORA Location
What is TNSNAMES? Whenever we need to connect to the database, we usually provide a connection string like this: SQL> conn hr/hr@chicago-db-server:1521/ORCL Connected. Or we… Read More »Where is TNSNAMES.ORA Location
Where is ORACLE_HOME Location
ORACLE_HOME Location ORACLE_HOME is the location of Oracle database home directory, which contains many important file relationship we may use them very often. To find… Read More »Where is ORACLE_HOME Location
How to Resolve PRCC-1016 : ORCLCDB was already stopped
PRCC-1016 Found an error PRCC-1016 when I tried to stop a RAC database. By the way, it's a Container Database (CDB). [oracle@primary01 ~]$ srvctl stop… Read More »How to Resolve PRCC-1016 : ORCLCDB was already stopped
How to Replace OPatch
In this post, I'm trying to design the best practice to replace the old OPatch utility with the new one, either in single-instance or RAC… Read More »How to Replace OPatch
How to Resolve ORA-22930: directory does not exist
ORA-22930 Tried to grant read write privilege on a directory object to a user, but it failed with ORA-22930. SQL> GRANT READ, WRITE ON DIRECTORY… Read More »How to Resolve ORA-22930: directory does not exist
Where is Audit File Location
AUDIT_FILE_DEST (ADUMP) The audit file location AUDIT_FILE_DEST, also known as ADUMP may be different from version to version. For 10g and later releases Conventionally, we… Read More »Where is Audit File Location
How to Clone PDB with TDE
Before entering our topic, I assumed that you have already know how to clone a PDB to another CDB. In this post, I will show… Read More »How to Clone PDB with TDE
How to Resolve ORA-28365: wallet is not open
ORA-28365 There're several possibilities about Transparent Data Encryption (TDE) that throw ORA-28365. Wallet is not configured. You should configure a wallet for your database. Wallet… Read More »How to Resolve ORA-28365: wallet is not open
Where is DBCA Log Location
DBCA Log Location Two locations that you can see the trace log of Database Configuration Assistant (DBCA). DBCA log location The file path and name… Read More »Where is DBCA Log Location
Where is NETCA Log Location
NETCA Log Location Two locations that you can see the trace log of Net Configuration Assistant (NETCA). NETCA log location The file path and name… Read More »Where is NETCA Log Location