Database Administrator

In linux, when init. crs is not modified, cluster software is always automatically integrated with the system during startup. The database raclinux In addition, you can also view the crs-stat-t to manually start a service that has not been started. [

To install Oracle 11g in Ubuntu 10.04, follow these steps:1. Install JDK. For the installation method, see setting up a sun java Development Environment under Ubuntu 10.04.To solve Chinese garbled characters, create the "fallback" directory in the

1> User temporary default tablespace Switching -- Query the user's default temporary tablespaceSQL> SelectUsername,Temporary_tablespaceFromDba_users;USERNAME

I. REPORT1. Report the physical structure of the target databaseRMAN> REPORT SCHEMA2. REPORT the data files to be backed up. Before performing the BACKUP, you often NEED to obtain the information of the data files to be backed up. Run the report

Installation of Oracle11G for RHL AS5Server Configuration:Xeon 3.0 GHZ * 24 gb ecc ddr memory300 gb scsi Utrl 320 15 K hard drive X 2   Prerequisites: Memory and swap space; For details, see the official database \ doc \ install directory

(1) srvctl status database-d dbservername Oracle @ zjgldb2 $ srvctl status database-d kms Instance kms1 is running on node zjgldb1 Instance kms2 is running on node zjgldb2 (2) crs_stat-t Oracle @ zjgldb2 $ crs_stat-t Name Type Target status host ----

At work, we need to insert and read and write Chinese data to MySQL. This problem was tricky at first. After a period of investigation, the problem was solved smoothly. The solution is as follows: 1. Set the character set of the MySQL server. The

PhpMyAdmin is mainly used to manage mysql on the web interface. The Installation Method in Fedora is as follows: 1. yum install phpMyAdmin The path of phpMyAdmin installed using yum is as follows: Installation

This knowledge point is only applicable to Oracle 9i and later versions. To view table data changes, use the SQL statement: select * from user_tab_modifications; The fields in the user_tab_modifications table are as follows. From this table, you can

If you want to talk less, go straight to the topic. Here is the procedure for porting: 1. Transplantation First download SQLite 3.3.8 from here. The following example shows how to store data in the/root directory. # Cd/root # Tar zxvf

Next, I installed the Oracle Client on Ubuntu 10.10. When I used sap's user sapsr3 or sys to connect to the service, it was not successful. Sapsr3 indicates that the select any dictionary permission is missing, and sys prompts that the user password

By default, alert log has only one file. When a certain amount of data is accumulated, it is a little troublesome to view alert. log. You can only use the tail-xxx line for viewing. Therefore, if you can store alert. log by day or put it in a

ORA-16014 error and flash space full Create table user as select name from t_userinfo created yesterdayThe t_userinfo table is very large. After a while, I have been reading and writing the hard disk for three hours.PL/SQL DEVELOPER cannot be

When I use the Hibernate framework today to operate the mysql database, the varchar type data in the database appears ?? I set gbk encoding in my database. It is certain that there is no problem with the database, but garbled code occurs during

Experiments show that Oracle11gR2 creates objects such as tables and indexes without data. In order to save space, oracle does not allocate segment, but allocates segment only when there is a dml operation, even if the dml is rolled back, the

First, download the database you need to install.Second, configure your yum source. If it is CentOS, you do not need to configure the yum source.Third: Put the mysql-xxx.tar file you downloaded and the script in the/usr/local/src directory.4.

Authorize scott to enable the execution plan. The script is as follows:[Oracle @ rac1 admin] $ sqlplus/as sysdbaSQL * Plus: Release 10.2.0.5.0-Production on Sat Oct 12 02:02:28 2013Copyright (c) 1982,201 0, Oracle. All Rights

Stream is an extended application of Oracle Message Queue (also called OracleAdvanced Queue) technology. Oracle Message Queue solves event management through publishing/subscription. Stream replication is only based on its data sharing technology.

There are three Oracle encryption methods: transparent encryption, password encryption, and dual-mode encryption. By default, Oracle disables the encryption function:RMAN> show all;Configure encryption for database off; # defaultConfigure encryption

Oracle Server: Select * from NLS_database_PARAMETERS where parameter like '% CHARACTERSET % ';PARAMETER VALUE----------------------------------------------------------------------NLS_CHARACTERSET WE8MSWIN1252NLS_NCHAR_CHARACTERSET AL16UTF16 Table t1: