Database Administrator

I have just studied Linux and are still studying OCI. After calling OCI to connect to the database a few days ago, I tested it with the example provided by Oracle. I can read data normally (in English), so I can rest assured that I can switch to

I. How to completely delete the old version of Oracle 1. Run DBCA in cmd and delete the Oracle instance here;2. Find the Universal Installer under the Oracle subdirectory in the Start \ Program and run it to uninstall the Oracle software;3. Go to

Follow the steps in the Oracle official documentation to install the system. First, check the system requirements on Solaris10: #/Usr/sbin/prtconf | grep "Memory size"Memory size: 16384 Megabytes#/Usr/sbin/swap-lSwapfile dev swaplo blocks

In the past two days, I have studied the problem of garbled Characters During MySQL upgrade and finally solved the problem that has plagued me for a long time. Here I will record it and the previous articles have been updated. Change the server that

Recently, the company's servers are always faulty. Sometimes the access speed is too slow to handle. I am just getting started with Linux, but I can't find the problem. I am so bored. First, I want to modify the mysql configuration file to check

1. After remotely logging on to and running./runInstaller, the graphic interface is disconnected. DISPLAY = Local IP: 0.0Export DISPLAY Okay. 2. If the network configuration of Oracle Startup Check fails, it is always displayed as not executed (it

Today, when I create a table in MySQL, I first create it in MySQL Query Browser, but I always report an error. Later I thought it was just a client software that is easy to operate. I guess it won't work. Later, I created a table under the MySQL

I have been depressed for many days. By default, the database mysql installed in mandriva is faulty. The problem is more than two connections. Let's talk about it now. 1) install mysql: sudo urpmi mysql 2) Run mysql-uroot. [mysql] ERROR 2002 (HY000):

The following error occurs when connecting to MySQL in Linux C: After the compilation is successful, run the program./connect: error while loading shared libraries: libmysqlclient. so.15: cannot open shared object file: No such file or

I have been using the MySQL database software, which is stable and highly efficient. There are several possible causes for serious performance problems: 1. The index is not created; 2. SQL statements are too complex; 3. Configuration Error; 4. The

Step 1: Shut down the database. When the database is shut down, the database system mainly completes three tasks. First, the system will write the content in the redo log cache to the redo log file. Second, write the modified data in the high-speed

Profile is a set of names for password and resource restrictions. When an Oracle database is created, Oracle automatically creates a Default Profile and assigns it to users. If this parameter is not specified, the default profile is enabled. 1. view

Generally, after Oracle software is installed, Oracle will be patched before the database is created. Of course, it doesn't matter if the database is not installed. Next we will introduce the upgrade process of Oracle after the database is created,

View the maximum number of processes in Oracle:SQL> select count (*) from v $ session # Number of connectionsSQL> Select count (*) from v $ session where status = 'active' # number of concurrent connectionsSQL> show parameter processes # maximum

Users who bought the commercial version can use commercial backup tools to back up the MYSQL database. I will demonstrate how to back up and restore the database. This includes full backup and Incremental backup. Backup Method Full: Mysqlbackup --

In the previous article "using Sqoop for data exchange between MySQL and DHFS systems", we mentioned that sqoop allows data exchange between RDBMS and HDFS and supports importing data to HBase from mysql, however, direct import from HBase to mysql

Oracle 10g rac standby automatic deletion script for archiving logs #! /Bin/bashExport ORACLE_HOME =/opt/oracle/product/10.2.0/db_1Export ORACLE_SID = standby1Export ARCHIVE_DIR =/log/archivelogExport LOG_FILE =/home/oracle/logs/del_archive.log If [!

How to disable and start Oracle 10g RAC Scenario 1: maintain the database and operating system, servers, and shut down the database (all instances), OS, and Server. A. Stop the Oracle10g environment first$ Lsnrctl stop (you can also use srvctl to

Original SQL: An ORA-03113 error occurred while running, the network is normal, and other SQL statements are also normal. 13:04:26 CRY @ CRY> select operatetime, billtypename, billid, shopcode, shopname, goodscode, goodsnAme, ''quantity at the

Disable innodb_fast_shutdown =0. Complete all full purge and merge insert buffer operations (for example, during InnoDB plugin upgrade)1 By default, the above operations are not required, but the dirty pages in the buffer pool are refreshed.2. logs