Pavan DBA's Blog

The DBA Knowledge Store

Video Tutorials


This Page is intended to provide knowledge on various Oracle DBA concepts in the form of videos. I have uploaded all those videos in YOUTUBE and sharing the links here in this page

Note: All videos are recorded in my practice machine and should be tested before implementing in prod or any other critical environments

Installing VMWare 7 workstation on Windows 7 platform

Installing OEL 4.7 on vmware

Installing vmware tools on OEL 4.7

Installing 10g on OEL 4.7

Installing 11gR2 on OEL 4.7

Applying 10.2.0.4 patchset or Upgrading database from 10.2.0.1 to 10.2.0.4

Installing OEL 7.2 on vmware

Installing Oracle 12.1.0.2 on Oracle Linux 7.2

Applying PSU on Oracle 12c Database

Installing Oracle Linux 6.4 64-bit on vmware

Installing Oracle 12.2.0.1 on Oracle Linux 7.3

77 Responses to “Video Tutorials”

  1. Pradeep said

    Hi Pavan ,

    Can you please share me the new batch details .

    Pradeep

    • Pavan DBA said

      you can contact admin@thetechmaster.in for training details

  2. Prakash Badhani said

    I Pavan sir i want to learn oracle dba .But i have one doubt before learning I am BA Student.But i heard lots of my friends If you are BCA,MCA student then you can get success.Please assist me Pavan. what should i do ??

    • Pavan DBA said

      it is not like that. any degree person can become oracle dba

  3. Oracle Core DBA Online Training is Offering at Glory IT Technologies. Our Online Trainiing is mostely hands on bases. Which will help students to learn Oracle DBA 11g Architecture such as backup ,recovery,database installation and trouble shooting performance issues. Extra topics also covered to help students get comfortable with Linux. Glory IT Technologies have Real Time Professionals in every Oracle Technologies

  4. khadeer said

    Pavan,Pls let me know.is there any fast track stuff @ DBA Talent,am runing short of time,pls suggest.thanks.shayam

    • Pavan DBA said

      Hi, unfortunately there is no fast track available.

  5. santhosh p said

    Hi Sir,

    i am santhosh now am working as an oracle Database administrator, recently i got the another opportunity on “database testing”. Is it fine to switch?
    and what is the difference b/w oracle DBA & database testing.

    • Pavan DBA said

      database testing is more like checking whether your database can with standby the transactions that are incoming, load analysis etc. you can take this chance as it will enhance your resume

  6. shama syed said

    hi sir… my passout btech batch is 2012.. i want to learn dba.. can u help me out? and can i know what is the relation between linux and dba??

    • Pavan DBA said

      Hi Shama, if require online training you can contact me at mymailbox.21@gmail.com.

      relation between dba and linux is Linux is a operating system on top of that, we will install oracle database. dba will be doing administration of that

  7. janakiram said

    hi..sir

    i already learned MS SQL DBA and i have sound knowledge in that …now i got a opportunity as a oracle DBA..so i want to learn oracle dba course ..what is the major difference between MS SQL DBA & oracle DBA…

    • Pavan DBA said

      administartion wise it will be same. but architecture wise it is completely different. if u r learning oracle, then u should first unlearn sql server when attending training

  8. vamsi said

    Sir i am vamsi ,I want to become a Database Administrator.. would you please tell me what courses i have to learn.

    • Pavan DBA said

      you need to first learn basics of sql, pl/sql and unix commands

  9. Sable Shekhar said

    Sir whom do you preferred the most Apps DBA or Core DBA for good future

    • Pavan DBA said

      sorry… i didn’t get your question.

      • Shekhar said

        sir i mean to say in which field future is better does it is core dba or apps dba

      • Pavan DBA said

        both are equal. better to have knowledge on both

  10. vetrivel R said

    Hi pavan,

    This is vetrivel from banglore.. acutaly i had 4 years of exp with system admin.. can you please help me out switch over as a DBA..even i dont know where i have to start with this please guide me…

    • Pavan DBA said

      better u can do oracle dba course to get into this. if u r looking for trainer, plz contact dhanvanthi.jain@gmail.com

  11. sudhakar said

    Hi sir,
    I’am MCA graduate 2009 batch,i had learned DBA 2011 at kanna technologies.After that some reasons doing some marketing job. i’am not satisfy with marketing jobs, is there any possibility to change my platform in to DBA.Please suggest me.

    • Pavan DBA said

      plz contact me on mymailbox.21@gmail.com

  12. printeshkumar T Patel said

    hi sir my name is printesh patel i done my ocp in 2012 now i want to upgrade my certification to 12c can i directly give the exam without submitting hand on course

    • Pavan DBA said

      yes you can. no need of hands on course

  13. rama koteswara rao said

    Hi Expert
    I heard about u from my friends, I have done my m.tech , I am working as manual tester in very small organization I love database concepts since my b.tech. what are the prerequisites to learn DBA .
    I want to enroll online training.

    Could you please give me the details regarding course

    • Pavan DBA said

      hi rama, its good to hear your interest in dba. for training details, plz contact the mail id or phone given in my blog

  14. Tekslate said

    Tekslate.com is the Industry leader in providing Oracle Apps DBA Training across the globe. Our online training methodology focus on hands on experience of Oracle Apps DBA.

    To Attend Free Demo (Or) For any Queries Write to us at:
    Email: info@tekslate.com
    USA :- +1 415-830-3823, India :- 91 954-262-2288
    Website: http://tekslate.com/
    URL: http://tekslate.com/oracle-apps-dba-training/

  15. mindmajix said

    Mindmajix is unique in providing Oracle Apps DBA training which emphasize on hands on experience with examples from real-time scenarios by experts. For free demo please visit :http://mindmajix.com/oracle-apps-dba-online-training

  16. pawan said

    hi pavan,

    please suggest some books to learn performance tuning (local author).

    • Pavan DBA said

      best book is oracle documentation or by donald burleson.

  17. Siva said

    hi could you please upload putty connection documnets

    • Pavan DBA said

      what u mean by putty connection documents?

    • anil said

      could please tell me which institute is best for oracle apps dba in oracle apps dba with real time knowledge and good lab facility and i have completed dba in wilshire software technologies.

      • Pavan DBA said

        you can try dba talent or sri sai technologies

  18. ja said

    you seem not talking in video but can see what you are doing

    • Pavan DBA said

      i couldnt record voice for some videos will try to modify them soon

  19. uday said

    1) what are database shutdown modes and after shutdown dbase then database come to which mountmode?
    2) connect two servers which command using in unix level?

    • Pavan DBA said

      plz go thru oracle documents or check google

  20. Krishna said

    I’m pursuing M.tech 2nd year…and working as a contract engineer in DRDO organisation. But my interest at DBA since my B.tech…I have possible timing from 7:00PM onwards everyday because of my present job…can you please suggest me the way to learn DBA..

    • Pavan DBA said

      you can better try online training

  21. ashish niranjan said

    Hello Pavan sir ,

    I have learned full Oracle 10g (sql & pl/sql).I have good knowledge in sql & pl/sql, but i am not an expert as i do not have any real time work experience.So, tell me how to improve more in database.Really need help to crack Oracle Interviews for TOP MNCs.Need your guidance for inetrviews. Willing to learn also Oracle DBA. please tell me how i will get update with current going situations for database in world business.
    please help me as i am struggling a lot for searching a job for core oracle sql,pl/sql work.

    Thanks&regards,

    Ashish
    9634343722

    • Pavan DBA said

      now a days there are less openings for sql, pl/sql developers. so i recommend u to do oracle dba course and start trying for jobs in that.

      • ashish said

        Really … thankyou very much for your suggestion. i will be very thankful to you for lifetime.

      • Pavan DBA said

        u r welcome

  22. Chandra Deo said

    Hi Pavan ,
    I work as Oracle Developer and have some experience in DBA activity(export/import DB,Schema), performace tuning and would like to move in DBA line. Could please guide me, where and how to start to become a good DBA. I have good knowledge of Oracle Database.

    • Pavan DBA said

      i suggest to do oracle dba course from a real time person so that u can get very good knowledge.

  23. naveen said

    Hello pavan
    i am taking 11g classes and our current topic performance tuning going on ,it is bit confusing to me se please suggest books for 11g beginners

    • Pavan DBA said

      try sam.r.alapati book performance tuning chapters.

  24. chinmoy said

    Hi Pavan,

    Please read my explanation & correct me if is there any wrong steps.

    The details is given below,

    Sqlplus scott/tiger@mandb

    SQL>select * from emp;

    SQL>update emp set salary=10000 where empid=5;

    SQL>commit;

    1. sqlplus command is fired, the user process (client) access sqlnet litener.
    2. sqlnet listener confirms that database is open & creates a server process.
    3. server process allocates PGA into memory. Each server process has its
    own PGA area, PGA contains data & control information of server process.
    PGA ( Private Sql area & Session Memory ).
    4. ‘Connected’ message returned to user.
    5. select * from emp;
    6. select statement is parsed into shared pool ( library cache & data dictionary
    cache) , this is called hard parse because the select statement is not already
    present in shared pool. An executable code is generated for select statement
    in shared pool. Server process got the all necessary information for select
    statement before fetch.
    7. server process takes the data from data file , loads into the buffer cache, puts
    into the most recently used(MRU) area & gives the data to the client via PGA.
    8. update emp set salary=10000 where empid=5;
    9. Before update statement , I want to say that empid=5 has a salary=8000
    10. update statement is parsed & executed in shared pool.
    11. server process checks( via PGA) buffer cache for data is available or not.
    12. In our case data is available in buffer cache.
    13. So data is updated into buffer cache with new salary i.e., 10000 & keep
    old copy i.e., 8000 into undo blocks for rollback.
    14. update is placed into redo log buffer.
    15. row updated message returned to client via Server Process(via PGA).
    16. commit;
    17. server process sends a commit to redo log buffer , a SCN is assigned.
    18. LGWR process writes redo buffer contents to current online redo log
    file on disk.
    19. CKPT process updates the header of all control files with new SCN.
    It signals DBWR to write modified blocks (dirty blocks) from buffer
    cache to data file on disk.
    20. commit complete message return to user.
    21. DBWR process writes modified blocks from buffer cache to data file
    on disk & CKPT updates header of the data file with new SCN.
    22. Undo data blocks associated with this transaction are released from
    Buffer cache.
    23. exit

    • Pavan DBA said

      all steps are correct.

  25. Hi Pavan, I’ve installed oracle10g on Linux-rhel4 through VMWARE-6.5 sucessfully but while creating database manually & connecting to sqlplus its asking for username & password. if I give username sys as sysdba & password as whatever I created while creating d database, but its showing Error as Insufficient Privileges. So how to solve dis Error. Plz Can u help me out on dis….

    • Pavan DBA said

      have u tried with below command?
      sqlplus / as sysdba

      if still getting same error, it means ur unix username is not part of DBA group. check that using “id” command of unix.

  26. uday said

    Hi pavan sir,
    I have got an interview question recentely from cts which is is in 11gR2 if we do not configure FAL_CLIENT & FAL_SERVER who is going to fill archives gap fill at standby?

    I said it is mandatory but he said FAL_CLIENT & FAL_SERVER Is optional in 11gR2 and 12c also for this what we need to tell for this sir? could u plz help me this answer

    I am waiting for ur best answer sir………

    • Pavan DBA said

      a part of it is correct. fal_client was deprecated from 11gr2 onwards. but still fal_server is there. u need to mention that.

      • uday said

        Hi sir,
        Awsome sir.I thougt it both are depricated. thanks for ur information. Suppose if we configure FAL_SERVER on standby side, without FAL_CLIENT how archve gap fill? i mean who is going to take the responsibility intimate to RFS from Primary? i got confusing plz tell me how it works……………..

      • Pavan DBA said

        it is FAL process itself.

  27. chava said

    how to find the schema information inside the dumpfile without imprting and i dont have logfile also…..

    • Pavan DBA said

      you can run import command (imp) with show=y. import logfile will get information about the dumpfile. also, see this
      https://pavandba.com/2011/07/13/different-ways-to-get-dumpfile-version-other-information/

  28. Shakeer Hussain said

    Hi Pavan,

    I had seen, you have been clarifying doubts of most here. Well going Sir, Keep it up.
    I wish you a very a happy and developing career in your life.

    With Best Regards

    Shakeer Hussain.S
    KSA

    • Pavan DBA said

      thank you

  29. Rajan said

    Went through the discussions (queries / reply ) it’s an excellent job.

    Hope to get some better solution for my query ….aswell

    I m planning to do oracle dba … attended couple of classes , the problem i’m facing is not able to understand it thoroughly in the class may be its a new area to me / some more reasons… I tried with video learning(youtube etc) i found its effective .. But they are not systematic / planned properly from basic to advanced .. do you have any such CBT with Lab sessions for oracle dba from basic to advanced….?

    Thanks
    Rajan

    • Pavan DBA said

      I don’t have complete videos. whenever I get time I used to record and upload to my blog

  30. sir,
    in my database…i practised rman..$rman catalog rm/rm target sys/sys@oradb1….execute this cmd at catalog it shows some errores …how to solve that type of errores
    rman-00554:initialization of internal recovery manager package failed
    rman-04004:error message stack fallowes
    it showes that type of errores..
    could you please tell me how to solve errores

    • Pavan DBA said

      is ur target and catalog database are of same version?
      check ur oracle_home path set correctly or not?

  31. ramu said

    hello please upload rac installation on unix. please….

    • Pavan DBA said

      it is already there in the important docs section. check out

  32. aamir said

    Hello sir,

    Will u please upload 11g manual installation on vmware?

    • Pavan DBA said

      do u mean manual db creation?

      • aamir said

        Yes sir….

      • Pavan DBA said

        i will upload it soon. right now i am busy with work

      • Aamir said

        Thanks sir….

  33. Ankur said

    Hi Pavan,
    I’m an OCP(10g) and want to learn Oracle Apps, can you please share some good video tutorials.
    Your help will be highly appreciated.

    Thanks,
    Ankur

    • Pavan DBA said

      hi ankur, unfortunately i don’t have apps knowledge. may be you can try onlineappsdba.com

      • Ankur said

        Thanks Pavan.
        I’m aware of this web site.

  34. ram said

    could u pls uploaded abt rac installations.pls……….

    • Pavan DBA said

      will do it soon

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: