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

learn more… | top users | synonyms

2
votes
2answers
50 views

RMAN DUPLICATE from backup without Target or Catalog: How is the aux instance created?

I am trying to duplicate an Oracle database based on backups to test if they can be used in case of complete system failure. Hence, I want to do this without a connection to the source database. I'm ...
0
votes
0answers
15 views

Application Latency [closed]

I am not sure this is the correct group or not and I don't know which group to post this question.So apologies. We have an SQL Server client application, which take an average of 10 sec to login and ...
0
votes
1answer
12 views

Oracle Database Remote Connection

I've been searching online for a solution to my problem without any luck. I'm trying to connect to a remote server (~ 700 km of distance), but since I'm new in this Database administration world I'm ...
0
votes
0answers
41 views

Postgres wont install on windows 7 64 bit (Failed to load SQL modules into table)

I have been trying to install standard postgres 9.3 onto a windows 7 Machine. every single time it gives the same error: Failed to load SQL modules into table I have tried (from this question ...
0
votes
0answers
10 views

Windows 7 service manager thinks postgresql 9.4 is stopped, but database is up

I have several machines running postgresql 9.4 on windows 7. The database is configured to start automatically after a reboot, and it seems to start ok. pgadmin is accessible, and I can run queries ...
0
votes
1answer
71 views

SQL Server 2016 Install ERROR (Pictures and logs provided)

Can't install, updated Windows Server 2012 R2 fully with all Optional and Important Updates. I enabled a proxy to gain outside access which works (since Windows updates work). There is no anti-virus ...
1
vote
1answer
45 views

Run multiple MySQL instances in Windows

Which is a better way to install multiple instances of MySQL / MariaDB / etc on a single Windows box? Manually setting different ports? Docker? Virtual Box? Something else? (Sandbox, mysql_multi, ...
1
vote
1answer
43 views

pg_dump fails to create a backup when running from System User in Windows Task Scheduler

I am trying to run a pg_dump through a scheduled task in windows. I have two batch files. One creates the task. The other one runs the pg_dump. Even though the pg_dump works with the current user with ...
0
votes
1answer
16 views

SQL Server can't see subst/virtual drive

I have been having trouble getting SQL Server to see subst/virtual drives at all. For example: I've used the subst command to create a F:/ drive that maps to C:/FDrive. The stored procedures use ...
1
vote
1answer
73 views

Accessing impact of deleting ibtmp1 file in MYSQL

There is a file called ibtmp1 and it is consuming 138 GB. I understand, this stores uncompressed data. Do we really need these files or can we delete it? if deleting is fine, then could you please ...
1
vote
1answer
82 views

How can I check the path of my.ini, through the command line?

I would like to know, if possible, how to display (using the command line) the path to my.ini used by the server. I am using MySQL 5.6 inside a windows IIS. I have the following: Program ...
1
vote
0answers
84 views

Windows to DB2 Connection: Connection authorization failure occurred. Reason: Local security service non-retryable error

Error creating SQL Model Connection connection to TSMDB1. (Error: [jcc][t4][2010][11246][3.68.61] Connection authorization failure occurred. Reason: Local security service non-retryable error. ...
1
vote
2answers
21 views

MySQL server feature gap on Windows and Linux

Is there any gap or difference in features of MySQL Server on Windows and Linux? Feature refers to below aspects: common DBMS functionalities such as Stored Procedures, Updateable Views, ...
0
votes
1answer
41 views

should I give dbo permissions to NT AUTHORITY\NETWORK SERVICE?

We're in the process of assessing a new application that will require access to our MSSQL database I've set up a user that is a member of a role only giving it readonly access to certain views in the ...
1
vote
0answers
64 views

Configure Oracle database (first time user)

I am trying to learn how to use Oracle Database. I downloaded the Standard Edition version 12c from here: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html. I ...
0
votes
0answers
36 views

PostgreSQL 9.5 - Implications of setting dynamic_shared_memory_type to none

I'm using pg_upgrade to upgrade some databases from version 9.0 to 9.5 on Windows. I've noticed that running two 9.5 clusters on different ports on the same machine is not possible when ...
0
votes
0answers
122 views

PostgreSQL crash when connection failed

Error log is: 016-02-21 21:22:34 GET DETAIL: Connection matched pg_hba.conf line 83: "host all all ::1/128 md5" .... .... 2016-02-21 21:22:37 GET DETAIL: ...
3
votes
0answers
9 views

PostgreSQL crash when connection failed [duplicate]

Error log is : 016-02-21 21:22:34 GET DETAIL: Connection matched pg_hba.conf line 83: "host all all ::1/128 md5" .... .... 2016-02-21 21:22:37 GET DETAIL: ...
0
votes
1answer
16 views

Prostrct create causes windows batch file to exit

I have a daily job to restore a database from last night's back up before doing other things to it and moving on. I'm trying to automate this with a script, but when I get to the following command the ...
1
vote
1answer
245 views

MySQL 5.6 Server start fails: InnoDB Operating system error number 23

I use a local MySQL 5.6 Server (InnoDB) on a Windows 7 machine to store several schemas of a research project. Until yesterday the system ran without problems. During a query, MySQL Workbench ...
-2
votes
1answer
24 views

Application load considerations, use what you get vs. not all at once

General question: Should I as an application use all resources I can get and thrust the OS schedeuler or should I already do some load considerations for the OS. If so, what metric should I use? ...
2
votes
1answer
135 views

How do you configure Postgres 9.4 for incremental backups and hot standby?

I want to set up Postgres to do incremental backups. I'm using PostgreSQL 9.4 on Windows with a database that weighs about 1GB and has a growing 10000 records each day. I understood that the steps ...
3
votes
1answer
233 views

Using a Different Windows Account for Invoke-Sqlcmd

I'm attempting to make a Powershell script that needs to interact with SQL Server, so part of the script will involve invoke-sqlcmd. However, the script can't be scheduled as a job in SQL Server and ...
1
vote
1answer
146 views

Why do innodb tables get corrupted so easily?

I'm upgrading a legacy system running MySQL 5.1 all the way to MariaDB 10. We're on a brand new Windows server, running XAMPP. I've done plenty of DB migrations in my time but this one has just been ...
0
votes
0answers
35 views

Oracle 11g databse control with Enterprise manager on Windows 7 64 bit error

I am trying to install Oracle 11g on Windows 7 64 bit. I get Successful installation until when I get to connect to the database I got a message error.I login as a Username "Sys" with password and ...
0
votes
1answer
40 views

Update row contents on some condition

For example, let's say I'm building a database for an auction system, in which various users can partake in both selling and bidding on different items, I'd want for an "Auction" instance to also ...
0
votes
0answers
14 views

Is there anyway to check what is the PostgreSQL data directory programatically?

I'm doing an installer to my program and I'd like to check if the databases already exists in the computer. I do this in a horrible way, calling psql -lqt | findstr dbname. If someone knows a better ...
1
vote
1answer
389 views

Installing SQL Server 2012 error

I am installing SQL Server 2012 on Windows 7 Enterprise on a company laptop. I am getting SQL Server Setup failure An invalid return code was encountered waiting for a program to execute. ...
2
votes
1answer
1k views

ORA-12546: TNS:permission denied, on Windows through Task Scheduler

I am trying to export all objects of specific oracle user by executing a batch file through Windows Task Scheduler: exp.exe myuser/pass@dbname owner=myuser log=mylog.txt The Oracle 11.2.0.4 x64 and ...
1
vote
2answers
33 views

Recovery of a corrupted database using only the .frm in Windows

Is it possible to restore mysql database using only .frm files in Windows
0
votes
0answers
11 views

Is it possible to create a SQL Server 2012 cluster with the node name becoming the cluster name?

For example, I have a single, stand-alone SQL Server 2012 system that I want to put into a two-node cluster. Due to the amount of effort reconfiguring all the applications that use that server would ...
0
votes
1answer
149 views

Increase sga_max_size on Oracle 10g Windows

i would like to increase the max memory size of one Oracle 10g database installed on Windows. The v$parameter shows sga_max_size 452984832 and sga_target 452984832 Note that the ...
1
vote
1answer
49 views

Can't create a Database on Oracle 11g

I'm new on Oracle and I'm trying to create a new database. I followed tutorials online but the problem seems to be in Windows and not in Oracle. I'm using the Oracle assistant to build my Database ...
0
votes
1answer
60 views

Checking whether my pgAdmin III is a 32 or 64 bits version

I need to check if my pgAdmin III is a 32 or 64 bits version. Where can I find this information? The About... menu in pgAdmin GUI does not mention it (only the version number like 1.20). I've looked ...
6
votes
1answer
1k views

Install MySQL for Windows from .zip and reset root password

I wanted to have on my PC (with Windows 8.1 x64) the MySQL server only, without Workbench or something. So I downloaded .zip archive from dev.mysql.com/downloads. It's a download for Win64 on x86_64 ...
0
votes
0answers
331 views

MySql Workbench 6.3 error with Server Status on Windows 7

I am using 32 bit Windows 7 Ultimate and MySql Workbench 6.3, with WAMP installation (MySQL5.6). I am able to set connection, and run few SQL queries against test named database. But whenever I ...
0
votes
0answers
126 views

Postgres user credentials for copying WAL files to a network storage in Windows

I have 3 postgres server setup with streaming replication - 1 primary and 2 secondary servers, one intended as a failover server and another as DR. I want to setup WAL archiving on to a network ...
1
vote
2answers
322 views

MySQL - Slow InnoDB Write Speeds on Windows 10

I have Windows 10 bootcamped. I've installed the latest version of MySQL community server. I've also installed WordPress onto IIS. The MacBook has 16Gb of memory. Here is my config file [client] ...
1
vote
1answer
139 views

PostgreSQL: Installing a contrib extension on windows

I am trying to install this Temporal Tables extension into my localhost installation of PostgreSQL. (pg9.4, windows 7) I have figured out I needed to put the files into the 9.4/share/contrib folder ...
0
votes
0answers
48 views

Installation of SQL*Plus and SQL Server Management Studio into Windows Tablet

I would like to check if SQL*Plus client and Microsoft SQL Server Management studio (SSMS) are supported in Windows(8.1) tablet? Windows tablets such as Asus or Lenovo MII3/thinkpad 8 comes with ...
1
vote
1answer
109 views

How do flush innodb table, copy files, then unlock tables from Windows bat file?

I can successfully execute "FLUSH TABLES myTable FOR EXPORT;" in MySql Workbench. Then I can copy the cfg and ibd files I need, and then I can go back to workbench and run "UNLOCK TABLES" and all is ...
0
votes
1answer
23 views

MySQL Linux and Windows entity changes [closed]

I have a trigger on an entity that copies the row and saves it in a different entity. I also have 2 MySQL servers one on Linux and the other on Windows. It seems the order of the columns in the same ...
1
vote
0answers
84 views

Connecting to MS SQL server from a Linux box

I am trying to connect to MS SQLServer from an application that I have written (using Qt) which runs on Linux. Here are some details of the setup: The SQLServer box (SQLBox) is part of my domain ...
1
vote
0answers
38 views

Effect of upgrading windows server 2012 data center

I have a production windows server 2012 data center server where IIS and SQL server was installed and replication was configured in SQL Server. It is infected with a malware. After cleaning it with an ...
1
vote
2answers
31 views

MySQL Drive Storage Allocation

In our production servers for SQL Server, we usually split our drives by Software, Logs, Data, and Backups. I've been assigned to help with a MySQL installation (On Windows Server) and I'm not as ...
2
votes
0answers
64 views

Identifying table causing runaway rollback in MySQL 5.5 (InnoDB / Windows)

I have a large database (180 GB), running under Windows, with a runaway rollback that starts running as soon as the database is started up. I have started the database with innodb_force_recovery=3 ...
0
votes
0answers
89 views

Lost my Databases after using Xampp - Mysql (Windows)

This migth seem a newbie seek up question, but I'm intrigued with a problem that arose. I use Windows (ok, I know its not a good OS to deal with database and stuff) and I had Mysql installed with the ...
1
vote
1answer
84 views

How I compact WAL files?

I like compact WAL files. Actually I do: archive_command = 'cp "%p"C:\\%f"' What is the best way to do it?
0
votes
1answer
74 views

Windows ODBC Driver versions for Netezza

I am looking for information regarding the Netezza windows ODBC driver versions. What are the supported/preferred windows ODBC driver versions for Netezza 7.2, Netezza 6.1 and Netezza 6.0. Any ...
1
vote
1answer
1k views

Changing Data Directory on MySQL DB Server

I have installed mysql server 5.6.24 on Windows Server 2012 R2. I imported dump files and the data files are stored in C:\ProgramData\MySQL\MySQL Server 5.6\data I want to change directory like ...