Questions tagged [startup]

The Startup tag is for questions regarding startup issues for databases. Be sure to include the appropriate database product and version tags, and operating system tags.

Filter by
Sorted by
Tagged with
-2 votes
1 answer
23 views

postgresql-12.2.service does not exist

After a Centos server restart, unable to restart postgres?? I am getting a Postgres error: Unit postgresql.service not found I have tried every solution on Google, nothing works?? I would appreciate ...
user avatar
0 votes
0 answers
19 views

Database as IPC on ARM proccesor performance

I have multiple processes on my ARM processor which want to communicate with each other. I know there are other mechanisms for IPC except database, but currently, I chose database. My solution uses ...
user avatar
  • 131
0 votes
1 answer
48 views

Postgres (9.6) hangs on start after storage upgrade

I have been running Postgres on a Linode with the data directory mapped to an external volume. Yesterday Linode prompted me to upgrade my storage to NVMe so I did. Unfortunately, following that, ...
user avatar
  • 101
0 votes
2 answers
50 views

MS SQL: Execute Database Request after Server Start

I need to execute a request (Stored Procedure) to MS SQL Server after Windows restart, i.e. as soon as the database is accessible. How can I do that? Is there a possibility to register a database ...
user avatar
0 votes
1 answer
30 views

Need to Alter PostgreSQL Startup on CentOS 7?

I am planning a move of Postgres' data directory from one disk to another on a CentOS 7 server. All of the data and configuration files reside in /var/lib/pgsql/12/data/. I have previously migrated ...
user avatar
  • 37
0 votes
1 answer
19 views

How to start second MySQL instance on boot on Ubuntu 20.04?

I have a second MySQL 8 instance running on Ubunut 20.04, started by this command: mysqld_safe --defaults-file=/home/user/mysqld_replica.cnf & The config file contains all needed settings like ...
user avatar
  • 283
1 vote
1 answer
169 views

SQL Full-text Filter Daemon Launcher with Startup set to Manual is Running after Bootstrap

I have on my Windows 10 PC an instance of SQL Server 2017 Developer edition All the services Startups are set to Manual Today I started the PC and found in the SQL Server Configuration Manager that ...
user avatar
  • 141
1 vote
1 answer
533 views

MySQL no longer starting "An attempt was made to access a socket in a way forbidden by its access permissions." (Windows 10)

I don't think this is another "some other process is using port 3306 rtfm" kinda question. I have been running MySQL 8.0.x fine for a couple of months on Windows 10 for some local python ...
user avatar
  • 121
0 votes
0 answers
48 views

postgresql data on secondary disk, automatic start fails with "not accessible or does not exist"

The OS is Ubuntu 20.04. I moved the data directory to a secondary disk. In the "Disks" utility, I clicked "Edit Mount Options", turned off "User Session Defaults", and ...
user avatar
1 vote
1 answer
2k views

Disable auto-start of postgres server on boot (Mac)

Running a Mac. I installed Postgresql 9 many years ago and configured it to auto-start. Now I have upgraded to version 12 using brew, but on system restart version 9 server is still starting ...
user avatar
  • 155
1 vote
2 answers
12k views

MongoDB start errors

I was following along a course and entered a command that was given mongod --dbpath=data --bind_ip 127.0.0.1 In the past, I had used mongo and it had worked, but I'm sure I had never entered this ...
user avatar
  • 13
0 votes
0 answers
93 views

AIX Oracle 11g db hangs on startup

ENV: AIX 7.1 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bitNo RAC, No PDB. (Pretty plain-vanilla) We recently had an outage of some of our Oracle AIX environments. After the servers ...
user avatar
  • 315
-1 votes
1 answer
83 views

Multiplexing control files error

We can create only 8 control files. If I create 9 files, I should get the error: ORA-00208: number of control file names exceeds limit of 8. But I get the error ORA-03113: end-of-file on ...
user avatar
  • 31
0 votes
1 answer
64 views

How do I figure out how Postgres was installed on my Linux system?

I'm using Postges 9.6 on Ubuntu Linux 16. I'm trying to figure out how the Postgres server was installed so I can figure out a command to start and stop it. It evidently isn't installed as a Linux ...
user avatar
  • 605
1 vote
2 answers
115 views

How to do Postgresql 9.2 version check in Linux?

$ systemctl restart postgresql-9.2.24 Failed to restart postgresql-9.2.24.service: Unit not found.
user avatar
0 votes
1 answer
316 views

Oracle 12c create manual script for automatic startup on RHEL7

I need to create a script to start and shut down a 12c database in rhel7 automatically when the operating system starts and shuts down, it turns out that I have tried the common options with dbstart ...
user avatar
2 votes
1 answer
1k views

Startup Parameters greyed out in SSCM for new instance

We do not appear to be able to change the startup parameters for a new SQL Server instance, using SQL Server Configuration Manager (see screenshot below). We are members of the sysadmin fixed server ...
user avatar
  • 535
0 votes
1 answer
73 views

Calculating the elapsed time of Oracle Database Startup operation

I'm trying to calculate the elapsed time of Oracle Database startup command. The view V$INSTANCE contains the STARTUP_TIME column which tells at what time the database is started. But, i need way to ...
user avatar
  • 123
2 votes
1 answer
61 views

Is there a way to change the compaction throughput via startup options in Cassandra?

We are currently running a Cassandra cluster in K8S containers as Stateful sets. We're considering exposing the config file but we would like to know if perhaps we can provide this value as a startup ...
user avatar
0 votes
0 answers
382 views

Enterprise manager failed to start in oracle 10g

I am using oracle 10g with 4 instance with same server but one of them has failed to start Oracle Enterprise Manager and rest of three are working fine. Starting Oracle Enterprise Manager 10g ...
user avatar
  • 71
0 votes
0 answers
1k views

Cant start Oracle DB due to control file errors

I'm trying to start Oracle db, but it yields an error which is shown below: I have checked the control_files and these are listed below: Check the accessibility of both files: $ ll /app/...
user avatar
1 vote
1 answer
222 views

How to stop MySQL recreating SSL files on restart

We're using MySQL 5.7.22. Each time I restart MySQL it creates a set of SSL files ( ca-key.pem etc) in the datadir. The problem is that I already have these files on the server, in /etc/mysql/ssl. ...
user avatar
  • 1,920
6 votes
2 answers
311 views

How to control position of startup predicate in the execution plan

For two last statements of the code below produce actual execution plan. You can see that startup predicate on @Par1 is placed in a different position that completely changes the actual number of rows ...
user avatar
0 votes
2 answers
2k views

Getting MySQL start and shutdown time

How to write a trigger that updates a table before startup and shutdown of the database in MySQL 5.7 ? Any suggestions that could be helpful to us?
user avatar
0 votes
1 answer
1k views

Why my Oracle 12c database seems not to be started?

I have installed an Oracle 12c database on my development environment, which I start only once a while for integration testing. But today, it does not seem to start, or did it start but does not allow ...
user avatar
0 votes
1 answer
1k views

Unexpected Shutdown affects SQL Server DB start at OS start up

I have an application that uses a sql server db (SQL Express 2008 R2) and starts when Windows OS starts. When the pc shutdown unexpectedly and then restart the pc the application run automatically but ...
user avatar
  • 253
15 votes
2 answers
3k views

When is the SQL Server database ready to accept queries?

In the SQL Server error log file I found the following lines: 2018-02-22 14:10:58.95 spid17s Starting up database 'msdb'. 2018-02-22 14:10:58.95 spid16s Starting up database 'ReportServer'. ...
user avatar
  • 253
-1 votes
1 answer
432 views

ERROR [XulParser] handler not found: W?NDOW

PDI(spoon.bat) crashes on startup. Here's /logs/spoon.log: 09:59:04,793 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled 09:59:08,932 INFO [KarafInstance] ***************...
user avatar
  • 99
2 votes
2 answers
2k views

Unable to start oracle database after trying to enable archive log mode on

I am facing this unusual issue. I wanted to enable archive log mode from noarchivelog mode and used alter command for the same as ALTER SYSTEM SET log_archive_dest='LOCATION=D:\Oracle\Redo Log ...
user avatar
0 votes
1 answer
58 views

MySQL customized service script for zip installation

We are currently using MySQL 5.7.20 on CentOS and are using zip installation. Since it is a zip installation we do not have service created in /etc/init.d/. Is there any other method for auto-...
user avatar
  • 1,370
1 vote
1 answer
1k views

oracle-xe (11g) service not mounting the database

A few days ago I did a system upgrade to fedora 27 and since then the oracle service doesn't properly start the database, I mean after running: sudo service oracle-xe start the database still down. ...
user avatar
2 votes
1 answer
1k views

Firebird 3.0 service won't start on Windows 7

I have Firebird 2.5 classic server running on Windows 7 on port 3059. This service is set to automatically start up and it works fine. I've installed Firebird 3.0.2 as classic server on port 3050 but ...
user avatar
5 votes
2 answers
3k views

SQL Service Using Group Managed Service Account does not start after reboot

We are using group managed service accounts for our SQL Server 2016 servers. For some reason, when we reboot the server, the service does not start and we see this in the event viewer: The ...
user avatar
  • 563
0 votes
2 answers
670 views

Oracle12c R2 on Windows 10 starts only one of two instances. Manual start results in LRM-00109

I have installed Oracle 12c R2 on my local Windows 10 (64 Bit) machine. For the installation I choose only to install the software. After the installation I have used the tool that comes with the ...
user avatar
  • 113
1 vote
0 answers
3k views

Getting "pg_ctl: No such file or directory" when trying to start Postgres server on Mac

I'm using Postgres 9.5 on Mac Sierra. My postgres db suddenly died, and so I need to restart it, but I'm getting some errors when I try and run /usr/local/var/postgres start below tells the saga .....
user avatar
  • 605
1 vote
3 answers
259 views

Hook to run code when Postgres DB launches

I need to run code when a database/catalog in a Postgres cluster comes online, before any client has connected. Specifically I need to do some cleanup such as dropping/truncating a particular table. ...
user avatar
0 votes
1 answer
1k views

Prevent Firebird's default instance from starting

I want temporarily to use another named instance. Can I prevent the default instance from starting when the PC starts? I am using Windows 8.1
user avatar
1 vote
2 answers
21k views

pg_ctl won't start postgres

I'm new to PostgreSQL. Although I could access a localhost database either with PGAdminIII or psql (eg sudo -u postgres psql mydb), I've not been able to connect from Dart. I think my difficulties ...
user avatar
  • 11
1 vote
1 answer
257 views

is it recommend to set "--setParameter ttlMonitorEnabled=false" for better performance if you don't use TTL Indexes

We run a few sharded clusters and many replicasets. Our customers don't use TTL Indexes. Will there be a better performance if we disable background thread that is responsible for deleting documents ...
user avatar
  • 2,188
2 votes
0 answers
1k views

Start/stop postgresql with pg_ctl or service without root access on RHEL6

We plan to use postgresql on RHEL 6. DBAs won't have root access but they will need to start/stop the databases. They'll be able to do so with pg_ctl as postgres. However databases should also start ...
user avatar
3 votes
1 answer
726 views

SQL Server 2008 service keeps crashing

Problem I have a Windows 7 Ultimate x64 machine running SQL Server 2008 SP3. After creating a local database, when trying to start the service it keeps stopping (crashing). Research I read a lot of ...
user avatar
3 votes
1 answer
1k views

How to know who restarted and what caused SQL Server

I need to know Who restarted SQL Server or What caused automatically to restart SQL Server, I have searched Event viewer for events 17163, 6005, 6006 , 6008 and 6009, but unsuccessful it had returned ...
user avatar
6 votes
1 answer
46k views

How to (re)start Postgres on Windows command line in background?

My local Postgres server is configured to start when the computer starts. I just changed postgresql.conf file and had to restart the server. I did: pg_ctl restart from the command line BUT that ...
user avatar
1 vote
1 answer
3k views

What are the different ways to Warmup InnoDB Buffer Pool in MySQL 5.6?

Warming up a cold MySQL instance is moving all data or the data with the highest probability of getting used to main memory. And, yes, by main memory, I mean InnoDB Buffer Pool. The Buffer Pool is ...
user avatar
2 votes
1 answer
1k views

Oracle DB unix/linux autostart - oracle user no login shell

I have to setup an autostart for a Oracle DB 12c on a RHEL 6.8 OS. The user oracle has no login shell e.g. sudo su - oracle -s /bin/bash I followed a guide for a RHEL setup. The init.d script Looks ...
user avatar
  • 878
0 votes
1 answer
2k views

STARTUP2 mode - command admin.$cmd command: isMaster { isMaster: 1 } keyUpdates:0 writeConflicts:0 numYields:0 reslen:644 locks:{}

MongoDB 3.2.8 is in STARTUP2 mode building indexes at the moment. A replicaset with 3 nodes. 2016-08-15T08:11:19.385+0200 I - [rsSync] Index Build: 387200/2273552 17% 2016-08-15T08:11:19.425+...
user avatar
  • 2,188
0 votes
1 answer
1k views

index-*.wt: encountered an illegal file format or internal - WT_PANIC: WiredTiger library panic - aborting after fassert() failure

One hypervisor went down for 7 seconds and afterwords I couldn't start mongod. See error. Replicaset with 3 nodes. I use /var/lib/mongodb-mms-automation/mongodb-linux-x86_64-3.2.8/bin/mongod. I fixed ...
user avatar
  • 2,188
1 vote
1 answer
1k views

Cannot start both neo4j development and neo4j test servers

I have a Rails application backed by a Neo4j database. I've installed both a development server and a test server, as explained here and here. Each server works fine when started up alone, but if I ...
user avatar
0 votes
0 answers
3k views

SQL Server 2012 service will not start after each server reboot - corrupt SQLBOOT.DLL

When I tried to start the service manually from a command prompt, I get a dialog stating: Your SQL Server installation is either corrupt or has been tampered with (Unable to load SQLBOOT.DLL (HRESULT ...
user avatar
  • 2,028
3 votes
2 answers
3k views

Oracle: Why is DBW terminating my Instance?

I was performing routine administrative tasks on an Oracle instance and I was not able to connect to it. I proceeded to do as follows to reach a diagnosis: I checked for Oracle processes in memory ...
user avatar