Это видео недоступно.
Сожалеем об этом.

How To Unlock HR User In Oracle Database 21c by Manish Sharma

Поделиться
HTML-код
  • Опубликовано: 13 авг 2024
  • In previous versions, Sample schemas were placed inside the pluggable database but in Oracle Database 21c we have to download the sample schemas. In this video, you will learn how to Install and unlock HR User in Oracle Database 21c by Oracle Ace Manish Sharma
    ------------------------------------------------------------------------
    ►►►LINKS◄◄◄
    Blog: No Blog Required
    Git Hub Repo: github.com/oracle/db-sample-s...
    Previous Tutorial
    ► • I Deleted The Data Fil...
    -------------------------------------------------------------------------
    ►►►Social Media - Where I sort of Live
    / rebellionrider
    / therebellionrider
    / rebellionrider
    / mannbhardwaj
    -------------------------------------------------------------------------
    ►►►Books I refer to
    PL/SQL amzn.to/2QE1jX0
    Performance Tuning amzn.to/2sgiAw4
    1z0-071 Exam amzn.to/2sgfeJw
    Python Programming amzn.to/305UEbh
    -------------------------------------------------------------------------
    ►►►Camera Gears
    ► Video Gears That We Use For Creating Our RUclips Video
    www.amazon.in/shop/manishshar...
    ► Work From Home Essential Tech That We Use Daily
    www.amazon.in/shop/manishshar...
    AFFILIATE DISCLOSURE:
    Some of the links used in the description will direct you to Amazon.in. As an Amazon Associate, I earn from qualifying purchases at no additional cost to you.
    #RebellionRider

Комментарии • 44

  • @arlettepwatsonify
    @arlettepwatsonify Год назад +5

    Thank you for this great vid.
    For anyone who gets Error ORA-65011: Pluggable database ORCLPDB does not exist - here is the script to get your pluggable DB name "SELECT pdb_name,status FROM cdb_pdbs;"

  • @nicolasenriquevilloriaguti6602
    @nicolasenriquevilloriaguti6602 Год назад +1

    Your videos are amazing! Very good voice and video managing. For a non native english speaker, I can hear your videos even with the subs!
    Thanks a lot for your efforts!!!

    • @Rebellionrider
      @Rebellionrider  Год назад +1

      Thank you so much for your kind words and support! I'm thrilled to hear that you find my videos amazing and that my voice and video management are enjoyable for you. It means a lot to me, especially knowing that English is not your native language and you can still follow along with the subtitles. I appreciate your effort to engage with my content and I'm grateful for your continued support. It's comments like yours that motivate me to keep creating and improving. Thank you again, and I hope to bring you more videos that you'll enjoy in the future!

    • @nicolasenriquevilloriaguti6602
      @nicolasenriquevilloriaguti6602 Год назад

      @@Rebellionrider Thanks to you for your generous reply! Your eng is so well pronounced and timed that almost even I can understand you without using the subtles.

  • @haameemshimar8828
    @haameemshimar8828 Год назад +4

    hy manish,
    procedure has been successfully created.by HR user is not showing in all_users.while connecting username and password is error

  • @soumyaps2902
    @soumyaps2902 10 месяцев назад +2

    In the zip file,you have shared
    I couldn't find the hr.main file
    Could you please help me with this

  • @aytacturan2182
    @aytacturan2182 Год назад

    I found the most descriptive information on this subject thanks to you, thank you very much.

  • @tsehayneshhaile5343
    @tsehayneshhaile5343 Год назад

    Manish, you are doing an excellent job! It is too beneficial. It took me a while to install it, but it's done now. Thank you a lot!

  • @anudipray4492
    @anudipray4492 2 года назад +1

    After long time Manish good to see you i have learnt from you many things previously

    • @Rebellionrider
      @Rebellionrider  2 года назад +1

      I am really happy to know that you find my content helpful. I am working hard to bring more informative content in future. Thank you so much Anudip

    • @mehtabidreesi7942
      @mehtabidreesi7942 2 года назад +1

      @@Rebellionrider @Manish Sharma plz sir kindly amke video on how to upgrade database 12c to 19c in linux from beginners level plz
      plz
      plz
      oracle 12c to 19c on linux p;zy step by step

  • @peterlisp3399
    @peterlisp3399 Год назад

    thanks, in pluggable was successful, in regular orcl created by hands , my pleasure ,great man ,great tutorial

  • @BewithuNnk
    @BewithuNnk Год назад

    I got an error while doing at the last stage after grant succeeded getting error like tns could not resolve the connect identifier specified?

  • @AmitKumar-kx3qi
    @AmitKumar-kx3qi 3 месяца назад

    Thank you so much bro

  • @user-nt5lv9pb6o
    @user-nt5lv9pb6o 9 месяцев назад

    Manish these videos are amazing, can you help me with backup and recovery in a full detailed video in a single playlist i am confused how to take backup of single database and and full and increments backup.

  • @satyabratapani8603
    @satyabratapani8603 2 года назад

    Hii..Manish when I want to re install Oracle 19c it's show a error called "failed to add sys/sys install user to %2% group"... please guide me how to resolve it

  • @batboy-um9kv
    @batboy-um9kv Год назад

    anyone knows what is the problem here:
    ERROR at line 1:
    ORA-65090: operation only allowed in a container database

  • @BewithuNnk
    @BewithuNnk Год назад

    Hi Manish, tq for uploading such kind of videos which is really helpful.
    I've a doubt why my PC has taken a lot of time to get installed almost more than 2hours oracle 21c. is there any settings that should change to overcome this problem with my laptop (4gb , 1tb wind10-64bit)

  • @manishkulkarni734
    @manishkulkarni734 2 года назад

    Hello Manish sir, I have completed connecting the HR schema as shown in this video but as I logout the session it does not show the connection and I everytime while running the session connect the hr schema by referring your video can you please suggest some solution. Thanks in advance

  • @Englishuncovered
    @Englishuncovered 2 года назад

    Hi Maneesh ur videos are very useful. Could you please upload videos related to db performance tuning and query tuning also checking dbase health checkup

  • @FM-nq7wh
    @FM-nq7wh 2 года назад

    hi Manish, do you know how to use hr user on oracle db 21c, but with a connection to the oracle free cloud? that was the only way i could install it, i am working on a mac m1 2020

  • @lawie7585
    @lawie7585 Год назад +1

    I was able to find hr_main.sql. is there anyone who can help

  • @insidehead
    @insidehead Год назад

    TNS-12545: Connect failed because target host or object does not exist
    TNS-12560: TNS:protocol adapter error
    TNS-00515: Connect failed because target host or object does not exist
    64-bit Windows Error: 49: Unknown error
    getting this error plz help... OS: window home 11

  • @realbeatrixbee
    @realbeatrixbee 2 года назад +1

    thank you for you video. but after unlocking hr user i cant login into it. what should i do&

    • @Rebellionrider
      @Rebellionrider  2 года назад

      Check the open mode of the pluggable database. Most probably it's mounted not open for read and write

    • @Rebellionrider
      @Rebellionrider  2 года назад

      You can refer this SHORTS that created ruclips.net/user/shortsbeYcobrCKG0

  • @amnaiqbal8307
    @amnaiqbal8307 Год назад

    I have followed your tutorial and my user was created succesfully. But when I try to login as HR it says that user HR doesnot exist... :( any idea on how to fix this? By the way my pluggable database is open.

  • @insidehead
    @insidehead Год назад

    ORA-01918: user 'HR' does not exist plz help

  • @aabijitshrama1382
    @aabijitshrama1382 Год назад +1

    Thanks

  • @SqlByPrashant
    @SqlByPrashant Год назад

    SP2-0310: unable to open file "_C:\oracle\dbhomeXE\demo\schema\human_resources\hr_analz.sql" what to do next? pls guide next

  • @balakarthikeyanmurugesan5170
    @balakarthikeyanmurugesan5170 Год назад

    How to do in oracle linux 21c bro

  • @ukaszwnek5089
    @ukaszwnek5089 Год назад

    Hi. I have error ORA-65011: Pluggable database ORCLPDB does not exist. What should i do?

    • @ukaszwnek5089
      @ukaszwnek5089 Год назад

      I solved the problem 🙂

    • @Rebellionrider
      @Rebellionrider  Год назад

      Do share the solution and help other in the community.

    • @tomeklewandowski3478
      @tomeklewandowski3478 Год назад +1

      Wiesz może co wstawić po ALTER SESSION SET CONTAINER = ' ' ?
      Gdy wpisuję orclpdb z filmu yo wyskakuje mi że nie istnieje takie coś. Lub gdzie tego szukać może?

  • @vineetadola1547
    @vineetadola1547 2 года назад

    Hi Manish, I have followed the steps as it is but after all I got the error SP2- 0606: cannot create spool file in logs path. And drop hr cascade and user hr doesn't exist

    • @Adarshparmar18
      @Adarshparmar18 Год назад +1

      same error how did you have resolved the error

    • @troymelok831
      @troymelok831 Год назад

      @@Adarshparmar18 same for me

  • @ramanihoney8123
    @ramanihoney8123 Год назад

    hi, i did notfind description to find ORACLE_HOME

    • @Rebellionrider
      @Rebellionrider  Год назад +1

      How to find out the SID and DB Home in Oracle Database by Manish Sharma
      ruclips.net/video/4EJcbQuaeR0/видео.html

  • @Ahmed_Tarek673
    @Ahmed_Tarek673 2 месяца назад

    I hate oracle so much