Tag Info

New answers tagged

0

Oracle 11g R2 Database Release 2 only support Windows, Linux, and Solaris. So if you want to using Oracle 11g R2 on a Mac OS you will need to using something like Virtual Box or VMware Fusion. You can read more about installing Oracle 11g R2 on these operating system here.


1

If the problem is only cannot start sqlplus, there are two alternatives: 1) If one has the GUI (GNOME or KDE), do the search: "sql command line", and It will appear Run SQL Command Line. 2) Check again the environment variables. Edit the files /root/.bash_profile and /root/.bashrc (for example: # nano /root/.bash_profile) and put the line (at the end): ...


2

This version of Oracle XE is based on 11g2 edition, which is not compatible with CentOS 7. In fact, it isn't even 100% compatible with CentOS 6, however it will run there without problems, after you install a number of RPM packages not installed/required by Oracle installer (especially libaio both 32/64-bit). These are formal OS requirements for XE 11g2: ...


0

Slave_SQL_Running: No The above indicates that although the replica is connected to the master it is no longer applying SQL statements to the dataset. This is due to the problems exposed in the 'Last_Error' field. You should resolve these issues either by aligning the data or skipping the transaction and syncing the data thereafter. You've likely arrived at ...


0

I got this error after a clean installation. Somehow i think something messed up the MariaDB data directory (/var/lib/mysql). The solution was to delete the content of /var/lib/mysql on all nodes and run mysql_install_db --user=mysql. Be aware that this will delete all your existing data.


0

Your hostname must be an alias for 127.0.0.1 in your /etc/hosts file to make it work. aldwin@myhostname~$ cat /etc/hostname myhostname aldwin@myhostname:~$ hostname myhostname aldwin@myhostname:~$ cat /etc/hosts 127.0.0.1 localhost 127.0.1.1 myhostname


1

Reason: Is it the same version of Mongo on both servers? Record Padding : http://docs.mongodb.org/v2.4/core/record-padding/ No Padding Allocation Strategy Changed in version 3.0.0. For collections whose workloads do not change the document sizes, such as workloads that consist of insert-only operations or update operations that do not increase document ...


-2

msqldump command is used to store away a snapshot of the database. I have used this command and it works fine for me. Try using the below command: msqldump --database=database_name This will dump the data onto standard output. If you want to save this to a file use the below command: msqldump --database=database_name > PATH


2

If the PostgreSQL version and architecture is the same on the target so they're binary compatible: Set up streaming replication with WAL archive fallback, so the new host replicates from the old one. Enable hot_standby mode so you can connect to the new host read-only. Test. Then when you're ready to cut over, stop the old server and pg_ctl promote the new ...


1

You should be able to just run mysql_install_db from the command line mysql_install_db initializes the MySQL data directory and creates the system tables that it contains, if they do not exist. It also initializes the system tablespace and related data structures needed to manage InnoDB tables. As of MySQL 5.6.8, mysql_install_db is a Perl script and can ...



Top 50 recent answers are included