-
编辑 删除
12C Plug No_cdb Into Cdb
1 only nocdb operation: SQL> set linesize 500SQL> set pagesize 500SQL> show pdbsSQL> select cdb,NAME,dbid from v$database;CDB NAME &nbs...
-
编辑 删除
Oracle 12c rac 2node install on rhep6(non flex crs)
http://www.itpub.net/thread-1818063-1-1.html
-
编辑 删除
12 cloud control OEM Installer
http://www.itpub.net/thread-1822152-1-1.html
-
编辑 删除
Conn / as sysdba 出现ORA-01031: insufficient privileges
sqlplus '/ as sysdba'SQL*Plus: Release 10.2.0.1.0 - Production on Sun Oct 13 13:47:47 2013Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:ORA-01031: insufficient privil...
-
编辑 删除
Oracle11g ORA-00845: MEMORY_TARGET not supported on this system
[root@ruei ~]# umount /dev/shmumount: /dev/shm: device is busyumount: /dev/shm: device is busy[root@ruei ~]# [root@ruei ~]# fuser -km /dev/shm/dev/shm:  ...
-
编辑 删除
Config server pool in oracle 12c rac
[grid@oratest2 bin]$ ./srvctl config srvpool -serverpool testplServer pool name: testplImportance: 0, Min: 2, Max: 2Category: Candidate server names: srvctl modify srvpool&nbs...
-
编辑 删除
gc/Agent passwd reset
./emctl secure oms -resetOracle Enterprise Manager 10g Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.Enter Enterprise Manager Root Password : Ent...
-
编辑 删除
Database_Properties
SQL> col PROPERTY_VALUE for a35SQL> /PROPERTY_NAME PROPERTY_VALUE------------------------------ -----------------------------------DEFAULT...
-
编辑 删除
ORA-39123 ORA-29345/dbms_metadata_util.load_stylesheets
ORA-39123: Data Pump transportable tablespace job abortedORA-29345: cannot plug a tablespace into a database using an incompatible character setSQL> select tab1.aa||'_'||tab2.bb||'.'||tab3.cc from(sel...
-
编辑 删除
Drop Database
SQL> conn / as sysdba;Connected to an idle instance.SQL> startup mountORACLE instance started.Total System Global Area 272629760 bytesFixed Size ...
-
编辑 删除
9i dba_jobs_running
1 bug： from catjobq.sql 9i： create or replace view DBA_JOBS_RUNNING as select v.SID, v.id2 JOB, j.FAILURES, LAST_DATE, substr(to_c...
-
编辑 删除
Emca -Deconfig
[oracle@node2 bin]$ ./emca -deconfig dbcontrol db -repos dropSTARTED EMCA at Apr 25, 2013 2:19:37 PMEM Configuration Assistant, Version 10.2.0.1.0 ProductionCopyright (c) 2003, 2005, Oracle. All...
-
编辑 删除
ORA-38706 ORA-3871
SQL> startup mount;ORACLE instance started.Total System Global Area 205520896 bytesFixed Size 1218508 bytesVariable Size ...
-
编辑 删除
Recover Controlfile[incompelete recover]
RMAN> set dbid=224143822;executing command: SET DBIDRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-0...
-
编辑 删除
Restricting Access to a Database at Startup
archive log list;Database log mode No Archive ModeAutomatic archival DisabledArchive destination ...
-
编辑 删除
ORA-27452 ORA-06512
同事反应他们常用的应用用户，调用job报错如下：ORA-27452: is an invalid name for a database object.ORA-06512: at "SYS.DBMS_ISCHED", line 99ORA-06512: at "SYS.DBMS_SCHEDULER", line 262ORA-06512: a...
-
编辑 删除
Metlink:How to Modify Public Network Information including VIP in Crs
Applies to: Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.2.0.0 [Release 10.1 to 11.2]Information in this document applies to any platform.PurposeThe purpose of this note is to illust...
-
编辑 删除
Automatic Tuning of Undo_retention Causes Space Problems
Applies to: Oracle Server - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [Release 10.2]Information in this document applies to any platform.Oracle Server Enterprise Edition - Version: 10.2.0.1 t...
-
编辑 删除
Online Redefinition
begin dbms_redefinition.can_redef_table(uname => 'CT10000UAM', ...
-
编辑 删除
RMAN-00571 RMAN-00569 RMAN-00571 RMAN-03009 ORA-19588
Applies to: Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]Information in this document applies to any platform.***Checked for relevance on 24-May-2012***Sym...
