Friday, April 11, 2008

Looking for ideas...

I use a couple of venues to generate new material, new talking material every year.  Hotsos symposium has always been one, Oracle University Seminars have been another.  Oracle OpenWorld is definitely one as well.

Well, believe it or not, it is time for me to submit my abstract for Oracle OpenWorld already - even though it is not until September.  So, it is time to come up with yet another topic.  I've been known to do a "top ten" style presentation for a while at OpenWorld - the last few years have been top tens on 9i Release 2, 10g Releases 1 and 2 and most recently - 11g Release 1.  Intermixed with that was a database 'worst practices' presentation as well.

So, now - I'm looking for some fresh ideas.  A topic that can be well covered in an hour and would have broad general appeal.  In reality - if I get a couple of good ideas, I'll probably generate the material for all of them but just pick one (maybe two) for presentation at OpenWorld. 

So, I invite you to submit an idea - doesn't have to be fully fleshed out - just a concept, something you would find useful at a venue such as OpenWorld (or a presentation to a user group - as this is where this material will be used time and time again...)

Thanks in advance for any ideas!

POST A COMMENT

72 Comments:

Anonymous Anonymous said....

What about the new partitioning features on 11g?
Since I come from the DW world...

Fri Apr 11, 12:39:00 PM EDT  

Blogger Galuvian said....

I have an application that would be perfect to use Change Notification in. We've been trying to use it on and off for a while now. Every time we turn it on, we find yet another pitfall.

The features are adequately documented, but there isn't much in the way of a body of knowledge on the best ways to use it and when it can get you into trouble.

Although Change Notification can be used in PL/SQL, I am primarily concerned with using it from C# using ODP and a GUI. For instance, I didn't expect that using the feature would introduce threading issues...

Fri Apr 11, 12:55:00 PM EDT  

Blogger Alberto Dell'Era said....

Advanced Queueing is something you have never covered (so it might be interesting for you), and which is very useful in many contexts, yet rarely used since it is perceived as "complicated" (since it is a bit feature-rich, hence complex to understand at first sight).

Basic scenario: many worker processes (oracle jobs?) that read from the same request queue (that synchronizes the dispatching) ... substitutes the frequently-abused polling on "request tables".

Fri Apr 11, 01:18:00 PM EDT  

Anonymous Anonymous said....

What about,
"Top Ten Things that do not Scale with Oracle DB" ?
Of course Streams AQ, Partitioning are useful ones.

Fri Apr 11, 03:37:00 PM EDT  

Anonymous Anonymous said....

You have always said that an application that cannot scale in single instance DB will not scale in a RAC.
For a change assuming an application that scales in a single instance, what are the pitfalls/caveats when comes to RAC from an application developer perspective. eg: JDBC 11g new features for RAC(FCF,TAF)

Fri Apr 11, 03:43:00 PM EDT  

Anonymous David Aldridge said....

I like Alberto's idea of covering Advanced Queuing, but it could perhaps be expanded to "Features You're Paying For That You Ought To Be Using".

I'm sure you get a lot of "How do we code this?" questions for which the answer is "We'vealready done it for you" that would be good fodder.

I'm assuming there's an OOW pass to the submitter of the chosen idea, of course.

Fri Apr 11, 04:18:00 PM EDT  

Blogger Joel Garry said....

1. Stored Procedures - Angelic, or Evil?

2. Why participate in volunteer forums? I think there's a whole new generation that might want to hear your personal experiences with that, especially as it has advanced your understanding.

word: xwvwyq
word: bpvdwftg

Fri Apr 11, 04:44:00 PM EDT  

Blogger Glenn said....

In agreement with Alberto and David Aldridg. Some bit of Oracle functionality that you've seen either misused or not used when it should be. Application_info would meet my requirements in every place i have worked (at least until I got there ;)

Fri Apr 11, 08:15:00 PM EDT  

Blogger Tony said....

I really like the "Things you are paying for and not using" idea. There is so many features that it is hard to keep up - many of them make re-inventing the wheel unnecessary. XDB comes to mind.

Fri Apr 11, 09:00:00 PM EDT  

Blogger Karthick. said....

by seeing the presentations that are available for us in asktom.com i can see you have talked a lot about tech stuff about oracle. All of them are very much interesting and an assert to every one.

but what i would like to here from you being a developer is a presentation on "How to approach development" its not just about writing PL/SQL but in general for any language.

for instance the user of WHEN OTHERS. i have seen you talk a lot about it in asktom. why not a presentation on it. and other nice principals like the one that you say

1. do it in SQL
2. if not SQL a little PL/SQL
3. if not PL/SQL a little Java
4. if not java a little c
5. if not c then think is it really necessary.

in short if you been asked to write a code how you will go bout it. where you will start and how you will proceed. what all you keep in your mind wile writing it.

i am not sure if all this is worth talking in the presentations that you give as i have never been to one. because i have no idea about the kind of audiences that you address.

why i would like to see these things is because these are the undocumented stuff. no one documents these things and yet these are the most important aspect of development.

Thank you,

Karthick.

Sat Apr 12, 03:42:00 AM EDT  

Blogger Karthick. said....

thinking further i got this topic in mind.

"What a developer should do to make his DBA love him"

could be very interesting!!!

Sat Apr 12, 03:51:00 AM EDT  

Blogger Max McDonald said....

Hey...you never touched the list I provided when you first asked for this :-)

http://tkyte.blogspot.com/2005/11/looking-for-suggestions.html

Sat Apr 12, 09:53:00 AM EDT  

Blogger Juan Luis said....

Simple things to make a better IT dept.

becareful about the Boss of the mobil banking junior developer.

2 o 3 examples about how an IT dept can be organized.

the capability of each role and the know how of each role "the DBA must be one of the guys".

some tips for that guys that take? desicions.

Sat Apr 12, 11:27:00 AM EDT  

Blogger Craig Thomas said....

How about dealing with PCI/Sarbanes-Oxley requirements? Auditing, using database/audit vault efficiently, more on encryption.....

Sat Apr 12, 07:12:00 PM EDT  

Anonymous Anonymous said....

Tom -
You can now do pretty much ANYTHING in Oracle database like call external programs, pattern matching, HTTP post, Call web service, AQ etc...

If you can come up with something that tell us this is good for the database and this is good for middleware etc. that would be great.

Sat Apr 12, 10:20:00 PM EDT  

Blogger Anton Kovalenko said....

As for me I would be very intrested to listen to a presentation about testing and deployment techniques used by PL/SQL developers in Oracle Corporation, for instance.

Or, as a joke, an answer to a very tricky question "why sql*plus still has no history browsing ability as bash has"?

Sun Apr 13, 06:33:00 AM EDT  

Blogger robert said....

This sounds like something you probably have done already - I would find it interesting nevertheless:

The evolution of the CBO
- beginnings
- why it was invented (deficiencies of RBO)
- what changed between versions and where are particular pitfalls when migrating an application to the next version of Oracle
- 11g and beyond

Somehow I compare this with the evolution of the Java Virtual Machine - the environment becomes smarter to make clean code (hint-less SQL) perform optimal. Maybe this can be the red line through the topic.

Sun Apr 13, 09:12:00 AM EDT  

Anonymous Mette said....

How to survive in a heterogeneous environment using Java, Bea, Hibernate - and Oracle!

Almost all installations are mixed, SOA is here (java/bea/JMS/webservices). How do we see Oracle in all this and do not end up as old bitter men and women - looking like dinosaurs to the rest of the world.

Sun Apr 13, 09:56:00 AM EDT  

Anonymous The guy who writes the scripts they run said....

How about the top ten things a DBA must know? I have met a lot of "DBA"s that don't know RMAN, can't write PL/SQL (or any other code, for that matter), can't administer without a GUI, etc.

I know I'm preaching to the choir here, but if nothing else this would be good to show management why I get frustrated when they hire somebody as a DBA who doesn't know how to recover a database or switch the profile for a group of users without clicking on them one by one (and doesn't want to learn)...

Sun Apr 13, 02:07:00 PM EDT  

Anonymous Anonymous said....

"How to use Metalink without frustration"

"BP for FGA in large databases"

Sun Apr 13, 03:06:00 PM EDT  

Blogger Rakesh said....

1. Practical approach to Optimizer Statistics
2. Introduction to Oracle Access paths and Joins
3. How to implement database design in Oracle
4. Principles of developing Successful Oracle Applications
5. Introduction to Oracle Cost Based Optimizer

Sun Apr 13, 04:12:00 PM EDT  

Anonymous Anonymous said....

''Minimising single points of failure'

- When to RAC and not to RAC (If you buy a $300k SUN Machine do you really need to RAC)
- Where are the 'real' points of failure in your topology?
- Do you multiplex your archive logs?
- Is your disaster recovery documentation stored on a network drive?'
- Should the web server be load balanced?

Sun Apr 13, 06:54:00 PM EDT  

Anonymous Anonymous said....

Hi Tom,

I wish to hear your view on:
How to design and implement a good database on Oracle? considering that Oracle is more of an operating environment now.
Top ten things not to do when designing a database

Mon Apr 14, 04:40:00 AM EDT  

Anonymous Anonymous said....

Tom, you're always teasing us about writing a book on Analytics. As a taster of this eagerly awaited event my title for your presentation would be "Advanced Analytics". This would take us past the "simpler" stuff and concentrate on more difficult concepts like windowing which I can't quite get my head around.

Mon Apr 14, 05:11:00 AM EDT  

Anonymous Anonymous said....

How to read explain plan and different joins (like Hash Join, Nested Loop etc) You've already written about this in your book. But it would be nice to see you presenting this and then clearing our doubts in Q&A.

Mon Apr 14, 05:25:00 AM EDT  

Anonymous Anonymous said....

My top ten bigest mistakes.

Top ten practicies, which shouldn't be used anymore (but were recommended in some previous version as best).

Mon Apr 14, 07:16:00 AM EDT  

Blogger Kubilay Cilkara said....

Hi Tom

How about 10 approaches/practices in analysing data in a company with Oracle Analytics and SQL. After seeing Oracle acquring so many different companies which do Business Intelligence and Application Building, one wonders what does the future hold. What if my budget is little and I really want to get "Intelligence" out of my Oracle installation without having to spend money on tools A, B, C... What is the golden SQL that I can run, or how can one analyse and approach data to deliver more insight just with SQL... Poor Man's BI if you like.

Mon Apr 14, 07:19:00 AM EDT  

Anonymous Anonymous said....

Tom - It was nice hearing you @ PHLOUG ...

Here are some of the suggestions

1) Top N myths about SQL , PL/SQL / DB concepts etc

2) Capacity planning and sizing database for an application what are top factors to take into account.

3) Upgraded DB recently ? feeling the pains ? Did you test ? So in short how to achieve a good testing strategy for changes related to database upgrades

4) Going live with a new applications what are the top n considerations/topics to be followed for DB settings , coding standards , security settings etc to make the go live a smooth and sucessful one...

Mon Apr 14, 12:14:00 PM EDT  

Anonymous Anonymous said....

How to talk to/explain things to managers/non technical people for database related decisions.

-Alexander

Mon Apr 14, 12:34:00 PM EDT  

Blogger MWrynn said....

Maybe something about powerful but often overlooked features/techniques.

Mon Apr 14, 01:54:00 PM EDT  

Anonymous Anonymous said....

Hi Tom,
what about data cardrige? I thing it's one of the most unknown features of oracle.
You can find tons of good aricles and books about CBO, tuning etc etc but Data Cardridge?
This would be my favourite topic

Regards
Wolfgang

Mon Apr 14, 03:10:00 PM EDT  

Anonymous Basil said....

I agree with Mette.

The development world could really use some thoughts on managing the heterogeneous world that SOA is giving us, coupled with the rise of the ORM packages. I know why Hibernate is bad first-hand, but I've had no success in communicating this to manglement.

Mon Apr 14, 04:26:00 PM EDT  

Blogger Andreas Piesk said....

Queueing would be a great topic, together with scheduling event-based jobs. why? because using these features can save a lot of code.
many shops pay for oracle but use only basic features and re-implement features which already exist in oracle.
so i like the idea of david aldridge very much.

Mon Apr 14, 05:37:00 PM EDT  

Anonymous Beate said....

Yes, we need to bridge to the SOA/java world instead of just distancing us from it. We need to understand their approach and they need to understand ours. Then we might develop moderne well funtioning systems again.

So, yes a session on the heterogene world and how to survive in it

Tue Apr 15, 05:16:00 AM EDT  

Anonymous Anonymous said....

How about how to get that perfect swing?

http://en.wikipedia.org/wiki/Tom_Kite

:-)

Tue Apr 15, 08:34:00 AM EDT  

Anonymous Jimmy Green said....

How about a general philosophy for the dba?

Such as thinking more "scientifically" to eliminate guessing when troubleshooting.

Proving what you say. Like how to prove that a performance related problem is not the database, but how the developers wrote their code.
e.g., tens of thousands of selects, then processing, updating each row and commiting when it is possible to get the same results by doing hundreds of selects, then processing, updating hundreds of rows and commiting

How to be critical of what you read about Oracle on the Internet. Some experts are better than others, some experts may not be experts at all.

One thing I learned from my wife, who is a pharmacist--check, double-check, triple-check.

Test everything, which should be obvious.

Tue Apr 15, 11:45:00 AM EDT  

Anonymous Anonymous said....

You frequently advocate using just one production database to service many applications, rather than separate databases for each application. What are some of your methods and best practices for implementing this model?

Possible topics include partitioning and virtual private database for a one-to-many service model, when several clients use the same logical database structures but need separated data for performance and security. Also, how have you dealt with applications that expect their service account to have full DBA privileges? In particular, how have you lowered their privileges to maintain good security in a multi-application database.

Tue Apr 15, 12:03:00 PM EDT  

Blogger Marco Gralike said....

What about XMLDB (trying to turn you to the dark side)

8-)

Tue Apr 15, 02:03:00 PM EDT  

Anonymous Sokrates said....

finally, it's all about
"Thinking Data".
Or, is it
"Thinking Oracle" ?

That would be a nice topic I would be interested in:
"Is 'Thinking Oracle' more than just 'Thinking Data' ?"

Wed Apr 16, 07:18:00 AM EDT  

Anonymous Anonymous said....

How about 10 things that can really screw your database performance, and ways to improve them.

In at number 3 is VPD developed in 8i, still the same at 10g, when they could be using STATIC policies. Ho Hum.

Wed Apr 16, 08:18:00 AM EDT  

Anonymous Anonymous said....

Hi Tom,
How about "Top 10 things that all DBAs (Even Tom Kyte) routinely do "wrong")" ... and how to fix them?

Thanks!

Wed Apr 16, 09:47:00 AM EDT  

Anonymous Anonymous said....

Hi Tom,

It's what you do best: "How to Explain Things".

My current favorite example of divorcing understanding from implementation is the story about "make me a sterile cookie" at the start of chapter 2 of Freeman & Hart's 9i RMAN book (ISBN 0-07-222662-5). (I was shocked it was cut from the 10g edition.)

At any rate -- as DBAs, we must truly believe in the importance of understanding Process and Business Context before we can ever hope to communicate effectively with managers and people in other disciplines, or even people in our own field.

You demonstrate this for your audience over and over again, yet the fear that comes through in so many of the questions and posts about saying no to management shows that many folks just don't get it. Or don't believe they can do it because they have not achieved guru status.

Thanks for all you do.

Wed Apr 16, 11:10:00 AM EDT  

Anonymous Kashif said....

I was thinking on the same lines as Alberto and reckon that covering Advanced Queuing could prove useful as many applications/problems require some sort of queuing. Usually the DB is used as a dump (no surprise there then) with possible "select for update" logic to get rows out from the table. This doesn't scale well.

Wed Apr 16, 12:49:00 PM EDT  

Blogger Sudip said....

How about 10 Worst design decisions for your application. the application may be categorized into Data warehouse and OLTP.

Wed Apr 16, 05:29:00 PM EDT  

Blogger Tom said....

How about a presentation that proves Oracle rules of thumb wrong but maybe do it in reference to new features. Everyone already knows about binds and when NOT to use them. Everyone knows why the buffer cache ration is misleading.

I'm sure you have probably got some new ones from Ask Tom where you can trump conventional wisdom.

but is it really wisdom then? : )

Wed Apr 16, 08:31:00 PM EDT  

Blogger Tom said....

I agree with the person who talks about old practices that shouldn't be practiced anymore (like worrying about separating indexes and tables into different tablespaces).

Wed Apr 16, 08:33:00 PM EDT  

Blogger Kevin said....

Describe a bizarro world where DBA's, java developers, web designers,sys admins and (dare I say it) project managers work cohesively and harmoniously to create functional,flexible and performant systems. Describe the revolutionary events that led to this collaboration and the end of the religious wars around components, tools and platforms. Give us that fantasy, if only for an hour...

Thu Apr 17, 05:15:00 PM EDT  

Anonymous Anonymous said....

What about "Things to know before you design your Oracle database application that will help to reduce application DOWNTIME during its lifetime".

The main objective will be how to reduce your downtime during maintenance. I don't mean data guard, standby, RAC and etc. I mean application logic.Things like:

What can be modified online?
Is it possible to design a database application which can be maintained without downtime ? :)
How can we reduce downtime during uploads of database code changes or schema structure changes?

Sorry, I'm not specific at all, it's just one idea that I think is worth to be discussed and further shaped.

Thanks for your great contribution Mr. Tom Kyte :)

Fri Apr 18, 03:47:00 PM EDT  

Blogger Johan said....

I would suggest:

Databases in the SOA world - everybody is jumping on the SOA bandwagon, often without understanding what it is about and forgetting about the "humble" database...

Sat Apr 19, 04:59:00 AM EDT  

Anonymous Beate said....

Yes, SAP & Oracle

Hand in hand - or Fist against fist?

Sat Apr 19, 01:12:00 PM EDT  

Blogger ozturk.ferhat said....

Hi Tom and Tom lovers,
in my opinion your topic can be "is murphy right?", let me give some details, according to murphy "if it is working, dont touch it". we should touch or not:)
NOTE: i m not sure if i spell the name of the guy morphy.
Ferhat/Turkey(TR)
www.movieloby.com

Sat Apr 19, 06:25:00 PM EDT  

Anonymous Anonymous said....

How about talking about misuse of Materialized Views (e.g. using them in OLTP systems with frequent commits etc).

Mon Apr 21, 02:19:00 AM EDT  

Blogger Denis Avdonin said....

Database change management - Tom Kyte recommended best practices.

Mon Apr 21, 11:32:00 AM EDT  

Anonymous Anonymous said....

1) Rules Manager and Expression Filter ...

Some of the applications use Blaze or some other Rule Engine , which by their architecture is slow and isolated from the database .

2) SQL for Modeling

It is powerful yet it is complicated . Not many people are using because of its complexity

Mon Apr 21, 01:36:00 PM EDT  

Blogger Abhijeet said....

I would go with the gentlemen who suggested topics on the features of the database. Eg Advanced Queueing and the person who said Rules Manager.
I am always intrigued why Oracle does not always "eat its own dog food" so to speak, especially for things which it drums up so much.
I work primarily in the Oracle E-Biz Suite space and I am amazed as to the complete lack of uptake of all the new features in the internal code.
Take AQ. EBiz still has this Concurrent Manager facility which is primarily a table driven facility. No AQ. Of course I can play devils advocate and say why change something which a'int broken ( and I will be the first to admit that the Conc. Mgr facility is a gem). But come on! Would'nt it be an actual proof that the damn thing is really reliable enough?
About Rules too...there is a Business Rules feature now available on the App server but at the same time there is this new Rules Manager right in the DB. What are the pros and cons...Why even HAVE these two feature sets when it is best to have the validation rules and business rules closest to the database.
EBS is just ripe for such a feature. There are just so many screens to implement the basic business rules and then they all just fall short.
Solution...consultants like me who then go into the innards of the EBS code base and figure out how to "extend" the functionality of the ERP business flow.

I would suggest you cover these "exotic" supplied packages ...those which Oracle Corporation shows a certain reluctance to use it themselves in their own flagship Application.
When and where can we have CEP rules and not constraints / PKs / UKs / Triggers ?...How do the App Server based Business Rules and the Database side Rules Manager complement each other ?
Of course you would guess right that I am fishing for some answers about some business problems I need to solve for my current client (in Oracle EBS R12) for which I would love to use the features of the Rules Manager (judging from what I have read so far).

Tue Apr 22, 10:48:00 PM EDT  

Anonymous Cyber Optik said....

TKyte is the master of Analytic Functions... so why don't you create a presentation about it? :)

Wed Apr 23, 02:43:00 AM EDT  

Anonymous Anonymous said....

We aim to develop successfull applications using oracle. So it will be interesting to develop with concrete real experiences on a subject like

"WHY DO APPLICATIONS FAIL?"

Mohamed Houri

Wed Apr 23, 10:12:00 AM EDT  

Blogger christopher said....

How does oracle plan on competing with column based databases, which are yielding substantially faster query results, on the order of 30X - 200X? Is oracle going to implement this feature in its main DB, or purchase a 3rd party company (like Vertica) and implement it as a separate product, like TimesTen?

Mon May 05, 05:42:00 PM EDT  

Anonymous Anonymous said....

I would like to see a topic about setting the crs to manage services like failover and load balancing

Mon May 05, 06:20:00 PM EDT  

Blogger nasar said....

How about 11gRelease 2 OLAP feaures and how it has (or will) revolutionize the Summary Management capabilities of Oracle Database. Although OLAP has existed inside the database since 9i version, it is only now in 11g (specifically in 11gR2) that OLAP cubes showing up as Materialized Views, Query Rewrite capabilities of OLAP cube views, and better handling of JOINs and other features will make it a strong alternative to creating Materialized Views. Creating one OLAP cube replaces dozens and dozens of MVs. Also any types of hierarchies can be handled.. PLUS sql queries are MUCH MUCH MUCH simpler against olap views.

Mon May 05, 08:52:00 PM EDT  

Blogger Thomas Kyte said....

@Christopher

and were is the audited, open 'benchmark' that was performed such that the rdbms was tuned for the rdbms and the columnar data store for itself (eg: meaning different structures could be employed, whatever features the underlying databases had could be used) showing these numbers?

I'm not saying there isn't something to be said for columnar datastores - I just don't accept statements like "which are yielding substantially faster query results, on the order of 30X - 200X?". Not at all, not even a little. Not from my side or from the other side of the fence.

Tue May 06, 12:37:00 AM EDT  

Anonymous Learco Brizzi said....

What about the Apex 'revolution'?

Learco Brizzi

Tue May 06, 02:34:00 AM EDT  

Blogger Rajesh said....

Hi Tom,
For me the topics should be either of the two...
1) How to understand and interpret the awr report to tune a database.
2) The top 10 things an Oracle DBA must know.

I have googled a lot but did not find any comprehensive document to interpret an awr report completely. Bits n pieces explanation of the same galore but not a single comprehensive one.
Keep Smilin...
Rajesh

Tue May 06, 03:53:00 AM EDT  

Anonymous Anonymous said....

Why not to talk about three things Oracle is very good about:
- non healthy pregnancy (raw releases)
- premature birth (under-developed versions and patches)
- bad organized nursery (poor support).

During last 7-8 years all DBAs do is: upgrade/patch,patch,patch,upgrade/patch,patch,patch,upgrade/patchpatch,patch...

Sounds too negative for OOW?....

-Shushana

Tue May 06, 09:46:00 AM EDT  

Anonymous Anonymous said....

How about tips, tricks and best practices for tuning poor scripts?

Tue May 06, 10:51:00 AM EDT  

Blogger Joseph said....

RLS, PL/SQL stored procedure and trigger

Tue May 06, 10:35:00 PM EDT  

Anonymous Anonymous said....

What about the Grid approaches you can use as ISV?

Base products are Oracle Database, Caching Option (aka TimesTen) and Coherence.

What can be achieved, how to set it up and how to operate environments using two out of the three components?

Wed May 07, 08:50:00 AM EDT  

Blogger Darshan said....

It would be great if we can cover on Oracle's Replication Technology Stack. This covers Streams, Mat Views, CDC, AQs, Logical/Physical Standby..etc.
How to leverage them under what circumstances. Scalability and Availabilty can also be covered with these instead of going for RAC which most of the people think.

Wed May 07, 07:24:00 PM EDT  

Anonymous Anonymous said....

I recently got politically stuck in between the hardware and the software departments. DBAs are a strange hybrid of both specialties. No matter which dept you're in, you'll have to face some challenges. So how's this topic: "Which department am I in?"

Wed May 07, 09:08:00 PM EDT  

Anonymous Anonymous said....

Very Good article , this article make some interesting points.
Tactical Flashlights
r c helicopter
video game
Tactical Flashlight
Flashlight

Mon Jun 23, 02:55:00 AM EDT  

Anonymous Anonymous said....

Advanced Queuing.

Tue Jul 01, 02:31:00 PM EDT  

Blogger Victor said....

Dear Tom,
You could add this little issue to your list.
When I imported (with full=y) data from old Oracle 7 to Oracle 10g the new password for DBSNMP user replaced existing one. Then the EM DB Control could not start since DBSNMP user password was kept in DBConsole configuration file and did not match the database level password from Oracle 7. I believe it would be nice not to keep database passwords in DBConsole configuration files. Passwords have to be kept only at the database level as occurs with Application Server.
Sincerely,
Victor Slootsky
Technical Area Lead, Database/Design Development
Certified Oracle Professional (DBA)
BAE Systems Technology Solutions & Services
1601 Research Blvd.
Building 4
Rockville, MD 20850-3173
Office: 301-231-2496
Cell: 301-351-2907
victor.slootsky@baesystems.com

Thu Jul 17, 03:56:00 PM EDT  

POST A COMMENT

<< Home