51CTO博客开发
测试环境一段sql，无法跑出结果，在生产环境同样的sql，秒出，后来发现select后面的自定义函数对应的包失效，尝试重新编译包，无法编译。找到锁住的包的会话，全部杀掉，重新编译。SELECT 'alter system kill session ' || '''' || sid || '
&
--buffer busy waitsselect sw.P1 "FILD ID", sw.P2 "Block ID", sw.P3 "Class ID" from V$session_Wait sw where sw.EVENT='buffer busy waits'SELECT s.ROW_WAIT_OBJ# FROM V$SESSION s where event = 'buff
Symptoms今天群里一哥们，问Chrome登录EBS报错FRM-92120如何解决。由于平时都使用IE，对Chrome还真没有研究过。FRM-92120: Registry file http://servername:8888/forms/java/oracle/forms/registry/Registry.dat is missingCause这类错误，主要和客户端浏览器和JAVA有关。
--case when 的行转列select e.job as "工作"，case e.deptno when 10 then sal end as " 部门 10 工资",case e.deptno when 20 then sal end as "部门 20 工资",case e.deptno when 30 then sal end as "部门 30 工资",e.sal as
--Join Predicate Pushdowncreate table emp1 as select * from scott.emp create table emp2 as select * from scott.emp create index idx_emp1 on emp1(empno);create index idx_emp2 on emp2(empno);create or r
--标量子查询select e.empno, e.ename, e.sal, e.deptno, (select d.dname from dept d where e.deptno = d.deptno)as dname from emp e--插入一条数据insert into emp(empno,deptno
Can this feature be disabled without administrative access?Yes. This can be done by deleting any previously downloaded versionlist.xml files and instructing IE to stop updating the XML file. This can
oracle ASM替换存储和主机：1.在新的主机当安装单机GRID,和数据库软件，可以从源主机上拷贝，然后克隆操作2.把新的存储挂在旧的主机上，建立新的磁盘组，用back as copy 把数据库备份到新的磁盘组上，然后新的存储从旧的主机上取消映射，3.把旧的OCR 导出，并导入新的主机上，./ocrconfig -export /tmp/033_asm.ocr./ocrconfig -expo
copy 备份：[oraprod@ebsprod ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jun 20 11:28:50 2016 Copy
1.数据库当前版本 SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64b
把EBS 数据库从11.1.0.7升级到11.2.0.4后，无法登陆[oraprod@ebsprod PROD_ebsprod]$ sqlplus / as sysdbaERROR:ORA-01804: failure to initialize timezone informationSP2-0152: ORACLE may not be functioning properlyFIX:####
EBS R12 Database upgrade 11.1.0.7 to 11.2.0.4EBS R12.1.3 - DatabaseUpgrade 11.1.0.7 to 11.2.0.4· Interoperability NotesEBS 12.0 and 12.1 with Database 11
7 升级Oracle数据库到11gR27.1 先打补丁7303030_zhs，9062910，8919489，8919489_ZHS ，9868229，10163753，11071569，9738085，9852070，12686610（貌似批量打补丁时查询麻烦，所以不用AD Merge Patch）停应用：su – appltest. /u01/TEST/apps/apps_st/appl/AP
修密码前一定备份一下，SQL> create table fnd_user_20160614 as select * from fnd_user;Table created.SQL> create table fnd_oracle_userid_20160614 as select * from fnd_oracle_userid; Table created.如果修改失败
FND_SESSION_MANAGEMENT.CHECK_SESSION When Logging On---201407211. 问题现象：Clone EBS 12.1.3后登陆提示如下：Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 has been detecte
SELECT REQUEST_ID, a.user_name, f.ACTUAL_START_DATE DATE_STARTED, DECODE(TRUNC(sysdate - ACT
yum install gcc \glibc \glibc-common \glibc-devel \glibc-devel \libgcc \libgcc \libstdc++ \libstdc++ \libstdc++ \libstdc++ \make \gdbm \gdbm \libXp \libXp \libaio \libaio \libgomp \sysstat \util-linux
步骤一安装字符集，具体方法如下smit lang1.查看操作系统当前字符集：# locale 2.查看操作系统已安装字符集：# locale -a 3.安装新字符集： #smit lang ---->Add Additional Language Environments ---->CULTURAL conve
--创建用户DECLAREv_user_name VARCHAR2 (100) := upper('&Enter_User_Name');v_description VARCHAR2 (100) := 'NEW Test User';BEGIN fnd_user_pkg.createuser(x_user_name => v_user_name, x_owner
select * from test1 where owner='SCOTT' or object_id in(select object_id from test2 where owner='SCOTT');select * from test1 where owner='SCOTT' unionselect * from test1 where object_id in(selec
#mkdir /databack#mklv -t jfs2 -y lv_databack datavg 2g-t 为逻辑卷类型-y为逻辑卷名字datavg是指定卷组2g是逻辑卷的大小#crfs -v jfs2 -d lv_databack -A yes -m /databack-v 为文件系统的类型-d为逻辑卷名字-A 为系统重启后自动挂载-m为挂载的目录
--报表所属职责SELECT FCPT.USER_CONCURRENT_PROGRAM_NAME, FRG.REQUEST_GROUP_NAME, FR.RESPONSIBILITY_KEYFROM FND_CONCURRENT_PRO
SELECT wk.*, decode(wk.description, NULL, &nb
http://blog.delphix.com/ron/2014/06/18/oracle-ebs-r12-2-install/ http://appsdbaworkshop.blogspot.com/2013/10/oracle-applications-r122-installation.html
首先，通过 select userenv('language') from dual;SIMPLIFIED CHINESE_CHINA.WE8MSWIN1252查询oracle服务器端的编码， 如为： SIMPLIFIED CHINESE_CHINA.WE8MSWIN1252 显示什么编码 就设置什么编码 在我们的客户端需要和服务器端的编
-查看EBS用户的所有职责：SELECT frt.responsibility_name, furg.END_DATE FROM fnd_user_resp_groups furg, fnd_responsibility fr, &n
AIX上用tar更换java版本的时候发生此问题，但ps -ef检查后并未发现相关进程。用”slibclean”命令清一下系统的动态库 搞定！由于netback空间增长，无法找到具体的文件，服务器上有oracle数据库。可以执行slibclean清除，释放空间
--row_numberSELECT ename, deptno, rownum, row_number() over(ORDER BY deptno) rn, rank() over(ORD
Copyright © 2005-2023 51CTO.COM 版权所有 京ICP证060544号
