Wednesday, June 29, 2022

ORA-01017: incorrect username/password, login denied when using a wallet

›
If you find yourself in the situation where you cannot make a connection using your wallet because of the error ORA-01017: incorrect us...
Tuesday, June 28, 2022

List parameters in a container database

›
To see the list of parameters in a container database, use can use the following query. select name,value,display_value, default_value,...
Tuesday, June 21, 2022

What is the difference between mkstore and orapki?

›
The difference is mainly that the orapki tool is dealing with certificates rather than the wallet itself. The mkstore is more of a tool for...
Friday, June 17, 2022

How to solve ORA-17628: Oracle error 1031 returned by remote Oracle server ORA-01031: insufficient privileges when cloning a non-cdb oracle instance to a PDB

›
When attempting to clone my database testdb01, a normal, non-cdb database, into a CDB and convert it to a PDB, I hit a permission error. I...
Tuesday, June 14, 2022

How to alter a flashback data archive that needs additional quota

›
SELECT F.FLASHBACK_ARCHIVE_NAME, F.TABLESPACE_NAME,F.QUOTA_IN_MB, (SELECT ROUND(SUM(S.BYTES)/1024/1024/1024) FROM DBA_SEGMEN...
Tuesday, May 31, 2022

How to solve ORA-65035: unable to create pluggable database from PDB$SEED

›
The error means: oerr ora 65035 65035, 00000, "unable to create pluggable database from %s" // *Cause: An attempt was made to ...
Wednesday, May 11, 2022

Find available directories on your server

›
set lines 200 col directory_name format a30 col directory_path format a60 select directory_name,directory_path from dba_directories; exit ...