Listener does not recognize an instance

We have been running several instances in the past: PUC and PST. Access to PUC is still working but recently I tried to access the PST instance and we get the following message from Listener:

D:\app\swtoracle\product.1.0\dbhome_1\BIN>lsnrctl services pst

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 – Production on 14-FEB-2020 13:13 :44

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=swtoracle-db)(PORT=1521) )(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=pst))) Services Summary… Service “CLRExtProc” has 1 instance(s). Instance “CLRExtProc”, status UNKNOWN, has 1 handler(s) for this service… Handler(s): “DEDICATED” established:0 refused:0 LOCAL SERVER Service “puc” has 1 instance(s). Instance “puc”, status READY, has 1 handler(s) for this service… Handler(s): “DEDICATED” established:61 refused:0 state:ready LOCAL SERVER Service “pucXDB” has 1 instance(s). Instance “puc”, status READY, has 1 handler(s) for this service… Handler(s): “D000” established:3 refused:0 current:0 max:1022 state:ready DISPATCHER (ADDRESS=(PROTOCOL=tcp)(HOST=swtoracle-db)(PORT=49171)) The command completed successfully

Any ideas why it does not appear to see the PST instance? Thanks

install postgresql without creating instance (for use with repmgr)

I’m trying to get REPMGR setup, and I’m following the steps at https://repmgr.org/docs/current/quickstart-standby-preparation.html to get the standby setup.

I noticed it warns On the standby, do not create a PostgreSQL instance. However I believe this happens automatically with how I installed Postgres

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" |sudo tee  /etc/apt/sources.list.d/pgdg.list sudo apt update sudo apt -y install postgresql-12 postgresql-client-12 

because when I try to clone the primary onto the standby as mentioned in https://repmgr.org/docs/current/quickstart-standby-clone.html
$ repmgr -h node1 -U repmgr -d repmgr -f /etc/repmgr.conf standby clone --dry-run

I get

postgres@empty2:~$   repmgr -h 192.168.1.102 -U repmgr -d repmgr -f /etc/repmgr.conf standby clone --dry-run NOTICE: destination directory "/var/lib/postgresql/12/main" provided ERROR: specified data directory "/var/lib/postgresql/12/main" appears to contain a running PostgreSQL instance HINT: ensure the target data directory does not contain a running PostgreSQL instance 

Now I’m just ASSUMING that this is because the database instance was created when I installed postgres on the standby. and I’m also ASSUMING that I can just delete everything in the data directory on the standby, and everything will work ok…

But (assuming my assumptions are correct….) what is the correct way to install postgres12 without creating an instance and the corresponding data files?

SSMS 18.4 Error opening database properties dialog box Azure SQL DB Managed Instance

I have three databases in an Azure SQL DB Managed Instance. I am using SSMS 18.4. One database I can right-click, choose Properties, and the dialog box comes up normally. The other two databases give me the following error.

enter image description here

I have spent a couple of hours Googling with no results. Anyone have any ideas?

Is this a doable character build in this particular instance?

I’ve been debating this for a couple weeks now and I was wondering if this is a doable build and if a DM would even be likely to allow this considering it is almost entirely home brewed. I am wanting to try a Chaotic Neutral Fullangr where I take a few classes in Barbarian and possibly a few classes in Smithing.

https://dnd-wiki.org/wiki/Fullangr_(3.5e_Race)#Fullangr

For reference this is the page my brother in law found for me. I am hoping that with this and a two weapon style and exotic weapon proficiency. I’ll be able to dual wield siege axes. Can’t figure out how to get a link for that one.
I had thought of having them be a last gift from the giantess mother before her death as passing on her weapons to her son who is big enough and strong enough to use them since she will not be able to anymore. Maybe having the Dwarven father etch some runes into them for some effect but not sure if i even want to go that route possibly except for maybe a durability rune just so they stay sharp, wont rush, stuff like that.

Since i also like playing where the DM has everyone choose one melee and one ranged weapon I was wanting to wrap chains around the forearms to use as improvised gauntlets and whips if necessary for this character. I had thought of having them as a last gift from the father as his weapons passed on to him. With the main special things about them being that they have a silencing rune on them from the father, and other runes to allow each one to have an end that is free hanging or can reattach to the rest on command. that way they wind back onto the arms and stay there i thought acting as either gauntlets or improvised bucklers. Or can unwind to be used like whips or grapples when needed. Semi inspired by both Ghost Rider and God of War. This way he has worn them for so long that they no longer effect him as merely cumbersome and only have the natural weight problem but no extra penalties that many like to throw out as a heavy cumbersome weapon causes for nearly any roll at all. Also since when retracted they would attach to themselves they still allow for full mobility and use of hands for grasping and holding other objects and weapons. Was thinking maybe he learned to fight like a barbarian from the mother while she was able and smithing from the father for the same reason. Figured if he’d been trained since an early age to wear the chains and how to use them and the same for the siege axes that would help backstory wise on why he can walk around with such heavy cumbersome equipment without many of the drawbacks. I mean I have been repeatedly told that backstories are what allow many characters to do things they shouldnt be allowed to do if you follow the wording of RAW to a precise detail right? The next thing I wanted to do is a mount or companion. Since after they died and possibly I his own heart he felt like he didnt really belong anywhere because of the mixed blood he has a fondness for mix breeds and mutts. So i thought why not? While wandering one day he found a cave which stank of death and knowing there was a peaceful settlement nearby (species undetermined but not hostile towards him at least even if he doesnt feel comfortable there.) he decided to go in. What he found was a dark warlock or sorcerer or whatevers abandoned experiment lab where through use of both chemicals and dark magics had been creating their own chimeras or hybrids. Almost everything in the lab had been butchered or already was. The state of the place and stench makes it hard to determine. So he decides to be merciful and move through the horrors of this place one cell at a time and check everything while quickly and painlessly as he can putting down anything that seems to be suffering which is pretty much everything. When suddenly he hears a small whimpering that seems even more out of place. He looked around until he found the source. Surrounded by the corpses of several of the butchers (haven’t decided yet on specific) are a large black male Dire Wolf already dead and an equally large silver coloref female Warg. Between them are several different colored pups who are obviously their litter. Some looked healthy some not so much is a single pup still alive nuzzling the mother and whimpering. It is coal black like the father but has the spotted pattern like the mother in a definite silver color making it resemble what he names it on the spot. “Night Sky” he kept it, nursed it to full heath, and raised it until one day it decided he was its new packmate and it would stay and keep its pack safe.

With the information provided in this situation is this a workable character build for 5e? Or should I stick with 3.5 which is really all I have any xp with at this point. I ask because my little sister and brother in law are trying to wrangle me into a 5e game but I have absolutely no xp with this system and what is or isnt allowed anymore.

Can polynomial many-to-one reduction be done to a specific problem instance?

Let’s say I reduce the problem $ A \in L$ to $ B \in K$ , with a function $ f: \Sigma^{*} \rightarrow \Gamma^{*}$ such that $ w \in L \Leftrightarrow f(w) \in K$ . I know if I want to solve $ A$ , given some polynomial time algorithm for $ B$ , I just have to transform $ A$ to $ B$ and solve $ B$ . So it can be thought as:

The reduction must be done from arbitrary instance of $ A$ to a legal instance of $ B$

My question is, do I have to reduce to arbitrary instance of $ B$ or some instance of $ B$ ? I.e. reduction from TQBNF to Generalized Geography is done to some valid graph instance, but there exist many more valid instances of Generalized Geography.

Restriction: polynomial time decision of instance is why needed to “decision Problem”?

I am reading book “combinatorial optimization 3rd edition(Bernhard Korte、 Jens Vygen)”.

(latest version is sixth.)

There are some discriptions in this book that I don’t understand

Not all binary strings are instances of Hamiltonian Circuit but only those representing an undirected graph. For most interesting decision problems the in- stances are a proper subset of the 0-1-strings. We require that we can decide in polynomial time whether an arbitrary string is an instance or not:

  • quote from p350

decision problem is pair P = (X,Y), where X is a language decidable in polynomial time.

  • quote p351

Why decision problem required that decide in polynomial time whether an arbitrary string is an instance or not?

I can’t found any reasons of this restriction in the book.

SQL Database ‘Project_Content’ on SQL Server instance ‘XXX’ not found – after removing project server

I keep getting this error in event viewer. I reckon project server was installed before on the farm and it has been removed but it seems its still looking for the content database see error below

SQL Database 'Project_Content' on SQL Server instance 'XXX' not found.  Additional error information from SQL Server is included below.  Cannot open database "Project_Content" requested by the login. The login failed. Login failed for user XXX\xx.farm'. 

How can i stop this and where can i inform the SP farm that it doesn’t exist anymore. Thanks in Advance

Restoring the Existing Sharepoint farm using different SQL server instance

How to change the Database server instance of the the existing sharepoint 2013, when its current SQL server database instance is corrupt?

Explanation;

->Sharepoint 2013 server lost all the connections to the SQL server database due to server failure (server farm is setup on virtual machine and SQL server on different Virtual machine)

we were able to retrieve the sharepoint databases(including config and content dbs) which were month old.

we have attached these database to the new SQL server instance created (this time the database instance name is different)

but we are not able to configure the existing SharePoint 2013 server to the new database SQL server instance

we tried running the configuration wizard, and also change the server setting running the cliconfg.exe (C:\windows\system32)

but it still points to the old server instance. can anyone please suggest how to restore these sharepoint sites without re-installing the sharepoint 2013 server

thanks n regards

WebDAV issues since moving SQL instance

We are currently running a SharePoint 2013 farm on-site, and one of our intranet sites is used for file storage & collaboration. For one specific business case, users use a mapped drive to quickly upload files to a given location. The process has worked well for the past few years with no issues.

A month ago we moved our databases to a new SQL instance. We are using aliases for everything, so it was pretty much just a question of updating the alias on each SharePoint server. Everything seems to have gone smoothly, but now I’m detecting what may be a problem.

Out of 400 or so users, I’ve had four users report that they can no longer upload files via WebDAV. Small files seem to work ok, but anything larger than 450-500MB returns the error “Can’t read from the source file or disk.” The problem is intermittent even with these users, and therefore difficult to troubleshoot. The new SQL instance has plenty of room, the content database is large but hasn’t hit any size limits, and manually increasing the WebDAV file size limit in the registry (say, to 1024MB) doesn’t resolve the issue.

In case it’s relevant, we moved from MS SQL 2008 to MS SQL 2017.

Has anyone here encountered this sort of issue before?

Note: Yes, I know using WebDAV and/or storing 400+MB files in SharePoint isn’t ideal, but for the purpose of this question that’s irrelevant. We’ve been using this system for long enough that I know it worked and was stable before the SQL move.

Copy SQL Server DB into another instance without SA access

I’ve two SQL Server databases and both of them are on cloud.

  1. First server is source
  2. Second server is destination

I only have a non SA access. And I’m using DBForge Studio for managing the database. I’m trying to copy the database from the first server to the second server through DBForge→Database Sync→Copy Database and then select copy (I’m following this article).

Note: The database already exists in destination with same name, but no tables yet.

I got an error message when trying to copy:

The EXECUTE permission was denied on the object ‘xp_fileexist’…..

Then I try to copy & overide but I got the same error message.

So I try to use another way like export & import. I export the database from source server into .sql, but there are only queries for insert, it didn’t serve the query for create table schema, and I tried to import into another file like .csv and .xsl but I got the same, it only contain data without schema.

Is there any better way to copy the database without SA access?