database
Download the grid 12c setup from MYORACLESUPPORT and unzip the setup. Double click the setup.exe and initiate the installation process. Select the appropriate option for the installation of your desire. Click next. Here i will be installing the software only and will be configuring the Grid latter. Select the
database
ORA-01194: 文件 1 需要更多的恢复来保持一致性 解析 Posted by PDSERVICE on May 30, 2016 In ORA-1194 "file %s needs more recovery to be consistent" ORA-1547 "warning: RECOVER succeeded but OPEN RESETLOGS would get error below" ORA-1110 "data file %s: '%s'" ? [oracle@mlab2 ~] $ oerr ora
Oracle
ORA-01659: 無法分配超出 7 的 MINEXTENTS (在表空間 DATA 中) 查了一下資料，原來是在創建表空間的時候，沒有把表空間設置成自動擴展，表空間不夠造成的。可以選擇擴大表空間，或者設置成自動擴展。 通過DBA帳號查出表空間存儲路徑 select name from v$datafile 1E:\APP\ADMINISTRATOR\ORADATA2\ORCL\SYSTEM01.DBF 2E:\APP\ADMINISTRATOR\ORADATA2\ORCL\SYSAUX01.DBF 3E:\APP\ADMINISTRATOR\ORADATA2\ORCL\UNDOTBS01.DBF 4E:\APP\ADMINISTRATOR\ORADATA2\ORCL\USERS01.DBF 5E:\APP\
database
Playing with Oracle 12c Multitenant Users and Roles Posted on November 10, 2013 I’ve realized these days that the great list of articles by Oracle Alchemist does not contain any articles describing a little more in depth common roles and Users. I’ve found these ones by Pete Finnigan
configuration
Oracle Database 12c – How to Add / Multiplex Control Files PURPOSE: – protect your Database in case of a disk failure – reduce the risk of control file loss due to corruption or accidental removal – as a DBA, it’s your responsibility to multiplex and backup control files to protect your organization in
Oracle
Oracle Database 12c Release 1 (12.1) Installation on Oracle Linux 7 (OL7.2) Note from Oracle Database 12c R1 Installation Guide: * Starting with Oracle Database 12c Release 1 (12.1.0.2), Oracle Linux 7 and Red Hat Enterprise Linux 7 are supported on Linux x86-64 systems. Supported Oracle
database
Oracle 12c: Create a Container Database (CDB) manually with CREATE DATABASE script Note: Oracle strongly recommends using the Database Configuration Assistant (DBCA) instead of the CREATE DATABASE SQL statement to create a CDB, because using DBCA is a more automated approach, and your CDB is ready to use when DBCA
database
下面指令，都請至該台DB SERVER cmd模式下執行 1.查看archive相關設定值 c:\>sqlplus / as sysdba SQL> SHOW PARAMETER ARCH NAME TYPE VALUE —————————- ——– ——————- ………(篇幅關係 上面還有，只取下面) log_archive_dest_state_9 string enable log_archive_duplex_dest string log_archive_format string ARC%S_%R.%T log_archive_local_first boolean TRUE
database
rman target sys/corl Recovery Manager: Release 12.2.0.1.0 – Production on Mon May 14 16:31:37 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL001 (DBID=3872964947) RMAN> show archivelog deletion policy; using target database control
database
Oracle Database 12c 因為有 multitenant container database (CDB) 及 pluggable databases (PDBs) 的功能，所以在建立帳號時，就必需要指定。不然會有錯誤訊息：ORA-65096: invalid common user or role name [oracle@oradb12clinux ~]$ echo $ORACLE_SID orcl [oracle@oradb12clinux ~]$ sqlplus / as sysdba SQL> show con_name CON_NAME —————————— CDB$ROOT SQL> create user abcd identified by
database
https://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN11258 The V$DIAG_INFO view lists all important ADR locations for the current Oracle Database instance. SELECT * FROM V$DIAG_INFO; INST_ID NAME VALUE ------- --------------------- ------------------------------------------------------------- 1 Diag Enabled TRUE 1 ADR Base /u01/oracle
configuration
Oracle的優化器(Optimizer)-Analysis 標籤： Oracle Oracle的優化器(Optimizer)有兩種優化方式, Hint也不例外，除了/*+rule*/其他的都是CBO優化方式 基於規則的優化方式(Rule-Based Optimization，簡稱為RBO) 基於成本的優化方式(Cost-Based Optimization，簡稱為CBO) RBO(Rule-Based Optimization)方式：優化器在分析SQL語句時,所遵循的是Oracle內部預定的一些規則。比如我們常見的，當一個where子句中的一列有索引時去走索引。 CBO(Cost-Based Optimization)方式：它是看語句的成本(Cost),這裡的成本主要指CPU和記憶體RAM。 優化器在判斷是否用這種方式時,主要參照的是表及索引的統計資訊。統計資訊給出表的大小、 有多少行、每行的長度等資訊。這些統計資訊起初在庫內是沒有的，是做 Analyze 後才出現的，很多的時侯過期統計資訊會令優化器做出一個錯誤的執行計畫, 因些應及時更新這些資訊