SystemsMix

[systemsmix-blog]

Oracle IMP EXP Amazon Relational Database Service (RDS)

Oracle IMP EXP Amazon Relational Database Service (RDS)

Oracle IMP & EXP Oracle imp exp. Import and export tools imp/exp are sometimes your only options when using Amazons Oracle RDS service. The reason for this is due to the file system on the database server being unavailable to you. The scenario where you would normally use impdp and expdp  to create a dumpfile and move it between servers is no longer a straight forward option. Using Oracle exp and…

View On WordPress

[systemsmix-blog]

Oracle Datapump in AWS using Network Link

Oracle Datapump in AWS using Network Link

Oracle Datapump Oracle DataPump can be complicated when using Amazons RDS offering Using Oracle Datapump when using an Oracle RDS offering from Amazon Web Services can leave you tearing your hair out in frustration. When using Oracle RDS in Amazon you do not have access to the data dump directory and as such can not use impdp/expdp. If you relay on moving databases around via dmp files as I do…

View On WordPress

[systemsmix-blog]

Bash FTP Script & Cronjob

Bash FTP Script & Cronjob

Bash FTP Scripting Creating a Bash FTP Script and installing as a cronjob can be a great way to move files around scheduled intervals . Want to move files around at set intervals? Even to internal servers sometimes the best way to accomplish this is with a bash ftp script. The below example of a bash script logs onto a remote FTP server and checks for messages before downloading them to the…

View On WordPress

[systemsmix-blog]

ORACLE Materialized View Creation and scheduled refresh

Materialized View –  Creating and scheduling materialized views in Oracle Database Oracle views can be resource hungry. Depending on how much data they contain hungry views can cause crippling performance issues when badly written. A quick and easy way to fix any identified issues  (maybe through a statspack report in order to identify the problem) is to materialize the view and schedule…

View On WordPress

[systemsmix-blog]

Install SQLPLUS on debian based systems

SQLPLUS install on Debian I have  often had to install the sqlplus instant client on debian based systems. Below I am sharing how I last went about this on Ubuntu 13.04 but the guide should be solid on other debian based distros. SQLPLUS install Ubuntu 13.04 64 Bit First download the package “alien from the ubuntu repos. This will allow you to install rpm packages on debian based systems. sudo…

View On WordPress

[systemsmix-blog]

CloudHQ It's time to get your house in order

CloudHQ I’m sure there are plenty of people out there like me with cloud storage fragmented across multiple services like Dropbox, Google Drive and Onedrive.  Today I decided to find a solution to migrate or at least sync between them all. After researching whats out there I have decided on keeping the other services instead of just using one cloud storage to rule them all! My preference was for…

View On WordPress

[systemsmix-blog]

Evernote Client Everpad Integrated with Linux Desktop

Evernote client for Linux Everpad The unofficial Evernote client on Linux Desktop. How to install Everpad 2.15.8 on Ubuntu. I’ve come to rely on Evernote over the last few years. I had tried it out a few years back but had little use of it at the time. My idea of organization used to be a hundred or so scraps of paper , crumpled in my pocket, on my desk and in my car containing illegible…

View On WordPress

[systemsmix-blog]

ORA-28000 - the account is locked

ORA-28000 – the account is locked.

If you are getting this then chances are you have entered the user/pass wrong two many times against the schema and the account has become locked. In my case I see this daily when an application has been incorrectly configured and is hammering away with invalid connection credentials. In that case simply unlocking the account will not work as it is just a…

View On WordPress

[systemsmix-blog]

Untar / extract all .tar files in a folder at once

So you have tried to untar multiple files *.tar files right? Like me you probably indistinctly used

$ tar xf *.tar

And no doubt got the unexpected result of ….

This is because tar was originally intended for use with magnetic tape devices and as such used on only one file at a time.  Turns out that to use tat on multiple files that needs to be fed  to tar one at a time. So your command would…

View On WordPress

[systemsmix-blog]

Change Message Of The Day (MOTD) Banner Amazon EC2

Permanently change the MOTD banner on AWS EC2 Amazon Linux I found out the hard way that hanging the /etc/motd file on  Amazon EC2 AMI only works until the image is rebooted. I only came to this conclusion after spending considerable time updating it with custom messages on numerous servers. On reboot I was dismayed that all my time had been wasted. To be honest I nearly just left it as default.…

View On WordPress