appsdbaportal.blogspot.com

Oracle Application DBA Portal

Major changes from 11i. Compile Apps Schema invalid objects in R12. Apps Components and Architecture. Upgrade 11.5.9 to 11.5.10.2. Upgrade from 11.5.10.2 to R12. Upgrading 9i to 10g with 11i. AppsDBA System Management Utilities Guide. Identifying Long Idle Sessions. Identifying High Active Sessions. Change hostname for EBS. Oracle12c Datafile moved Online. Upgrade 10g to 11g R1. Upgrade 11.2.0.2 to 11.2.0.3. Top 99 Responsibilities of a DBA. Disk I/O,Events,Waits. Oracle AS10g null protocol issue. New an...

http://appsdbaportal.blogspot.com/

OVERVIEW OF appsdbaportal.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

20

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR APPSDBAPORTAL.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

May

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.9 out of 5 with 13 reviews

5 star

6

4 star

2

3 star

4

2 star

0

1 star

1

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

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.6 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT APPSDBAPORTAL.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

20

SSL

EXTERNAL LINKS

40

SITE IP

172.217.11.33

LOAD TIME

0.563 sec

SCORE

6.2

PAGE TITLE

Oracle Application DBA Portal | appsdbaportal.blogspot.com Reviews

<META> DESCRIPTION

Major changes from 11i. Compile Apps Schema invalid objects in R12. Apps Components and Architecture. Upgrade 11.5.9 to 11.5.10.2. Upgrade from 11.5.10.2 to R12. Upgrading 9i to 10g with 11i. AppsDBA System Management Utilities Guide. Identifying Long Idle Sessions. Identifying High Active Sessions. Change hostname for EBS. Oracle12c Datafile moved Online. Upgrade 10g to 11g R1. Upgrade 11.2.0.2 to 11.2.0.3. Top 99 Responsibilities of a DBA. Disk I/O,Events,Waits. Oracle AS10g null protocol issue. New an...

<META> KEYWORDS

1 r122 architecture

2 r12 http debug logging

3 concurrent managers

4 patching

5 using ad patch

6 using ad control

7 fndcpass utility

8 single node installation

9 multi node installation

10 find apps version

CONTENT

Page content here

KEYWORDS ON PAGE

r122 architecture,r12 http debug logging,concurrent managers,patching,using ad patch,using ad control,fndcpass utility,single node installation,multi node installation,find apps version,cloning,11i/r12 general topics,oracle 12c database,general info,rman

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Oracle Application DBA Portal | appsdbaportal.blogspot.com Reviews

https://appsdbaportal.blogspot.com

Major changes from 11i. Compile Apps Schema invalid objects in R12. Apps Components and Architecture. Upgrade 11.5.9 to 11.5.10.2. Upgrade from 11.5.10.2 to R12. Upgrading 9i to 10g with 11i. AppsDBA System Management Utilities Guide. Identifying Long Idle Sessions. Identifying High Active Sessions. Change hostname for EBS. Oracle12c Datafile moved Online. Upgrade 10g to 11g R1. Upgrade 11.2.0.2 to 11.2.0.3. Top 99 Responsibilities of a DBA. Disk I/O,Events,Waits. Oracle AS10g null protocol issue. New an...

INTERNAL PAGES

appsdbaportal.blogspot.com

1

Oracle Application DBA Portal

http://appsdbaportal.blogspot.com/2009/04/change-hostname-for-e-business-suite.html

Major changes from 11i. Compile Apps Schema invalid objects in R12. Apps Components and Architecture. Upgrade 11.5.9 to 11.5.10.2. Upgrade from 11.5.10.2 to R12. Upgrading 9i to 10g with 11i. AppsDBA System Management Utilities Guide. Identifying Long Idle Sessions. Identifying High Active Sessions. Change hostname for EBS. Oracle12c Datafile moved Online. Upgrade 10g to 11g R1. Upgrade 11.2.0.2 to 11.2.0.3. Top 99 Responsibilities of a DBA. Disk I/O,Events,Waits. Oracle AS10g null protocol issue. 3 Upda...

2

Oracle Application DBA Portal

http://appsdbaportal.blogspot.com/2009/05/concurrent-managers.html

Major changes from 11i. Compile Apps Schema invalid objects in R12. Apps Components and Architecture. Upgrade 11.5.9 to 11.5.10.2. Upgrade from 11.5.10.2 to R12. Upgrading 9i to 10g with 11i. AppsDBA System Management Utilities Guide. Identifying Long Idle Sessions. Identifying High Active Sessions. Change hostname for EBS. Oracle12c Datafile moved Online. Upgrade 10g to 11g R1. Upgrade 11.2.0.2 to 11.2.0.3. Top 99 Responsibilities of a DBA. Disk I/O,Events,Waits. Oracle AS10g null protocol issue. A task...

3

Oracle Application DBA Portal

http://appsdbaportal.blogspot.com/2009/04/upgrade-1159-to-115102.html

Major changes from 11i. Compile Apps Schema invalid objects in R12. Apps Components and Architecture. Upgrade 11.5.9 to 11.5.10.2. Upgrade from 11.5.10.2 to R12. Upgrading 9i to 10g with 11i. AppsDBA System Management Utilities Guide. Identifying Long Idle Sessions. Identifying High Active Sessions. Change hostname for EBS. Oracle12c Datafile moved Online. Upgrade 10g to 11g R1. Upgrade 11.2.0.2 to 11.2.0.3. Top 99 Responsibilities of a DBA. Disk I/O,Events,Waits. Oracle AS10g null protocol issue. 7 Chec...

4

Oracle Application DBA Portal

http://appsdbaportal.blogspot.com/2009/04/using-ad-patch.html

Major changes from 11i. Compile Apps Schema invalid objects in R12. Apps Components and Architecture. Upgrade 11.5.9 to 11.5.10.2. Upgrade from 11.5.10.2 to R12. Upgrading 9i to 10g with 11i. AppsDBA System Management Utilities Guide. Identifying Long Idle Sessions. Identifying High Active Sessions. Change hostname for EBS. Oracle12c Datafile moved Online. Upgrade 10g to 11g R1. Upgrade 11.2.0.2 to 11.2.0.3. Top 99 Responsibilities of a DBA. Disk I/O,Events,Waits. Oracle AS10g null protocol issue. An Ora...

5

Oracle Application DBA Portal

http://appsdbaportal.blogspot.com/2009/04/patching.html

Major changes from 11i. Compile Apps Schema invalid objects in R12. Apps Components and Architecture. Upgrade 11.5.9 to 11.5.10.2. Upgrade from 11.5.10.2 to R12. Upgrading 9i to 10g with 11i. AppsDBA System Management Utilities Guide. Identifying Long Idle Sessions. Identifying High Active Sessions. Change hostname for EBS. Oracle12c Datafile moved Online. Upgrade 10g to 11g R1. Upgrade 11.2.0.2 to 11.2.0.3. Top 99 Responsibilities of a DBA. Disk I/O,Events,Waits. Oracle AS10g null protocol issue. The fo...

UPGRADE TO PREMIUM TO VIEW 15 MORE

TOTAL PAGES IN THIS WEBSITE

20

LINKS TO THIS WEBSITE

pursueoracle.blogspot.com

PURSUE ORACLE: October 2009

http://pursueoracle.blogspot.com/2009_10_01_archive.html

Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Saturday, October 17, 2009. Import/ Export from multiple schema. Fromuser=(USER01, USER02, USER03, USER04). Touser=(USER01, USER02, USER03, USER04). Subset of a table import. Exp scott/tiger tables=emp query="where deptno=10". From sys.v $sqlarea. DO NOT e...

pursueoracle.blogspot.com

PURSUE ORACLE: November 2009

http://pursueoracle.blogspot.com/2009_11_01_archive.html

Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Monday, November 16, 2009. VARCHAR2( 10 ) and VARCHAR2( 10 CHAR). By default, when you declare a variable VARCHAR2( 10 ), Oracle allocates. 10 bytes of storage. If you use a variable-length character set (i.e. Subscribe to: Posts (Atom). Http:/ asktom....

pursueoracle.blogspot.com

PURSUE ORACLE: April 2009

http://pursueoracle.blogspot.com/2009_04_01_archive.html

Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Monday, April 6, 2009. UNISTR ASCIISTR SUBSTRB LENGTHB. Select nvarchar2 field FIELD , Lenght(nvarchar2 field) LENGTH, LenghtB(nvarchar2 field) LENGTB. LengthB gives the size in bytes,. Length gives the size in characters. More use of LENGTHB. The followin...

pursueoracle.blogspot.com

PURSUE ORACLE: RMAN Tutorial

http://pursueoracle.blogspot.com/2010/07/rman-tutorial.html

Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Monday, July 26, 2010. Ability to perform incremental backups.Ability to recover one block of a datafile. Ability to perform the backup and restore with parallelization. Ability to automatically delete archived redo logs after they are backed up. With the ...

pursueoracle.blogspot.com

PURSUE ORACLE: January 2010

http://pursueoracle.blogspot.com/2010_01_01_archive.html

Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Tuesday, January 12, 2010. Http:/ asktom.oracle.com/pls/asktom/f? P=100:11:818301469484507: : P11 QUESTION ID:146412348066. Dbms output.put line has limitation of 255 characters. Procedure p( p string in varchar2 ). L string long default p string;. Put( s ...

pursueoracle.blogspot.com

PURSUE ORACLE: Index, Bitmap Index, B-Tree, IOT

http://pursueoracle.blogspot.com/2010/07/index-bitmap-index-b-tree-iot.html

Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Sunday, July 25, 2010. Index, Bitmap Index, B-Tree, IOT. Index, Bitmap Index, B-Tree Index. Oracle's two major index types are Bitmap indexes and B-Tree indexes. Characteristic of Bitmap Indexes:. For columns with very few unique values (low cardinality).

pursueoracle.blogspot.com

PURSUE ORACLE: RMAN Enhancements in Oracle Database 10g

http://pursueoracle.blogspot.com/2010/07/rman-enhancements-in-oracle-database.html

Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Monday, July 26, 2010. RMAN Enhancements in Oracle Database 10g. RMAN Enhancements in Oracle Database 10g. Http:/ www.oracle-base.com/articles/10g/RMANEnhancements10g.php. The flash recovery area. Multiplexed online redo logs. Using this feature all change...

pursueoracle.blogspot.com

PURSUE ORACLE: December 2009

http://pursueoracle.blogspot.com/2009_12_01_archive.html

Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Monday, December 14, 2009. The SYSDATE return current date and time and the SYSTIMESTAMP function returns the system date, including fractional seconds and time zone of the database. SQL select sysdate from dual;. SQL select systimestamp from dual;. Select...

pursueoracle.blogspot.com

PURSUE ORACLE: August 2010

http://pursueoracle.blogspot.com/2010_08_01_archive.html

Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Wednesday, August 4, 2010. ORA-04052: error occurred when looking up remote object SYS.DBMS UTILITY@DB10G. ORA-04052: error occurred when looking up remote object SYS.DBMS UTILITY@DB10G. The DB link part throws this error. Tried to run catalog.sql. How to ...

pursueoracle.blogspot.com

PURSUE ORACLE: July 2009

http://pursueoracle.blogspot.com/2009_07_01_archive.html

Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Friday, July 24, 2009. STARTUP FORCE has nothing to do with starting the database with bad datafiles. It starts the database just like normal STARTUP command, so if STARTUP returns errors about corrupted datafiles, so will STARTUP FORCE. SQL shutdown abort;.

UPGRADE TO PREMIUM TO VIEW 30 MORE

TOTAL LINKS TO THIS WEBSITE

40

OTHER SITES

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.

appsdbanew.wordpress.com

Apps DBA Concepts

Just another WordPress.com weblog. Bulk collect comes handy for plsql. Find the current SQL in the database. Important for Windows Oracle Apps customer. How to find blocking session and kill the session from database. R12 - Shortcut to access the forms URL and sysadmin Responsibility page. Applications Short Name for most of the Apps Products. To find the StartCD version - R12. How to find an AD patchset level? ARCHIVE LOG START is DEPRECATED in 11g. Naveen – Pratical Apps DBA. On November 27, 2010.

appsdbanotes.wordpress.com

Apps DBA notes | Just another WordPress.com weblog

Just another WordPress.com weblog. How Veeam backup MSSQL. July 8, 2016. I love Veeam. It is easy to use and do a nice job. Make our live easier than before. OK, What is important for DBAs here? What is the relation that DBA need to know about. How Veeam backup SQL server? This is first and most important question that I was looking for. Veeam is install service on VM during backup time and in our case is using Volume Shadow Copy Services (VSS) to backup SQL server. How this is going to be? BE CAREFUL AS...

appsdbaportal.blogspot.com

Oracle Application DBA Portal

Major changes from 11i. Compile Apps Schema invalid objects in R12. Apps Components and Architecture. Upgrade 11.5.9 to 11.5.10.2. Upgrade from 11.5.10.2 to R12. Upgrading 9i to 10g with 11i. AppsDBA System Management Utilities Guide. Identifying Long Idle Sessions. Identifying High Active Sessions. Change hostname for EBS. Oracle12c Datafile moved Online. Upgrade 10g to 11g R1. Upgrade 11.2.0.2 to 11.2.0.3. Top 99 Responsibilities of a DBA. Disk I/O,Events,Waits. Oracle AS10g null protocol issue. New an...

appsdbaquestions.blogspot.com

Oracle Apps DBA troubleshooting

Oracle Apps DBA troubleshooting. Saturday, November 14, 2009. ORA-27047: unable to read the header block of file. Trying to clone from prod. If you noticed following error message. CREATE CONTROLFILE REUSE SET DATABASE "DEV". ERROR at line 1:. ORA-01503: CREATE CONTROLFILE failed. ORA-01565: error in identifying file. ORA-27047: unable to read the header block of file. After above error I run following command and noticed header error. System01.dbf: Header block magic number is bad. Oracle Apps DBA blog.

appsdbaref.com

Coming Soon - Future home of something quite cool

Future home of something quite cool. If you're the site owner. To launch this site. If you are a visitor. Please check back soon.

appsdbarepository.blogspot.com

Info on Oracle Apps and DB

Info on Oracle Apps and DB. Sunday, March 25, 2007. Apps - Concurrent Queries. Request Details with Status/Phase Info. Select b.user concurrent program name, cp.request id, sc.MEANING,pc.MEANING ,. To char(cp.actual start date,'dd-mon-yyyy hh24:mi'),. To char(cp.actual completion date,'dd-mon-yyyy hh24:mi'). FROM apps.fnd concurrent requests cp ,apps.fnd concurrent programs vl b, apps.fnd lookups sc , apps.fnd lookups pc. Cprequest id between = ReqId. Bapplication id = cp.program application id and.