Oracle

On Solaris, when Oracle 10g Database is started automatically, the following prompt is displayed: www.2cto.com ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net ListenerUsage: /export/home/oracle/product/10gr2/bin/dbstart ORACLE_HOME

The crsctl, ocrcheck, ocrdump, and ocrconfig commands on the RAC cluster layer are detailed. The cluster layer is a core cluster composed of Clusterware, which maintains the shared devices in the cluster, and provides a complete cluster Status view

When oracle manually adds a database and starts the database instance normally, 1. manually delete the old database. Stop the running database www.2cto.com SQL> shutdown immediate; enter the Mount database (load the instance and open the control

Oracle escape & Analysis of insert into table1 (ID, DESCRIPTION) values (1, '/Action. do? Method = getA & iframe = true '); when inserted in pl/SQL, iframe is regarded as a variable and changed to the following form: insert into table1 (ID,

10500 event tracking SMON process is a key process in ORACLE. It is responsible for INSTANCE rediscovery, clearing temporary segments, merging idle space, shrinking rollback segments, and maintaining the SMON_SCN_TIME table. We can track the above

The multi-row data in the Oracle column is combined into one display character. oracle provides two functions: WMSYS. WM_CONCAT and listparts. Www.2cto.com: WMSYS. WM_CONCAT example: id name 1 aa 2 bb 3 cc results in "aa, bb, cc" select WMSYS.

The sequence created in oracle is the so-called serial number. It is automatically added each time it is obtained. It is generally used in places where the sequence is sorted by serial number. Www.2cto.com 1. Create Sequence you must have the create

If Oracle is not installed, PlSqlDeveloper re-installs the company's machine a few days ago. Basically, all the work needs are installed, so oracle is worse. Generally, plsql developer is used, it cannot be used without oracle installation, but it

Oracle 11.2.0.3 RAC environment ORA-29280 error solution the customer's 11.2.0.3 RAC environment automatically runs the JOB reports an error ORA-29280. Detailed error message for www.2cto.com: Sat Sep 15 05:59:59 2012 VKRM started with pid = 54, OS

The strange DECODE function encountered the following problem today: www.2cto.com order by decode (column_id, 1, null, 2, null, 3, null, column_id, that is, when the number of columns is greater than 10, the column_id order is 10, 11, 12, 13, 6, 7, 8

The default auto-Growth of primary keys in Oracle many times when database-related operations are performed, primary keys cannot be filled by users or when multiple users operate on one table at the same time, we need to strictly control the primary

Oracle assigns permissions to log on to the database www.2cto.com as an administrator. create user: create user [username] identified by [password]; grant logon permission: grant create session to [username]; grant table creation permission: grant

MAXAIO causes Oracle to start the hang problem Oracle database, 10.2.0.4 for linux x86. When it restarts normally, it freezes to the open stage. On the operating system, the CPU usage of some user processes started due to scheduled tasks is almost 10

Em/console/aboutApplication System Error 2 the system cannot find the specified file. Solution error Description: https: // lizhengnanhua1: 1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 11g Database Control... system Error 2.

SQL optimization series (2) _ SQL optimization sorting 1. SQL query optimization (1 ). table name order (only valid in rule-based Optimizer): The Parser for www.2cto.com ORACLE processes the table names in the FROM clause in the order FROM right to

To reduce the redo size of Oracle, use lab instructions www.2cto.com 1. In non-archive mode: [SQL] SQL> archive log list database log mode automatic archiving in non-archive mode disable archiving end point USE_DB_RECOVERY_FILE_DEST oldest online

Oracle COALESCE function syntax is COALESCE (expression 1, expression 2 ,..., expression n), n> = 2. The function of this expression is to return the first non-null expression. If both are null, a null value is returned. Note: All expressions must

Data Guard configures Standby Redo Log Data Guard in maximum protection and maximum availability mode, for real-time use of the maximum performance mode, the Standby database must be configured with the Standby Redo Log www.2cto.com slave database

Data Guard Standby_archive_dest and Log_archive_dest_n: www.2cto.com STANDBY_ARCHIVE_DEST is relevant only for a standby database in managed recovery mode. it specifies the location of archive logs arriving from a primary database indicates the

Since ORACLE 9i, Oracle provides a Web-based graphical data management tool OracleOracle Enterprise Manager (Oracle Enterprise Manager) is used to manage databases instead of SQL commands. In Windows, OEMs are enabled by default and can be accessed