Buy your textbooks here

Free 1Z0-035 Text Books of Killexams.com | study guide | Braindumps | Study Guides | Textbook

Killexams.com 1Z0-035 prep pack is designed to pass 1Z0-035 certification exam There is no match of killexams.com on internet - study guide - Study Guides | Textbook

Pass4sure 1Z0-035 dumps | Killexams.com 1Z0-035 existent questions | https://www.textbookw.com/


Killexams.com 1Z0-035 Dumps and existent Questions

100% existent Questions - Exam Pass Guarantee with lofty Marks - Just Memorize the Answers



1Z0-035 exam Dumps Source : Oracle 7.3 and 8 to Oracle9i DBA OCP Upgrade

Test Code : 1Z0-035
Test cognomen : Oracle 7.3 and 8 to Oracle9i DBA OCP Upgrade
Vendor cognomen : Oracle
: 905 existent Questions

How many days preparation required to pass 1Z0-035 exam?
It is excellent! I passed my 1Z0-035 exam yesterday with a nearly consummate score of 98%. Thank you Killexams! The materials in the bundle are unquestionable and cogent - this is what I got on my other exam. I knew answers to most of the questions, and some more questions were very similar and on the subjects fully covered in the study guide, so I was able to retort them by myself. Not only did I accumulate an excellent learning implement which has helped me expand my professional knowledge, but I also received an smooth pass to my 1Z0-035 certification.


a course to do together for 1Z0-035 examination?
I might regularly pass over lessons and that is probably a stately wretchedness for me if my dad and mom observed out. I needed to cowl my errors and ensure that they will reckon in me. I knew that one manner to cover my mistakes emerge as to Do nicely in my 1Z0-035 check that become very near to. If I did well in my 1Z0-035 test, my mother and father would fancy me yet again and they did due to the fact i used to live able to clear the check. It emerge as this killexams.com that gave me the perquisite instructions. Thanks.


Just try these Latest dumps and success is yours.
killexams.com became a blessing for 1Z0-035 exam, since the system has plenty of tiny details and configuration tricks, which can live challenging in case you dont fill much of 1Z0-035 revel in. killexams.com 1Z0-035 questions and solutions are adequate to steal a seat and pass the 1Z0-035 check.


Passing 1Z0-035 exam is simply click away!
The excellent ingredient approximately your questions bank is the explanations provided with the solutions. It helps to apprehend the theme conceptually. I had subscribed for the 1Z0-035 questions and answers and had long gone thru it three-4 times. within the exam, I tried total the questions under forty mins and scored 90 marks. thank you for making it cleanly for us. Hearty course to killexams.com crew, with the assist of your version questions.


Is there a person who surpassed 1Z0-035 examination?
First of total I want to mention Thanks to you people. I fill cleared 1Z0-035 Exam by course of subscribing to your examine material. So I wanted to participate my fulfillment in your website. Thank you once again. Thank you very much to your extremely helpful assist. I even fill cleared my 1Z0-035 with 90%.


real test questions modern day 1Z0-035 examination are available now.
Hats down the pleasant 1Z0-035 exam coaching preference. I passed my 1Z0-035 exam remaining week, and this set of examquestions and solutions has been very useful. These things from killexams.com is right. Before making a purchase, I contacted customer champion with questions about how updated their materials are, and that they showed that they supersede total tests on nearly each day basis. They upload updates wherein essential, or in reality double test the content dump to submit unavoidable its up to date. It justifies buying an exam brain dump. With killexams.com, I recognizethat im able to depend upon the brand fresh exam material, not a few e-book which can whirl out to live out of date each week after its published. So I anticipate this is the high-quality exam instruction alternative. I assume i will extend my certification portfolio into a few different companies, Im virtually now not nice which of them but. But what Im positiveapproximately is that I will live the employ of killexams.com as my essential education useful resource.


in which can i ascertain 1Z0-035 exam examine help?
I passed the 1Z0-035 exam. It changed into the primary time I used killexams.com for my training, so I didnt recognise what to anticipate. So, I got a nice prodigy as killexams.com has shocked me and absolutely passed my expectancies. The exam simulator/exercise exams travail top notch, and the questions are valid. by cogent I imply that theyre existent exam questions, and that i got many of them on my existent exam. Very dependable, and i was left with extremely helpful impressions. i might now not waver to advocate killexams.com to my colleagues.


decided maximum 1Z0-035 Questions in existent test questions that I prepared.
I should admit, selecting killexams.com was the next sapient determination I took after selecting the 1Z0-035 exam. The patterns and questions are so nicely spread which allows individual raise their bar by the time they compass the last simulation exam. appreciate the efforts and wholehearted thanks for helping pass the exam. sustain up the helpful work. Thanks killexams.


It is really considerable suffer to fill 1Z0-035 existent exam questions.
As I had one and simplest week nearby before the exam 1Z0-035. So, I relied on upon the of killexams.com for quick reference. It contained quick-duration replies in a systemic way. huge thanks to you, you transmute my international. that is the best exam retort in the event that i fill confined time.


Do you need existent exam questions of 1Z0-035 examination to bypass the examination?
Before I walk to the testing center, I was so confident about my preparation for the 1Z0-035 exam because I knew I was going to ace it and this assurance came to me after using this killexams.com for my assistance. It is very helpful at assisting students just fancy it assisted me and I was able to accumulate helpful scores in my 1Z0-035 test.


Oracle Oracle 7.3 and 8

Oracle Linux 7.three Now available with Unbreakable enterprise Kernel unlock 4 | killexams.com existent Questions and Pass4sure dumps

After remaining week's unlock of red Hat's RHEL (purple Hat enterprise Linux) 7.3 working gadget, now Oracle is haughty to publish the universal availability of its Oracle Linux 7.3 distribution for 64-bit (x86_64) servers.

in line with the crimson Hat commercial enterprise Linux 7.3 and powered via its kernel-3.10.0-514.el7 Linux kernel package, Oracle Linux 7 update three looks to live the primary liberate of the server-oriented Linux-based mostly working equipment to employ Oracle's fresh Unbreakable trade Kernel liberate four (UEK R4), versioned kernel-uek-4.1.12-61.1.18.el7uek. Oracle Linux 7.3 also introduces UEFI and secure Boot support.

"here's the first Oracle Linux 7 ISO to embrace UEK unencumber four (UEK R4). please live awake that fresh installations of Oracle Linux 7 update three will installation and boot the UEK R4 kernel via default. despite the fact, updates to current Oracle Linux 7 environments require the person to explicitly set up UEK R4 and will no longer instantly exchange existing UEK R3 kernels," wrote Teri Whitaker, application supervisor at Oracle, within the unlock announcement.

Oracle Linux 7.3 helps the latest UEK R3u7 and later

within the decent subculture of the working device, Oracle Linux 7.3 supports each the Unbreakable trade Kernel (UEK) and purple Hat appropriate Kernel (RHCK) kernels, nevertheless it boots the former with the aid of default, while the latter will also live manually enabled via administrators. although, Oracle Linux 7 supersede three continues to aid the latest Unbreakable enterprise Kernel unlock 3 supersede 7 and later.

As anticipated, those that fill an energetic steer subscription for Oracle Linux can now down load the ISO setting up photographs of Oracle Linux 7.three from My Oracle guide, in addition to from Oracle software birth Cloud. Oracle also provides individual RPM packages for Oracle Linux 7.three on the Unbreakable Linux community (ULN) and a public YUM server. users are inspired to update their installations as quickly as possible.


Buffett, the Oracle of Omaha, backtracks on Oracle, the trade | killexams.com existent Questions and Pass4sure dumps

by using Jonathan Stempel

(Reuters) - The Oracle of Omaha, Warren Buffett, admitted on Monday he knew lower than he thought about Oracle Corp, the enterprise overseen by course of fellow billionaire Larry Ellison.

traders were flummoxed past this month when Buffett's company, Berkshire Hathaway Inc, printed that during last yr's fourth quarter it had exited a $2.13 billion stake in Oracle that it had taken the prior quarter.

It is uncommon for Berkshire, which owns some shares for a long time, to unwind an investment so fast. it is also infrequent for Berkshire to submit significant investments within the expertise sector.

speaking on CNBC television, Buffett recalled his unsuccessful investment in alien company Machines Corp in deciding upon that Oracle, the business, wasn't for him, although Ellison had executed a "remarkable job" operating it.

"After I total started purchasing it, I felt I nevertheless did not fill in intelligence the enterprise," Buffett talked about. "certainly after my event with IBM, I don't believe I reckon exactly the spot the cloud goes."

The Oracle of Omaha is a nickname that Buffett's fans frequently employ for him. His conglomerate is based mostly in Omaha, Nebraska.

Berkshire referred to it ended the year with $172.8 billion of shares, including $40.3 billion in iPhone maker Apple Inc, which Buffett views more as a consumer enterprise.

He pointed out the all can also upward thrust in 2019 since it has become tough to buy complete businesses to add to Berkshire's portfolio of greater than 90 companies, including the Geico auto insurer and BNSF railroad.

it is dubious why Berkshire's annual file on Saturday unnoticed a previously blanketed zone known as "acquisition criteria," together with that Berkshire preferred "fundamental companies (if there's lots of expertise, they won't understand it)."

Buffett and longtime vice president Charlie Munger ceded every day oversight of Berkshire's working gadgets ultimate yr to Vice Chairmen Greg Abel and Ajit Jain.

(Reporting through Jonathan Stempel in long island; enhancing by means of Jeffrey Benkoe)


device for making a selection on what's installed on Oracle 7.3.four and 8.1.6 | killexams.com existent Questions and Pass4sure dumps

Is there a device or script so that it will inform me exactly what I actually fill installed on servers operating Oracle 7.three.four and 8.1.6?

The Oracle universal Installer become first released with eight.1.5 and has been used ever because. So, for the 8.1.6 liberate, that you may accelerate the installer and click the "installed products" button on the first monitor to explore the installed accessories. i know that I've considered some types of the OUI additionally document on different ORACLE_HOMEs it finds (I presuppose they accumulate the listing from the oratab), but now not total OUI models materialize to Do that.

To find the ingredient record for the 7.three.4 ORACLE_HOME, open the file $ORACLE_HOME/rdbms/admin/unix.rgs (for Unix systems) FILLIN. here is a text file that lists the accessories that the installer do in.


Whilst it is very difficult job to select dependable exam questions / answers resources regarding review, reputation and validity because people accumulate ripoff due to choosing incorrect service. Killexams. com submit it unavoidable to provide its clients far better to their resources with respect to exam dumps update and validity. Most of other peoples ripoff report complaint clients advance to us for the brain dumps and pass their exams enjoyably and easily. They never compromise on their review, reputation and trait because killexams review, killexams reputation and killexams client self assurance is essential to total of us. Specially they manage killexams.com review, killexams.com reputation, killexams.com ripoff report complaint, killexams.com trust, killexams.com validity, killexams.com report and killexams.com scam. If perhaps you behold any bogus report posted by their competitor with the cognomen killexams ripoff report complaint internet, killexams.com ripoff report, killexams.com scam, killexams.com complaint or something fancy this, just sustain in intelligence that there are always evil people damaging reputation of helpful services due to their benefits. There are a great number of satisfied customers that pass their exams using killexams.com brain dumps, killexams PDF questions, killexams drill questions, killexams exam simulator. Visit Killexams.com, their test questions and sample brain dumps, their exam simulator and you will definitely know that killexams.com is the best brain dumps site.

Back to Braindumps Menu


CPSM1 cheat sheets | CLSSGB braindumps | ST0-141 braindumps | II0-001 cram | P2140-022 free pdf download | 2V0-622D study guide | HP0-626 free pdf | M2010-720 existent questions | 310-560 dump | VCPC510 drill questions | 2V0-602 mock exam | 250-924 braindumps | 70-532 brain dumps | 600-211 dumps questions | 920-805 dumps | C2180-606 study guide | CA-Real-Estate free pdf | HP0-D24 braindumps | F50-529 drill Test | ISEE bootcamp |


Guarantee your prosperity with this 1Z0-035 question bank
killexams.com Oracle Certification is vital in career oportunities. Lots of students had been complaining that there are too many questions in such a lot of drill assessments and exam guides, and they are just worn-out to fill enough money any more. Seeing killexams.com professionals travail out this comprehensive version of brain dumps with existent questions at the identical time as nonetheless assure that just memorizing these existent questions, you will pass your exam with helpful marks.

As the main thing that is in any capacity censorious here is passing the 1Z0-035 - Oracle 7.3 and 8 to Oracle9i DBA OCP Upgrade exam. As total that you require is a lofty score of Oracle 1Z0-035 exam. The only a solitary thing you need to Do is downloading braindumps of 1Z0-035 exam prep coordinates now. They will not let you down with their unrestricted guarantee. The specialists in fancy manner sustain pace with the most best in class exam to give most of updated materials. Three Months free access to fill the skill to them through the date of purchase. Every candidate may endure the cost of the 1Z0-035 exam dumps through killexams.com requiring diminutive to no effort. There is no risk involved at all..

Inside seeing the bona fide exam material of the brain dumps at killexams.com you can without a lot of an extend develop your pretense to fame. For the IT specialists, it is basic to enhance their capacities as showed by their travail need. They submit it basic for their customers to carry certification exam with the abet of killexams.com confirmed and honest to goodness exam material. For an awesome future in its domain, their brain dumps are the best decision.

killexams.com Huge Discount Coupons and Promo Codes are as under;
WC2017 : 60% Discount Coupon for total exams on website
PROF17 : 10% Discount Coupon for Orders greater than $69
DEAL17 : 15% Discount Coupon for Orders greater than $99
DECSPECIAL : 10% Special Discount Coupon for total Orders


A best dumps creating is a basic segment that makes it straightforward for you to steal Oracle certifications. In any case, 1Z0-035 braindumps PDF offers settlement for candidates. The IT assertion is a censorious troublesome attempt if one doesnt find genuine course as obvious resource material. Thus, they fill genuine and updated material for the arranging of certification exam.

We fill their experts working continuously for the collection of existent exam questions of 1Z0-035. total the pass4sure questions and answers of 1Z0-035 collected by their team are reviewed and updated by their Oracle certified team. They remain connected to the candidates appeared in the 1Z0-035 test to accumulate their reviews about the 1Z0-035 test, they collect 1Z0-035 exam tips and tricks, their suffer about the techniques used in the existent 1Z0-035 exam, the mistakes they done in the existent test and then ameliorate their material accordingly. Once you fade through their pass4sure questions and answers, you will feel confident about total the topics of test and feel that your knowledge has been greatly improved. These pass4sure questions and answers are not just drill questions, these are existent exam questions and answers that are enough to pass the 1Z0-035 exam at first attempt.

Oracle certifications are highly required across IT organizations. HR managers prefer candidates who not only fill an understanding of the topic, but having completed certification exams in the subject. total the Oracle certifications provided on Pass4sure are accepted worldwide.

Are you looking for pass4sure existent exams questions and answers for the Oracle 7.3 and 8 to Oracle9i DBA OCP Upgrade exam? They are here to provide you one most updated and trait sources that is killexams.com. They fill compiled a database of questions from actual exams in order to let you prepare and pass 1Z0-035 exam on the first attempt. total training materials on the killexams.com site are up to date and verified by industry experts.

Why killexams.com is the Ultimate selection for certification preparation?

1. A trait product that abet You Prepare for Your Exam:

killexams.com is the ultimate preparation source for passing the Oracle 1Z0-035 exam. They fill carefully complied and assembled existent exam questions and answers, which are updated with the identical frequency as existent exam is updated, and reviewed by industry experts. Their Oracle certified experts from multiple organizations are talented and qualified / certified individuals who fill reviewed each question and retort and explanation section in order to abet you understand the concept and pass the Oracle exam. The best course to prepare 1Z0-035 exam is not reading a text book, but taking drill existent questions and understanding the remedy answers. drill questions abet prepare you for not only the concepts, but also the routine in which questions and retort options are presented during the existent exam.

2. User Friendly Mobile Device Access:

killexams provide extremely user friendly access to killexams.com products. The focus of the website is to provide accurate, updated, and to the point material to abet you study and pass the 1Z0-035 exam. You can quickly accumulate the existent questions and retort database. The site is mobile friendly to allow study anywhere, as long as you fill internet connection. You can just load the PDF in mobile and study anywhere.

3. Access the Most Recent Oracle 7.3 and 8 to Oracle9i DBA OCP Upgrade existent Questions & Answers:

Our Exam databases are regularly updated throughout the year to embrace the latest existent questions and answers from the Oracle 1Z0-035 exam. Having Accurate, unquestionable and current existent exam questions, you will pass your exam on the first try!

4. Their Materials is Verified by killexams.com Industry Experts:

We are doing struggle to providing you with accurate Oracle 7.3 and 8 to Oracle9i DBA OCP Upgrade exam questions & answers, along with explanations. They submit the value of your time and money, that is why every question and retort on killexams.com has been verified by Oracle certified experts. They are highly qualified and certified individuals, who fill many years of professional suffer related to the Oracle exams.

5. They Provide total killexams.com Exam Questions and embrace circumstantial Answers with Explanations:

killexams.com Huge Discount Coupons and Promo Codes are as under;
WC2017 : 60% Discount Coupon for total exams on website
PROF17 : 10% Discount Coupon for Orders greater than $69
DEAL17 : 15% Discount Coupon for Orders greater than $99
DECSPECIAL : 10% Special Discount Coupon for total Orders


Unlike many other exam prep websites, killexams.com provides not only updated actual Oracle 1Z0-035 exam questions, but also circumstantial answers, explanations and diagrams. This is essential to abet the candidate not only understand the remedy answer, but also details about the options that were incorrect.

1Z0-035 Practice Test | 1Z0-035 examcollection | 1Z0-035 VCE | 1Z0-035 study guide | 1Z0-035 practice exam | 1Z0-035 cram


Killexams HP2-E29 questions and answers | Killexams 000-400 test prep | Killexams 1Z0-141 test prep | Killexams A9 braindumps | Killexams 000-875 study guide | Killexams P2090-075 drill test | Killexams HP0-J11 braindumps | Killexams 000-S01 study guide | Killexams CHFP free pdf | Killexams ST0-247 cram | Killexams FortiSandbox drill exam | Killexams C4040-332 drill test | Killexams 000-973 questions answers | Killexams HP3-045 exam prep | Killexams CRRN exam prep | Killexams HP0-D03 test questions | Killexams 250-422 sample test | Killexams 83-640 VCE | Killexams HP2-B82 cheat sheets | Killexams A2040-986 braindumps |


killexams.com huge List of Exam Study Guides

View Complete list of Killexams.com Brain dumps


Killexams 1Y0-614 cheat sheets | Killexams M9510-726 questions and answers | Killexams 000-N31 exam prep | Killexams C2090-320 drill test | Killexams 700-302 existent questions | Killexams P2060-017 exam questions | Killexams HP3-C40 free pdf | Killexams A6 questions answers | Killexams 70-489 test questions | Killexams P2170-015 dump | Killexams M2035-725 dumps questions | Killexams 1Y1-A19 exam prep | Killexams C9560-505 bootcamp | Killexams HP0-A02 drill exam | Killexams CCD-333 free pdf | Killexams ST0-236 questions and answers | Killexams 642-979 dumps | Killexams 190-273 test prep | Killexams HP2-B119 braindumps | Killexams 132-S-900.7 free pdf download |


Oracle 7.3 and 8 to Oracle9i DBA OCP Upgrade

Pass 4 confident 1Z0-035 dumps | Killexams.com 1Z0-035 existent questions | https://www.textbookw.com/

Keep downtime short on 11i migration: Evaluating which tasks can done before and after | killexams.com existent questions and Pass4sure dumps

This tip is an excerpt from the paper "Keep downtime short on 11i migration" and is brought to you by the International Oracle Users Group (IOUG). Become a member of the IOUG to access the paper referenced here and a repository of technical content created for Oracle users by Oracle users.

Evaluating which tasks can live done before or after censorious downtime

The simplest approach to upgrade Oracle Applications is to exactly supervene the Upgrade Manual. Since the manual lacks instructions for many viable upgrade optimizations, the most essential job is to fade through the all manual, your upgrade arrangement and check which tasks could live accomplished before or after Apps required downtime. A helpful illustration of such activity is application of file system patches during the test upgrade and reusing the patched file system for later production upgrade.

It is not viable to evaluate total the upgrade tasks in this document, but here's a short list with examples about touching (parts of) tasks before or after the upgrade process:

  • Use Oracle's fresh tool, The Upgrade Manual Script (TUMS), to report upgrade tasks which don't fill to live accelerate in your environment. (See metalink note 230538.1)
  • Gather table and index statistics before upgrading in source system. Although 10.7 not champion CBO, they silent can anatomize total needed tables and sustain init.ora parameter optimizer_mode=rule. Then RBO will live used even if statistics exist. This analyzing should live done after data purging or larger updates are done, to fill up-to-date statistics.
  • For example, in Order Management, Shipping Execution and Advanced Pricing you can employ Upgrade Bifurcation feature to upgrade only active transactions during AutoUpgrade process and inactive transactions could live upgraded when fresh system is already in use.
  • Importing, processing and purging data in total kinds of interfaces are measure Applications Upgrade steps, but naturally, these tasks can and should live done before taking down the system. In case there's a continuous feed of transactions into interface tables, they silent should process the majority of records in interfaces during uptime and the leisure few ones when taken down the system for upgrade.
  • Few smaller issues, fancy installing online abet could live done after the system has gone live, but there are other restrictions fancy users who fill just started using the fresh system, likely need this abet system pretty much.
  • If you need to add any fresh languages to fresh system, it'd live reasonable to Do it afterwards, when your fresh system is already in employ and proved to live working. Otherwise you need to apply patches for more languages during the upgrade, thus having longer downtime. If converting character set to UTF-8, it should live done after Applications is successfully upgraded to 11i.
  • Any data issues establish during test cycles should live fixed in production as well, so that they would live fixed before they start production upgrade.
  • Purging or archiving brokendown and unnecessary data before any upgrade. The less data to upgrade, the faster the upgrade.
  • Also, total the customizations and interfaces aren't required immediately on the first minute after going live with fresh system. It might live reasonable to schedule less essential and less used customizations to live implemented later on, after successfully gone live with the core functionality. On the other hand, if using an automated system for applying the customizations, the all process usually won't steal too much time (it is smooth to create a script which copies total the custom forms/reports in place, creates triggers, etc).

    Downtime planning

    It's always a helpful understanding to check for any national holidays and arrangement Applications downtime over weekend and holiday if possible, thus keeping the non-availability repercussion to the trade minimum. Of course this activity doesn't curtail the hours spent on migration nor would abet much in an international installation or 24x7x365 scenarios, but it is definitely worth considering in most upgrade cases. For illustration even though the manufacturing has to travail 24x7, the pecuniary department doesn't travail during national holidays – the actual price of downtime will live lower.

    Database migration to applications' certified versions

    Many Applications 10.7 sites are silent running on desupported 7.3 or 8.0 Oracle Server versions databases, so the first major job during an upgrade is to accumulate total the data to new, certified release of database server. Currently, the choices vary from version 8.1.7 to 9.2.

    There are several ways to migrate data to the fresh version database, but the most essential question regarding upgrade downtime is, whether to Do the database upgrade prior to censorious downtime age or within it. Both ways fill their pluses and minuses, there's again tradeoff between downtime and preparation time, the shorter you want the first, the more you'll fill to spend on second.

    Upgrading database prior to applicaitons

    Upgrading Oracle database before Oracle Applications can abet to reduce several hours of downtime during the production migration, especially if the export/import upgrade path is chosen. Even using the mig utility for database migration, can steal several hours to recreate the dictionary and other objects, thus if downtime price is high, they need to spread database upgrade's downtime to a week or two prior Applications censorious downtime. This is mostly the case, when weekend/night downtime is cheaper than during daytime, thus having a point in spreading downtime to multiple parts. Upgrading database prior to Appications itself has other advantages, fancy skill to anatomize tables and indexes during uptime, in working system.

    Here arises one more essential issue, if you are upgrading Apps version lower than 11.5.3 and you want to employ database version 9i. Oracle has certified its Applications on 9i starting from version 11.5.3.

    A quote from Metalink Certify section:

    Oracle9i: There are no plans to certify Oracle9i on release 11.5.3 or lower, including Releases 11.0.3 & 10.7.

    So, if you are planning to upgrade to database version 9i, you shouldn't sever the database and applications upgrade, because versions 10.7 and 11.0 aren't certified with 9i database configuration, thus introducing additional problems and risks. If you are planning to accelerate on 8.1.7, there isn't going to live a problem, because both 10.7 and 11.0 accelerate on 8i fine. Though, since Oracle 9i Release 2 is getting stable enough now, upgrading to 9i R2 is recommended. Of course, it is viable to upgrade (or keep) existing database on 8i, accelerate brokendown Apps on 8i at first, then execute the Apps upgrade using 8i, and switch to 9i later on, when needed. This greatly increases complexity, but can eliminate or spread up several hours of censorious downtime for upgrading database and analyzing tables, while silent keeping the certified version compatibility between Apps and database.

    Upgrading database with applications

    This is probably the cheapest course of upgrading in sense of overall project efforts. The brokendown Applications' database is migrated within the production upgrade downtime. Since total major changes, both in database and Applications are done in a row, no double testing distress is needed, but the downtime is going to live longer. In some international 24x7 used environments this approach to fill larger downtime once, than shorter downtime twice, can live even better, because there's not much disagreement in any time of day or week.

    Database upgrade with export/import routine to a fresh database

    Applications version 11i requires minimum database hide size to live 8k, thus in several cases Applications database has to live recreated if brokendown one has smaller hide size. Reorganizing database using exp/imp has other advantages as well, fancy optimizing table storage usage, index rebuilding, also they are able to employ locally managed tablespaces already from start, not having to transmute from DMTs.

    But the major drawback is increased downtime: the all database has to live exported to an exportfile, then imported back to fresh one, total indexes fill to live recreated, etc. If you fill decided or fill to fade with export/import, there's one trick, which can abet us to curtail downtime caused by import.

    The main understanding is to export and import the analytic structure of database to fresh server even before the upgrade starts. Naturally they fill already created the fresh bare database to fresh location, with total its datafiles with sizes measured accurate during test cycles, controlfiles, redos, etc. Since upgrading with exp/imp routine involves exporting and importing the plenary database, they can actually transfer the analytic structure (table definitions, packages, triggers, etc) to fresh database using exp and imp options rows=n. This can curtail downtime considerably, since creating packages, table definitions and others can also steal considerable amount of time. Since they transfer total data (rows + possibly LOBs) afterwards, they will fill consistent and up to date information in target system. The Applications configuration should live frozen after exporting the analytic structure, no DDL changes to database should live allowed. To verify whether any protest definitions fill changed after export in source database, they can employ dba_objects view's column last_ddl_time. Following query will justify total objects which fill changed in last 24 hours due DDL on them.

    select owner, object_name, object_type from dba_objects where last_ddl_time > sysdate - 1;

    In rare cases, as some customizations, objects are dropped and recreated regularly, thus they'll justify up as recently modified. It's usually enough to verify whether the definition of the protest in fresh database silent matches the one in source environment. Also, you might want to Do viable DDL changes in database (such as TUMS patch, etc) before the export, to avoid confusion with comparing schemas afterwards.


    Oracle® Database | killexams.com existent questions and Pass4sure dumps

    Readme

    10g Release 2 (10.2)

    B14233-06

    February 2008

    Purpose of this Readme

    This Readme file is germane only to the delivered Oracle Database 10g Release 2 (10.2) product and its integral parts, such as SQL, PL/SQL, the Oracle convoke Interface (OCI), SQL*Loader, Import/Export utilities, and so on.

    This Readme documents differences between the server and its integral parts and its documented functionality, as well as known problems and workarounds.

    Operating system releases, such as UNIX and Windows, often provide readme documents specific to that operating system. Additional Readme files may also exist. This Readme file is provided in lieu of system bulletins or similar publications.

    Welcome epistle and Licensing

    Please read the welcome epistle included with your Oracle Database 10g Release 2 (10.2) package.

    Documentation

    For further documentation, behold the plenary list of books provided with this release, or refer to:

    http://oracle.com/technology/documentation

    Contents

    Section 1, "Compatibility, Upgrading, and Downgrading"

    Section 2, "Default deportment Changes"

    Section 3, "Automatic Storage Management"

    Section 4, "Block Change Tracking"

    Section 5, "Configuration Assistants"

    Section 6, "Database Control"

    Section 7, "Database Security"

    Section 8, "Encryption and Integrity"

    Section 9, "Java and Web Services"

    Section 10, "Media Management Software"

    Section 11, "Oracle Change Management"

    Section 12, "Oracle Data Guard"

    Section 13, "Oracle Data Mining"

    Section 14, "Oracle HTML DB"

    Section 15, "Oracle interMedia"

    Section 16, "Oracle Internet Directory"

    Section 17, "Oracle-Managed Files"

    Section 18, "Oracle Net Services"

    Section 19, "Oracle existent Application Clusters"

    Section 20, "Oracle existent Application Testing"

    Section 21, "Oracle Sample Schemas"

    Section 22, "Oracle ODBC Driver"

    Section 23, "Oracle Gateways Installation"

    Section 24, "Oracle Spatial"

    Section 25, "Oracle Text"

    Section 26, "Oracle XML Developer's Kit"

    Section 27, "Oracle XML DB"

    Section 28, "PL/SQL"

    Section 29, "Pro*C"

    Section 30, "Pro*COBOL"

    Section 31, "Pro*FORTRAN"

    Section 32, "Replication"

    Section 33, "SQLJ"

    Section 34, "SQL*Module for ADA"

    Section 35, "SQL*Plus"

    Section 36, "Summary Management"

    Section 37, "Streams"

    Section 38, "Time Zones"

    Section 39, "Types"

    Section 40, "Utilities"

    Section 41, "Documentation Addendum"

    Section 42, "Open Bugs"

    Section 43, "Documentation Accessibility"

    1 Compatibility, Upgrading, and Downgrading

    The following sections narrate items for compatibility, upgrading and downgrading.

    For late-breaking updates and best practices about preupgrade, post-upgrade, compatibility, and interoperability discussions, behold Note 466181.1 on OracleMetalink (https://metalink.oracle.com/) that links to "The Upgrade Companion" web site.

    1.1 measure Edition Starter Database Upgrade

    When the measure Edition starter database is upgraded, the following components cannot live upgraded by the SE server because they require options that are not installed in the measure Edition:

  • Oracle Data Mining

  • Spatial

  • OLAP Catalog

  • OLAP Analytic Workspace

  • Oracle OLAP API

  • After the upgrade, these components will fill a STATUS value of 'OPTION OFF' in the DBA_REGISTRY view, and there will live some invalid objects in the associated component schemas. The Database Upgrade aide will justify unsuccessful upgrades for these components.

    1.2 Tablespace Sizing

    The Oracle Database 10g Pre-Upgrade Information Utility (utlu102i.sql) estimates the additional space required in the SYSTEM tablespace and in any tablespaces associated with the components that are in the database (for example, SYSAUX, DRSYS). For a manual upgrade, live confident to accelerate this utility on your existing database prior to upgrading.

    To avoid potential space problems during the upgrade, you can set one data file for each tablespace to AUTOEXTEND ON MAXSIZE UNLIMITED for the duration of the upgrade. The Pre-Upgrade Information Utility does not currently appraise UNDO tablespace utilization during the upgrade. The total amount of UNDO tablespace required to accelerate the upgrade scripts depends upon the UNDO_RETENTION initialization parameter and other UNDO options in effect.

    If you are using Automatic Storage Management (ASM), live confident there is adequate space in the ASM disk groups for the total tablespace sizes estimated by the utlu102i.sql utility.

    1.3 JServer JAVA Virtual Machine Upgrade

    The JServer NCOMP files, JAccelerator, are now on the companion products installation media. If JServer is in the database that is being upgraded, the following oversight will occur during a manual upgrade, provided JServer is not installed:

    ORA-29558: JAccelerator (NCOMP) not installed. refer to install steer for instructions.

    JAccelerator can live installed either before or after the upgrade; installing it prior to the upgrade avoids the error.

    This oversight will not live displayed if you are upgrading using the Database Upgrade aide (DBUA). Instead, DBUA shows a warning message at the finish of the upgrade in the Upgrade Results page, stating which components should live installed from the companion products installation media.

    1.4 Upgrading Databases with interMedia, Spatial, or XDK for Java

    Oracle interMedia, Oracle Spatial, and Oracle XDK for Java employ the Oracle XML DB. If any of these components are installed with the database, Oracle XML DB will live automatically installed to champion them.

    1.5 Compatibility with Oracle8i Database

    Connection of Oracle Database 10g release 2 client or server to Oracle8i Database release 8.1.7 servers is supported. Similarly, connecting Oracle8i Database servers to Oracle Database 10g release 2 servers is supported.

    1.6 Upgrading XML Developer's Kit PL/SQL Code

    When you employ PL/SQL packages DBMS_XMLDOM, DBMS_XMLPARSER, and DBMS_XSLPROCESSOR with XML documents that reference Document type Definition (DTD) documents or XML Schema documents, the referenced documents must reside as resources in Oracle XML DB Repository.

    Note:

    In releases prior to Oracle Database 10g Release 2 (10.2), this restriction did not apply. To upgrade germane Oracle XML Developer's Kit PL/SQL code from previous releases:
  • Add total referenced DTD and XML-Schema documents to the repository.

  • For each XML document that references one of the type-definition resources mentioned in (1): If the reference is a relative path, then change it to an absolute path.

  • 1.7 Enabling Automated Backups

    While installing Oracle Database, the Specify Backup and Recovery Options screen may materialize truncated if your system does not fill the required fonts installed. If your system has only fixed-width fonts, you may not live able to fully specify the required information in the Backup Job Credentials zone of the screen. To travail around this issue, Do not select Enable Automated Backups on this screen. After the installation is complete, employ Oracle Enterprise Manager 10g Database Control to enable automated backups.

    2 Default deportment Changes

    This section describes some of the differences in deportment between Oracle Database 10g and previous releases. The majority of the information about upgrading and downgrading is already included in the Oracle Database Upgrade Guide.

    Log Transport Services Password

    Log transport services now require that total databases in an Oracle Data Guard configuration employ a password file. The password for the SYS user must live identical in the password file of every system that is in the identical Oracle Data Guard configuration. For more details, refer to Oracle Data Guard Concepts and Administration.

    Offset for CLOB and NCLOB APIs

    Starting with Oracle Database 10g Release 1 (10.1), APIs that write to a CLOB or NCLOB will reason oversight ORA-22831 when the offset specified for the dawn of the write is not on a character boundary in the existing LOB data.

    LOB APIs employ UCS2 codepoint semantics for the amount and offset parameters on CLOBs or NCLOBs when the database default or national character set is multibyte or varying width. For example, if the starting offset is in the middle of a surrogate pair, oversight ORA-22831 occurs and the data is not written. This avoids corrupting the character in the target LOB.

    To configure the database so that it does not fling ORA-22831, you can set event 10973 to any level. When this event is set, data is written to the target LOB regardless of whether the offset is on a character boundary. Note that when supplemental logging is enabled, setting event 10973 does not disable oversight ORA-22831.

    LOG_ARCHIVE_DEST_n Parameter

    The LOG_ARCHIVE_DEST_n parameter can now live used to specify a local archiving destination on a database instance running Oracle measure Edition. Previously, this parameter could only live specified on a database instance running Oracle Enterprise Edition.

    PARALLEL_ADAPTIVE_MULTI_USER Parameter

    The default value of the initialization parameter PARALLEL_ADAPTIVE_MULTI_USER has changed. behold Oracle Database Reference for details.

    QUERY_REWRITE_ENABLED Parameter

    The default value of the initialization parameter QUERY_REWRITE_ENABLED has changed. behold Oracle Database Reference for details.

    SHARED_POOL_SIZE Parameter

    The amount of shared pool recollection allocated by previous Oracle Database releases was equal to the sum of the value of the SHARED_POOL_SIZE initialization parameter and the internal SGA overhead computed during instance startup. This overhead was based on the values of several other initialization parameters. As an example, if the SHARED_POOL_SIZE parameter is 64m and the internal SGA overhead is 12m, the existent size of shared pool in the SGA would live 76m, although the value of the SHARED_POOL_SIZE parameter would silent live displayed as 64m.

    Starting with Oracle Database 10g release 1, the size of internal SGA overhead is included in the value of SHARED_POOL_SIZE parameter; the shared pool recollection allocated at startup is exactly the value of SHARED_POOL_SIZE. Therefore, this parameter must live set such that it includes both the internal SGA overhead and the desired efficient value of the shared pool size. Assuming that the internal SGA overhead remains unchanged, the efficient available value of shared pool after startup would live 12m less than the value of the SHARED_POOL_SIZE parameter, or 52m. To maintain 64m for the efficient value of shared pool memory, set the parameter to 76m.Migration utilities for this release recommend fresh values for SHARED_POOL_SIZE based on the value of internal SGA overheads in the pre-upgrade environment, which you can determine by running the following query before upgrading to Oracle Database 10g:

    SQL> SELECT SUM(BYTES) FROM v$sgastat WHERE pool = 'shared pool';

    In Oracle Database 10g, the exact value of internal SGA overhead, or Startup overhead in Shared Pool, is listed in the fresh v$sgainfo view.

    In the manual SGA mode, values of SHARED_POOL_SIZE that are too minuscule to accommodate the internal SGA overhead result in an ORA-00371 oversight during startup. This generated oversight message includes a suggested value for the SHARED_POOL_SIZE parameter.If you are using automatic shared recollection management, the size of the shared pool is tuned automatically, and the ORA-00371 oversight is never generated.

    SHARED_SERVERS Parameter

    When the initialization parameter SHARED_SERVERS is dynamically changed to 0, no fresh clients can connect in shared mode, but existing shared server connections can continue to operate. Prior to Oracle Database 10g, existing shared server connections would hang in this situation.

    3 Automatic Storage Management

    Please note the following when working with Automatic Storage Manager.

    3.1 ASM Non-Interactive Mode

    When using the non-interactive mode of the ASMCMD utility on UNIX platforms, employ the percent symptom (%) as the wildcard character instead of the asterisk (*). In interactive mode, both wildcard characters are supported.

    3.2 File Redundancy

    The redundancy-lowered column in particular of V$ASM_FILE view can fill one of the 3 values U, Y, or N for Unknown, Yes, or No, respectively. In the following cases ASM instance would unable to note if the redundancy of a file is compromised or not.

  • Files were created using Oracle Database 10g release 1 Automatic Storage Manager software.

  • Newly-created files start out in an unknown state. This bug will live fixed in the first patch set.

  • The V$ASM_FILE views' redundancy_lowered column transitions from being unknown (U) to either Y or N when the storage configuration of the diskgroup is changed. For example, when adding, dropping or resizing, the disks in the diskgroup will update total the files that are affected. The user can trigger these updates by executing ALTER DISKGROUP CHECK or ALTER DISKGROUP REBALANCE.

    See Also:

    Oracle Database Administrator's steer for information about reduced-redundancy files. 4 hide Change Tracking

    Please note the following change in hide change tracking:

    4.1 hide Change Tracking and Physical Standby Database

    Block Change Tracking can live enabled at a physical standby database. However, you should note that changed blocks are not recorded, and incremental backups will not live faster during the physical standby as they are receiving and applying redo transactions from the primary database.

    When the physical standby becomes a primary database, changes are once again recorded. Following the subsequent smooth 0 backup, incremental backups steal odds of change tracking.

    5 Configuration Assistants

    Please note the following when working with configuration assistants.

    5.1 NET Configuration aide (NETCA)

    During creation of a 10.2.0.1 RAC database or upgrade of a 10.1.0.x RAC database, NETCA may live accelerate to migrate listeners from the 10.1.0.x Oracle home to 10.2.0.1 Oracle home. If for some reason, migration fails on remote nodes, database creation or upgrade will succeed. However, listeners may not fill been configured on the remote nodes where failure occurred. execute one of the following workarounds to resolve this.

  • Resolve the problem condition and rerun NETCA migrate on any failed node as netca /migrate /nodeinfo <comma separated list of remaining nodes>.

  • Run NETCA in standalone mode to delete any existing listeners on the failed nodes and recreate 10.2.0.1 listeners.

  • 5.2 Creating Multiple Databases with Database Configuration aide (DBCA)

    Starting in Oracle Database 10g Release 2 (10.2), DBCA allocates 40% of total RAM to each instance by default, which is internally divided into SGA_TARGET and PGA_AGGREGATE_TARGET. If you are creating a database with other database instances running on your machine, you may accumulate oversight "ORA-27102: out of memory". If you arrangement to accelerate multiple databases on the identical machine, you may need to modify the default recollection parameter settings. If you create a database as allotment of install, select the Advanced option on the Select Database Configuration page of the Oracle Universal Installer, which launches DBCA interactively so you can customize recollection parameters.

    6 Database Control

    Please refer to the Oracle Enterprise Manager 10g Database Control Readme, at:

    $ORACLE_HOME/relnotes/readmes/EM_db_control.htm 6.1 Network Utilization Metrics Not Displayed

    Database Control should array the following network utilization metrics for each network interface:

  • Network Interface Combined Utilization (%)

  • Network Interface Read Utilization (%)

  • Network Interface Write Utilization (%)

  • If these metrics are not displayed for a particular network interface, create the $ORACLE_HOME/sysman/config/network_speed file and enter the network interface cognomen and speed in the file as follows. In this example, interface is the network interface cognomen and speed is the speed of the interface in megabits per second (Mbps):

    interface_name speed

    For example, if the eth0 network interface does not array metrics, create the $ORACLE_HOME/sysman/config/network_speed file and enter the following, where 100 is the network speed in Mbps:

    eth0 100 7 Database Security

    Please note the following changes in Database Security.

    7.1 FAILED_LOGIN_ATTEMPTS Default Changed

    As of Oracle Database 10g release 2, the restrict for FAILED_LOGIN_ATTEMPTS for the DEFAULT profile is 10. Prior to release 10.2, the default was UNLIMITED.

    7.2 Desupport of Oracle DCE Integration

    Beginning in Oracle Database 10g release 2, Oracle Advanced Security option will no longer champion integration with the Distributed Computing Environment (DCE).

    7.3 CONNECT Role Privileges Removed

    In Oracle Database 10g Release 2 (10.2) the CONNECT role only contains the CREATE SESSION privilege. Making this change enables fresh and existing database customers to implement helpful security practices more easily. Applications that depend on the CONNECT role to create tables, views, sequences, synonyms, clusters, or database links, or applications that employ the ALTER SESSION command dynamically, may fail due to insufficient privileges.

    See Also:

    Appendix A of the Oracle Database Security Guide, for a discussion of viable customer impacts and approaches to dealing with the CONNECT role changes 7.4 Scheduler External Jobs Security

    In Oracle Database 10g Release 2 (10.2), a fresh privilege, CREATE EXTERNAL JOB has been added which will now live required for database users to execute jobs that accelerate on the operating system outside of the database. During upgrade from Oracle Database 10g release 1 this privilege is granted to total users who already fill the CREATE JOB privilege.

    For improved security, Oracle recommends that after an upgrade to Oracle Database 10g Release 2 (10.2), DBAs revoke the CREATE EXTERNAL JOB privilege from total users who Do not explicitly require it.

    7.5 Changes in Default Security Settings

    Java class oracle.security rdbms.server.AppCtx will live deprecated in future Oracle Database releases.

    7.6 Enterprise User Security

    Databases with different methods of authenticating to Oracle Internet Directory cannot participate the identical ldap.ora file.

    If these databases employ the identical $ORACLE_HOME, one of them should fill a sever TNS_ADMIN directory with its own ldap.ora file (Bug 3327626).

    8 Encryption and Integrity

    Oracle recommends the employ of SHA-1 for data integrity for protected communication between clients and servers. Using MD5 in cipher suites that affect short-timed transactions such as during SSL/TLS authentication or using keyed MD5 for one-way hash stores and using MD5 in SSL/TLS protocols fill not been identified as being vulnerable at this time.

    9 Java and Web Services

    Please note the following items when working with Java.

    9.1 JavaVM

    The JavaVM readme file is located at:

    $ORACLE_HOME/javavm/doc/readme.txt 9.2 JDBC

    For Instant Client operation of the JDBC Driver, the following files must live copied from the $ORACLE_HOME/jdbc/lib directory:

  • classes12.jar if JDK 1.2 or 1.3 will live used

  • orai18n.jar for Globalization and NLS support

  • ocrs12.jar for Oracle JDBC rowset implementation

  • The JDBC readme file is located at:

    $ORACLE_HOME/jdbc/Readme.txt 9.3 JPublisher

    The JPublisher software, including Database Web services, is provided on the installation media.

    The JPublisher readme is at the following locations:

    $ORACLE_HOME/sqlj/READMEJPub.txt $ORACLE_HOME/sqlj/READMEJPub.html 9.4 Web Services

    As an alternative to Oracle Net, Oracle Database Web services provides non-connected access to the database through measure Web services mechanisms. These embrace XML, SOAP, and WSDL, and can whirl the database into a Web services provider. Similarly, the database itself can act as a Web service consumer and invoke external Web services. essential features of Web services include:

  • A JAX-RPC based SOAP Client library supports invocation of external Web services from within the database, and applies the power of SQL to the results.

  • Web Services Call-In: Deploying a JPublisher-generated Java class against Oracle Application Server 10g enables you to invoke database operations fancy Java and PL/SQL procedures and packages, SQL queries, and DML operations.

  • Web Services Call-Out: Deploying a JPublisher-generated Web services client from a WSDL and its PL/SQL wrapper supports invocation of external Web services from within the database.

  • 10 Media Management Software

    Oracle Database 10g release 2 includes Oracle Backup software to provide tape backups of your Oracle Database and other censorious Oracle infrastructure. Oracle Backup is fully integrated with Recovery Manager (RMAN) to provide data protection services for one or more databases in a networked environment. Oracle Backup differs from Oracle's previously bundled media management software, Legato sole Server Version (LSSV), in the following ways:

  • Oracle Backup does not restrict the types of devices that may live used.

  • Oracle Backup does not restrict the number of devices that may live used.

  • Oracle Backup is supported for non-database file backups, for files such as your Oracle home. LSSV is supported only for RMAN-based database file backups.

  • Oracle Backup can operate in a networked environment. LSSV is constrained to operate on a sole host.

  • Oracle no longer bundles LSSV.

    10.1 Limited Globalization champion for Oracle Backup

    The following globalization restrictions apply to Oracle Backup:

  • The Oracle Backup command line interface is English only and is not globalized. It does not champion localizations or multi-byte character set data. total messages are in English.

  • Those portions of the Oracle Backup graphical user interface (GUI) that are exposed through Oracle Database Control are globalized and are translated to local languages. However, any information passed between the command line and Database Control is in English only.

  • Older graphical interfaces to Oracle Backup, other than the Database Control interface, are English only.

  • Oracle Backup does not champion backups of file system files whose names are encoded in character sets that Do not champion null-termination, such as Universal Character Set (UCS).

  • Oracle Backup does not champion RMAN database backups when the backup names are encoded in character sets that Do not champion null-termination, such as UCS.

  • 11 Oracle Change Management

    Quick Tour is not available in Oracle Change Management Pack. If you try to accelerate it, then an oversight results.

    12 Oracle Data Guard

    Please refer to Note 278521.1 on Oracle MetaLink for information and instructions on upgrading a primary database and a physical standby database from Oracle Database release 9.2 to release 10.1. For information and instructions for upgrading a analytic standby please refer to Note 278108.1.

    12.1 Fast-Start Failover

    A Fast-Start Failover will fail if the observer cannot restart the fresh primary database. This can happen, for instance, if the <db_unique_name>_DGMGRL service cognomen has not been statically registered with the listener as documented in Chapter 2 of the Oracle Data Guard Broker manual. If the observer cannot restart the fresh primary database, the observer will shut down and it cannot live restarted until the following steps fill been completed:

  • Start and mount an instance of the fresh primary database.

  • Wait for the Broker to open the fresh primary database instance.

  • Start and mount an instance of the brokendown primary database.

  • Run DGMGRL and connect to the fresh primary database.

  • Issue the REINSTATE DATABASE <old primary db_unique_name> command to transmute the brokendown primary database to a standby database.

  • Issue the stop OBSERVER command. You must Do this step even if the observer is not running to live able successfully restart the observer.

  • Restart the observer.

  • In rare cases, the observer may fail to automatically reinstate the brokendown primary database. If this happens, accelerate DGMGRL, connect to the fresh primary database, and then issue the REINSTATE DATABASE <oldprimary db_unique_name> command.

    12.2 DDL Statements that employ DBLINKS

    On analytic standby databases, avoid using SQL statements such as CREATE TABLE tablename AS SELECT * FROM bar@dblink as they may fail.

    When a statement is executed on the analytic standby database, it will access the database link at that time. It is not viable to know if the information on the analytic standby database is the identical as it was at the time the statement was executed on the primary database. For example, additional columns may fill been added or dropped; this can submit it impossible to apply the rows that follow. Assuming that the network was set up so that the initial creation succeeded, you may behold the following error: ORA-26689: column datatype mismatch in LCR for a table containing nested table columns. Also, the ORA-02019: connection description for remote database not establish oversight may live returned if the database link or the TNS service was undefined on the analytic standby database.

    When this happens, employ the DBMS_LOGSTDBY.INSTANTIATE_TABLE procedure for the table being created, and then restart SQL APPLY operations.

    12.3 analytic Standby Databases on the identical Node as the Primary Database

    If a analytic standby database is located on the identical computer system as the primary database, it is likely that both Oracle Database instances fill access to the identical directory structure. There are Oracle Database commands that reuse datafiles. If Oracle Database commands that reuse datafiles are applied on the primary database, the commands may also live applied on the analytic standby database. If that happens while the primary database is shut down, it is viable for the analytic standby database to pretense the file as allotment of its database and possibly reason damage to the primary database.

    For this reason only, Oracle recommends using the following settings when running the primary and analytic standby databases on the identical computer system:

    EXECUTE DBMS_LOGSTDBY.SKIP('ALTER TABLESPACE'); 12.4 analytic Standby Stops with oversight ORA-00955

    When this oversight occurs, check the alert log for the following output:

    LOGSTDBY stmt: Create table anyddl.anyobj... LOGSTDBY status: ORA-16542: unrecognized operation LOGSTDBY status: ORA-16222: automatic analytic Standby retry of last action LOGSTDBY status: ORA-16111: log mining and apply setting up LOGSTDBY stmt: Create table anyddl.anyobj... LOGSTDBY status: ORA-00955: cognomen is already used by an existing protest

    The initial attempt to apply the DDL actually completed, but failed to live recorded. The ORA-16542 oversight identifies this problem.

    You can restart the analytic standby database using the following command:

    ALTER DATABASE START analytic STANDBY APPLY SKIP FAILED TRANSACTION; 12.5 ALTER DATABASE GUARD Issues on Oracle existent Application Clusters

    For analytic standby databases running on an Oracle existent Application Clusters system, you must issue the ALTER DATABASE GUARD statement on each active instance for it to live efficient on total instances in the cluster.

    12.6 Defining Destinations for Standby Log Files When Using a glimmer Recovery zone with analytic Standby Databases

    If you fill enabled a glimmer recovery zone on a analytic standby database, you must set the following initialization parameters:

  • Define the STANDBY_ARCHIVE_DEST parameter to point to a location other than the glimmer recovery area. Doing so ensures that redo data received from the primary database is not archived in the glimmer recovery area.

    For example, when creating a analytic standby database as described in Section 4.2.3.2 of Oracle Data Guard Concepts and Administration, define the following parameter on the analytic standby database: STANDBY_ARCHIVE_DEST='/arch2/boston/'

  • Define a LOG_ARCHIVE_DEST_n parameter and embrace the LOCATION and the VALID_FOR=(STANDBY_LOGFILES, STANDBY_ROLE) attributes to direct archiving of standby redo log files to a destination that is not the glimmer recovery area. For example,

    LOG_ARCHIVE_DEST_3= 'LOCATION=/arch2/boston/ VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=boston'
  • In addition, Oracle recommends that you set the identical initialization parameters on the primary database to prepare it for a future switchover:

  • Define the STANDBY_ARCHIVE_DEST to point to a location other than the glimmer recovery area.

    For example, when creating a analytic standby database as described in Section 4.2.2.2 of Oracle Data Guard Concepts and Administration, define the following parameter on the primary database: STANDBY_ARCHIVE_DEST='/arch2/chicago/'.

  • Define a LOG_ARCHIVE_DEST_n parameter and embrace the LOCATION and the VALID_FOR=(STANDBY_LOGFILES, STANDBY_ROLE) attributes to direct archiving of standby redo log files to a directory that is not the glimmer recovery area. For example,

    LOG_ARCHIVE_DEST_3= 'LOCATION=/arch2/chicago/ VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=chicago'
  • 12.7 Database Guard Stays On In the fresh Primary Database If a Prepared Switchover Operation Detects a Network Outage

    If a analytic standby database performs a switchover to the primary database role running in maximum protection mode, and the LGWR process encounters an oversight with a destination, LGWR will re-evaluate total destinations to ensure at least one of them is working properly.

    If the LGWR process does not find a destination to which it can successfully write the standby redo log file, and if it does not accommodate any missing log files, or gaps, then the primary instance shuts down. Although the switchover completes successfully, the database guard remains enabled to prevent data divergence.

    The solution, which appears in the alert log for the database instance, is to:

  • Start the database in a lower protection mode, such as maximum performance.

  • Manually disable the database guard by issuing the ALTER DATABASE GUARD not a soul command.

  • 12.8 Max Protection Switchover With a Bystander analytic Standby

    When performing a zero data loss switchover in a maximum protection configuration that involves more than one analytic standby database, sustain the following items in mind:

  • Ensure that total transport settings (specified by the LOG_ARCHIVE_DEST_n parameters on the current primary database) for analytic standby instances not participating in the switchover are set to ARCH, not LGWR, for the duration of the switchover.

  • After the transport setting is modified, but before the switchover operation, execute an ALTER SYSTEM ARCHIVE LOG CURRENT to ensure that any active standby redo logfiles are archived.

  • Once the switchover is complete, the destination setting for the bystanders should live changed back to the LGWR transport mode.

  • 12.9 Enable Flashback Database on total Databases in a Data Guard Configuration

    Oracle recommends that flashback database live enabled on total databases in a Data Guard configuration. This is particularly essential on standby databases that Do not employ a log apply delay.

    13 Oracle Data Mining

    The file dmREADME.txt in $ORACLE_HOME/rdbms/demo/ is obsolete. For complete and up-to-date instructions for using the Oracle Data Mining sample programs, behold the Oracle Data Mining Administrator's Guide.

    14 Oracle HTML DB

    Please note the following items when working with Oracle HTML DB.

    14.2 Rendering Select Lists in a Report or Tabular Form

    You can employ the HTMLDB_ITEM package to render select lists in a report or tabular form by making direct calls to HTMLDB_ITEM.SELECT_LIST or by applying unavoidable array types to report columns. Note that this type of select list cannot exceed 32K characters. also note that selecting too many options may result in the select list not rendering correctly.

    In Oracle HTML DB 1.5.1, select lists rendered using this approach did not embrace closing OPTION tags for each option. Closing OPTION tags for each option are now included in Oracle HTML DB 1.6, reducing the number of options allowed in a select list. The actual change in the number of options depends on the length of the option text strings. This also affects pagination if the row ranges in select list style is chosen. If the number of allowed options is reached, the pagination style changes to X-Y of Z without using a select list.

    14.3 Escaping Special Characters Rendered from Session State

    Page and application items can fill their session status values established using a URL or in POSTDATA. In release 1.6, the HTML DB engine escapes these values for two detail types when it saves them in session state.

    14.3.1 detail Types Escaped on Input

    To accomplish this, the HTML DB engine converts commonly used characters to entity references. For example, the HTML DB engine converts the less than symptom (<) to &lt;. This rule applies to two types of items:

  • Page items of type array as text (does not save state)

  • Application smooth items (that is, items that are not associated with a particular page)

  • The objective of this change is to protect your application from cross site scripting (XSS) security attacks for detail types that are not escaped during rendering. Developers may continue to store escapable characters into any type of detail by setting those detail values internally within the page (for example, using page processes, computations, or queries). However, attempts to externally set the values of application items or page items of type array as text (does not save state) will result in their values being escaped when they are saved in session state. live awake that setting these types of items to text containing HTML or Java Script from outside the application (for example, using the URL) is a hazardous practice.

    Note that you may fill problems with existing pages if they depend on the previous deportment (that is, no items values being escaped on input.) viable examples include:

  • When escapable input characters are passed into session status using a URL or POSTDATA for page items of type array as text (does not save state) and are to live rendered as form items on the page without being escaped. In release 1.6 the values will live escaped on input and thus will not render correctly.

  • When escapable input characters are passed into session status using a URL or POSTDATA for application items or for page items of type array as text (does not save state) and are referenced in HTML regions using &ITEM_NAME. syntax and are expected to live rendered exactly as they were represented on input. For example, the string A<B passed into page detail P1_ITEM in the URL would live stored as A&lt;B and would live rendered incorrectly as A&lt;B.

  • To fix these types of pages:

  • Set the content of page items of type array as text (does not save state) using detail default source values, page processes, or computations instead of setting them using the URL method. In this course values will not live escaped when stored in session status and the values will not live escaped during rendering as form items.

  • Set the content of application items or page items of type array as text (does not save state) using page processes or computations instead of setting them using the URL method. In this course values will not live escaped when stored in session state. These values will, however, live escaped during rendering in the HTML region, just as they were in prior releases, so that the less than symptom (<) will materialize as the less than symptom (<) and will not live interpreted as a special character by the browser.

  • 14.3.2 detail type Escaped on Output

    Page items of type array as Text (saves state) are escaped on output when rendered as form items on a page. The purpose of this change is to remedy a bug that caused these items to not live escaped. The fresh deportment makes this form detail array type consistent with other form detail array types.

    Note that you may also fill problems with existing pages if they depend on the previous deportment (that is, where form items of type array as Text (saves state) were not escaped during rendering.) For example, you may fill problems with a page with items that containing escapable characters used for HTML markup.

    To remedy this type of situation:

  • Change the detail type to array as text (does not save state).

  • If there is a requirement to submit the value in POSTDATA, adjust the page design to achieve the desired results without introducing XSS exposures.

  • 14.4 Restoring Indented Values in a Report Column

    Earlier releases of Oracle HTML DB stripped total HTML tags from query column values when those columns where used in HTML expressions and links. In Oracle HTML DB 1.6, you can disable this deportment by turning off the denude HTML attribute on the Report attribute page. By default, this attribute is enabled so that applications developed in earlier releases will behave the identical course after upgrading.

    In release 1.6, stripping of HTML tags also includes NBSC evade characters. This type of character is used in some applications to indent link values in a report column. You can restore the indent after upgrading, by editing your report and setting the denude HTML attribute on the Report attribute page to No.

    14.5 Implementing Themes in an Application Migrated from Earlier Releases

    Oracle HTML DB release 1.6 introduces the concept of themes. A theme is a analytic group and classification of templates within an Oracle HTML DB application. The HTML DB engine maps templates between different themes using classes. Because this functionality did not exist in previous releases, live awake of the following issues before trying to utilize themes in an application created in a previous release.

    When you import an application into release 1.6 from an earlier release, Oracle HTML DB groups total the templates in the application into a theme named Application Theme.

    Before switching the theme of an application developed in an earlier release you must:

  • Edit each template in your application and allot it the appropriate class.Both the theme you are switching from and the theme you are switching to must accommodate the identical classes. If you fill a template that does not drop within a predefined class, you can employ a custom class. Each template type has eight custom classes.

  • Review the default templates (and template classes) in the theme you are switching from and the theme you are switching to. You can review the default templates defined in a theme on the Define Theme page.Note that failing to execute this step may result in unexpected results. For example, you might accelerate into problems if one theme has a default page template that is one-level template while another has a default page template which is a two-level template.

  • If you switch an application theme and it does not render correctly:

  • Verify that the default templates for the active theme are set correctly.

  • Check that the templates within the active theme fill the remedy template classifications.

  • 14.6 About Column attribute Format in Japanese

    When you open the number or date format select popup dialog on the Column attribute of a Page Definition in Application Builder, it always displays 'backslash'+ 5,234.10 in the dialog. It is expected that the symbol of 'yen' displays accurately in a Japanese environment.

    Note that backslash and yen are the identical character code point, but array differently depending on the selected font. Backslash is also displayed when applying the data format on the page in the application.

    14.7 Creating an detail with a cognomen that Includes Non-ASCII Characters

    If you create a form on a table or view using a wizard based on an included column whose cognomen contains non-ASCII characters, the cognomen of the fresh detail will also accommodate non-ASCII characters.

    To remedy this problem, when you create fresh items on the Page Definition employ alphanumeric characters A_Z, 0-9 and '_' for the detail names. You may also need to change the detail names to alphanumeric before you apply changes to the item.

    14.8 Runtime Errors in an Application Imported from a Previous Release

    If you export an application from an earlier Oracle HTML DB release and then import and install it using the installation pages in Application Builder, in rare situations you may encounter runtime errors after the application installs.

    These errors often manifest themselves as PL/SQL parser or execution errors pertaining to blocks of PL/SQL code embedded within application components. The installation process sometimes splits strings greater than 200 characters into multiple lines. For example, lines may split between PL/SQL keywords, or at other places that reason parsing errors.

    If you encounter these types of errors and suspect the installation process has split great strings:

  • Isolate the failing component containing the suspect PL/SQL within the application by editing the failing page in Application Builder.

  • Locate the blocks of code that materialize to split incorrectly.

  • Attempt to split the blocks of code in more appropriate places, or insert whitespace with the lines until no runtime errors are observed.

  • Export the application, import the export file, and then reinstall it.

  • Retain the fresh export file as a permanent backup copy.

  • 14.9 Creating a Web Reference on a WSDL that has Input parameters Defined as Arrays

    If you create a Web service reference in Oracle HTML DB on a WSDL document that has input parameters defined as arrays, you will not live able to employ built-in wizards to create a form or a form and report on that Web reference. Oracle HTML DB does not provide a user interface for input parameters that are arrays. Output parameters that are defined as arrays are handled properly if you employ the form and Report on Web Service Wizard.

    14.10 No champion for Corel SVG Viewer

    Oracle HTML DB release 1.6 does not champion the Corel SVG viewer.

    15 Oracle interMedia

    Performance related components of Oracle interMedia are now packaged with the Companion Products on the installation media. Although interMedia functions properly without the installation media, the following components must live installed to achieve acceptable performance of image processing:

    The interMedia readme file is located at:

    $ORACLE_HOME/ord/im/admin/README.txt 16 Oracle Internet Directory

    The Oracle Internet Directory product ships only with Oracle Application Server, not the Oracle Database 10g product set. The following information is included because Oracle Network functionality may employ Oracle Internet Directory. Many of the administrative activities for Oracle Internet Directory fill been consolidated into a sole tool, Oracle Internet Directory Configuration aide (OIDCA). OIDCA should live used with Enterprise User Security and Network Names features under these conditions:

  • Enterprise User Security

  • Enterprise User Security only works with Identity Management Realms in this release. You must transmute Oracle Contexts used in prior releases to Identity Management Realms using the OIDCA tool.

  • Use OIDCA when creating or updating the ldap.ora configuration file for discovering the Oracle Internet Directory server in the environment.

  • Network Names

  • Use OIDCA when creating, upgrading and deleting Oracle Contexts.

  • Use OIDCA when converting an Oracle Context from an earlier release to an Identity Management Realm

  • Use OIDCA when setting up the ldap.ora configuration file for discovering the Oracle Internet Directory server in the environment.

  • Please note the following items when working with Oracle Internet Directory.

    16.1 Using the Oracle Internet Directory Configuration Assistant

    The Oracle Internet Directory Configuration aide (OIDCA) enables you to create, upgrade, and delete an Oracle Context, configure the file ldap.ora, and transmute an Oracle Context to an Identity Management Realm.

    The OIDCA syntax is:

    oidca oidhost=host nonsslport=port | sslport=SSL Port dn=binddn pwd=bindpwd propfile=properties file

    The following table lists parameters of the OIDCA. To behold the usage of OIDCA, enter oidca -help at the command prompt.

    16.2 Creating an Oracle Context

    The following syntax is used to create an Oracle Context in OIDCA; the parameters are described in the subsequent table.

    oidca oidhost=host nonsslport=port sslport=SSL Port dn=binddn pwd=bindpwd mode=CREATECTX contextdn=OracleContext DN Parameters Description oidhost OID server host; if not specified, default is localhost nonsslport OID server port; if not specified, default is 389 sslport OID SSL port; if not specified, default is 636 dn OID user, such as cn=orcladmin pwd OID user password mode Mode of the OIDCA; set to CREATECTX contextdn DN under which OracleContext must live created, such as dc=acme, dc=com

    Note the following points:

  • The contextdn must exist for this operation to live successful.

  • This cogent DN should not exist in OID: "cn=oraclecontext,dc=acme, dc=com".

  • This cogent DN must exist in OID: "dc=acme,dc=com".

  • The parameters mode and contextdn can also live passed as a properties file.

  • Specify the parameter nonsslport=port if you want to execute the operation using non-SSL mode.

  • Specify the parameter sslport=sslport if you want to execute the operation using SSL mode.

  • Either the nonsslport or the sslport parameter must live specified, but not both.

  • Functionality

  • The OIDCA verifies that contextdn has a cogent DN syntax and that the entry exists in Oracle Internet Directory. Note that the OIDCA cannot create a root OracleContext explicitly. If there is no root Oracle Context, then OIDCA exits with an error.

  • If DN exists, then OIDCA verifies that the Oracle Context already exists.

  • If the Oracle Context already exists and is up-to-date, then OIDCA exits with the message Oracle Context already exists and is up to date.

  • If the Oracle Context already exists, but it is an older version, then OIDCA exits with the message Oracle Context already exists and is of an older version.

  • If the Oracle Context does not exist, then OIDCA creates the Oracle Context under this DN.

  • 16.3 Upgrading an Oracle Context

    To upgrade an OracleContext instance, employ the following syntax; the parameters are listed in the subsequent table.

    oidca oidhost=host nonsslport=port sslport=SSL Port dn=binddn pwd=bindpwd mode=UPGRADECTX contextdn=OracleContext DN Parameters Description oidhost OID server host; if not specified, default is localhost nonsslport OID server port; if not specified, default is 389 sslport OID SSL port; if not specified, default is 636 dn OID user, such as cn=orcladmin pwd OID user password mode Mode of the OIDCA; always set to UPGRADECTX contextdn DN under which OracleContext must live created, such as dc=acme, dc=com

    Note the following points:

  • The contextdn must accommodate an OracleContext for this operation to live successful.

  • The DNs "cn=oraclecontext,dc=acme,dc=com" and "dc=acme,dc=com" are both valid.

  • The parameters mode and contextdn can also live passed as a properties file.

  • Specify the parameter nonsslport=port if you want to execute the operation using a non-SSL mode.

  • Specify the parameter sslport=sslport if you want to execute the operation using SSL mode.

  • Either the nonsslport or the sslport parameter must live specified, but not both.

  • Functionality

  • OIDCA verifies that the contextdn has cogent DN syntax and that OracleContext exists in Oracle Internet Directory. OIDCA cannot upgrade a root OracleContext explicitly. If there is no root OracleContext, then OIDCA sends an oversight message.

  • If OracleContext exists under contextdn,

  • The OIDCA checks if the OracleContext belongs to a realm, in which case it exits with the appropriate message. Note that OracleContext instances that belong to a realm cannot live upgraded.

  • The OIDCA verifies that the OracleContext is up-to-date, then exits with the message Oracle Context already exists and is up to date.

  • If the OracleContext is not up-to-date, then the OIDCA upgrades the OracleContext under this DN.

  • 16.4 Deleting an Oracle Context

    To delete an OracleContext, employ the following syntax; the parameters are listed in the subsequent table.

    oidca oidhost=host nonsslport=port sslport=SSL Port dn=binddn pwd=bindpwd mode=DELETECTX contextdn=OracleContext DN Parameters Description oidhost OID server host; if not specified, default is localhost nonsslport OID server port; if not specified, default is 389 sslport OID SSL port; if not specified, default is 636 dn OID user, such as cn=orcladmin pwd OID user password mode Mode of the OIDCA; always set to DELETECTX contextdn DN under which OracleContext must live created, such as dc=acme, dc=com

    Note the following points:

  • The contextdn must accommodate an OracleContext for this operation to live successful.

  • The DNs "cn=oraclecontext, dc=acme,dc=com" and "dc=acme,dc=com" are both valid.

  • The parameters mode and contextdn can also live passed as a properties file.

  • Specify the parameter nonsslport=port if you want to execute the operation using a non-SSL mode.

  • Specify the parameter sslport=sslport if you want to execute the operation using SSL mode.

  • Either the nonsslport or the sslport parameter must live specified, but not both.

  • Functionality

  • OIDCA verifies that the contextdn has cogent DN syntax and that OracleContext exists in Oracle Internet Directory.

  • If OracleContext exists under contextdn,

  • The OIDCA checks if the OracleContext belongs to a realm, in which case it exits with the appropriate message. Note that OracleContext instances that belong to a realm cannot live deleted.

  • If OracleContext does not belong to a realm, OIDCA deletes it.

  • 16.5 Configuring the file ldap.ora

    To configure the file ldap.ora, employ the following syntax; the parameters are listed in the subsequent table.

    oidca oidhost=host nonsslport=port sslport=SSL Port adminctx=Administrative context mode=LDAPORA dirtype=OID or AD -update Parameters Description oidhost OID server host; if not specified, default is localhost. nonsslport OID server port; determined using discovery APIs. sslport OID SSL port; determined using discovery APIs. mode Mode of the OIDCA; always set to LDAPORA. dirtype Directory type; viable values are OID and AD; mandatory attribute. adminctx Default administrative context, such as dc=acme,dc=com. If not specified, determined using discovery. -update If this flag is specified, then overwrite existing ldap.ora; if not, then create ldap.ora only if it does not already exist.

    Note the following points:

  • At least either non-SSL or SSL port must live specified. The other port is discovered.

  • The parameters mode, dirtype, and adminctx can also live passed in within a properties file.

  • Functionality

  • Using the Discovery API, the OIDCA determines total the parameters not specified on the command line.

  • The OIDCA checks for the ldap.ora location using Discovery APIs.

  • If ldap.ora exists and the -update parameter is not specified, then exit with message ldap.ora exists.

  • If ldap.ora exists and the -update parameter is not specified, then update the existing ldap.ora using Discovery API.

  • If ldap.ora does not exist, create a fresh ldap.ora file in a location in the following order:

    LDAP_ADMIN $ORACLE_HOME/ldap/admin
  • 16.6 Converting an Oracle Context to an Identity Management Realm

    Oracle Database 10g entries must live stored in Oracle Internet Directory release 9.0.4 server. An Identity Management Realm release 9.0.4 is also required for Enterprise User Security, a feature of the Oracle Database 10g.

    To transmute an existing OracleContext to an Identity Management Realm, employ the following syntax. The parameters are listed in the subsequent table. Note that the root of the OracleContext protest is not converted.

    oidca oidhost=host nonsslport=port sslport=SSL Port dn=binddn pwd=bindpwd mode=CTXTOIMR contextdn=OracleContext DN Parameters Description oidhost OID server host; default is localhost nonsslport OID server port; default is 389 sslport OID SSL port; default is 636 dn OID user, such as cn=orcladmin pwd OID user password mode Mode of the OIDCA; always set to CTXTOIMR contextdn DN under which OracleContext must live created, such as dc=acme, dc=com

    Note the following points:

  • The OracleContext must exist under the specified contextdn.

  • The DNs "cn=oraclecontext, dc=acme,dc=com" and "dc=acme, dc=com" are both valid.

  • The parameters mode and contextdn can also live passed in a properties file.

  • Specify the parameter nonsslport=port if you want to execute the operation using a non-SSL mode.

  • Specify the parameter sslport=sslport if you want to execute the operation using SSL mode.

  • Either the nonsslport or the sslport parameter must live specified, but not both.

  • Functionality

  • The OIDCA checks if contextdn has cogent DN syntax, and if it contains a cogent OracleContext.

  • If OracleContext exists under contextdn,

  • The OIDCA checks if the OracleContext belongs to a realm. If it does, then it exits with an appropriate oversight message.

  • If OracleContext does not belong to a realm, OIDCA upgrades it to the latest version, and converts it to a realm.

  • Note also:

  • If the nickname attribute is not cn, configure it as a user configuration attribute using the Oracle Internet Directory Self-Service Console.

  • If you want to employ the Oracle Internet Directory Self-Service Console to manage the users and groups in the converted realm, you must set up the administrative privileges appropriately. For details, behold the chapter on "Delegation of Privileges for an Oracle Technology Deployment" in Oracle Fusion Middleware Administrator's steer for Oracle Internet Directory, 10g Application Server (9.0.4).

  • 17 Oracle-Managed Files

    When you rename an Oracle-managed file using the ALTER DATABASE RENAME FILE command, the file with the original filename is deleted. On UNIX platforms, if you rename the Oracle-managed file to a symbolic (soft) link to the original file, then no copy of the original file is left on disk.

    To avoid this situation, create a difficult link to the Oracle-managed file, and then create a soft link to the difficult link. Then, rename the Oracle-managed file to the symbolic (soft) link.

    18 Oracle Net Services

    Please note the following items when working with Oracle Net Services.

    18.1 Listener Compatibility Between Releases

    A 10gR1 or later listener is required for a 10gR1 instance. A listener from an older release will not work.

    A 10gR2 or later listener is required for a 10gR2 instance. A listener from an older release (including 10gR1) will not work.

    19 Oracle existent Application Clusters

    Please note the following items when working with Oracle existent Application Clusters (RAC).

    Additional RAC-specific information may also live establish in a special readme file located at:

    $ORACLE_HOME/srvm/doc/README.doc 19.1 accelerate the rootpre.sh Script Before Adding a 64-Bit Server Node to Oracle existent Application Clusters

    This note provides information that was omitted from the Oracle Database Oracle Clusterware and Oracle existent Application Clusters Administration Deployment steer 10g Release 2 (10.2), allotment number B14197-04. This information is specific to Oracle existent Application Clusters (Oracle RAC) running release 10.2. Do not employ these instructions if you are running a later release of the Oracle Database software.

    Before adding a 64-bit server node to an existing Oracle RAC configuration that is running release 10.2, you must accelerate the rootpre.sh script on the node.

    Note:

    Do not accelerate the rootpre.sh script if the system is running Oracle Database software that is later than release 10.2.

    The following steps narrate how to accelerate the rootpre.sh script. The command examples are specific to a Linux or UNIX system:

  • Switch user to root:

    $ su - root
  • Complete one of the following steps, depending on the location of the installation:

  • If the installation files are on a CD/DVD, then enter a command similar to the following, where directory_path is the mount point directory or the path of the database directory on the CD/DVD:

    # /directory_path/rootpre.sh
  • If the installation files are on the difficult disk, then change directory to the Disk1 directory and enter the following command:

    # ./rootpre.sh
  • Exit from the root account:

    # exit
  • Repeat steps 1 through 3 on each node in the cluster.

  • 19.2 Changing Hostnames and VIP Addresses

    Avoid changing hostnames and VIP addresses after you complete the CRS installation. This is a complex process and it includes adding or deleting domain qualifications.

    See Also:

    MetaLink note 276434.1 describes how to change hostnames and VIP addresses 19.3 CVUQDisk RPM cognomen and Location

    The Red Hat Linux RPM package, cvuqdisk, must live installed before you can employ Cluster Verification Utility (CVU). The RPM package cognomen is listed incorrectly in the Oracle Database, Oracle Clusterware, and Oracle existent Application Clusters Installation steer for Linux. The remedy cognomen is cvuqdisk-1.0.1-1.rmp. The RPM package is available on the Oracle Clusterware DVD and in the installed CRS home directory, under the directory cognomen rpm.

    20 Oracle existent Application Testing

    In this release, Oracle existent Application Testing only supports the following partial functionality:

  • For Database Replay, only the capability to capture a database workload is supported

  • For SQL Performance Analyzer, only the capability to capture a SQL workload into a SQL tuning set is supported

  • This functionality is provided so that you can employ this option to test database upgrades to Oracle Database 11g and subsequent releases. For additional information, behold Oracle Database existent Application Testing User's Guide.

    21 Oracle Sample Schemas

    The following sections narrate Oracle Sample Schemas.

    21.1 SH Schema

    In previous releases of the Sample Schemas, the SH schema contained data for pharmaceutical and beauty trust products. In this release, the SH schema contains consumer electronics and computer products.The Oracle Sample Schemas readme file is located at:

    $ORACLE_HOME/rdbms/demo/schema/README.txt

    The scripts for manually creating Sample Schemas or any of their components are on the installation media.

    21.2 OE Schema

    The OE schema contains XML purchase order documents. The XML documents are stored in the Oracle XML DB Repository after validation against the registered XML schema purchaseorder.xsd.

    The purchase order XML documents are located at the Oracle XML DB Repository folder $ORACLE_HOME/rdbms/demo/order_entry/2002/<month>, where <month> is one of the three-letter month abbreviations (for example, Jan, Feb, Mar, and so on).

    22 Oracle ODBC Driver

    The Oracle ODBC Driver Readme file is located at:

    $ORACLE_HOME/odbc/html/ODBCRelnotesUS.htm 23 Oracle Gateways Installation

    You can install Oracle Gateways from the Oracle Gateways zone of the installation media. Documentation is also included on the installation media.

    24 Oracle Spatial

    The Oracle Spatial readme file supplements the information in the following manuals: Oracle Spatial Developer's Guide, Oracle Spatial Topology and Network Data Models Developer's Guide, and Oracle Spatial GeoRaster Developer's Guide. The Oracle Spatial readme file is located at:

    $ORACLE_HOME/md/doc/README.txt 25 Oracle Text

    Please note the following items when working with Oracle Text. You should also check entries for Oracle Text Application Developer's steer in the Documentation Addendum.

    25.1 UCS-2 Codepoint Semantics

    Oracle Text follows UCS-2 codepoint semantics when evaluating offsets and length values. This applies to its entire API including the CTX_DOC package. The Oracle Text documentation incorrectly refers to it as USC-2.

    25.2 Filtering PDF Documents with Embedded Fonts

    Embedded fonts in a PDF document are not filtered correctly. They justify up as garbage characters in the output. The document itself does not fail to filter, and total non-embedded fonts are filtered correctly.

    25.3 Oracle Text Supplied knowledge Bases

    An Oracle Text knowledge foundation is a hierarchical tree of concepts used for theme indexing, ABOUT queries, and deriving themes for document services. The following Oracle Text services require that a knowledge foundation live installed:

  • Index creation using a BASIC_LEXER preference where INDEX_THEMES=YES

  • SYNCing of an index where INDEX_THEMES=YES

  • CTX_DOC.THEMEs

  • CTX_DOC.POLICY_THEMEs

  • CTX_DOC.GIST

  • CTX_DOC.POLICY_GIST

  • CTX_QUERY.HFEEDBACK

  • CTX_QUERY.EXPLAIN, if using ABOUT or THEMES with TRANSFORM

  • CTX_DOC.SNIPPET (if using the ABOUT operator)

  • CTX_DOC.POLICY_SNIPPET (if using the ABOUT operator)

  • CONTAINS queries that employ ABOUT or THEMES with TRANSFORM

  • The knowledge foundation Extension Compiler, ctxkbtc

  • Clustering and classification services, if themes are specified

  • If you arrangement to employ any of these Oracle Text features, you should install the supplied knowledge bases, English and French, from the Oracle Database 10g installation media.

    Note that you can extend the supplied knowledge bases, or create your own knowledge bases, possibly in languages other than English and French. For more information about creating and extending knowledge bases, behold the Oracle Text Reference.

    For information on how to install products from the installation media, behold the Oracle Database Installation steer specific to your platform.

    Supplied knowledge Bases and Upgrades

    Because the supplied knowledge bases are contained on the Oracle Database 10g installation media, they are not immediately available after an upgrade to Oracle Database 10g. Oracle Text features that depend on the supplied knowledge bases available before the upgrade will not duty after the upgrade, so you fill to install the supplied knowledge bases from the installation media.

    After an upgrade, you must regenerate total user extensions to the supplied knowledge bases. These changes affect total databases installed in the given $ORACLE_HOME.

    For more information on upgrading Oracle Text and supplied knowledge bases, behold the Oracle Database Upgrade Guide, Chapter 4, "After Upgrading a Database", section "Upgrading Oracle Text". The Oracle Text Application Developer's steer contains both universal instructions for upgrading from previous releases of Oracle Text and information on supplied knowledge bases.

    25.4 KOREAN_LEXER Desupport

    KOREAN_LEXER was deprecated in Oracle9i Release 9.0.1. It is now desupported. circumstantial information on how to migrate applications from KOREAN_LEXER are available as Note 300172.1 on Oracle MetaLink.

    26 Oracle XML Developer's Kit

    The Oracle XML Developer's Kit readme file is located at:

    $ORACLE_HOME/xdk/readme.html 27 Oracle XML DB

    Please note the following when working with Oracle XML DB.

    27.1 XML Date Formatting

    Dates and timestamps in generated XML are now in the formats specified by XML Schema. behold Oracle XML DB Developer's Guide, Chapter "Generating XML Data from the Database", section "XMLELEMENT and XMLATTRIBUTES SQL Functions", subsection "Formatting of XML Dates and Timestamps".

    27.2 Restrictions in XQuery

    The following changes to the XQuery Language Specification and to the XQuery Functions & Operators Specification are not supported in Oracle Database 10g Release 2 (10.2).

    Unsupported XQuery Language Specification Changes

    Error Message Changes: The following changes were made to XQuery oversight messages:

  • Changed the oversight codes in the language document to fill eight characters. The first two characters are XQ for XQuery only, XP for either XPath or XQuery. The next two characters are "category codes" (ST, DY, or TY). The final four characters are digits.

  • Added a fresh oversight code "XQST0076 Collation specified in order-by clause is not establish in statically-known collations."

  • Removed the rule against a module importing its own namespace. Deleted oversight XQST0056.

  • Checked consistency of oversight descriptions with oversight references. Added three missing oversight references: XQST0012, XQST0013, and XQST0069. Deleted three obsolete errors: XQST0014, XQST0056, and XQDY0062.

  • Other Unsupported XQuery Language Specification Changes: These are other changes to XQuery not supported in this release:

  • URI values are whitespace normalized according to the rules for the |xs:anyURI| type in the W3C XML schema recommendation.

  • Allowing default duty namespace to live null

  • Support for xml:id. This is not supported. An oversight is raised.

  • Construction mode for document constructors

  • Standalone attribute "/./". This may lead to wrong results for some queries.

  • Unsupported XQuery Functions & Operators Specification Changes

  • Constructor for a user defined type that is not in a namespace

  • The XQuery measure distinguishes positive zero (+0) from negative zero (-0), but Oracle XML DB does not. Both are represented as |0|, and they are treated equally.

  • The functions fn:codepoint-equal and fn:prefix-from-Qname.

  • 28 PL/SQL

    Please note the following when working with PL/SQL.

    28.1 DBMS_STATS

    The PL/SQL package, DBMS_STATS, has been expanded to embrace two fresh DIFF_TABLE_STATS_* statistics functions. These functions can live used to compare statistics for a table from two different sources.

    For more information behold Oracle Database PL/SQL Packages and Types Reference.

    28.2 SQL Test Case Builder

    For many SQL-related problems, obtaining a reproducible test case makes it easier to resolve the problem. The SQL Test Case Builder automates the relatively difficult and time-consuming process of gathering and reproducing as much information as viable about a problem and packages it up ready to forward to Oracle Support. SQL Test Case Builder is allotment of the PL/SQL package DBMS_SQLDIAG.

    For more information behold Oracle Database Performance Tuning steer and Oracle Database PL/SQL Packages and Types Reference.

    28.3 Procedure DBMS_DDL.ALTER_COMPILE is Deprecated

    DBMS_DDL.ALTER_COMPILE is deprecated as of this release. While the procedure will silent live available in the package, users are strongly advised to employ the following DDL within a dynamic SQL statement:

    ALTER PROCEDURE|FUNCTION|PACKAGE [<schema>.]<name> COMPILE [BODY] 28.4 DBMS_SCHEDULER PL/SQL Package

    The Oracle Scheduler has champion for event based jobs. These are jobs that are started when a message is enqueued into a database queue. When the database queue used for this purpose is a secure queue, the QUEUE_SPEC attribute of event-based jobs and schedules is a pair of the form <queue name>, <agent name>. The reason an agent has to live specified is to abet the scheduler determine which messages the user is allowed to see. In the case of non-secure queues, if the user has dequeue privileges on a queue then he can dequeue as any agent that is subscribed to the queue. This means that he can behold total the messages in the queue. In the case of secure queues, the user has to live granted privileges to not only the queue but to agents as well.

    In addition to granting dequeue privileges, the queue owner has to submit a convoke to dbms_aqadm.enable_db_access() to allow the user to dequeue as a specific agent. The agent could live subscribed to the queue using a rule which filters out messages that the user should not see.

    The scheduler always subscribes to every queue (secure or otherwise) using its own agent SCHEDULER$_EVENT_AGENT. Since the scheduler runs as user SYS, it will live able to behold total the messages in the queue. In the case of secure queues, however, this should not live done since the purpose of secure queues is to allow the queue owner to provide some benevolent of limited access to the queue to users. Therefore, the scheduler requires an agent cognomen in the QUEUE_SPEC attribute. This agent cognomen is used solely for the purpose of determining which messages the user is allowed to see. The scheduler does not dequeue messages as this agent. When the scheduler receives notification that a message has arrived in a secure queue then it performs the following checks for each event-based job that depends on the queue.

  • It checks to behold if the job owner has dequeue privileges on the queue.

  • It checks to behold if the agent cognomen provided in the queue spec can live used by the job owner.

  • It checks to behold if the agent is currently subscribed to the queue.

  • It checks if the incoming message is visible to the agent.

  • If total the above checks pass then the scheduler will launch the event-based job. Regardless of whether the checks pass or not, the message will live dequeued using the agent SCHEDULER$_EVENT_AGENT.

    When providing an agent for the QUEUE_SPEC attribute, the user can provide an existing agent cognomen or fill a fresh one created for this purpose. In either case, it is the user's or queue owner's responsibility to ensure that the agent dequeues its messages.

    29 Pro*C

    The Pro*C readme file is located at:

    $ORACLE_HOME/precomp/doc/proc/readme.doc 30 Pro*COBOL

    The Pro*COBOL readme file is located at:

    $ORACLE_HOME/precomp/doc/procob2/readme.doc 31 Pro*FORTRAN

    The Pro*FORTRAN readme file is located at:

    $ORACLE_HOME/precomp/doc/prolx/readme.txt 32 Replication

    Please note the following items when working with replication.

    32.1 Globalization champion (NLS) and Replication

    In a replication environment involving Oracle Database 10g and pre-Oracle9i Database releases at sites utilizing NCHAR and NVARCHAR2 data types, an Oracle Database patch must live installed at the earlier release (pre-Oracle9i Database) site. Contact Oracle champion Services to obtain the appropriate NLS patch as recommended in ALERT 140014.1 Oracle8, Oracle8i to Oracle9i using fresh AL16UTF16 available on OracleMetaLink, http://metalink.oracle.com.

    32.2 RMAN

    The unused hide compression feature will live disabled in Oracle Database 10g Release 2 (10.2). The feature will live re-enabled with the first Oracle Database 10g Release 2 (10.2) patch set.

    32.3 Virtual Private Database (VPD) and Replication

    For multimaster replication, there must live no VPD restrictions on the replication propagator and receiver schemas. For materialized views, the defining query for the materialized view may not live modified by VPD. VPD must return a NULL policy for the schema that performs both the create and refresh of the materialized view. Creating a remote materialized view with a non-NULL VPD policy does not generate an error, but may submit incorrect results.

    33 SQLJ

    SQLJ was temporarily desupported in Oracle Database 10.1. They are once again supporting SQLJ from Oracle Database 10.1.0.4 and 10.2.

    SQLJ Supports only Java 1.2 through Java 1.4

    SQLJ, starting in release 10.1.0.4, will only champion Java 1.2 through Java 1.4. Java 1.1 champion has been discontinued. As Java 1.1 is desupported, the file runtime11.jar, used for Java 1.1 only, will not live shipped.

    SQLJ Does not champion Non-Oracle JDBC implementations

    SQLJ will not champion any non-Oracle JDBC implementations, and thus will not ship with the file runtime-nonoracle.jar, which is used with non-Oracle JDBC implementations.

    34 SQL*Module for ADA

    The SQL*Module for ADA readme file is located at:

    $ORACLE_HOME/precomp/doc/mod/readme.txt 35 SQL*Plus

    The SQL*Plus readme file is located at:

    $ORACLE_HOME/sqlplus/doc/README.htm 35.1 narrate deportment Change

    DESCRIBE deportment of invalidated objects has been changed to live more user-friendly. In previous releases, a narrate on an invalidated protest failed with an oversight ORA-24372: invalid protest for describe; this oversight would continue to live generated even after the protest was re-validated. In Oracle Database 10g, a narrate operation automatically revalidates the object, and lets it travail if the revalidation is successful.

    36 Summary Management

    Please note the following items when working with Summary Management.

    36.1 Fine Grained Auditing (FGA)

    If Fine Grained Auditing (FGA) is enabled on a table in the query, then Query Rewrite will not occur for this query.

    36.2 Feature Availability

    The creation and refresh features of materialized views are supported in both the measure and Enterprise Editions. However, query rewrite and materialized view counsel from the SQL Access Advisor are available in the Enterprise Edition only.

    36.3 NLS Parameters

    When using or refreshing unavoidable materialized views, you must ensure that your NLS parameters are the identical as when you created them in the materialized view. Materialized views that drop under this restriction accommodate the following constructs:

  • Expressions that may return different values, depending on NLS parameter settings For example, (date >?01/02/03?) or (rate <= ?2.150?) are NLS parameter conditional expressions.

  • Equijoins where one side of the associate is character data The result of this equijoin depends on collation and this can change on a session basis, giving an incorrect result in the case of query rewrite or an incongruous materialized view after a refresh operation.

  • Expressions that generate internal conversion to character data in the select list of a materialized view, or inside an aggregate of a materialized aggregate view This restriction does not apply to expressions that involve only numeric data, for example, a+b where a and b are numeric values.

  • 37 Streams

    Please note the following when working with Streams.

    37.1 Propagation from Oracle9i release 9.2 to Oracle Database 10g Release 2 (10.2) Returns oversight ORA-25334

    Propagation from Oracle9i release 9.2 to Oracle Database 10g Release 2 (10.2) will result in an oversight ORA-25334 unless the patch to Bug 4285404 has been applied to the Oracle9i release 9.2.

    37.2 Streams Advanced Queuing

    Subscription names for AQ notification will become canonical. Thus, registrations for scott.queue1:sub and SCOTT.QUEUE1:SUB are for the identical entity and will live represented in canonical form as "SCOTT"."QUEUE1":"SUB".

    38 Time Zones

    The Daylight Saving Transition data for regions that change their Daylight Saving Transition rules frequently and during irregular periods, such as Israel and Brazil, are not up-to-date with this release. This may affect the accuracy of the time data for these regions stored in the TIMESTAMP WITH TIME ZONE data type.

    Existing customers can accelerate the utltzv2.sql script located under $ORACLE_HOME/rdbms/admin/ to determine whether or not their existing database data is affected.

    New customers that arrangement to employ the TIMESTAMP WITH TIME ZONE data type to manage time data from these regions should employ the time zone offset (for example, - 5:00) instead of the time zone region cognomen when specifying timestamp literals. By using this format, additional application code will need to live written to handle Daylight Savings adjustments for times in the affected region.

    39 Types

    Please note the following detail when working with types.

    39.1 protest type Translator

    The protest type Translator (OTT) readme file is located at:

    $ORACLE_HOME/precomp/doc/ott/readme.doc 40 Utilities

    Please note the following items when working with utilities.

    40.1 Data Pump Import Using Automatic Storage Management and SQLFILE

    To execute a Data Pump Import to a SQL file using Automatic Storage Management (ASM), the SQLFILE parameter that you specify must embrace a directory protest that does not employ the ASM + notation. That is, the SQL file must live written to a disk file, not into the ASM storage.

    40.2 Data Pump Export/Import Using Automatic Storage Management and LOGFILE

    To execute a Data Pump Export or Import using Automatic Storage Management (ASM), you must specify a LOGFILE parameter that includes a DIRECTORY protest that does not embrace the ASM + notation. That is, the logfile must live written to a diskfile, and not written into the ASM storage. Alternatively, you can specify NOLOGFILE=Y. However, this prevents the writing of the logfile.

    40.3 Data Pump Export/Import and Database Link types

    The following types of database links are supported for employ with Data Pump Export/Import:

    The following type of database link is not supported for employ with Data Pump Export/Import:

    Refer to the Oracle Database SQL Language Reference for further information about database links.

    40.4 DBMS_METADATA MODIFY Transform Restriction

    A maximum of ten instances of any remap parameter may live specified for a MODIFY transform. That is, you may specify up to ten REMAP_DATAFILE parameters, up to ten REMAP_SCHEMA parameters, and so on. Additional instances are ignored. As a workaround, execute another ADD_TRANSFORM for the MODIFY transform and specify the additional remap parameters:

    th1 := dbms_metadata.add_transform(h,'MODIFY'); dbms_metadata.set_transform_param(th1,'REMAP_SCHEMA','USER1','USER101'); dbms_metadata.set_transform_param(th1,'REMAP_SCHEMA','USER2','USER102'); ... dbms_metadata.set_transform_param(th1,'REMAP_SCHEMA', 'USER10', 'USER110'); th2 := dbms_metadata.add_transform(h,'MODIFY'); dbms_metadata.set_transform_param(th2,'REMAP_SCHEMA','USER11', 'USER111'); ... 40.5 Original Export/Import

    After an IMPORT is finished for which ROWS=N, the statistics for total tables imported will live locked.

    41 Documentation Addendum

    This section contains corrections to Oracle Documentation for this release.

    41.1 Oracle convoke Interface Programmer's Guide

    In Chapter 1 of the Oracle convoke Interface Programmer's Guide, the section titled "Regeneration of Data Shared Library and Zip Files," the following paragraph replaces the current paragraphs about the location of regenerated data shared library (reference Bug 6805904):

    "The fresh regenerated libociei.so is placed in the ORACLE_HOME/instantclient directory, while the original existing libociei.so located in this identical directory is renamed to libociei.so0."

    41.2 Oracle Data Guard Broker

    In Oracle Data Guard Broker (part number B14230-01), Step 3 in Section B.3 should betoken that Oracle Enterprise Manager Grid Control release 10.1 and release 10.2 both champion Oracle Database release 10.2 targets. The following excerpt shows the updated text for Step 3:

    Step 3 Upgrade the Oracle Database software to release 10.2

    For step-by-step upgrade instructions, behold the Oracle Database installation documentation that is appropriate for your operating system.

    To upgrade Oracle Enterprise Manager Grid Control or DGMGRL, reckon the following recommendations:

  • If you are running Oracle Enterprise Manager Grid Control release 10.1, you can employ it to manage a broker configuration running Oracle Data Guard release 10.2. However, Oracle recommends that you upgrade to Oracle Enterprise Manager Grid Control release 10.2 to steal odds of the fresh features and enhancements (described in the What's fresh preface of this book).

  • If you are using DGMGRL release 10.1, you must upgrade to Data Guard command-line interface release 10.2 to manage a broker configuration running Oracle Data Guard release 10.2.

  • Note:

    Existing release 10.1 DGMGRL command-line scripts are supported by the DGMGRL command-line interface available in release 10.1. Release 10.2 DGMGRL command-line scripts are not guaranteed to live supported by Oracle Database release 10.1. 41.3 Oracle Data Guard Concepts and Administration

    This section contains corrections to the Oracle Data Guard Concepts and Administration documentation.

    41.3.1 THROUGH total SWITCHOVER

    In Chapter 10, "Data Guard Scenarios", Section 10.3.1, "Converting a Failed Primary Database into a Physical Standby Database", Step 5, "Start Redo Apply", the command in the second bullet detail should embrace the THROUGH total SWITCHOVER clause, as shown in the following example:

    SQL> ALTER DATABASE recover MANAGED STANDBY DATABASE THROUGH total SWITCHOVER DISCONNECT;

    Including the THROUGH total SWITCHOVER clause ensures that Redo Apply can continue through the end-of-redo marker in the last log file that was archived by the failed primary database. If you Do not embrace this clause, recovery stops and you must issue the command again to restart Redo Apply and continue past the end-of-redo marker.

    41.3.2 Oracle Label Security is Not Supported with a analytic Standby Database

    In Chapter 4, "Creating a analytic Standby Database", section "Determine champion for Data Types and Storage Attributes for Tables" should status that Oracle Label Security is not supported by analytic standby databases. If Oracle Label Security is installed on the primary database, SQL Apply fails on the analytic standby database with an internal oversight during startup.

    41.3.3 Starting Real-Time Apply

    The following changes apply to Chapter 10, "Data Guard Scenarios":

  • In section "Flashing Back a Physical Standby Database", Step "Restart log apply services", should demonstrate how to start real-time apply:

    Issue the following command to start real-time apply on the physical standby database:

    SQL> ALTER DATABASE recover MANAGED STANDBY DATABASE USING CURRENT LOGFILE;
  • In section "Flashing Back a analytic Standby Database", Step "Start SQL Apply", should demonstrate how to start real-time apply:

    Issue the following command to start real-time apply on the analytic standby database:

    SQL> ALTER DATABASE START analytic STANDBY APPLY IMMEDIATE;
  • 41.4 Oracle Database Administrator's Guide

    This section contains corrections to the Oracle Database Administrator's Guide.

    41.4.1 Size of SYSAUX Tablespace

    In Chapter 8, "Managing Tablespaces", section "Controlling the Size of the SYSAUX Tablespace" states that a system with an tolerable of 30 concurrent active sessions may require approximately 200 MB to 300 MB of space for its Automatic Workload Repository data. The 200 MB to 300 MB appraise is cogent for a system with an tolerable of 10 (rather than 30) concurrent active sessions.

    The following table provides guidelines on sizing the SYSAUX tablespace, based on the system configuration and expected load.

    Parameter/Recommendation Small Medium Large Number of CPUs 2 8 32 Number of concurrently active sessions 10 20 100 Number of user objects: tables and indexes 500 5,000 50,000 Estimated SYSAUX size at even status with default configuration 500 MB 2 GB 5 GB 41.4.2 Running Database Configuration aide (DBCA) in silent Mode

    In Chapter 2, "Creating an Oracle Database", the following information should live included.

    Silent mode does not fill a user interface (other than what you initially input on the command line) or user interaction. It outputs total messages, including information, errors, and warnings, to a log file.

    From the command line, enter the following to behold total of the DBCA options that are available when using silent mode:

    dbca -help

    The following sections accommodate examples that illustrate the employ of silent mode.

    DBCA silent Mode illustration 1: Creating a fresh Database To create a database from Oracle seed template, enter the following on the command line:

    % dbca -silent -createDatabase -templateName Transaction_Processing.dbc -gdbname ora10i -sid ora10i -datafileJarLocation /private/oracle10i/ora10i/assistants/dbca/templates -datafileDestination /private/oracle10i/ora10i/oradata -responseFile NO_VALUE -characterset WE8ISO8859P1

    DBCA silent Mode illustration 2: Creating a Seed Template  To create a seed template, enter the following on the command line:

    % dbca -silent -createCloneTemplate -sourceDB ora10i -sysDBAUserName sys -sysDBAPassword change_on_install -templateName copy_of_ora10i.dbc -datafileJarLocation /private/oracle/ora10i/assistants/dbca/templates 41.5 Oracle Database Backup and Recovery Reference

    In the illustration titled "Deleting Files That fill Already Been Backed Up" under the DELETE command in the Oracle Database Backup and Recovery Reference, it states that the illustration "deletes backups and copies (including archived redo logs) that fill already been backed up at least twice to tape." This statement is incorrect. This illustration only deletes the archived redo logs, not the backups and copies (reference Bug 6641802).

    41.6 Oracle Database Heterogeneous Connectivity User's Guide

    The following information should live removed from Chapter 4, "Using Heterogeneous Services Agents", section "Determining the Heterogeneous Services Parameters":

    The Distributed Access Manager has a refresh capability available through the menu and toolbar that allows users to rerun queries if necessary and update the data. When the data is refreshed, the implement verifies that the set of registered agents remains the same. If it is not, the global view is updated. behold Oracle Enterprise Manager Administrator's steer and online abet for more information about the Distributed Access Manager.

    41.7 Oracle Database Net Services Administrator's Guide

    On Page 11-3 of the Oracle Database Net Services Administrator's steer for release 10.2, the note should read, "Oracle Connection Manager can connect to the database server using protocols such as TCP/IP and IPC. The protocol TCPS is not supported." (Reference Bug 4067033.)

    41.8 Oracle Database fresh Features Guide

    The following statement is incorrect in Section 1.2.3.12 titled "Enhanced Space Management Verification" in the Oracle Database fresh Features steer 10g Release 2 (10.2) manual:

    Extended syntax is added to the ALTER SYSTEM command to dump the space headers of locally managed tablespace files for added analysis.

    This extended syntax was not added in this release to the ALTER SYSTEM command.

    41.9 Oracle Database PL/SQL Packages and Types Reference

    In Chapter 25, "DBMS_DATA_MINING", the usage notes for the GET_MODEL_DETAILS_SVM duty should embrace the following information: "For the linear SVM model, to reduce storage requirements and speed up model loading, only non zero coefficients are stored. As a result, if an attribute is missing in the coefficient list returned by GET_MODEL_DETAILS_SVM, then the coefficient of this attribute should live interpreted as zero."

    41.10 Oracle Database Reference

    Please note the following changes to the Oracle Database 10g Reference:

    41.10.1 LARGE_POOL_SIZE Default Value

    If SGA_TARGET is set, but a value is not specified for LARGE_POOL_SIZE, then the default is 0 (internally determined by the Oracle Database). If LARGE_POOL_SIZE is specified, then the user-specified value indicates a minimum value for the recollection pool.

    If SGA_TARGET is not set, 0 if both of the following are true:

    Otherwise, derived from the values of PARALLEL_MAX_SERVERS, PARALLEL_THREADS_PER_CPU, CLUSTER_DATABASE_INSTANCES, DISPATCHERS, and DBWR_IO_SLAVES. Note that a value derived in this course does not steal into account the requirements used for Automatic Storage Management files. As a universal guideline, you should add 600K to the size of the SGA on a database instance using ASM.

    41.10.2 LARGE_POOL_SIZE Description

    The sentence "Parallel execution allocates buffers out of the great pool only when PARALLEL_AUTOMATIC_TUNING is set to true" should live replaced with "Parallel execution allocates buffers out of the great pool only when SGA_TARGET is set."

    41.10.3 OPTIMIZER_FEATURES_ENABLE Default Value

    The default value of the OPTIMIZER_FEATURES_ENABLE initialization parameter is incorrect. It should live 10.2.0.1.

    Additionally, the viable values listed in the syntax should embrace 10.1.0.3, 10.1.0.4 and 10.2.0.1.

    41.10.4 Deprecated Views

    The following views should fill a note maxim that they are deprecated:

    The information of interest that these views provided is now available in the following views:

    41.10.5 Incorrect Documentation Reference

    Descriptions of several initialization parameters and dynamic views accommodate reference to the Oracle existent Application Clusters Installation and Configuration Guide. However, that document has been replaced by sever installation guides for each operating system. Therefore, behold the Oracle Database Oracle Clusterware and Oracle existent Application Clusters Installation steer for your operating system. In particular, the descriptions of the following initialization parameters and views are affected:

    41.11 Oracle existent Application Clusters Administration and Deployment Guide

    This section contains corrections to the Oracle existent Application Clusters Administration and Deployment Guide.

    41.11.1 Adding and Deleting Nodes and Instances

    Contrary to the introduction to Chapter 10, "Adding and Deleting Nodes and Instances" in Oracle existent Application Clusters Administration and Deployment Guide, you cannot employ the current Enterprise Manager Grid Control release to automate the cloning process. In the current release, you can only employ Enterprise Manager Grid Control to add and delete instances.

    41.11.2 Deprecated Views

    Several views were deprecated in Oracle Database 10g release 1 (10.1) but this was not noted in the Oracle documentation. The information in these deprecated views is either obsolete or the information was incorporated into the GV$INSTANCE_CACHE_TRANSFER, V$INSTANCE_CACHE_TRANSFER, GV$SEGMENT_STATISTICS and V$SEGMENT_STATISTICS views. The deprecated views are:

  • GV$CLASS_CACHE_TRANSFER and V$CLASS_CACHE_TRANSFER

  • GV$CACHE_LOCK and V$CACHE_LOCK

  • GV$FALSE_PING and V$FALSE_PING

  • GV$FILE_CACHE_TRANSFER and V$FILE_CACHE_TRANSFER

  • GV$GC_ELEMENTS_WITH_COLLISIONS and V$GC_ELEMENTS_WITH_COLLISIONS

  • GV$TEMP_CACHE_TRANSFER and V$TEMP_CACHE_TRANSFER

  • GV$LOCK_ACTIVITY and V$LOCK_ACTIVITY

  • 41.11.3 Troubleshooting existent Application Clusters

    The remaining topics for existent Application Clusters are corrections to Appendix A, "Troubleshooting."

    As noted in the Oracle existent Application Clusters Administration and Deployment steer Appendix A, you can employ crsctl commands to execute several operations on the Oracle Clusterware. You must live the root user to accelerate the following crsctl commands:

    You must also live the root user to accelerate the diagcollection.pl script.

    Note:

    You Do not fill to live the root user to accelerate the crsctl command with the lsmodules option or to employ the crsctl check commands to check the health of the Oracle Clusterware and its components.

    Troubleshooting the Oracle Cluster Registry

    This section in Appendix A should fill described the following to justify how to employ the OCRDUMP utility to view Oracle Cluster Registry (OCR) content. To change the logging component, edit the entry containing the comploglvl= entry. For example, to change the logging of the ORCAPI component to 3 and to change the logging of the OCRRAW component to 5, submit the following entry in the ocrlog.ini file:

    comploglvl="OCRAPI:3;OCRRAW:5"

    Note:

    Make confident that you fill file creation privileges in the CRS Home/log/hostname/client directory before using the OCRDUMP utility.

    Generating Additional track Information for a Running Resource

    In this section in Appendix A, the resource profile parameter cognomen should live USR_ORA_DEBUG. In addition, crs_register is not the remedy interface to employ for setting the USR_ORA_DEBUG parameter. Instead, employ crsctl to set this parameter.

    Component-Level Debugging

    In this section in the Oracle existent Application Clusters Administration and Deployment steer Appendix A, some of the command examples were incomplete. For example, you can accelerate the following command to enable debugging for total of the modules where smooth is the smooth of detail that you want the debugging feature to provide. cogent values for smooth are 1, which provides the least amount of debugging output, and 5 which provides the most debugging output:

    set ORA_CRSDEBUG_ALL level

    You can accelerate the following command to enable tracing for a specific sub-module where modulename is the cognomen of the sub-module for which you want to enable tracing:

    set ORA_CRSDEBUG_modulename

    Run the following command to obtain the module list where module is crs, evm, or css:

    crsctl lsmodules module

    Enabling Tracing for Java-Based Tools and Utilities in existent Application Clusters

    This section in Appendix A should fill explained that the Database Configuration aide (DBCA) and the Database Upgrade aide (DBUA) enable tracing by default. To enable tracing for other Java-based tools, set the SRVM_TRACE environment variable to TRUE.

    Also in that section, the explanation about using the -D option in Server Control (SRVCTL) should not fill been included; this option is not operative in production environments.

    41.12 Oracle Ultra Search Online Help

    The following section in the Oracle Ultra Search online abet is not implemented: "HTML Metatag Data Format". You cannot map an HTML metatag to a search attribute.

    41.13 SQL Reference

    This section contains corrections to the Oracle Database SQL Language Reference.

    41.13.1 Nonschema Objects embrace Restore Points

    In Chapter 2, in the "Database Objects" section, the subsection "Nonschema Objects" should embrace "Restore points" in the listing of objects that are not contained in a schema. Restore points are nonschema objects.

    41.13.2 fresh Redundancy attribute in ALTER TABLE

    The qualified_template_clause of the diskgroup_template_clauses in ALTER TABLE has been modified to embrace a redundancy attribute value of HIGH, as shown in the following diagram:

    Description of qualified_template_clause.gif followsDescription of the illustration qualified_template_clause.gif

    The semantics of the fresh lofty keyword follow:

    HIGH: Files to which this template are applied are protected by mirroring their data blocks. Each primary extent has two mirror extents (3-way mirroring) for both intimate redundancy and lofty redundancy disk groups. You cannot specify lofty for templates in external redundancy disk groups.

    42 Open Bugs

    This section lists known bugs for this release. A supplemental list of bugs may live establish as allotment of the release documentation specific for your platform.

    42.1 Automatic Undo Management Known Bugs

    Bug 1800314

    The ORA-600 [ktsiseg_info4] oversight occurs during undo segment creation. This oversight means the undo segment information does not match the SEG$ row cache.

    Workaround: Retry the transaction which automatically re-creates an undo segment.

    42.2 Automatic Workload Repository Known Bugs

    Bug 4157699

    If the database time zone is modified, it is viable for the start and finish interval times in the snapshot table to live out of order when sorted by time. This is an unsupported case since the start and finish interval timestamps Do not fill timezone information.

    Workaround:  For those times that are out of order, subtract the disagreement between the brokendown and fresh timezone from the time. Or, employ the workaround provided in the bug text to modify the times.

    42.3 External Password Store Known Bugs

    When attempting to accelerate CONNECT /@db_connect_string, the connection sometimes fails with an ORA-1017 error. This can occur when the db_connect_string, which matches the credential value in the Password Store and the TNS alias in TNSNAMES.ORA is a multiple of 4 characters long.

    Workaround: When adding credential entries to the Password Store, submit confident the length of the db_connect_string is not a multiple of 4 characters long. also check that this value matches the value of the TNS alias in TNSNAMES.ORA.

    42.4 External Procedures Known Bugs

    Bug 3969675

    Oracle Database will crash in the following scenario:

    An application developer creates a nested table of user-defined type and a C external duty that takes an dispute of the nested table of user-defined type. The external duty is created with invoker's rights, so that it executes with the privileges of the user invoking the function. The application developer grants the user privileges to convoke the function, but does not award privileges to access the nested table of the user-defined type. As a result, the C external duty encounters oversight ORA-28578 when it attempts to access the dispute that was passed to it.

    Workaround: If the application developer grants privileges on the nested table of the user-defined type to the user, then the application continues to travail correctly.

    42.5 Enterprise Security Manager (ESM) Known Bugs

    Bug 4072113

    A user who is member of the OracleDBSecurityAdmins group is unable to behold any accessible domains in ESM.

    Workaround: Log in to ESM as a member of the OracleContextAdmins group. If there is no user who belongs to OracleContextAdmins group, log in as super user (cn=orcladmin) to add, delete, or view the accessible domains.

    42.6 Enterprise User Security (EUS) Known Bugs

    Bug 4393920

    EUS proxy with the connect string "connect [targetuser]/@<tnsname>" throws "SP2-0306: Invalid option" error.

    Workaround: Store the user cognomen with proxy user and target user in the wallet. For example, store user cognomen in wallet as proxyuser[targetuser] instead of just proxyuser. Then Do "connect /@<tnsname>" to connect to the database.

    42.7 OLAP Known Bugs

    Bug 4402965

    A dimension with a TEXT or NTEXT data type migrated from a 10.1.0.4.0 analytic workspace may exhibit missing or duplicate values if the dimension was created by an EIF import of more than 2047 dimension values. This includes imports performed using the Oracle Import utility.

    Workaround: Exporting and re-importing into a fresh analytic workspace may decipher this issue. However, to properly diagnose and provide a resolution, please consult bug 4402965 or Oracle Support.

    Bug 4425656

    While importing a TIME dimension into a fresh schema using the Template feature in Analytic Workspace Manager, the default sort order for the members may live lost.

    Workaround: Delete the TIME dimension attributes that finish in _DSO_X (where X is a number) before loading the data with the Maintain Wizard.

    Bug 4438324

    The default OLAP Parallel Update feature in Oracle OLAP can possibly disrupt a node in a existent Application Clusters configuration.

    Workaround: Disable OLAP Parallel Update on a existent Application Clusters system by inserting the following parameters into the init.ora file:

    _olap_parallel_update_threshold=2147483647 _olap_parallel_update_small_threshold=2147483647 42.8 Oracle convoke Interface Known Bugs

    Bug 1704273

    This bug manifests itself in MTS setups when shared db links are used between the middle-tier and the dedicated backend. The symptoms of this bug are client disconnects, accompanied by the following oversight messages: ORA-02068: following ascetic oversight from BACKEND, ORA-00022: invalid session ID; access denied.

    Workaround: Set the values of system variables mts_servers and max_mts_servers to live equal.

    Bug 4424140

    If Transparent Application Failover (TAF) is configured and a failover occurs in a OCCI/OCI application due to database connection going down, then the client side protest cache could live in a incongruous status after failover. This can result in capricious crashes. This bug manifests only if there are multiple connections, for instance, with connection pool, where objects are being used and a failover takes place.

    42.9 Oracle Clusterware Known Bugs

    Bug 4433140

    If you are installing Oracle Clusterware as a user that is a member of multiple operating system groups, the installer will install files on total nodes of the cluster with group ownership set to that of the user's current active or primary group. However, in some cases, group ownership of a minuscule number of files will live set incorrectly to the first group that the user is a member of rather than the current active group. In the illustration output of /usr/bin/id below, the current active or primary group is dba while the first group that the user is a member of is ioracle. This is determined by the order in which groups are listed in the file /etc/group.

    uid=500(oracle) gid=8000(dba) groups=7500(ioracle),8000(dba)

    Workaround: Perform any one of the following actions:

  • Ensure that the first group listed in the file /etc/ group is the current active group.

  • Invoke the Oracle Clusterware installation using the following additional command line option, to force the installer to employ the proper group when setting group ownership on total files:

    runInstaller s_usergroup=<current active group>
  • Bug 4460807

    When adding a node to Oracle Clusterware, OUI defaults to the private and virtual host names for employ on the "Specify Cluster Nodes to Add to Installation" GUI page. If you click Next without making confident the default private node or virtual host names are configured for employ or if you enter a private node cognomen or virtual host cognomen that are unreachable, you behold the following oversight message, "OUI-35000: mortal cluster oversight encountered (). remedy the problem and try to operation again."

    Workaround Make confident the private node cognomen or virtual host names are reachable by performing nslookup on them. If they are not reachable, submit confident they exist either in DNS or in /etc/hosts file. Alternatively, you can supersede the default private node and virtual host names to those that are configured for employ on your system.

    Bug 4480465

    When the "Oracle Clusterware lofty Availability API" is installed, the header file containing the Oracle defined data types oratypes.h is missing from the $ORACLE_HOME/crs/demo directory.

    Workaround: Choose the workaround here that best suits your situation.

    For runtime install, admin install, and custom install when Oracle convoke Interface component is installed:

    cd $ORACLE_HOME/crs/demo cp ../../rdbms/public/oratypes.h .

    For Custom Install when Oracle convoke Interface component is not installed, first install the Oracle convoke Interface component, and then:

    cd $ORACLE_HOME/crs/demo cp ../../rdbms/public/oratypes.h . 42.10 Oracle Database Application Known Bugs

    Bug 3969675

    Oracle Database will crash in the following scenario: An application developer creates a nested table of user-defined type and a C external duty that takes an dispute of the nested table of user-defined type. The external duty is created with invoker's rights, so that it executes with the privileges of the user invoking the function. The application developer grants the user privileges to convoke the function, but does not award privileges to access the nested table of the user-defined type. As a result, the C external duty encounters oversight ORA-28578 when it attempts to access the dispute that was passed to it.

    Workaround: If the application developer grants privileges on the nested table of the user-defined type to the user, then the application continues to travail correctly.

    42.11 Oracle Data Guard Known Bugs

    Bug 2795200

    Distributed transaction states are not preserved after failover involving a analytic standby database. The status of an in-doubt transaction at the primary database is not preserved in the analytic standby database on a failover or switchover.

    Workaround None.

    Bug 3184834

    Logical standby database shows job processes are available, although jobs cannot live executed in the analytic standby database.

    Querying the V$PARAMETER view in the analytic Standby database may justify JOB_QUEUE_PROCESSES being available, and the analytic standby database allows for scheduling jobs. However, the scheduled jobs are not executed in the analytic standby database.

    Some applications may incorrectly assume that job scheduling is possible, when it is not.

    Workaround Set JOB_QUEUE_PROCESSES to 0 before starting SQL Apply. After a failover or switchover to the database, set JOB_QUEUE_PROCESSES to the desired value.

    Bug 3199961

    The command ALTER DATABASE GUARD {ALL | STANDBY | NONE} does not propagate to total active instances in RAC. Executing the ALTER DATABASE GUARD command on one instance does not affect the other active instances in a RAC cluster. Instances that are shut down at the time of the command execution, automatically pick up the fresh guard setting when starting up.

    Workaround: Execute the ALTER DATABASE GUARD command on total active instances.

    Bug 3311688

    The Oracle Label Security feature is incompatible with SQL Apply.

    Workaround: If Oracle Label Security is in use, employ Redo Apply instead of SQL Apply for reporting and calamity recovery.

    42.12 Oracle Enterprise Manager DB Control Known Bugs

    Bug 4453868

    Japanese Oracle OLAP abet is not displayed in DB Control. English abet is displayed instead.

    Workaround: None.

    42.13 Oracle HTML DB Known Bugs

    Bug 3384664

    When you open the number or date format select popup dialog on 'Column Attribute' in 'Page Definition' of Application Builder, it always displays 'backslash'+ 5,234.10 in the dialog, it is expected that the symbol of 'yen' accurately in Japanese environment. (Note: backslash and yen are the identical character code point, but displayed differently depending on font used). Backslash is also displayed when applying the data format on the page in the application.

    Workaround: None.

    Bug 3393090

    If you create a form on a table or view based on an included column whose cognomen is in Japanese, using the Application Builder wizard, the cognomen of the fresh detail will live included in Japanese.

    Workaround: When you create fresh items on the Page Definition page in ApplicationBuilder, you need to employ alphanumeric characters A_Z, 0-9 and '_' as detail names. You also need to edit detail names to alphanumeric before you apply changes to the item.

    Bug 4459414

    ORA-31011 and ORA-19202 errors are displayed when Find button is clicked in Japanese help.

    Workaround: None.

    42.14 Oracle Locale Builder Known Bugs

    Bug 4226400

    When trying to rename a fresh folder in the File save dialog box, if another folder is clicked instantly after entering the fresh name, the clicked folder may accumulate renamed instead.

    Workaround: Avoid clicking other folders too quickly after entering the fresh folder name.

    42.15 Oracle Net Services Known Bugs

    Bug 4417761

    When listener is configured with the hasty Application Notification (FAN) feature of Oracle Database 10g existent Application Clusters, and listener is started by Listener Control Utility directly (rather than by racgmain or racgwrap), listener may fail to subscribe to the ONS node down event, thus live unable to update the corresponding service upon event notification.

    Workaround: Set the environment variable ORACLE_CONFIG_HOME to the ORA_CRS_HOME.

    42.16 Oracle ODBC Driver Known Bugs

    Bug 4428186

    Oracle ODBC Driver is not installing with Instant Client installation.

    Workaround: Copy Oracle ODBC driver library, libsqora.so.10.1,into Instant Client's target directory. The library can live copied from Client Admin Installation or Client Custom ODBC Installation or from ODBC Instant Client ZIP(odbc.zip) hosted on OTN.

    42.17 Oracle existent Application Clusters Known Bugs

    Bug 3377903

    When shutting down an instance and immediately starting it again using SQL*Plus, sometimes the CRS resource for the instance does not accumulate started, because it is silent diligent stopping. In this case, srvctl status instance -d cognomen -i sid will incorrectly report the instance not to live running.

    Workaround: Start the instance's CRS resource with srvctl status instance -d cognomen -i sid.

    Bug 4217623

    If you install Oracle Database 10g Release 1 (10.1) RAC on a cluster running Oracle Clusterware 10g Release 2 (10.2), errors will live generated by the root.sh script maxim that there is no such file or directory for the directories crs_stat and evm.auth.

    Workaround: Before running the root.sh script, set the CRS_HOME environment variable to point to the 10.2 Oracle Clusterware home.

    Bug 4409534

    When adding a node and running root.sh on the fresh node, you will accumulate the oversight message: "IP address '<VIP address>' has already been used. Enter an unused IP address.". Ignore this oversight message. The VIP for the fresh node has already been configured in the rootaddnode script

    Workaround: None.

    Bug 4411708

    During online OCR device replacement, ocrconfig might report the oversight "PROT-22: Storage too small". The ocrconfig might report this oversight because OCR makes a conservative size estimate. In some cases, the OCR might detect that the fresh replacement location is not great enough to mirror the OCR.

    Workaround: To successfully execute an online OCR replacement, the fresh replacement location must live slightly larger than the size of the original location when the OCR was first created. If the fresh OCR location is a file, then the OCR will ensure that there is enough free space on the file system.

    For example, if the original device size is 120M, then the replacement device must live at least 128M in size, or the replacement file should fill at least 128M of free space on the file system.If the original device size is 160M, then the fresh replacement device must live at least 256M in size, or the replacement file should fill at least 256M of free space on the file system.

    In total cases, the required size of the fresh replacement device is no more than 128M larger than the size of original device.

    Bug 4428985

    When performing a CRS install on a node with an existing inventory, the following problem will live seen if the user goes back from the Summary page and then proceeds with the install. After the install, a dialog box will appear, asking you to accelerate orainstRoot.sh and root.sh. The root.sh script entry shows the list of total nodes on which the script has to live run. However, the list of nodes on which to accelerate orainstRoot.sh is blank.

    Workaround: On encountering this problem, ignore the orainstRoot.sh entry and only accelerate root.sh on the listed nodes. It is not required to accelerate orainstRoot.sh since the central inventory is created and appropriately registered in the oraInst.loc file. In cases where one or more nodes Do not fill the central inventory setup, OUI will list the remedy nodes on which to accelerate orainstRoot.sh. The users should supervene instructions to execute the script on those nodes.

    Bug 4430689

    When upgrading your Oracle9i release 9.2 RAC environment to Oracle Database 10g Release 2 (10.2), you are prompted to specify one or more Voting Disks during the Oracle Clusterware installation. You must specify a fresh location for the voting disk in Oracle Database 10g Release 2 (10.2). You cannot reuse the brokendown Oracle9i release 9.2 quorum disk for this purpose.

    Workaround: Enter a fresh location for voting device.

    Bug 4449401

    When installing 10gR2 CRS software on a cluster with 920x cluster repository on a raw device, if you behold the message "PROT-8: Failed to import data from specified file to the cluster registery" while running rootupgrade.sh and the message "utopen:12:Not enough space in the backing store" in the log file $ORA_CRS_HOME/log/<hostname>/client/ocrconfig_<pid>.log then employ the following workaround.

    Workaround: Identify a raw device that has 100MB or more space. Locate the existing raw device cognomen from /var/opt/oracle/srvConfig.loc and copy the contents of this raw device to the fresh device using the dd command.

    Bug 4454562

    When CRS_HOME is shared among multiple nodes in the cluster, ONS daemons on some nodes may not start properly. This may reason CRS ONS resources to live OFFLINE.

    Workaround: Perform the following steps.

  • Stop ONS daemons on total nodes by issuing CRS command for each node.

    crs_stop -f ora.<nodename>.ons

    To find the list of nodes accelerate <CRS_HOME>/bin/olsnodes.

  • Make confident there is no ONS daemon left running on each node by the following script.

  • Add the following line to file <CRS_HOME>/opmn/conf/ons.config.

    usesharedinstall=true
  • Start ONS daemons on each node by issuing CRS command.

    crs_start ora.<nodename>.ons
  • Bug 4457480

    When the user specifies cluster nodes and network configuration on the Cluster Specification page, returns to the Cluster Registry Setup page, and then returns to the Cluster Specification page and clicks Next, the network configuration page does not appear.

    Workaround: The user should fade back one more step to the product-specific prerequisites page and then fade through the subsequent pages of the install. Alternatively, the user may quit and restart the installation.

    42.18 Oracle Wallet Manager

    Bugs 4384718, 3066733

    Depending on the character set specified during installation, Oracle Wallet Manager may reject certificate requests with special characters in the common name, organizational unit, or organization fields. For example:

    cn: John Brown, III o: Brown, Inc.

    This is another such example:

    cn: John Brown III o: Brown & Associates

    The oversight message returned is "Could not create certificate request. please check the user information."

    Workaround: Avoid using special characters, or substitute an ampersand (&) with the long form.

    42.19 Oracle XML DB Known Bugs

    Bug 3141321

    When running in Oracle existent Application Clusters mode, multiple instances of Oracle XML DB may hang during a DBMS_XMLSCHEMA.DELETESCHEMA call.

    If a session from node A performs an operation on the identical schema that node B is attempting to delete, the DELETESCHEMA operation will hang. This happens because the session pool will remain with node A during the DELETESCHEMA call; the pool is cleared only for the local instance.

    Workaround: Shut down total nodes that fill accessed the schema.

    Bug 3330788

    Direct path loading is not supported if the schema-based xml column is not a top-level column of a table, or if the types created for the schema-based xml involve inheritance.

    Workaround: Use conventional loading to load the data through SQL*Loader.

    42.20 Pro*C Known Bugs

    Bug 1466269

    Hints are not precompiled properly when used in an EXEC SQL justify arrangement statement. The hints are not carried forward in the Pro*C generated code.

    Workaround: None.

    Bug 1323304

    When PL/SQL code is used in a version of Pro*C that has embedded \n characters, if the statement is sufficiently long, it has to live split into a convoke to sqlbuft and also live placed in sqlstm.stmt. This results in incongruous escaping for \n in sqlbuft, with a runtime oversight in prepare:

    PLS-00103: Encountered the symbol "\" when expecting ...

    Workaround: Edit the generated C file to remove the extra backslashes when the statement is split.

    Bug 658837

    While precompiling even with SQLCHECK=FULL, Pro*C doesn't detect invalid column names in UPDATE statement when WHERE CURRENT OF clause is used.

    Workaround: None.

    42.21 Pro*COBOL Known Bugs

    Bug 1897639

    Referring to an implicit VARCHAR within a group detail returns a PCB-S-00208 oversight while precompiling with Pro*Cobol.

    Workaround: Add an EXEC SQL VAR statement before referring it as host variable as follows:

    EXEC SQL VAR <varchar group detail name> IS VARCHAR(<size>) END-EXEC

    Bug 1656765

    Using the embrace statement to copy files, which accommodate IDENTIFICATION, ENVIRONMENT, DATA, and PROCEDURE DIVISION, into a host program as sub programs, Pro*Cobol fails with PCB-S-00400 error. This problem happens if .pco files employ EXEC SQL embrace statements to embrace one nested program after another nested program.

    Workaround Put two files into one embrace file. If PROCEDURE DIVISION has only one embrace statement, Pro*Cobol precompiler succeeds in generating a .cob file. The included .pco file should not accommodate IDENTIFICATION DIVISION, any DIVISIONS for that matter but only code (routines).

    Bug 1620777

    If a host variable is defined by adding the keyword VARYING, and then the data type is overridden using data type equivalencies, the length value of the expanded string province is increased by 2.

    Workaround None.

    Bug 953338

    When a Pro*Cobol program is precompiled with embedded PL/SQL using select /*+ index hint */ statement, PCB-S-00567, PLS-103 errors are returned.

    Workaround None.

    42.22 RMAN Known Bugs

    Bug 6415310

    In Oracle Database 10g, if you accelerate a BACKUP VALIDATE command in an RMAN session, and if RMAN encounters a hide that was previously marked as corrupt, then the RMAN output does not report this debauch block. The backup will not fail if known debauch blocks are establish in the data file.

    Workaround: To identify previously marked debauch blocks you must query V$DATABASE_BLOCK_CORRUPTION or V$BACKUP_CORRUPTION or check the alert log.

    Bug 3479963

    Errors occur when backing up archived logs to a DVD writer on Windows.

    Workaround: None.

    Bug 2722635

    The RMAN CROSSCHECK command can force the retrieval of files that fill been migrated to HSM, because it opens the file to verify the contents of the first few blocks.

    Workaround: Some HSM systems can live configured to leave a minuscule portion of the file on disk. If that is possible, then this problem can live avoided by leaving the first 4M of every migrated file on disk. If that is not possible, then there is no workaround other than to not employ the CROSSCHECK command.

    Bug 2656503

    RMAN cannot back up transported tablespaces unless they fill been made read-write after they fill been transported. It is not necessary to leave them in read-write status, but they cannot live backed up by RMAN unless they fill been made read-write once, if only briefly, after they fill been plugged in.

    Workaround: None.

    Bug 2692990

    When restoring files at a standby database using recovery catalog, RMAN attempts to employ the file names of the primary database for the restored files.

    Workaround: Use SET NEWNAME to restore the files to the remedy locations.

    Bug 2670671

    Lack of statistics in RMAN catalog schema can lead to impoverished performance.

    Workaround: Occasionally employ the ALTER USER ... COMPUTE STATISTICS command to re-compute the statics for the RMAN catalog schema.

    Bug 2353334

    RMAN backups will fail with internal errors when a non-standard db_block_size, such as 6k, is used, and the tablespace that is being backed up has a measure hide size, such as 8k or 16k.

    Workaround: Contact Oracle champion for the workaround if you encounter this bug.

    42.23 sole Instance to RAC Conversion implement Known Bugs

    Bug 4456047

    SHUTDOWN IMMEDIATE may hang when converting a sole instance database to a RAC database using the rconfig utility. This is caused by an idle RMAN session.

    Workaround: After confirming that SHUTDOWN IMMEDIATE is hanging by inspecting the alert log, stop the RMAN process.

    42.24 Transparent Data Encryption Known Bugs

    Bug 4436949

    The BINARY_FLOAT data type and the BINARY_DOUBLE data type are currently not supported for encryption.

    Workaround: None.

    42.25 Utilities Known Bugs

    Bug 2770880

    When a READ_ONLY tablespace is imported into the target database using Data Pump Import, it is created OFFLINE.

    Workaround: The tablespace can live manually set back to READ_ONLY when the Data Pump Import completes.

    Bug 3309770

    If an protest type in one schema references an protest type in another schema, there will live compilation warnings when Data Pump Import creates the first protest type.

    Workaround: The protest types can live manually revalidated once Data Pump Import completes.

    Bug 3369197

    Errors will result when attempting to execute a network mode Data Pump Import using the NETWORK_LINK parameter if the source database table contains a LONG data type.

    Workaround: Use a measure dumpfile-based Data Pump Export and Import of the table that contains the LONG data type.

    Bug 3392310

    Data Pump Export and Original Export fail with ORA-29341: The transportable set is not self-contained oversight message when in transportable mode.

    Workaround: Use EXCLUDE=CONSTRAINT with Data Pump Export and CONSTRAINTS=N with original export.

    Workaround: Use original export instead of Data Pump Export if your tablespace contains a nested table.

    Bug 4046665

    Multibyte characters are unavailable in Automatic Storage Management command utility. There is no internationalization champion for ASMCMD in Oracle Database 10g release 2 (10.2).

    Workaround: None.

    Bug 4444014

    If a rebalance wait is in progress and another rebalance is initiated locally or on any node in the cluster, the first rebalance wait will betoken completion.

    Workaround: Do not interrupt the ongoing rebalance or employ the wait option on the fresh rebalance.

    42.26 Workflow Known Bugs

    Bug 4451346

    Oracle Workflow Server Japanese abet is not displayed. Only English online abet is active.

    Workaround: None.

    Bug 4453877

    For translated languages, Workflow Configuration aide fails to Workflow server.

    Workaround: Set system locale to English, then employ English Workflow Configuration aide to install, or edit the wfinstall.bat / wfinstall.csh and add "/tablespace Default" at the finish of WFCA command.

    43 Documentation Accessibility

    Our goal is to submit Oracle products, services, and supporting documentation accessible, with helpful usability, to the disabled community. To that end, their documentation includes features that submit information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that their documentation can live accessible to total of their customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.

    Accessibility of Code Examples in Documentation

    Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should materialize on an otherwise bare line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

    Accessibility of Links to External Web Sites in Documentation

    This documentation may accommodate links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

    TTY Access to Oracle champion Services

    Oracle provides dedicated Text Telephone (TTY) access to Oracle champion Services within the United States of America 24 hours a day, 7 days a week. For TTY support, convoke 800.446.2398. Outside the United States, convoke +1.407.458.2479.

    Oracle Database Readme, 10g Release 2 (10.2)

    B14233-06

    Copyright © 2001, 2008, Oracle. total rights reserved.

    The Programs (which embrace both the software and documentation) accommodate proprietary information; they are provided under a license agreement containing restrictions on employ and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited.

    The information contained in this document is theme to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to live error-free. Except as may live expressly permitted in your license agreement for these Programs, no allotment of these Programs may live reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose.

    If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable:

    U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall live theme to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software--Restricted Rights (June 1987). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

    The Programs are not intended for employ in any nuclear, aviation, mass transit, medical, or other inherently hazardous applications. It shall live the licensee's responsibility to steal total appropriate fail-safe, backup, redundancy and other measures to ensure the safe employ of such applications if the Programs are used for such purposes, and they disclaim liability for any damages caused by such employ of the Programs.

    Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may live trademarks of their respective owners.

    The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not accountable for the availability of, or any content provided on, third-party Web sites. You endure total risks associated with the employ of such content. If you select to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not accountable for: (a) the trait of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not accountable for any loss or damage of any sort that you may incur from dealing with any third party.


    Upgrading from 7.3.4 to 9i with PowerBuilder | killexams.com existent questions and Pass4sure dumps

    I am upgrading an Oracle 7.3.4 database to Oracle9i. I fill many systems using PowerBuilder v7 and Developer 2000 to communicate with this database. What benevolent of issues Do I fill to explore into when planning out this upgrade? I already know it will require a PowerBuilder upgrade.

    There were many changes introduced to the Oracle database between release 7.3.4 and 9.2 so an upgrade will definitely affect any applications that are hosted in your database. I would insinuate that you select the best migration path for your database (this would depend on the size of the database, length of production outage allowed, etc.) and then execute the upgrade process several times in a non-production environment. After the database is upgraded each time, ensure that total application champion teams affected by this upgrade fill a casual to test their applications.

    The Oracle9i Release 2 (9.2) Database Migration steer is a helpful resource to assist you with this upgrade. The steer is located on Oracle's Technology Network Web site.

    The key word to remember when upgrading is test, test, test!



    Direct Download of over 5500 Certification Exams

    3COM [8 Certification Exam(s) ]
    AccessData [1 Certification Exam(s) ]
    ACFE [1 Certification Exam(s) ]
    ACI [3 Certification Exam(s) ]
    Acme-Packet [1 Certification Exam(s) ]
    ACSM [4 Certification Exam(s) ]
    ACT [1 Certification Exam(s) ]
    Admission-Tests [13 Certification Exam(s) ]
    ADOBE [93 Certification Exam(s) ]
    AFP [1 Certification Exam(s) ]
    AICPA [2 Certification Exam(s) ]
    AIIM [1 Certification Exam(s) ]
    Alcatel-Lucent [13 Certification Exam(s) ]
    Alfresco [1 Certification Exam(s) ]
    Altiris [3 Certification Exam(s) ]
    Amazon [2 Certification Exam(s) ]
    American-College [2 Certification Exam(s) ]
    Android [4 Certification Exam(s) ]
    APA [1 Certification Exam(s) ]
    APC [2 Certification Exam(s) ]
    APICS [2 Certification Exam(s) ]
    Apple [69 Certification Exam(s) ]
    AppSense [1 Certification Exam(s) ]
    APTUSC [1 Certification Exam(s) ]
    Arizona-Education [1 Certification Exam(s) ]
    ARM [1 Certification Exam(s) ]
    Aruba [6 Certification Exam(s) ]
    ASIS [2 Certification Exam(s) ]
    ASQ [3 Certification Exam(s) ]
    ASTQB [8 Certification Exam(s) ]
    Autodesk [2 Certification Exam(s) ]
    Avaya [96 Certification Exam(s) ]
    AXELOS [1 Certification Exam(s) ]
    Axis [1 Certification Exam(s) ]
    Banking [1 Certification Exam(s) ]
    BEA [5 Certification Exam(s) ]
    BICSI [2 Certification Exam(s) ]
    BlackBerry [17 Certification Exam(s) ]
    BlueCoat [2 Certification Exam(s) ]
    Brocade [4 Certification Exam(s) ]
    Business-Objects [11 Certification Exam(s) ]
    Business-Tests [4 Certification Exam(s) ]
    CA-Technologies [21 Certification Exam(s) ]
    Certification-Board [10 Certification Exam(s) ]
    Certiport [3 Certification Exam(s) ]
    CheckPoint [41 Certification Exam(s) ]
    CIDQ [1 Certification Exam(s) ]
    CIPS [4 Certification Exam(s) ]
    Cisco [318 Certification Exam(s) ]
    Citrix [48 Certification Exam(s) ]
    CIW [18 Certification Exam(s) ]
    Cloudera [10 Certification Exam(s) ]
    Cognos [19 Certification Exam(s) ]
    College-Board [2 Certification Exam(s) ]
    CompTIA [76 Certification Exam(s) ]
    ComputerAssociates [6 Certification Exam(s) ]
    Consultant [2 Certification Exam(s) ]
    Counselor [4 Certification Exam(s) ]
    CPP-Institue [2 Certification Exam(s) ]
    CPP-Institute [1 Certification Exam(s) ]
    CSP [1 Certification Exam(s) ]
    CWNA [1 Certification Exam(s) ]
    CWNP [13 Certification Exam(s) ]
    Dassault [2 Certification Exam(s) ]
    DELL [9 Certification Exam(s) ]
    DMI [1 Certification Exam(s) ]
    DRI [1 Certification Exam(s) ]
    ECCouncil [21 Certification Exam(s) ]
    ECDL [1 Certification Exam(s) ]
    EMC [129 Certification Exam(s) ]
    Enterasys [13 Certification Exam(s) ]
    Ericsson [5 Certification Exam(s) ]
    ESPA [1 Certification Exam(s) ]
    Esri [2 Certification Exam(s) ]
    ExamExpress [15 Certification Exam(s) ]
    Exin [40 Certification Exam(s) ]
    ExtremeNetworks [3 Certification Exam(s) ]
    F5-Networks [20 Certification Exam(s) ]
    FCTC [2 Certification Exam(s) ]
    Filemaker [9 Certification Exam(s) ]
    Financial [36 Certification Exam(s) ]
    Food [4 Certification Exam(s) ]
    Fortinet [13 Certification Exam(s) ]
    Foundry [6 Certification Exam(s) ]
    FSMTB [1 Certification Exam(s) ]
    Fujitsu [2 Certification Exam(s) ]
    GAQM [9 Certification Exam(s) ]
    Genesys [4 Certification Exam(s) ]
    GIAC [15 Certification Exam(s) ]
    Google [4 Certification Exam(s) ]
    GuidanceSoftware [2 Certification Exam(s) ]
    H3C [1 Certification Exam(s) ]
    HDI [9 Certification Exam(s) ]
    Healthcare [3 Certification Exam(s) ]
    HIPAA [2 Certification Exam(s) ]
    Hitachi [30 Certification Exam(s) ]
    Hortonworks [4 Certification Exam(s) ]
    Hospitality [2 Certification Exam(s) ]
    HP [750 Certification Exam(s) ]
    HR [4 Certification Exam(s) ]
    HRCI [1 Certification Exam(s) ]
    Huawei [21 Certification Exam(s) ]
    Hyperion [10 Certification Exam(s) ]
    IAAP [1 Certification Exam(s) ]
    IAHCSMM [1 Certification Exam(s) ]
    IBM [1532 Certification Exam(s) ]
    IBQH [1 Certification Exam(s) ]
    ICAI [1 Certification Exam(s) ]
    ICDL [6 Certification Exam(s) ]
    IEEE [1 Certification Exam(s) ]
    IELTS [1 Certification Exam(s) ]
    IFPUG [1 Certification Exam(s) ]
    IIA [3 Certification Exam(s) ]
    IIBA [2 Certification Exam(s) ]
    IISFA [1 Certification Exam(s) ]
    Intel [2 Certification Exam(s) ]
    IQN [1 Certification Exam(s) ]
    IRS [1 Certification Exam(s) ]
    ISA [1 Certification Exam(s) ]
    ISACA [4 Certification Exam(s) ]
    ISC2 [6 Certification Exam(s) ]
    ISEB [24 Certification Exam(s) ]
    Isilon [4 Certification Exam(s) ]
    ISM [6 Certification Exam(s) ]
    iSQI [7 Certification Exam(s) ]
    ITEC [1 Certification Exam(s) ]
    Juniper [64 Certification Exam(s) ]
    LEED [1 Certification Exam(s) ]
    Legato [5 Certification Exam(s) ]
    Liferay [1 Certification Exam(s) ]
    Logical-Operations [1 Certification Exam(s) ]
    Lotus [66 Certification Exam(s) ]
    LPI [24 Certification Exam(s) ]
    LSI [3 Certification Exam(s) ]
    Magento [3 Certification Exam(s) ]
    Maintenance [2 Certification Exam(s) ]
    McAfee [8 Certification Exam(s) ]
    McData [3 Certification Exam(s) ]
    Medical [69 Certification Exam(s) ]
    Microsoft [374 Certification Exam(s) ]
    Mile2 [3 Certification Exam(s) ]
    Military [1 Certification Exam(s) ]
    Misc [1 Certification Exam(s) ]
    Motorola [7 Certification Exam(s) ]
    mySQL [4 Certification Exam(s) ]
    NBSTSA [1 Certification Exam(s) ]
    NCEES [2 Certification Exam(s) ]
    NCIDQ [1 Certification Exam(s) ]
    NCLEX [2 Certification Exam(s) ]
    Network-General [12 Certification Exam(s) ]
    NetworkAppliance [39 Certification Exam(s) ]
    NI [1 Certification Exam(s) ]
    NIELIT [1 Certification Exam(s) ]
    Nokia [6 Certification Exam(s) ]
    Nortel [130 Certification Exam(s) ]
    Novell [37 Certification Exam(s) ]
    OMG [10 Certification Exam(s) ]
    Oracle [279 Certification Exam(s) ]
    P&C [2 Certification Exam(s) ]
    Palo-Alto [4 Certification Exam(s) ]
    PARCC [1 Certification Exam(s) ]
    PayPal [1 Certification Exam(s) ]
    Pegasystems [12 Certification Exam(s) ]
    PEOPLECERT [4 Certification Exam(s) ]
    PMI [15 Certification Exam(s) ]
    Polycom [2 Certification Exam(s) ]
    PostgreSQL-CE [1 Certification Exam(s) ]
    Prince2 [6 Certification Exam(s) ]
    PRMIA [1 Certification Exam(s) ]
    PsychCorp [1 Certification Exam(s) ]
    PTCB [2 Certification Exam(s) ]
    QAI [1 Certification Exam(s) ]
    QlikView [1 Certification Exam(s) ]
    Quality-Assurance [7 Certification Exam(s) ]
    RACC [1 Certification Exam(s) ]
    Real-Estate [1 Certification Exam(s) ]
    RedHat [8 Certification Exam(s) ]
    RES [5 Certification Exam(s) ]
    Riverbed [8 Certification Exam(s) ]
    RSA [15 Certification Exam(s) ]
    Sair [8 Certification Exam(s) ]
    Salesforce [5 Certification Exam(s) ]
    SANS [1 Certification Exam(s) ]
    SAP [98 Certification Exam(s) ]
    SASInstitute [15 Certification Exam(s) ]
    SAT [1 Certification Exam(s) ]
    SCO [10 Certification Exam(s) ]
    SCP [6 Certification Exam(s) ]
    SDI [3 Certification Exam(s) ]
    See-Beyond [1 Certification Exam(s) ]
    Siemens [1 Certification Exam(s) ]
    Snia [7 Certification Exam(s) ]
    SOA [15 Certification Exam(s) ]
    Social-Work-Board [4 Certification Exam(s) ]
    SpringSource [1 Certification Exam(s) ]
    SUN [63 Certification Exam(s) ]
    SUSE [1 Certification Exam(s) ]
    Sybase [17 Certification Exam(s) ]
    Symantec [134 Certification Exam(s) ]
    Teacher-Certification [4 Certification Exam(s) ]
    The-Open-Group [8 Certification Exam(s) ]
    TIA [3 Certification Exam(s) ]
    Tibco [18 Certification Exam(s) ]
    Trainers [3 Certification Exam(s) ]
    Trend [1 Certification Exam(s) ]
    TruSecure [1 Certification Exam(s) ]
    USMLE [1 Certification Exam(s) ]
    VCE [6 Certification Exam(s) ]
    Veeam [2 Certification Exam(s) ]
    Veritas [33 Certification Exam(s) ]
    Vmware [58 Certification Exam(s) ]
    Wonderlic [2 Certification Exam(s) ]
    Worldatwork [2 Certification Exam(s) ]
    XML-Master [3 Certification Exam(s) ]
    Zend [6 Certification Exam(s) ]





    References :


    Issu : https://issuu.com/trutrainers/docs/1z0-035
    Dropmark : http://killexams.dropmark.com/367904/11786009
    Wordpress : http://wp.me/p7SJ6L-1Er
    Dropmark-Text : http://killexams.dropmark.com/367904/12514491
    Blogspot : http://killexamsbraindump.blogspot.com/2017/12/kill-your-1z0-035-exam-at-first-attempt.html
    RSS Feed : http://feeds.feedburner.com/Pass4sure1z0-035RealQuestionBank
    Box.net : https://app.box.com/s/6334ppt9xox12nnxwssz514ep4eoqddn
    zoho.com : https://docs.zoho.com/file/67jzb50a611cafaf643208f8172dfa3b30c60











    Killexams 1Z0-035 exams | Killexams 1Z0-035 cert | Pass4Sure 1Z0-035 questions | Pass4sure 1Z0-035 | pass-guaratee 1Z0-035 | best 1Z0-035 test preparation | best 1Z0-035 training guides | 1Z0-035 examcollection | killexams | killexams 1Z0-035 review | killexams 1Z0-035 legit | kill 1Z0-035 example | kill 1Z0-035 example journalism | kill exams 1Z0-035 reviews | kill exam ripoff report | review 1Z0-035 | review 1Z0-035 quizlet | review 1Z0-035 login | review 1Z0-035 archives | review 1Z0-035 sheet | legitimate 1Z0-035 | legit 1Z0-035 | legitimacy 1Z0-035 | legitimation 1Z0-035 | legit 1Z0-035 check | legitimate 1Z0-035 program | legitimize 1Z0-035 | legitimate 1Z0-035 business | legitimate 1Z0-035 definition | legit 1Z0-035 site | legit online banking | legit 1Z0-035 website | legitimacy 1Z0-035 definition | >pass 4 sure | pass for sure | p4s | pass4sure certification | pass4sure exam | IT certification | IT Exam | 1Z0-035 material provider | pass4sure login | pass4sure 1Z0-035 exams | pass4sure 1Z0-035 reviews | pass4sure aws | pass4sure 1Z0-035 security | pass4sure coupon | pass4sure 1Z0-035 dumps | pass4sure cissp | pass4sure 1Z0-035 braindumps | pass4sure 1Z0-035 test | pass4sure 1Z0-035 torrent | pass4sure 1Z0-035 download | pass4surekey | pass4sure cap | pass4sure free | examsoft | examsoft login | exams | exams free | examsolutions | exams4pilots | examsoft download | exams questions | examslocal | exams practice |



    International Edition Textbooks

    Save huge amounts of cash when you buy international edition textbooks from TEXTBOOKw.com. An international edition is a textbook that has been published outside of the US and can be drastically cheaper than the US edition.

    ** International edition textbooks save students an average of 50% over the prices offered at their college bookstores.

    Highlights > Recent Additions
    Showing Page 1 of 5
    Operations & Process Management: Principles & Practice for Strategic ImpactOperations & Process Management: Principles & Practice for Strategic Impact
    By Nigel Slack, Alistair Jones
    Publisher : Pearson (Feb 2018)
    ISBN10 : 129217613X
    ISBN13 : 9781292176130
    Our ISBN10 : 129217613X
    Our ISBN13 : 9781292176130
    Subject : Business & Economics
    Price : $75.00
    Computer Security: Principles and PracticeComputer Security: Principles and Practice
    By William Stallings, Lawrie Brown
    Publisher : Pearson (Aug 2017)
    ISBN10 : 0134794109
    ISBN13 : 9780134794105
    Our ISBN10 : 1292220619
    Our ISBN13 : 9781292220611
    Subject : Computer Science & Technology
    Price : $65.00
    Urban EconomicsUrban Economics
    By Arthur O’Sullivan
    Publisher : McGraw-Hill (Jan 2018)
    ISBN10 : 126046542X
    ISBN13 : 9781260465426
    Our ISBN10 : 1260084493
    Our ISBN13 : 9781260084498
    Subject : Business & Economics
    Price : $39.00
    Urban EconomicsUrban Economics
    By Arthur O’Sullivan
    Publisher : McGraw-Hill (Jan 2018)
    ISBN10 : 0078021782
    ISBN13 : 9780078021787
    Our ISBN10 : 1260084493
    Our ISBN13 : 9781260084498
    Subject : Business & Economics
    Price : $65.00
    Understanding BusinessUnderstanding Business
    By William G Nickels, James McHugh, Susan McHugh
    Publisher : McGraw-Hill (Feb 2018)
    ISBN10 : 126021110X
    ISBN13 : 9781260211108
    Our ISBN10 : 126009233X
    Our ISBN13 : 9781260092332
    Subject : Business & Economics
    Price : $75.00
    Understanding BusinessUnderstanding Business
    By William Nickels, James McHugh, Susan McHugh
    Publisher : McGraw-Hill (May 2018)
    ISBN10 : 1260682137
    ISBN13 : 9781260682137
    Our ISBN10 : 126009233X
    Our ISBN13 : 9781260092332
    Subject : Business & Economics
    Price : $80.00
    Understanding BusinessUnderstanding Business
    By William Nickels, James McHugh, Susan McHugh
    Publisher : McGraw-Hill (Jan 2018)
    ISBN10 : 1260277143
    ISBN13 : 9781260277142
    Our ISBN10 : 126009233X
    Our ISBN13 : 9781260092332
    Subject : Business & Economics
    Price : $77.00
    Understanding BusinessUnderstanding Business
    By William Nickels, James McHugh, Susan McHugh
    Publisher : McGraw-Hill (Jan 2018)
    ISBN10 : 1259929434
    ISBN13 : 9781259929434
    Our ISBN10 : 126009233X
    Our ISBN13 : 9781260092332
    Subject : Business & Economics
    Price : $76.00
    1Z0-0351Z0-035
    By Peter W. Cardon
    Publisher : McGraw-Hill (Jan 2017)
    ISBN10 : 1260128474
    ISBN13 : 9781260128475
    Our ISBN10 : 1259921883
    Our ISBN13 : 9781259921889
    Subject : Business & Economics, Communication & Media
    Price : $39.00
    1Z0-0351Z0-035
    By Peter Cardon
    Publisher : McGraw-Hill (Feb 2017)
    ISBN10 : 1260147150
    ISBN13 : 9781260147155
    Our ISBN10 : 1259921883
    Our ISBN13 : 9781259921889
    Subject : Business & Economics, Communication & Media
    Price : $64.00
    Result Page : 1 2 3 4 5