Website Design, Website Development, Shopping Carts, Content Management Systems, Custom Programming, Custom Applications Appsdba: March 2009

Oracle Applications, Middleware, Database, DB RAC & HA

It is place where anyone grab more knowledge about Oracle Applications, middleware etc.

 
APPS R12
  • File System
  • Tech Stack
  • Admin Scripts
  • Forms Mode
  • APPS 11i
  • Know more
  • Maintenance Mode
  • Maintenance Mode(New)
  • Patching
  • APPS Scripts
  • Database Scripts
  • Protect APPS Password
  • Concurrent Manager
  • Database Refersh
  • Patchset Utility
  • Forms Data Loader
  • Web Server
  • Space Required
  • Responsibilities Of APPSDBA
  • OAS 9i/10gR2
  • Software Load Balancer
  • OAS 10gR3
  • Components
  • HTTP Server as Port 80
  • Database
  • Enable Archive
  • Clear Temp Tablespace
  • Drop DB (New in 10g)
  • Database Performance
  • Oracle Process
  • Advanced Topic
  • Database RAC

  • Do you know
  • Clusterware
  • Manage RAC Environment
  • High Availability
  • Certifications
  • EBS R12 Beta Exam
  • APPS 11i - 1z0-233
  • RAC 10gR2 - 1z0-048
  • Oracle Certifications
  • DBA Tools
  • TOAD
  • KEEP TOOL
  • ORACLE's SQL DEVELOPER
  • Spotlight on Oracle E-Business
  • DBDiff For Oracle

  • Run PDA For Portal 3.0.9 Integrated with 11.5.9 !!!!!!!
    Tuesday, March 31, 2009
    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 server.

    3) Change the ownership and permission.

    chown applmgr:dba pda30.zip
    chmod -R 755 pda30.zip

    4) Unzip the pda30.zip file into a folder.

    5) Login to SQL*PLUS as PORTAL30 user.

    6) Execute

    sqlplus> @/u01/PDA/PDA30_unix.sql


    7) Script will prompt :

    - Folder Path /u01/PDA
    - The 9iAS Home
    - The Portal Schema Name - portal30
    - The SSO Schema Name

    8) The script will give you a chance to verify the values you entered.Please verify it and make sure they are correct.

    Press "Return" key if the values are correct or press "Ctrl-C" twice to stop the script execution.

    9) It will generate PDA_RESULTS.zip

    10) Zip the PDA_RESULTS folder as PDA_RESULTS.zip and upload the file via metalink

    11) Open the PDA.html file (under the PDA_RESULTS folder) in the browser.


    Example :

    bash-2.05$ sqlplus portal30/portal30

    SQL*Plus: Release 8.0.6.0.0 - Production on Tue Feb 17 11:53:45 2009
    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.6.0 - Production

    SQL> @PDA30_unix.sql
    Enter PDA unzip folder path(ex: /u01/PDA): /prodapps/applprod/PDA
    Enter 9iAS_Home(ex: /u01/isuites): /prodapps/applprod/prodora/iAS
    Enter Portal Schema Name(default is PORTAL30):
    Enter SSO Schema Name(default is PORTAL30_SSO):


    You have entered the following values:

    PDA folder: /prodapps/applprod/PDA

    9iAS Home: /prodapps/applprod/prodora/iAS

    Portal Schema Name: PORTAL30

    SSO Schema Name: PORTAL30_SSO

    If this is correct, please press the "Return" key to continue....
    ....or press "Ctrl-C" twice to stop execution of this script
    posted by Jaswinder Singh @ 2:29 AM   0 comments
    About Me

    Name: Jaswinder Singh
    Home: Bangalore, Karnataka, India
    Certifications: RAC Certified Expert, OCP 9i, 10g & 11i
    About Me: I am working as APPSDBA, have hands on experience on DB RAC, HA on OAS 10g and Oracle Applications.
    See my complete profile
    Previous Post
    Archives
    Links
    Powered by

    Free Blogger Templates

    BLOGGER

    ADVERTISEMENT
    click here
    © 2006 Appsdba .