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

CentOS: httpd invalid command

Was configuring a CentOS 6 server recently, and I decided to comment out all httpd (i.e. Apache) LoadModule directives. Upon restart, there were several invalid commands, so I took the time to note ’em down as it wasn’t obvious (to me, at least) which commands were provided by which modules. I liken this to a […]

Read More CentOS: httpd invalid command

Windows, Linux (and Samba)

I needed to copy a 140MiB file from a Windows 2000 server. The only problem was that it didn’t support FTP (or SFTP) and I couldn’t download FileZilla Server since there was no network connection. I asked my colleague for a quick fix to this, and I can’t recall what he said, but suddenly I […]

Read More Windows, Linux (and Samba)

Using ‘grep’ with Subversion

I use ‘grep’ alot, but it false positives when searching in a Subversion working copy. So I’m using the ‘-r’ flag to recursive search for the phrase ‘quick brown fox’: $ grep -r ‘quick brown fox’ * app/controllers/users_controller.php: quick brown fox app/controllers/.svn/text-base/users_controller.php.svn-base: quick brown fox This is only a minor annoyance if there are just […]

Read More Using ‘grep’ with Subversion

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