yaluo009-CSDN博客

原创 ssss.iijmio.jp

https://ssss.iijmio.jp/07041399223DN050450324437031319253

2016-12-29 13:39:46 650

翻译 oam Not Send Authorization Responses

OAM 11g Does Not Send Authorization Responses To Downstream Application (Doc ID 1376402.1)Applies to: Oracle Access Manager - Version 11.1.1.5.0 to 11.1.1.5.0 [Release 11g]Information in

2016-12-26 13:19:44 497

转载 jps命令使用

jps(JavaVirtual Machine Process Status Tool)是JDK 1.5提供的一个显示当前所有Java进程pid的命令，简单实用，非常适合在Linux/unix平台上简单察看当前java进程的一些简单情况。jps(Java Virtual Machine Process Status Tool)是JDK 1.5提供的一个显示当前所有java进程pid

2016-12-20 12:31:05 1059

原创 zangma

http://www.sbkk8.cn/wangluo/cangdimima/82193.html

2016-11-25 15:14:43 404

原创 fnd_web_sec

select fnd_web_sec.validate_login('GUEST','') from dual;

2016-10-26 22:35:54 679

原创 ebs blank

R12: Troubleshooting 500 Internal Server Error in Oracle E-Business suite (文档 ID 813523.1)cd $FND_TOP/patch/115/bin ojspCompile.pl --compile --flush

2016-10-26 22:33:12 241

原创 hacmp start-stop

HACMP测试将EBS脚本集成到HACMP脚本后，则进行HA测试。数据库节点脚本：#ls /hascriptappstart.sh appstop.sh dbstart.shdbstop.shappstart.shsu – oraprod –c “/erpdb/PROD/r12/db/tech_st/11.2.0/appsutil/scripts/PROD_erpdb/

2016-10-26 22:30:46 351

原创 oracle privs

系统权限select * from dba_sys_privs;select * from dba_role_privs;select * from dba_tab_privs;ORACLE权限：系统权限: 允许用户执行特定的数据库动作，如创建表、创建索引、连接实例等对象权限: 允许用户操纵一些特定的对象，如读取视图，可更

2016-10-21 10:42:40 531

原创 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 428

原创 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 1416

翻译 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 408

原创 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 2081

原创 ebs log monitor

ebs apache/oacore/form opmn logfileHow To Enable Apache, OC4J and OPMN Logging in Oracle Applications R12 (Doc ID 419839.1)$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf/httpd.conf $ORA_CONFIG_

2016-10-12 13:45:25 362

原创 ebs 双节点

准备步骤Ø Step 1 ：修改tnsnames.ora修改$TNS_ADMIN/tnsnames.ora中SID，使应用可以连接其中一个实例PROD= (SERVICE_NAME=PROD1) (INSTANCE_NAME=PROD1)确认可以正常连接数据库sqlplus apps/apps Ø

2016-10-11 23:11:50 2540

原创 fangzi

http://www.360doc.com/content/10/0908/23/3071980_52247039.shtmlhttp://bbs.51gaifang.com/thread-12226-10-1.html瓷砖小样是看到一篇贴子采购来的，对我来说属扫盲贴，介绍的比较详细，有需要的可以看下http://bbs.tianya.cn/post-766-399038-

2016-09-28 12:07:32 267

原创 japan card

https://s.iijmio.jp/07041399223DN05045032244370313192253基本情報電話番号 07041399223 ICCID DN05045032244370SIMタイプ microSIM 回線状態利用中初期データ量 2000MB データ残量 2000MB ご利用開始日時

2016-09-23 08:44:33 328

原创 japan hotel

http://www.jalan.net/http://www.jalan.net/cn/japan_hotels_ryokan/

2016-09-21 14:53:15 342

原创 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 962

原创 japan eat

https://www.gnavi.co.jp/

2016-09-16 15:14:07 317

原创 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 568

转载 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 272

翻译 Gather Schema Statistics fails with Ora-20001

Gather Schema Statistics fails with Ora-20001-- identify duplicate rowsselect table_name, column_name, count(*)from FND_HISTOGRAM_COLSgroup by table_name, column_namehaving count(*) > 1;

2016-09-07 14:17:05 374

原创 ebs cookies ( oracle.uix )

oracle.uix cookie 是时区valueoracle.uix cookie是持久的 oracle.uix (version 10.1.2 and above)•Set by the OIDDAS, which uses UIX to render its user interface. UIX sets this cookie and it has nothing t

2016-09-07 09:55:23 470

原创 guoxin zhengquan

转账成功后，请登陆国信证券营业厅（https://trade.guosen.com.cn/），完成OTC融资合约确认

2016-09-01 14:00:10 512

原创 sql loop

我们在Oracle存储过程中需要遍历一张表，应该怎样做。我想大多少的人第一个念头就是Cursor。　　　　比如：　　　　create or replace procedure StudyCursor(　　resulst out integer　　) is　　v_tablename varchar(30);　　v_tabletype varchar(11);

2016-08-30 10:55:34 573

原创 SQL 查看职责,哪个用户有

--查看职责,哪个用户有 SELECT FU.USER_NAME, FRV.RESPONSIBILITY_NAME, --职责名称 FURG.CREATION_DATE, FURG.CREATED_BY, FURG.START_DATE, --添加职责开始时间 FURG.END_DATE, --职责到期时间

2016-08-29 22:41:38 723

翻译 The 10.1.3.5 patchset installer error

1>error The 10.1.3.5 patchset installer fails to start OPMN.Solution:Back up the file opmnctl at 1013_ORACLE_HOME/opmn/binCopy the file $INST_TOP/ora/10.1.3/opmn/bin/opmnctl to 10.1.3

2016-08-04 14:17:40 649

原创 linux 5 clone to linux 6 libjava.so error

error occurred during initialization of vmunable to load native library: /opt/oracle/mcs/itb/apps/tech_st/10.1.2/jdk/jre/lib/i386/libjava.so: symbol verifyformat ,version sunwprivate_1.1 not

2016-08-02 17:43:18 521

原创 home live buy

1.aux 12446url: https://auxdq.world.tmall.com/shop/view_shop.htm?user_number_id=1035757927&ali_trackid=2%3Amm_54202973_15026068_58300757%3A1469412012_253_12721599761.0P 2*1949 AUX/奥克斯 KFR-2

2016-07-25 10:19:23 445

原创 11g 12c nls parameter

11gselect * from nls_database_parameters;12cshow parameter nls

2016-07-21 09:13:18 394

原创 ORACLE in-memory parameter

**inmemoryselect open_mode from v$database;select * from v$option where PARAMETER like '%In-Memory%';select name,open_mode from v$pdbs; ORACLE 12C IN-MEMORY初体验千呼万唤ORACLE in-memor

2016-07-21 08:38:52 467

原创 insert into FND_PROFILE_OPTION_VALUES

If so execute below insert statement after taking the back up of FND_PROFILE_OPTION_VALUES table, then GL:Data access set profile will be assigned to all responsibilities for which GL:Set Of books

2016-07-19 13:54:52 1113

翻译 About "Applications Start Page" profile option (Doc ID 729375.1)

Applies to: Oracle Applications Framework - Version 11.5.10.2 to 11.5.10.2.6 [Release 11.5.10]Information in this document applies to any platform.Oracle Applications 11.5.10.2 and above.

2016-07-19 13:29:41 522

原创 ebs Start Page

How To Reset Preferences 'Start Page'? (Doc ID 420035.1)Applies to: Oracle Applications Framework - Version 11.5.10.2 to 11.5.10.2.6 [Release 11.5.10]Information in this document applies

2016-07-15 16:01:08 502

原创 ebs 12.1 oa framework

12.1.1: Oracle Application Framework (OAF) Release Notes, Release 12.1.1 ( Doc ID 565870.1 )12.1.4: Oracle Application Framework Release Notes for Release 12.1 RUP Patchsets ( Doc ID 1931412.1

2016-07-15 14:27:37 289

原创零基础快速语

http://zhidao.baidu.com/link?url=TvKrJlR6TIPANR2BeZrptPQ04hJ8FZNT6DbjE-La2yoRXPNIGmrhz1i0o3wZNruGRoAyAEERm4I8Bwv6U3EzZYyA1UdV4zQqMy41tLxlSyK

2016-07-14 14:02:13 408

原创 Database Upgrade to 12c ebs,JDeveloper Connections Fail With Error "ORA-28040

JDBC Version 10.2.0.4 Produces ORA-28040 Connecting To Oracle 12c (12.1.0.2) Database (Doc ID 2023160.1)After a Database Upgrade to 12c for E-Business Suite, JDeveloper Connections Fail With Err

2016-07-14 13:48:34 735

翻译 'FND: Application Module Pool Enabled'

1>Health Check Alert: Set the profile 'FND: Application Module Pool Enabled' to Yes (Doc ID 957532.1)DescriptionChecks if the profile 'FND: Application Module Pool Enabled' is set to No at Sit

2016-07-12 13:30:13 522

翻译 Remove The Global 'Preferences'

How to Remove The Global 'Preferences' button from OA Framework Page (Doc ID 979804.1)Applies to: Oracle Applications Framework - Version 11.5.10.0 to 12.1.1 [Release 11.5.10 to 12.1]Infor

2016-07-12 12:53:21 494

原创 ebs OAF Pages edit / remove / hide

1."Navigator" And "Favorites"Customer Form Issue: How to Hide "Navigator" And "Favorites" Menus in Customers Page at Responsibility Level? (Doc ID 1602812.1)Profile : FND: Disable Navigator an

2016-07-11 15:53:28 392