Oracle

 Replace the Oracle cluster NIC (changing a network Interface)If you change the network card before and after the NIC name, IP, gateway, subnet mask is unchanged, the cluster level is not allowed to do extra operations!After you replace the NIC,

RowNum is a fake of Oracle, and its order increments according to the order in which records are fetched from the table, it is important to note that because the records are stored in the table in a disorderly way, you cannot get a result similar to

Su-root#groupadd Oinstall#useradd-G Oinstall Oracle#passwd Oracle#mkdir-P/u01/app/oracle#chown-R oracle:oinstall/u01/app/oracle$SU-#rm-F/etc/orainst.loc#touch Orainst.locCat >> Orainst.loc

1, delete the duplicate data of a table the same table_name usedDELETEFrom table_name AWHERE rowid > (SELECT min (rowid)From table_name bWHERE b.id = a.id and B.name=a.name);2. Export all information of a userExp scott/[email protected]File=d:/scott.

The installation process is simple, follow the steps to go. Here's a reminder. If you are using PL/SQL to operate Oracle, it is best to install a 32-bit Oracle program. The reason is that the web says PL/SQL only supports 32-bit Oracle, and if you

Oracle Configuration Tnsnames.ora File InstanceIn order to connect with the server, the client must first contact the listening process on the server. Oracle describes the connection information through the connection descriptor in the Tnsnames.ora

ORA-12514 The TNS listener is currently unable to identify the resolution of the request service in the connection descriptor (2011-01-20 13:50:37)reprint http://blog.sina.com.cn/s/blog_5007d1b10100oqo8.html Tags: it Category:

In a project, a backup of a data table, or a backup of a data table structure, is often required so that it can be done with SQL statements.1. Copy the table structure and its data:CREATE TABLE Table_name_new as SELECT * from Table_name_old2. Copy

I've never used Oracle. Today finally installed, said I installed the process, feeling still a little toss.One, I installed the Oracle version 9, the total size downloaded from the Internet 1.3G. is a three compressed package.First, after extracting

-PrincipleNulls first and Nulls last are the syntax supported by the Oracle order by, if an expression is specified in order by, the record that represents a null value is ranked at the top (either ASC or DESC) If the expression is specified in the

Problem description: On February 10, 00600, the Ora-9835218 error occurred while checking the database warning file, and the Rman L1 backup failed. query the relevant information and find that the error was a Bug. Therefore, we asked SR for official

SQL dialect configuration for oracle, mysql, and sqlserver databases in hibernate4 (SQL Dialects) Database Type Hibernate SQL Dialect DB2 Org. hibernate. dialect. DB2Dialect DB2 AS/400 Org. hibernate. dialect. DB2

Linux system boot oracle self-boot Log On As root: $ Su-root 1. dbstart and dbshut of oracle in linux do not respond: Modify the Oracle system configuration file/etc/oratab: # vi/etc/oratab /Etc/oratab format: SID: ORACLE_HOME: AUTO Set the AUTO

I used to share the RMAN backup script column in my blog. I used RMAN to back up the file to a local path, and then uploaded the backup file to the FTP server through FTP. Next, we will briefly introduce another RMAN backup solution. Below is a

Oracle11g RAC construction in linux (iv) III. Configure shared storage configuration ASM management preparation 1) OCRDISK: stores CRS resource configuration information 2) VOTEDISK: The arbitration disk, which records the node status. 3) DataDisk:

Changing the NIC of an oracle cluster (Changing a Network Interface) If the NIC name, ip address, gateway, and subnet mask remain unchanged before and after the NIC, no additional operations are required at the cluster level! Next, use the new Nic

Often used in the development of Oralce database, use may encounter a variety of errors, such as: ORA-00933: SQL command is not properly ended, ORA-009242, etc, this record accumulation is very helpful for you. Today we will record some problems

We can use the show sga command to view the overall components of the Shared Pool: ... Waiting .... I. SGA Memory Structure In Oracle, SGA mainly includes: 1. FIXED data structure (FIXED Size) 2. data block BUFFER (database buffer) 3. redo log

1. The original intention of installing rlwrap;2. Install the rlwrap tool and problems encountered;3. Use the rlwrap tool; 1. The original intention of installing rlwrap:In Windows, SQLPLUS can be used to flip the front and right sides of the up

Create a trigger. When a record is deleted from the employee table emp, write the deleted record to the employee table deletion log table. -- Create a trigger to add the employee information to the log information table emp_his before deleting