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.
610
questions
0
votes
0answers
16 views
How to setup Network in Desired State Configuration for SQLSetup - Action = "InstallFailoverCluster"
I am looking to setup the network addressing correctly.
Configuration SQLInstall
{
node localhost
{
SQLSetup 'InstallSQLClusterNode1-2019'
{
Action = 'InstallFailoverCluster'
.
.
.
...
0
votes
0answers
46 views
Oracle 19c new Installation Hostname and IP Address Issue
I have installed Oracle 19c DB in my windows VM and it gave me below error, I used the oramtsctl.exe command to attach the Hostname and IP address, but hostname addition failed.
Now I am only able to ...
0
votes
0answers
73 views
Reinstalling Oracle 19c on Windows 10. Fatal Error in Oracle Database Configuration Assistant
I have tried many times to reinstall Oracle 19c. Every time, when I run setup.exe I get an error on the installation step that says [INS-20802] Oracle Database Configuration Assistant Failed. In error,...
0
votes
0answers
29 views
Getting problem in SQL installation. Error messages are coming
I am getting some problems with SQL installation. first SQL 2008 was installed on my computer.
I uninstalled it on installed SQL 2014. After installation, although it was running fine, I was not able ...
1
vote
1answer
111 views
Differences between MariaDB docker tags
I need to install MariaDB 10.5 latest GA with docker.
What is the main difference between the following tags?
10.5.11-focal
10.5-focal
10-focal
focal
10.5.11
10.5
10
latest
0
votes
2answers
496 views
SQL Server Management Studio 18 setup fails after splash screen
I'm trying to install the latest SMSS version on Win 10.
I also had Visual Studio 2017 and Visual Studio 2019 Community, and all .Net runtimes and the DevExpress Framework which came also with some ...
0
votes
0answers
44 views
Can't create a Postgres extension for pgaudit
I compiled pgaudit on Windows10 using Visual Studio. I added shared_preload_libraries = 'pgaudit' and restarted the server.
When I try to add the extension, I get:
ERROR: could not find function &...
0
votes
0answers
58 views
Root Directory for multiple instances
I ve setup a new SQL Server 2019 and the default root path (during installation) was left at c: drive. Changed all the other paths for user-data-log files as well as tempdb and backup to different ...
0
votes
0answers
26 views
Install LocalDB feature with SQL Server Express as a CLI feature argument
We have been trying to install SQL Sever Express with all the necessary features using the CLI, it seems that LocalDB is not being installed.
This is what the flags look like:
'/ACTION=Install /...
0
votes
1answer
37 views
Your database files were created by PostgreSQL version 13 [closed]
OS is openSUSE Tumbleweed. Previously I had PostgreSQL 13 installed. I just removed it by:
> sudo zypper rm 'postgres*'
> sudo zypper rr PostgreSQL
> sudo rm -rf /usr/local/var/postgres
...
0
votes
1answer
137 views
Does my PostgreSQL instance support kerberos/gssapi authentication?
I installed it following instructions from digital ocean how-to-install-postgresql-on-ubuntu-20-04-quickstart:
% sudo apt install postgresql postgresql-contrib
I also did a 'show all' in psql and ...
0
votes
2answers
1k views
How to install mysql server 5.6 on ubuntu 18.04 or 20.04 system?
What are the steps to install MySQL 5.6 on Ubuntu 18.04 or 20.04 system?
I know that MySQL 5.6 version is not available in 18.04 and 20.04 apt repos. Any other way to install this particular version?
1
vote
1answer
196 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 ...
0
votes
1answer
30 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 ...
-1
votes
1answer
35 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 ...
0
votes
0answers
47 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 ...
1
vote
1answer
75 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 ...
0
votes
0answers
53 views
SQL Server silent installation does not work
We need to install SQL Server Express 2008 silently without any user interaction.
I am using this code but in the middle of the installation the user interface comes out
SQLEXPR_x86_ENU.exe /q
/...
0
votes
0answers
34 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
...
0
votes
2answers
147 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.
...
0
votes
1answer
340 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: ...
-1
votes
3answers
283 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 ...
0
votes
2answers
310 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 ...
0
votes
1answer
70 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?
0
votes
1answer
241 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 ...
0
votes
0answers
86 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 ...
0
votes
0answers
55 views
Credentials error while performing unattended install of mulitple instances
I'm installing multiple named instances of SQL Server 2019 on, the base instance and 5 others (A/B/C/D/E). I'm trying to use a configuration file to setup everything but I keep getting the error:
...
0
votes
0answers
166 views
Oracle 19c express manager not loading, listener will not register https port after exec dbms_xdb_config.gethttpsport()
We just set up a new oracle 19c install on a VM Windows Server 2020. I have been struggling trying to get the Express Manager working. At the end of the installation Oracle notified me that I can ...
0
votes
0answers
31 views
Essbase installation on windows 10 : problem with prerequisites
I would like to install essbase on windows 10 pro, but I have some problems.
I followed this tutorial : here by changing the OS to windows and version to the latest. I picked the files corresponding ...
1
vote
1answer
73 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 =...
0
votes
1answer
80 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 ...
0
votes
1answer
152 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:
(...
0
votes
1answer
23 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 ...
0
votes
1answer
2k 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 ...
0
votes
1answer
829 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 ...
0
votes
1answer
31 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
...
0
votes
1answer
22 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 -&...
0
votes
1answer
232 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 ...
0
votes
1answer
470 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:
...
0
votes
1answer
1k 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
...
2
votes
0answers
686 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, ...
1
vote
1answer
2k 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 ...
0
votes
2answers
3k 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 ...
0
votes
1answer
26 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 ...
0
votes
0answers
693 views
User, group, or role ... already exists in the current database. Changed database context to 'DWConfiguration'. Error code: 0x84BB0001
Most of the question is in the title.
My case concerns MS SQL Server 2017 - Developer Edition.
The error happens during SQL Server 2017 installation process.
While searching for answer online I ...
1
vote
1answer
854 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 ...
1
vote
1answer
2k 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:...
0
votes
0answers
2k 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 ...
0
votes
0answers
168 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 ...
0
votes
1answer
146 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-...
