Database Administrator

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

Recently, the company needs to build Oracle9i on a 64-bit RedHat system, which is a relatively old version and is difficult to install. The general installation process is as follows: 1. Download the installation package 1、amd64_db_9204_disk1_1-32.16

1. view the storage engines supported by the system Show engines; 2. view the storage engine used by the table Two methods: A. show table status from db_name where name = 'table _ name '; B. show create table table_name; If the display format

The purpose of setting unused is to use the unused flag to delete the unused when the cpu, memory, and other resources are insufficient. After setting the unused column, the column data is not deleted immediately, but hidden physically. The recovery

1. By default, Oracle log files are recorded in the $ ORACLE/rdbms/log directory. [Oracle @ oracle log] $ pwd/Home/oracle/product/10.2.0/db_1/rdbms/log The log file is (alert _ ): [Oracle @ oracle log] $ ll Total 848 -Rw-r -- 1 aaa 962 06-20

This is the case: Due to my carelessness, I helped other departments to update some data in batches on October 13, July 30. Who knows that the global update is complete, and I was notified of this problem only on October 10, September 26. They

The developer asked me to set an Oracle 11g sga slightly larger. Therefore, follow the previous 10 Gb memory operation on oracle.[Oracle @ localhost db_1] $ sqlplus/nolog SQL * Plus: Release 11.2.0.1.0 Production on Saturday June 30 13:42:07

There are many ways to synchronize tables between Oracle databases, such as triggers, Materialized View (MV), Stream, and Goldengate. Materialized View is a database object that includes query results. It is a local copy of remote data or used to

Oracle EBS R12.1.1 on Oracle Linux 64 5.7 The dependency package selects only the oracle-validated-1.1.0-14.el5, and no other dependency package verification is performed. 1. All http-related services fail to be verified in the last step. 1.1 run

Environment: Oracle 11.2.0.1.0 RHEL5.3 64bit mysql Server version: 5.5.9 1: Download [ODBC Driver Manager] unionODBC2.2.14, decompress the package, and put it in the/u01/app/tools/unionodbc directory. [Oracle @ wonder tools] $

I learned about the Partition Table Technology in Oracle today. Now I want to save the statement for creating a partition table here! SQL> conn system/windows @ studyConnected. SQL> create tablespace test datafile 'd: \ oracle \ product \ 10.2.0 \

Currently, ASM instances are widely used in both rac and single-instance database environments. This article mainly introduces the management of ASM instances in Oracle 11.2.0.3, including the following:1: view the status of the ASM disk and disk

I. environment required The IP addresses of MYSQL services installed on both virtual machines are 192.168.1.1 192.168.1.2. 2. The procedure is as follows; Virtual Server 1 [Root @ localhost ~] # Yum install mysql-server-y [Root @ localhost ~] #

MongoDB does not provide the installation package. You can download the package directly to learn how to use it. Installation: 1. Run: D: \ Tools \ mongodb \ bin> mongod -- dbpath "E: \ MyProject \ Web \ mongo \ data" on the console. Note that

There are two problems with uninstalling the Oracle Al Installer that comes with Oracle: 1) Slow speed; 2) not clean; not completely; there are some residual registries that will affect subsequent installation. Therefore, we recommend that you

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

Manage databases 1. create a database: create database name; 2. Connect to the database: use database name; 3. delete a database: drop the database name; Manage tables 1. create a table: create table Name ( Table Name Data Type (length ), Table Name

A few days ago when the machine room to connect to the database server, reported "ORA-12170: TNS: Connection timeout ". It took me two days to solve this error. Now, I hope you will not take any detours. The error message indicates that the local

Data Integrity Overview 1. entity integrity An object is an object in the world. Every row in RDBMS represents an object. Entity integrity means that every entity can be differentiated. Therefore, entity integrity is generally achieved through

Rename a data file If the primary database re-commands one or more data files, the modification will not be automatically transmitted to the standby database. If you want to make standby and data files consistent with primary, you can only manually