Tag Info

New answers tagged

0

Depeniding upon the servers connectivertiy, then SSH could be one of your best answers. Using rscync, the you can pull the files or directories through from the red hat server or even push them to the Windows server. NAME rsync - a fast, versatile, remote (and local) file-copying tool SYNOPSIS Local: rsync [OPTION...] SRC... [DEST] ...


0

Actually, at a first sight, you may run out of physical memory and run into swappiness. Minimum memory per-thread, as in your configuration, is 51MB. All threads may use 51x100=5100MB (btw, what is the value of Max_used_connections?). Adding to 28000MB as the InnoDB_buffer is and the Query_cache_size of 500 MB (is it really needed??), you have 33600MB. ...


0

No you can't. SSH is an operating system for remote administration, what is happening when you do ssh and directly enter to the database is because of a script or default shell changed in /etc/passwd for the specific user. But for mariadb(mysql) (including workbench) this means nothing, cause in practice is very likely to do ssh root@yourserver and then ...


0

First edit your /etc/oratab changing N to Y like that: orcl:/u01/app/oracle/product/11.2.0/dbhome_1:N Must be change to Y: orcl:/u01/app/oracle/product/11.2.0/dbhome_1:Y Then to start you must use the dbstart script like that: export ORACLE_HOME=youroraclehome su oracle -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME" Where "oracle" in the "su" command ...


0

Check the server.log. That normally indicates why the issue is happening. I have faced the same issue and I could see that it was unable to find var/postgres/ postgres.auto.conf etc. I am using Mac so I used the following commands and it came back again. But I lost my data folder. brew uninstall postgres brew install postgres initdb `brew ...


0

Here are the things I look at when reviewing a server: (Innodb_buffer_pool_reads) / Uptime (Innodb_buffer_pool_pages_flushed) / Uptime (Opened_tables) / Uptime (Opened_files) / Uptime (Opened_table_definitions) / Uptime (Qcache_lowmem_prunes) / Uptime (Qcache_not_cached) / Uptime (Questions) / Uptime (Queries) / Uptime ...


0

For mysql server monitoring you should concern these- Mysql server is running or not by command (service mysql status) and by telnet the server that is running or not. You should consider these parameters. ibdata size no of connections or Threads reads per second write per second cpu load memory utilization no of open tables query per second insert/update ...


1

I've experienced problems like this before. It seems to happen when you don't exactly follow the instructions for creating users. There are normally two solutions - perform the operation as root. The other solution is to (re)create your user carefully - but if this is one-off data loading step, then root should be fine.


2

From the INSTALL document Short Version ./configure make su make install adduser postgres mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data su - postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 & ...


2

Look at: http://docs.oracle.com/database/121/DBSEG/authentication.htm#DBSEG99827 Operating system authentication is not supported in a multitenant environment. You can't connect with "sqlplus / as sysdba" to a PDB. It only works with the CDB. If you change environment variable ORACLE_SID to that of a PDB, you'll connect to the binaries to what he expects ...


1

Nothing bad happened even if you took the config server offline during a chunk migration. In order for a chunk to be marked as migrated, all three config servers need to be up (Contrary to popular belief they do not form a replica set.). (The following is a tiny bit simplified for the sake of shortness.) When a chunk is moved, a global (read cluster wide) ...


0

The problem may have been permissions You had to run chown mysql:mysql /root/mysql.password or chmod 777 /root/mysql.password before starting mysqld


0

For a start you can use oraenv script to set PATH, LD_LIBRARY_PATH, ORACLE_BASE and ORACLE_HOME: export ORACLE_SID=ORCL ORAENV_ASK=NO . /usr/local/bin/oraenv ORACLE_SID can be parsed from /etc/oratab file. ORACLE_HOSTNAME maybe from HOSTNAME environment variable.



Top 50 recent answers are included