Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

Include in your question how you attempted starting the database; via scripts or grid/enterprise management tools. Include relevant error messages and log file contents.

88 questions
32
votes
1 answer

"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 a few hours and then it quit. It wouldn't restart.…
kainaw
  • 1,404
  • 3
  • 15
  • 26
17
votes
3 answers

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 server can't be started: $ mysqld…
qazwsx
  • 3,507
  • 9
  • 23
  • 21
15
votes
2 answers

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'. 2018-02-22 14:10:58.95 spid18s Starting up…
Ahmed
  • 253
  • 2
  • 8
14
votes
7 answers

How to solve "Can't connect to local MySQL server through socket" error?

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 through socket '/var/lib …
MahuLovzYou
  • 141
  • 1
  • 1
  • 3
11
votes
8 answers

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 parameters LRM-00109: could not open parameter file…
Praneeth Pj
  • 243
  • 2
  • 3
  • 8
9
votes
3 answers

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 this because I am used to the startup speed of…
maxschlepzig
  • 563
  • 4
  • 6
  • 16
7
votes
2 answers

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 that come from test_fn1 function. I need to…
Grzegorz Łyp
  • 81
  • 6
7
votes
1 answer

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 started the server on the next command…
amphibient
  • 354
  • 1
  • 6
  • 17
6
votes
2 answers

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 MSSQLSERVER service was unable to log on as…
kaitlyn
  • 593
  • 2
  • 7
  • 15
6
votes
1 answer

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 Configuration Manager. I have found some blogs…
Md Haidar Ali Khan
  • 6,523
  • 9
  • 40
  • 62
5
votes
3 answers

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 Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft…
vincent nguyen
  • 71
  • 1
  • 1
  • 2
4
votes
2 answers

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 - see DBWR trace file ORA-01110: data file 54:…
user2018791
3
votes
1 answer

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 material online, disabled Windows and Java updates…
user115227
3
votes
1 answer

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 null, i don't want information like last restart…
info.sqldba
  • 327
  • 4
  • 15
3
votes
2 answers

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 and saw that the instance was down. I tried to…
Oscar Caraballo
  • 41
  • 1
  • 6
1
2 3 4 5 6