Hot answers tagged

37

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 ...


17

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 !!!


12

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 ...


11

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

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


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.


6

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

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

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

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

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 ...


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

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

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

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

The information in Using a gMSA with SQL Server by Wayne Sheffield worked for me with the service issue. The pitfalls of using a gMSA with SQL Server As with almost all things, there is inevitably something that doesn’t work correctly. One thing that I found is that when the server is rebooted, the SQL Server services are not restarted. And I’m not ...


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

Also, is the Services section in SQL Server Configuration Manager just a "shell" of the full Services screen, which is limited to SQL Server related services? Yes, SQL SCM is the SQLServerManager10.msc file that is opened as a snap-in Windows Management Console (mmc.exe). Is there any reason not to stop and start SQL Server services from the full ...


2

SQL Server Configuration Manager performs additional operations that the Windows Services does not. Please check Technet SQL Server Configuration Manager particularly if you have changed the service account and/or password recently or use startup options.


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