![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
database
文章平均质量分 53
yaluo009
这个作者很懒,什么都没留下…
展开
-
RDBMS Database Patchset Patch Numbers
Quick Reference to RDBMS Database Patchset Patch Numbers (文档 ID 753736.1)In this Document Goal SolutionAPPLIES TO:Oracle Database - Enterprise Editi翻译 2013-10-19 10:50:42 · 1088 阅读 · 0 评论 -
db queue grant and revoke
1>grantdbms_aqadm.grant_queue_privilege ('','SYS.SYS$SERVICE_METRICS', '');for example: exec dbms_aqadm.grant_queue_privilege ('DEQUEUE','SYS.SYS$SERVICE_METRICS', 'SCOTT');SQL> select *原创 2016-10-21 10:25:49 · 439 阅读 · 0 评论 -
linux fs
1>Kernel Warning : EXT4-fs (dm-X): ext4_da_update_reserve_space (Doc ID 1616773.1)# tune2fs -l /dev/mapper/ | grep features# umount /# tune2fs -O /dev/mapper/# tune2fs -l /dev/mapper/ |原创 2016-10-19 09:26:44 · 1437 阅读 · 0 评论 -
Which packages did exist in Oracle 11.2.0.4 but don't exist in Oracle 12.1.0.2 anymore?
https://blogs.oracle.com/UPGRADE/entry/package_differences_between_oracle_11Package Differences between Oracle 11.2.0.4 and 12.1.0.2? By Mike Dietrich-Oracle on Jun 23, 2015The quest翻译 2016-10-17 13:05:41 · 416 阅读 · 0 评论 -
How to add Oracle OLAP to a 12c Database? (Doc ID 1936550.1)
The initial checks are identical for a Multitenant and non-Multitenbant environment:1. The Oracle OLAP option is only available as part of the Enterprise Edition (EE) of the Oracle RDBMS.Therefore原创 2016-10-17 10:32:49 · 2094 阅读 · 0 评论 -
oracle job
可视化编辑器,alt+1到9键,切换到工具区,tab键,选择按钮,esc键,返回编辑 --1.plsql中学习job --学习job --建表 create table test_job(para_date date); commit; insert into test_job values(sysdate); commit; s转载 2016-09-08 09:20:52 · 278 阅读 · 0 评论 -
12c xdb_wallet default directory
EM Express 12c Database Administration Page FAQ (Doc ID 1601454.1)How can I replace the default wallet/certificate?The XDB wallet is stored in the $ORACLE_BASE/admin//xdb_wallet director原创 2016-09-20 15:16:34 · 975 阅读 · 0 评论 -
ORA-28040 no matching authentication protocol
Log: Adcfgclone.pl tier apps Errors with RC-40201: Unable to connect to Databasemetalink doc:After a Database Upgrade to 12c for E-Business Suite, JDeveloper Connections Fail With Er原创 2016-09-15 16:36:16 · 587 阅读 · 0 评论 -
11g 12c nls parameter
11gselect * from nls_database_parameters;12cshow parameter nls原创 2016-07-21 09:13:18 · 398 阅读 · 0 评论 -
ORA-04098: trigger 'SYS.OLAPISHUTDOWNTRIGGER' is invalid and failed re-validation
Invalid OLAP Triggers after Upgrade to 12.1.0.2 and/or Application of PSU on 12.1.0.2 (Doc ID 2056217.1)Symptoms After upgrading to 12.1.0.2 or applying a PSU on 12.1.0.2 you get the follo原创 2016-07-07 16:09:49 · 3893 阅读 · 0 评论 -
ORA-32004:obsolete or deprecaated parameter(s) specified for RDBMS instance Oracle 12c Release 1
ORA-32004:obsolete or deprecaated parameter(s) specified for RDBMS instance,when Oracle 12c Release 1 startup.########## # Database Password Case Sensitivity# # The default v原创 2016-07-07 09:31:24 · 671 阅读 · 0 评论 -
pdksh-5.2.14 elfutils-libelf-devel-0.97 Are Missing
Installing 11.2.0.3 Or 11.2.0.4 (32-bit (x86) or 64-bit (x86-64) ) On RHEL6 Reports That Packages "elfutils-libelf-devel-0.97" And "pdksh-5.2.14" Are Missing (PRVF-7532) (Doc ID 1454982.1)Sympto原创 2016-07-06 09:05:04 · 1123 阅读 · 0 评论 -
oracle 表空间使用率查询
SELECT a.tablespace_name 表空间名, total 表空间大小, free 表空间剩余大小, (total - free) 表空间使用大小, ROUND((total - free) / total, 4) * 100 使用率 FROM (SELECT tablespace_name, ROUND(转载 2016-06-28 13:57:34 · 265 阅读 · 0 评论 -
oracle privs
系统权限select * from dba_sys_privs;select * from dba_role_privs;select * from dba_tab_privs;ORACLE权限: 系统权限: 允许用户执行特定的数据库动作,如创建表、创建索引、连接实例等 对象权限: 允许用户操纵一些特定的对象,如读取视图,可更原创 2016-10-21 10:42:40 · 539 阅读 · 0 评论