Oracle Database 12c Tutorial 2: How To Unlock HR schema in Oracle Database 12c

[@GrafMKristo]

It seems that every topic in the IT universe, which you are stuck in, has its indian who has already solved it and published on KZbin. No any insult here at all. You really helped me, bro! Thanks from Russia!

[@MasterZhang]

THANK YOU FOR POSTING THIS. The official documentation(s; there's like a bunch of official Oracle docs that ostensibly explain different parts of the process) are absolutely horrible at explaining how to do this. With the previous video and this one, you did in like 20 minutes what half a day of the Oracle Certification Exam Guides could not.

[@davidfullstone]

Your videos are great. Straight to the point, fast, furious and full of what's needed!

[@francisobiesie4108]

You're so good, followed your steps diligently till I got it. Thanks a lot

[@guptatushar86]

Beautifully put and sorts end-to-end doubt. Kudos ! quite an underrated tutorial ! i had tried to put hr profile couple of times after i missed it while config. oracle, before this tutorial helped me to sail through. though i had to slow the playback speed to code along, but the content smokes off that minor challenge :)

[@haseenashaik6944]

AWESOME TUTORIAL I NEVER SAW BEFORE THIS TYPE OF EXPLANATION WITH CLARITY ,LOVE UUUR VIDEOS

[@ininvideos]

Well explained. The video is good for reference. Play around with Oracle 12c. Understand and connect the concepts in the video.

[@subhankarsatpathy9990]

Amazing video, saved my entire day, although i found your video at the end of the day..

[@kevtell]

Awesome tutorial Manish, followed it step by step and it worked like a charm....

[@Rebellionrider]

+Kevin Amadi I am glad to know that the tutorial helped you. Thanks for your appreciation. Do make sure to Like and Share it with others.

[@Rebellionrider]

+Kevin Amadi Your comment has become the star comment of the day and is being featured on all my social media. Make sure to check it out. Twitter:twitter.com/RebellionRider Facebook Page:facebook.com/RebellionRider.officia Facebook Profile:facebook.com/imthebhardwaj Instagram: instagram.com/rebellionrider/

[@EasyOracleTutorials]

Best step by step video

[@mdrahman6335]

Excellent, it works. thank you Manish.

[@JunaidKhan-gq8nw]

Thanks You Very Much Manish, you are such a genius. Love You.

[@Rebellionrider]

+Junaid Khan I am delighted as well as humbled by your comments. Thank you so much for encouraging and appreciating me.

[@alishapala4910]

thank you manish... this tutorial is very helpful

[@jgaron]

Thank you Manish - great explanation

[@minduladissanayaka2667]

Great work Bro. Keep it up...!!

[@patricksinha4343]

Incredible. Thank you so much Manish, you are amazing!!!

[@vbn2763]

thanks a lot manish. i was able to unlock and connect to hr schema.

[@Sniki3]

Great quality Manish, thank you!

[@baskaraningersal6005]

Thank you very much for your best teaching

[@navinly1030]

Thank you so much sir, it works perfectly!

[@HumbertoBorba]

Very very helpfull! Thank you very much!

[@encore428]

I followed this for my 18C XE, everything works (instead of PDBORCL, 18C uses XEPDB1). Thanks.

[@karishmanikku8591]

Thank you So much Manish :) !! ur AweSome..

[@majedulislammondolgroup7816]

Thanks ,,,,, Thanks,, Thank you very much brothers......

[@Rebellionrider]

Learn how to unlock HR user in #OracleDatabase12c. Tags: #Oracle12c #Oracle #RebellionRider

[@barax9462]

Manish Sharma i did exactly what you've done and it worked but when i close sql and start it again it says that the user and employee table dont exist, how to save the hr account plz help

[@zakariachakoury7790]

+Manish Sharma ... I tried to connect via the conn hr/hr @PDBORCL. I got an error : ORACLE only available to users with RESTRICTED SESSION privilege and then I get disconnected. i tried alter system disable restricted session; (logged as sysdba) but still have the same error ... can you help me

[@ronlodh5807]

+Manish Sharma VERY GOOD MR.MANISH. GREAT SHOW.THANKS A LOT.

[@naurozehoath]

+Zakaria Chakoury Check if your PDB is in restricted mode by entering 'show pdbs'. If under Restricted it says YES, then you have to just shut down the instance and start it up again. Here's how: SQL> shutdown immediate Pluggable Database closed. SQL> startup Pluggable Database opened. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 PDBORCL READ WRITE NO

[@rajshep3009]

Hi manish, thanks for this tutorials, but i have one error message, could you tell me which service you had done manually you told in this video for save the time. SQL> conn hr/hr@pdborcl ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Warning: You are no longer connected to ORACLE.

[@janezvegan]

Really great video. Thank you for your help and your presentation of how to unlock hr user

[@nelbabarreto5373]

Thank you so much! It worked perfectly :)

[@Rebellionrider]

Always a pleasure.

[@circleoflife3749]

@@Rebellionrider Not able to execute 'conn hr/hr@pdborcl' Error : ORA-12154 : TNS : could not resolve the connect identifier specified Edit: I referred your blog still it is not resolved

[@kkbb2193]

You are the best 👍👍👍

[@kkbb2193]

Can you make some videos for informatica too ? 🙇

[@siddhantbhatt3174]

very helpfu video thanks a ton. :)

[@AhmedHamed-ot1ez]

Thanks a lot very helpful

[@mhafegypt]

Thank you very much for the explanation

[@nnnmmm9084]

i have a problem please in the file "tnsname" i have only "ORACLR_CONNECTION_DATA" and when i added the database appeared in cmd and made the step in 4:26 it didn't work

[@syedayazahmed8841]

Excellent knowledge oracle database tutorial Please do post other Oracle 12c database tutorials as wll

[@ayoob999]

Manish ...your great..I can use same method for scott user/Schema...

[@Rebellionrider]

+Ayoob manker Yes you can... Thanks for the appreciation it means a lot.

[@arsaurabh6044]

bravo ! thanks for making this video man.

[@samudraladheeraj2683]

Thanks bro it is perfectly working

[@sonyasendy8668]

Thank you for your help :)

[@Rebellionrider]

You're welcome!

[@serpentshrovoyt2714]

It worked!!!Thanks a lot!!!!

[@CarlosRecinos_SV]

MEN, THANKS, THIS WORKS FOR EL 18C VERSION OF THE DATABASE TOO,

[@buisol9972]

Is this a mandatory step to be able to use SQL developer?

[@nikola612]

Can you tell me which of your tutorials i need to follow to have an database offline on my workstation, thx in advance

[@danielfelipebustacara2700]

thanks !! You are the best

[@PouyaMoradian]

just wanna say thank you!

[@sangtran545]

Dear @Manish Sharma, I faced this error in the first command, I tried with hr/oracle, sys/oracle but both were failed. please help! C:\Users\SangTH>sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Mon Oct 5 15:40:00 2020 Copyright (c) 1982, 2017, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name:

[@jacquelines1622]

This is so frustrating. I get to the 4:45 section where I need to login as a sysdba and I keep getting the same error. ORA-01017: invalid username/password; logon denied.

[@richafernandes7399]

Hi can you please let me know how did you format sqlplus output? For me output is scattered all over the place. Do you have any blog or tutorial on that as well? Thanks

[@cuonghuy1553]

thanks you very much

[@shashwatgupta2184]

when i type the cmd sqlplus / as sysdba i get error Microsoft Windows [Version 10.0.17134.228] (c) 2018 Microsoft Corporation. All rights reserved. C:\>sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Sun Aug 19 20:39:21 2018 Copyright (c) 1982, 2014, Oracle. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied Enter user-name: i am not able to login as "sys" @Manish could u pls help me ??

[@F4sT]

thank you sir!

[@srikanthkota8534]

nice work... any alternative to this?

[@tarekhasabelnaby5881]

Thanks so much for tutorial! I couldn't create hr as a user @hrPDBORCL... any suggestion?

[@syedhasan773]

Sir is there a scott user in oracle 12c ?

[@jrstatic9231]

greetings to all, change the "pdborcl" to "orclpdb" with that helped me was a pleasure in helping them give like.

[@Ra1m010]

thanks alot

[@manojtalwar7407]

Hi Manish, thank you for the video and the instructions. All went well until the last part "Alter user hr identified by hr account unlock;' and I get an error 'ORA - 01918: user 'HR' does not exist '. Any idea?

[@zakariachakoury7790]

+Manish Sharma ... I tried to connect via the conn hr/hr @PDBORCL. I got an error : ORACLE only available to users with RESTRICTED SESSION privilege and then I get disconnected. i tried alter system disable restricted session; (logged as sysdba) but still have the same error ... can you help me

[@vterrans]

hi Manishnew to oracle following your videos.just installed 12c but cant find this file tnsname.ora in my 12c installation folder [followed the same path as you told in the video]. Please help.

[@prasadrasal7966]

thank you

[@AliHasan-pu1mt]

Thanks Manish for the very informative guidelines, I have a problem if you can tell me the solution I will be great full, I unlock the HR Schema and run through ok but can I don it for permanent what I mean is I run 12c on windows 7 and whenever I restart the computer I have to go through all this procedure again. Is any way that the Sample HR database stay unlocked. Sorry I am learner only.

[@yogirajoo]

Hello Manish, I also have same question. Do I need to repeat process after every restart? Is there a way to automate the script as a oracle startup or something like it?

[@thaaer_shaabo3130]

hi ,i try sqlplus / as sysdba after that he ask me for entering a username and password and i try all the configure that i enter it in the installtion but it faild to connect he said "Enter user-name: thaer Enter password: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified " any idea for fix problem ,and thx

[@vikasray4837]

+thaer shabo SQL> conn hr/hr @pdborcl; there is space after hr . i was facing the same issue , it is resolved now

[@ariefahmedshaik729]

I kept space but still it didnt help me and getting same error SQL> conn hr/hr @pdborcl; ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Warning: You are no longer connected to ORACLE. SQL>

[@mohammadali-ef6sv]

SQL> conn hr/hr@pdborcl ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Warning: You are no longer connected to ORACLE.

[@pkgola1996]

i was also facing same error, for this try this code SQL> conn hr/hr @pdborcl; and if you find same error which simply mean that you have different pluggable database name.

[@TECHNOFUNS]

CHECK THE tn.ora file name, where you have added new service. there would be name change .

[@zaidahmad5331]

:\Windows\system32>sqlplus / AS SYSDBA SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 19 01:49:06 2017 Copyright (c) 1982, 2014, Oracle. All rights reserved. Enter user-name: SYS AS SYSDBA Enter password: Put password that was created at the time of install Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

[@geraldmusaga6969]

how do u resolve such an error

[@15nkrish]

Hi Manish.. Quick question. I tried to connect via the conn hr/hr@pdborcl. I got a message ORACLE is only available to users with RESTRICTED SESSION PRIVILEGE and then I get disconnected. I have tried the alter disable when logged in as sysdba and then tried to connect but get the same error. Can you help?

[@larrytate28]

Manish, nice video, but every time I try to reload the listener using the command prompt, I get the following error. I also had the same problem when creating a pluggable database:C:\WINDOWS\system32>lsnrctl reloadLSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 28-JUL-2016 11:09:07Copyright (c) 1991, 2014, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Desktop)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown error Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) The command completed successfully

[@jerome_ee6522]

Im using 12c on windows 10 after this typing this, SELECT name, open_mode FROM v&pdbs; It says, Enter value for pdbs: What should I type there, @Manish Sharma?

[@karanvarma8775]

hey bro in my case there in services.msc not contain any Oracle network file, so how do i connect . can you solve this problem plz...

[@ahmedfathy3720]

Thank you very much Manish but i got the same error every time ERROR: ORA-12154: TNS:could not resolve the connect identifier specified using SQL> conn hr/hr@pdborcl; even if i add a space after hr SQL> conn hr/hr @pdborcl; i hope to help me fixing it

[@jrstatic9231]

greetings to all, change the "pdborcl" to "orclpdb" with that helped me was a pleasure in helping them give like.

[@kkbb2193]

I was able to unlock yesterday but today when I am opening the hr schema it is giving me error ORA-01033: oracle initialization or shut down in progress .....Please tell me the solution

[@binukafbinukaf3938]

thnks alot

[@PraveenKumar-wn1mk]

Thanks Manish for updating and sharing the videos. They are very helpful to me Could you upload or share information on connecting to oracle 11g database using 10g client. Since in my project, i'm having 11gR2 database and 10g Client installed in different servers. Because when i'm doing the same as said above, i'm getting cannot resolve TNS-identifier name though it is configured correctly in tnsnames.ora. But don't have any listener.ora file. Is that mandatory?

[@vikasray4837]

+Praveen Kumar SQL> conn hr/hr @pdborcl; there is space after hr . i was facing the same issue , it is resolved now

[@47tejash]

Hi Manish, I have oracle 12C on a virtual machine,cent os OS and have sqldeveloper in my local system. I need to create a local db and import a dmp file. I would really appreciate your help doing this. Thanks in advance.. Tejashree

[@H0LDENSUX]

Like most people who were unsuccessful, i keep getting the ORA-12154 Error: TNS: Could not resolve the connect identifier specified. The name of the v$active_services where con_id=3 is pdborcl.home and I'm not sure if this can affect the settings. Any further help is mostly appreciated.

[@abhi6100]

Hi manish bhai plz help me i choose second option where i created my user id and password but every time i try login with that user id and password it give error invalid login id and password .

[@rohitmalvi8137]

Thanks sir :-)

[@raghudungala9279]

I do try to unlock scott user using the same procedure .. but it says user doesnt exits.. help me out..!!

[@SACHINPRASADHS]

hi manish., i installed oracle 12c as per your previous tutorial but to unlock HR schema i cant find TNS.ORA file. How to create it. please help me.

[@aditya1000kumar]

AS soon as I connect to the database from command prompt, an ORA - 01017 Error occurs saying invalid username/password; logon denied. Can you help? BTW thanks for this very thorough video. (I installed oracle db by following your steps from one of your previous videos).

[@OasisFinder]

i am getting error ORA-01017: invalid username/password; logon denied and i am confident i am using right id and password

[@freegun300]

me too, you have a solution ?

[@ariefahmedshaik729]

I am getting error in last step SQL> alter user hr identified by hr account unlock; User altered. SQL> conn hr/hr@pdborcl ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Warning: You are no longer connected to ORACLE. SQL>

[@gkoushik8773]

hi arief ahmed shaik can u help me out if you resolved this error

[@adactverecek6162]

thank you :)

[@rambabuthippana]

Hi Manish, I have unlocked HR schema following this video, thanks for that. But each time I connect to HR schema i am facing "ORA-01033" error. then login as sys user and executes this query "alter pluggable database all open;" to resolve the issue. but this solution is only temporary, if i reboot my pc, i am encountering the same issue again. Any permanent solution for this ? Thanks in Advance.

[@ashishroutray9486]

After entering conn hr/hr@PDBORCL error: ORA-12154:TNS:could not resolve the connected to oracle. Warning :you are no longer connected to oracle. Please help me out from this issue

[@akhmadbawono]

if you find problem "Error: ORA-12541: TNS- no listener.:" Check out your TNS Names, this must not have spaces at the left side of the ALIAS. I have a space so get this problem. minute 3.55 no space before keyword PDBORCL thank you Mr +Manish Sharma

[@buseselinoglu596]

i followed but tables is not show. so no rows selected can you help me ? i checked in sql developer but no tables note : ınstaller was successful

[@prithukumar1618]

very useful

[@kazmhacyev3781]

thanks

[@sickoboy]

On the step lsnrctl reload .... TNS-01190: The user is not authorized to execute the requested listener command What should I do?

[@fatimasiddiqui7905]

HI Manish,after the last command conn hr/hr@PDBORCL m getting 'ora-12154:TNS:could not resolve the connect identifier specified' error..please help

[@vikasray4837]

+fatima siddiqui  SQL> conn hr/hr @pdborcl; there is space after hr . i was facing the same issue , it is resolved now

[@deborahbarndt8263]

My PDBORCL says READ WRITE not MOUNTED. And when I try to do the next step it gives me ORA-65019: pluggable database PDBORCL already open

[@govindarao9285]

i did sa the same way u did but got an error sayin' ORA-12451: TNS: no listener now what should i do? plz help me out..

[@vikasray4837]

+Govinda Rao SQL> conn hr/hr @pdborcl; there is space after hr . i was facing the same issue , it is resolved now

[@vinetasaini7731]

hi i tried giving space as well but same error SQL> conn hr/hr @ORCLPDB ERROR: ORA-12154: TNS:could not resolve the connect identifier specified

[@teklehaimanotatikilt1435]

how to make oracle 12 c support multilingual i tried to store to emp table of name NVARCHAR2 datatype Amharic language oracle and where i fire SELECT NAME FROM EMP oracle displays question mark why is that?

[@shashanksen8386845629]

My tnsname.orc file isn't having orcl part, what should I do ?

[@mohamedessam-xi3oh]

thank u for help u r the best but why i canot see schemea or user in commen user (enterprice manager)?? mean HR SCHEMEA !

[@hamada100001]

same issue here

[@umairansari87]

bro while executing the last query the cmd is showing"ora-12154"tns-could not resolve the connect identifier specified"" i am quite frustrated as this is my 6th time i am installing this bullshit and i didnt succeed :(

[@circleoflife3749]

Any luck after 4years ? Because same thing happened to me too

[@kkbb2193]

hi Manish I have to do the same process everytime I restart my computer. can you tell me some solution to make it permanent? thanks

[@ashique1988]

Create a trigger in sys/system which should trigger after startup on database and perform execute immediate 'alter pluggable database pdborcl open'

[@bharatbhushan05]

How we can use same in sql developer ?

[@dhanrajshirgire]

I am getting this error when I tried to login as HR SQL> select name,open_mode from v$pdbs; NAME -------------------------------------------------------------------------------- OPEN_MODE ---------- ORCLPDB READ WRITE SQL> alter user hr identified by hr account unlock; User altered. SQL> conn hr/hr@oraclepdb ERROR: ORA-12170: TNS:Connect timeout occurred Warning: You are no longer connected to ORACLE. SQL> conn hr/hr@oraclepdb ERROR: ORA-12541: TNS:no listener

[@ammaralaqili6109]

SQL> conn hr/hr@pdborcl; ERROR: ORA-12154: TNS:could not resolve the connect identifier specified

[@ammaralaqili6109]

Problem solved!

[@dariariley8101]

+Ammar Alaqili I have the same error, how did you resolve it?

[@imranrao]

+Ammar Alaqili how did you resolve the problem?

[@vikasray4837]

+Ammar Alaqili SQL> conn hr/hr @pdborcl; there is space after hr . i was facing the same issue , it is resolved now

[@ronlodh5807]

+Ammar Alaqili LOOK FOR A SPACE OR AN ESCAPE CHARACTER IN YOUR TNS ENTRY. ONCE YOU CORRECT THAT IT WILL WORK.

[@vivekswadhin84]

I tried unlocking hr user but it's giving error as TNS could not resolve the connect identifier specified . Warning: you r no longer connected to oracle. These error I m getting. Followed all steps but still unable to unlock hr user.

[@DarkWhisperer13]

Hey, Can you do some video on realtme activity? Please....

[@progamer-tk1jf]

i'm trying to connect hr but showing an error. kindly help me to resolve this issue. SQL> conn hr/hr @ORCLPDB ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

[@sonalidash7429]

In my system I can't alter the session.it is showing error like pdborcl doesn't exist. What to do now

[@AndreLandauro]

i have the same problem :(

[@mhmdwahab]

thank you for your great effort could you please show us how to connect SYS and HR account by sqldeveloper in orcale 12c release2 in windows platform