Tag Info

New answers tagged

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


0

The easiest way would be to change the global setting for long_query_time to a ridiculously high number, run the mysqldump, and change long_query_time back to its original value. Perhaps something like this MYSQL_USER=backupuser MYSQL_PASS=backupuserpassword MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}" # # Record the long_query_time value # SQL="SELECT ...


0

Based on my own research, google results and ansible's answer, I was able to come up with complete solution for Oracle Linux 7. Everytime you read Kitet - this is my Oracle Instance SID. To start or stop database, dbstart and dbshut scripts are used respectively. They are located in $ORACLE_HOME/bin. Both of them need a parameter, which is $ORACLE_HOME. If ...


0

First, are you using the $ORACLE_HOME/bin/oraenv command? This is what typically sets the ORACLE_BASE, ORACLE_HOME, and ORACLE_SID environment variables on a Linux system using the Oracle Database. When connecting to an Oracle database from the command line in Linux, running oraenv should usually be your first step, as it will prompt you for the SID of the ...


0

It is possible that your TMP location is set to noexec. You can check this in your fstab. cat /etc/noexec If you see something like this: /dev/mapper/vg_primary-lv_tmp /tmp ext4 defaults,nodev,nosuid,noexec 1 2 It means that your tmp partition has been mounted in a noexec format.


0

Your error is "failed to access tmp" Ensure that the current user has required permissions to access the temporary location chmod your tmp so that the user doing the installation has permission to write in it.


1

The best option is probably to install PostgreSQL 9.1 from http://apt.postgresql.org/ if it's available for your distro/version. If not, you can install a temporary copy of your old Ubuntu version in a VM for recovery purposes - use virtualbox, kvm, etc. Vagrant can make life easier, just grab a prebuilt Ubuntu box from ...


0

The one I like best is IRI FieldShield (https://www.iri.com/products/fieldshield) in terms of versatility (most data masking functions), speed (CoSort engine for data movement inside), and ergonomics (simple 4GL jobs supported in its Eclipse GUI with tons of DB and file connections). Price-wise it’s about half IBM and Informatica, though also available in a ...


0

By default, innodb_thread_concurrency is 0. That's actually the best setting. It means infinite concurrency. It allows the InnoDB storage engine to decide the best number of concurrency tickets to launch and address. Setting it to a nonzero value actually can throttle InnoDB or throttle the OS if not set properly. I have written many posts in the DBA ...



Top 50 recent answers are included