Database Administrator

In many cases, the Oracle password file needs to be rebuilt. ORACLE has strict requirements on the password file, such as the file name and file name case. Once the ORACLE_SID was case-insensitive for a long time, the record is as follows: Linux

After several days of hard work, I finally succeeded in the Fedora core files, which really made me suffer a lot, because I have stored N database files, because I have never doubted it, I suspect that my downloaded file has been damaged (including

1. Use the root user to modify the/etc/oratab file: $ Gedit/etc/oratab Orcl:/Oracle/app/product/10.2.0/db_1: N Changed: Orcl:/Oracle/app/product/10.2.0/db_1: Y That is, change the last N to Y. 2. Use the Oracle user to modify the $

Environment: Linux Prerequisites: Install VSFTPD, MySQL, and PAM_MySQL 1. Add a VSFTPD user[Root @ xxx] # useradd ftpguestAfter a virtual user logs on, the user is located in the/home/vsftpguest directory of vsftpguest. To log on to other

The company's website has just completed the revision, optimized the database structure, and used the memcache distributed cache to add MySQL. In the first few days, the database service has not been down for a few days. however, the machine is

When encountering such a requirement at work, mysql needs to execute a large number of scripts to update the database. After checking the mysql source command, only one script file can be executed. I tried source/sqkdir/*. SQL; No. Mysql cannot use *

Oracle listener log file (usually called listener. log) is a plain text file whose size keeps increasing. On a production Oracle Server, DBA checks the file daily, such as checking whether the listener has an abnormal stop, whether there is a

A simple record of the Oracle 10g Installation Process on AIX 5.3: Check hardware configuration Check memory: # Lsattr-El sys0-a realmemRealmem 2097152 Amount of usable physical memory in Kbytes False Check swap space # Lsps-Page Space Physical

It depends on three places. 1. To determine the character set used by your mysql database, you can use the commandMysql & gt; show create database & lt; Your database Name> 〉You can use the following command to create a database with the gbk

Anyone who has learned Web development should know ODBC. This Microsoft-Created database connection method makes it easy for a program to connect to the database in Windows, such as Java ODBC to connect MSSQL and Access. To develop a cross-platform

Recently, I have seen a lot of information about cluster. I have been studying the load balancing and high availability of Linux systems, but it has not been completely successful yet, but it only implements some simple services; today, I found that

In Linux, it took me a long time to figure out how to process the MySQL database sample program in C language. Compile: Reference G ++-Imysql/include-Lmysql/lib-o a. out a. cpp-lmysqlclient-lz This mysql directory is the source code directory of a

1. In startup Linux, Oracle reports the following error:ORA-27102: out of memory Linux-X86_64Error: 28: No space left on device 2. Check the alter log to report:Checkpoint not completeCurrent log #3 seq #514388 mem

Environment Oracle 11.2.0 + SQL Plus Problem The following error occurs when querying the current Sequence value: SQL> SELECT seq_WGB_Test2.CURRVAL FROM dual; SELECT seq_WGB_Test2.CURRVAL FROM dual *Row 3 has an error: ORA-08002: sequence

1. Shut down the database [Oracle @ RHEL5] $ sqlplus/as sysdba SQL> shutdown immediate; Ii. Disable listening [Oracle @ RHEL5] $ lsnrctl stop 3. Delete oracle_base I switched to root here. [Root @ RHEL5] # rm-rf/s01 3. Clear residual files [

Oracle 11g installation references1,Install the dependency -------------- under the root user for Ubuntu12.04 32bitSudo apt-get updateSudo apt-get dist-upgradeSudo apt-get install gcc make binutils libc6 libc6-dev lesstif 2 RPM libmotif3 libstdc ++ 5

The running environment of Oracle SQL statements is divided into multiple different levels, including instance level, session level, and statement level. The priority increases sequentially. That is, the statement-level execution environment has the

Important knowledge points to be mastered in Oracle Learning 1. Basic syntax This is required. select, insert, update, where, and so on. To master this knowledge, you can do some verification and testing work. The target is for O & M or testing. 2

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

Oracle 11g has a new feature. Replace the variable in the RMAN script. Today, I did a small experiment on the server and tried this feature. Although some errors have been made, all of them have been solved! I feel that this feature is still good.