Sometimes expdp jobs fail for any number of reasons. Re-running expdp, I noticed that the number had increased since the prior run; e.g., SYS_EXPORT_SCHEMA_02 instead of SYS_EXPORT_SCHEMA_01. As it turns out, these are potentially orphaned jobs, so clean ’em up! Generally, copied from Anar Godjaev’s excellent blog post: SQL> select owner_name, job_name, operation, job_mode, state, […]Read More Oracle: Cleaning up SYS_EXPORT_SCHEMA_xx jobs
Work around for this issue is to increase the amount of space allocated to db_recovery_file_dest; e.g., $ sqlplus sys as sysdba SQL> show parameter db_recovery_file; db_recovery_file_dest string /opt/oracle/flash_recovery_area db_recovery_file_dest_size big integer 20G Compare this with the output of ‘du -sh’; e.g., $ du -sh /opt/oracle/flash_recovery_area 21G /opt/oracle/flash_recovery_area 21 vs 20, so set it to something […]Read More ORA-00257: archiver error. Connect internal only, until freed
I quickly pressed Windows Key + q to open the Search box and typed in: turn windows features on or off Turn windows features on or off I scanned a few options but one in particular was salient: Hyper-V was enabled. So I installed the 64-bit version of Docker for Windows after configuring a shiny new VirtualBox CentOS 7 […]Read More SOLVED: VirtualBox shows only 32-bit guest versions on my (64-bit) Windows 10?
Received this error whilst make-ing oci8 for PHP. It was a fresh install of 64-bit CentOS 5.4 w/ Oracle XE 10g installed; e.g. $ sudo make . . . /usr/bin/ld: skipping incompatible /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so when searching for -lclntsh /usr/bin/ld: cannot find -lclntsh $ So I checked for /usr/lib/oracle/10.2.0.4/client/lib/libclntsh.so — it was there, but for some reason […]Read More Skipping incompatible lclntsh
This set of commands helped me resolve ORA-01653 quickly. First we need to find out the path to the appropriate datafile(s): $ sqlplus sys as sysdba SQL> select name from v$datafile where name like ‘%system%’; NAME ——————————————————————————– /oradata/dgs3/system01.dbf 1 rows selected. There’s only one datafile, so we’ll need to check if the /oradata (or /) […]Read More ORA-01653: unable to extend table SYSTEM.AUD$
So I’ve downloaded and installed Fedora 12 for the work laptop for awhile now. Previously it was Linux Mint 7/8, but I haven’t actually used the machine yet, as I encountered that darned OCIEnvNlsCreate() error message again. Same setup, just Oracle Express 10 on Linux, except the distro is Fedora this time. So I was […]Read More OCIEnvNlsCreate() failed again
Should you update /etc/hostname — I did — be sure to update the default tnsnames.ora and listener.ora. Mine were found in /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin. Otherwise you’ll get an ORA-12541 message.Read More Changing hostname