Quick statement to find the uptime for an Oracle database
SELECT to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "DB Startup Time" FROM sys.v_$instance;
Quick statement to find the uptime for an Oracle database
SELECT to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "DB Startup Time" FROM sys.v_$instance;
So … Gov DeWine dropped the requirement that customers wear masks when going into retail stores because people didn’t like it. Does that mean we can get rid of speed limits?
Also, how do people not get the irony of traveling to a mass gathering where people are not wearing masks to protest … not being allowed to travel, congregate, and avoid wearing masks!? I get that a lot of the protest centers around the “back to work” part of congregating … but on the face, protesters are doing exactly what they claim to not be permitted to do.
12
servings1
hour30
minutes30
minutesSweet rolls with cinnamon, brown sugar, and currants.
2 1/4 tsp active dry yeast
1 cup warm water
1 tsp sugar
3 tbsp softened butter
1/2 cup sugar
1 cup warm water
1 teaspoon salt
1 egg
2 cups whole wheat flour
2 1/2 cups all-purpose flour
1/4 cup softened butter
1 tbsp cinnamon
3/4 cup brown sugar
1/2 cup currants






6
servings15
minutes40
minutesRed lentils in a tomato and coconut milk curry sauce
1.5 cups split red lentils
3 cups water
1 medium onion, diced
2 cloves garlic
1 Tbsp butter
1 tsp garam masala
1/2 tsp ground ginger
1 Tbsp hot curry powder
1 tsp sweet curry powder
28 oz diced tomatoes, puréed
14 oz can coconut milk, solids
We got a air popper to make popcorn (we’d made some really good caramel corn a few night previously, and really want to make some more … plus it’s just easier to use an air popper than to pop the kernels on the stove). Picked Presto’s 04820 (which is cheaper and , evidently, the same as the 04821 but without the popcorn company’s logo on it) – a 1475 Watt air popper). It works well, but there’s a strange design decision — no on/off switch. Obviously, we can unplug the thing and plug it in again when we’re ready to use it. I expect a majority of the use cases involve the popper being put into a cupboard somewhere when not in use anyway — so the machine is going to be unplugged after each use.
I expect this is a trend we’ll see in small appliances — it’s a component cost the company saved, reduced assembly time, and a point of failure is eliminated.
Oracle 11g seems to ship with password expiry enabled — which is a very good thing for production systems. I’ve even written some code to maintain our system account password (scripts are grabbing the password from a not-clear-text storage facility anyway, so it wasn’t a big deal to add an n-1 password and move the current stashed password into the n-1 column, change the account password, and stash the updated password in the current password location … now my system ID password is updated by a monthly cron job, no one actually knows the password {although anyone could find it, so I would run the password cycle script when individuals leave the group}). But I’m a lot lazier about this stuff in my sandbox. Proof of concept code has clear text passwords. But the server is bound to localhost & there’s no real data in, well, anything.
I started seeing lines in my error log indicating the password would expire. Aaaand that’s how I learned that password expiry was enabled by default now.
[Sat Apr 18 07:42:59 2020] [error] [client 127.0.0.1] PHP Warning: oci_connect(): OCI_SUCCESS_WITH_INFO: ORA-28002: the password will expire within 7 days in /var/www/vhtml/…/file.php on line 191, referer: …
I’m going to disable password expiry because it’s a sandbox. For a real system, obviously, this may not be a stellar idea.
select USERNAME, ACCOUNT_STATUS, PROFILE from dba_users where USERNAME = 'SampleUser';
| USERNAME | ACCOUNT_STATUS | PROFILE |
|---|---|---|
| SampleUser | EXPIRED(GRACE) | DEFAULT |
Note the account status “EXPIRED(GRACE)” — that’s why I am getting the error shown above. Grab the profile name — it’s a sandbox, so 99% sure it’s going to be ‘DEFAULT’ and alter that profile with an unlimited password expiration:
alter profile <profile_name> limit password_life_time UNLIMITED;
Except that didn’t actually stop the error. Turns out you’ve still got to change the password once the account has been flagged as expired (or let the password expire and then unlock the account … but I was looking at the log because I’m debugging something, and I wanted the error to stop *right now*).
alter user SampleUser identified by N3W_P@s5_w0rD;
Here are the chickens we want to order. I had put together a list based on research and talking to other people. Then I let Anya go through the hatchery’s website and pick the chickens she liked. Then I showed her where to find info about how many eggs they produce, if they are good in hot and cold weather, how friendly they are. We went through her list & eliminated birds that didn’t want to be in the cold, weren’t friendly, or only produce an egg a week. She really wants a white leghorn, but they say it’s not a good breed for cold weather. All but one of the ones I added were dropped because of lower egg production or less friendly personalities, so she was OK with removing some of her favorites from the list because sooooo many of mine got removed too.
Now we just have to wait until August for them to arrive! There’s evidently been a run on both chickens and seeds as people encounter runs on, well, everything at the grocery store.
| Name | Breed | Eggs-Low | Eggs-High | Climate | Personality | Egg Size | Eggs | Baby | Adult |
| Astra | Austra White | 208 | 260 | Heat and Cold Hardy | Quite, tame and docile | Large | ![]() |
![]() |
![]() |
| Sunshine | Buff Orpington | 200 | 280 | Very Cold Hardy | Docile, Quiet & Affectionate | Large | ![]() |
![]() |
![]() |
| Tilly | Columbian Wyandotte | 180 | Very Robust, Cold Hardy | Generally Docile | Large | ![]() |
![]() |
![]() |
|
| Queenington | Green Queen | 208 | 260 | extremely hearty in all climates | Friendly, Docile, Good Pet | Large | ![]() |
![]() |
![]() |
| Soaring Eagle | Black Jersey Giant | 180 | 200 | very cold hearty | Calm & Easy Going | Medium | ![]() |
![]() |
![]() |
There are some people protesting the stay at home orders – I see videos from outside of DeWine’s daily briefings, and several other states seem to have similar problems. Apart from the question of astroturfing, problem is that there’s very little opportunity for counter-protests. When you go to DC, there are PETA people counter-protesting the people looking to fund medical research (animal testing). There are vegans counter-protesting people looking to increase subsidies in the meat industry. I’ve never seen an abortion protest that didn’t have both sides represented.
These ‘liberate us’ protests? These are people who don’t think they should have to stay at home – they should allowed to hang out at bars, eat in restaurants, shop, party, and … oh yeah … crowd together at protests. The people who think the stay-at-home and shelter-in-place orders are important to protect their health? Seems like a far smaller portion of them would be willing to hang out in Columbus in a protest. Even if they could find masks and whatnot.
Why drive somewhere nonessential? Your car breaks down, and you’re exposed to others (and exposing them to you). You get into an accident and you’re exposed to others (and exposing them to you). Get injured in the accident and you’re adding to the patient load at hospitals. We’re not just staying at home to avoid large congregations. We’re staying at home to create less load for emergency personnel.
Without any special Administrative rights, you can list the members of the Azure AD groups that are used in MS Teams. If you don’t already have the AzureAD module installed, install it. In Windows, this is:
Install-Module -Name AzureAD
In Linux,you’ll need the preview of Azure AD:
# To run on Linux, you need the preview mode of AzureAD Register-PackageSource -Trusted -ProviderName 'PowerShellGet' -Name 'Posh Test Gallery' -Location https://www.poshtestgallery.com/api/v2/ Install-Module -Name AzureAD.Standard.Preview
Connect to AzureAD. There is a separate command to list the group owners (Get-AzureADGroupOwner). I’ve always found the owner(s) in the member list as well, but it’s technically possible to have entries unique to the owner list.
Connect-AzureAD Get-AzureADGroup -SearchString "Group Name Here" | Get-AzureADGroupOwner -All $True Get-AzureADGroup -SearchString "Group Name Here" | Get-AzureADGroupMember -All $True
Redirect the output to a file if you wish to use the results elsewhere, or stash the returned member list in a variable and use Get-AzureADUser to get additional information for the user records.
$objMembers | ForEach-Object -Process {get-azureaduser -objectid $_.ObjectID}
We use design documents at work to ensure a clear understanding between the requestors, product owners, and developers. There’s a request document that outlines what they’re looking to accomplish, we produce a design document that outlines what we’re doing and how that will be accomplished. External dependencies use the design document to implement their required services — if I have a design document that says I’ll pass x (required), y (required), and z (optional) to a WSDL and end up with an object in the application database where a=x, b=y, and, optionally, c=z … they’ll whip up an endpoint that takes the parameters, performs the required actions, and builds the object I need. Once everyone is in agreement that it’s what they want, it’s reasonable (security, ROI), and possible … developers get to work. Tests are built against the documented functionality, and we know we’re done when the tests pass. If the users want something changed, the design document is amended, a quick feasibility/reason-ability review is performed, and development work commences.
I thought of this process after observing some people push PRs for major overhaults into a few open source projects only to have the PRs rejected as, essentially, not the direction “we” want to go. On the other extreme … I’ve made some changes to open source apps — in some cases, those were bug fixes, and I’ve pushed the changes back to the main project. But, when I’ve changed functionality. I’ve made those changes to address a specific need I have, and I leave the changes in my own fork. Which has the detriment of, potentially, not providing useful functionality to the main project. While it’s perfectly reasonable to put a lot of time into a major change that you need anyway (and, potentially, offer those changes back to the community) … it is terrible to put a lot of your time into something for someone else and have it rejected. And while not engaging with the project maintainers to see if they’re interested in my derivative work saves effort for me, it reduces innovation (how many people actually run through all of the forks of a project to see if anything ‘interesting’ happened elsewhere?).
Obviously, the answer isn’t for projects to accept effort just because it’s a significant investment on the contributor’s part — there should be some mechanism for ensuring what you’re about to delve into is something the project maintainers actually want. Which is what made me think of the design documents we use at work.
If a project had a design document that detailed what it waned to do, how it was doing it, and potentially a section for desired future features and functionality … it would provide a guideline to anyone looking to contribute. A change that doesn’t impact functionality (e.g. a bugfix) can be worked on and submitted for inclusion in the project as occurs normally. If you want to change something about how the application works, you first submit a PR against the design document. Outline what you want to do, how you want to do it … maybe even a quick mock-up (I use Pencil Project for mock-ups where I’m uncertain the final project will be approved, HTML web code when I know the project is a go and want a head-start on my development … but I also accept the risk that I ‘wasted’ a few hours building the design document wireframe if the project gets dropped). Want to work on one of the ‘desired future’ items? Modify the design document to include that functionality and how it’ll be implemented. Discussion about the approach refines what you’ll actually be doing, and you’ll understand if the project maintainers are interested in your contribution before dedicating hundreds of hours to development.
Some projects are interested in “bugfixes only” — which can be stated in the contributing guidelines. In this example, I developed a quick script to produce in-scope user lists. I don’t want to include other details about the identified users, I don’t want to find the first n levels of reports, etc. It’s exactly what I needed, and I’m putting it on GitHub as an example — using Python to search an LDAP directory and using recursion with back-linked attributes.
Projects that are open for collaborative contributions, though, can include the design document location in their contributing guidelines. Initial contributions are made against the design document, discussed, and approved or rejected. Once approved, code can be developed to the new design.