Installation (or setup) of a database application, is the act of putting the application onto a computer system so that it can be executed.
9
votes
2answers
8k views
How do I install pgcrypto for PostgreSQL in Ubuntu Server?
I'm using Ubuntu Server 10.10 and I have installed PostgreSQL 8.4 using apt-get install postgresql. I would like to use the built-in sha1() function, but it seems that I have to install pgcrypto ...
6
votes
3answers
3k views
Installing default MySQL Tables in Windows (mysql_install_db)
In Linux, the default MySQL grant tables can be created with the mysql_install_db script, but that does not work on Windows.
How can the default grant tables be installed on Windows?
(No, I’m not ...
6
votes
1answer
145 views
Who installed SQL Server
Is there any way to find out who installed SQL server on a Windows 2003 server?
5
votes
1answer
2k views
Add Oracle Label Security to an existing Oracle installation
We are using Amazon EC2 to host some Oracle database instances while we are evaluating and prototyping some software. We are using the AMIs provided by Oracle - specifically, Oracle Database 11g ...
4
votes
2answers
341 views
Learning Oracle, does it matter if I install 10g or 11g?
I'm taking a class in Databases, they're using Oracle 10g in class, but I'm having some trouble installing the database here in Windows 8 (auth problems), so I thought I'd attempt 11g.
Is 11g ...
4
votes
3answers
2k views
Not able to install any piece of SQL server 2012 dev edition on my windows 7
I have tried everything i can think f to install SQL 2012 but no luck I am getting these errors but after looking through the logs I can't find the actual cause to get a solution.
every feature gives ...
4
votes
2answers
67 views
Database Install Issue
I was navigated over here from Stack Overflow, hopefully you can help me out.
So I've got a dilemma. Our company has bought a volume license for Microsoft SQL Server 2012 Standard Edition. We ...
4
votes
1answer
1k views
Unattended install of SQL Server 2008 R2 cluster fails with error - “Illegal characters in path.”
I am trying to build an .ini file for unattended installations of SQL Server 2008 R2. I followed this blog post to build an initial .ini file: ...
3
votes
3answers
5k views
Where does my.cnf get stored in Linux?
I am new to linux, and i just installed MySQL-server-5.1.59-1.glibc23.i386.rpm in my linux machine.
I wanted to know where my.cnf file gets stored..?
Will my.cnf gets created with the installation ...
3
votes
4answers
377 views
Is it advantageous to scale out using multiple SQL Server instances on the same server?
For a use-case of 9 databases spread across 3 time zones, is it advantagous to spread the databases onto multiple SQL Server instances on the same server?
What will I gain and what will I lose? ...
3
votes
1answer
100 views
Why SQL Server installs multiple services for AS and RS, but only one for IS?
When I install multiple SQL Server instances on a same computer, every instance gets its own SQL Server Service for Analysis Services and Reporting Services. But I get only one service for Integration ...
3
votes
2answers
7k views
How to run psql on Mac OS X?
I installed PostgreSQL on a computer with Mac OS X using the One click installer. Then I try to access PostgreSQL using the psql command, but it doesn't seem to be available.
I get this message:
...
3
votes
2answers
1k views
DB2 Express-C on Mac OS X
I have followed all the steps described on the Getting Started with DB2 Express v9.7 e-book and installed DB2 Express-C on my Mac. The installation succeeded without a problem.
I did setup OS X ...
3
votes
2answers
840 views
Oracle 11g setup closes without errors on pre-requisite check
I'm installing Oracle 11g and the setup wizard just closes automatically after the pre-requisite check.
I have administrative access
UAC is disabled
IPv6 is diabled
There is more than enough free ...
3
votes
3answers
598 views
Setting up SQL Server 2008 R2
I need to set up a SQL Server for a development environment for a client. First I installed SQL Server 2008, I was able to connect to it from SQL Server Management Studio fine but when I tried to ...
3
votes
1answer
154 views
Microsoft SQL Server 2008 R2 Developer Edition Data Tuning Advisor tool
I have Microsoft SQL Server 2008 R2 Developer Edition installed on my machine which has Win7 64 bit OS.
I am not able see Data Tuning Advisor tool in my SSMS. Before this installation my machine ...
3
votes
1answer
1k views
Installing 10g client next to 11g database on same computer
I have Oracle 11.2.0.1.0 installed on Windows 7 64 bit
I want to import data from warehouse which has Oracle 10.2.0.4.0 installed.
When I try to import
impdp usr/pass@WAREHOUSE TABLES=TABLE ...
3
votes
2answers
443 views
Errors after installing mysql
After installing mysql I get the following errors:
> 120105 6:02:49 [Warning] Setting lower_case_table_names=2 because
> file system for /usr/local/var/mysql/ is case insensitive mysqld:
> ...
3
votes
1answer
224 views
SQL Server 2008 Setup Error 0x80070490
I am trying to install SQL Server 2008 x64 on Windows 2008 R2 and keep getting the following error:
SQL Server Setup has encountered the following error: Element not
found. (Exception from ...
2
votes
1answer
2k views
Installing Oracle 11g XE on Ubuntu 12.04
I have spent the last 6 hours trying to install Oracle 11g on Ubuntu. Obviously, I'm not the only one who has struggled with this, as there is a lot of (often misleading) "documentation" online on how ...
2
votes
2answers
136 views
How to specify the system database location when installing SQL Server?
It seems that we can't specify a location for the system databases when installing SQL Server. I want to know whether this is true. Take a look at the image I attached.
Thanks!
2
votes
3answers
449 views
how to install mysql on mac?
My Mac runs Mac OS X, version 10.7.5., so it's a 64 bit system.
First, I downloaded mysql-5.5.28-osx10.6-x86_64.dmg.
Then I double clicked mysql-5.5.28-osx10.6-x86_64.dmg, it's mounted, and shows
...
2
votes
1answer
73 views
Microsoft Baseline Configuration Analyser on Production
I came across an useful tool that Microsoft has released for configuration analysis. It's called Microsoft Baseline Configuration Analyser 2.0.
I downloaded and ran it on my local instance and got a ...
2
votes
1answer
520 views
How do you set the MySQL password on Mac OS X?
I've downloaded mysql 5.25 on mac os x Lion (10.7.4). I just tried setting my password in the usual way, however I'm getting an access denied error which is odd:
[user@Macintosh:~] #mysqladmin -uroot ...
2
votes
1answer
1k views
SQL Server 2008 R2 64bits repair error
I had to reinstall the default server instance on one Windows 2008 R2 server.
I checked that the sql groups were cleaned and the registry keys cleaned before reinstalling.
After reinstalling, the ...
2
votes
1answer
76 views
PostgreSQL CREATE EXTENSION file not found error on Mac OS
On PostgreSQL 9.2.3 when trying this:
CREATE EXTENSION btree_gist;
I get this error:
ERROR: could not open extension control file "/opt/local/share/postgresql92/extension/btree_gist.control": ...
2
votes
1answer
3k views
SQL Server 2012 installation failure An error occurred for a dependency of the feature causing the setup process for the feature to fail
I am installing SQL Server 2012 Developer (from ISO image written on DVD), my machine has Windows 7 (Edit: Windows 7 with service pack 1) and it already has SQL Express and SQL 2008 R2 Express ...
2
votes
1answer
527 views
SQL Server 2005 Tools makes SQL Server 2008 Express install fail
When I tried installing SQL Server 2008 Express, the install failed due to this line. How can I circumvent this, or fix the issue?
2
votes
1answer
113 views
PostgreSQL EXCLUDE USING error: Data type integer has no default operator class
In PostgreSQL 9.2.3 I am trying to create this simplified table:
CREATE TABLE test (
user_id INTEGER,
startend TSTZRANGE,
EXCLUDE USING gist (user_id WITH =, startend WITH &&)
);
...
2
votes
1answer
555 views
SQL Server 2012 setup fails immediately (Error result: -2067529723)
I am trying to install SQL Server Enterprise Core 2012 w SP1 64bit (as downloaded from the Microsoft Partner Program site) on a 64-bit Windows 2008 R2 SP1 server. When simply right-clicking on ...
2
votes
1answer
515 views
Cannot install DB2 Express C 10.1 on Mac OS X 10.7.5
When I invoke ./db2setup it cannot find the JRE where it expects it. Binary for Java not found as follows:
/private/tmp/db2/expc/db2/macos/install/db2setup: line 606: ...
1
vote
2answers
171 views
When installing Oracle, what's the quickest way to check rpm packages and install what is missing?
When installing Oracle, there is a step which is to install all necessary packages. I use the following command to test whether a package is installed and install them if they are missing:
rpm -qa | ...
1
vote
1answer
80 views
sql server express install administration
is there a way to install sql server express without administration right?
Is there a portable version?
tank you
(I need to test sql server on my computer before using the server but I dont have ...
1
vote
2answers
163 views
To find a version for your pc check with the software publisher install mongodb
I want to install MongoDb on windows 8 but when i try to run C:\mongodb\bin\mongod.exeiget this error:
To find a version for your pc check with the software publisher.
1
vote
1answer
235 views
Determine sql server installation (server or client tools only)
Think about the situation that you have a software audit.
The company use a software facility management tool to determine installed software on a machine.
This software that seek for installed ...
1
vote
2answers
2k views
How do you install MySQL 5.1.34 on CentOS 5.5?
I am trying to install Mysql 5.1 on cent OS. I researched a lot but could not find any link which gives step by step procedure. Everywhere, there are vague answers. Can someone please give me steps ...
1
vote
1answer
70 views
Can I install an additional oracle database on one node of an oracle cluster (RAC)?
Let's say I have a two-node Oracle RAC environment. Can I install an additional Oracle database on one of the node?
Thanks.
1
vote
2answers
789 views
Oracle XE Fedora 15 Installation problem
I got a problem installing Oracle XE on Fedora 15. Hope you can help me.
I used this tutorial(that worked great for F14) but didn't got lucky with F15.
The problem is that during installation goes ...
1
vote
2answers
254 views
why can I only install MySQL 5.1 on cent OS 6.2?
I had Ubuntu 10.10 on my server and MySQL 5.1 version. But since i wanted to update the system, I installed a fresh version of Cent OS 6 only so I could install the latest version of MySQL. But after ...
1
vote
2answers
2k views
How is localhost resolved by Oracle listener?
When I o an Oracle test installation on a Windows server accepting mostly the defaults, I end up with a listener.ora like
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = ...
1
vote
1answer
126 views
How can I skip reboot check and remove command line appearing during install of SQL Server?
While i am installing SQL Server 2008 R2 using the configuration file method I sometimes get an error in installation due to system reboot checking.
After restarting my PC, SQL Server installs ...
1
vote
1answer
258 views
PowerShell error for installation SQL Server 2012 RTM Developer on Windows 7 X64
I had a lot of grief with upgrading from 2008 R2 and PowerShell. Created a thread but doesn't seem to be promising to solve it, so de-installed, and now I am installing from scratch 2012 .
And ...
1
vote
2answers
2k views
How to install MySQL 5.1 on Ubuntu 10.10?
I researched a lot but could not find any link which gives step by step procedure. Everywhere, there are vague answers. Can someone please give me steps to be followed to install Mysql 5.1 ?
It gives ...
1
vote
2answers
624 views
How to install MySQL server on Mac (OS X 10.6.8) from command line?
How to install MySQL server on Mac (OS X 10.6.8) from command line? If I donwload the .dmg file, is it possible to install it from command line?
1
vote
1answer
207 views
Installing Sphinx on Mac OS with XAMPP
We have:
Sphinx 2.0.3
Mac OS 10.6.8
XAMPP 1.7.3 (with MySQL 5.1.44)
Here is PATH:
user:sphinx-2.0.3-release user$ echo $PATH
...
1
vote
2answers
6k views
Oracle11.2g post-installation problem on Oracle Linux kernel
[question copied from stackoverflow]
After installation of Oracle 11.2g in silent mode on the Oracle Linux kernel, I have the following error:
[u01/app/oracle/product/11/bin] $ sqlplus
sqlplus ...
1
vote
1answer
598 views
I am getting an error while trying to download binary for mysql 5.5.11
I am trying to upgrade MySQL 5.1 to 5.5.11 on Ubuntu 10.10. Everytime I try the wget command I get this error:
wget ...
1
vote
1answer
930 views
SQL Server 2005 collation issue during installation
Every time I try to install SQL Server 2005 on to a Windows 7 machine it installs properly but the collation installed is sql_latin1_general_as instead of sql_latin1_general_cp1_ci_as. I have read ...
1
vote
1answer
170 views
Oracle Application Server 10g Installation Process
I downloaded Oracle Application Server 10g from this Oracle site. It has 4 .cpio files for the Linux installation. How do I unzip and install it on VMWare?
1
vote
2answers
50 views
Dictate edition during unattended install?
I am creating an automated build of SQL Server installation which is run from a batch file. Is there any way to change the registry, or other method, of deciding which SQL Server edition (Either ...
