Hot answers tagged

33

After hours of misdirection from official Oracle support, I dove into this on my own and fixed it. I am documenting it here in case someone else has this problem. To do any of this, you must be the oracle user: $ su - oracle Step 1: You need to look at the alert log. It isn't in /var/log as expected. You have to run an Oracle log reading program: $ adrci ...


23

The SQL Server database is ready to accept queries as soon as: SELECT DATABASEPROPERTYEX(N'database name', 'Collation') does not return NULL. From the documentation for DATABASEPROPERTYEX (Transact-SQL): Note: The ONLINE status may be returned while the database is being opened and is not yet recovered. To identify when a database can accept ...


16

The entire folder should be owned by mysql cd /usr/local/mysql-5.6.21-osx10.8-x86_64/data/ chown -R mysql:mysql * Then go restart mysql Give it a Try !!!


11

Check the folowing First check if another instance is runnig in the same machine ps ax | grep mysql Then, check if your file my.cnf (probably in /etc/mysql/ folder) is correctly configured with [mysqld] datadir = /var/lib/mysql/ socket = /var/lib/mysql/mysql.sock Next, you have changed the default data directory, did you gave the right permissions to ...


10

I see two things wrong here. Oracle tries to open a parameter file in the $ORACLE_HOME/dbs directory with the format "spfile" + $ORACLE_SID + ".ora". If it cannot find it, it then tries to open "init" + $ORACLE_SID + ".ora". This is where the problem(s) are. By virtue of the fact that Oracle is trying to open a parameter file named "initXE.ora", your SID ...


8

You can use the dbstart/dbshut scripts which come with an Oracle install. They are available under $ORACLE_HOME/bin. After a fresh install you have to edit the /etc/oratab file: # cat /etc/oratab # format: $ORACLE_SID:$ORACLE_HOME:N|Y my_sid:/home/juser/app/juser/product/11.2.0/dbhome_1:N # sed -i 's/:N$/:Y/' /etc/oratab # grep my_sid /etc/oratab my_sid:/...


7

The files in /opt/ibm/db2/V10.5/ are not to be used for a specific instance. When you run the db2icrt command, it copies a series of files and directories into ~db2inst1/sqllib, and sets the permissions accordingly. (Some of the directories in ~db2inst1/sqllib will be soft links back to directories in /opt/ibm/db2/V10.5). For example, you should find ...


6

If this is a new installed Oracle and you do not have initXE.ora parameter file here /u01/app/oracle/product/11.2.0/xe/dbs/, that means you need to create XE DB first. To do that run /u01/app/oracle/product/11.2.0/xe/bin/createdb.sh script first.


5

From ParnassusData: This error indicates that a mismatch has been detected between redo records and rollback (undo) records. ARGUMENTS: Arg [a] - Maximum Undo record number in Undo block Arg [b] - Undo record number from Redo block Since we are adding a new undo record to our undo block, we would expect that the new record number ...


5

My issue was that multiple mysql processes were running concurrently. First kill the processes with: sudo pkill mysql and sudo pkill mysqld restart mysql sudo service mysql restart now you should be able to log in mysql -u root -p


5

It would appear that the socket file is missing. service mysql stop and service mysql restart depend on the socket file's existence to shutdown. You will have to connect to mysql using mysqladmin and TCP/IP to shutdown MYSQL_USER=root MYSQL_PASS=rootpassword MYSQL_CONN="-h127.0.0.1 -u${MYSQL_USER} -p${MYSQL_PASS} --protocol=tcp -P3306" mysqladmin ${...


5

I presume that on the source machine these were on the E drive and you just copied them over lock stock and barrel to the F drive on the destination? One other option now you are in this situation is add startup parameter -T3608 to tell SQL Server not to start any database except master. You can then use ALTER DATABASE ... MODIFY FILE to fix up the paths ...


5

According to the documentation, SQL Server Configuration Manager requires Local Administrator permissions since various SQL Server Configuration items are stored in the local system registry. From the "SQL Server Properties (Startup Parameters Tab)" in the SQL Server Configuration Manager Help: Use of this page is restricted to users who can change the ...


5

Assuming, you have a 7200 rpm HDD, if you perform random reads and expect the data to be loaded whenever it is required by the application, it will slow down the whole process. Random reads are way slower than sequential reads in case of HDD. So, rather the records must be loaded in sequential access. It may take a while under a regular workload to store ...


5

Is there any whitepaper or documentation on how SQL Server is placing startup predicates? No, not that I've ever seen. They don't get written about all that much. The one time I blogged about them, I did a lot of head scratching. Now, I have an answer -- it's not guaranteed to always work. It's playing some tricks on the optimizer that you can learn more ...


4

For the article you linked it references the specific start up options used by the Database Engine ("sqlservr.exe"). So the "-" dash is used as stated in the article. This article points to the method used in a DOS prompt to start SQL Server in single user mode. I believe using /m"SQLCMD" would work the same way, but I normally use the commands noted below. ...


4

As it turns out, it was running in the console because I didn't tell it where to stream the log. The following sent the process in the background: pg_ctl restart -l %PGDATA%\server.log


3

It seems that postgresql doesn't like your postgresql.conf file. The log message clearly says that it wasn't expecting a " character on line 392, but it doesn't tell you which one (of two " on this line) is it. I would assume that there is an unclosed " earlier in the config file.


3

Start by commenting out the offending line in your postgresql.conf and retry. It is possible that a change made some time ago caused this problem and you are only now seeing it because a reload operation or similar failed, and so PostgreSQL was running on old configuration. If that works address what you have on that line (maybe get rid of the quotes?) If ...


3

I find another reason for the same error. I use homebrew to install mysql. The server could not be stopped by simply use the command: mysql.server stop The mysql process will automatically restart. The only way to stop that is using this command: brew services stop mysql Then, you could fix issue with root user.


3

I agree with Miracle173's answer. I dug around on metalink (I assume you don't have an account there) and this seems to be the best, supported method to solve your ora-600 [4194] issue. This error normally happens for a new transaction. The trace file actually shows an active transaction for the undo segment because this is the transaction created by the ...


3

Let me show you what Oracle says about your errors. ORA-01157: cannot identify/lock data file string - see DBWR trace file Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However ...


3

There are two options Manually change the startup type of the service Remove (and optionally reinstall) the service Manually change the startup type of the service You can disable it in the Services configuration. Use Windows-key+R or open run from the start menu, enter services.msc, find the Firebird instance (Firebird Server - DefaultInstance), right ...


3

You have two methods of doing this, Step back, your best bet is to use TEMPORARY TABLES TEMPORARY or TEMP If specified, the table is created as a temporary table. Temporary tables are automatically dropped at the end of a session, or optionally at the end of the current transaction (see ON COMMIT below). Existing permanent tables with the same name ...


3

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 22-JAN-2018 21:22:58 Copyright (c) 1991, 2011, Oracle. All rights reserved. Starting /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.2.0 - Production System parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora Log messages written ...


3

SHUTDOWN MySQL 5.7 now features the SHUTDOWN command, which requiresthe SHUTDOWN privilege. SHUTDOWN METHOD #1: Within mysql client mysql> SHUTDOWN; SHUTDOWN METHOD #2: From OS using mysql client MYSQL_HOST=127.0.0.1 MYSQL_USER=root MYSQL_PASS=rootpassword MYSQL_CONN="-h${MYSQL_HOST} -u${MYSQL_USER} -p${MYSQL_PASS} -P3306 --protocol=tcp" mysql ${...


3

SQL Server databases start up, but then they need to analyze the transaction log to roll transactions forward & backward. This process can take anywhere from milliseconds to hours (even days!) in the event of a long-running transaction, many (think thousands) of user databases, or databases with lots (think tens of thousands) of virtual log files. If ...


2

By copying the complete DATA directory, you most likely also copied the system databases, specifically your master database from your old server and overwritten the system databases of your second SQL Server. When copying a USER database in general, the easiest method is to make a backup of that user db on the source server and restore that backup on the ...


2

Don't forget that things like apparmor can block write access to directories for mysql, as well. See places like /etc/apparmor.d/usr.sbin.mysqld, and give "** rwk" to your mysql datadir. (Needs apparmor restart) See place like /var/log/kern.log for apparmor reports.


2

Hi i'have just installed zabbix 3.0 and same problem appeared after few hours ago. When i check the zabbix permission in the phpmyadmin I realised there is no permission for user "zabbix" . I gave Grand permission to zabbix and problem solved. This might be helpfull for someone.


Only top voted, non community-wiki answers of a minimum length are eligible