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
0
votes
2answers
212 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
3k 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
5k 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
192 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
277 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). ...
2
votes
1answer
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 ...
0
votes
1answer
5k views

oracle cannot start

I have oracle database 11.2.0.4 on oracle linux 6.7 . I have install oracle database single instance with asm option . I have 2 users : oracle and grid My database is open and all of things are ...
0
votes
1answer
8k views

Cannot Start Oracle Database after Shutdown

I have install oracle 11.2.0.4 with oracle asm on oracle linux 6.4 and it work correctly . After shutdown abort , i can not start database at all . can any one help me ? SQL*Plus: Release 11.2.0.4.0 ...
0
votes
1answer
2k views

How to resolve error ORA-19802 when starting up an Oracle database instance?

I tried starting up my instance and received the error ORA-19802. Cannot use db_recovery_file_dest without db_recovery_file_dest_size. How can I resolve the problem?
0
votes
3answers
3k views

Oracle database not open and ORA-00600 error

Whenever I try to open Oracle, I get following error : ORA-01109: database not open So as suggested by various blog and forum, I tried the following series of commands c:> sqlplus /nolog sql&...
13
votes
7answers
329k 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 ...
0
votes
2answers
3k views

Mysql daemon failed to start: unknown variable password=xxx

Mysqld don't restart anymore...In the log, the apparently obvious reason: mysqld started [Warning] Ignoring user change to 'root' because the user was set to 'mysql' earlier on the command line [...
-1
votes
2answers
21k views

Unable to mount database: error reading control file

I have an installation of an Oracle XE on Windows 7 (Home Premium). The database worked fine until yesterday when the database could not be started. It reports ORA-01033: oracle initialization or ...
17
votes
3answers
62k 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 ...
1
vote
2answers
491 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 ...
5
votes
3answers
25k 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 ...
2
votes
1answer
527 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 ...
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 ...
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 ...
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 ...
1
vote
1answer
6k 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/...
27
votes
1answer
280k 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 ...
1
vote
1answer
5k 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 ...
0
votes
1answer
1k views

Oracle 11G Startup failed after altering the number of system processes

When I alter the number of system processes to 100000 and restart the database, I get the error below: ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semids_per_proc ...
0
votes
3answers
3k views

Oracle won't start

While it was working fine, I had to stop the server once. When trying to start Oracle using a script we have, I got the following error: SQL> Connected to an idle instance. SQL> ORA-01081: ...
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 "...
9
votes
3answers
62k 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 ...
1
vote
1answer
312 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 ...
11
votes
7answers
126k 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 ...
2
votes
3answers
11k 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 ...
0
votes
2answers
3k views

MySQL 5.5 Fail start Fedora 16

I installed mysql and mysql-server from the repos (MySQL version 5.5). Then tried to start it, but got an error. [root@server]# service mysqld start Redirecting to /bin/systemctl start mysqld....

1
2