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

  Рет қаралды 56,619

NIC IT ACADEMY

NIC IT ACADEMY

Күн бұрын

Пікірлер: 217
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
*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
@vyaschakravarthy9337 2 жыл бұрын
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
@NICITACADEMY 2 жыл бұрын
You're welcome!
@thasneembinnilam
@thasneembinnilam Жыл бұрын
I am successfully installed and configured. Explanations are perfect, very useful. Upload more contents related to ORACLE DB
@NICITACADEMY
@NICITACADEMY Жыл бұрын
Great to hear!. 🔵Oracle SQL Tutorial - English kzbin.info/aero/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF 🌕Oracle SQL - தமிழில் kzbin.info/aero/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4
@VibeTribe786
@VibeTribe786 Жыл бұрын
Can I import the HR schema to 19c database also. Plz reply
@mohamedafridi9168
@mohamedafridi9168 Ай бұрын
Great explanation sir, Concise and to the point!
@NICITACADEMY
@NICITACADEMY Ай бұрын
Thank you for your kind words, I am glad you found it helpful!
@nag1102
@nag1102 6 ай бұрын
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
@NICITACADEMY 6 ай бұрын
Thank you very much, Keep watching my channel.
@nag1102
@nag1102 6 ай бұрын
@@NICITACADEMY Ur welcome. Sure
@sudheerbabu3050
@sudheerbabu3050 3 ай бұрын
I have successfully installed HR Schema... Thank you so much..
@NICITACADEMY
@NICITACADEMY 3 ай бұрын
Great 👍
@krishnachakraborty4961
@krishnachakraborty4961 Жыл бұрын
Thank you so much sir .For the first time i am able to download sql developer in my windows 11
@NICITACADEMY
@NICITACADEMY Жыл бұрын
You are most welcome
@xmile2277
@xmile2277 4 ай бұрын
I like how straightforward it is.
@NICITACADEMY
@NICITACADEMY 4 ай бұрын
Thanks
@srikanthkondragunta4243
@srikanthkondragunta4243 2 жыл бұрын
thank you so much, it's very useful and neatly explained about installation and its problems
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
Keep watching my channel. Thanks for your feedback.
@duraley_v_tumane
@duraley_v_tumane Жыл бұрын
thank you so much, kind sir! im endlessly grateful for people like you!!
@NICITACADEMY
@NICITACADEMY Жыл бұрын
You're very welcome!
@raghavaperusomula7546
@raghavaperusomula7546 2 жыл бұрын
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
@NICITACADEMY 2 жыл бұрын
You are most welcome Keep watching my channel.
@Srivarthans
@Srivarthans 11 ай бұрын
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
@NICITACADEMY 11 ай бұрын
Glad it was helpful!
@hrishikeshtembe1646
@hrishikeshtembe1646 20 күн бұрын
Successfully done! Thank you!
@NICITACADEMY
@NICITACADEMY 17 күн бұрын
I'm glad you were able to successfully install Oracle 21c!
@umashiva7958
@umashiva7958 2 жыл бұрын
Thank you sir...i could easily follow your instructions and able to download successfully..thank you for your videos.
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
You are most welcome.
@mkarvj
@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?
@deepakj6717
@deepakj6717 2 жыл бұрын
Very Useful .. Thank you Sir !!
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
Glad it was helpful!
@rashadhuseynov7788
@rashadhuseynov7788 6 ай бұрын
Great job. Thank you, sir!
@NICITACADEMY
@NICITACADEMY 6 ай бұрын
Welcome. Thank you. Keep watching my channel.
@bhavnajain2657
@bhavnajain2657 Жыл бұрын
I am getting the error when connecting to SQL Developer application Error message is "The network adopter could not establish connection
@BalaFarathi
@BalaFarathi 9 ай бұрын
Could you find solution for that error
@satyanarayanamunipalli109
@satyanarayanamunipalli109 8 ай бұрын
Sir Ref at 1:17/19:51 link is not provided for downloading HR Schema. Kindly provide link for downloading HR Schema.
@insidehead
@insidehead 2 жыл бұрын
sir, after restarting the system the listener is not working.. could you please help how to resolve it..
@tryloghan3269
@tryloghan3269 Жыл бұрын
Thank you, You saved my day, you're the best!
@NICITACADEMY
@NICITACADEMY Жыл бұрын
You are welcome!
@marwadlishad146
@marwadlishad146 7 ай бұрын
you are life saver thank you very much
@NICITACADEMY
@NICITACADEMY 7 ай бұрын
You're welcome!
@krishnanselvam786
@krishnanselvam786 2 жыл бұрын
what is difference between cursor and refcursor
@krishnanselvam786
@krishnanselvam786 2 жыл бұрын
advantage of package and why using in package procedure and function use pannurom and eppa use pannum ketanga sir.
@krishnanselvam786
@krishnanselvam786 2 жыл бұрын
why using in oracle transfer user pannurom yesterday interview kettanga sir.eppadi answer pannurathunu therila
@krishnanselvam786
@krishnanselvam786 2 жыл бұрын
what is the dynamic sql and where is mosly used sir.
@evgeniynorfolk5909
@evgeniynorfolk5909 Жыл бұрын
Спасибо тебе большое, добрый человек! Желаю тебе самого наилучшего! Thank you very much, kind person! I wish you the very best!
@NICITACADEMY
@NICITACADEMY Жыл бұрын
Thank you 🙏
@krishnanselvam786
@krishnanselvam786 2 жыл бұрын
please post video three type hints sir this quest kettaga interview la sir.
@niralikatre2252
@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
@NICITACADEMY Жыл бұрын
Please watch this video fully. I have explained.
@ShwethaM-rb7jc
@ShwethaM-rb7jc 4 ай бұрын
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
@NICITACADEMY 4 ай бұрын
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
@ShwethaM-rb7jc 4 ай бұрын
Yes sir I re imported the hr schema again and it's working fine now sir..thanks a lot sir😊
@krishnanselvam786
@krishnanselvam786 2 жыл бұрын
what is difference between procedure and function
@prakasharc7629
@prakasharc7629 Жыл бұрын
Installation is "rolling back" and it is not getting install. Kindly suggest, what to do?
@sakthijack4480
@sakthijack4480 2 жыл бұрын
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
@NICITACADEMY 2 жыл бұрын
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
@sakthijack4480 2 жыл бұрын
Thank you so much sir successfully connected
@meghnadas1499
@meghnadas1499 4 ай бұрын
Sir i have dell insppirion laptop but in my laptop after 21c ,dbexe nd demo does not exists what should I do
@NICITACADEMY
@NICITACADEMY 4 ай бұрын
install this version, it will be lightweight. kzbin.info/www/bejne/gKPIl55nnbR9h8k
@reddymalathi694
@reddymalathi694 6 ай бұрын
I am getting error human resources file executing in sql developer can u please help me sir?
@VASHANTHEEEVH
@VASHANTHEEEVH 4 ай бұрын
It says: "Warning - could not install some modules." What should I do to install it properly?
@reddyprasadbonamsetty1805
@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
@NICITACADEMY Жыл бұрын
It is there in the oracle installation video and connection creation video as well. you need to create one more user, thats it.
@maheshramteke2765
@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.
@deboopatra
@deboopatra 2 жыл бұрын
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
@NICITACADEMY 2 жыл бұрын
Download one more time SQL developer and open SQL developer from new folder. It should work
@plkmaciekable
@plkmaciekable Ай бұрын
You are my hero
@NICITACADEMY
@NICITACADEMY Ай бұрын
Wow, thank you! Your kind words truly inspire me to keep creating!
@sudhakarak2300
@sudhakarak2300 2 жыл бұрын
How to get service number of Oracle 21C xe
@jscorpuz
@jscorpuz Жыл бұрын
Hello, I forgot to screen shot the oracle database connection information, where can I find it? Thank you
@NICITACADEMY
@NICITACADEMY Жыл бұрын
All the details are default value only, you can follow my video. you can input the same values
@SabbirHossain-t8x
@SabbirHossain-t8x 11 ай бұрын
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.
@integer4
@integer4 Жыл бұрын
Thank you very much!
@NICITACADEMY
@NICITACADEMY Жыл бұрын
You're welcome!
@kishormarimuthu7952
@kishormarimuthu7952 Жыл бұрын
I forgot to take starting sql developer installation finish setup screenshot wt should I do please help me
@NICITACADEMY
@NICITACADEMY Жыл бұрын
Np, Just follow the same steps in my video.
@pratikgupta9461
@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
@attitudegirljeniferwinget.1212 10 ай бұрын
Also I am gotten same problem bro.😢 What can do
@mr_pk1997
@mr_pk1997 2 жыл бұрын
Thank you so much sir..!
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
Welcome. Keep watching my channel 🙂
@kareemabdullah0
@kareemabdullah0 2 ай бұрын
my sql developer doesn't give anything when i run it
@Luckycherry0612
@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.
@NeerajTripathy-t7j
@NeerajTripathy-t7j Жыл бұрын
when i connect HR schema and click on test it is showing the " the network adapter could not established connection
@NICITACADEMY
@NICITACADEMY Жыл бұрын
Re-install one more time.
@krishnanselvam786
@krishnanselvam786 2 жыл бұрын
thank you so so much sir.
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
Most welcome
@heyman7983
@heyman7983 10 ай бұрын
i am not able to see the links for oracle, sql developer, hr_resources links
@NICITACADEMY
@NICITACADEMY 10 ай бұрын
Please check the description
@prasannavenkatesh2955
@prasannavenkatesh2955 2 жыл бұрын
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
@NICITACADEMY 2 жыл бұрын
Please follow the same steps without skipping.
@farhansayed5103
@farhansayed5103 Жыл бұрын
hi bro did problem solved
@itstimefor7145
@itstimefor7145 2 жыл бұрын
Sir what is the difference between 11g version 21c version?
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
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.
@hyderabad5218
@hyderabad5218 2 жыл бұрын
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
@NICITACADEMY 2 жыл бұрын
Please do the session alter in SQL plus.
@hyderabad5218
@hyderabad5218 2 жыл бұрын
Sir, issue is resolved, i uninstalled and reinstalled again and the issue was resolved.
@GOVARDHANREDDYVENNAPUSA-i1e
@GOVARDHANREDDYVENNAPUSA-i1e Жыл бұрын
sir i hvae problem in sql developer
@satyanarayanamunipalli109
@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
@NICITACADEMY Жыл бұрын
Namashkar Ji, No time limit on trial version, every 6 months once you need to reset the password.
@skeditz09official22
@skeditz09official22 2 жыл бұрын
Sir after installed where can I open oracle sql idont know not showing my laptop 😢
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
please check SQL developer folder, you can find the icon then open it.
@The_open_file
@The_open_file Ай бұрын
No connection not established what to do sir😔
@NICITACADEMY
@NICITACADEMY Ай бұрын
Please double check the port numbers and database connection settings.
@skeditz09official22
@skeditz09official22 2 жыл бұрын
Sir I susessfully installed all and set but idont know how to open oraclesql
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
please check SQL developer folder, you can find the icon then open it.
@kunalpatil8171
@kunalpatil8171 2 жыл бұрын
Hello Sir after the closed oracle sql devloper how to start again when i search it it not getting on desktop also
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
Go to SQL developer folder and open with icon. Watch my video
@kunalpatil8171
@kunalpatil8171 2 жыл бұрын
Ok sir
@lithish6431
@lithish6431 2 жыл бұрын
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
@NICITACADEMY 2 жыл бұрын
Please re-install winrar software one more time and download the HR dump fully and extract it.
@muhammadtaha3773
@muhammadtaha3773 9 ай бұрын
very helpful
@NICITACADEMY
@NICITACADEMY 9 ай бұрын
Glad to hear that
@gopukalyan4570
@gopukalyan4570 Жыл бұрын
Pls post the Data warehousing concept sir
@NICITACADEMY
@NICITACADEMY Жыл бұрын
kzbin.info/www/bejne/bYComKWBmdN2jKM
@logapriyasekar2275
@logapriyasekar2275 2 жыл бұрын
Sir ,Hr schemea files present but table not showing in SQL developer How to resolve this issue.
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
Please follow the same steps as I have explained in the video.
@nithyasampath7731
@nithyasampath7731 2 жыл бұрын
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
@NICITACADEMY 2 жыл бұрын
I have already posted video on this error. Not sure whether you checked it. Please check the playlist.
@skeditz09official22
@skeditz09official22 2 жыл бұрын
I sususssfully installed all set after close sql where to open my laptop
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
please check SQL developer folder, you can find the icon then open it.
@lakshmivemuri9274
@lakshmivemuri9274 9 ай бұрын
while adding HR schema 21c is empty
@DDvlogs45
@DDvlogs45 Жыл бұрын
Hi , Sir the Hr schema file is not opening it's showing error
@NICITACADEMY
@NICITACADEMY Жыл бұрын
Please check the description of this video and try to download after some time. It should download.
@sukumarkothapally7796
@sukumarkothapally7796 9 күн бұрын
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
@NICITACADEMY 9 күн бұрын
Please check this path is there in your system
@chaitrasreeram1
@chaitrasreeram1 2 жыл бұрын
is there any way we can get all Advanced sql videos
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
I will upload advanced SQL
@nag1102
@nag1102 6 ай бұрын
The current HR package has "install.sql" instead of "main.sql".
@GeervaniSingiri-t8y
@GeervaniSingiri-t8y Жыл бұрын
Where is remaining concepts of SQL like views and all ..
@NICITACADEMY
@NICITACADEMY Жыл бұрын
I will upload, please stay tuned.
@anilevergreen3286
@anilevergreen3286 Жыл бұрын
Hi sir, How can I get HR schema dump
@NICITACADEMY
@NICITACADEMY Жыл бұрын
Please check the description of the video. I have given
@maroturajasekhar9336
@maroturajasekhar9336 2 жыл бұрын
i forgot to take screen shot for service name, how can i found it ?
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
xe
@cemanivannan27
@cemanivannan27 2 жыл бұрын
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
@NICITACADEMY 2 жыл бұрын
Please download the software from the description and follow the same steps. You can able to install.
@saitejatarak19
@saitejatarak19 2 жыл бұрын
Hello Manivannan just change the destination folder , I too got the same error but after changing the folder it worked.Happy Coding
@stevealicea205
@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
@tamilarasan5515 4 ай бұрын
did your error resolved . facing the same here
@mohamedthameem8562
@mohamedthameem8562 2 жыл бұрын
i got this error how can i slove this: SQL Error: ORA-00942: table or view does not exist
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
Please follow the same steps.
@mohamedthameem8562
@mohamedthameem8562 2 жыл бұрын
@@NICITACADEMY ok I will try
@GBheemesh-qq7ye
@GBheemesh-qq7ye Жыл бұрын
@@mohamedthameem8562 is the problem solved for you?
@Oppy_gamer12
@Oppy_gamer12 Жыл бұрын
I forgot to take screenshot after installation of database. How can I get connection string now?
@NICITACADEMY
@NICITACADEMY Жыл бұрын
No issues.. You can follow my video.. it is similar
@Oppy_gamer12
@Oppy_gamer12 Жыл бұрын
@@NICITACADEMY ok
@buHamoodGaming
@buHamoodGaming Жыл бұрын
Thanks brother
@NICITACADEMY
@NICITACADEMY Жыл бұрын
Welcome
@005-ameerkhanms4
@005-ameerkhanms4 2 жыл бұрын
iving the error: ORA-01950: no privileges on tablespace 'USERS'
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
Please follow the same steps
@stevealicea205
@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
@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
@tetandtrt9156
@tetandtrt9156 2 жыл бұрын
You are awesome sir
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
Thank You.
@karlakuntasunil1179
@karlakuntasunil1179 Жыл бұрын
great!!!
@NICITACADEMY
@NICITACADEMY Жыл бұрын
Thanks, Keep watching my channel.
@AbhishekPradhan-mv1qj
@AbhishekPradhan-mv1qj Жыл бұрын
Where is the link in the description ???
@NICITACADEMY
@NICITACADEMY Жыл бұрын
Everything I have given in description, which link you want to know?
@AbhishekPradhan-mv1qj
@AbhishekPradhan-mv1qj Жыл бұрын
@@NICITACADEMY sir I got the details ..... Sorry to bother you
@NICITACADEMY
@NICITACADEMY Жыл бұрын
No problem, Keep watching my channel. Keep learning.
@tan2561
@tan2561 Жыл бұрын
Thank you !
@NICITACADEMY
@NICITACADEMY Жыл бұрын
You're welcome!
@chanduiics
@chanduiics 11 ай бұрын
how to create core schema
@NICITACADEMY
@NICITACADEMY 11 ай бұрын
Please check this video, second part kzbin.info/www/bejne/gKPIl55nnbR9h8k
@YuvrajS1ngh4
@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
@maktumbagawan6093 2 ай бұрын
Hi @yuvaraj getting the same error here as well
@kunalkumar57
@kunalkumar57 2 жыл бұрын
HR user schema not access through sqlplus
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
PLease import HR schema as per my video
@aravindrk9627
@aravindrk9627 Жыл бұрын
i am facing issues while installing any one kindly help to me ...
@rameshs2221
@rameshs2221 2 жыл бұрын
SQLPLUS 21C RUN AAGUMA Sir
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
Yeah.. it ll run
@kunalkumar57
@kunalkumar57 2 жыл бұрын
@@NICITACADEMY HR user schema not access by sqlplus after all this step done.
@karunakarr9396
@karunakarr9396 Жыл бұрын
I am getting the error while oracle 21c
@NICITACADEMY
@NICITACADEMY Жыл бұрын
what is the error?
@karunakarr9396
@karunakarr9396 Жыл бұрын
I am getting the error ORA-12514
@Jeevigcj
@Jeevigcj 6 ай бұрын
There's no set up file inside . hod people are got that?????????????????
@NICITACADEMY
@NICITACADEMY 6 ай бұрын
It is already there in the video description.
@Samudram1
@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
@jjcet0102
@jjcet0102 2 жыл бұрын
Windows 7 la install pannalaama?
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
Yes, we can install. Please go for Oracle 11g version.
@jjcet0102
@jjcet0102 2 жыл бұрын
@@NICITACADEMY installed 11g thanks for your video♥️
@gokuleditz554
@gokuleditz554 2 жыл бұрын
Is it compatible with windows8 and 8.1 ?
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
Yes compatible
@sailearner5058
@sailearner5058 2 жыл бұрын
Sir, After installation successfully, it worked as you said and I ran a query also. Then i closed .now i can't open it
@NICITACADEMY
@NICITACADEMY 2 жыл бұрын
Please open from in SQL developer folder.
@karnatisirisha7301
@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
@NICITACADEMY Жыл бұрын
I have already posted a video on this issue, kindly check SQL playlist.
@milesCM0405
@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
@milesCM0405 Жыл бұрын
Can you please help me reconnecting
@NICITACADEMY
@NICITACADEMY Жыл бұрын
Re-install one more time.
@niralikatre2252
@niralikatre2252 Жыл бұрын
Hello sir ..i had watched the video again n again ,but my doubt is not cleared whether we have to follow the same steps for creating the core schema (for target tables)like hr schema.I am also watching your IICS videos ,there Is a need of another schema for target tables .pls help sir 🙏
@NICITACADEMY
@NICITACADEMY Жыл бұрын
Yes, If you want to load the data in same oracle database then create core schema. If you want to load data to any other data base like SQL server or MySQL then create a connection and load.
@niralikatre2252
@niralikatre2252 Жыл бұрын
Ok sir ,Thank you so much for replying..it helps me alot 🙏
Oracle 21c installation on Windows Made EASY
26:25
NIC IT ACADEMY
Рет қаралды 17 М.
How to Set Up the Oracle HR Schema
6:20
Database Star
Рет қаралды 25 М.
Арыстанның айқасы, Тәуіржанның шайқасы!
25:51
QosLike / ҚосЛайк / Косылайық
Рет қаралды 699 М.
How to treat Acne💉
00:31
ISSEI / いっせい
Рет қаралды 100 МЛН
Beat Ronaldo, Win $1,000,000
22:45
MrBeast
Рет қаралды 158 МЛН
MASTER Oracle PLSQL in 30 Days or LESS!
11:13:39
NIC IT ACADEMY
Рет қаралды 31 М.
Master SQL in 6 Hours and Get Ahead of 90% of Oracle Developers!
6:36:53
NIC IT ACADEMY
Рет қаралды 461 М.