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.
76
questions
0
votes
1answer
55 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 ...
0
votes
1answer
31 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 ...
1
vote
2answers
28 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.
0
votes
1answer
144 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 ...
1
vote
0answers
26 views
How does Oracle authenticate a user?
I'm learning Oracle and below is my testing of starting up an Oracle instance and make the database available.
oracle:[~]$ sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Aug 5 09:29:30 ...
2
votes
1answer
487 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 ...
0
votes
1answer
29 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 ...
2
votes
1answer
45 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 ...
0
votes
1answer
2k views
MariaDB startup failure on Ubuntu 18.04
I have installed MariaDb hundreds of times on previous Ubuntu versions, but on Ubuntu 18.04 I'm struggling. After the installation finishes, once I restart the PC, MariaDB starts for around 2 minutes ...
0
votes
0answers
222 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 ...
0
votes
0answers
785 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/...
1
vote
1answer
105 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.
...
5
votes
2answers
249 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 ...
0
votes
2answers
442 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?
0
votes
1answer
486 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 ...
0
votes
1answer
716 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 ...
11
votes
2answers
2k 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'.
...
-1
votes
1answer
316 views
ERROR [XulParser] handler not found: W?NDOW
PDI(spoon.bat) crushes 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]
**************...
2
votes
2answers
924 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 ...
0
votes
1answer
50 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-...
1
vote
1answer
766 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. ...
2
votes
1answer
977 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 ...
4
votes
2answers
2k 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 ...
0
votes
2answers
540 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 ...
1
vote
0answers
1k 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 .....
1
vote
3answers
161 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. ...
0
votes
1answer
781 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
1
vote
2answers
15k 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 ...
1
vote
1answer
174 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 ...
1
vote
0answers
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 ...
3
votes
1answer
584 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 ...
3
votes
1answer
826 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 ...
3
votes
1answer
39k 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 ...
1
vote
1answer
2k 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 ...
2
votes
1answer
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 ...
0
votes
1answer
1k 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+...
0
votes
1answer
907 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 ...
1
vote
1answer
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 ...
0
votes
0answers
2k 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 ...
3
votes
2answers
2k 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 ...
1
vote
1answer
6k views
systemctl startup script gives “WSREP: Failed to recover position” - manual startup works
We have a Galera crash. 3 Nodes on RHEL7.
I can start one node with this command
# sudo -u mysql /usr/libexec/mysqld --wsrep-cluster-address='gcomm://'
160408 13:36:24 [Warning] Could not increase ...
3
votes
1answer
19k views
Get ORA-01157 when startup database
I created a datafile /tmp/encrypted_ts.dbf. When the machine started again, the datafile was gone. When I started it I got ORA-01157, the details are:
ORA-01157: cannot identify/lock data file 54 - ...
0
votes
2answers
2k views
Database not able to startup showing an error in reading control file
On Windows Server 2008 R2, when I am trying to startup Oracle 11g database it shows an error:
SQL> startup
ORACLE instance started.
Total System Global Area 3206836224 bytes
Fixed Size ...
0
votes
2answers
198 views
how to set mogodb in upstart service with authentication in mongodb way
I set username and password in MongoDB every time I have to run this command in terminal:
sudo mongod --auth --port 27017 --dbpath /var/lib/mongodb
As soon as I close terminal, MongoDB db also ...
6
votes
1answer
2k views
How to Start Express SQL Server instance in Single user mode?
I want to start my SQL Server Express instance in single user mode to do some troubleshooting such as restoring the Master database.
I am unable to find the "Startup Parameter" options in SQL Server ...
0
votes
1answer
8k views
Non-RAC single instance with ASM startup query
How to start a non-rac single instance with ASM file system. As in the case of RAC after reboot of server, the ASM and CRS resources startup automatically.. but with non-RAC but with ASM storage, what ...
0
votes
1answer
4k views
mysql won't start, it says Table mysql.plugin doesn't exist
I've had this problem for several hours, and now I'm just tired..
When I try to start MySql from terminal (mac), i get
ERROR! The server quit without updating PID file (/usr/local/mysql/data/127.0.0....
3
votes
1answer
2k views
PostgreSQL on Windows fails to start - 'could not create shared memory segment'
PostgreSQL 9.4 & 9.5 (beta) on my Windows 7 laptop fails to start. In the Windows event log I see the following error:
2015-11-10 13:53:49 IST FATAL: could not create shared memory segment "...
0
votes
0answers
190 views
I cannot start Oracle 11g
I cannot start Oracle 11g after a reboot. Configured Using ASM. I'm New to Oracle domain.
# crsctl start has
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start ...
1
vote
1answer
218 views
PostgreSQL: changing data directory location (sshfs)
I'm trying to change my PostgreSQL data directory initially on my Debian server to my NAS (running also on linux).
To do so, I've mounted it on a specific directory through sshfs (in /mnt/titanBDD).
...
