tag:blogger.com,1999:blog-56993286234398664342012-01-12T04:17:46.168-08:00Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.comBlogger57125tag:blogger.com,1999:blog-5699328623439866434.post-55701345010253762732011-08-31T09:00:00.000-07:002011-08-31T09:03:08.981-07:002011-08-31T09:03:08.981-07:00

1. Single client access name (SCAN) is the virtual hostname to provide for all clients connecting to the cluster (as opposed to the vip hostnames in 10g and 11gR1). 2. SCAN is a domain name registered to at least one and up to three IP addresses, either in the domain name service (DNS) or the Grid Naming Service (GNS). 3. By default, the name used as the SCAN is also the name of the cluster and

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com0tag:blogger.com,1999:blog-5699328623439866434.post-14714725416833891252011-01-31T10:06:00.000-08:002011-01-31T10:41:14.544-08:002011-01-31T10:41:14.544-08:00

1. Login as orale user and Stop the Database2. Stop ASM instance3. Stop Node App4. Login as root and stop Oracle Cluster ./crsctl stop crs========================================== Startting Oracle Cluster==========================================- Login as root user and start the cluster, it will start the rest. of services ./crsctl start crs- Check the status ./crsctl check crs ./

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com0tag:blogger.com,1999:blog-5699328623439866434.post-50862460814926723732010-11-30T03:57:00.000-08:002010-11-30T04:14:03.380-08:002010-11-30T04:14:03.380-08:00

These steps have been followed on RHEL 5.3 after applying Database Patch Set 11.1.0.7. --> Download Oneoff patch 9654987Issue : there was lower version of Opatch then we have applied latest available patch of Opatch utility.[oracle@testdbserver 9654987]$ /oraapp/TESTDB/product/11.1.0/db_1/OPatch/opatch applyInvoking OPatch 11.2.0.1.3Oracle Interim Patch Installer version 11.2.0.1.3Copyright (c)

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com0tag:blogger.com,1999:blog-5699328623439866434.post-76070474754171011812010-08-31T00:23:00.000-07:002010-08-31T00:24:17.361-07:002010-08-31T00:24:17.361-07:00

OCM is the final stage of mastering ORACLE in specific version .There are some restrictions for OCM -> You must be Oracle certified professional. -> You must took 2 advance courses prior to OCM. -> Recommended but not optional 3 to 4 years of real time experience.Heres the list of advance courses.Each course duration is 5 days and course fee is US$ 3000.After passing OCM Oracle Corporation host

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com0tag:blogger.com,1999:blog-5699328623439866434.post-86738592059899509822010-05-06T04:19:00.000-07:002010-05-06T04:25:29.773-07:002010-05-06T04:25:29.773-07:00

Introduction The Transparent Data Encryption (TDE) feature introduced in Oracle 10g Database Release 2 allows sensitive data to be encrypted within the datafiles to prevent access to it from the operating system. Oracle Database 11g encrypts data using a master key, which is stored in a secure location called a wallet, which is a file on the database server. Table keys are placed in the

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com0tag:blogger.com,1999:blog-5699328623439866434.post-60167043875321518172010-03-31T11:17:00.000-07:002010-03-31T11:26:29.410-07:002010-03-31T11:26:29.410-07:00

-> Oracle RAC 1, Active-Passive configuration of Oracle RAC-> We can configure OCR and Voting Disk On ASM Instance-> Introduce the enhanched features of Oracle XML DB-- Rest Of The New Features Coming Soon -----

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com0tag:blogger.com,1999:blog-5699328623439866434.post-12376450583614731622010-01-01T01:24:00.000-08:002010-01-01T01:26:30.854-08:002010-01-01T01:26:30.854-08:00

===================================Wish Happy New Year To ALL Readers===================================Check the following :SQL> Select OWNER,OBJECT_NAME,OBJECT_TYPE,STATUS from dba_objects where OBJECT_NAME='WF_DEFERRED';RE-CREATE WORKFLOW QUEUE======================== => Bring down the Workflow Services of DMYFAI instance. => Add the Subscribers to The WF_DEFERRED queue =>Logon to

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com2tag:blogger.com,1999:blog-5699328623439866434.post-7361346073438673112009-11-30T04:34:00.000-08:002009-11-30T04:40:07.764-08:002009-11-30T04:40:07.764-08:00

-> Take the backup of existing SPFILE which is located at shared location. In my case it's in (spfileTEST.ora) under /test/oradata/data01 -> Create the pfile from spfile. -> Add the required parameter in pfile for both instancs all the RAC nodes *.parameter_name -> Create the spfile(spfiletest.ora) in temporary location from pfile. -> Bring down the services of TEST instance. -> Move the

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com3tag:blogger.com,1999:blog-5699328623439866434.post-36420959371412583292009-10-30T06:59:00.000-07:002009-10-30T07:02:11.234-07:002009-10-30T07:02:11.234-07:00

There are 4 main logos screens in the signon process of Rel 11i Initial Screen (with Jinitiator Download notice) Splash Screen FNDSCSGN (Applictaions Signon Screen) ICXINDEX.htm (Self Service Signon Screen) Changing the images that appear when signing on to Oracle Applications R11i is a customization of that form. Applications sign-on form FNDSCSGN contains a

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com3tag:blogger.com,1999:blog-5699328623439866434.post-11997852304946755082009-09-07T19:52:00.000-07:002009-09-08T01:11:19.259-07:002009-09-08T01:11:19.259-07:00

OID Database Schema Owner The Oracle Internet Directory runs on an Oracle database and creates two database users: ODS and ODSCOMMON. ODS is the schema owner that contains all of the database objects (tables, views, objects, etc.) used for OID functionality and directory storage. When the OID needs to login to the database, it uses the ODS database account which has a default password of ODS.

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com1tag:blogger.com,1999:blog-5699328623439866434.post-32572659080330156012009-09-04T05:15:00.000-07:002009-09-04T05:16:38.892-07:002009-09-04T05:16:38.892-07:00

Q1. To check the database version?A. Logon to SQLPLUS as sysdba : SQL> SELECT * FROM v$version; BANNER----------------------------------------------------------------Oracle9i Enterprise Edition Release 9.2.0.7.0 - ProductionPL/SQL Release 9.2.0.7.0 - ProductionCORE 9.2.0.7.0 ProductionTNS for Linux: Version 9.2.0.7.0 - ProductionNLSRTL Version 9.2.0.7.0 - ProductionQ2. Check the

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com1tag:blogger.com,1999:blog-5699328623439866434.post-47327837078277545622009-08-30T01:17:00.000-07:002009-08-30T01:22:31.102-07:002009-08-30T01:22:31.102-07:00

Oracle Applications Release12 by default configures Forms 10g stack in servlet mode, as this is the preferred and recommended deployment model for forms on the web.In this mode a java servlet called the Forms Listener Servlet manages the communication between the Forms Java Client and the OracleAS Forms Services.The Forms Listener Servlet communicates through the HTTP server port and does not

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com6tag:blogger.com,1999:blog-5699328623439866434.post-43880070534419368542009-07-23T17:48:00.000-07:002009-07-23T18:05:18.451-07:002009-07-23T18:05:18.451-07:00

1. On server where the concurrent manager resides, setup the printer at the OS level. As the applmgr, verify that the OS print queue is working by submitting a print job, from the OS command line to the target printer, with a simple ASCII text file. Check the OS vendor manual for the command and syntax required or printing from a command line. i.e lpstat -p2. If Pasta is not

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com1tag:blogger.com,1999:blog-5699328623439866434.post-68564795470978466682009-07-02T10:37:00.000-07:002009-07-02T11:12:23.164-07:002009-07-02T11:12:23.164-07:00

-> Printer should be setup at the operating system level .Use lpstat –a commandand check if the printer is configured as OS level.To check if printer is printing at OS level use the following command: Lp -d -> File name can be any text file (ex any .req file $APPLCSF/$APPLLOG directory)-> Network team and firewall team may need to be involved if the printer is not accessible from OS

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com3tag:blogger.com,1999:blog-5699328623439866434.post-91728798050532202742009-06-24T06:11:00.000-07:002009-06-25T09:33:19.677-07:002009-06-25T09:33:19.677-07:00

1. Take the backup of adapcctl.sh file located in $COMMON_TOP/admin/SID_HOSTNAME2. Make following changes in adapcctl.sh for automatically deleting _pages whenever we shutdown the apache.3. Implement this before exit_code if [[ "$control_code" = "stop" ]] ; then DIR=`grep _pages $APACHE_TOP/Jserv/etc/zone.properties|grep -v "^#"|awk -F"="'{print $5}'` if [[ -d $DIR ]];

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com0tag:blogger.com,1999:blog-5699328623439866434.post-22090929677728717282009-06-16T06:15:00.000-07:002009-06-16T06:18:51.136-07:002009-06-16T06:18:51.136-07:00

1. As the Applications Unix user, login to middleTier. 2. Take Cold backup of prod instance including Applications file system 3. Backup the Context file.Use the AutoConfig editor to change the context value for the guest password AutoConfig variable name is "s_guest_pass" 4. Run AutoConfig 5. Verify the new guest password as follows: select fnd_web_sec.validate_login('

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com0tag:blogger.com,1999:blog-5699328623439866434.post-39623212525486421372009-05-30T01:48:00.000-07:002009-05-30T01:53:22.723-07:002009-05-30T01:53:22.723-07:00

Patch installation instructions for applying discrete or OPM patches:1. Unzip the patch to temporary directory.2. cd 3. There will be a patch application driver .drv4) Please apply the patch using the patching tool "indpatch"(this is utlity is provided by the patch application tool provided through patch 6059025)Apply the patches in the following way:For Discrete Patches: ----------------------

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com0tag:blogger.com,1999:blog-5699328623439866434.post-32656981248790787922009-04-24T02:18:00.000-07:002009-04-24T02:22:58.466-07:002009-04-24T02:22:58.466-07:00

After installing the Rapid Clone and AutoConfig patches, you are ready to clone an instance. There are tenbasic steps involved:1. Run system configuration on the Application tier: $ $COMMON_TOP/admin/scripts//adautocfg.sh Use the APPS password when prompted.2. Run system configuration on the database tier: $ $ORACLE_HOME/appsutil//scripts/adautocfg.sh Use the APPS password when prompted

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com1tag:blogger.com,1999:blog-5699328623439866434.post-8191481051010173932009-03-31T02:29:00.000-07:002009-03-31T03:06:55.733-07:002009-03-31T03:06:55.733-07:00

Portal 3.0.9 is no longer supported by Oracle but for existing client they are supporting and suggesting to upgrade by latest version. To collect information about portal and other required to help Metalink Support to take rapid action. Do the following steps.1) Download the script from here (http://www.oracle.com/technology/products/ias/portal/files/pda30.zip) 2) FTP the pda30.zip file to the

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com0tag:blogger.com,1999:blog-5699328623439866434.post-23570183014437797502009-01-31T01:41:00.000-08:002009-01-31T01:51:36.535-08:002009-01-31T01:51:36.535-08:00

- What is dedicated and shared server?- Have you installed Oracle on Linux?- What is kernel parameter ,SHMMAX - What is ipcs?Temporary Segment- What is sorting operation?Performance Tunning - Explain Plan- Execution Plan- Analyze - Cursor sharing- TKPROF- Hard parse and Soft parse- What is CBO?- What is RBO?- Fire one sql query which perform full table scan , how can you escape the full table

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com0tag:blogger.com,1999:blog-5699328623439866434.post-67591201726185482502008-12-31T08:58:00.000-08:002008-12-31T09:26:34.859-08:002008-12-31T09:26:34.859-08:00

Interview Questions Usually asked by interviewer to APPSDBA ..... Oracle Application Server Interview Question• Oracle Enterprise Manager.• Oracle OC4J clustering file opmn.xml.• SOA Suite High Availability.• Active/Active and Active/Passive Installation steps not concept and Configuration.• How can you do OID synchronization with Database? Web Cache • Invalidation • Cache • What

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com0tag:blogger.com,1999:blog-5699328623439866434.post-23513644309164998212008-11-30T01:12:00.000-08:002008-12-01T20:37:39.680-08:002008-12-01T20:37:39.680-08:00

In this post there is two Nodes RAC implemented as below. Nodes oradb1.oracle.com oradb2.oracle.comInstances racdb1 racdb2Database prod Manually Control Oracle Clusterware StackStop the Oracle Clusterware stack by using this command.# crsctl stop crsStart the Oracle Clusterware stack by using this command.# crsctl start crs This Command to disable oracle clusterware from being started in a

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com3tag:blogger.com,1999:blog-5699328623439866434.post-9589395927876324182008-09-29T10:51:00.000-07:002008-09-29T10:59:42.829-07:002008-09-29T10:59:42.829-07:00

Recently I have cleared RAC administration exam which leads to Oracle Certified Expert (OCE).I have hands on experience of RAC, referred oracle student guides, the documentation and oracle press books which helped a lot to clear exam easily. Exam is 1z0-048 Oracle Database 10gR2: RAC for Administrators. Certification is Oracle Database 10g: Real Application Clusters Administrator Certified

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com2tag:blogger.com,1999:blog-5699328623439866434.post-64864654114628128892008-08-30T01:08:00.000-07:002008-08-30T01:10:52.328-07:002008-08-30T01:10:52.328-07:00

1) It was originally known as Oracle Parallel Server (OPS) and introduced in Oracle 6.0.35 (subsequently known as Oracle 6.2).2) The OPS code matured through Oracle?, Oracle8, and Oracle 8L In Oracle 9.0.1, OPS was relaunched as the RAC option. It has continued to mature in Oracle 9.2 and Oracle 10.3) Prior to Oracle 10.1, Clusterware was platform-dependent. On most platforms, Clusterware was

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com2tag:blogger.com,1999:blog-5699328623439866434.post-38883140742351353062008-07-14T01:58:00.001-07:002008-07-14T02:21:05.553-07:002008-07-14T02:21:05.553-07:00

1) Apply Patch 4569559. Download From Oracle Metalink.2) Backup of internal.xml, located under $ORACLE_HOME/webcache directory on UNIX.3) User Text Editor to open and the internal.xml.4) Locate the CALYPSOINTERNALPARAMS element.5) Add the LOADBALANCE sub element directly after the OEMPERFTOOL sub element as follows: 6) Save and exit internal.xmlNote: If you are already using 80 Listen port

Jaswinder Singhhttp://www.blogger.com/profile/04369491599172730768noreply@blogger.com1