oracle 11g sql certification

Tags: OracleOracle Database 11g Some important initialization parameters (i)Initialize parameter file locationD:\app\Administrator\admin\orcl1\pfile\init.oraInit.ora1, Diagnostic_destIn 11g, there is a new structure for storing diagnostic information called the Automated Diagnostics repository (AUTOMATICD Diagnostic Repository ADR).Specify the directory location with some parameters, such as $ORACLE_BASE/DI

Solution to ORA-01417 under Oracle 11g Today there is customer feedback, there is a SQL on 12C no problem, on Oracle 11g, the error is reported, the error content is ORA-01417: The table can be externally connected to at most one other table. This section analyzes the

The mongoel DG technology uses redo log transmission and application to ensure consistent data on the standby end and the primary end. In this process, Redo Transport and Redo Apply are two core actions. Redo Transport transmits the Redo Log information to the Standby end and waits for the Apply operation. Redo Apply is to execute these log applications and change the Standby data to achieve consistency. The following experiment uses alert log to observe the situation where a pair of Primary and

Background:The physical memory of the master and slave machines is doubled. After the memory is expanded, You need to modify the memory parameters related to the database, including the database and operating system. After doubling the memory size of the backup machine, modify the relevant memory parameters and start the database to the backup machine for two days. If no problem exists, then, double the physical memory of the previous host to switch the database to the slave host. The reason for

The following is a summary of the problems encountered when oracle 11g uses deferred_segment_creation to create a feature. Problem 1: You can create tables in all tablespaces. Problem 2: exp cannot export empty tables. Problem 1: Version: oracle 11.2.0.1.0 Select * from v $ version; create user aaa and grant the connect and resource roles to the User, but revoke

same database is used for both capture and replay operations to simplify the process. I am using the most basic Oracle 11g seed database and the sample solution installed by default. The DATABASE will run in ARCHIVELOG mode with the FLASHBACK log function, so that the flashback database command can be quickly used to roll back to an initial point during replay. Phase 1: Recording Load ◆ To create a capture

[[email protected] admin]$ Rman target Sys/[email protected] Auxiliary/Rman> duplicate target database for standby nofilenamecheck;Rman> exitClose the databaseShutdown immediate 5. Start the Redo applicationStartup Nomount;ALTER DATABASE mount standby database; sql> ALTER DATABASE recover managed standby database using current logfile disconnect from session; Database altered.6. VerificationMain LibrarySql> Archive Log ListDatabase Log Mode Archive

document can be downloaded to the script dbupgdiag.sql: Script. To Collect DB upgrade/migrate diagnostic Information (dbupgdiag.sql) [ID 556610.1] Run this script: CD $ sqlplus/as SYSDBA Sql> alter session set nls_language= ' American '; sql> @dbupgdiag. sql Sql> exit If the script reports a invalid object, r

Oracle provides the scott user's re-creation script, and the 11G uses the script to create scott. The simple operation is as follows: SQL> select * from dba_users where username = 'Scott '; ------ SCOTT has been manually deleted. No rows selectedSQL> exitDisconnected from Oracle Database

/dbhome_1/ Database location:/opt/oracle/oradata/ Product list:/opt/oracle/oraInventory/ SHAPE \ * MERGEFORMAT SHAPE \ * MERGEFORMAT Verify installation result Access the database using sqlplus from the command line Access https: // dbserver: 1158/em/from a browser/ Username sys, administrative password, connection identity SYSDBA [Root @ dbserver ~] #Cd/opt/o