Welcome to Oracle Masters. The portal, as the tagline says, is for anything Oracle. FAQs, Certifications, Resources! In addtion, there will be pages on real life scenarios, Oracle internals, approaching the DBA job at various stages in your career and many other useful resources.Further, if you have a question, you can ask it and we will answer it at the earliest!
So join in. Learn, share and prosper! Register with us!
You can use a stored outline that allows use of a standard execution plan to be maintained, irrespective of the changes
in the system. This feature gives plan stability for queries. This can be useful when you cannot change the code as it
is a third party application, but feel that a certain query can run better with a particular execution plan.
The following article shows the technical aspects of setting up outlines in Oracle database.
With releases prior to Oracle 11GR2, addition or deletion of nodes would entail the client tnsnames.ora file being updated with the correct VIP address. This would be cumbersome if there are many clients that connect to the cluster. With Oracle 11gR2 GRID, Oracle has introduced the concept of SCAN.Clients connect to the cluster providing the database service, via the scan listener (initial connection) and based on the load profile of the node, the scan listener would “hand off” the connection to the local listener, establishing the final database connection.
I have some problem with my Oracle Installation, we had a virus called Sality and I think it might have
affected some of my Oracle system files. After we installed Karspersky AntiVirus 6.0.4,
I now can’t launch any of the Oracle Tools, like Enterprise Manager Console, Net Service Configuration, SQLPlus etc.
But surprisingly when I check the Oracle Services, they are started, but I am unable to access the DB via SQLPLUS nor EM Console, nor can
I reconfigure the TNS.
So am wondering what to do next, could you possibly know of a way I can fix this kind of a problem?
My Data files .i.e .DBF files are fortunately on a separate drive (D:), but I wonder if there
is a way I can recover the affected Oracle system files and then restore the data.
Please guide me on how to go about this issue.
When you insert the Oracle 10g R2 CD, is there an option to Repair?
With Oracle 11g, you can use physical standby database while your it is open in read only mode. Hence, the users can get real time data, which is almost as of production time. This feature is called Active Dataguard or Real Time Query.