So it seems that I need to learn more about exactly how listeners work and how databases work with them.
And especially how to have multiple databases talking to one listener and/or having more than on listener on one box.
I’ve been trying to install a 10g database and get it to register with the listener on the box, but it won’t do it.
I’m not sure if it is something to do with the fact the listener is only version 9 or if it is something I am doing wrong.
I did some digging and found out that Postgres is actually PostgreSQL an open source database. Much like MySQL.
I setup a spare laptop with Fedora 10 and installed it and got it running OK with only a few little hitches. Mostly from not knowing a thing about it.
Looks like it would be simple enough to use, it would just be a matter of learning the new syntax for everything.
I happened to have a quick look at the jobs available at the Bureau of Meteorology yesterday. They have a “Systems and Database Specialist” position available starting at $80K.
Although I’m not going to apply for it, it has given me some ideas on how/where to improve my skills.
- Database Tuning
- AIX (not sure how I’m going to do this)
- Postgres (not even sure what this is !)
This is becoming a habit. I got called into work again today to recover a database. Its a fairly easy to do, just a hassle to have to spend the 30 minutes driving in and the 30 minutes back again.
Oh well, it’s part of the job I guess.
Setting up a network printer is a bit more difficult in Solaris than it
is in Linux.
And it can be a tick to find a helpful page on the internet.
But I did manager to find this page,
http://www2.petervg.nl/cgi-bin/docs.cgi?a=read&doc=168 and I have added
a tip to my tips database about it
I’ve been getting a very high score in my OCP practise exams lately. I feel I’m just about ready to do the real thing.
I want to do one or two more practises in ‘exam condition’ before I book the real thing though.
Theses exams make me nervous. It’s not only the fear of failing, but the fear of ‘wasting’ the $175 it costs to do the exam.
For the last few years that I have been work as a DBA here, I have always used imp and exp to import and export data to the databases.
But with our recent increased used of 10g databases I have started to use impdp and expdp.
I felt that it would be better to use these versions rather that the outdated(?) versions. But the new syntax takes a little getting used to. But then again it took me a little while to be able to type and imp/dmp command without have to look it up or use an excel cheat sheet.
EDIT : Of course the impdp/expdp are also more powerfull, allowing for schema and tablespace remapping during the import.
I read an interesting article here about monitoring the alert logs that Oracle writes. They offer some suggestions to use scripts or monitoring tools but no real information or examples.
I checked how we do it at work and remembered that I had written a script some time ago that runs grep over the alert log looking for anything starting with ORA- (any oracle error starts with ORA-).
It then pipes all this to a html file that i can access from a server that is running apache. I simple check this web page every morning to see if there were any errors i need to be concerned about.
I had problems putting the script in the post as it contains html tags. If you’d like to see if, email me at firstname.lastname@example.org. Thanks.
I read a blog post the other day about some essential steps to take before you’re laid off and some of them were basically to update your web presence. Some I’ve spent the last few days updating my profile on LinkedIn and Facebook, creating a page on Twitter and (re)starting a blog.
I configured google apps and my domain today so that I can use the address email@example.com and read the mail via a google interface.
It seems to work OK but I’m not sure if I have it setup OK or that i like it.
And i can’t seem to apply themes to my inbox on my mc account like i can my normal gmail account. why not?