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.
597
questions
-1
votes
1answer
33 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
25 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
37 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
49 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
31 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
1answer
72 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
77 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
61 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
36 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
100 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
80 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
35 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
67 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
24 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
46 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
75 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
73 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
19 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
0answers
693 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
319 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
29 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
19 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
142 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
281 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
606 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
385 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
1k 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
978 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
0answers
12 views
Run MongoDB under a Windows Managed Service Account
In Windows environment can I run MongoDB under a Windows Managed Service Account? the main reason is there is a company policy about PWD expiration each 60 days, and we want to use Managed Service ...
0
votes
1answer
25 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
406 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 ...
0
votes
0answers
537 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 ...
0
votes
0answers
23 views
How to restart an installation of Oracle grid 19c
I would like to know how to perform an installation after trying a previous installation that gave an error.
During the installation of the grid in a RAC 19c I was given an error almost finishing it ...
1
vote
1answer
1k 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
1k 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
103 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
80 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-...
1
vote
1answer
80 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 ...
0
votes
0answers
1k 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 ...
1
vote
1answer
46 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 ...
2
votes
0answers
6k 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/...
8
votes
3answers
4k 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 ...
1
vote
2answers
128 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 (...
0
votes
1answer
183 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 ...
5
votes
0answers
329 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 ...
1
vote
1answer
238 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 ...
2
votes
1answer
274 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::...
0
votes
1answer
73 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 ...
0
votes
1answer
40 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 ...
0
votes
1answer
33 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 ...
