Tag Info

New answers tagged

0

I believe restarting the applicable windows service will bounce the database. net stop oracleservicexe net start oracleservicexe Alternatively you can connect as sys and provide the password instead of using internal authentication, then bounce the database from there. >sqlplus /nolog SQL>connect sys as sysdba Password: You may also want to check ...


1

Which version are you using? 5.6.? I did however came across this bug, hopefully it helps. http://bugs.mysql.com/bug.php?id=68287


2

For PostgreSQL 9.2 and above there is no postgres system user (by default). It runs as NETWORK SERVICE. Create d:\tablespaces and give the NETWORK SERVICE (SERVICE RÉSEAU in french) "Full control" over it. That should do the trick.


0

You can find Adam Bartoszewicz's instructions here on Google Groups (also published on Pavel Stehule's blog): Download and install PostgreSQL 9.3.4 for Win32 from http://www.enterprisedb.com Download and install Microsoft Visual C++ 2010 Express Lern tutorial http://blog.2ndquadrant.com/compiling-postgresql-extensions-visual-studio-windows The ...


0

You are using plain text dump and that's why it break on those characters. Try with custom format and use pg_restore for restoring the database. check this tutorial Be aware that you need to copy also user rights or recreate them on new machine related with the database.


1

As Cougar9000 found out himself the usage of ephemeral (dynamic) ports is not managed by the application but by the operating system. You can only change it for the whole server. The answer to this question does provide you with the information and links you need. In short you could do netsh int ipv4 set dynamicport tcp start=50000 num=1000 Please note ...


1

x86-64 Virtual Address Space Details: Although virtual addresses are 64 bits wide in 64-bit mode, current implementations (and all chips known to be in the planning stages) do not allow the entire virtual address space of 264 bytes (16 EB) to be used. This would be approximately four billion times the size of virtual address space on 32-bit machines. ...


0

There is nothing wrong in Available Virtual Memory is 8,763,135,270,912. This number is at least 8TB actually starting from SQL Server 2012 this new feature has been introduced in SQL Server 2012 DBCC MEMORYSTATUS output. Below is output of memorystatus on my system Process/System Counts Value ---------------------------------------- ...


0

In Control panel open Administrative tools then double click Services. Scroll down to MySQL and double click to open the properties. Change the Startup type to Manual.


0

On Unix: Oracle is multi-process database. It does not use threads (on the contrary to other databases). Some of the processes are background ones (Oracle internal) the other ones are user sessions processes. They all communicate via IPC (messages, shared ram). When user opens a TCP connection to listener, the listener process forks and then executes(exec) ...


1

The best option is probably to install PostgreSQL 9.1 from http://apt.postgresql.org/ if it's available for your distro/version. If not, you can install a temporary copy of your old Ubuntu version in a VM for recovery purposes - use virtualbox, kvm, etc. Vagrant can make life easier, just grab a prebuilt Ubuntu box from ...


1

The folder C:\Program Files\MySQL\MySQL Server 5.6 is the correct location for my.ini. There are two possible reasons 1400 shows up as table_definition_cache. REASON #1 You did not restart mysql. Login to Windows DOS command line as Administrator and run C:\> net stop mysql C:\> net start mysql Value should be in place afterwards. REASON #2 ...


0

Just a guess, but make sure that at least one of TLS 1.1 or TLS 1.2 is explicitly enabled. It may be that you've mandated a secured connection, but then removed any protocols currently supported by the server that it could use to accomplish this.



Top 50 recent answers are included