tag:blogger.com,1999:blog-70771466227054182842012-02-16T11:41:10.359-08:00Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.comBlogger321100tag:blogger.com,1999:blog-7077146622705418284.post-2779337331236210002011-05-08T23:14:00.000-07:002011-05-08T23:17:37.928-07:00

Hi Readers,Please find the link to learn more technologies of Oracle. You can find many demos on this link which will helpful to understand many things and clear your doubtshttp://apex.oracle.com/pls/apex/f?p=44785:1:4375925786888155RegardsGuru

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-17385220262791218672011-03-18T10:11:00.000-07:002011-03-18T10:13:28.182-07:00

Hi,Just sharing you the metalink ID of Oracle Database scripts.Database Scripts Library Index [ID 131704.1]Regards,Guru

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-58725203934863823662011-03-10T00:40:00.001-08:002011-03-10T00:45:57.724-08:00

Oc4jadmin default password could be 'secret' or 'oafm - Application server 10g R3 (10.1.3.5.0)

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-71804955570307153002011-03-09T23:12:00.000-08:002011-03-09T23:26:47.271-08:00

Hi Readers,I faced below two errors reported by end users many times but I did not face the same error even a single time. I crosschecked with my other team members and they also did not face the same . Even in Application log files I did not get much information. Most of the times we communicated to end users that the problem is with there laptop/desktop or some java issue etc. etc. because they

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-40182346785759664212011-03-01T23:24:00.000-08:002011-05-03T23:16:20.990-07:00

Hi Readers,7-8 months back I implemented R12.1.1 on Sun sparc-10 (64-bit) . End users start complaning that after giving username/password on login page and press login gives "unexpected error - please contact to your system administrator" . More interesting thing is that this issue comes intermittently .When end user tried again or refrehes the Internet explore and provide user credentials and

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com2tag:blogger.com,1999:blog-7077146622705418284.post-90108027391777563962011-03-01T22:46:00.000-08:002011-03-01T22:52:57.023-08:00

Hi All,Here is the requirement to configure statspack.install statspackto take performance snapshots every 15 minutes on the 15 minutes except during our batch window of midnight until 7am, during which time we would like performance snapshots taken every 2 hours at the top of the hour (midnight, 2, 4 and 6).To acheive the requirement we need to create function in which we will pass the data and

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-71252614522510029502011-01-27T04:28:00.000-08:002011-01-27T04:44:00.066-08:00

Hi,I was facing couple of issues while deleting the Discoverere 10g workbook from front end.I successfully deleted the same from backend.Please find the scripts to delete particular workbook (select sql - to retrive and confim the workbook name ) and delete sql (pass the parameters as per the outcome/requirement of select statement.eg:-1)select * from eul5_documents where doc_id=121412 and

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com16tag:blogger.com,1999:blog-7077146622705418284.post-40885032868530120642011-01-27T04:16:00.000-08:002011-01-27T04:20:18.835-08:00

While viewing log and ouput files I am getting below error in log/output window.Error connecting to database (**** DB NAME****): ORA--1I did lot of troubleshooting to find the cause of this error. Finally came across that APPLSYSPUP is in EXPIRED (GRACE) status . you can check this under dba_users cloumn account_status.I changed the status to open usingAlter user APPLSYSPUB identified by PUB;This

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-35153644533213312042010-02-10T21:56:00.000-08:002010-10-13T04:35:03.500-07:00

Hi Readers,After a long break I am updating my blog.Its very difficult to find out patch/RUP details. Currently I am working on implementation project so thought to share few things.After installation R12.1.1 you need to apply RUP2 patch to upgrade release 12.1.1 to 12.1.2Here is the patch no's .First apply pre-requisite then apply RUP2.a)Pre-requisite - 8502056 - R12.AD.B.DELTA.2 - will take 1

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com2tag:blogger.com,1999:blog-7077146622705418284.post-11426113065691802052008-05-11T03:41:00.000-07:002008-05-11T03:50:11.063-07:00

Hi Folks,As you very much aware that you can change SYSADMIN password using FNDCPASS utilityFNDCPASS apps/appspwd 0 Y system/manager USER SYSADMIN sysadminpwdHere I am giving another way to change the SYSADMIN password and Application User Login passwords using fnd_user_pkg from backend. Here is the proceduresql> declare var_l boolean; begin var_l=fnd_user_pkg.change_password(

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-29852182015552183632008-05-05T07:11:00.000-07:002008-05-05T07:22:08.331-07:00

Hi Everyone,Recently I faced one problem in R12 instance. I was not able to see the login screen after application URL. I got blank page on AppsLocalLogin.jsp or sometimes I got a message unable to autheticate the session instead of giving me username and password screen. Backend side everything is working fine. I did lot of head strikes and searched lot of docs but did not found any. I also

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-17633205691319217602008-03-28T03:29:00.000-07:002008-03-28T04:46:09.659-07:00

Hi Friends,I install 12.0.0 in HPUX-PA-RISC(64-bit). I was doing cloning without following cloning doc and prerequisites(406982.1) and failed to do so.AS per cloning doc I planned to upgrade (RUP2)12.0.2 but finally I decided directly upgrade to 12.0.4 .Refer note (402308.1) and metalink note(465776.1)Below are the steps I follow in upgrade.1> Take cold backup of the application as well as

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-36165620354825872802008-03-13T22:12:00.000-07:002008-03-15T05:09:05.861-07:00

Hi Friends,I was getting one problem after creating the custome top,generating custom forms and custom reports.Everything I have checked like Menus,functions,submenus,resgister custom top in system Adminstrator responsibility.But still I am getting some error while clcking the menu or submenu in custom responsibility.Error message is "Function is not available for this responsibility.Contact your

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com6tag:blogger.com,1999:blog-7077146622705418284.post-62178533161268418562008-03-13T22:04:00.000-07:002008-03-15T05:08:21.760-07:00

Hi Readers,Following are the common steps to create custom Top.Step 1> Create the directory structure.$ cd $APPL_TOP$ mkdir xxxx$ cd xxxx$ mkdir 12.0.0$ cd 12.0.0$ mkdir admin$ mkdir bin$ mkdir froms$ mkdir patch$ mkdir reports$ cd admin$ mkdir sql$ cd forms$ mkdir US (for custom forms)$ cd patch$ mkdir 115$ cd 115$ mkdir import (for ldt files)$ cd ..$ cd reports$ mkdir US (for your custom

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com2tag:blogger.com,1999:blog-7077146622705418284.post-61349264049056683672008-03-13T04:35:00.000-07:002008-03-13T04:40:05.812-07:00

Hi friends,You can use below syntax to compile a form in R12.$>frmcmp_batch FORM_name.fmb userid=APPS/APPS output_file=/d02/oracle/VIS12/apps/apps_st/appl/XXXXX/12.0.0/forms/US/FORM_name.fmx module_type=form compile_all=specialOR you can refer my other articlehttp://oracleapplicationguru.blogspot.com/2008/02/frm-91500-unable-to-startcomplete-build.htmlRegards--Guru

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-16576607671449906562008-03-13T01:37:00.000-07:002008-03-13T01:40:38.770-07:00

What is RDA?Remote Diagnostic Agent (RDA) is a set of command-line diagnostic scripts that are executed by an engine written in the Perl programming language.RDA gather detailed information about an Oracle environment. Output of this RDA scripts is useful to see the whole system configuration.Why use RDA?Oracle strongly encourages the use of Remote Diagnostic Agent (RDA) diagnostics

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-55908104886387666582008-03-09T04:14:00.001-07:002008-03-09T05:05:55.142-07:00

Hi Readers,I just faced one error after cloning of 4node architecture.Node A-DB tier, Node B-Conc/admin,Node C-Secondary form,Node D-PrimaryI have done everything correctly what I used to do for cloning. But my application is not opening i.e URL ....NodeD:8000 and getting the below error on Primary NodeD after running adstrtal.sh ,other components are running fine except Apache.adapcctl.sh

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com1tag:blogger.com,1999:blog-7077146622705418284.post-77311614249619541052008-03-07T10:30:00.000-08:002008-03-07T10:45:12.666-08:00

Just to enhance the knowledge of APPS DBAFINANCE1.General Ledger2.Accounts Payable (A/P)3.Accounts Receivable (A/R)4.Fixed Assets5.Cost Accounting6.Cash Management7.Budgeting8.Financial Reporting9.Project AccountingQUALITY MANAGEMENT1.Customer return file2.Damaged material3.Inspection required4.Automated inspection criteria5.Inspection disposition with audit trail6.Quantity rejected7.Reject

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-80780065713555808442008-03-06T02:35:00.000-08:002008-03-06T02:39:28.130-08:00

When you open Oracle Application,your first step would be to open the URL hostname.domainname:port . You will get the first screen .When this url opens below files will come into picture.1>apptitle.html2>applist.html3>appdet.html4>appsmed3.gifLocation of these files are:cd $COMMON_TOP/portal/(context_name)You see the Oracle Application logo on the left hand side on this screen. How to change this

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com1tag:blogger.com,1999:blog-7077146622705418284.post-42715285159497653232008-03-03T07:21:00.000-08:002008-03-03T07:27:58.133-08:00

Hi folks,Some times you will not be able to set the display using below commands in HPUXexport DISPLAY=ipaddress:0.0 'or'export DISPLAY=ipaddress 'or'export DISPLAY=ipaddress:0 'or'export DISPLAY=hostname:0.0andxhost +xhost +hostname etc.Simply run below command in a single line to run xhost + successfullynohup /usr/bin/X11/Xvfb :0 -screen 2 1024x800x8 -pn -fp /usr/lib/X11/fonts/misc -sp /etc/X11

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-74863563393184661922008-03-03T07:05:00.000-08:002008-03-03T07:19:26.558-08:00

Multi Node to Single node in 11iApps-11.5.10.2 DB-9.2.0.6Architecture- NODE A- Apps(Conc/Rep/admin),DB NODE B- Apps(forms/web)Purpose: Convert NODE A + NODE B = NODE A (multi node to single node)Few easy steps to achieve this using "appsTier merge" and "appltop merge"Prerequisties- Application tier patches- 4038964 and 4175764 AND AD Minipack AD.I.2 or more(would

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com1tag:blogger.com,1999:blog-7077146622705418284.post-3447567987530704962008-02-29T21:04:00.000-08:002008-02-29T21:08:12.856-08:00

Finally here is the solution to run 'frmcmp' in R12 . (FRM-91500)Step1> From client machine you need to run reflection software or any XServer Display on your machine . This is mandatory to run 'frmcmp' successfully in R12.Step2>On the client Side Login to server with user 'applmgr'' on Putty session and do the following$ export DISPLAY='IP adress of your client':0.0$frmcmpThanks--Guru

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-11054389423553464462008-01-28T00:04:00.000-08:002008-01-28T00:10:16.015-08:00

Login to OAM (See metalink note 216816.1)You can write your own scripts and can use in OAM.Navigate to Site Map -> Monitoring -> SQL Extensions1. Create directory in the $APPL_TOP/admin /custom/sql2. Place your script in this directory.3. Bounce Apache to see the scripts in OAMThanks--Guru

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-80417391954142830452008-01-23T18:03:00.001-08:002008-01-23T18:08:01.234-08:00

Click on the below link for PPT of Oracle Database Architecture.http://docs.google.com/Presentation?id=d69347t_3dr3rxpdk

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com3tag:blogger.com,1999:blog-7077146622705418284.post-19315727297648314402008-01-23T17:41:00.000-08:002008-01-23T17:48:57.215-08:00

Use below link to know about the Installation of 11.5.10.2 on Linuxhttp://docs.google.com/Doc?id=d69347t_1fv4gj7gf

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-20387502721154532592008-01-23T17:14:00.000-08:002008-01-23T17:23:14.656-08:00

Hey Guys, Recently I faced one issue .One of the user is not able to do export from front end Application. Let me explain ,Suppose you query to find the running requests. A request window will appear which shows currently running request. Now you want to export all the request with all the info of this request window to a text file instead of taking print screen.You will use the navigation File--

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-50221942767723308882008-01-23T16:31:00.000-08:002008-01-23T17:08:44.448-08:00

(Interview Ques: What happens internally when you run adpreclone and adcfgclone)I am covering the Internal Cloning Process which you will not get eaily on the net. Generally you find the steps for cloning like run adpreclone on apps and db tier then copy the file sytem to Target then run adcfgclone on apps tier and db Tier.What happens when you run adpreclone and adcfgclone. The below steps give

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com10tag:blogger.com,1999:blog-7077146622705418284.post-8559675039561308292008-01-23T16:22:00.000-08:002008-01-23T17:05:42.704-08:00

column traceid format a8column tracename format a80column user_concurrent_program_name format a40column execname format a15column enable_trace format a12set lines 80set pages 22set head offselect 'Request id: 'request_id , 'Trace id: 'oracle_Process_id, 'Trace Flag: 'req.enable_trace,'Trace Name: 'dest.value'/'lower(dbnm.value)'_ora_'oracle_process_id'.trc','Prog. Name: '

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com1tag:blogger.com,1999:blog-7077146622705418284.post-67147329977911641102008-01-22T22:35:00.000-08:002008-01-22T22:37:01.778-08:00

Create a tablespace which will hold the STATSPACK objects:SQL> create tablespace SPTBS datafile '/u01/oradata/pavc2data/sptbs01.dbf' size 500M autoextend offCreate the STATSPACK user PERFSTAT:SQL> create user perfstat identified by perfstat 2 default tablespace sptbs;User created.Run $ORACLE_HOME/rdbms/admin/spcheck.sql....spcpkg.sql from SYS user.This script will prompt from PERFSTAT user

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-75112686714599955462008-01-22T22:20:00.000-08:002008-01-22T22:21:45.458-08:00

Oracle Database, the relational database management system from Oracle Corporation, is arguably the most powerfull and feature rich database on the market. Larry Ellison founded Software Development Laboratories in 1977. In 1979 SDL changed its company name to Relational Software, Inc. (RSI) and introduced its product Oracle V2 as an early commercially-available relational database system. The

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-38894278115325280622008-01-22T21:59:00.000-08:002008-01-23T17:07:39.538-08:00

click the image for proper view.The technology stack for R11i 11.5.7 contains three separate ORACLE_HOMEs that are used to provide the functionality within the release.

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com0tag:blogger.com,1999:blog-7077146622705418284.post-46715152064659871152008-01-22T18:07:00.000-08:002008-01-23T17:06:54.183-08:00

Where oracle-->servernameapps.guru-->domain name8000-->port numberAOL/J Diagnostic Testshttp://oracle.apps.guru:8000/OA_HTML/jsp/fnd/aoljtest.jspAPPS_WEB_AGENThttp://oracle.apps.guru:8000/pls/vis/fnd_web.pingAPPS_FRAMEWORK_AGENThttp://oracle.apps.guru:8000/ICX_FORMS_LAUNCHERhttp://oracle.apps.guru:8000/dev60cgi/f60cgi(Interview ques: How to bypass the home page)ICX_REPORT_LAUNCHERhttp://

Gurtejhttp://www.blogger.com/profile/00499415385726392286noreply@blogger.com2