专注Oracle EBS--理性的浪漫
===========================================================
===========================================================

卸载掉了搜狗,然后被它一直占用的热键SHIFT+CTRL+1 不会释放出来,然后我找资料到注册表删除的键值才可以.

 查看全文

moonsoft 发表于:2009.06.23 00:06 ::分类: ( view ) ::阅读:(71次) :: 评论 (1)
===========================================================
===========================================================
有时候我们会不小心修改了spfile的某些参些参数导致数据库不能启动,这时候改怎么让数据库重新跑起来呢,oracle 针对spfile还是提供了几种方法来修复的。 Oracle参数文件有三种: spfile: spfile.ora pfile: init.ora init: init.ora 参数文件的默认路径为: $ORACLE_HOME/dbs (UNIX) 查看全文
moonsoft 发表于:2009.06.02 20:59 ::分类: ( ORACLE DBA ) ::阅读:(95次) :: 评论 (0)
===========================================================
===========================================================

本来想修改系统的PROCESSES , SESSIONS 等参数, 却遇到

ORA-00064: object is too large to allocate on this O/S (1,440000012)

ora-32001 :write to spfile requested but

经过查资料及自己的摸索,终于解决了

以下是操作LOG :

 查看全文
moonsoft 发表于:2009.06.02 20:52 ::分类: ( ORACLE DBA ) ::阅读:(95次) :: 评论 (0)
===========================================================
===========================================================

新增成本会有一个月标准折旧,下面举了个例子,欢迎财务顾问提出看法

 查看全文
moonsoft 发表于:2009.05.26 20:40 ::分类: ( 财务 ) ::阅读:(168次) :: 评论 (0)
===========================================================
===========================================================

上周我进行了非常重要的一次面向最终用户的培训,可是由于系统设置的不规范操作和没有专业DBA的陪同,可以说是出现了实施生涯最丢脸的一次培训,当系统运行一些标准请求出错时,我恨不得找个地缝钻进去!太丢脸了......

同时作为项目组成员难逃其咎,可是在实施过程中乙方公司又不听自己的任何建议,心里真是感觉冤枉.在没有进行任何压力测试的情况下进行CRP3培训真是冒险

 查看全文

moonsoft 发表于:2009.05.17 23:59 ::分类: ( EBS , ORACLE DBA ) ::阅读:(330次) :: 评论 (3)
===========================================================
===========================================================
庆祝一下,最近,一些很伤心的事情,一些麻烦的事发生过,同时也很少再去做技术层面的东西,所以不知不觉博客文章也少了些,以后要加强博客和自己知识的总结.

moonsoft 发表于:2009.05.08 18:30 ::分类: ( 理性的浪漫 ) ::阅读:(133次) :: 评论 (0)
===========================================================
===========================================================
解决办法之一是: /ora11510/oracle/visdb/9.2.0/network/admin/VIS_erp 下面有一个文件叫 sqlnet.ora 如果里面的 tcp.validnode_checking 是tcp.validnode_checking = yes 请改成 tcp.validnode_checking = no 然后重新启动数据库即可用sql navigator或者pl/sql developer访问了
moonsoft 发表于:2009.04.10 16:39 ::分类: ( ORACLE DBA ) ::阅读:(189次) :: 评论 (0)
===========================================================
===========================================================
When I apply RUP6 PATCH third time get fellow error, it is still running....

There are now 3711 jobs remaining (current phase=A35):
0 running, 2 ready to run and 3709 waiting.

Assigned: file WFRESGEN on worker 1 for product fnd username APPLSYS.
Assigned: file WFRESGEN on worker 2 for product fnd username APPLSYS.
FAILED: file WFRESGEN on worker 1 for product fnd username APPLSYS.
Deferred: file WFRESGEN on worker 1 for product fnd username APPLSYS. (Deferment number 1 for this job)
FAILED: file WFRESGEN on worker 2 for product fnd username APPLSYS.
Deferred: file WFRESGEN on worker 2 for product fnd username APPLSYS. (Deferment number 1 for this job)
Assigned: file WFRESGEN on worker 1 for product fnd username APPLSYS.
Assigned: file WFRESGEN on worker 2 for product fnd username APPLSYS.
FAILED: file WFRESGEN on worker 2 for product fnd username APPLSYS.
Deferred: file WFRESGEN on worker 2 for product fnd username APPLSYS. (Deferment number 2 for this job)
Assigned: file WFRESGEN on worker 2 for product fnd username APPLSYS.
FAILED: file WFRESGEN on worker 1 for product fnd username APPLSYS.
Deferred: file WFRESGEN on worker 1 for product fnd username APPLSYS. (Deferment number 2 for this job)
Assigned: file WFRESGEN on worker 1 for product fnd username APPLSYS.
FAILED: file WFRESGEN on worker 1 for product fnd username APPLSYS.
FAILED: file WFRESGEN on worker 2 for product fnd username APPLSYS.

ATTENTION: All workers either have failed or are waiting:

FAILED: file WFRESGEN on worker 1.
FAILED: file WFRESGEN on worker 2.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

moonsoft 发表于:2009.03.07 18:04 ::分类: ( EBS , ORACLE DBA ) ::阅读:(191次) :: 评论 (0)
===========================================================
===========================================================

前天晚上开始就牙龈肿痛, 我也没有吃什么上火的东西,搞不明白,只是前几天听到别人说牙龈肿痛,我还想自己好久没有过了,谁知道马上就报应到我头上了,人不能太沾沾自喜。

晚上10:10就睡觉了,难得一次这么乖早早睡觉,可是到凌晨就牙痛醒了,而且口渴,索性就起来看看6728000补丁打得怎么样了,得到如下错误:

 查看全文

moonsoft 发表于:2009.03.06 02:01 ::分类: ( 理性的浪漫 , EBS , ORACLE DBA ) ::阅读:(268次) :: 评论 (1)
===========================================================
===========================================================
FA 快速增加的时候出现错误APP-OFA-47290



手动增加资产就没有这个错误,奇怪
FAXASSET APP-OFA-47290: Units Assigned Must Not Exceed Units
 查看全文
moonsoft 发表于:2009.03.05 16:31 ::分类: ( 财务 ) ::阅读:(178次) :: 评论 (0)
===========================================================
===========================================================

0305 log


AutoPatch error:
--------
Missing prerequisite codelevel for entity 'ad'.

This patch requires the following codelevel or higher: 'R12.AD.A.6'.
The current on-site codelevel for the entity 'ad' is : 'R12.AD.A.4'.

In order to apply this patch you must first apply a patch that introduces
at least the minimum required codelevel.

You may merge this patch with a patch that introduces the required codelevel.
--------


Warning:

The description for the entity 'dna' in the patch driver
does not match with the current description.

The current description is :'Development'
The description in the patch is :'Product Workbench'

The current description will not be changed.


Warning:

The description for the entity 'iby' in the patch driver
does not match with the current description.

The current description is :'iPayment'
The description in the patch is :'Payments'

The current description will not be changed.


Warning:

The description for the entity 'izu' in the patch driver
does not match with the current description.

The current description is :'Support Diagnostic Tools'
The description in the patch is :'Oracle E-Business Suite Diagnostics'

The current description will not be changed.


AutoPatch error:
--------
A fatal error related to codelines or codelevels has occurred.

See messages above for details.
--------

 查看全文
moonsoft 发表于:2009.03.03 11:00 ::分类: ( EBS , ORACLE DBA ) ::阅读:(305次) :: 评论 (0)
===========================================================
===========================================================

1.CATEGORY FIEXFIELD 不允许动态插入,

2.AP LOOKUP CODE INVOICE TYPE 也不允许DISABLE 有些发票类型

原因

http://www.itpub.net/viewthread.php?tid=1130192&pid=12968995&page=1&extra=#pid12968995

 查看全文
moonsoft 发表于:2009.02.26 15:25 ::分类: ( 财务 , EBS ) ::阅读:(335次) :: 评论 (0)
===========================================================
===========================================================

这次最佳影片可能就是 本杰明.曼哈顿奇事(返老还童,已看), 贫民窟的百万富翁(印度底层人的励志片,已看),朗读者(好像德语爱情片,未看),还有对话尼克松(未看)

个人感觉本杰明.曼哈顿奇事 和朗读者很有可能获奖.贫民窟的百万富翁我不看好

马上发奖了,很有可能我预测依然不准确


moonsoft 发表于:2009.02.23 12:21 ::分类: ( 理性的浪漫 ) ::阅读:(211次) :: 评论 (2)
===========================================================
===========================================================

子模块和总账核对 :
有个报表,应付账款试算表 列出来应付的余额, 没有付款的发票的余额
余额等于 总账 应付账款的科目的余额(总账的应付账款账户没有用该科目,余额就对)
如果发票付款过了,要传送总账,那么形成 AP 分录的抵消,一正一负 , 余额不变

 查看全文
moonsoft 发表于:2009.02.23 12:14 ::分类: ( 财务 ) ::阅读:(383次) :: 评论 (0)
===========================================================
===========================================================

不是, 发票 验证和审批就可以去付款, 与是否传送到总账无关.

 查看全文

moonsoft 发表于:2009.02.23 12:13 ::分类: ( 财务 ) ::阅读:(293次) :: 评论 (0)
===========================================================
===========================================================
Oracle EBS R12 12.0.6 Release update pack (RUP6) now available 查看全文
moonsoft 发表于:2009.02.19 09:46 ::分类: ( EBS ) ::阅读:(374次) :: 评论 (0)
===========================================================
===========================================================
奥运后,一场由美国次贷引起的经济危机几个月内席卷了全球,我们身为ORACLE 外包行业虽然不是站在震荡的第一线,可是今天听到一个同事被裁员的消息的时候,心里不禁冷了一下,听到::狼真的来了. 查看全文
moonsoft 发表于:2009.02.17 23:15 ::分类: ( 理性的浪漫 ) ::阅读:(472次) :: 评论 (1)
===========================================================
===========================================================

每次启动服务都需要
输入目录cd /oraebs12r/d01/oracle/PROD/inst/apps/PROD_oraebsr12/admin/scripts,
怎样可以设置个环境变量来把敲入的命令缩短?


***
我的方法是将 对应的路径,如: /oraebs12r/d01/oracle/PROD/inst/apps/PROD_oraebsr12/admin/scripts

放入到 .bash_profile 的变量中.
****
在/home/applmg下建一个 startapp.sh
里面输入
/oraebs12r/d01/oracle/PROD/inst/apps/PROD_oraebsr12/admin/scripts/adstrtal.sh apps/apps
然后给startapp.sh添加运行权限

chmod +x startapp.sh

 查看全文
moonsoft 发表于:2009.02.16 10:57 ::分类: ( ORACLE DBA ) ::阅读:(144次) :: 评论 (0)
===========================================================
===========================================================

有时候,建了新库会忘记修改一些设置,Form导出tsv数据中文全部是“靠”就是常见的问题。这种乱码的问题跟sqlplus连数据库导致乱码的原理是一样的,都是因为客户端的字符集跟服务器端的字符集不一致所致。

 查看全文

moonsoft 发表于:2009.02.16 10:47 ::分类: ( forms ) ::阅读:(319次) :: 评论 (0)
===========================================================
===========================================================
R12: Posting Error PERF0005: Oracle Error in glpsqs, ORA-20001: An Active Sequence Assignment is Required 查看全文
moonsoft 发表于:2009.02.13 11:14 ::分类: ( 财务 ) ::阅读:(291次) :: 评论 (0)
Blog信息
博客日历
切换风格
文章归档...
最新发表...
最新评论...
最多阅读文章...
博客统计...
网站链接...
新闻聚合