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

Apple Special Event

Apple Park, it starts with the first event held today at the Steve Jobs Theatre. Today at Apple, it seems to be huge. I can’t attest to this though, haven’t been at the Orchard Road one. Apple Watch No. 1 apparently, leapfrogging Rolex. New heart rate metrics (e.g., resting heart rate, recovery rate) in watchOS […]

Read More Apple Special Event

Linux: Ifconfig and its replacement

Recently I installed CentOS 7 Minimal, and lo and behold, command not found. As it turns out, ifconfig while you can still get via ‘yum install net-tools‘, we should be a bit more forward looking, and use it’s designated replacement. To quote Doug Vitale’s excellent article: some Linux tools that, while still included and functional […]

Read More Linux: Ifconfig and its replacement

Hiding page breaks in Excel

I’d successfully hidden ’em distracting grid lines in Excel via (Ribbon) > View > Gridlines, but then I wanted to hide (similarly distracting) page breaks. As it turns out, this option is pretty well hidden: File > Options > Advanced > Display options for this worksheet > Show page breaks Also note that this option […]

Read More Hiding page breaks in Excel

Windows 10: Multiple displays

I use my 23″ monitor as the main display when paired with my 14″ Windows laptop (HP EliteBook 840 G3). 150% display scaling is fine with 23″ of glorious, screen real estate, but eye-achingly small on just 14″; i.e., when I go for meetings. As a result, I’d toggle between 100% and 150% display scaling, […]

Read More Windows 10: Multiple displays

“ORA-24454: client host name is not set” when connecting from Ubuntu instance on AWS EC2

So I have this Ubuntu client connecting to Oracle Database (the server). Changed its host name late last week, and then the users realized that the app is no longer working correctly… Thankfully, it’s a configuration issue which I resolved with help from Stack Overflow (of course). Simply update /etc/hosts with the correct host name […]

Read More “ORA-24454: client host name is not set” when connecting from Ubuntu instance on AWS EC2