New answers tagged

0

I ran into this problem when trying to run multiple instances of MySQL, but instead of removing apparmor, I updated the usr.sbin.mysqld file: vim /etc/apparmor.d/usr.sbin.mysqld For example, this is what my file looks like, and once I added the folders that need write permissions, all worked as it should. /usr/sbin/mysqld { capability dac_override, ...


3

I write a bash script to perform the backups (RMAN, datapump and also xtrabackup and dump for MySQL in a similar way) and then call that from cron. That way you can handle the email as you want. So a simple crontab line is like this 00 18 * * 0-6 /dba/bin/rman.sh > /tmp/dba_rman_SID.log 2>&1 Then everything is done in the script. So define ...


-1

I had the same problem of getting an ORA-01031 error when doing a sqlplus / as sysdba. My problem was corrected when I unset the environment variable TWO_TASK.


1

This is the code that I came up with to get the information: #!/bin/bash ###################### ##BY: kixes ## ##Created: 4-1-2016 ## ##Version: 1.01 ## ###################### ##################### ######Variables###### ############################################################# #LogFile is where the ErrorLog dumps its filtered error log ...


0

You are trying to connect to the remote host using the server file of the master. The reason it is working with only the CA is presumably the SSL configuration on the slave has it's own certificate signed by the same CA. What you seem to be trying to do is use client certificate authentication. If that is the case you need an additional client certificate ...


-2

Hope this helps... (wrapped for readability) sqlplus username/password@'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=hostname)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=service_name) (INSTANCE_NAME=instance_name)))'


0

First you have to tell Oracle to use the tnsnames.ora file at all. For this open/create file sqlnet.ora and insert row like this: NAMES.DIRECTORY_PATH = (TNSNAMES) You may add other methods for resolution, e.g. 'LDAP', see DIRECTORY_PATH. Entry tnsnames tells Oracle to use an tnsnames.ora file. Regarding the location of these two files the answer is not ...


3

tnsnames.ora doesn't "come with" anything. The key is not that file, as it is nothing but a names resolution file. And sqlplus is nothing but a CLI application. If you want to connect to an Oracle database (or ANY database) you must have, at a minimum, the client software for that particular database product. For oracle you need to download and install the ...


2

It is possible using cgroups. Some tutorials are available as well as shell script for Ubuntu 14.04. See also Is there any option to limit mongodb memory usage? on Stack Overflow.


1

The problems got removed, when i swapped the my.cnf file, with a highly simplified version of it, which was earlier present in a machine, having MySQL 5.6. So possibly the issue was with my.cnf file. # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html [mysqld] init-connect='SET ...


2

I tried creating /tmp which was not existing as a separate file system and kept 4gb of space. But the issue did not get resolved. I try to keep my temporary file in a different place where the space available around 20gb. Still issue did not get resolved. Finally I had to run the below command which resolved the issue. I couldn't find the solution so ...



Top 50 recent answers are included