Reboot server to the following interface. Press key “e” Add “init=/bin/sh” which is in the red box Press key “Ctrl+x”, You’ll lonin the server without…
Possible reason 1.Couldn’t find device with uuid 2.Couldn’t find all physical volumes for volume group Example and solution
Example: extend 10GB for partition /oradata
Edit configuration file. vim /etc/my.cnf add “skip-grant-tables” in [mysqld] field. Save and exit Restart mysql servicesystemctl restart mysqld Login mysqlmysql -uroot -p Switch database to…
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…
I encountered the following error when I import a dmp file to oracle database. Processing object type SCHEMA_EXPORT/JOB ORA-39083: Object type JOB failed to create…