Database Administrator

Question: today, I want to create a user for the monitoring server I2000 in the current network database, requiring the user's permissions to be consistent with the permissions of an existing user in the database! I have provided my practice here.

View the operating system version: [Root @ rac1 ~] # Cat/etc/issueEnterprise Linux AS release 4 (October Update 7)Kernel \ r on an \ m View the kernel version: [Root @ rac1 ~] # Cat/proc/versionLinux version 2.6.9-78.0.0.0.1.ELsmp

1. To allow PHP to support PostgreSQL, you need to re-compile PHP; . /Configure -- prefix =/usr/local/php5 -- with-apxs2 =/usr/local/apache2/bin/apxs -- with-mysql =/usr/local/mysql -- with-config- file-path =/usr/local/php5 -- with-zlib --

2011.11.23 the ASM disk block of the Virtual Machine RAC results in DB ReconstructionWe just built a 10gr2 rac environment on a company's PC machine with vmware workstation8 and built it with bare equipment + ASM. After the installation is

1) Only appropriate privileged user can do delete operation on SYS. AUD $ table. The user must have either of the following privileges.-SYS user.-Delete any table system privilege. (If O7_DICTIONARY_ACCESSIBILITY = TRUE)-A user to whom SYS has

1.Set the total number of lines displayed on the page   1)View the currentPagesize,The default value is14: SqlplusCode 1.Show pagesize;   2)SetPagesizeSet100,You can display more than enough rows at a time.: SqlplusCode 1.Set

ORA-06413 Connection not open. Cause: Unable to establish connection. Action: Use diagnostic procedures to ascertain exact problem Error Description: it can be connected using the Oracle connection tool, and sqlplus can be connected on the

UPDATE SMS_PROVINCE set provincename = REPLACE (PROVINCENAME, CHAR (10), ''), CHAR (13 ),''); Environment: RHEL5 + MySQL Solution: UPDATE tablename SET field = REPLACE (field, CHAR (10), "), CHAR (13 ),"); Char (10): line feed Char (13): Carriage

When Oracle 9i Database is logged on, A ORA-01003 & ORA-01110 message is prompted, which probably means that the data file storage media is corrupt. Startup nomount, normal; Alter database mount, also normal; Alter database open:  Alter database

The Oracle password file is used to store the passwords of all users who connect to the database with the sysdba or sysoper permission. to remotely connect to the database with the sysdba permission, you must use the password file. Otherwise, you

Hibernate provides many methods for object operations. This article briefly introduces the use and comparison of these methods. Before describing the methods, describe the three states of objects in hibernate: transient, persistent,

I. background The production environment IBM P560 is currently used on the standby machine of Oracle universal uard. When oracle applies archive logs, check the server I/O and find that the I/O on Hdisk0 and 1 can sometimes reach 100%. There are

Today, I downloaded Oracle Linux 6.1 and installed it on a virtual machine. I am going to use it to install ORACLE 11G R2 (11.2.0.3). I suddenly found that yum cannot be used. I found it online, find the SETUP document on the

F: facet Name="Filter"> Af: selectOneChoice Required="# {Bindings. Pay0detailVO1. hints. Vsource. mandatory }" Includesc="# {Bindings. Pay0detailVO1. hints. Vsource. tooltip }" Id="Soc41" ContentStyle="Width: 100px ;" Value="# {Vs. filterCriteria.

1. Introduction to swingben  Currently, open-source Oracle stress testing tools on the network are mainly orabm and swingbench. Because orabm does not support oracle 11g, this test uses swingben for stress testing. In addition, swingbench can also

InLinuxInstalled onOracle 10g In the future, we will often useIsqlplusTo executeSQLStatement. But normalIsqlplusThe logon interface only supports Logon as a common user.SysIdentity permission to perform some operations, then how can

I. Overview of Oracle DataGuard EnvironmentOS: CentOS5 + ORACLE10G 10.2.0.4.0IP: 192.168.100.208 (primary) 192.168.8.201 (standby)ORACLE_SID: jscnORACLE_HOME:/oracle/ora10/product2. Preparations for the primary database1. modify primary dba to

Lab Purpose This experiment allows the students to master the basic usage of simple query statements and the specified alias methods, and create and execute SQL scripts. Lab requirements (1) master the basic use of SQL * Plus (2) understand the

1. Install Devadm @ devserver :~ $ Sudo apt-get install mysql-server......The following NEW packages will be installed:Libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient16Libnet-daemon-perl libplrpc-perl mysql-client-5.1

Sys @ DEX>Select*FromV $ statnameWhere Name Like '% Sort %'; STATISTIC #NAMECLASS STAT_ID ---------------------------------------------------------------------- 565 sorts (memory) 64 2091983730 566 sorts (disk) 64 2533123502 567 sorts (Rows) 6