Tuesday, February 27, 2024

DBT-05509 when creating pluggable database using DBCA from command line

An odd occurrence when trying to create a pluggable database in a newly created container database.

This is Oracle 19c on Windows, but it will likely apply to other platforms as well.

I am able to connect to the database using SQLPlus.exe.

However, when I try to run DBCA from command line, I get the errors shown below.


 PS D:\backup> dbca.bat -silent -createPluggableDatabase -pdbName PSEUDONIMOUSPDBNAME  -sourceDB PSEUDONIMOUSCDBNAME -createPDBFrom DEFAULT -createUserTableSpace true -pdbAdminPassword PSEUDONIMOUSPASSWORD -sysPassword PSEUDONIMOUSPASSWORD

[FATAL] [DBT-05509] Failed to connect to the specified database (PSEUDONIMOUSCDBNAME).

   CAUSE: OS Authentication might be disabled for this database (PSEUDONIMOUSCDBNAME).

   ACTION: Specify a valid sysdba user name and password to connect to the database.

 I had forgotten to add my username to the ORA_DBA and ORA_OraDB19Home1_DBA groups.

After doing so, it worked without issue...

 PS D:\backup> dbca.bat -silent -createPluggableDatabase -pdbName PSEUDONIMOUSPDBNAME  -sourceDB PSEUDONIMOUSCDBNAME -createPDBFrom DEFAULT -createUserTableSpace true -pdbAdminPassword PSEUDONIMOUSPASSWORD -sysPassword PSEUDONIMOUSPASSWORD

Prepare for db operation

13% complete

Creating Pluggable Database

15% complete

19% complete

23% complete

Thursday, December 7, 2023

The Database is not accessible after creating Always On Availability Group

Having created a fully functional SQL Server Always On Availability Group, I connect using SSMS.

Upon trying to expand the database, I get this message: "The database [...] is not accessible (Object Explorer).

The stack trace mentions get_CanGetChildren().





File this one under "sometimes, our lives are meant to serve as a warning to others."

I was connecting to the Windows Server Failover Cluster, rather than the SQL Server listener. SSMS / SQL Server is happy to let you do this, but then you're not able to expand the database.

When I connected via the listener, it worked without issue.


Monday, July 3, 2023

2023 Iowa Derecho / Tech Work

 Being a human is weird.

Most of you are well aware that we had a derecho blow through.
For 4 days, I cut trees and cleaned branches and called contractors and insurance agents and adjusters.
My body hurt. I sweat profusely. I was in a hightened state of awareness, worried that more limbs would fall and actually hurt someone.

And ... some part of me absolutely loved it.


Today the electricity is on and I'm back to work. I'm cool and caffeinated and staring at the beautiful screens that constitute the bulk of my life. Things are getting back to normal.

And I'm ... horribly depressed?

Not looking for sympathy. It's fine. These things (depression/anxiety) come, they visit for a while, and they go on their way. I've learned to separate from them and let them be what they are until they aren't anymore.

What's weird, though, is the very fact that I'm depressed. I should be exuberant. Power's on. It's the 4th of July week. I have vacation coming. I can play video games watch YouTube and microwave lunches and charge my phone.

But I'm not exuberant. I want to turn the power back off. I want to leave my desk and go do something with my body, and feel powerfully connected with the earth and a part of a community. I want to feel how rewarding it is to work with people I love, and make progress toward a goal.

It's almost like I'm mourning this brief time, uncomfortable as it was, where I got to be an actual human.

I've known for a long time that I was kind of living my life wrong. I just don't know what to do about it.

I keep telling myself "3 more years." (That's how long until my youngest graduates HS)

Oh, well. Back to the money machine...
Happy Monday, kids.
¯\_(ツ)_/¯

Thursday, July 14, 2022

Where you gonna get your power? (Roe V. Wade)

TO: My liberal friends

SUBJECT: Choice

I see a lot of rage in my feed, and I totally get it. 

I would humbly and politely advise you on this matter, if you care to receive advise. If not, again, I totally get it. 

So, my advise:

1) Don't try to reason with or argue with people who think Barak Obama was born in Kenya, or was a Muslim, or a terrorist. Don't try to reason with people who think Covid doesn't exist, or Jan 6 was Antifa (in white-face?) trying to frame good conservatives. (I could actually go on for paragraphs like this, but you get the idea) It's a complete waste of your time and energy, and none of us have either of those things in infinite supply.

2) In dividing into "us and them", be careful where you draw your lines. A lot of men are on your side, and a lot of women are against you. Giving in to the temptation to make this about men oppressing you misses some very important aspects of the battle. 

3) Voting is not going to fix this. If your vote mattered, Neither Trump nor W would have ever have been president. 

4) Related to #3, but worthy of it's own bullet: Quit focusing on the next election. You need a sort of meta-political organization or movement to effect the following changes: 

    A) There must be a penalty for propaganda (SLOGAN ideas: "Make lying wrong again", or "CHRISTIANS: Thou shalt not bear false witness against thy neighbor"). There is really good money to be made telling conservatives the lies they want to hear, and far from having any negative consequences, they're actually laughing all the way to the bank. 

    B) Make liberal votes actually matter 

    C) Do something about the political organizations masquerading as religious organizations that sit on corner-lots throughout our towns and cities. Yes, they're going to howl. When do they not? 

None of that involves a candidate or an election, per-se. 

Conservative senators abused their power to block judges appointed by a duly elected president, and then "values voters" allied with the first man to put a strip club in a casino to finally overturn #RoeVsWade. There is every indication that most of them were willing to go as far as refusing the peaceful transition of power that our nation is built on to get what they want. Your liberal leaders are too weak and useless to deal with a party that appears quite willing to burn the world down to get what it wants. Your leaders have been out-maneuvered or overpowered at every turn, even when they're briefly in the majority. Putting your faith in the current system, or deceiving yourself to think that your voice matters AT ALL, will only produce a continued slide towards totalitarianism. 

Where you gonna get your power?  

Thursday, January 27, 2022

Joseph the Fatherless

 

I was raised in church. Like, literally. 3 times a week + 6-7 day “revivals” a couple times a year + 1 week VBS + summer camps + teen retreats + whatever-else-came-along.

While everybody else was watching the ’85 bears win the super bowl, I was one of, as I recall, 3 or 4 people in church, two of whom were my mom and I. ON SUNDAY *NIGHT*.  The preacher didn’t even want to be there. I could tell.

At some point, via all this emersion, I suppose, I became a company man. I believed, baby. Whatever they said, I believed it. I mean, it MUST be right. He’s standing on an elevated platform in a business suite in front of a cross and an American flag waving a Bible, for Heaven’s sake. He *MUST* be speaking truth.

I’ll never forget listening to a preacher decrying the state of our society, the decay, the decadence, the Satanic influence, the “illegitimate” children.

I hadn’t seen Austin Powers yet; but if I had, I’m sure my response would have been “Ouch, baby. Very ouch”. Illegitimate ... that's me...

By that time, I suppose, I was beginning to understand that I wasn’t like other kids. In the late ‘70’s or early ‘80’s in my rural community, kids had a mom and a dad. Period.

Or, at the least, they knew who their dad WAS.

Not me, though. Nope. No idea. Never met the guy. Don't even know his name. 

Sadly, that was by no means the worst of it.

My mind was highly analytical and critical, and yet utterly awash in unintelligible sophism that I was too terrified to question. That combination produced a clear and unavoidable result: I shouldn’t exist.

I was a symptom of all that is wrong in the world. I AM the rejection of God’s plan. I embody the great fall of our civilization. The man on the elevated platform in front of the cross and the flag wore the business suite, waved his bible, looked me right in the eye, and told me so. 

If two people hadn’t flipped Almighty God the bird and gone out and SINNED, I wouldn’t exist.

Wouldn’t exist. Shouldn’t exist.

I’m never sure how much of my dumb-fuckery is caused by condition x, and how much of my awareness of condition x is just my innate dumb-fuckery looking for a reason to exist, but here’s the deal: I had LOTS of dumb-fuckery, and it seems to have largely related to all of this in some way. 

I worked hard for many years, and I thought I’d sort of dealt with this and moved on. We can’t wallow in things forever. At some point, we need to say, “well, yeah, that sucked. Glad it’s over.”, and get on with it.

Which brings me to the present time.

Today I was finally able to look deeply at some problems I’ve been having in relationships. I emphasize the *I*. These problems are clearly not the fault of the other people. They are MY problems. 

I examine it, and I see this …  what? Cause? Condition? Commonality? Call it what you like, I suppose.

I’m not sure what I’m going to do with that. My initial reaction is to be so incredibly sad that those people who happily brain-raped the innocent for all of those years are somehow still speaking through my mouth, and so long after I thought I’d dealt with it and moved on.

This is normally where I turn this into something positive for people who are going through something similar. 

I'd say something like, "the people who are making you feel unworthy or unlovable or 'illegitimate' are DEAD WRONG. Cast off those chains." 

I just can't do that, though. Not yet. I can't tell you "this is how you do it", because clearly I haven't done it, yet . 

I’m going to sit quietly with this. I'm going to be still, and keep it company. The mud will settle. The right action will arise of its own accord. The energetic, emotional, and psychological patterns will disintegrate. I've seen it before. I've done it before. The process begins. So be it. 

I don’t want this new flaw, having come to light, to obscure my view of how far I’ve come, though. I’ve done well.

I remember so much anger, bitterness and hatred. Especially hatred - reserved primarily for for myself. For what? Being human? For existing?  For existing.

I lived long with so many regrets forged in decisions made out of desperation to just stop the pain.

But also,  I kept battling. I fell often, but I generally fell forward. I looked at the problem, worked hard to see it for what it was, and did the work to resolve it, over and over again.

And, ultimately, I made some decisions that I *AM* proud of. In spite of myself, I managed to become roughly the man I always wanted to be. I've kept some promises that were important to me. I've done alright.

They can’t have me anymore. I don’t want to be angry or resentful. I’m sure they were doing the best they knew. But, they can’t have me anymore.

They don’t get to decide what is an acceptable reality. They’ve proven themselves too given to magical thinking.

They’ve proven themselves too inobservant and unrealistic regarding the behavior of others, and too divorced from reality concerning their own.

They don’t get to decide what society should look like. They’ve proven too eager to throw away their own convictions when the situation calls for it, or toss aside the very Gospel when it conflicts with their instincts or their politics.

They don’t get to decide what is and is not *legitimate*.

 I am free.  

Monday, September 13, 2021

I hope you're right about Covid-19

 I hope you're right.

I hope it's just overblown, breathless nonsense concocted by the liberal media.
I hope this is all a hoax that the libtards cooked up when they got bored with peddling climate change.
I hope it's a Machiavellian plot by the DNC to get the mighty Trump out of office.
I hope that it's no worse than the flu.
I hope that Biden goes to jail and the world acknowledges that the election was stolen and Trump gets back in office and can can put everything right with the world again.
I hope that Obama was born in Kenya.
I hope he's a Muslim and a terrorist and a radical.
I hope that the 2008 bailout really was a government takeover of the auto industry and we've all just failed to see it.
I hope that Sharia law takes over. No, wait. I hope that it was really going to, but then was somehow thwarted by Rush Limbaugh as his last, heroic, dying act. Or something.
I hope that Fox News announces an investigative report of all the people that were killed by the death panels in the healthcare bill.
I hope that Elvis is still alive, that he's happily married to a mermaid, and that they're living in the sound studio that was used to film the moon landings.

Honestly, I'm not even joking. I really hope that, because it's the last hope we have.

You'd better be right. You have to be right. Because there is no opportunity for any other course than the one we're on.

I've never wanted more to be wrong, because it looks to me like people are lying to you and laughing all the way to the bank.

... Again ...

It looks to me like the vaccine is way < 100% effective.
It looks to me like ain't nobody gonna be wearing no goddam masks to make sure they don't give a deadly respiratory infection to their friends and neighbors - a respiratory infection that is even more serious than last year; that took at least 6 people I knew in 2020, and that hospitalized four others. (2 of which still haven't "bounced back")

You guys are in charge. Seriously. You on the right. You run the world, or at least the part I live in.

You'd better be right.

You'd better be right, or this is going to get really ugly really fast.

Covid-19 in Lee County

 I don't even know how to put this into words, so I'm just going to start writing and see what develops.

Someone close to me (very close, but to remain nameless) told me about a coworker who died of Covid-19. She was in her 40's.
I was just on a meeting with a friend/colleague who told me her bother-in-law died of Covid-19. He was in his 40's.

I understand being distrustful of big for-profit pharmaceutical agencies and the government agencies that are charged with regulating them. I really, really do. Somewhere there's a picture of me signing a book that I wrote entitled "I don't trust for-profit pharma or the government agencies tasked with regulating it, by Joe Hayes."

I understand being upset about mask mandates. Nobody likes being told what to do.

What I don't understand, what I REALLY don't understand, is actually needing a mask mandate. Why are we not falling all over ourselves to put a harmless piece of cloth across our face in the hopes that it might, even just maybe, protect our friends and community from this wrecking-ball of a respiratory infection.

But then, here's me. I'm not wearing one, either. The social pressures of living in an area where we don't believe in moon landings *OR* the efficacy of masks, and being the only one wearing a mask most places I went, became too much. I comfort myself by saying I'm fully vaccinated so I don't need a mask. I don't think I really believe that, though. I think I just became exhausted from the stares and the feeling of freakishness of being the only one in a room with a mask on. Oh, and by the way, when I'm the only one in the room with a mask on, it's nearly 100% pointless. (Not quite, but nearly)

I'm just so overwhelmed with sadness, disappointment, and yes, anger ... that the people who started off not believing Covid-19 even existed then moved on to thinking it's just the flu or that masks would bring about the mark of the beast or were a government plot to take away our freedoms, and that they *STILL* don't appear to have sort of looked around, realized that they were taken for a ride, and come back to sanity. (Am I wrong? Maybe they have and I just don't see it) And, again, why would mandates even be needed? Masks are such a simple, harmless, obvious thing to do ... :-( How hard do you actually have to work to not see that?

I'm so sad to realize that they're going to keep listening to the people who have told them these things, and quite the opposite of holding them accountable for the destruction they've contributed to, they're going to find ways to deny a connection, and to keep believing them when they say new, destructive, untrue things, because it's all just a team sport, and who cares if we burn the world down as long as our team is winning? :-/

I'm so incredibly disappointed to realize that we're just sort of letting people die, because people thought they could make political hay out of Covid-19, or spread nonsense on their talk show or YouTube channel, and laugh all the way to the bank.

We're just letting people die, because fuck your feelings, I guess.

It's so goddam weird to me.

And this is where I live. I feel like Spock on the Enterprise, one eyebrow raised quizzically, trying to figure out what makes you "humans" tick.

It's just so goddam weird to me.