The Never Ending Search For a Better Life or Why I Need to Develop Again

Hi folks,

I’ve created this blog for a purpose. To share knowledge, to document details of some tasks to remember faster about little caveats and to be seen. However, write it down in a way that everyone could understand, and sometimes, the need to argue with an “I know everything after find on google” genius takes some time, so I prefer to write a really good post once in a while instead to write a lot of mediocre posts every day.

All of it started some time ago when I’ve realized that I was not fitting in here anymore (Brazil). The turning point was when, again, more than 50% of voting people had chosen our actual president.

When you dislike something so hard, an event can break some chains and that was what happened to me. To everywhere I’d look, I felt bad, and a lot of minor people’s acts started to piss me off very quickly.

Some days after, I saw a news about people choosing Canada to learn English by its low costs and etc., so, as my English was too rusty (in fact, I’d never attend a class for more than two months), it gave me the idea to learn to talk English once and for all, because, without it, it was useless to do any planning about leaving the country.

As going to Canada to increase my English would be out of my budget, I started to save some time to study online. However, I did some research about how people come back after study in Canada, and to my surprise, almost all of them said: “I want to go back [to Canada] and stay forever”.

Well, one thing brings you to another, so I started to research about Brazilians in Canada. I’ve found a lot, and no one complaining, really… Being said that, to live in Canada became my new dream, and believe, a lot of levels higher than the last one.

I started to study about immigration processes and the IT market. About two months of Brazilian’s YouTube channels, showing all the marvels of living in a fair country, led me to start my family’s processes to leave Brazil.

Well, as many of you may know, it is not a simple task. Indeed, it is very hard, but not impossible. There are more than 50 ways to immigrate, but it will directly depend on your profile. IT market is hot in Canada, but they seek for very specific specialists, so a job offer overseas is almost impossible for me, as a jack of all trades. The government process is quite difficult too. You have to reach some points to be eligible to go there and look for work, but most of the points are given for who already worked and/or studied there unless you are a Ph.D. with band 8+ IELTS.

There are provincial processes too, they are less tough, however, you must be there already. What remains? Colleges and Universities. Yes, you can go there to study in a public institution and get the right to work there for a time. It will increase a lot your chances to be eligible for one or more of the immigration processes. In fact, it is the easiest way, if you have a lot of money, because of international students, on average, pay CAD 10k more for the year than the natives. So, be prepared to spend from CAD 20k to 30k for a year, the cost of living included (it is an estimate provided by their government website).

I’ve decided to specialize in something related to Software Development. There are so many reasons that I could forget to list all of them, but I’ll give a try:

  • You will never be an ex-Developer. As a DBA I need to code and to review codes a lot;
  • I feel slightly happier when I finish a code than when I finish a Database troubleshooting (may I say that it is more like a relief);
  • It is quite easier and faster to learn new technologies and almost all of the jobs don’t need so much experience . For SysAdmin and DBA roles, 8+ years of experience and a lot of certifications are common requirements;
  • This article: Tech Jobs Will Boom In Canada, But Country Lacks People To Fill Them;
  • Work as a freelancer. The best way to gain money independence nowadays. (I’m not against work as an employee, of course. In fact, you can do both (as I always did)).

See you there…


How to migrate a database from Oracle 10g RAC to 11g RAC with ASM – Part II

Let’s continue with the migration.

In the last post I made a summary of how I deal with the installation of Oracle Linux 6 and Oracle 11g. You can see it here.

After all installed, it’s time to create the databases and tablespaces. It is not mandatory, you can follow a lot of material that teachs you to do a full expdb (Data Pump), but I had some errors doing that so I preferred to import only schemas.

I’ve created the databases (instances) with their charsets, language and other specific parameters as they were set on the old machine. I’ve created the tablespaces and set the datafile’s definitions (in my case, big file with auto increment).

Continue reading

How to migrate a database from Oracle 10g RAC to 11g RAC with ASM (new machine)- Part I

Hi. I wrote this post as a reminder of how I migrated an Oracle 10g Rac database to 11g. I will focus on what is not given the right attention in the documentation. Talking about that, here is the Oracle Database Online Documentation 11g Release 2 (11.2)

At first, I need to expose some facts about this operation.

  1. The 10g databases were little weird because some production tablespaces were shared with dev environments;
  2. Without the proper training, it hurts a lot and that was my case, so please excuse me about something obvious that I may comment;
  3. The Oracle documentation is good, but you have to know some secrets. It is not a step by step, as some people are used to;
  4. Unfortunately, some community members don’t want to help. They just send you go training;
  5. If you want to use Oracle, pay for their support. It is a must have. The community is open, but some situations are so unique that it’s hard to find a complete solution. You will need to sum up all that you are gathering and process it. Oracle’s support page can save precious time;
  6. The last, but not the least. This Oracle environment  has almost all of our third-party databases, each one with their own character sets, languages, plugins and etc. It had a converted database from Dataflex that was used by a legacy ERP with a 3rd party driver.

Continue reading

How to solve the problem when Enterprise Manager refuses to start and all you have tried didn’t work


Some days ago I had some problems with Enterprise Manager. After a problem with space on disk, one of the instances of the EM refused to start after cleaned the logs that was filling the system disk.

As other instances came back to work normally, I thought that the problem was in the configuration and I reset it using EMCA. It didn’t work. I tried to solve every error that appeared in logs and anything worked. Every time I tried to start it, it took about 10 minutes to show me the failed status.

Finally, I have reached an uncommon error saying that a configuration file was given a wrong parameter. I revised it a lot of times and didn’t find the wrong parameter. As a last try, I changed some parameters to force an error and possibly get some advice from the logs. For my surprise, the user oracle couldn’t save the file. I was using vim at this time. So I change the ownership of the file to oracle and voilá, EM started. So, it’s a reminder to review my permissions.