appsdbaguides.blogspot.com

AppsWorld

Friday, January 25, 2013. Query to fetch the Latest CPU patch details from Database. Column BUG format a8;. Column PATCH format a60;. Set linesize 100;. Set pagesize 200;. Select b.bug number BUG, b.LAST UPDATE DATE LDATE, decode(bug number,. 13979374, 'July 2012 CPU patch for 11i RUP7',. 13979377, 'July 2012 CPU patch for 11i RUP6',. 13979372, 'July 2012 CPU patch for R12.1 ATG PF.B.Delta3',. 13979375, 'July 2012 CPU for R12.0 ATG PF.A.Delta6',. 13621940, 'April 2012 CPU for 11i RUP7',. 13621939','13322...

http://appsdbaguides.blogspot.com/

OVERVIEW OF appsdbaguides.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

8

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR APPSDBAGUIDES.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

August

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Sunday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.9 out of 5 with 17 reviews

5 star

8

4 star

3

3 star

4

2 star

0

1 star

2

Hey there! Start your review of appsdbaguides.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.8 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT APPSDBAGUIDES.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

8

SSL

EXTERNAL LINKS

0

SITE IP

172.217.6.225

LOAD TIME

0.828 sec

SCORE

6.2

PAGE TITLE

AppsWorld | appsdbaguides.blogspot.com Reviews

<META> DESCRIPTION

Friday, January 25, 2013. Query to fetch the Latest CPU patch details from Database. Column BUG format a8;. Column PATCH format a60;. Set linesize 100;. Set pagesize 200;. Select b.bug number BUG, b.LAST UPDATE DATE LDATE, decode(bug number,. 13979374, 'July 2012 CPU patch for 11i RUP7',. 13979377, 'July 2012 CPU patch for 11i RUP6',. 13979372, 'July 2012 CPU patch for R12.1 ATG PF.B.Delta3',. 13979375, 'July 2012 CPU for R12.0 ATG PF.A.Delta6',. 13621940, 'April 2012 CPU for 11i RUP7',. 13621939','13322...

<META> KEYWORDS

1 appsworld

2 patch

3 posted by

4 appsworld ravi kethavath

5 no comments

6 email this

7 blogthis

8 share to twitter

9 share to facebook

10 share to pinterest

CONTENT

Page content here

KEYWORDS ON PAGE

appsworld,patch,posted by,appsworld ravi kethavath,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,userdetails new sql,set serveroutput on,profile ';,grant roles,grant system privs,grant table privs,grant column privs

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

AppsWorld | appsdbaguides.blogspot.com Reviews

https://appsdbaguides.blogspot.com

Friday, January 25, 2013. Query to fetch the Latest CPU patch details from Database. Column BUG format a8;. Column PATCH format a60;. Set linesize 100;. Set pagesize 200;. Select b.bug number BUG, b.LAST UPDATE DATE LDATE, decode(bug number,. 13979374, 'July 2012 CPU patch for 11i RUP7',. 13979377, 'July 2012 CPU patch for 11i RUP6',. 13979372, 'July 2012 CPU patch for R12.1 ATG PF.B.Delta3',. 13979375, 'July 2012 CPU for R12.0 ATG PF.A.Delta6',. 13621940, 'April 2012 CPU for 11i RUP7',. 13621939','13322...

INTERNAL PAGES

appsdbaguides.blogspot.com

1

AppsWorld: January 2013

http://appsdbaguides.blogspot.com/2013_01_01_archive.html

Friday, January 25, 2013. Query to fetch the Latest CPU patch details from Database. Column BUG format a8;. Column PATCH format a60;. Set linesize 100;. Set pagesize 200;. Select b.bug number BUG, b.LAST UPDATE DATE LDATE, decode(bug number,. 13979374, 'July 2012 CPU patch for 11i RUP7',. 13979377, 'July 2012 CPU patch for 11i RUP6',. 13979372, 'July 2012 CPU patch for R12.1 ATG PF.B.Delta3',. 13979375, 'July 2012 CPU for R12.0 ATG PF.A.Delta6',. 13621940, 'April 2012 CPU for 11i RUP7',. 13621939','13322...

2

AppsWorld: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

http://appsdbaguides.blogspot.com/2013/01/ora-06502-plsql-numeric-or-value-error.html

Thursday, January 24, 2013. ORA-06502: PL/SQL: numeric or value error: character string buffer too small. Issue : ORA-06502: PL/SQL: numeric or value error: character string buffer too small. While creating the AWR report. Create table WRH$ SQLTEXT BKP as select * from WRH$ SQLTEXT;. Update WRH$ SQLTEXT set sql text = SUBSTR(sql text, 1, 1000);. Subscribe to: Post Comments (Atom). View my complete profile. Picture Window theme. Powered by Blogger.

3

AppsWorld: Advanced Compression in 11G

http://appsdbaguides.blogspot.com/2012/12/advanced-compression-in-11g.html

Friday, December 7, 2012. Advanced Compression in 11G. Script to find the Compression eligible objects. Col owner format a15. Col segment name format a32. Col segment type for a15. Col tablespace name format a20. From (select owner,. Round( bytes/1024/1024/1024),2) Size in GB. Where owner not in ('SYS','SYSTEM'). And segment type in ('TABLE'). And segment name not in (select table name from dba tables where (compression='ENABLED' or table name like '%$%'). Order by 5 desc). Where rownum = 40. Select owne...

4

AppsWorld: December 2012

http://appsdbaguides.blogspot.com/2012_12_01_archive.html

Friday, December 7, 2012. Script to create new user with existing DB user Privs. Set pages 0 feed off veri off lines 500. Accept oldname prompt "Enter user to model new user to: ". Accept newname prompt "Enter new user name: ". Accept new sch password prompt "Enter new user password: ". Spool CREATE GRANT SCH spool.sql. Select 'create user & newname identified by & new sch password' '. Default tablespace ' default tablespace. Temporary tablespace ' temporary tablespace ' profile '. From sys.dba users.

5

AppsWorld: Query to fetch the Latest CPU patch details from Database

http://appsdbaguides.blogspot.com/2013/01/query-to-fetch-latest-cpu-patch-details.html

Friday, January 25, 2013. Query to fetch the Latest CPU patch details from Database. Column BUG format a8;. Column PATCH format a60;. Set linesize 100;. Set pagesize 200;. Select b.bug number BUG, b.LAST UPDATE DATE LDATE, decode(bug number,. 13979374, 'July 2012 CPU patch for 11i RUP7',. 13979377, 'July 2012 CPU patch for 11i RUP6',. 13979372, 'July 2012 CPU patch for R12.1 ATG PF.B.Delta3',. 13979375, 'July 2012 CPU for R12.0 ATG PF.A.Delta6',. 13621940, 'April 2012 CPU for 11i RUP7',. 13621939','13322...

UPGRADE TO PREMIUM TO VIEW 3 MORE

TOTAL PAGES IN THIS WEBSITE

8

OTHER SITES

appsdbafaqs.blogspot.com

ORACLE DBA AND ORACLE APPS DBA FAQS

ORACLE DBA AND ORACLE APPS DBA FAQS. This blog is designed to capture/compile all important,useful and real time questions,scenarios really required for a Oracle DBA and Oracle Apps DBA. Please do comment your comments and suggestions. Saturday, January 21, 2012. Patch Application Assistant (admsi.pl) in Oracle Apps R12. Patch Application Assistant) is tool/Perl script to generate customized installation instructions. Is under $AD TOP/bin. 2 You can run admsi.pl. Patch Application Assistant) in two mode.

appsdbaforum-biswajit.blogspot.com

Apps DBA Forum

Thursday, September 3, 2015. EBS Changes in R12.2. Oracle Weblogic Server ( Fusion Middleware 11g). Oracle Access Manager 11g. Details description about each of the changes to follow soon. Monday, March 23, 2015. RMAN configuration in 7 Steps. Even if you are not an Oracle DBA, you’ll still encounter a situation where you may have to take a backup of an Oracle database. Using Oracle RMAN, you can take a hot backup for your database, which will take a consistent backup even when your DB is up and running.

appsdbafreelance.blogspot.com

Apps DBA Free Lance

This Blog is for All Oracle Apps DBA (11i / R12) Related Queries. Join this Blog for the latest updates on Oracle EBS R12 /Oracle Apps DBA. Monday, 17 December 2012. Re-create database links : -. To check for the existence of database links, use SQL*Plus on the database server node to connect to the Applications database instance as APPS and run the following query:. Sqlplus apps/ apps password. SQL select db link from dba db links;. Sqlplus apps/ apps password. SQL alter session set global names=false;.

appsdbaguides.blogspot.com

AppsWorld

Friday, January 25, 2013. Query to fetch the Latest CPU patch details from Database. Column BUG format a8;. Column PATCH format a60;. Set linesize 100;. Set pagesize 200;. Select b.bug number BUG, b.LAST UPDATE DATE LDATE, decode(bug number,. 13979374, 'July 2012 CPU patch for 11i RUP7',. 13979377, 'July 2012 CPU patch for 11i RUP6',. 13979372, 'July 2012 CPU patch for R12.1 ATG PF.B.Delta3',. 13979375, 'July 2012 CPU for R12.0 ATG PF.A.Delta6',. 13621940, 'April 2012 CPU for 11i RUP7',. 13621939','13322...

appsdbahosting.com

Site Unavailable

This site is currently unavailable.

appsdbainfo.com

Resume of Monique Underwood

Senior Oracle Applications Engineer with comprehensive knowledge in Oracle Databases, Oracle Applications technology stack including architecture, installation, configuration, maintenance, cloning and patching, Workflow Mailer, Oracle development tools and UNIX operating systems. Results and goal-oriented individual highly motivated, competent in functioning alone or as an integral team member. Exceptional analytical and problem-solving skills. Excellent verbal and written communication skills. Install a...

appsdbalab.blogspot.com

Oracle DBA (Core & Apps) Lab

Oracle DBA (Core and Apps) Lab. Dedicated to All Oracle Apps DBA / Core DBA in the World! Friday, December 24, 2010. UNIX FOR DBA’S. The "pwd" command displays the current directory:. U01/app/oracle/product/9.2.0.1.0. The "ls" command lists all files and directories in the specified directory. If no location is defined it acts on the current directory:. The "-a" flag lists hidden "." files. The "-l" flag lists file details. The "cd" command is used to change directories:. Root touch my.log. The "which" c...

appsdbalife.wordpress.com

Just Another Day of Apps DBA's Life | notes of an oracle apps dba

Just Another Day of Apps DBA's Life. Notes of an oracle apps dba. Author – Maris Elsins. GetMOSPatch.sh – Downloading Patches From My Oracle Support. November 12, 2013. This post originally appeared at the Pythian. How to download patches from My Oracle Support (MOS) directly to the server? Then, back in 2009 my teammate John. Published a blog post on Retrieving Oracle patches with wget. I think it’s time to get rid of browser dependency. So I’ve written a shell script getMOSPatch.sh. November 4, 2013.