CONTACT ME
Folks, you can contact me in below ways…
Personal Mail id : mymailbox.21@gmail.com or pavandba@facebook.com
Through Social Networking Sites….
Orkut : Pavan Kumar (not using much)
Twitter : pavandba
Facebook : Pavan Dba
Google + : Pavan dba
Linkedin – http://in.linkedin.com/in/pavandba
Right now, i am into these sites only…
sivakumar said
Good Evening sir, this is sivakumar, how to move multiple tables at a time one tablespace to another tablespace?, Please give me in detail explanation.
Pavan DBA said
you need to use dynamic sql… see below
select ‘alter table ‘||owner||’.'||table_name||’ move tablespace ;’ from dba_tables where owner=’your schema name’;
sivakumar said
sir, is there any other way to do this?
Pavan DBA said
Hi Siva, I don’t think so
NIssar said
Send me RAC Documents which contains the subject from the Basics of RAC.
Pavan DBA said
You can read this…
http://www.oracle.com/pls/db102/to_pdf?pathname=rac.102%2Fb14197.pdf&remark=portal+%28Books%29
abhi said
Hi pavan
i have gone through several blogs as like Kamran Agayev’s. tom’s etc…but the need full information is at your blog…as like what are the books to be studied…and i have done database cloning through your given steps nice..and very short…
i wish to know what are the good books or blogs to my self strong in the Sun SOLARIS 10 as i am beginner for that…??
i need your help sir….
Pavan DBA said
Hi Abhishek, thank you first of all for your comments on my blog. as we are not Os admin’s I believe we can concentrate more on DBA. Having basics knowledge of Solaris would be fine to survive. For those commands, you can refer to google. Let me know if there is specific reason to be strong in solaris.
Mohammed Shahid Khan said
Dear Pavan,
I found very good valuable resources, I need your assitant regarding OEM Grid Control 10gR2 installation on CentOS 5.7
while checking the kernel parameters for installation i am getting the below two parameters failed
Checking for semmsl2=250; found no entry. Failed <<<<
Checking for filemax=65536; found no entry. Failed <<<<
I can not be able to resolve it, need your expert advise.
Rgds,
Shahid
Pavan Kumar said
Hi, have you verified the related Oracle Installation guide? if not please do that.
http://kamranagayev.com/2011/01/31/video-tutorial-installing-oracle-10gr2-grid-control-and-deploying-agent/
suman said
HI PAvan SIr,
Can i get step by step doc to upgrade 10g 2 node rac CRS and database upgrade to 11g.
Thanks,
Suman
Pavan Kumar said
Hi Suman, this is one of the finest docs that i recommend
http://www.oracledba.org/upgrade/Upgrade_10gR2_RAC_to_11gR1_RAC.htm
Rashmi said
GM Pavan,
Hope u r fine n doing well.Pavan can u pls provide a good document or some link for PT covering basics ,tuning strategies etc.
Thanks.
Pavan Kumar said
Hi Rashmi, I don’t have any docs. But to learn PT, oracle documentation is the good way. link for that is below
http://www.oracle.com/pls/db102/to_pdf?pathname=server.102%2Fb14211.pdf&remark=portal+%28Books%29
Mostly in interviews they will ask about AWR report analysis etc. for this i already have 2 docs in “important docs” page of my blog. the doc names are “analyzing statspack report 1 & 2″. even though it says about statspack, it is applicable to AWR report also.
for strategies, you can refer to the questions asked in oracle forums. (http://forums.oracle.com) (you can do a free registration here)
vinod kumar said
hi sir ,
this is vinod.i am a passout of 2012.is it a good idea to do oracle apps as a fresher.how are the oppurtunities and what are the prerequisites to learn oracle apps..sir please give your suggestions
Pavan Kumar said
Hi Vinod, I am not sure what you asked by Oracle apps. Because Oracle apps contains two divisions. One is technical (which is more into programming) and functional (people call it as apps dba, which is into administration side). But as a fresher oppurtunities will be less for any of the divisons
pre-requisites to learn oracle apps technical – sql, pl/sql, forms and reports
pre-requisites to learn oracle apps functional (apps dba) – sql, unix basics & basics of shell scripting, Oracle DBA
vinod kumar said
thank you for the advice sir,
Rashmi said
Pawan,
Any idea about database replication & steps involved in it ?? Plz help.
I browsed on google but couldn’t get the relevant info.Please explain in detail as i have to work with a client on it.
Thanks.
Pavan Kumar said
Rashmi, there are several ways to configure database replication like using materialized views, streams, active dataguard (in 11g), golden gate (which is new technology). Out of these I have a doc for stream configuration in my blog. see this
http://pavandba.files.wordpress.com/2009/11/oracle-streams.doc
Rashmi said
Thanks Pavan.But it seems will have to use golden gate third party tool for repliaction here.
Pavan Kumar said
Golden gate is no more a third party tool. Now Oracle acquired Golden gate company, so its product from Oracle itself. so you can use it.
Naveen.K said
Hi,
Iam naveen i completed my DBA . RIght now iam searching for the jobs on DBA as experience of 3 years.Can i let u know in which locations can i find a jobs on DBA….
Pavan Kumar said
DBA jobs are across the country. You can follow my job postings in the blog and you can apply for them
sivakumar said
Sir, this is sivakumar, i would like to know how to design the database, i tried to do that, i faced many prob, one of that it, is
putting Primary key and Fk. So please tell with one example, with any name of database. so that , i can do that
Pavan Kumar said
Hi Siva, designing database is one the complex jobs DBA will do (that is why most of the times experienced dba’s will do that). As per your question, I can understand that you are talking about table design (preferably we should not call it as database design). In table design, we should concentrate firstly on constraints and need to decide which columns can be PK or FK etc. The best example you can take always is EMP and DEPT tables in SCOTT schema.
Suppose we have a student management system which is storing students information for a college, then columns in that table can be like this
Name
DOB
Father_name
Mother_name
Branch etc
now from the above you can see no columns can be PK, so we need to add new column by ourself called “student_id” and make that as PK. this column should also be there in other tables where it will be FK.
Rashmi said
Hi Pavan,
Hope you are fine and doing well.Can you plz let me know what query do we need to execute to monitor high loads on db & contension.
Pavan Kumar said
Hi, generally we need to use TOP command to know high load processes and based on process id, we can identify the sql statement. Even for contention we can use iowait command. But all this will be easy if you use Enterprise Manager in 10g
Rashmi said
Thanks a lot.
Pavan Kumar said
you are welcome Rashmi
anwar said
Sir,
i anwartaz completed B.Tech-2011 with aggregate of 65%.After that i did oracle DBA in ameerpet since 5 months i have been looking for job as a fresher/trainee DBA.i uploaded resume in all job portals and i went so many job consultances but idid’nt got any single chance to attend intrview.know i’m totally frustated could u plz guide me how to get job as fresher.i’m eagrly waiting for ur replay
Pavan Kumar said
Now a days having Oracle DBA knowledge alone is not sufficient as competition is getting more day by day. so try to learn adv topics like oracle RAC, APPS DBA etc. also if possible, try to do OCP certification which enhances the chances of getting job
rafi said
hi pavan,
i read u r blogs. its really helps lot.
i have some questions
one is how to restore the table (not using logical backup and flashback technology
second is how to restore rman backup thats having on diff disk or tapes
and third is what is locks latches and enques and please provide the performance tuning related docs.
Pavan Kumar said
Hi Rafi, thanks for your comments and here are the points I know….
1. Without using logical backup and flashback technology, u can do until time recovery in order to get a table. But this will effect other schema’s data.
2. either in tape or disk, we need to allocate a channel for that device using “allocate channel for device type” cmd and run “restore database” command (if it is full database)
3. Lock is a method of restricting a user from modification in order to avoid data corruption. This will be maintained for read consistency. Latch is the same concept, but applied for SGA. see this nice ppt – http://www.google.co.in/url?sa=t&rct=j&q=lock%20vs%20latch&source=web&cd=3&ved=0CDYQFjAC&url=http%3A%2F%2Fnocoug.org%2Fdownload%2F2001-05%2Flatches.ppt&ei=oeQLT9KuAY3zrQeWrKGwBA&usg=AFQjCNEFYgofQIuKyRW29LuzRpOmidkDBA&cad=rja
Also, for PT always start with PT guide in oracle documentation
prathap said
Hi sir,
this is prathap,i have 4 doubts?
1.archive logs are applying from production to standby…..suppose suddenely logs stoped shipping due to network problem. then wat steps have to take as a dba?
2.archive logs appling very very slowley?wat type of steps we have to take as a dba?
3.suppose i deleted 20(by mistake)archive logs in production before applying to standby.then wat type of steps to be take as dba?
Pavan Kumar said
1. if it is 9.2.0.1 or above version, then FAL processes will take care of archive log gap when network connection re-establishes
2. you need to check alert log of standby to check for any further information.
3. then u need to take incremental backup of primary database and rollforward that to standby. for steps, refer to google
prathap said
hi sir,
1.we are using 10g …Wat is FAL process duty?
2.thank u
3.thank you.
Pavan Kumar said
On the standby database a Fetch Archive Log (FAL) client monitors for gaps in the sequence of received logs. If it finds a gap, it may invoke one or more Fetch Archive Log (FAL) servers to run on the primary database to forward the missing item(s).
prathap said
hi sir,
on standby database 400 archivelogs are missed .i transfered that archive logs from production to standby manually by using scp command.then how apply that archive logs in standby?please provide me steps sir…………
Pavan Kumar said
you need to just make sure MRP process is up and running, rest will be taken care by it. or else, u can run register archivelog (for command check google)
prathap said
thank u
Jagat said
Deadlock happened intermittent from a single select statements. There is no other second SQL statement. The select statements have parallel processes.What you think what might be the issues
Pavan Kumar said
Mohanty, I suppose there wouldn’t be deadlock issue for select stmt as they will hold only shared locks. so tracing the session may give more results
Jagat said
Thank Pavan for your reply !
I checked in the trace file it does not show call stack of use PX operations.
The trace file also masking the commands which were run to hold Shared or Exclusive locks by the SQL. All deadlock traces are partial trace.
Is _bloom_pruning_enabled”=FALSE setting really help on this?,We have PSU3,guess it may be a bug not fixed in PSU3 .can you suggest?.S and X locks are conflicting and one prevent the other P0 from making any progress. The P0 sessions try to get hold of same locks in reverse order.
Pavan Kumar said
I feel it is better to raise a SR (if not already done) before setting that parameter, bcz they can give better option for tracing
Rashmi said
Hi Pawan,
Can u plz upload any document for oracle installation on linux platform, with details like
what are kernel parameters and why do we need them. and so on.
Thanks
Rashmi.
Pavan Kumar said
Rashmi, already there is a doc in “Important docs” page of my blog. You can access at http://pavandba.files.wordpress.com/2009/11/oracle-10g-on-linux.docx
Ravinder Reddy said
Hi Sir,
This is Ravinder. I need some help from you.
recently I got a chance to reorg some tables.
As per my knowledge we have the following methods.
1.CTAS
2.Move
3.export & import.
In my case above 3 are not working.
Here the database version is 8i(8.17).
table size is 7GB and it contain one long datatype.
I tried to use move command but it didn’t work bcos of long datatype.
next trial I export the table with no indexes,no constraints it took almost 30 mins.
But for import it is taking more than 10 hrs.
Is there any other way to reorg this table?
Thanks & Regards,
Ravinder.
Pavan Kumar said
Hi Ravinder,
as per my knowledge, export/import is the possible way since the database is 8i. You can better try to import that table into a test database. once done, you can export from there and import into production. (i believe even if u have import running for more than 10hrs, there will be no issue). Import will take that time because of LONG datatype.
Try to use buffer, commit parameters while importing
Ravinder Reddy said
Hi Sir,
Thanks for your reply.
Will try it.
bhaskar said
hi sir this is bhaskar student of kanna inst bd-19 batch. plse reply my questions to this mail id bhaskar.kanna1986@gmail.com
1.What is the differences between oracle 9i and 10g versions of RMAN backup ?
2.now iam trying on 3.2 years of exp… in interviews they asking in which level ur working L1 or L2 what is L1 and L2
Pavan Kumar said
1. there are so many differences. you can find them from net
2. give them answer as L2
bhaskar said
thanks sir
Shreya said
Hi Pavan
I am a aspiring DBA. I have taken coaching at a institute in Ameerpet. I have practised in lab environment. But i am putting 2.8 yrs experience as i was passed out in 2008. In the interview people are asking me several technical questions that i could answer. But some people are asking me questions such as ” TELL ME THE STEPS – - – HOW YOU CONNECT TO THE DATABASE IN UNIX PLATFORM MACHINES? ” I am unable to give the steps. please help me with these basic things. I am a hard worker, but due to some reasons i had not given a try at software job in these years.
Please help me.
Pavan Kumar said
I am not sure if you practised on Linux env or not. If you practised, then its same way that we connect to database even on unix.
export ORACLE_SID=
sqlplus “/ as sysdba”
let me know if u have any queries
Shreya said
I have practiced on Linux platform only. RHEL 4 version.
I say this as the answer, but immediate question they ask me is — ” YOUR TASK IS TO SWITCH ON THE MACHINE AND CONNECT TO THE DATABASE AND CHECK TO WHICH DATABASE YOU ARE CONNECTED “.
I understand this sqlplus “/ as sysdba”, but I need elaborate steps.
Please help.
Pavan Kumar said
Generally switch on the machine is not our task as a DBA. connecting to the database is same i told in prev reply. how to check which database we are connected? we need to use below query for that
select * from v$instance;
select name,open_mode from v$database;
Shreya said
This will help me i think.. Thanks a lot Mr.Pavan. I know that there are some tools used to get access to the database like Putty. Can u tell me few other of such type which we generally use.
Thank you so much once again for the reply.
Pavan Kumar said
for daily use to connect to server we use putty
for some other db related tasks we use Enterprise Manager
for installations etc using GUI we use tools like vncviewer, humming bird, xmanager etc
more than this any tools using depends on project
Shreya said
Thank you so much for the valuable response. I hope it helps me get a job soon.
Thanks again Pavan.
Shreya said
Hi pavan,
Can you please list down the steps ” HOW TO APPLY PATCHES,&, DIFF B/W CPU AND PSU”?
Is it possible to directly upgrade from 10.2.0.2 to 10.2.0.5?
Pavan Kumar said
Soon I will upload doc on how to apply CPU and PSU.
Regarding the difference between them, CPU (critical patch update) which is a quarterly patch released by oracle corp. PSU (patch set update) is a collection of patches and when you apply this your database version will change.
you can surely do upgrade from 10.2.0.2 to 10.2.0.5. for this you need to apply 10.2.0.5 patchset update
Shreya said
Hi
I am waiting for you to upload the above mentioned doc.
Meanwhile, I would like to know ” What is a monitoring tool? What monitoring tools do a DBA use in real time? ”
Thanks in advance.
Pavan Kumar said
Hi Shreya, I got too busy with office work and couldn’t be able to upload it. Let me do it soon
About monitoring tool, generally we will use it for performance monitoring of the database. even though there are so many 3rd party tools available in the market, I just saw DBA’s using 10g Enterprise Manager only to do this….
sridhar said
Sir this is sridhar.mukta..
In a team how many members have metalink access? and who wil download the patch and analysis? this question was asked in oracle corporation.. i could not give the successful answer..and what happens if we happen patch?
He asked a question me that any issues you faced in patching? then i was answer that “pre requisite patch was missed”. he asked that is it ur mistake r ur team problem? r any analysis problem? who will analyse patch ?
sir please give me a brief answer “what happens in real time before apply a patch”?
Regards,
sridhar.mukta
Pavan Kumar said
Hi Sridhar,
All of the team members will have access to metalink and anyone can download the patch in real time.
Generally it is the mistake of us only when patch is not appiled successfully. because we need to first test that either in dev or test instance.
Also, we can run a pre-check utility before starting patching. see my article – http://pavandba.com/2011/09/19/how-to-check-conflicts-while-applying-cpu-patch/
sridhar said
Hi sir Good morning,
This is sridhar.mukta please provide me the documentation of Opatch.
Pavan Kumar said
Hi Sridhar, I will provide that soon
mahaveer said
hi anna
i am getting error will installing oracle 11. 2.0
will i am running ./runInstaller it giving permission denied in .oui
Pavan Kumar said
Hi Mahaveer,
Please give full permissions on “database” directory as below
chmod 777 database
Then try installation. If any problems, please post here
Jagadesh said
Hi Pavan,
How to find the fragmented indexes in a Database;
Thanks
Jagan
Pavan Kumar said
Hi, you can use below script for that
select
‘exec analyzedb.reorg_a_table4(’||””||rtrim(t.table_owner)||””||’,’||””||
rtrim(t.table_name)||””||’);’,
t.table_owner||’.’||t.table_name name,
a.num_rows,
sum(t.inserts) ins,
sum(t.updates) upd,
sum(t.deletes) del,
sum(t.updates)+sum(t.inserts)+sum(t.deletes) tot_chgs,
to_char((sum(t.deletes)/(decode(a.num_rows,0,1,a.num_rows)))*100.0,’999999.99′) per_del,
round(((sum(t.updates)+sum(t.inserts)+sum(t.deletes))/(decode(a.num_rows,0,1,a.num_rows)) *100.0),2) per_chg
from analyzedb.table_modifications t,
all_tables a
where t.timestamp >= to_date(’&from_date’,’dd-mon-yyyy’) and
t.table_owner = a.owner and t.table_owner not in (’SYS’,’SYSTEM’) and
t.table_name=a.table_name
having (sum(t.deletes)/(decode(a.num_rows,0,1,a.num_rows)))*100.0 >=5
group by t.table_owner, t.table_name, a.num_rows
order by num_rows desc, t.table_owner, t.table_name;
srinivas reddy said
Hi sir
This is srinivas from hyd… your valuable suggestions are very very help full to us… i completed my Msc(cs) (2011)am searching job now.. I came to know about your blog while searching on oracle material now am eager to see your blog daily…I need your help to get a job…
thank you
Pavan Kumar said
Hi Srinivas, plz chat with me at mymailbox.21@gmail.com or at my facebook profile “Pavan Dba”
srinivas reddy said
thank you very much sir
AJay said
Hi Pavan,
How are you ..?
Could you pls help me out in letting me know any free oracle DB refresh tool, if any. Few senior guys are out here, but from past few days we are missing the integrity of the data, and very recently on friday@7th Oct’11, I too did a refresh, where we lost some of the data.
Thanks much.
AJay.
Pavan Kumar said
Hi Ajay, May i know what is the method you are using for refresh? as far as i knw, DBA’s generally wont use any tools to do this….
AJay said
Manually using impdp with parfile
> impdp parfile=.par
Pavan Kumar said
Ajay, we don’t have any tools for that. its always better to use those utilities directly instead of depending on 3rd party tools
kalaivani said
Hi pavan,
this is kalaivani. I a 2011 passed out BE graduate. I would like to work for cognizant. Your blog site was useful to know about the recruitment procedure. Thanks. But i need to seek for a referral for applying to cognizant. I don’t know anyone there. Could you please refer me? thank you in advance.
Pavan Kumar said
Hi Kalaivani, please send me your cv to nagapavan.s.t.p@cognizant.com, i will provide you reference details
kalaivani said
Thanks a lot pavan. I have sent my cv.
kalaivani said
Delivery to this id is getting failed. Couldn’t able to send my cv to you. Thanks a lot again. Got your reference details.
Kishan said
Hi Pavan,
This is Kishan, It was really great to came to know about your blog and i am very happy that your are helping people with your valuable suggestions.
I am really appreciate your time and patience while you are giving response to all posts…………..:)-
Pavan Kumar said
thank you Kishan…. hope i will do blogging more and more
vivek said
Hello Pavan,
greetings first of all thanks for this blog. i would like to get dumps and study material for exam 1z-051.
Thanks for all your help.
Thanks,
Vivek
Pavan Kumar said
plz chat with me on mymailbox.21@gmail.com
sagar said
Hello sir, i completed Btech in 2007 and after that i worked 3years in satyam bpo in GIS side and now i want to change my career into oracle dba. I completed the cource and searching for job but i am not getting any oppurtunity. Could u suggest
me how to get in. my contact number 09972948746.
Pavan Kumar said
if u r trying correctly, thr is no scope in not getting any opp. plz chat with me at mymailbox.21@gmail.com
SK said
HI Pavan,
I am looking out for any employee referral, is it possible you can refer me to CSC.
Please let me know your contact number/Email address. It would be of great help.
This opening is for Change management.
Regards
SK
Pavan Kumar said
Hi sirish, now i am no more working in CSC. plz forward ur cv to pavandba@facebook.com. i will contact my ex-collegues and will try seek their help
karthik said
hello sir,
this is karthik from chennai. Iam a btech graduate 2009 passed out completed my oracle ocp certification how can i get a job in oracle database .i tried a lot but none worked out pls give me a suggestion Iam ready to pay even via back door.
Pavan Kumar said
Hi Karthik, as a fresher there will be less opps for DBA. But i cannot say its completely impossible as i started as fresher DBA only. so keep on trying and follow my blog. in last 2 weeks i posted some fresher openings in HCL and cognizant. apply for them
ramesh said
Dear Pavan,
I would like to know the procedure of RMAN backup, the source and target databases both are in same host.
Thanks
Pavan Kumar said
Hi Ramesh, sorry i didn’t got your question. what you mean by source and target databases? are you talking about recovery catalog?
ramesh said
Dear Pavan,
source (catalog database) target database (yet to take backup using rman)
Pavan Kumar said
I expect you already registered target database with catalog. in such case u need to connect to both target and source and then issue backup database command.see below example
$ rman target / catalog rman/rman@rc
RMAN> backup database plus archivelog;
DL said
“Error in writing to file D:\Oracle\product\10.2.0.2.0\bin\oraevrus10.dll”
Lucky I saw your blog and reboot the server and restart the Oracle patch. Saves the day man !
Pavan Kumar said
thank you and i am happy that my post helped you…..
ramesh said
Hi Pavan
This is ramesh from bangalore
y v r running these two scripts orainstroo.sh & root.sh during installation
Pavan Kumar said
orainstroot.sh – it will change permissions to 755 and will change group owner to oinstall
root.sh – will create oratab file
you can get these answers when u read the output of them….
kirshna said
hi pavan,
This is krishna, I’m very glad to see your blog
I’m oracle core dba, my company people kept me as oracle apps dba. Recently i installed Oracle Apps R12 on RHEL 5.4 (64-bit) (IBM server). in server its working fine. when it comes to client machine its not opening, i added the server ip address in client machines. What to do & how to solve this issue?
Thanks
Pavan Kumar said
sorry Krishna, I am blank on apps dba.
vivek vishal said
Hi Pavan,
Hope u r doing well , Do u have some opening related to SQL server DBA ?
Do u also have document related to SQL server DBA .
If u have please share …
Thanks
Vivek
Pavan Kumar said
Hi Vivek, I am getting SQL server dba openings info very less. but whatever i got, am posting them in my blog.
also I am oracle DBA, so i don’t have any docs on sql server dba
Sriram G said
Hi Pavan,
How are you?
I am Sriram working in Oracle financial services as Oracle DBA. I am a B E (IT) professional.I have not done any course in DBA and I have been put into DBA team as my aggregate is more than 80% in Engg. I joined this DBA team as a fresher. I like this job very much and i am learning new things daily. The only disadvantage in my team is there is not much on-site opportunity but I am more interested in traveling to different countries. Can you please suggest me whether i can continue this team or switch over to any implementation or Appln development team as there is many on-site opportunities. If i want to continue in this team whether i have to do some course?
Please add me in ur gtalk. I have sent you the request.
Waiting for your reply.
Thanks & Regards,
Sriram G
Pavan Kumar said
As your are learning some good things, I suggest to continue in this team. Even for onsite opp, i think u need to get some experience. till that time, you can be here and later you can move to some other team where onsite opp are more. doing a course is not required as i feel.
i added you in the gtalk and you can chat with me now…
Sriram G said
Thanks pavan…
chandrashekar said
Hi pavan just now i saw ur web site,it is very usefull
What is the difference between obsolete RMAN backups and expired RMAN backups?
Pavan Kumar said
Obsolete means unnecessary backups. If at all we have latest backup available, RMAN will mark all older backups as obsolete backups depends on retention policy.
Expired backup means backup which is not available physically at OS.
Harry said
am waiting for Goldengate installation documention and steps from you pavan..
Pavan Kumar said
will upload them in near future
bhargava said
Hi Pavan,
Please try to post maximum openings in SQL DBA…! It will be appreciate…! Thanks in advance
Pavan Kumar said
sure. thanks for comments
balagangadharreddy said
hi pavan kumar,
This is bala ,this blog is very nice,
my ambition and interest is oracle apps technical consultant but i didn’t get any call for fresher (2010 mca pass out ) so i will put fake resume on apps , so plz give suggestion to me
if u don’t mine plz send validations on purchase order conversion thru mail (bala.grk@gmail.com)
Pavan Kumar said
Hi Bala, I am not a oracle apps technical professional. so I didn’t understand what you are asking….sorry !
krishna chaitanya said
Hi pavan,
Please can you post openings for IBM DB2 DBA please
Pavan Kumar said
surely chaitanya, but as I am oracle DBA, i would be getting more req’s on that….
chandra said
Hi pavan,
the blog is very gud. I have been trying for job change and have found the update for jobs posted vry gud here. is there any alert system in your blog where if i need to know any thing of a particular location. a mail can be sent to me.
Regards,
Chandra.
Pavan Kumar said
Hi Chandra,
Thanks for your comments…………
On the left hand side of my blog, there will be email subscription tab. you can leave your email id and whenever any post is pasted, you will get email notification
Ravi said
thanks for reply my msg and i happy that u helps any person who are getting job………….
Ravi said
hi sir
please give me suggestion. i wants to get job in oracle. if u have some time 4 me then u i want chat with u….. i will be waiting u
Pavan Kumar said
plz chat with me in mymailbox.21@gmail.com
vishnu said
Hi Pavan,
This is vishnu,may i know the ans for this-if some archive logs are not copied from prod to standby but we know after 1hr now what will we do know,and
what is softlink?
how do u know 2 users are accessing same table?
what is dbcache wati?
Difference b/w dbms_stats and analyze?
Pavan Kumar said
1. First we need to check the reason why they are not copied. for this we can check alert log of both primary and standby databases. If it is due to network problem, we have FAL server/client which will take care of this gap
2. softlink is a method of accessing a file with alias name (like shortcut in windows)
3. we can check that info by looking at their sql_text or by checking locks that they are holding on the table
4. a transaction waiting for free block in database buffer cache is called dbcache wait
5. dbms_stats will collect more statistical information than analyze command. so oracle recommends to use it.
vishnu said
Hi Pavan,
This is vishnu i want know some info from u i.e, if we create physical standby from production db,Once i create one new tablespace/datafile in production db and that is not a actual loc i created that separate loc that is it updated standy by or not,if i set standby_file_management=auto after what we have to do.
Pavan Kumar said
Hi Vishnu, yes it will be updated provided you need to have same location as primary in standby also.
For example, if you added file in /u01/ora10g/prod/mydata03.dbf in primary, in standby also you need to have /u01/ora10g/prod location.
All this will happen only when standby_file_management is set to AUTO.
If you don’t have that directory structure, oracle will try to create, but fails. in such case, your standby will be out of sync from primary
Hope that answers you question
Ravi said
Hi Sir
i am Ravi and i have been completed OCA & OCP but i am fresher and i am looking job from long time but i am getting job. please tell me what i do…..i am waiting…..
if u want to give me any suggestion please give me because
i love oracle and i am ready for any compromise.
oracle.ravi5@gmail.com
Pavan Kumar said
Hi Ravi,
Unfortunately there will be very less fresher DBA jobs. But its not impossible to get job as fresher as I also started my career like that. So don’t loose hope and keep on trying. I don’t know if you did, if not plz post your cv in all the job sites like naukri,monster etc.
Plz chat with me at mymailbox.21@gmail.com to give more suggestions
Vishnu said
Hi this vishnu can you please send me upgradation steps from 10g to 11g and 9i to 10g with screen shots.
Pavan Kumar said
Hi Vishnu, you can get lot of docs from google itself. But in few more days i am going to upload them in my blog at “important docs” page. keep watching it……
bala said
hai pavan
this is bala from chennai. really it’s amazing tutorials.just i want know without certification can i get job.please tell me or mail me and also i need oracle 9i dumbs .if u have please send me my mail.once again i tell u r done great job.
Pavan Kumar said
Hi bala, certainly certification will be added advantage to the profile while attending interviews. but without certification also you can go through interview process and get the job. i don’t recommend to use dumps to clear the exams. its a preferable way to get good hands on exp on the topics and then appear for the exam.
thanks for all the words you mentioned !!!
Srilakshmi said
Hi Pavan,
I am srilakshmi. I am following your DBA blog. its very nice. I have done Oracle DBA 10g course. My life ambition is work as a DBA without that i cant imagine my life. But i dont how to get a job as a fresher.I would be very greatfull If u give any suggestions to me.
Thanks&Regards,
Srilakshmi
Pavan Kumar said
Hi Srilakshmi,
Thanks for comments abt my blog and I hope I cleared some queries in our chatting…
Brijendra Kumar said
Hello Sir,
I want to know the procedure to restore database from tape.
I mean if I have backup in tape drive then what are the steps & procedure to restore that backup?
Thanks in advance.
Pavan Kumar said
you will be using restore command of RMAN even if it is tape drive. in other cases (hot or cold backup), there will be a separate (backup) team who will do restore
Nazeem said
Hi Pavan,
This is Nazeem from Pune,It was great to came to know about your blog and i have gone through your blog and i am very happy thet your are helping and cooperating with people,
I am working as Recruiter in MNC and i am looking for Wintel DBA with Unix,the person who will expert in read write and speak Japanese this is with one of my CMML5 client.
I would realy appreciate if you can do something for this.
Awaiting your possitive reply.
I will be reacheble on nazeem.kazi@adecco.co.in
Regards,
Nazeem
8149198928
dev said
Sir,
I want to write a shell script for compiling materialized view.
Let suppose there are 10 MV
when I check the status of them through the query
select object_name from user_objects where object_type=’MATERIALIZED_VIEW’ and status=’invalid’;
Let I got 4 MV whose status are INVALID
Now I want to compile these 4 MV to make it valid by running command one by one
ALTER MATERIALIZED VIEW MV_name COMPILE
Sir,
I want to automate the whole process through shell script.
Kindly advice.
Pavan Kumar said
you can direct the output of select query to a sql file and you can call that sql file in a shell script. for basic shell scripting, refer to google
srinivas said
Hi Sir, how to check the detection of corruption in datafiles in rman ? sir i need command…
Pavan Kumar said
if datafiles are having corruption, RMAN will show that during backup or validating the backup.
still you can use below commands to do that
physical corruption – RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
logical corruption – RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;
you can also use dbverify utility to find corruption for datafile (for syntax, refer google)
srinivas said
thanks u pavan…
vamsi krishna said
what is the force logging and nologging.
what is dataguard broker.
backup of archive log all delete input:what is the use of command
Pavan Kumar said
force logging will make sure all changes will be recorded in redolog files. If you use nologging option, those changes will not be recorded in redolog files. But NOLOGGING is not applicable to DML statements. It is useful for statements like
1. create table as select * from …
2. Insert into A select * from B;
3. alter index rebuild etc
Dataguard Broker – It is a utility through which we can easily manage primary and standby databases using observer. For more details, read oracle docs
backup of archive log all delete input – this is not correct command. The below is the correct command
RMAN> backup archivelog all delete input; – this will take backup of all archive log files in archive destination and will delete them immediately.
vamsi krishna said
Thanks sir
it will delets the all archive log files from archive destination or
delete prev backup of archives from rman backup directory in target database.
Pavan Kumar said
it will delete the archives which were taken backup (not newly generate ones)
vamsi krishna said
sir
what is the minimum size of redo logfile and can we resize the redologfile ?
how to monitor the redolog file size ?
Pavan Kumar said
Min size you can give for redolog file depends on operating system. In 9i min size is 100MB whereas in 10g & 11g it is 50MB.
redo size also depends on how much redo is generating….
we cannot resize redologfile, instead we can create new group with required size and drop the old one
redolog file size can be get from below query
SQL> select sum(bytes/1024/1024),group# from v$log group by group#;
basha said
hi sir, this is basha , pls educate me about cpu patcher which are oracle provides for every 3 months. bcoz i faced that quetion in interview. Our friends told that i.e, app dba relater. so pls help me regarding this
Pavan Kumar said
Hi Basha, its not related to apps dba. it is for DBA only.
As any other software, oracle database also contains some bugs in every version (9i or 10g or 11g). To fix those bugs oracle will release critical patch update (shortly called as CPU) every 3 months.
DBA need to download this patch from metalink and following a readme file (which gives step by step instructions) we need to apply patch on the database.
The latest CPU released is in OCT 2010 for 10.2.0.4 database
vamsi krishna said
hi sir,
if our database in force logging. what about tablespaces whether in nologging or force logging
I have one table with 2 rows.Using only single update statement row positions will become interchange(SWAPING) from tech mahindra interview.
Pavan Kumar said
if entire database is placed in force logging, even if your tablespace is in nologging it doesn’t makes difference
about your another question, i didn’t understand it….plz explain
Abhi said
I want to discuss with someone Oracle table partition. I have some doubts. Please add me on yahoo messenger dbaIBM09@yahoo.ca
Sasiniveda G said
Hi pavan…am sasi…i have completed my BE(CSE)in 2010..looking for software jobs..ll u tell me any interviews.help me.
Pavan Kumar said
hi sasi, plz keep on watching this blog. any updates will be posted here itself
Sasiniveda G said
thank u…
sandeep said
hai.. am sandeep.. i completed MCA in 2009.. i did oracle DBA in wilshire..
will you tell me any interviews for DBA freshers in Hyd
Pavan Kumar said
hi sandeep, plz keep watching this blog…any updates will first reflect here…
sandeep said
hai,
am following your blog from 3 months.. you are posting only exp jobs only.
but not for freshers.. plz post oracle DBA fresher jobs
Pavan Kumar said
Hi Sandeep, am not a HR to know fresher openings. whatever openings i came across am posting them.. frankly its not in my hands ! If i get to know about any opp about fresher DBA jobs, surely i will post them or if you know anything like that, forward me so that i can post it….
Ketan said
Hello sir i am a Btech (2008).Working with a bpo level 2 tech support.In total have around 17 months of experience.Looking for a change.Help me out .Please contact me at 9718685666
Pavan Kumar said
you can chat with me in gmail…@ mymailbox.21. i am not clear on your skill set etc, so its better to chat
sai said
im sai from kannatech
How can i increase the size of the tmp Directory to allow more swapping ?
Pavan Kumar said
am not sure about the way on how to do that. better install linux again. but before that, check your /tmp size using below command
$ df -h /tmp
also check if its writable by oramnr user or not
Brijendra Kumar said
I am not sure but may be it works, just delete the file which are there in /temp or increase the size of ur ram.
Or if u want to increase the ur swap
follow this……….
> Create a swap file and add it to the existing swap:
#mkfile m /swap
#swap -a /swap
Example:
#mkfile 20m /newdir/swapfile
#swap -a /newdir/swapfile
To make this swap space available (add the swap file to virtual memory) each time the system is rebooted, add a line in the /etc/vfstab.
#device device mount FS fsck mount mount
#to mount to fsck point type pass at boot options