Tag Info

New answers tagged

0

When I faced this message, I checked the postgresstartup.log, it showed that the data directory was having permissions as 777,After I changed to 700 , the postgresql started working sudo su - postgres chmod 700 -R <postgresql_Data_Directory> exit /etc/init.d/postgresql start /etc/init.d/postgresql status


0

To find out path to a socket mysqld process has opened you can use lsof: # lsof -U -c mysqld -a COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME mysqld 18149 mysql 16u unix 0xffff880037a7a700 0t0 126146 /var/lib/mysql/mysql.sock


0

Usually, when mysqld is still running and their is no socket, there is only one thing to do. If you have root@127.0.0.1 defined as a user, you can do a clean shutdown like this mysqladmin -h127.0.0.1 -P 3306 --protocol=tcp -uroot -p shutdown When the propt cvomes back, do a normal startup service mysql start This will recreate the mysql.sock file. I ...


0

Try to turn off Query Cache, which might cause extra lock.


0

If you need best practices, not minimum required values, this is how to proceed : plan a meeting between the OS main administrator and the DB main administrator, and bring along the list of minumum requirements. If those people can't figure out "best practices", nobody can.


0

The installation guide contains minimum (or recommended) values for each kernel parameter. On Metalink you can find at least one article (including formula) per each kernel parameter.


1

Whether a password is required or not has nothing to do with pg_shadow and whether a password is actually defined for the user. Yes, I know, that's weird. pg_hba.conf controls the authentication method. If you want to request a password, use md5 authentication. If you want to allow login with no password to anyone, use trust. If you want to require the same ...


4

Since you started both servers, you have executed (approximately) 162509 + 33073 + 11291 = 206,873 queries on the Linux server and 44648032 + 6866308 + 994889 = 52,509,229 queries on Windows. Why would you expect similar numbers when one has done more work than the other? The ratios, however, are similar with: 162509 / (162509 + 33073) ~= 83% 44648032 / ...


-1

while installation it creates the log files in temp . location. so make sure oracle user has permissions on /tmp location. may be this doc helps you during upgrade.follow the same procedure http://orcl11gdba.blogspot.in/2014/03/upgrading-database-from-112010-to.html


0

This amazing video explains how to solve the error step by step, If you dont want to watch then follow the text below 1) "Command not found" indicates oracle instance is not running or you have not running the dbca command as oracle user sol: follow @Frank Schmitt answer 2)The No protocol specified error indicates that "the user dont know how to launch ...



Top 50 recent answers are included