@@mahiit0333 sure firstly i tired alter user hr command to check when execute the alter command it gives error hr does not exist and later i checked con_name done this command after select name,open_mode frpm v$pdbs and after alter i tried session command to set orclpdb aggain i checked con_name then it shows orclpdb finally i execute alter user hr command it gives me error hr does not exists. Again i open tscnames file and add orclpdb then open cmd run as administration then executes lsnrctl reload this command again i tried to execute sqlplus hr/hr@localhost:1521/orclpdb; then it gives me error invalid username and password.
Could you run the same commands once again by using command prompt instead of SQL developer, just to make sure not missed any steps. If get any error during any command execution, let me know. All command should Run successfully. Also, I hope you have installed Oracle 19C DB only. For other version steps would be different.
No. SQL developer version is fine. I am talking about Oracle database version. First you need to install database. Second , you need unlock HR schema And then you can connect it using SQL developer. Below video will help you to install database 19c, once that is installed, then you can perform second step of unlocking hr schema, and then connect to that HR using SQL developer Video for DB installation: ua-cam.com/video/VYPB0iYwUhQ/v-deo.htmlsi=e9aV9P9eDEwdqamP
This error usually happens when TNS file is not correctly updated. Try the solution from below link, hope that'll help you stackoverflow.com/questions/10786782/ora-12514-tnslistener-does-not-currently-know-of-service-requested-in-connect-d
superb explaination
Thanks
Bro Thank you so much, finally I unlocked 😊 HR schema
Very happy to hear 🤩
Thank You!!!
thank you boss
Glad to help
thank you
hi while trying to unlock hr schema my statement
select name,open_mode from v$pdbs; returning nothing how to create pdbs ? many thanks in advance ..
Hi I cannot access hr schema using sqlplus
What's the error? Are you able to access using sql developer?
@@mahiit0333 solved
Gr8. Glad to hear 😊
Bro i am tring connect hr schema but it shows invalid username/password; logon denied and also i tried both ways...
What are the commands you used to create hr user and to login ? Can you share the exact commands.
@@mahiit0333 sure firstly i tired alter user hr command to check when execute the alter command it gives error hr does not exist and later i checked con_name done this command after select name,open_mode frpm v$pdbs and after alter i tried session command to set orclpdb aggain i checked con_name then it shows orclpdb finally i execute alter user hr command it gives me error hr does not exists. Again i open tscnames file and add orclpdb then open cmd run as administration then executes lsnrctl reload this command again i tried to execute sqlplus hr/hr@localhost:1521/orclpdb; then it gives me error invalid username and password.
hello Mahil, I followed your steps still error is showing HR is not exists. Please assist
Have you executed all the commands by login into SYS user(Sysdba)?.
@@mahiit0333 Yes. I did but same error
Could you run the same commands once again by using command prompt instead of SQL developer, just to make sure not missed any steps. If get any error during any command execution, let me know. All command should Run successfully.
Also, I hope you have installed Oracle 19C DB only. For other version steps would be different.
@@mahiit0333 ohh. I thought the steps are same for all versions. I have installed latest version of sql developer.
Please share the different steps🙏
No. SQL developer version is fine. I am talking about Oracle database version.
First you need to install database.
Second , you need unlock HR schema
And then you can connect it using SQL developer.
Below video will help you to install database 19c, once that is installed, then you can perform second step of unlocking hr schema, and then connect to that HR using SQL developer
Video for DB installation: ua-cam.com/video/VYPB0iYwUhQ/v-deo.htmlsi=e9aV9P9eDEwdqamP
it shows ORA-01918: user 'HR' does not exist
I am getting insufficient privilege error
Which command you are executing when you get this error?
@@mahiit0333 I have figured it out. My PDB instance is on read only mode. I changed to READ WRITE Mode. After that it worked fine
Ohh ok. Gald to hear that
Bro, I can't connect to HR schema showing error: listener refused connection error:ora-12514
This error usually happens when TNS file is not correctly updated.
Try the solution from below link, hope that'll help you
stackoverflow.com/questions/10786782/ora-12514-tnslistener-does-not-currently-know-of-service-requested-in-connect-d