Memory nearly exhausted in one oracle database server.Almost 100GB is occupied. As we know,oracle memory is made up of PGA and SGA,so I generate awr…
Deploy Oracle database software Following works will be finished firstly. You can login server node1 with x-windows or gnome by user oracle. Switch directory to…
Deploy grid cluster software Following works will be finished firstly. You can login server node1 with x-windows or gnome by user grid. switch directory to…
External shared storage preparation For details about external shared storage,you can view the following table Add external shard disks for node1 and node2 You must…
Introduction of hardware and software There are 2 nodes(virtual machine) included in this rac cluster. The details about them as shown in following table. Basic…
Check job SQL>SET LINE 500;SQL>col WHAT for a200;SQL>select SCHEMA_USER, job, what from dba_jobs; Delete job (for example,the job number is 4003) SQL>exec dbms_job.remove (4003);
Export full database with compression option expdp username/password directory=logical_directory dumpfile=dump_name_$date.dmp logfile=dump_name_$date.log compression=all Export full database without compression option expdp username/password directory=logical_directory dumpfile=dump_name_$date.dmp logfile=dump_name_$date.log Export a…
Background When I export data from oracle database, I encountered error “ORA-01555: snapshot too old: rollback segment number with name “***” too small” Soluton Check…