ORA-00257: archiver error. Connect internal only, until freed

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

SOLVED: VirtualBox shows only 32-bit guest versions on my (64-bit) Windows 10?

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?

Skipping incompatible lclntsh

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

ORA-01653: unable to extend table SYSTEM.AUD$

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$

OCIEnvNlsCreate() failed again

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

Changing hostname

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