Oracle 21c installation on windows | How to import HR schema in oracle 21c |Oracle 21c installation

[@NICITACADEMY]

*Complete 48 hours of Self-Paced Courses and Interview Questions Links:* courses.nicitacademy.com/ Are you interested in joining my Live training? or Self-Paced course? You can visit our website for more details. www.nicitacademy.com/ Contact me for more details @ 🌕 wa.link/m4lat0 *WhatsApp group:* chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0 Thanks, NiC IT Academy ======================================================================= 🔵Oracle SQL Tutorial - English kzbin.info/aero/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF 📌*IICS demo session:* kzbin.info/www/bejne/eWLdeImIe7JmY6M 📌*Informatica Full Course:* kzbin.info/www/bejne/jGOppY2VfrOgoMk 📌*SQL Full Course:* kzbin.info/www/bejne/n6bZq52cbNOIZ6s 📌*Informatica, IICS, and SQL playlist* 🌕 IICS Tutorial ENGLISH - Playlist kzbin.info/aero/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj 🌕 Informatica training in ENGLISH - Playlist kzbin.info/aero/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd 🌕 Informatica Interview Preparation - ENGLISH kzbin.info/aero/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d 🌕Oracle SQL - தமிழில் kzbin.info/aero/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4 🔵 Informatica training in தமிழில் - Playlist kzbin.info/aero/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3 🔵 Informatica Interview Preparation - TAMIL kzbin.info/aero/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD 🔵Unix for Informatica Developer kzbin.info/aero/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw 🌕Informatica Project videos kzbin.info/aero/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6 Please subscribe, Like, and comment. I will post more videos. Thanks

[@vyaschakravarthy9337]

Thank you so much. Earlier I didn't know that Oracle 21c is important to install before sql developer installing, and i always installed sql developer and got errors while connecting. You have done a great job

[@NICITACADEMY]

You're welcome!

[@thasneembinnilam]

I am successfully installed and configured. Explanations are perfect, very useful. Upload more contents related to ORACLE DB

[@NICITACADEMY]

Great to hear!. 🔵Oracle SQL Tutorial - English kzbin.info/aero/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF 🌕Oracle SQL - தமிழில் kzbin.info/aero/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4

[@VibeTribe786]

Can I import the HR schema to 19c database also. Plz reply

[@nag1102]

Guys, This is one BEST video to conceptualize the Oracle installation. I wanted to express my gratitude to you because I have learnt a lot from your videos. You explain complex topics clearly. Thank you for providing such high quality content. My best wishes to you!

[@NICITACADEMY]

Thank you very much, Keep watching my channel.

[@nag1102]

@@NICITACADEMY Ur welcome. Sure

[@krishnachakraborty4961]

Thank you so much sir .For the first time i am able to download sql developer in my windows 11

[@NICITACADEMY]

You are most welcome

[@raghavaperusomula7546]

thank you so much sir, before i tried many youtube videos but i doesn't help me this video helped me a lot to install and connect👏

[@NICITACADEMY]

You are most welcome Keep watching my channel.

[@sudheerbabu3050]

I have successfully installed HR Schema... Thank you so much..

[@NICITACADEMY]

Great 👍

[@srikanthkondragunta4243]

thank you so much, it's very useful and neatly explained about installation and its problems

[@NICITACADEMY]

Keep watching my channel. Thanks for your feedback.

[@Srivarthans]

Very useful for me , as I have a upcoming assessment in the topic of Oracle DBMS , going to practice PL\SQL by watching further your videos

[@NICITACADEMY]

Glad it was helpful!

[@duraley_v_tumane]

thank you so much, kind sir! im endlessly grateful for people like you!!

[@NICITACADEMY]

You're very welcome!

[@mohamedafridi9168]

Great explanation sir, Concise and to the point!

[@NICITACADEMY]

Thank you for your kind words, I am glad you found it helpful!

[@xmile2277]

I like how straightforward it is.

[@NICITACADEMY]

Thanks

[@umashiva7958]

Thank you sir...i could easily follow your instructions and able to download successfully..thank you for your videos.

[@NICITACADEMY]

You are most welcome.

[@evgeniynorfolk5909]

Спасибо тебе большое, добрый человек! Желаю тебе самого наилучшего! Thank you very much, kind person! I wish you the very best!

[@NICITACADEMY]

Thank you 🙏

[@hrishikeshtembe1646]

Successfully done! Thank you!

[@NICITACADEMY]

I'm glad you were able to successfully install Oracle 21c!

[@deepakj6717]

Very Useful .. Thank you Sir !!

[@NICITACADEMY]

Glad it was helpful!

[@rashadhuseynov7788]

Great job. Thank you, sir!

[@NICITACADEMY]

Welcome. Thank you. Keep watching my channel.

[@tryloghan3269]

Thank you, You saved my day, you're the best!

[@NICITACADEMY]

You are welcome!

[@marwadlishad146]

you are life saver thank you very much

[@NICITACADEMY]

You're welcome!

[@plkmaciekable]

You are my hero

[@NICITACADEMY]

Wow, thank you! Your kind words truly inspire me to keep creating!

[@mkarvj]

Hello Sir while connecting the SQL DB using the connection details in SQLDeveloper, getting this error message: "Listener refused the connection with the following error" ORA-21514, TNS:listener does not currently know of service request. What to do?

[@bhavnajain2657]

I am getting the error when connecting to SQL Developer application Error message is "The network adopter could not establish connection

[@BalaFarathi]

Could you find solution for that error

[@Catchy_Data]

Success. Thank you

[@NICITACADEMY]

Welcome 👍

[@krishnanselvam786]

advantage of package and why using in package procedure and function use pannurom and eppa use pannum ketanga sir.

[@insidehead]

sir, after restarting the system the listener is not working.. could you please help how to resolve it..

[@satyanarayanamunipalli109]

Sir Ref at 1:17/19:51 link is not provided for downloading HR Schema. Kindly provide link for downloading HR Schema.

[@karlakuntasunil1179]

great!!!

[@NICITACADEMY]

Thanks, Keep watching my channel.

[@muhammadtaha3773]

very helpful

[@NICITACADEMY]

Glad to hear that

[@integer4]

Thank you very much!

[@NICITACADEMY]

You're welcome!

[@ShwethaM-rb7jc]

Hi sir, thank a lot sir 🙏 I was able to follow this video, and do everything correctly but while refreshing the tables am not able to see the 7 table could u plz help me with this sir.

[@NICITACADEMY]

Please check the installation logs, what is the error, if not able to find logs now, you can re-import the HR schema one more time. Make sure that the paths are mentioned correctly.

[@ShwethaM-rb7jc]

Yes sir I re imported the hr schema again and it's working fine now sir..thanks a lot sir😊

[@krishnanselvam786]

please post video three type hints sir this quest kettaga interview la sir.

[@krishnanselvam786]

what is difference between cursor and refcursor

[@mr_pk1997]

Thank you so much sir..!

[@NICITACADEMY]

Welcome. Keep watching my channel 🙂

[@niralikatre2252]

Thank you so much Sir for your videos ,they are always beneficial n helpful. I ve successfully done the installation.Want to ask one thing How to create Core schema for target tables? Didn't find it in description box.

[@NICITACADEMY]

Please watch this video fully. I have explained.

[@krishnanselvam786]

thank you so so much sir.

[@NICITACADEMY]

Most welcome

[@VASHANTHEEEVH]

It says: "Warning - could not install some modules." What should I do to install it properly?

[@krishnanselvam786]

what is the dynamic sql and where is mosly used sir.

[@prakasharc7629]

Installation is "rolling back" and it is not getting install. Kindly suggest, what to do?

[@krishnanselvam786]

what is difference between procedure and function

[@reddymalathi694]

I am getting error human resources file executing in sql developer can u please help me sir?

[@buHamoodGaming]

Thanks brother

[@NICITACADEMY]

Welcome

[@meghnadas1499]

Sir i have dell insppirion laptop but in my laptop after 21c ,dbexe nd demo does not exists what should I do

[@NICITACADEMY]

install this version, it will be lightweight. kzbin.info/www/bejne/gKPIl55nnbR9h8k

[@sameerist2597]

I'm getting error while importing the hrs schema sir. How to solve it. Please give me the solution. Error... SP2-0332: Cannot create spool file

[@reddyprasadbonamsetty1805]

sir i have taken your iics selfaced training , but there i did not see how to connect to core schema.please help me with that

[@NICITACADEMY]

It is there in the oracle installation video and connection creation video as well. you need to create one more user, thats it.

[@sakthijack4480]

Hi Sir If I download the hr dump schema once extract that file under the human_resources folder is not file present like hr_code.sql please help me on that thanks

[@NICITACADEMY]

HR dump is available, Please check and download one more time, use winrar to unzip the file. please follow the rest of the steps, you can able to install successfully.

[@sakthijack4480]

Thank you so much sir successfully connected

[@tan2561]

Thank you !

[@NICITACADEMY]

You're welcome!

[@krishnanselvam786]

why using in oracle transfer user pannurom yesterday interview kettanga sir.eppadi answer pannurathunu therila

[@tetandtrt9156]

You are awesome sir

[@NICITACADEMY]

Thank You.

[@NeerajTripathy-t7j]

when i connect HR schema and click on test it is showing the " the network adapter could not established connection

[@NICITACADEMY]

Re-install one more time.

[@pratikgupta9461]

Sir Parameter 6 is not working.. localhost:1521/XEPDB1... Also password hr is not taken..pls tell me what can i do?

[@attitudegirljeniferwinget.1212]

Also I am gotten same problem bro.😢 What can do

[@kishormarimuthu7952]

I forgot to take starting sql developer installation finish setup screenshot wt should I do please help me

[@NICITACADEMY]

Np, Just follow the same steps in my video.

[@patansameerkhan2646]

thank U

[@NICITACADEMY]

You're welcome!

[@deboopatra]

Hi Sir, I have successfully installed Oracle 21c and created HR schema as per the video. Later I faced some issues in SQL Devloper, so I uninstalled both. But now again I installed Oracle 21c and try to create new connection in SQL Devloper but the new connection Button(+symbol) is not working and same to 'Create manually'. I tried a lot..please help me out of this.

[@NICITACADEMY]

Download one more time SQL developer and open SQL developer from new folder. It should work

[@nag1102]

The current HR package has "install.sql" instead of "main.sql".

[@maheshramteke2765]

Sir, please guide me on this issue after oracle 19c installation. If I start SQLPlus with username and password then adapter issue is showing and if I go to services then I want to start oracle service, oracle is starting then error is showing that windows is local computer Could not start OracleServiceORCL. The system can not find the file specified.

[@kunalpatil8171]

Hello Sir after the closed oracle sql devloper how to start again when i search it it not getting on desktop also

[@NICITACADEMY]

Go to SQL developer folder and open with icon. Watch my video

[@kunalpatil8171]

Ok sir

[@gopukalyan4570]

Pls post the Data warehousing concept sir

[@NICITACADEMY]

kzbin.info/www/bejne/bYComKWBmdN2jKM

[@jscorpuz]

Hello, I forgot to screen shot the oracle database connection information, where can I find it? Thank you

[@NICITACADEMY]

All the details are default value only, you can follow my video. you can input the same values

[@prasannavenkatesh2955]

Hi Sir, I wasn't able to install the software properly. I am getting an error state that status: Test failed- IO error: The network adapter couldn't establish the connection while try to create connection manually(SQL).

[@NICITACADEMY]

Please follow the same steps without skipping.

[@farhansayed5103]

hi bro did problem solved

[@heyman7983]

i am not able to see the links for oracle, sql developer, hr_resources links

[@NICITACADEMY]

Please check the description

[@itstimefor7145]

Sir what is the difference between 11g version 21c version?

[@NICITACADEMY]

11g Grid based processing and storage, 21C is cloud based processing and storage. Not much difference in SQL. But server level 21C most advanced system than 11g.

[@SabbirHossain-t8x]

Thanks for your effort. I've successfully installed and did some queries and basic operation as I'm an absolute beginner. After a while I exit sql developer and again reopen sql developer. I tried to open hr and system schema it asked for username and password. So i put but it says "TNS:listener does not currently know of service requested in connect descriptor". I tried to change the host from localhost to the host got in tns file under admin folder but yet it showing "TNS:listener does not currently know of service requested in connect descriptor". Now I uninstalled everything and reinstalling but my question is once I exit how can I get back to sql developer that will not cause the error "TNS:listener does not currently know of service requested in connect descriptor". I saw one of your vidoes in sql playlist and did so but yet getting this error.

[@kareemabdullah0]

my sql developer doesn't give anything when i run it

[@sudhakarak2300]

How to get service number of Oracle 21C xe

[@hyderabad5218]

Sir, iam unable to connect to data base by SQL developer, and i am getting an error No TNS entries found in..... Pripor to this i watched ur video changing local host in to ip address one. But also same error

[@NICITACADEMY]

Please do the session alter in SQL plus.

[@hyderabad5218]

Sir, issue is resolved, i uninstalled and reinstalled again and the issue was resolved.

[@satyanarayanamunipalli109]

Namashkar Ji , Is the Oracle 21c software downloaded from the official website of ORACLE Company is trial run software or Complete version ? Any time limit is fixed by Oracle Company for this trial version ? If so how many months it will work. If the above is a trial run software. How to get an official full version of Oracle 21c ?

[@NICITACADEMY]

Namashkar Ji, No time limit on trial version, every 6 months once you need to reset the password.

[@skeditz09official22]

Sir I susessfully installed all and set but idont know how to open oraclesql

[@NICITACADEMY]

please check SQL developer folder, you can find the icon then open it.

[@Oppy_gamer12]

I forgot to take screenshot after installation of database. How can I get connection string now?

[@NICITACADEMY]

No issues.. You can follow my video.. it is similar

[@Oppy_gamer12]

@@NICITACADEMY ok

[@skeditz09official22]

I sususssfully installed all set after close sql where to open my laptop

[@NICITACADEMY]

please check SQL developer folder, you can find the icon then open it.

[@GOVARDHANREDDYVENNAPUSA-i1e]

sir i hvae problem in sql developer

[@maroturajasekhar9336]

i forgot to take screen shot for service name, how can i found it ?

[@NICITACADEMY]

xe

[@skeditz09official22]

Sir after installed where can I open oracle sql idont know not showing my laptop 😢

[@NICITACADEMY]

please check SQL developer folder, you can find the icon then open it.

[@logapriyasekar2275]

Sir ,Hr schemea files present but table not showing in SQL developer How to resolve this issue.

[@NICITACADEMY]

Please follow the same steps as I have explained in the video.

[@DDvlogs4565]

Hi , Sir the Hr schema file is not opening it's showing error

[@NICITACADEMY]

Please check the description of this video and try to download after some time. It should download.

[@cemanivannan27]

Sir i have issue please fix it.the issue is, while installing oracle database 21c express edition-"the provided destination folder has invalid characters. verify and try again."

[@NICITACADEMY]

Please download the software from the description and follow the same steps. You can able to install.

[@saitejatarak19]

Hello Manivannan just change the destination folder , I too got the same error but after changing the folder it worked.Happy Coding

[@chaitrasreeram1]

is there any way we can get all Advanced sql videos

[@NICITACADEMY]

I will upload advanced SQL

[@Luckycherry0612]

Hi Chandra, while creating DB user i am getting below error, can you please help me. CREATE USER hr IDENTIFIED BY &pass Error report - ORA-65096: invalid common user or role name 65096. 00000 - "invalid common user or role name" *Cause: An attempt was made to create a common user or role with a name that was not valid for common users or roles. In addition to the usual rules for user and role names, common user and role names must consist only of ASCII characters, and must contain the prefix specified in common_user_prefix parameter. *Action: Specify a valid common user or role name.

[@lakshmivemuri9274]

while adding HR schema 21c is empty

[@nithyasampath7731]

Hi Sir, it throws the error - Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=jA0TWY/BQ8+iMoAGhmaeRg==)

[@NICITACADEMY]

I have already posted video on this error. Not sure whether you checked it. Please check the playlist.

[@AbhishekPradhan-mv1qj]

Where is the link in the description ???

[@NICITACADEMY]

Everything I have given in description, which link you want to know?

[@AbhishekPradhan-mv1qj]

@@NICITACADEMY sir I got the details ..... Sorry to bother you

[@NICITACADEMY]

No problem, Keep watching my channel. Keep learning.

[@The_open_file]

No connection not established what to do sir😔

[@NICITACADEMY]

Please double check the port numbers and database connection settings.

[@sukumarkothapally7796]

Hi Sir , I'm getting error as Error starting at line : 3 in command - @ C:\app\sukum\product\21c\dbhomeXE\demo\schema\human_resources\hr_main.sql Error report - SP2-0310: Unable to open file: "C:\app\sukum\product\21c\dbhomeXE\demo\schema\human_resources\hr_main.sql" while running @ C:\app\sukum\product\21c\dbhomeXE\demo\schema\human_resources\hr_main.sql in SYSTEM_ADMIN ,please let me know on this sir please

[@NICITACADEMY]

Please check this path is there in your system

[@anilevergreen3286]

Hi sir, How can I get HR schema dump

[@NICITACADEMY]

Please check the description of the video. I have given

[@stevealicea205]

Hello again. Steve here. OK... so... I uninstalled Oracle and REinstalled Oracle 12c successfully with NO errors. I already had SQL Developer installed on my machine. I opened SQL Developer and tried to add as you did in the video, "SYSTEM_ADMIN" for the username: system, and pw: admin, I added the Service Name as: XEPDB1, clicked on Test and got an error stating that the network adapter could not establish a connection. Any help on this would be MUCH appreciated. Thank you... Steve

[@tamilarasan5515]

did your error resolved . facing the same here

[@lithish6431]

Sir hr eh download pani extract kuduthu open panna ellam files um varala verum human_resources.rar nu dhan iruku.... Idha sql la run panna error nu varudhu sir help me

[@NICITACADEMY]

Please re-install winrar software one more time and download the HR dump fully and extract it.

[@stevealicea205]

Hello again... When trying to create the HR user, I get another error... "invalid username/password; logon denied"... I have checked the spelling "hr" and "hr" as the pw. Suggestions and thank you in advance. Steve

[@vSriveda]

if you get "invalid username/password; logon denied"... "solution is" = step 1 - go to system db and type querry - create user "your connection name" identified by 'your password name'; grant dba to 'your connection name' ; step 2- set host name as ip address and ip address is found in this path C:\app\'your pc name'\product\21c\homes\OraDB21Home1 etwork\admin\listener.ora step 3 - service name = XEPDB1 -(for the 21c ) and for 11g its XE step4 - click test step5- connect

[@GeervaniSingiri-t8y]

Where is remaining concepts of SQL like views and all ..

[@NICITACADEMY]

I will upload, please stay tuned.

[@gokuleditz554]

Is it compatible with windows8 and 8.1 ?

[@NICITACADEMY]

Yes compatible

[@Samudram1]

Error starting at line : 86 File @ C:\app\lenovo\product\21c\dbhomeXE\demo\schema\human_resources\hr_main.sql In command - DROP USER hr CASCADE Error report - ORA-01031: insufficient privileges 01031. 00000 - "insufficient privileges" *Cause: An attempt was made to perform a database operation without the necessary privileges. *Action: Ask your database administrator or designated security administrator to grant you the necessary privileges Showing This Error while creating schema

[@aravindrk9627]

i am facing issues while installing any one kindly help to me ...

[@chanduiics]

how to create core schema

[@NICITACADEMY]

Please check this video, second part kzbin.info/www/bejne/gKPIl55nnbR9h8k

[@karnatisirisha7301]

Hello sir, thank you for explaining very neatly, when I am setting up it’s coming error like listener refused the connection, plz help me with this, thank you

[@NICITACADEMY]

I have already posted a video on this issue, kindly check SQL playlist.

[@005-ameerkhanms4]

iving the error: ORA-01950: no privileges on tablespace 'USERS'

[@NICITACADEMY]

Please follow the same steps

[@Jeevigcj]

There's no set up file inside . hod people are got that?????????????????

[@NICITACADEMY]

It is already there in the video description.

[@jjcet0102]

Windows 7 la install pannalaama?

[@NICITACADEMY]

Yes, we can install. Please go for Oracle 11g version.

[@jjcet0102]

@@NICITACADEMY installed 11g thanks for your video♥️

[@YuvrajS1ngh4]

sir error is coming unable to open the file "@ C:\app\dell\product\21c\dbhomeXE\demo\schema\human_resources\hr_main.sql" please help

[@maktumbagawan6093]

Hi @yuvaraj getting the same error here as well

[@karunakarr9396]

I am getting the error while oracle 21c

[@NICITACADEMY]

what is the error?

[@karunakarr9396]

I am getting the error ORA-12514

[@rameshs2221]

SQLPLUS 21C RUN AAGUMA Sir

[@NICITACADEMY]

Yeah.. it ll run

[@kunalkumar57]

@@NICITACADEMY HR user schema not access by sqlplus after all this step done.

[@kunalkumar57]

HR user schema not access through sqlplus

[@NICITACADEMY]

PLease import HR schema as per my video

[@milesCM0405]

Thank you, I have installed it successfully. But over night my computer got restarted and now the database is no longer accessible via Sql developer

[@milesCM0405]

Can you please help me reconnecting

[@NICITACADEMY]

Re-install one more time.