Jump to content

DBA in Space


Casper

Recommended Posts

Pr0n is my calling in life, to pay the bills, I do the IT thing....for almost 22 years, 20 of it as an Oracle DBA, and have played around on SQL Server, MySql, etc....but for some odd reason I have found folks pay more for a good Oracle DBA. And since I have a personality, and can talk to non-technical folks in such a way they can understand technical issues, they keep me around.

Then Casper sends me this DBA in Space, and the damn questions are using RedGate's damn management software on a SQLServer database....bastages....

Link to comment
Share on other sites

I cut my teeth on FridayForm (older than the internet - I can't find proof it ever existed?) and then moved up to Delta. My first summer job was developing a relational database for BS5750 compliance (precursor to iso9000) for a company that made pressure vessels. I was 16, and yes, they got their certification.

I passed through MS Access like a White Castle Slider (spending less than a year of my professional life on it, yuck). Now I work SQLServer and Mysql. Mostly mysql these days. I have used every type of database out there (oracle, postgres, db2, sybase etc) but only been a DBA for SQLServer and Mysql.

So it's been about 21 years since my first DBA job. Wow I feel old now.

Link to comment
Share on other sites

Bitch please.

select dba from company into spaceship where name = 'Scruit';

You missing something.....

CREATE TABLE spaceship

(name char(50),

launch_date date)

Then we can see who's going up when...

select * from spaceship where name = '<astronauts_name>' order by launch_date

And I bet there's a good bit I could learn from Red. In my line of work our clients could be using M$SQL or Oracle for the back end DBs. And if the clients are doing multisite implementations they have to use Oracle for the DB replication (that's the only one that's supported for now). Got any experience with replicated instances Red? LOL!

Link to comment
Share on other sites

Scruit is very correct, Oracle's pricing is expensive. This is why so many people are going with SQL Server and MySQL, even with "lesser" performance.

As far as replication via Oracle, I'll give the patented Oracle answer, "it depends". Dataguard is one of the simplest forms of data replication, but most folks use streams to facilitate replication of data.

Anyone can ask Casper, I am the laziest person in existence(except for Pr0n). How can you define me as lazy? i.e. - Question - What is the definition of a lazy white boy? Answer - A man who marries a woman who is already pregnant! Both times I've been married, both of my wives already had kids, so that makes me the "Laziest White Man" in history!

Ok, back to the replication issue....if you are licensed for it, dataguard is the way to go. Under 11g, use OEM(aka GRID) to create a physical standby via archivelog shipping. Under 10g, OEM was flaky for dataguard creation, I have some instructions that might be able to help you. Anything earlier, and streams are your main choice, or use the RMAN duplicate on a periodic basis.

Feel free to shoot me email/questions at either redbarron77@yahoo.com or Mr.Ed@tamu.edu.

I'm really damn good with Oracle, but I will never say I am an expert. Don't have all the answers, but I have quite a few of 'em!

Link to comment
Share on other sites

Thanks for the offer Red. I might take you up on it in the future.

With what we install and configure using Oracle the distributed multimaster method is always used. No streams or dataguard, just advanced replication. I have a stack of Don Burleson authored Rampant books that I reference more often than I like but they've been very handy. We have written some code and we sell a service for replicated environment remediation. Too many times we've seen database inconsistencies between sites and we never have a good way to fix those problems (short of removing the site and recreating it :nono:). Once we dug into it we found there are some internal procedures that can fix things, but there's always a catch. For us it's the use of LOB objects in some tables....total pain in the ass to deal with. Then you can have package and package bodies that get corrupt or the stupid DBMS jobs fail for some reason and they clients don't know to restart the job and there's 20k transactions pending....uuhhhgg.

Such is my life. :(

But I'm start in on learning SharePoint and thusly that comes jam packed with a M$SQL backend. Yippie!

And I have some really good stories about Oracle implementations, Oracles "DBAs", and the costs associated. :nono:

Link to comment
Share on other sites

We all know what Red does for a living. He cruises porn sites for OR. He's on the payroll.
He should be on the payroll.
And if the clients are doing multisite implementations they have to use Oracle for the DB replication (that's the only one that's supported for now). Got any experience with replicated instances Red? LOL!
If old Ed can't help, I can. Replication, clustering, DR, and heterogeneous integrations are kinda my specialties. That goes for Oracle, MS SQL, and MySQL. I'm a high safety high availability guru. :)
Anyone can ask Casper, I am the laziest person in existence(except for Pr0n). How can you define me as lazy? i.e. - Question - What is the definition of a lazy white boy? Answer - A man who marries a woman who is already pregnant! Both times I've been married, both of my wives already had kids, so that makes me the "Laziest White Man" in history!
The only person I've ever met so lazy that he actually created an environment alias l="ls -al". :lol:
Link to comment
Share on other sites

Thanks for the offer Red. I might take you up on it in the future.

With what we install and configure using Oracle the distributed multimaster method is always used. No streams or dataguard, just advanced replication. I have a stack of Don Burleson authored Rampant books that I reference more often than I like but they've been very handy. We have written some code and we sell a service for replicated environment remediation. Too many times we've seen database inconsistencies between sites and we never have a good way to fix those problems (short of removing the site and recreating it :nono:). Once we dug into it we found there are some internal procedures that can fix things, but there's always a catch. For us it's the use of LOB objects in some tables....total pain in the ass to deal with. Then you can have package and package bodies that get corrupt or the stupid DBMS jobs fail for some reason and they clients don't know to restart the job and there's 20k transactions pending....uuhhhgg.

Such is my life. :(

But I'm start in on learning SharePoint and thusly that comes jam packed with a M$SQL backend. Yippie!

And I have some really good stories about Oracle implementations, Oracles "DBAs", and the costs associated. :nono:

Multimaster eh? For load balancing or for mobile databases?

Link to comment
Share on other sites

Multimaster eh? For load balancing or for mobile databases?

Neither, strictly just to have the data in two places for speed and accessibility needs of different geographical locations. Back when long distance network connections were stupid expensive and slow this was their solution. Put a copy of the database local to each place that needed it.

Link to comment
Share on other sites

Neither, strictly just to have the data in two places for speed and accessibility needs of different geographical locations. Back when long distance network connections were stupid expensive and slow this was their solution. Put a copy of the database local to each place that needed it.
Ah. Are they looking to move away from that setup or continue using it that way?
And on top of the database replication we have to deal with vault (aka file) replication to boot.
Vault as in Autodesk Vault?
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...