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
22
votes
1answer
239k views

“ORA-03113: end-of-file on communication channel” on startup

I have been reading posts here, on Oracle support, and anywhere else I can find for the last three days and I've given up on this problem... An Oracle database hung. Shutdown of the database sat for ...
16
votes
3answers
57k views

Can't start MySQL server because of wrong file permissions?

I'm trying to start the server and then fix the root user by $ mysql -u root mysql $mysql> UPDATE user SET Password=PASSWORD('my_password') where USER='root'; $mysql> FLUSH PRIVILEGES; But the ...
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'. ...
10
votes
5answers
101k views

Oracle startup error (could not open parameter file)

I installed the Oracle 11g server on Ubuntu 12.10. But I can't start the server. When I start up the server, the following error occurs: SQL> startup ORA-01078: failure in processing system ...
9
votes
3answers
61k views

How to quickly startup/shutdown Oracle 11?

I am wondering what is the quickest way to properly startup/shutdown a Oracle DB daemon (Oracle 11.2, installed on a test machine). I need it for C/C++ programs that use the OCI/Pro*C API. I want ...
7
votes
7answers
232k views

How to solve “Can't connect to local MySQL server through socket” error? [duplicate]

I kept getting this following error every time I tried to restart MySql. It was working fine before I changed the default data directory. ERROR 2002 (HY000): Can't connect to local MySQL server ...
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 ...
5
votes
3answers
23k views

ORA-03113 when starting up an Oracle 11g database

I have read "ORA-03113: end-of-file on communication channel" on startup and others from this site to solve my problem but I still have not solved it. All I get is the following: Microsoft ...
5
votes
2answers
229 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 ...
3
votes
2answers
1k 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 ...
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 "...
3
votes
1answer
514 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
678 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
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 ...
2
votes
3answers
10k views

Computer restarted and Postgres 9.2 service cannot be started?

My firewall is down and when I tried to start the Postgres service it gave me an error that said: the service started and then stopped. Some services stop automatically if they are not in use by other ...
2
votes
1answer
36k 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 ...
2
votes
2answers
2k views

net start sql service with startup option

From this article, I know to that slash (/) is used instead of a hyphen (-) when a net start is used with startup option, net start mssqlserver /m But if I want to have to use with startup option ...
2
votes
1answer
15k 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 - ...
2
votes
1answer
39 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 ...
2
votes
2answers
762 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 ...
2
votes
1answer
889 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 ...
2
votes
2answers
3k views

SQL Server starts normally from Windows Services screen, but shows error through SQL Server Configuration Manager. Why?

I have a SQL Server 2005 instance that has worked fine for years. There have been no changes that I am aware of. Recently, I found that if I stop and then start the instance in SQL Server ...
2
votes
1answer
324 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 ...
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 ...
2
votes
0answers
3k views

Issues in starting MongoDB service

I've installed MongoDB 3.0 in RHEL 6. From root user, I'm trying to start the mongo service but it is getting failed and the log file is not getting updated as well. 2015-10-13T09:53:26.133+0530 E ...
2
votes
1answer
486 views

Oracle database startup fails several times. Giving ksvcreate

Last night my production server database (ORACLE 10.2.04) was showing me number of connection exceeded as some times it show me. Then as usual I shut down abort my database then at the time database ...
1
vote
1answer
5k views

SQL1641N error on linux while running db2start using db2 express c on linux (LUW) but the file system is not mounted using nosuid

I am trying to install and start db2 on my linux machine using the following script: #!/usr/bin/env bash MKDIR=/bin/mkdir RM=/bin/rm TAR=/bin/tar DB2_SERVER_PROGRAM_PATH=/home/alok/Documents/...
1
vote
3answers
143 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. ...
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 ...
1
vote
1answer
614 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. ...
1
vote
2answers
19 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.
1
vote
1answer
5k 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 ...
1
vote
1answer
66 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. ...
1
vote
2answers
13k 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
142 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
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 ...
1
vote
1answer
190 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). ...
1
vote
2answers
407 views

How Can I Read Where TempDB's Files Will Be Created After Restoring Master DB?

I'm restoring to an alternate server in a DR drill and have restored master but can't restart the instance, even with /f and /m switches. The log is indicating tempdb can't be created, probably ...
1
vote
1answer
4k views

startup mount issues with Oracle

I am trying to simply shutdown and restart an Oracle db instance on a Windows Server 2008 machine (Oracle 11.2.0). Logged in via sqlplus, I issue the command shutdown immediate;. I get the Database ...
1
vote
1answer
307 views

Startup procedure for availability replica becoming primary

Is there any way how to create a startup T-SQL script/procedure for starting availability replica (when state has changed from secondary to primary)? I want to disable SSIS jobs specific for related ...
1
vote
0answers
22 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 ...
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
0answers
953 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 ...
1
vote
0answers
7k views

Troubleshooting a SQL Server instance that won't start

I've had a problem with one instance of SQL Server 2008 (the free version) not starting automatically. I always have to right click on the icon in the task bar and start it manually. It is set to "...
0
votes
3answers
5k views

Microsoft SQL Server does not start

I have problem with start SQL Server 2008. I needed copy database from one computer to seced. I copy only catalog DATA from my actually working server and past this catalog to my new fresh installed ...
0
votes
1answer
49 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-...
0
votes
1answer
699 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
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
1answer
24 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 ...
0
votes
1answer
598 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 ...