===========================================================
===========================================================
搜狗输入法,流氓
卸载掉了搜狗,然后被它一直占用的热键SHIFT+CTRL+1 不会释放出来,然后我找资料到注册表删除的键值才可以.
查看全文
===========================================================
===========================================================
spfile 排错及一点资料总结
有时候我们会不小心修改了spfile的某些参些参数导致数据库不能启动，这时候改怎么让数据库重新跑起来呢，oracle 针对spfile还是提供了几种方法来修复的。 Oracle参数文件有三种： spfile： spfile
moonsoft
发表于:2009.06.02 20:59
::分类:
( ORACLE DBA
)
::阅读:(95次)
:: 评论
(0)
===========================================================
===========================================================
修改ORACLE 系统参数导致的 ORA-00064 ,ora-32001
本来想修改系统的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)
===========================================================
===========================================================
固定资产成本调整的方法
新增成本会有一个月标准折旧,下面举了个例子,欢迎财务顾问提出看法
查看全文
===========================================================
===========================================================
一次极其丢脸的CRP3培训
上周我进行了非常重要的一次面向最终用户的培训,可是由于系统设置的不规范操作和没有专业DBA的陪同,可以说是出现了实施生涯最丢脸的一次培训,当系统运行一些标准请求出错时,我恨不得找个地缝钻进去!太丢脸了......
同时作为项目组成员难逃其咎,可是在实施过程中乙方公司又不听自己的任何建议,心里真是感觉冤枉.在没有进行任何压力测试的情况下进行CRP3培训真是冒险
查看全文
===========================================================
===========================================================
博客访问量超过50W
庆祝一下,最近,一些很伤心的事情,一些麻烦的事发生过,同时也很少再去做技术层面的东西,所以不知不觉博客文章也少了些,以后要加强博客和自己知识的总结.
===========================================================
===========================================================
ORA-12537
解决办法之一是： /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)
===========================================================
===========================================================
it is the third time I apply RUP6 PATCH get fellow error, it is still running....
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.
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.
===========================================================
===========================================================
RUP6 第二次升级失败
前天晚上开始就牙龈肿痛， 我也没有吃什么上火的东西，搞不明白，只是前几天听到别人说牙龈肿痛，我还想自己好久没有过了，谁知道马上就报应到我头上了，人不能太沾沾自喜。
晚上10:10就睡觉了，难得一次这么乖早早睡觉，可是到凌晨就牙痛醒了，而且口渴，索性就起来看看6728000补丁打得怎么样了，得到如下错误：
查看全文
===========================================================
===========================================================
FA 快速增加的时候出现错误APP-OFA-47290
FA 快速增加的时候出现错误APP-OFA-47290
手动增加资产就没有这个错误，奇怪
手动增加资产就没有这个错误，奇怪
FAXASSET APP-OFA-47290: Units Assigned Must Not Exceed Units
查看全文
===========================================================
===========================================================
apply 12.0.6 patch failure log
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.
--------
===========================================================
===========================================================
弹性域设置和LOOKUP 设置的时候不允许UPDATE ,是怎么回事
1.CATEGORY FIEXFIELD 不允许动态插入,
2.AP LOOKUP CODE INVOICE TYPE 也不允许DISABLE 有些发票类型
原因
http://www.itpub.net/viewthread.php?tid=1130192&pid=12968995&page=1&extra=#pid12968995
查看全文
===========================================================
===========================================================
关注一下81届OSCAR
这次最佳影片可能就是 本杰明.曼哈顿奇事(返老还童,已看), 贫民窟的百万富翁(印度底层人的励志片,已看),朗读者(好像德语爱情片,未看),还有对话尼克松(未看)
个人感觉本杰明.曼哈顿奇事 和朗读者很有可能获奖.贫民窟的百万富翁我不看好
马上发奖了,很有可能我预测依然不准确
===========================================================
===========================================================
AP&GL 对账
子模块和总账核对 :
有个报表，应付账款试算表 列出来应付的余额， 没有付款的发票的余额
余额等于 总账 应付账款的科目的余额（总账的应付账款账户没有用该科目，余额就对）
如果发票付款过了,要传送总账,那么形成 AP 分录的抵消,一正一负 , 余额不变
===========================================================
===========================================================
一定是过账之后才可以付款吗?
不是, 发票 验证和审批就可以去付款, 与是否传送到总账无关.
查看全文
===========================================================
===========================================================
Oracle EBS R12 12.0.6 Release update pack (RUP6) now available
Oracle EBS R12 12.0.6 Release update pack (RUP6) now available 查看全文
===========================================================
===========================================================
经济危机下学习R12的必要性
奥运后,一场由美国次贷引起的经济危机几个月内席卷了全球,我们身为ORACLE 外包行业虽然不是站在震荡的第一线,可是今天听到一个同事被裁员的消息的时候,心里不禁冷了一下,听到::狼真的来了. 查看全文
===========================================================
===========================================================
每次启动服务都需要输入复杂路径 怎样可以缩短?
每次启动服务都需要
输入目录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 导出乱码的问题
有时候，建了新库会忘记修改一些设置，Form导出tsv数据中文全部是“靠”就是常见的问题。这种乱码的问题跟sqlplus连数据库导致乱码的原理是一样的，都是因为客户端的字符集跟服务器端的字符集不一致所致。
查看全文
===========================================================
===========================================================
R12过账错误
R12: Posting Error PERF0005: Oracle Error in glpsqs, ORA-20001: An Active Sequence Assignment is Required 查看全文
