ORACLE DB Connects only when I do not specify SID

I have an Oracle 19c database in a Unix server. SQLPLUS command connects only when I do not specify the SID.

sqlplus system/manager SQL*Plus: Release - Production on Mon Jul 20 12:37:30 2020 Version  Copyright (c) 1982, 2019, Oracle.  All rights reserved.  Last Successful login time: Mon Jul 20 2020 11:45:41 +05:30  Connected to: Oracle Database 19c Enterprise Edition Release - Production Version  SQL> 

However, when I try with the SID, it does not connect.

sqlplus system/manager@S19110  SQL*Plus: Release - Production on Mon Jul 20 12:40:01 2020 Version  Copyright (c) 1982, 2019, Oracle.  All rights reserved.  ERROR: ORA-12537: TNS:connection closed   Enter user-name: 

I see the following in my listener.log :

TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Linux Error: 32: Broken pipe  

I googled the error and tried the following troubleshooting methods but no help.

  1. 6751 permission for $ ORACLE_HOME/bin/oracle
  2. Increase max number of processes in the database.

Please help.

Can movement spells that don’t specify they are teleportation bypass Forcecage?

Forcecage states:

A creature inside the cage can’t leave it by nonmagical means. If the creature tries to use teleportation or interplanar travel to leave the cage, it must first make a Charisma saving throw.

Despite external opinions about how the spell should work, is it correct to read the RAW interpretation that magical effects such as Tree Stride or Transport via Plants are capable of bypassing the saving throw as they don’t specify they are teleportation?

Specify Host for User in docker compose file

I’ve started messing with Docker and the MySQL 5.7 image, and have created a docker-compose.yaml file to quickly bring up a DB instance with the root password set, a new user & password created, and a new database. When I log in to the new DB, I see that the new user is set with a host of %. I would like to be able to set this to a host of my choice in the yaml, but I can’t find any docs or notes on what environmental variable to specify in the docker-compose file.

Thoughts about how to accomplish this? I did attempt to set MYSQL_USER: dbadmin@host but this just created the user as dbadmin@host with the host still set to % in MySQL.

Why does keycloak use HS256 algorithm to sign access token when client settings specify RS256?

I have the following setup with a keycloak authentication server and an application:

  1. user logs in on application client side, send un/pw to server
  2. application server sends un/pw to keycloak server for a token
  3. keycloak server sends a token back to application server
  4. application server outputs web page with sensitive data

I want to use RS256 to sign my tokens. When I try to get a token on the client side, they are corectly signed with RS256, but as soon as I try to get one on the server, HS256 is used. How can I set keycloak to use RS256 in both cases?

I use the /auth/realms/{REALM_NAME}/protocol/openid-connect/token endpoint and keycloak 10.0.1.

Keycloak configuration:

  • keys
    • realm keys are HS256, AES, and RS256 (listed in this order) all with a priority of 100 (EDIT: even if I set the RS256 key priority to a higher value, HS256 is used)
    • default signing algorithm for the realm is set to RS256
  • client
    • access token signature algorithm and ID token signature algorithm for the client are set to RS256
    • the client is public
    • Valid redirect URIs contain the domain where the application server is currently running (which is localhost but my computer has a domain name)
    • Web origins is set to "+" (which as far as I’m aware copies entries from valid red. uris)

Google seems to return no results related to my problem.

Why does the Amulet of the Black Skull specify that you cannot use it to teleport to another plane of existence?

The Amulet of the Black Skull from Tomb of Annihilation says:

You can use an action to expend 1 of its charges to transport yourself and anything you are wearing or carrying to a location within 100 feet of you. The destination you choose doesn’t need to be in your line of sight, but it must be familiar to you (in other words, a place you have seen or visited), and it must be on the same plane of existence as you.

Why does the description specifically prohibit intraplanar travel when it already specified that the location must be within 100 feet of you?

Are there any situations when this is definitively not a redundancy?

I’ve never played Tomb of Annihilation, is there an adventure specific circumstance I’m not aware of that makes both restrictions necessary in the descriptions?

Specify a force on the entire body (e.g. gravity)

In the thread Stress calculations using finite elements User21 showed an example how to define a force over the entire body during FEM calculation as boundary condition. See the screenshot below from the corresponding position in this thread.

enter image description here

In the description of the definition of the boundary condition – force on the entire bodyUser21 has defined the differential equation system as follows.

$ ps$ == {$ 0, -9.8$ }

Which unit has this power? Is the unit $ N/m^2$ ?

If $ N/m^2$ is the correct unit, then I can understand how to calculate the normalized body force from the density and volume of the body and insert it into the right side of the differential equation.

If $ N/m^2$ is not the right unit, then I have the following questions on you:

How is the density of the material or the mass considered here? Could you please show how to use this correctly in the equation?

In my case I have a centripetal acceleration due to rotation and the equation would look like this:

$ ps$ == {$ omega ^2 * x, omega ^2 * y$ }

Omega is the angular velocity of the body for which the deformations are to be calculated with FEM. And the expression

$ omega^2 * r$

is the centripetal acceleration, where $ r$ is the distance from the center of rotation.

However also here I have the problem, density resp. masses are not considered.

Does anybody have an answer to the question how to use the density and the mass correctly in the equation?

Many thanks in advance!

How can a disease be removed, if the description of the disease does not specify?

The description of a Gas Spore’s Death Burst [MM p. 138] says (in part):

Spores invade an infected creature’s system, killing the creature in a number of hours equal to 1d12 plus the creature’s constitution score, unless the disease is removed.

It does not say how the disease may be removed.

The DMG is very vague on disease. Regarding removal:

A simple outbreak might amount to little more than a small drain on party resources, curable by casting of lesser restoration. A more complicated outbreak can form the basis of one or more adventures….

What spells, abilities or tools can be used to remove disease where a specific cure is not mentioned in the disease’s description?

When you use wish as a contingent or glyph spell, when do you get to specify the effect?

Contingency and glyph of warding allow you to store a spell as part of the casting. Both also states the stored spell does not take effect until it is triggered.

… but the contingent spell doesn’t come into effect. Instead, it takes effect when a certain circumstance occurs.

Glyph of warding
The spell being stored has no immediate effect when cast in this way. When the glyph is triggered, the stored spell is cast.

When you cast wish as the stored spell, do you decide what the wish do before or after it is triggered?

Would allowing Primeval Awareness to specify numbers and directions make the feature unbalanced?

The 3rd level class feature of the ranger, Primeval Awareness, says:

Beginning at 3rd level, you can use your action and expend one ranger spell slot to focus your awareness on the region around you. For 1 minute per level of the spell slot you expend, you can sense whether the following types of creatures are present within 1 mile of you (or within up to 6 miles if you are in your favored terrain): aberrations, celestials, dragons, elementals, fey, fiends, and undead. This feature doesn’t reveal the creatures’ location or number.

Of all the rangers I’ve played myself or seen played by others, I have never seen this feature get used. One of the things that stops me (at least) from using it is that last line (“This feature doesn’t reveal the creatures’ location or number.“), which seems to make the feature overall pretty useless.

It seems that at least someone else agrees with me enough to level this criticism at Crawford:

Jonathan Longstaff:
@JeremyECrawford Also Primeval Awareness is arguably the worst class feature in the game. It’s so not worth a spell slot.

Jeremy Crawford:
@pukunui81 It’s definitely situational. In my recent Ravenloft game—heavy on investigation, light on combat—Primeval Awareness was pivotal.

Jonathan Longstaff:
@JeremyECrawford The fact that it covers a large area and doesn’t even give you a direction is the main issue for me.

Whilst I’m curious to know if anyone thinks this feature isn’t useless as-is and can explain why it’s actually useful, that’s not what I’m going to ask here (people can always link me to forum posts about such things in the comments below, if such forum posts exist).

Instead, my question is, assuming that I continue to believe that this feature is useless because of that last line, what are the balance implications of removing that last line from the class feature’s description? So the feature would read the same but excluding “This feature doesn’t reveal the creatures’ location or number.

My main concern is that it might end up being basically a better version of locate creature, which is a 4th level spell and therefore a RAW ranger wouldn’t be able to do this until level 13. On the other hand, this would only last a few minutes at most rather than up to an hour like locate creature.

Would allowing this feature to specify numbers and directions (bearing in mind that it only lasts a few minutes at most) make it overpowered, or would it merely increase its power enough to make it actually useful?