Oracle 12c – Logically There Is A Redo Group But Not Physically – Database Can’t Open

I have an Oracle 12c Database for my enterprise manager.

I could not connect to enterprise manager because the database was closed.

I opened listener. However, the database remained mounted mode. When I want to open the database in read & write mode, I get the error as follows:

SQL> alter database open;

ERROR at line 1:

ORA-00313: open failed for members of log group 3 of
thread 1

ORA-00312: online log 3 thread 1:

ORA-27037: unable to
obtain file status

Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

When I go to the file location of redo03, there is no redo03.

So it’s logically, but not physically.

There are some queries and results:

SQL> col member format a50
SQL> select group#, type, member from v$logfile;

---------- ------- --------------------------------------------------
         3 ONLINE  /path/of/redo/redo03.log
         2 ONLINE  /path/of/redo/redo02.log
         1 ONLINE  /path/of/redo/redo01.log
         4 ONLINE  /path/of/redo/redo04.log

SQL> select group#, thread#, sequence#, bytes/1024/1024, members, status from v$log;

---------- ---------- ---------- --------------- ---------- ----------------
         1          1      61525              50          1 INACTIVE
         4          1          0              50          1 UNUSED
         3          1      61527              50          1 CURRENT
         2          1      61526              50          1 INACTIVE

I tried doing this: create redo group 4. Drop redo group 3 and recreate redo group 3.

There was no problem creating redo group 4. I used this command below:

alter database add logfile thread 1 group 4 '/path/of/redo/redo04.log' size 50m;

But when I want to drop group 3, it gives error as follows:


ERROR at line 1:

ORA-01623: log 3 is current log for instance dbname (thread 1) –
cannot drop

ORA-00312: online log 3 thread 1: ‘/path/of/redo/redo03.log’

I wanted to try disable the thread that redo group is connected to and after that I wanted to drop redo group 3. But it give error as follows:

SQL> select thread#, status, enabled from v$thread;

---------- ------ --------
         1 OPEN   PUBLIC

SQL> alter database disable thread 1;
alter database disable thread 1

ERROR at line 1:

ORA-01109: database not open

When I try to switch logfile, it gives error as follow:

SQL> alter system switch logfile;
alter system switch logfile

ERROR at line 1:

ORA-01109: database not open

As a result; there is a redo group 3 logically but there is no physically file. I am sure that nobody has deleted the file because I checked it with the history command on linux system. I can’t open the database because redo group 3 cannot find. I can’t logfile switch, I can’t disable thead, I can’t delete redo group 3 and recreate it. Please can you help with this?

Best regards,

google sheets – Automatically Merge Group of Cells Below a Text Value

I’m building out a scheduling assistant; the look is great, but it is very tedious to Merge & highlight each schedule block individually, so naturally I turned to Apps Script.

I’m entering different Names (text values) on the schedule that may or may not be different every time, but the good thing is that each block will always be 3 hours (or 6 total cells).

My goal is to use a “Transform” button to run a script that would take any cell that has a text value on the schedule, and merge & center that text value with the 5 cells below it.

Ideally, I would type in all of the text values at their start time, then click this button, and all would merge at once – thus creating a 3 hour block.

My plan is to use Conditional Formatting to highlight these blocks after.

My current script is below, but I’m getting an error in Line 5.

As I’m sure you can tell, I’m very new to this. Trying to run Macros & use information I’ve found online to piece something together. Would anyone be able to point me in the right direction here?

function Merge() {

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var s = ss.getSheetByName('Schedule');
  var range = s.getDataRange()
  var values = range.getValues();

  for( var row = values.length -1; row >= 0; --row )
    if (values(row)(1),(2),(3),(4),(5),(6),(7) <= '')

I’ve also linked a sample sheet, because I’m sure this sounds very confusing without seeing what I’ve done thus far:

amazon web services – Security group does not belong to VPC

I am trying to create an internet facing elb. I have created vpc in ohio region (us-east-2). I have created 4 subnet. 2 public subnets and 2 private subnets.
Public subent: SubnetA (us-east-2a), SubnetB (us-east-2b)
Private subnet: SubnetC (us-east-2a) , SubnetD (us-east-2b)
When I give the availability zone to the load balancer it shows the following error Security group does not belong to VPC

AWSTemplateFormatVersion: 2010-09-09
    Description: "Source stack name"
    Type: String
    AllowedPattern: "^(a-zA-Z)(-a-zA-Z0-9)*$"
    Default: "wahaj-vpc"
    Type: AWS::EC2::SecurityGroup
      GroupName: wahaj-elb
          Fn::Sub: "${SourceStackName}-VpcID"
        - IpProtocol: tcp
          FromPort: 22
          ToPort: 22
          Description: For traffic from Internet
        - IpProtocol: tcp
          FromPort: 80
          ToPort: 80
          Description: For traffic from Internet
      GroupDescription: Security Group for demo server

    Type: AWS::ElasticLoadBalancing::LoadBalancer
        - "us-east-2a"
        - "us-east-2b"
        - "us-east-2c"
        - LoadBalancerPort: "80"
          InstancePort: "80"
          Protocol: HTTP
        - !Ref wahajelb
      LoadBalancerName: wahajelb
      # Subnets:
      #   - Fn::ImportValue: !Sub "${SourceStackName}-SubnetC"
      #   - Fn::ImportValue: !Sub "${SourceStackName}-SubnetD"
        Target: HTTP:80/SamplePage.php
        HealthyThreshold: "3"
        UnhealthyThreshold: "5"
        Interval: "30"
        Timeout: "5"

I am new to this so please if any changes is required to the template do tell me I might have made some mistakes.

google cloud Stackdriver Metrics to scale an Manage instance group – Regional

What are the Stackdriver Metrics we can use to autoscale Regional Manage instance groups ?
When i check the docs it says
Regional managed instance groups do not support filtering for per-instance metrics.
Regional managed instance groups do not support autoscaling using per-group metrics.

Is that mean I can not use any Stackdriver Metrics other than CPU ?

dnd 5e – Group with split likes in D&D game: role playing and combat

First of all: Don’t worry. Having one player that prefers roleplaying over combat is, at least to me, pretty much the default. I think I literally have never DM’d to a table that didn’t have that one Bard or Rogue that wants to sleep during combat and gets all excited when they get to a town and they can talk to people. That’s normal and usually everyone can have fun together without much problem.

Comments on Session 0

So, usually, this kind of thing would be talked about in a Session 0. The “problem” with new players is that they are, well, new players. They don’t know what they like or not about the system/game, because they have never played it before. It’s like asking “do you like this food?” to someone who has never eaten that – or anything similar, for that matter.

And, similar to tasting food, usually tasting it only once is not enough. Even a long session like yours is still little time to get a grasp on what you actually like or dislike in the game. Maybe the player didn’t like one very specific aspect of how these combats happened, but can’t figure it out yet.

So… play a little more as usual and find out what the actual likes of the players.

Early levels are usually a little more boring than the rest of the game

One of the main reasons to try to keep playing is that early levels in 5e are quite boring. I am assuming you ran this session with 1st level characters, since the adventure you mention start at 1st level. The Warlock didn’t get their Eldritch Invocations yet, they know 2 spells and have 1 spell slot. Their playstyle for now, as with most other classes, lacks choice. There is a reason the XP chart makes characters fly through the early levels: they are only to get a grasp of the combat for new players, and to construct your character personality.

Warlock, in particular, is a class that is very… strange. It’s like a full spellcaster that has a playstyle more akin to martial classes.

So, just to reaffirm: let them find out their tastes a little longer. Ask them to try out one more “regular” session.

After that, I have seen a few possible outcomes:

  • It is not that they didn’t like combat, they didn’t like their class, or even the way they have been playing the class. I have recently had a Druid player that felt like she hated combat because she was a Moon Druid and most of her combats were turning into beasts that couldn’t even talk and attacking and tanking damage. After she started spending more time in her humanoid form and focusing on casting spells and controlling the battlefield, she got considerably more interested in combats. If the player doesn’t like the class, offer them the possibility to change it. They are new players, they didn’t know what they were signing up for when they chose the class.
  • The player prefers roleplaying over combat. That is okay. If they can stand combat, which is kinda necessary in a D&D campaign (more about that later on “D&D is combat-centric”), you can easily balance between roleplaying and combat and everyone has a good time. More advice about it later on as well, on “Finding a Middle Ground”.
  • The player hated combat. Well, then it is possible that you can’t align your tastes, and it is even likely that D&D is not a good RPG fit for that player (again, more about it later). That is okay, it happens, not everyone is going to like the same things, and they don’t have to. The player can find tables on RPGs that are more about Storytelling and have fun over there. Or they could even find a very combat light D&D table. But then the other players have to have that same mindset. It is not clear whether this is the case to you and your other players.

D&D is combat-centric

This is both historical/cultural and designed. Monsters have a XP reward attached to them as one of the most notable numbers in their sheet, and there is almost none advice on how to reward things like talking to people and solving problems that are not encounters. The vast majority of class features are supposed to help in combat. Adventures are written in a way that most of the challenges are overcome through combat.

You can certainly play a story-driven D&D campaign, and make it combat light, but the system design makes it way harder for you to do that.


I think this is a needed advice in case you didn’t think about it yet: use Milestones to track levels, or any other alternative ways of rewarding experience. This will considerably reduce the focus of combat and tell the players they don’t need to murder everything they see to get their XP share.

Finding a Middle Ground

Now, let us assume the player didn’t hate combat, and the other players didn’t hate roleplaying. There is a similar question here, and you can read it to get some insight. But some things you may do to find a middle ground:

  • Balance the real life time spent in combats and in roleplaying in a way that is satisfying. I am not saying this will be 50/50. Maybe Combat has to play a smaller role. You will have to find that out by playing and asking more feedback to your players.
  • Allow and incentivize non-combat ways of solving or at least easing combats. For example, the Warlock could persuade some guards in the place they want to invade to let them in, instead of having to fight the guards. I am currently running a campaign with a roleplayer Bard, and frequently he has solved problems through persuading people rather than killing them. Sometimes, he has to fight, though, and then he is more of a supportive character. He is able and willing to accept that this is part of the game and this is what is fun for the War Cleric in the party. He has found creative ways of having fun in combat in the meantime, instead of just “sucking it up” and “accepting” the combat. Your player will probably be able to do the same, eventually.
  • Design encounters with meaningful choices. This is extremely important at early levels, when the class features don’t provide enough choices by themselves. This will take time to figure out as a DM, but you can read advice, for example, here. Disclaimer: This is a link to The Angry GM. Strong words used frequently. Proceed with caution.
  • Make the game about a goal, and combats are a challenge to overcome to achieve that goal. Find out what motivations your player and his character have, and include that motivation behind your combats. Again, talking about the roleplaying Bard: there is a Tome that contains information that he really, really wants. For him, a combat that makes him closer to that Tome is a meaningful combat. Even though he doesn’t like combats, in general, that much, the motivation behind it is enough for him.

The last two bullets make an important point: Combats (or, more generally, Encounters) are about a clash of motivations or goals. They don’t need to start because one side wants to kill the other, and they don’t need to end only when one side is dead.

Practical Example

Again going to the Bard example: consider an encounter where they finally get closer to the Tome, and there are some monsters guarding it. They don’t care about killing the monsters, they care about getting the tome. Killing the monsters and then safely getting the Tome is one way to solve this, but also is becoming invisible and stealthing through the monsters and simply running away with the monsters. Maybe if they try to just walk through invisible it won’t work because the monsters are very attentive and will notice the Tome missing as soon as it gets stolen and will enter a rampage mode, but if the other characters of the party distract the monsters while the bard stealthily steals the tome, and then they run away as soon as he is safe, that is as solved as killing the monsters, the Bard didn’t need to enter combat, and the other players got their combats. In order to not make it trivial, the Tome is guarded by some traps that the Bard will have to overcome while the party is fighting the monsters, who are overwhelming the party. If the Bard takes too long the party will have to run or die before they manage to get the Tome and they were defeated (and, in the case of running, defeat also does not mean death: the Monsters goal is to guard the tome. Killing the adventurers is one way to do it, making them flee is another).

Although I have not run this encounter with the Bard I have been mentioning, I have done similar encounters and the party usually would have fun as a whole. By the end they would be like “Whoof you took too long I thought that Gorgon was going to kill me, I almost got petrified you know?!?!”, “Excuse me I had to deactivate a fire breathing statue that burnt my beloved cloak… It was a parting gift from my master okay????”, with adrenaline pumping in their blood.

Keep getting feedback

You are learning as well. It is very nice that you asked feedback from your players and that you asked advice here. Keep improving. Unless you have players on a really extreme end of the “likes” spectrum and they can’t stand the way the other players have fun, you will certainly be able to find a sweet common ground where everyone has fun. Keep asking for feedback, keep finding advice on how to improve on that feedback, just… keep learning.

How to pass a group value in inventory file to jinja2 template file in ansible

I have an inventory file named hospital.inventory and it contains following group with a single value.


Then I have a file name security.json.j2 inside the folder call templates. In there I want to refer above mentioned value in below placeholder.

"wellKnownUrl": "https://_placeholder_value_/my-configuration",

Is there any direct way of doing that?

As an alternative, how I did was declare a variable in main.yml file inside defaults directory and use it.

swarm_hostname: "
   {% for host in groups['dockerSwarmManager'] -%}
   {%- if not loop.last %}, {% endif -%}
   {%- endfor %}"

I don’t think it’s nice to use a loop just to extract a single value from a group inside the inventory file even though I get the expected output.

dnd 5e – Group with split likes in DnD game: role playing and combat

Combat can have Roleplaying

Just because swords are drawn does not mean that roleplaying has to stop. On the contrary roleplaying is a vital part of keeping combat encounters from being purely mechanical. There are strategies you can use to keep roleplaying in combat:

Engage the characters in the stakes of the encounter
Combat is one of the ways that he can enact the will of his character. You can try to include more combats that relate to his character’s individual interests as opposed to just the generic interest in survival. If he is fighting to save a friend NPC that has been captured he can roleplay his specific character more and might be more engaged. He might roleplay his character’s interest in protecting the NPC by suffering Attacks of Opportunity to get closer to them or he might specifically target the enemy that harmed his friend.

Include more narration in combat and invite him to do the same
You can roleplay the actions and reactions of the enemies in combat and doing so can help him invest in the story of the combat in the same way he invests in the story of a social encounter. The goblin doesn’t just “attack you with his shortbow, it misses” instead he “bares his teeth at you as he lowers his bow and releases an an arrow. You duck just in time and the arrow flies overhead embedding itself into the side of an oak tree.” This will take more time so you will need to balance it with other aspects of the combat. In turn you can invite him to include more narration in his actions in combat. If he hits with an attack ask him to describe how it hits. When he casts a spell ask him to describe what the casting looks like. Eventually he will hopefully do this automatically and will be able to express his character even in combat encounters.

Make decisions in combat less generic
When you make a combat more than just taking turns attacking you give him more options to express his character. Would his character prefer to deal with the goblin that is blocking the exit or the bugbear that is advancing on the party? One of the goals in designing combat encounters should be to make the character’s mechanical decisions as difficult as possible. Oftentimes the best thing a character can do in combat is deal damage. If you increase the value of other actions (disengaging, helping, dodging, searching the room, applying medicine) then you make the character’s decisions less generic.

There will still be a balance between social encounters, puzzle encounters, and combat encounters. How that balance plays out will depend a lot on what your players enjoy. Are all of the other players equally content with social encounters as with combat encounters? If so you can make it nearly entirely social encounters. Do the other players want to have a lot of combat? If so you will need to balance the desires of the various players and yourself. By taking steps to make combat interesting for the player who likes roleplaying (and conversely engaging the combat-preferring players in the social encounters) you can make finding a happy compromise easier.

database – How to fix Uploaded to this post option to see group of images uploaded to a post in WordPress?

I’m transferring a site using the WordPress importer and Exporter settings. First, I downloaded the Posts content and the Media content, so I have two xml files.
After importing in the new site, I noticed that inside a posts, in the Add media section, when I select the “Uploaded to this post” option no images are listed. The media library shows all the images, and add media I’m also to see all the images.

Does anyone know what database content I need transfer to see the group of images uploaded to a particular post using the “Uploaded to this post” option?


8 – Search API group by issue with views

I have a content type thats is called course which has a field that is a reference to a taxonomy called category.

My specification tells to build a search where users can search for the course title, category and other fields that the course type has. The search functions like intended and everything works great except the display view. Here is my setup:

  • Drupal 8.5
  • Search Api with DB / Solr Backend. (tried both)

So to come back: each course can have multiple categorys to be in which means that the view has to be grouped by the category. If I do that my view displays this:

Category 1 Name

Category 1 Name, Category 2 Name

Category 2 Name

Category 3 Name, Category 2 Name

Category 3 Name

  • Course 7
  • Course 8
  • Course 9

As you can see courses that belong to multiple categorys are not listed underneath the respected category instead they are seperated by a comma. My goal is this:

Category 1 Name

  • Course 1
  • Course 2
  • Course 3

Category 2 Name

  • Course 3
  • Course 4
  • Course 5
  • Course 6

Category 3 Name

  • Course 6
  • Course 7
  • Course 8
  • Course 9

such behaivor is easy to do if you dont use search api and want just to display a normal view. I have already read this issue but it seems my goal is not possible.

I’m asking now here if something has changed or if its possible to get this done with writing custom code? Maybe tell search api to return every result and display them with custom code grouped by the categorys? Can anyone point me to the right direction?