DISCLAIMER
Related to Technical posts :
The posts presented by me are not ready made to use in production environment. So, please test them before implementing in any environment.
Related to Jobs:
The job postings are known from reliable sources and I or referer is not responsible in any way for job placements. even, i am not responsible if referer didn’t responded to your mail.
It is just to spread the openings information across many techies. It doesn’t gurantee any job placement.
srimannarayana said
Hi,
how to set variables like “set pages 200″ in a file.It will run while connecting to sqlplus like .bash_profile and
How to get both records and expain plan as o/p at at time when we fire a query?
Pavan DBA said
can you bit more clear about your question? I couldn’t able to understand completely
teja said
Hi All,
Will you please give me any possible cause for my below problem..? Thanks you in advance
This is the problem i am facing in the newly setup 10g RAC(with all the nodes).
I am getting error ORA-12519, TNS: No appropreate service handler found…….. while connecting through “SQL DEVELOPER” tool.
But this tool was working fine for my another rac setup.
I have checked that the listener is up and runnin fine. CAN I HAVE TO DO ANY MODIFICATIONS TO THE EXISTING LISTENER/TNS CONTENT….?
Even aftergone through several documents i didnt get the exact solution till now.
REGARDS,
teja
Pavan DBA said
You said, listener is up and running. please check whether “lsnrctl status command” is showing your db name or not. If not, you need to include SID list in listener.ora aganist that listener entry.
Bhaskar said
Hi, sir,
Again i want to learn oracle dba, so i want to write a dba exam to get oca certification. Tell me both things happen in such best institute name. Which would get a best teaching and best guidelines for the oca certification exam.
In Hyderabad i want the location of the institute name.
thank u
regards
Bhaskar
Pavan DBA said
Hi Bhaskar, You can join KANNA TECHNOLOGIES where I am giving training on Oracle DBA. In the course, we will train people in a way that comfortably you can write OCP certification and also will get complete real time knowledge and hands on practise.
New batch is starting on 2nd april (monday) and demo is there on this saturday (31st mar) at 9 AM.
Institute is located in ameerpet. Find the address from here… http://www.kannatechnologies.com
If you wish, you can attend demo and decide……
webhaskar said
Hi, sir,
I am already trained in oracle dba can you tell me the test center in hyderabad, which will get a oracle certification association(OCA).
can you tell me the address in hyderabad where test is conducting.
thank u
regards
Bhaskar
Pavan DBA said
Hi Bhaskar,
if you wish to write through oracle test center (where there could be a chance for getting some discount), see this link
http://pavandba.com/category/certification/
if you opt to write through prometric center, see the test center details in below link
http://www6.pearsonvue.com/Dispatcher?application=VTCLocator&action=actStartApp&v=W2L&cid=554
sathi said
Hi pavan,
I have some questions
1) How many types of explain plan?
2) Why rman better?
3)How corrupted blocks are updated to table r views?
4) How do u monitor tables?
5) How many types of checkpoints?
6) What is sql trace r sql tuing ?
Please give answer for this questions.
Thanks in advance,
Sathi
Pavan DBA said
1. Generally we have only one explain plan. But the optimization mode earlier used to be different like Rule based and Cost based. But from 10g, we are maximum using Cost based only as it is better than rule based. (rule based is having some disadvantages)
2. RMAN will take the backup of used blocks by which the backup size and time will reduce. not only this RMAN is having many other advantages like validating backup, incremental backup, parallelism etc
3. I didn’t got your question… please explain
4. we will never monitor tables. It is not a DBA’s duty
5. there are many. see this link – https://kr.forums.oracle.com/forums/thread.jspa?messageID=2535902
6. we are capturing every step of what the statement is doing in the database which is called sql trace. sql tuning means trying to reduce the complexity in statement and achieving same result.
sathi said
Hi Pavan,
Thanks for you answers.
Pavan DBA said
welcome
Nagesh said
Hi sir,
I need small help,i am using aix os and oracle 9i databases .i would like to plan schedule in crontab script for capture the daily Ora-600 errors in alert log file.Could you please tell me the script.
Thanks,
Nagesh
Pavan DBA said
Hi Nagesh, we have already discussed this in chat and you got the link…..
sathi said
Hi Pavan,
1> When ever archive file system is filled(100%) what are the steps we will perform?
Thanks in advance,
Sathi
Pavan DBA said
Hi Sathi,
1. first we will try to take rman archive backup (script should be already configured)
2. if we don’t have time to do that (as taking backup and deleting archives will take some time), then we can temporarily move archives to another mount point
generally we won’t get this issue if we plan our archives backup strategy correctly. depends on database activity, it can be scheduled either every 4, 8, 12 hours etc of time
sathi said
Hi Pavan,
Thanks for your answer.
Thanks & Regards,
Sathi
Pavan DBA said
you are welcome
sathi said
when ever we generate AWR report we get Top5 events?In that top5 events what issues will come come?And how we will solve those issues?
if you have any document please share for me?
Pavan DBA said
The events are many and we face them depends on the kind of performance problem. I have two documents listed in my blog itself to know this…plz read them
http://pavandba.files.wordpress.com/2009/11/statspack_opm4.pdf
http://pavandba.files.wordpress.com/2009/11/statspack_tuning_otn_new1.pdf
even though above are saying “statspack”, same is applicable for AWR also….
sathi said
Hi Pavan,
In dataguard we have 3 protection modes,what is the use of those protection modes?and which protection mode we will use in real time?and what are the situations for switch over? if you have any document regarding this protection modes please share for me?
Thanks in advance
Sathi
Pavan DBA said
Hi Sathi,
See this link to understand about protection modes – http://pavandba.com/2009/10/24/configuration-of-oracle-10g-data-guard/
coming to the question on which mode will be used in real time, it depends on the project and criticality of the database. generally for banking and other investment databases, data is more important, so in that case we will use max protection mode.
for other databases, we will use either max performance or max availability.
we will do switchover to test whether our standby is working fine or not. in the link i pinged above, you have steps for switchover also.
sathi said
Hi pavan,
what are the causes for ora600 error?if you have any document please share for me?
Pavan DBA said
Hi,
ORA-600 is an internal error which may occur due to several reasons. In my exp, I have seen it occurred because of memory issues, any bugs, or even if some pl/sql code is written wrong by application team (which got executed in the database).
So, there is no specific situation we can say when this error will occur.
regarding the solution, whenever we hit with this, we need to do following
1. log in to “my oracle support” and check for the error in ora-600 lookup tool
if you don’t find any information, then go for option 2
2. raise a Service request (SR) with Oracle support
The above two are the only possible solutions for ora-600
kanthi said
Hello Sir,
Hope you are doing great.
Tell me steps before going to raise the SR(service request)
Pavan Kumar said
Hi, I didn’t got your question clearly. Raising a SR is self explanatory procedure.
kanthi said
The question is when ever we get errors like ora 600,7445 we contact oracle support.Before going
to contact oracle support what are the steps inovolved in that?
Pavan Kumar said
before contacting oracle support, you have something called “ora-600 lookup tool” in my oracle support. you need to first search your error there, if that error is already recorded, then you will get answer. otherwise you need to raise SR. those errors cannot be resolved by checking in google, blogs or any other oracle forums. mandatorily you need to check in my oracle support
kiran said
Thank Q sir.
Pavan Kumar said
u r welcome
srimannarayana said
hi sir,
What happend to database when pmon fails or mandatory backgnd process fails.db goes down or hang.
Pavan Kumar said
DB will go down whenever any background process fails
Shashank said
Hi pavan,
When i’m trying to create database manually i’m facing the following error
ORA-01092: ORACLE instance terminated. Disconnection forced
this error is thrown when i’m trying to run the create database script.
Could u please help me out to get rid of this error.
Pavan Kumar said
Hi Shashank, check the undo tablespace name that mentioned in pfile and compare that with the name you have in the database creation script. maximum times, this error occurs because you have different names for undo. Fix that and your prob will be solved.
Shashank said
Thank you Pavan it worked out.
I Appreciate your effort on this site.Its simply owesome Pavan…
Pavan Kumar said
you are welcome Shashank…
Krishna Kumar said
hi sir,
i am installing oracle10g on redhat 5.4 the following error occur during installation
ERROR IN INVOKING TARGET ‘NTCONTAB.O’ OF MAKEFILE
Pavan Kumar said
Hi Krishna,
10g is not certified on a Redhat 5 version as it is released later than 10g. Try 11g or else you need to download and install various rpm’s in case if u want strictly to go for 10g on RHEL 5. there are so many docs over google, the below one is one of its kind. see this
http://oracleflash.com/18/Install-Oracle-10g-Release-2-on-RHEL-5.html
srimannarayana said
Hi sri,
what is meant by symantical checks & systactical checks.In db archt. who will do this where it will do and also what is meant by sanitory checks?
Pavan Kumar said
Hi, First let me correct those terminologies. Its syntax checking and symentic checking. These two are sub phases of parsing. Server process will do this in library cache.
I had not heard about a term called sanitory check. can you explain more clearly where you got this question?
kanthi said
While doing upgradation if one of the components are not installed
how could i resolve that one?
Pavan Kumar said
Hi Kanthi, if this is fresh component, you can later re-install this component alone. but if it failed during upgrade, then we need to check the reason in log file and correspondingly take necessary action
k.manohar said
Hi, sir,
i am apps dba student in our inistitute kana technologies. i got a error
ORA 600 “internal error code, arguments: [%s], [%s],[%s], [%s], [%s]”
tn this error my database not up, how to solve, plz send the solution
thank u
regards
Manohar
Pavan Kumar said
Hi Manohar, ora-600 is called internal error which will be caused due to various reasons. There is no direct solution for this, we need to contact oracle support. But in your case as you are not a licensed user, you cannot contact them. so only option is restore the backup, if not create new database