There is no oracle recommended for reorg SYSTEM tablespace.

Looks like export dump is taken from 18c database and you are trying to import in 12.2 database. Dumps from higher version db will not work in lower version db.

So you need to take the export from 18c database with version=12.2 parameter  and then try to import the same

Below script will trigger notification if process count increase values of 50. ( You can change according to your requirement)

step 1 : 

create a sql script as

cat /home/oracle/monitor/proc_count.sql

set feed off;

select count(*) from gv$process;

step 2 : 

create a shell script as – >

cat /home/oracle/monitor/proc_count.sh

export ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1

export ORACLE_SID=ORCL

export PATH=$ORACLE_HOME/bin:$PATH

set -o vi

pro_count=`sqlplus -s ORDBA/ORDBA << EOF

set head off

set feed off

spool /home/oracle/monitor/count.log

@/home/oracle/monitor/proc_count.sql

spool off

exit

EOF`

if [ $pro_count  -ge 50 ];

then

mailx -s “TOTAL PROCESS COUNT CAN REACH MAX PROCESS  ()  ” support@dbaclass.com < /home/oracle/monitor/count.log

fi

step 3 :

configure the shell script in cronjtab:

0,10,20,30,40,50 * * * * /home/oracle/monitor/proc_count.sh > /tmp/proccount_log.log

Regards

Admin

No It is not required to restart the database  post gather stats .

Dear for if you are calculating for year 2018. You can change the year accordingly .

then

select to_char(creation_time, ‘MM-RRRR’) “Month”, sum(bytes)/1024/1024/1024 “Growth in GB”
from sys.v$datafile
where to_char(creation_time,’RRRR’)=’2018′
group by to_char(creation_time, ‘MM-RRRR’)
order by to_char(creation_time, ‘MM-RRRR’);

Regards

Admin

Try to import into the pluggable database, instead of container .

Bcoz exclusive restrict mode give access only to the database admin users , with which DBA can perform the drop database command.

Please check if new firewall has been implemented there?

It means, no patches were applied to the database .

You can check the rdbms binary for patches .

$ORACLE_HOME/OPatch/opatch lsinventory

As a fresher DBA, for first few months, you should be shadowing a senior DBA and learning how they are working on the database issues. In parallel study the database concepts , user management, tablespace management, export import utility. Practicing on a test machine would be a great idea.