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.
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