Tag Info

New answers tagged

-1

After an upgrade you need to run "mysql_upgrade -u root" and this will handle all the system table updates.


0

db-user passwords are in dba_users (10g) or sys.user$ (11g). No passwords have been given to you, but you need to login as the db-user (SCOTT). eg. Oracle 11g select password from sys.user$ where name='SCOTT'; -- save this EXISTIMG encrypted password. F123458D5B67 alter user scott identified by tiger; -- this is the new password that you just created. ...


1

Well, if you have full access to the database host you don't need to delete and re-create the password file. According to Using Operating System Authentication section in Database Administrator's Guide logging in as an OS user which is a member of dba group on *nix or ora_dba group on Windows and connecting to an Oracle Database instance using SQL*Plus ...


0

No. There is no possibility to pass for operating system request not to cache file reads for IO done for specific query. You can reduce sysctl parameter vm.swappiness to 1 to make cache recovery more aggressive, but that affects all IO caching in the server.


1

this bug is reported in MySQL Forums (67179) and the solution is mentioned here. please note that you should do clean-up, before creating tables /* temporary fix for problem with windows installer for MySQL 5.6.10 on Windows 7 machines. I did the procedure on a clean installed MySql, and it worked for me, at least it stopped lines of innodb errors in ...


-1

@ursitesion We also had a similar problem after we migrated our MySQL DB from Windows to Linux. We were lucky that our table names were already in small caps, the only issue we faced was that inside our application & some Stored Procedures (SP) we had mentioned the table names in Large Caps / Camel Case. We followed the following steps and were able to ...


0

According to SMAA documentation you can connect just fine to any Oracle server. It doesn't matter if server works on Windows or Linux. After connection you just go with the next steps.


1

For Official MySQL packages: Oracle yum repository for MySQL. For MariaDB Packages: MariaDB yum repository. After that, you will be able to update MySQL via yum up to the latest stable version. They only include the server, client and the minimal MySQL libraries. For details, I've recently written a step-by-step guide on How to install MySQL 5.6 on ...


0

I found out the solution: If the machine has a hostname defined in /etc/sysconfig/network, this name also needs to be defined in /etc/hosts, period. This is what I had: host2> cat /etc/sysconfig/network NETWORKING=yes HOSTNAME=host2 host2> cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 ...


0

Adam has covered most of the points. However, there are a few things to add. Usage of Windows in a production environment For tl;dr candidates: It is a Very Bad Idea™ to run a mongod instance except for a config server on Windows. Here is why. Both ReFS and NTFS are at least 1/3 slower than ext4 or XFS, the recommended filesystems for Linux production ...


0

I found the Answer after long investigation, the problem in my case is root.sh under $ORACLE_HOME/root.sh is not running fine, so in-order to fix this issue I need to use root user then navigate to $ORACLE_HOME and execute the script. it will ask you to Enter the full pathname of the local bin directory: [/usr/local/bin] enter the correct values and replace ...


1

DBCA relies on /etc/oratab. If that file is empty, or the entry for the database you want to delete is missing, the option(s) will be disabled.


1

If the user has: Physical hardware access; Root / "Administrator" access to the system; or PostgreSQL superuser rights; then they effectively have total control and can do whatever they feel like. It's a little trickier when starting with superuser access, but the PostgreSQL superuser is not isolated from the underlying OS user that PostgreSQL its self ...


0

At first make sure the database host is available ping host1. Then you have to install a client and configure service name. To install the oracle client correctly and be able to use it you have to: Choose the "Administrator" type of the oracle client installation, not instant client, it provides you database administrator tools. After your client ...


0

There is no inconsistency here, this is simply due to how you have the volumes mounted and where you have located you MongoDB database path. You have one logical volume mounted on root (/) and the other mounted on /home - I am guessing you do not have your database path in MongoDB set to something under /home instead it is set to something else which is ...


0

The number of seconds that the server has been up. SHOW GLOBAL STATUS LIKE 'Uptime'; The number of seconds since the most recent FLUSH STATUS statement. SHOW GLOBAL STATUS like 'uptime_since_flush_status';


0

Another solution is : ps -ef|grep mysqld then check STIME which is the last start time .


1

SHOW GLOBAL STATUS LIKE 'Uptime'; http://dev.mysql.com/doc/refman/5.6/en/server-status-variables.html#statvar_Uptime


1

You do not need to purge anything, you just need to follow these instructions to reset the administrator password. If you happened to delete the admin user, just create a new one on the init file: create user root@localhost; grant all privileges on *.* to root@localhost;



Top 50 recent answers are included