Arun ShindeResize your Oracle datafiles down to the minimum without ORA-03297So, how do you find this minimum value, which is the datafile’s high water mark?Mar 12, 2023Mar 12, 2023
Arun ShindeEnviroment Variable Postgresexport PG_HOME=/Postgres/pg13 export PATH=$PG_HOME/bin:$PATH export PGDATABASE=postgres export PGDATA=/Postgres/Data/Jul 28, 2021Jul 28, 2021
Arun ShindePostgres 13.0 Source code installationDownload Postgres binary(source code) from https://www.postgresql.org/ftp/source/ you can download (postgresql-13.0.tar.gz) or…Jul 28, 2021Jul 28, 2021
Arun ShindeORA-27211: Failed to load Media Management LibraryMost of the time after migration of database on new server we get following error in rman backup jobNov 13, 2020Nov 13, 2020
Arun ShindePostgres Environment VariableFollowing are the environment variable we can set in .profile or .bash_profile in the Linux-based system.Oct 17, 2020Oct 17, 2020
Arun ShindeORA-01940: cannot drop a user that is currently connectedWhen we dropping user with “CASCADE” option oracle will not allow us to drop that user because he’s session is present in database no…Jul 29, 2020Jul 29, 2020
Arun ShindeORA-00020: maximum number of processes (680) exceededConnecting through sqlplus with os authentication (sqlplus / as sysdba) didn’t work due to the same reasonMay 22, 2020May 22, 2020
Arun ShindeHow to run RMAN and Datapump job in the backgroundRun RMAN job in the backgroundJan 30, 2020Jan 30, 2020