Database Administrator

As a DBA of an Oracle database, deploying an Oracle database is a basic skill. What should be included in the complete deployment of an Oracle database? The following is a brief discussion. 1. Set up the basic environment. The key to this step is to

The log system of the Oracle 1gR2 database changes a lot. The following describes the changes in the parameter file and adr.1. parameter fileAfter converting the spfile to pfile, we can see that the original bdump, adump, cdump, and udump settings

Interaction between main modules (introduces the main responsibilities of various modules of mysql) When Connection Manager receives a Connection from the client, it initializes the network Connection process and establishes the Connection handler

Two features of Oracle role 1) role DelayDelayed How to enable the role to take effect immediately:Set role name;For example:Set role resource;Delay recoveryThe following experiment demonstrates the delay recovery:Session (1) scott:Sys @ ORCL> conn

Log on to Oracle as a sys user, SQL> grant sysdba to username; Grant sysdba to username *ERROR at line 1:ORA-01994: GRANT failed: password file missing or disabled First, change the value of the initialization parameter REMOTE_LOGIN_PASSWORDFILE to

The application workload can be defined as services in Oracle 10 Gb, also known as services. It can be used in a single instance or separately used and managed in RAC. Therefore, the entire database load can be divided into multiple different

I. Code /** Connect to the Oracle database * Database Name: abc * Table Name: my_oracle * User name: system * Key: 123 * Port: (default) 1521 */ Void MainDialog: connectOracle (QString sIp, int iPort, QString sDbNm, QString SUSErNm, QString

Today's duty in case of really many, mirror database a large number of rollback, can not be started normally; A database inexplicable downtime; also within a month the second encountered a ORA-600, is it time to burn incense.Or simply record this

As a DBA, one of the common scenarios is: Create a tablespace: Create tablespace ThinkDatafile '/u01/app/Oracle/oradata/orcl/think. dbf' size 100 MAutoextend on next 10 M maxsize 4096 MExtent management local uniform size 256 KSegment space

I tested Stream over the past two days and found some information on the Internet to collect some information about Oracle RAC. After the test, I sorted out the results and shared them. You can try it on your own.1. Basic Environment1.1 source

Creating a web server is generally the first letter of LAMP (linux: Operating System, Apache: http server software, MySQL: database software, and PHP :( sometimes Perl or Python) combined. Component Analysis: Linux Linux is a free open-source

When my colleague retrieved the database, it was Oracle 10 Gb, and the previous deletion method was delete. I don't know how to use trancate. The SCN (System Change Number) is spelled as System Change Number, which is a very important data structure

Through the introduction in the last two articles, our redis server basically runs. All databases have the most basic CRUD functions. along this context, we start to learn about the rich data structures of redis. Of course, we should first start

Problem description: If you accidentally delete the dbf file of the Oracle database, an error is prompted when you start or close the database. When startup starts the database, the following message is displayed: ORA-01157: unable to

This problem was found in a test. Restore the backup of the production database on the VM. The server has 24 GB of memory, and the VM has allocated 2 GB of memory. Let's get down to the truth: When the system reports a ORA-00845 error, it is caused

Pl/SQL block that only contains the execution part Set serveroutput on -- enable output options Begin Dbms_output.put_line ('hello '); End; Instructions: Dbms_output is a package provided by Oracle locks (similar to java). This package

SQL> alter database begin backup; -- start to back up the databaseDatabase altered. SQL> host cp/u01/Oracle/oradata/ORCL/*. dbf/u01/oracle/dump1/-- power-off before execution, abort Problems occurred when restarting the database[Root @ station88 ~] #

Related Parameters and export examples: 1. DIRECTORY Specifies the directory where the dump and log files are located DIRECTORY = directory_object Directory_object is used to specify the DIRECTORY object name. Note that the DIRECTORY object is an

How to add a node Oracle 10g RAC Add a node The current RAC environment is as follows. You must delete racdb3 first. SQL> select INSTANCE_NAME, HOST_NAME, VERSION, STARTUP_TIME, STATUS, ACTIVE_STATE, INSTANCE_ROLE, DATABASE_STATUS from gv $ INSTANCE;

1. Create two external files in 1.txt and 2.txt with only one data. 2. Create a logical directory and perform proper authorization: SQL> create directory ztj1_dir as 'C: \ ztj1 \'; Directory created Then, manually create the actual directory in the