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

Подписаться 101 тыс.

Просмотров 14 тыс.

50% 1

#JUSTIN#ORACLE#SQL#TAMIL#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers
how to install oracle xe 21c on windows 10,
how to install oracle database 21c on windows 10,
install oracle database 21c on windows 10,
install oracle database 21c on windows,
install oracle database 21c windows,
how to install oracle database 21c,
oracle database installation on windows 10,
oracle database 21 installation on windows 10,
oracle installation on windows,
oracle 21c installation on windows 11,
oracle database 21c installation windows
========================================================
🌕Want to join WhatsApp Group? (Only technical discussion, no spam messages, no promotion msg)
📌chat.whatsapp.com/Gjv1mone1bd...
🌕For more details contact me on WhatsApp (+91 7010080468) or below link
wa.link/m4lat0
========================================================
Step 1: Download all the software from given link below
========================================================
1. Oracle 21C xe(Express edition)
Option 1: drive.google.com/file/d/1fxO5...
2. Download SQL developer application
Option 1: drive.google.com/file/d/1vxx7...
Option 2: www.oracle.com/tools/download...
3. Download HR schema dump
Option 1: drive.google.com/file/d/1om_v...
Step 2: Unzip all the software by using winrar or winzip
Step 3: Install Oracle 21C XE
Step 4: Connect ADMIN schema with SQL developer
---------------------------------------------------------------------------
Unlock/ Install HR Schema SQL Commands
---------------------------------------------------------------------------
Place the un Zipped HR schema dump file in the below path:
=================================================
C:\app\LENOVO\product\21c\dbhomeXE\demo\schema
Execute the below steps in ADMIN schema (In SQL Developer)
@ C:\app\LENOVO\product\21c\dbhomeXE\demo\schema\human_resources\hr_main.sql
Parameter 1 :
------------
hr
Parameter 2 :
-------------
users
Parameter 3 :
-------------
temp
Parameter 4 :
----------------------
admin
Parameter 5 ::
----------------------
$ORACLE_HOME/demo/schema/log
Parameter 6 ::
----------------------
localhost:1521/XEPDB1
Create the connection for HR schema
Execute the below steps in HR schema (make sure to change the corresponding file path as per your system name)
=======================================================================
select * from employees; -- No data will be present initially. Then execute the below commands in HR
@ C:\app\LENOVO\product\21c\dbhomeXE\demo\schema\human_resources\hr_cre.sql
@ C:\app\LENOVO\product\21c\dbhomeXE\demo\schema\human_resources\hr_popul.sql
@ C:\app\LENOVO\product\21c\dbhomeXE\demo\schema\human_resources\hr_idx.sql
@ C:\app\LENOVO\product\21c\dbhomeXE\demo\schema\human_resources\hr_code.sql
@ C:\app\LENOVO\product\21c\dbhomeXE\demo\schema\human_resources\hr_comnt.sql
@ C:\app\LENOVO\product\21c\dbhomeXE\demo\schema\human_resources\hr_analz.sql
Thanks,
Please subscribe the channel and click on bell icon for more updates on Oracle and SQL
============================================================
Oracle 11g Installation: (light weight - please follow first 15 minutes to install Oracle and SQL developer)
• How to install Informa...
============================================================
📌 Oracle SQL - Complete tutorial Playlist
• Oracle SQL Tutorial - ...
*****************************************************************************************************
📌 Oracle SQL Day wise Video:
Oracle SQL Tutorial - Day 1 - • Oracle SQL Day 1|Oracl...
Oracle SQL Tutorial - Day 2 - • Day 2 - Oracle SQL for...
Oracle SQL Tutorial - Day 3 - • Day 3 - Oracle SQL for...
Oracle SQL Tutorial - Day 4 - • Day 4 - Oracle SQL for...
Oracle SQL Tutorial - Day 5 - • Day 5 - Oracle SQL for...
****************************************************************
📌 Oracle SQL Full Course in 6 hours - TAMIL
• SQL tutorial TAMIL | ...
===============================
📌Oracle SQL Day wise Video: TAMIL
===============================
Oracle SQL in Tamil - Day 1 - • Day 1 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 2 - • Day 2 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 3 - • Day 3 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 4 - • Day 4 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 5 - • Day 5 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 6 - • Day 6 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 7 - • Day 7 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 8 - • Day 8 - SQL in TAMIL |...
Oracle SQL in Tamil Day 9 - • Oracle SQL Analytical ...
Oracle SQL in Tamil Day 10 - • Views in Oracle SQL TA...

Опубликовано:

21 июн 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 90

@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 ru-vid.com/group/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF 📌*IICS demo session:* ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-C1zGVRFM3-A.html 📌*Informatica Full Course:* ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-V2FtZ_INmjg.html 📌*SQL Full Course:* ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iuvzjf7nU1I.html 📌*Informatica, IICS, and SQL playlist* 🌕 IICS Tutorial ENGLISH - Playlist ru-vid.com/group/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj 🌕 Informatica training in ENGLISH - Playlist ru-vid.com/group/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd 🌕 Informatica Interview Preparation - ENGLISH ru-vid.com/group/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d 🌕Oracle SQL - தமிழில் ru-vid.com/group/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4 🔵 Informatica training in தமிழில் - Playlist ru-vid.com/group/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3 🔵 Informatica Interview Preparation - TAMIL ru-vid.com/group/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD 🔵Unix for Informatica Developer ru-vid.com/group/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw 🌕Informatica Project videos ru-vid.com/group/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6 Please subscribe, Like, and comment. I will post more videos. Thanks

@globalsightseers2766 Год назад

Step by step explaination super 👍👍👍. Pakka clear explanation.. The way you are teaching is easy to connect. No one can explain like you. I feel you are the greatest tutor 🤝🤝🤝🤝🤝

@NICITACADEMY Год назад

Thank you so much 🙂

@sathishbandolero Год назад

Thank you so much anna, beautifully explained. Simply and easy to follow and successfully completed too. Appreciate your time and efforts in making this video for the community. #grateful

@NICITACADEMY Год назад

Thank you so much 🙂 Keep watching my channel.

@krishnanselvam786 2 года назад

sir,one request plsql videos post pannum pothu real time la eppadi work pannuommo appadi video post pannunga sir,just basic level teach pannathinga sir,neega podura video one of the best teaching video va irukanum sir,it is my humble request sir.

@kanchanadeviraju7365 4 месяца назад

Thank you so much for this video! Due to some reason I was not able to connect to oracle using SQL Developer. The installable given by you is working for me, now I am able to connect! Very Good Explanation Sir!

@NICITACADEMY 4 месяца назад

Glad it helped! Keep watching my channel.

@KrishnaKumarM2811 Год назад

So many thanks....And unga description la iruka command la copy panna mudiyala....Drive notes irutha nalla irukum... Download pannikalam

@NICITACADEMY Год назад

Thanks. You can copy from description

@globalsightseers2766 Год назад

Thank you brother. It makes sense..

@NICITACADEMY Год назад

Glad to hear it

@sabeerrookie862 2 года назад

Vera level sir unga video la apram plsql topics video venum sir

@NICITACADEMY 2 года назад

Sure, I will post. Keep watching.

@kowricseswe6624 Год назад

thanks for your effort sir.its very useful.

@NICITACADEMY Год назад

You are most welcome

@krishnanselvam786 2 года назад

please post video about global temporary table sir.

@AshokNasa123 10 месяцев назад

Thanks sir. Successfully installed

@NICITACADEMY 10 месяцев назад

Welcome 👍Keep watching my SQL sessions.

@palanir3322 Год назад

Super teacher..Thanks so much

@NICITACADEMY Год назад

Thank you! 😃

@user-sh3md4gg2q 5 месяцев назад

Sir, I have a clarification; can you please help? Thanks for this video; it's working fine. I have tried to upload an Excel document using SQL Loader; however, I got the below error: "invalid username/password; logon denied." In my SQL Loader command: sqlldr userid=hr/hr control='C:\Users\MYSYSTEM\Downloads ew1load.ctl' I have provided the HR password as "hr" per your video, and I can also access the HR schema in SQL Developer. However, when using SQL Loader, I receive an error message. Please guide me on what my issue might be. Or should i use system/admin ?

@PadmapriyaS-ku5zx 10 месяцев назад

Establish connection problem solve panna mudila sir... Listener and select database connection place la same hostname koduthum status failure nu varuthu sir

@priyadharshini2786 Год назад

Parameter 6 :: pannathukku appuram SP2-0332: Cannot create spool file. Error starting at line : 86 File @ C:\app\Admin\product\21c\dbhomeXE\demo\schema\human_resources\hr_main.sql In command - DROP USER hr CASCADE Error report - ORA-01918: user 'HR' does not exist 01918. 00000 - "user '%s' does not exist" *Cause: User does not exist in the system. *Action: Verify the user name is correct. intha Error varuthu hr

@DhatchanaMoorthiR Месяц назад

Hi Brother, Default system host name ku badhil ah, naan localhost nu kuduthutten. adhanaala yedhum problem aaguma? Adha yeppadi change pannanum? hr schema la correct ah create pannitten, neenga guide panna badi.. Thank you so much.

@krishnanselvam786 2 года назад

please post video three types of use hints video haha waiting sir.

@NICITACADEMY 2 года назад

Will do soon

@krishnanselvam786 2 года назад

sir new series start panninga athula substr() ,and instr() video post panni irukinga athu pola videos eppa sir start panna poringa ,

@PraveenKumar-tr9rq 4 дня назад

Even after changing the host's name am facing issues in connecting. Can you please help me to connect?

@krishnanselvam786 2 года назад

table partition video post sir.

@leo67136 2 месяца назад

Nanum neriya times try panni pathutan ana last ahh rolling back action apdinu varuthu neriya videos pathu panalum ethumey workout agala bro anyone has solution kindly tell it will be very helpful

@subi0181 10 месяцев назад

How to connect hr schema in sql plus .. Plz tell

@sundarganesh421 2 года назад

very very thanks sir

@NICITACADEMY 2 года назад

Most welcome

@krishnanselvam786 2 года назад

hi sir,thank you so much....................

@NICITACADEMY 2 года назад

You are most welcome

@gnsniper07yt64 10 месяцев назад

Sir puggable database I'd yepdi pakurathu na save panni vakkala

@vikramk1712 Год назад

Why we need to import HR schema sir? System admin laye yen tables create panna koodathu. What is the use of HR schema ?

@NICITACADEMY Год назад

System schema will have only metadata tables. We will create new user to have separately all the objects.

@user-by9xy1rk8o 6 месяцев назад

bro...i installd 21 c and table created ,next step values inserting error occer Error report - ORA-01950: no privileges on tablespace 'USERS'

@user-by9xy1rk8o 6 месяцев назад

bro...pls rly

@suriya4250 Год назад

for opening core this error is coming. Listener refused the connection with the following error: ORA 12518 , TNS: listener could not hand off client connection. Thank you in advance sir!

@NICITACADEMY Год назад

Please uninstall and install one more time how I have explained.

@lavanyam1762 Год назад

SQL developer ah download pannitten first time install pannittu open pannapo ellam crt ah irunthuchu..Next Oracle install pannittu SQL developer ah open panren some modules are not found nu varuthu... So atha delete pannittu marupadiyum SQL developer ah download pannen but atha install pannum pothu some modules are missing not find nu oru page varuthu..

@NICITACADEMY Год назад

SQL developer is an application, not installable file, you have to open on top of Java, Download the SQL developer and unrar by using latest rar software. It will work.

@lavanyam1762 Год назад

@16:47 intha time la.. same error vanthuchu neenga pannatha apdiye pannen but test kudukum puthu same error varuthu..Ennaku host name listener file la lenovo nu irukku..Ungalukku iruka mathiri IP address illa..Nan neenga sonna 2 method layum pottu pathuttu but same error tha varuthu

@NICITACADEMY Год назад

Just Google your error, and try to fix it, it may be different error.

@vishnu7982 2 месяца назад

Oracle SQL developer connect panna mudiyala bro..

@vishal-il3vr Год назад

Sir getting error while installing 21c XE Your system has not been modified.

@NICITACADEMY Год назад

Please uninstall the existing Oracle and re-install one more time and follow the same process which I have explained. Use winrar software to extract the files. Keep watching my channel.

@vishal-il3vr Год назад

Sir still the installation rolling back I'm using windows 10

@arulmurugan3238 3 месяца назад

super

@NICITACADEMY 3 месяца назад

Thank you

@dhaveethuabraham3880 12 дней назад

Hi Sir, I got an error while creating core schema like this (Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied) Kindly do the needful..

@NICITACADEMY 11 дней назад

Execute this query in admin schema alter user core identified by core account unlock;

@dhaveethuabraham3880 11 дней назад

@@NICITACADEMY Wow very nice you are sir, I appreciate for your guidance sir. And one doubt about all this changes that asks save should I give save or deny that..

@stellapaul922 Год назад

I have seen it video many time...I am not able to install it... kindly help me to fix the error

@NICITACADEMY Год назад

What is the error you are getting? If you follow the same steps you can able to install it without any issues. make sure you are running the queries in the respective schema.

@haugrid9823 Год назад

13:13 service name note pannrathuku munadi naa close panniten again servise name eduka mudiuma 🙏 please reply

@NICITACADEMY Год назад

You can follow as per my video, it is same

@user-lc3su2te9f Год назад

Hi, sir . Download panniten but setup a run as administrator kudutha next step pogama apdiye irukku enna panna

@NICITACADEMY Год назад

Just restart your machine and try one more time. Instead of running as administrator, just double click the set-up file and try to install.

@jayamalinishankar 2 года назад

Sir, install pannumbothu service name screens hot eduka marandhutan...ippo service name epdi find panradhu sir

@NICITACADEMY 2 года назад

xepdb1 .. or go to sqlplus login with admin user and you can find service name.

@rathinsivan3248 Год назад

this link is expired plz new link of oracle

@rjhere3272 2 года назад

sir, please make video for the informatica installation on linux ubuntu. we dono how to install. because in real scenario we widely handle it on Linux platform. if you make a video, this will quietly useful for some people........ #NICITACADEMY

@NICITACADEMY 2 года назад

Noted

@priyadharshini2786 Год назад

Forget to take screenshots of Pluggable database.. how to get again

@NICITACADEMY Год назад

It is same as in the installation video, just follow the same

@haameemshimar8828 Год назад

is jdk version 8 enough to install sql developer??

@NICITACADEMY Год назад

Yes Enough

@venkatr6049 2 года назад

Hello ipa HR import pannumbodhu error vandhuchuna enna pannaun for eg last step la localhost la thappu panna enna pannanun??

@NICITACADEMY 2 года назад

Please follow the same steps, check the localhost whether you have mentioned any space in between. share the full error message here.

@lavanyam1762 Год назад

Ithuku solution irukka.. sir

@naveen_np Год назад

Hi core schema la table create panni values insert pannum pothu "ORA-01950 : no privileges on table space 'USERS' nu varuthu How can I solve it this problem?