Database Administrator

I have been engaged in Oracle database development for more than two years and have always felt that I am a half bucket of water. During this period, I also read some documents and books. I feel that I should first learn about Oracle database

Create Database User S_NQ_SCHED/S_NQ_SCHED Connect sqlplus to the user and run the SQL statement $ OracleBI_HOME/server/Schema/SAJOBS. Oracle. SQL and SAACCT. Oracle. SQL The DSN error is prompted. You need to modify odbc. ini. Add a DSN

1. FreeBSD:Create a webhost user and have operation permissions on apache and mysql. Mysql startup command/Usr/local/etc/rc. d/mysql-server start 2. Run the following command to start mysql in Linux:Mysqladmin start/Ect/init. d/mysql start (the

It turns out that dpo_mysql-related parameters were not included when php was compiled in Linux. It was discovered only after installation. Re-compilation is a little time-consuming, so I decided to install it separately. Go to

Environment: Oracle 10g + RedHat Linux 5 32-bit 1. Install the support packages required by asmA. Download the support package from the oracle Website:Http://www.oracle.com/technology/software/tech/Linux/asmlib/rhel5.htmlB. Download the

Yesterday I installed 64-bit Linux and Oracle 10 GB on a new machine, 32-bit Linux and oracle for countless times. I thought this was not a small dish for me. I did not expect to encounter a few very difficult problems. Today I finally got it

1. Use the show character set statement to list available CHARACTER sets in the database:Mysql> show character set;2. to list the Collation rules of a character set, use the show collation statement.For example, to view the proofreading rules for

Many new users have a headache when installing the Oracle database server in Linux. Due to work reasons, I have installed Oracle several times in Linux. Although I have encountered many problems, however, all of them finally solved various problems

Mysql error number 1051 says a lot on the Internet (including foreign networks), but no one knows why. This is caused by different store engines. For example, if the first engine = myisam and table A are created on this basis, you need to convert

My mysqllistener is mysql-cluster-gpl-6.2.15-linux-i686-glibc23.tar.gz. In actual work, if you do not start mysqld service on the data node in the cluster settings, data and tables created on the MySQL node server cannot be transparently displayed

Manual configuration of MySQL 5.1 noinstall version 1. Configure Option FileMySQL5.1 installed with MySQL install will automatically generate the configuration file "my. ini" or "my. conf". Unzip the file to complete the installation of MySQL

DataGuard dual-node node1 node21. Configure the network on node2, including the NIC mac address, ip address, and dns name, and test the network2. Run the terminal command -- env | grep PATH on node1.3. Create a database on node1 and select a special

I used mysqldump for backup, which is easy to store as text files, but it is slow. Of course, the fastest backup method is to copy the data directory directly. But in general, MySQL services must be shut down before you can do it. Otherwise, when

/*** Modify the session storage mode to Mysql Aboc QQ: 9986584*/ Class Session { // Expiration timePrivate $ _ LEFT_TIME = 1440; Public function open (){ } Public function close (){} /*** Read*/Public function read ($ sessid ){$ SQL = "select data

Code: # Include # Include # Include "/usr/local/include/mysql. h" // location of the mysql header file installedUsing namespace std;String host = "database address ";String user = "user Name ";String pwd = "password ";String dbname = "Database

1. What is ASM? ASM is called Automatic Storage Management (Automatic Storage Management). It is a new feature launched by Oracle 10 Gb. This is a volume manager provided by Oracle to replace the LVM provided by the operating system. It not only

Two parameters used for data block optimization: pctfree and pctused are generally used in OLTP systems. There is no relationship between the two. When one of the conditions is met, the free-list will be displayed/removed. Condition for Oracle to

An error is reported when "space = user tablespace: -- View the tablespace size; SQL> SELECT TABLESPACE_NAME, SUM (BYTES)/1024/1024 MB FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME; -- View the path where data files are stored in the tablespace: SQL>

I. Move data files: You can use alter database or alter tablespace to move data files. 1. ALTER DATABASE Method 1: You can use this method to move data files in any tablespace. Step 1: Close Database # Sqlplus/as sysdba SQL> shutdown immediate Step 2

I just created a database manually. It was too late to continue the study. As a result, the following error was reported when I opened the database again today. ORA-00704: bootstrap process failure.ORA-39700: database must be opened with UPGRADE