The Stack Overflow podcast is back! Listen to an interview with our new CEO.

New answers tagged

0

The only thing that worked for me was to edit the my.ini file using Notepad++ ... do NOT use Windows Notepad as any change will stop mysql from starting. I would guess this is because mysql fails to parse the file, so uses internal defaults which are no good as its looking for mysql master db in 'program files'.


1

I cannot comment yet (reputation low since not very active): But disabling Windows Firewall, like mentioned above, is the worst possible answer. Correct would be: Create firewall rules in "inbound" to allow Port 1433 communication on those local IPs (or all) you need. And I also recommend to set which remote IPs are allowed to connect to that SQL Server.


-1

Try this: Open Oracle Net Configuration Assistant Select radio button option at "Local Net Service Name Configuration", then click "Next" Select radio button option at "Reconfigure", then click "next" Select the net service name you want to reconfigure, either ORACLR_CONNECTION_DATA or ORCL, then click "Next" input your Service Name, if your service name of ...


1

I have re-installed the sql server 2014 and it fixed this issue. I have realized the sql server native client was not properly installed. Thanks your time


1

Assuming that these machines are sitting in the same network domain, have no firewalls between them and that you're running with everything "as standard", then you should be able to access the Database Instance running on PC1 from PC2 using these parameters in SQL Developer: Connection Type: Basic Hostname: PC1 Port: 1521 SID: ...


2

Automating the process is simple once you know what you want to delete. I can give you a few hints: Typically, you want to remove all WAL archives older than the oldest base backup which you want to retain. Whenever a base backup is done, PostgreSQL will archive a file called *.backup. You can use this file as the second argument to pg_archivecleanup to ...


1

You should probably used a canned solution, rather than trying to create your own. However, the only open-source canned solution I know of that explicitly says is supports Windows is pg_probackup, which I have never used. You say you can lose no more than 15 minutes worth of work. So without a streaming solution, your "archive_timeout" needs to be less ...


0

On cmd, type echo %ORACLE_HOME%. If ORACLE_HOME is set it will return you the path or else it will return %ORACLE_HOME%.


Top 50 recent answers are included