Operating system produced by Microsoft. Windows is produced in various desktop and server versions.

learn more… | top users | synonyms

1
vote
2answers
1k views

MySql InnoDB tables are missing after restarting

I had a MySql database with a few InnoDB tables. After restarting the server, and starting MySql Server again, I connected to the MySql Server using MySql Workbench, and couldn't see the database at ...
0
votes
2answers
97 views

What is the easiest and best way to migrate data from Oracle in Linux Platform to SQL Server in Windows Platform?

I came to know there is a tool called Microsoft SQL Server Migration Assistant v5.3 for Oracle which can be used to convert the Oracle database to Microsoft SQL. But I have Oracle database in Linux ...
0
votes
2answers
561 views

Error changing mysql 5.6 default port

I've changed my.ini with port=3308 but after restart the service mysql 5.6 is working in the same default port 3306. I've tried in mysql 5.5 and it worked fine. C:\Archivos de programa\MySQL\MySQL ...
0
votes
2answers
159 views

mysqldump with automatically generated export name

When I do database dumps through MySQL WorkBench it picks a filename for me which is the current date (YYYMMDD). Now, I want to do this in a batch file since I want to make weekly dumps automatically ...
0
votes
2answers
83 views

Mysql 5.5.25 must be restarted to connect

We have MySQL v5.5.25 running on Windows Server 2008 R2. Occasionally people are unable to connect, and the only way we have found to fix this is to restart the mysql service. This happens every 2-3 ...
4
votes
1answer
678 views

Ports necessary for Oracle 11g Replication across a firewall?

We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
3
votes
1answer
48 views

Problems while building plpgsql_check on Windows

I try to build plpgsql_check extension by @PavelStehule (Erwin Brandstetter recommended it to me in this answer) on Windows XP 32bit with Visual Studio 2010 (I used this article as a manual). However, ...
3
votes
1answer
144 views

ProcessID Owner with third party app

I am having problems trying to audit a third party app with a SQLServer backend. The app manages users and user access via a SQL table, using a single SQL login to access the databases. I am trying ...
2
votes
1answer
681 views

Unable to start Oracle Database Server : Get an error as I try to start it

I just installed Oracle Database Express Edition 11g Release 2 for windows.It created a short cut icon on the desktop : but as I click this icon I see this dialog box : What is it ? How do I ...
1
vote
1answer
317 views

Upgrading using pg_upgrade on windows fails

When upgrading from postgres 9.2 to 9.3 by following the upgrade procedure found in PostgreSQL 9.3.4 documentation about pg_upgrade, the following command fails: RUNAS /USER:postgres "CMD.EXE" ...
0
votes
1answer
9 views

How to get mysql automatically running when I start tomcat apache on Windows?

When starting my Tomcat Apache Server, I've been having to start up mysql before than using the mysqld command. I was wondering if there was a work around this so that I could have mysql start up when ...
0
votes
1answer
38 views

Toad 9.7.2 for Oracle hangs on Windows 7

I am using Toad 9.7.2 on Windows 7 64 bit. It is generally working fine but there is one problem. When I click on certain tables in "Schema Browser" and then click on "Data" tab to see records in ...
0
votes
1answer
69 views

ORA-01033: ORACLE initialization or shutdown in progress using Oracle Express

I am using Oracle Database 11g Express Edition. I'm on Windows 7-64Bit I get this error when trying to access the database: ORA-01033: ORACLE initialization or shutdown in progress I set up the ...
0
votes
1answer
31 views

Problem using pg_dump in Windows 7

I am trying to copy a remote database onto my local machine using the following command C:\Program Files\PostgreSQL\9.1\bin>pg_dump -h remote_server -U remote_user_name -c database_name | psql -a ...
0
votes
1answer
51 views

How do the Oracle DB instance and the local listener communicate?

It seems this my other question needs some background: Basically, on Windows, how do the Oracle DB instance process and the listener process communicate? Do they use TCP? Is the configuration of this ...
0
votes
1answer
49 views

How to restore data after MySQL Upgrade?

I upgraded from MySQL 5.5 to 5.6 by uninstalling 5.5 and then installing MySQL 5.6. Now that MySQL 5.6 is running, none of my DBs or data is present/visible in MySQL Workbench. I also see that I ...
0
votes
1answer
640 views

MySQL connection timeout error retrieving big results

All of the sudden our MySQL 5.6 server (on Windows server) started to give us this error: "Lost connection to server during query". We never had this problem before and we haven't touch MySQL config ...
0
votes
1answer
717 views

Why does max_connections in my.ini not match concurrent connections in Mysql instance config wizard?

MySQL 5.1.x | Windows Server 2003 Can someone please clarify why max_connections in my.ini is much larger than the manual value I specify in the Concurrent Connections Dialogue? For example, if I ...
-1
votes
1answer
643 views

the environment variables configuration for ORACLE EXPRESS 11g / windows7 32Bit

I can't connect in Oracle Express 11g (windows7 32-bit) and I think the problem comes from the environment variable ORACLE_SID & ORACLE_HOME , how can I get the database instance to do the right ...
2
votes
0answers
2k views

Unable to install postgresql 9.3 on windows 8.1

I have been trying, without success, to get posgresql 9.3 up and running on Windows 8.1 on and off over the last ten days. Here is what I have done so far: I got the windows installer from ...
2
votes
0answers
957 views

SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled

I have two SQL Server instances in an availability group. They are not mirrored. I'm trying to connect to the AG using the MS JDBC drivers (4.0) with a connection string including ...
2
votes
0answers
938 views

oracle crash - not starting

We have a Windows Server 2008 R2 Enterprise x64 Oracle 10.2.0.3 Adempiere - ERP We had a power breakdown at 03.00 AM. At 07.30 AM we started the server At 08.00 our colleagues observed that the ...
1
vote
0answers
11 views

DB2 Express User ID Authority Error

I'm trying to create a sample database in first steps after installing db2 Express V10.5 I've looked at the answers provided below, but I'm not able to resolve my issue. How to grant rights for a user ...
1
vote
0answers
214 views

How to apply a patch to pgAdmin III 1.18.1 on Windows?

A follow-up question to this one: How to apply a patch in PostgreSQL on Windows? There is a lot of .patch files distributed everywhere, but no hints how to apply them (at least no hints that wouldn't ...
1
vote
0answers
1k views

High availability PostgreSQL 9.3 server on Windows

I'm trying to set up PostgreSQL 9.3 server in HA mode on 2 Windows servers. Final solution should be deployed to Microsoft azure network, so there are few limitations. Since Microsoft is doing ...
1
vote
0answers
194 views

Oracle: How to find non-local (background) processes in Windows Machine

Following link advises to find non-local background processes and kill them using following bash script. Solution 1) : without shutdown anything just kill that database processes which are not ...
1
vote
0answers
491 views

Restoring Oracle prod backup to test server with new database name

I need to restore an Oracle production database (aaprod) to a test server that already is home to a test database (aatest) under a new name (bbtest). I have a cold backup of the production database ...
0
votes
0answers
37 views

Update on table deletes the record

I'm having a problem in my oracle database, I have a table PAYMENTS which has an ID (PK) and when I want to update a record: UPDATE PAYMENTS SET AMOUNT = 2000 WHERE ID = '1'; The record with ID = ...
0
votes
0answers
29 views

MySQL “ERROR 1005 (HY000): Can't create table 'foo' (errno: 13)”

Windows Server 2008 MySQL 5.5.39 using the root user with full privileges granted to the DB. I know errno: 13 is a permissions issue. I've seen several answers to this for linux where setting ...
0
votes
0answers
78 views

How to install Slony for 64-bit PostgreSQL 9.3 on Windows?

I have installed 64-bit version of PostgreSQL 9.3.5 from EnterpriseDB installer. Now I want to install Slony-I through Application Stack Builder, but it offers only 32-bit version of Slony, ...
0
votes
0answers
29 views

ODBC Data Source Administrator: Driver name is an empty string

Below you will see a screen shot of a warning in Windows 7. Why would I get this error when opening up "Data Sources (ODBC)"? How can I resolve it? If you can give me some tips on where to start ...
0
votes
0answers
417 views

ora-12705 cannot access NLS data files or invalid environment specified

I have i'm installing oracle in machine 12c, while installing everything goes smoothly but when it reach to database creation it passes two step. cleaning up failed stat copying database file ...
0
votes
0answers
36 views

Oracle Counters for Windows Performance Monitor exceeding handle quota

On several windows 2008 R2 servers with an oracle 11.2.0.3.0 database installation i see the following warning in the eventlog every couple of days: Windows Management Instrumentation has stopped ...
0
votes
0answers
43 views

Infinite loop in MySQL when connecting to database

I am running xampp on Windows - Apache and MySQL start fine, but when I try to go to the directory where I have my example app, it loops infinitely waiting for localhost: The log shows: 2014-08-22 ...
0
votes
0answers
34 views

Reliability of Scimore embedded database

I currently use SQLite for some applications that need a light embedded database. These apps use multiple processes that access the same database. For concurrent write access this is cumbersome. We ...
0
votes
0answers
126 views

How to startup a oracle database with sql plus or with any developer tool without connecting to the Database

How to startup a database without connecting to Database. Actually what I did is I shutdown my database and then my sql plus screen hanged and so closed unhandled. then I tried to connect my ...
0
votes
0answers
540 views

Postgres 9.3 64 Bit Windows 7 and 64 bit Postgres install - cleared password no longer connects

Originally I allocated a password to the postgres database, but for some stupid reason the servers are usually setup with a blank password. I then assigned it a blank password in PGAdmin III, and it ...
0
votes
0answers
22 views

Windows mysql optimal configuration architecture (moca)?

is there a 'mysql optimal configuration architecture (moca)' layout for Windows? I need to set up a brand new dedicated MySQL server for MySQL and would like to follow as closely as possible this ...
0
votes
0answers
67 views

How to move MySQL 5.6 data file on Windows 7

I don't get it. I am administrator on my machine, but I cannot move the data files. I get access denied errors when I attempt to. There was no my.ini in C:\Program Files\MySQL\MySQL Server 5.5, so I ...
0
votes
0answers
59 views

MySQL migration to new hardware + upgrade + huge DB + windows

I am relatively new to DBA work and have a critical task in front of me, I really appreciate any detailed help you could offer. What I have a is a roughly 340 GB MySQL database on a Windows server. ...
0
votes
0answers
197 views

ODBC connection Issue from windows 8.1 workstation

Having an issue with inconsistent connectivity to SQL from Windows 8.1 workstation. I access SQL using an ODBC connection. I connect in the beginning of the day then an hour later try to connect ...
0
votes
0answers
650 views

PostgreSQL Install Error

When I install the server for the first time, when almost finished it reports: (from log file "%temp%\bitlock_installer1376.txt") Loading additional SQL modules... Executing cscript //NoLogo ...
0
votes
0answers
171 views

SQL Server Replication do not replicate DELETE statement

We have two servers A and B. Both of them have SQL Server 2005 on them. A is for data collection, just a "lightweight server". B is for archiving, data manipulation etc. From A to B we have ...
0
votes
0answers
211 views

Create a high availability cluster configuration PostgreSQL for Windows

I want a server to be replicated, here is the scenario: When my primary server goes down or fail I want the secondary or the standby server to take over, I'm using Windows 7 for the primary server, ...
0
votes
0answers
130 views

Performance of large queries on low bandwidth connections

I've been running some measurements on bandwidth needs and the effects of latency on query performance against Postgres 8.3 (waiting for management to approve upgrade) on Windows. SELECTs of various ...
0
votes
0answers
784 views

Install PostgreSQL 9.2 on Windows using WIN1252 encoding.

I had installed PostgreSQL 9.2 earlier and it always installed with the encoding being WIN1252 (the default database was WIN1252). I then some time ago reinstalled it with the encoding being UTF8 (I ...
0
votes
0answers
83 views

Long disk queue when no traffic

I got dedicated disk (RAID 10 - 4 SAS disks) for Postgres. I am bit worried as recently, I see under Windows Resource Manager disk queues like 3+ in the mornings (low traffic hours), like every 30-60 ...
0
votes
0answers
528 views

How to detect when did ocurre ORA-00604?

Today, between 3:00pm-3:30pm, my Oracle 10g database on Windows hanged on twice. Error messages were related to ORA-00604. I'm pretty sure it was some query or queries that some user run as owner of ...