Questions tagged [installation]

Installation (or setup) of a database application, is the act of putting the application onto a computer system so that it can be executed.

Filter by
Sorted by
Tagged with
1 vote
1 answer
1k views

FirstResponderKit - missing objects

our vendor has recommended us to use your tool to collect data for him. After the installation (version 8.03) we received following errors (warnings): *The module 'sp_AllNightLog' depends on the ...
ondrej80's user avatar
0 votes
1 answer
376 views

How do I know my Oracle database is correctly configured and running?

I've installed a fresh Oracle 19.3 on Linux CentOS 8.3. I used the install steps (manual install) from this official Oracle guide. I tried to start the DB using the standard script: [oracle@localhost ...
sugarman's user avatar
-1 votes
1 answer
66 views

Best Database to be shipped with my application? [closed]

I have a .NET core application using a database. I need to create an installer using NSIS where I will be packaging my application along with a database, so that the client can easily install my ...
Dragon's user avatar
  • 99
0 votes
0 answers
465 views

Postgresql server appears not to be running after install

I installed ubuntu 12.6 on Ubuntu 20.10. I had a postgresql version 10 once running on my system. I purged it before installation with sudo apt --purge remove postgresql postgresql-contrib. The ...
Arnold's user avatar
  • 101
1 vote
2 answers
539 views

How to script server level objects in sql server?

I regularly do sql server installations (mainly sql server 2016), in virtual machines or otherwise, and I have a bunch of things like permissions, and linked servers and endpoints that I have mostly ...
Marcello Miorelli's user avatar
0 votes
0 answers
39 views

SQL Server 2019 unable to install error [duplicate]

When installing SQL server 2019 receiving installation error. Error log Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068052377 ...
Munkhorgil Batbileg's user avatar
0 votes
2 answers
4k views

Can no longer connect to localdb after updating from Sql Server 2016 to 2019

I need to restore a backup for an assignment, but SMSS said I was running v13 while the backup was made in v15. So I downloaded and installed SQL Server Express 2019 and uninstalled the older version. ...
FDM's user avatar
  • 101
0 votes
1 answer
1k views

SQL Server 2019 install - Python and R failing

I'm installing SQL 2019 Enterprise on the first node of a failover cluster. Everything successfully installs except Python and R. Error messages are as follows: Feature: ...
camaro322hp's user avatar
-1 votes
3 answers
2k views

How to create a Postgres instance [closed]

How do I create a (new) Postgres instance on Windows Something along the lines: C:\postgresql\psql --create-server -name=MyAwesomeServer -host=localhost, etc.etc. I want to specify everything needed ...
JDOaktown's user avatar
0 votes
2 answers
766 views

MySQL server will not start/stop

I am currently in the process of setting up a database in MySQL for an application where I will be running PowerBI to do analyses on the data in the database and in a further stage to design an ...
SDR3078's user avatar
0 votes
1 answer
311 views

MariaDB default utf8

The installation puts character-set-server=utf8 in my.ini by default. Is it better to use utf8mb4 instead of clean utf8 and if Yes, why utf8mb4 is not set by default?
i486's user avatar
  • 225
0 votes
1 answer
1k views

Connecting to local Oracle Server via MacOS SQL Developer

I am new to Oracle SQL, but I want to give it a shot and play around with the HR schema. I don't want to use a VM, because I had a lot of issues with them. Setup: Oracle Server setup on WIN64 PC. HR ...
ben.reisinger's user avatar
1 vote
0 answers
167 views

What's the problem with my password while installing Apex 20.1?

I am installing Apex 20.1 on my windows 10 with oracle 19c. After running the command : @apxchpwd.sql I get this error even after respecting all the password regulation and trying different ...
Chadi Hani's user avatar
1 vote
1 answer
624 views

SQL Server Configuration File and InstanceName parameter

We have a configuration file at E:\SQL_Server_2016_Install\MyConfigFile.ini that looks like below: [OPTIONS] ACTION = "Install" FEATURES = SQLENGINE INSTANCENAME = MSSQLSERVER AGTSVCACCOUNT =...
Aleksey Vitsko's user avatar
0 votes
1 answer
172 views

MAXDOP Setting on a SQL Server [duplicate]

When upgrading and creating my new SQL server farm on 2016 I researched things to set on the server, one being MAXDOP setting. From reading up about the setting I have set it at 8 on a server that has ...
Garry's user avatar
  • 73
1 vote
1 answer
1k views

SQL Server Command Line Install - How to change the edition?

I am creating a script to install SQL Server via the command line. I cannot see a way to choose the edition I want to install. The GUI on my install media offers Evaluation, Developer or Express: (...
SE1986's user avatar
  • 1,960
0 votes
1 answer
32 views

MySQL - can't see end of

I am trying to pick the MySQL charset combination which is correct. Unfortunately, at least on my screen, the list of options is very narrow and doesn't show the full text of the options. I want to ...
Statsanalyst's user avatar
2 votes
1 answer
27k views

MySQL - "Visual Studio must be installed" - but it is?

When using the MySQL installer, it says "Visual Studio version 2015, 2017 or 2019 must be installed". I have installed Visual Studio 2019 and "MySQL for Visual Studio", but it ...
Statsanalyst's user avatar
0 votes
1 answer
2k views

Need help installing ODAC 122011x64 so I can connect ADW to Power BI

So I have successfully installed Oracle DB 19c and connected it to Oracle SQL Developer. I am able to create tables and run queries. Furthermore, I can connect to ADW with both python and SQL ...
Andrew Hicks's user avatar
0 votes
1 answer
46 views

SQL Server 2017 MLS - cant add python package

I'm new-ish to MLS and have been trying to add new python packages like  attrs  to the python but it hasn't been working. Our set up is SQL Server 2017 with CU14 on Win 2016. Python version is 3.5.2 ...
steve's user avatar
  • 111
0 votes
1 answer
50 views

SQL Server 2017 installation unauthorized error

I'm getting the below errors while installing SQL Server on a Windows machine. I'm using my admin account which has permissions (I’m in Administrations group. Verified here -> Computer management -&...
Jetr_forever's user avatar
0 votes
1 answer
669 views

How to install HANA DB on Oracle Linux 7?

I want to know how to install SAP HANA DB 2.0 on Oracle Linux 7 including downloading, installing and the first connection establishing to the system from network. I've spent a few hours to find out ...
Gryu's user avatar
  • 285
0 votes
1 answer
1k views

Adding Python package to Sql Server 2017 machine learning services breaks it

I am trying to get started running python inside of Sql Server 2017 with Python Machine Learning Services. Out of the box it works and I can run simple scripts like listing the installed packages: ...
AsbjornB's user avatar
0 votes
1 answer
7k views

Install mysql through deb file on ubuntu 20.04

Hi I've downloaded the file mysql-server_8.0.21-1ubuntu20.04_amd64.deb-bundle.tar from mysql site. I've extracted it to see below list of deb files libmysqlclient21_8.0.21-1ubuntu20.04_amd64.deb ...
Ajeetkumar's user avatar
2 votes
0 answers
2k views

Oracle BI 12C (12.2.1.4.0) Configuration Assistant Error (Adding default service instance) on Windows Server 2016

I'm installing Oracle BI Pub 12c (12.2.1.4.0) on Windows Server 2016, all steps were successfully passed but on "Add Default Service Instance" it throws below error Not sure what to do now, ...
user avatar
1 vote
1 answer
6k views

Cant install SQL Server 2019

I have a single node Windows 10 Pro machine, 64 bit, with 32GB Ram and an i7 processor. When I try to install the developer edition of Sql Server 2019, it fails installing the Database engine with a ...
bilpor's user avatar
  • 111
0 votes
2 answers
11k views

Can't find missing packages Oracle Linux 8

super newbie here. Trying to learn DBA stuff. I've been trying to install oracle database 18c on Oracle Linux 8 but there are two missing packages that are just not being found. I need these to ...
Cute Cake's user avatar
0 votes
1 answer
160 views

Is there a way to optimize the process of uninstalling and installing SSMS?

in terms of patching sql server 2016 to the latest cumulative patches, I found out that stopping the services helps avoiding lots of inconveniences, specially if there is log shipping and replication ...
Marcello Miorelli's user avatar
4 votes
1 answer
6k views

Is there a way to automatically upgrade DBeaver?

I am trying to update DBeaver Community Edition 7.0.3 to (currently) newest 7.1.0 edition on Fedora 30. When I start DBeaver a "Version Update" window pops up with buttons as options to Upgrade and ...
NikolaS's user avatar
  • 232
1 vote
1 answer
6k views

Oracle19C installation is stuck at executing datapatch in Windows 10 using dbca

I tried using dbca. There are no errors. It just hangs. I tried leaving it running for 4 hours. It is always stuck at 36% even after multiple tries. Logs: [progressPage.flowWorker] [ 2020-05-25 00:...
Aegon's user avatar
  • 11
0 votes
0 answers
3k views

Failed to add 'Admin user' to %2% user group in Oracle 19C Windows 10 installation

Oracle 19c installation fails with this error message. I am trying to set up oracle for my 'Existing Local User' account Installation logs tries to add Admin user to all groups and fails .it says ...
Aegon's user avatar
  • 11
0 votes
0 answers
449 views

Removing postgres connection installed with EnterpriseDB on MacOS

I had earlier installed Postgres using Enterprise DB which is installed by default at location: /Library/PostgreSQL/10 However, because of some database issues I had to uninstall it. I followed all ...
Jio's user avatar
  • 113
0 votes
1 answer
293 views

What is the correct way to present the disks to ASM?

Hello I would like to know which is the correct way ... or the most recommended way to present the disks to ASM, for example: I have 3 disks mapped to a server (rhel7) orasys, orafra, oradata, with dm-...
miguel ramires's user avatar
1 vote
1 answer
497 views

Full Text Search :SQL Server 2012

I want to enable full text search in sql server the feature already checked in the installation but in sql when i make this query select serverproperty('IsFullTextInstalled') The value 0 should be ...
م. أماني مفيد's user avatar
0 votes
0 answers
3k views

Postgresql 12.2 "Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed" on windows 10

I get this error whenever I try to install Postgresql 12.2 "Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed". I followed ...
user8714896's user avatar
1 vote
1 answer
300 views

Should an account be set up and used solely to install SQL Server?

I'd like to follow best practices. However, is it overkill to create a new service account (with minimal access and no special rights) and then use that account to install SQL Server? Are there ...
LeSteelBox's user avatar
3 votes
0 answers
17k views

/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)

I had to install MySQL on Ubuntu 18.04.4 LTS (GNU/Linux 4.15.0-1065-aws x86_64) But it produces errors: ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/...
Bao Nguyen's user avatar
9 votes
3 answers
22k views

How can I install the SQL Server PowerShell module on an offline machine?

I have some SQL Server machines that cannot connect to any external sites. I have been using PowerShell more and more when managing databases, so I definitely need this module to be installed so ...
Marcello Miorelli's user avatar
1 vote
2 answers
973 views

Properly determine SQL Server version and update level

I have some existing code which tries to read the current version of SQL Server that's installed for a particular instance name by using a WMI query. It checks the first dotted part of the VERSION (...
Miral's user avatar
  • 111
0 votes
1 answer
690 views

DBCA and can't init database

SQL> startup; ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/app/oracle/product/12.2.0.1/db_1/dbs/initAWSDB.ora' I created a new Oracle 12c ...
GettingStarted's user avatar
7 votes
1 answer
2k views

How can Cumulative Updates to SQL Server 2019 be Slipstreamed into a Single Installer?

I'd like to take the latest version of SQL Server (SQL Standard, 15.0.2000.5), and apply the latest CU to it so that I have a single installer, thus reducing the size of the resulting package. The ...
CJBS's user avatar
  • 121
1 vote
1 answer
1k views

Postgres initialization of pg_basebackup

Hi Im running on a centos 7 machine, Im in the process of migrating an old postgres database to the new server, it has like 10TB of data so Im trying it with pg_basebackup. The new server has an ...
Imanol Y.'s user avatar
  • 785
2 votes
1 answer
1k views

SQL Server 2019: InitPersistentVersionStore failed after installing CU2

I have installed SQL Server 2019 CU 2 over a vanilla install of SQL Server 2019 RTM. Now I am puzzled by the following messages in the error log at startup: RecoveryUnit::...
Martin Guth's user avatar
16 votes
1 answer
10k views

What is AzureAttestService?

We started the installation and configuration of SQL Server 2019 on Windows 2019 and noticed after install a new service named 'AzureAttestService' was running and set to automatic. Services list the ...
SQLDBAND's user avatar
  • 355
0 votes
1 answer
292 views

Cross-Domain SQL Server Service Accounts

I am working on a project in which we wish to have SQL Servers in a test domain make use of accounts in a development domain so that we don’t have to manage multiple forests of accounts. We’ve ...
John M's user avatar
  • 1
0 votes
1 answer
273 views

SQL Server Command Line install - Default database directories

Is there any way using the Command Line install method, I can specify a custom location for the system databases? I want them to be in D:\SqlServer\Data or is this only way to do this to install ...
SE1986's user avatar
  • 1,960
0 votes
1 answer
142 views

What are the parameters to install oracle 11g r2 command line?

I'm trying to install oracle 11g R2 using a responsefile. I do like this: ./runInstaller -responseFile /home/oracle/database/response/db_install.rsp But when I execute the command, it always open my ...
Astora's user avatar
  • 713
5 votes
2 answers
24k views

how to list all features installed in a sql server instance?

There are other Installation related questions with similar details here and here. I could not find anything related to listing the installed features in sql server 2016 though. I can do it manually ...
Marcello Miorelli's user avatar
0 votes
2 answers
66 views

Installation and shell to move physical and logical SQL Server in azure IaaS VM

Firts of all excuse my english is not my primary language. We are creating an azure template to deploy an IaaS machine with disks C and D with windows server, and the idea is also deploy an ...
Andres Arango's user avatar
1 vote
0 answers
8k views

I can't successfully install postgreSQL. 'Problem running post-install step' error message pops up

I have successfully installed postgreSQL previously, but I am struggling to install it in one particular machine (Windows 8.1 Pro). Everytime I try to install it I get the following message: Warning ...
Pitrako Junior's user avatar

1
2
3 4 5
13