Oracle 21c installation on windows TAMIL | How to import HR schema in oracle 21c |Oracle 21c TAMIL
Вставка
- Опубліковано 21 чер 2022
- #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...
*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
ua-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
📌*IICS demo session:*
ua-cam.com/video/C1zGVRFM3-A/v-deo.html
📌*Informatica Full Course:*
ua-cam.com/video/V2FtZ_INmjg/v-deo.html
📌*SQL Full Course:*
ua-cam.com/video/iuvzjf7nU1I/v-deo.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
ua-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
🌕 Informatica training in ENGLISH - Playlist
ua-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
🌕 Informatica Interview Preparation - ENGLISH
ua-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
🌕Oracle SQL - தமிழில்
ua-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
🔵 Informatica training in தமிழில் - Playlist
ua-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
🔵 Informatica Interview Preparation - TAMIL
ua-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
🔵Unix for Informatica Developer
ua-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
🌕Informatica Project videos
ua-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
Please subscribe, Like, and comment. I will post more videos.
Thanks
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 🤝🤝🤝🤝🤝
Thank you so much 🙂
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
Thank you so much 🙂 Keep watching my channel.
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.
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!
Glad it helped! Keep watching my channel.
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 ?
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.
please post video about global temporary table sir.
Establish connection problem solve panna mudila sir... Listener and select database connection place la same hostname koduthum status failure nu varuthu sir
sir new series start panninga athula substr() ,and instr() video post panni irukinga athu pola videos eppa sir start panna poringa ,
Even after changing the host's name am facing issues in connecting. Can you please help me to connect?
So many thanks....And unga description la iruka command la copy panna mudiyala....Drive notes irutha nalla irukum... Download pannikalam
Thanks. You can copy from description
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
Vera level sir unga video la apram plsql topics video venum sir
Sure, I will post. Keep watching.
thanks for your effort sir.its very useful.
You are most welcome
Thank you brother. It makes sense..
Glad to hear it
Thanks sir. Successfully installed
Welcome 👍Keep watching my SQL sessions.
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
How to connect hr schema in sql plus .. Plz tell
Super teacher..Thanks so much
Thank you! 😃
Sir puggable database I'd yepdi pakurathu na save panni vakkala
table partition video post sir.
Why we need to import HR schema sir? System admin laye yen tables create panna koodathu. What is the use of HR schema ?
System schema will have only metadata tables. We will create new user to have separately all the objects.
please post video three types of use hints video haha waiting sir.
Will do soon
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..
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.
Oracle SQL developer connect panna mudiyala bro..
very very thanks sir
Most welcome
@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
Just Google your error, and try to fix it, it may be different error.
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!
Please uninstall and install one more time how I have explained.
bro...i installd 21 c and table created ,next step values inserting error occer
Error report -
ORA-01950: no privileges on tablespace 'USERS'
bro...pls rly
hi sir,thank you so much....................
You are most welcome
13:13 service name note pannrathuku munadi naa close panniten again servise name eduka mudiuma 🙏 please reply
You can follow as per my video, it is same
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?
Ithuku solution irukka.. sir
Hi, sir . Download panniten but setup a run as administrator kudutha next step pogama apdiye irukku enna panna
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.
Hello ipa HR import pannumbodhu error vandhuchuna enna pannaun for eg last step la localhost la thappu panna enna pannanun??
Please follow the same steps, check the localhost whether you have mentioned any space in between. share the full error message here.
is jdk version 8 enough to install sql developer??
Yes Enough
Sir, install pannumbothu service name screens hot eduka marandhutan...ippo service name epdi find panradhu sir
xepdb1 .. or go to sqlplus login with admin user and you can find service name.
I have seen it video many time...I am not able to install it... kindly help me to fix the error
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.
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..
Execute this query in admin schema
alter user core identified by core account unlock;
@@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..
this link is expired plz new link of oracle
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
Noted
super
Thank you
Any time limit for this eddition installation period
No limit
Forget to take screenshots of Pluggable database.. how to get again
It is same as in the installation video, just follow the same
Sir getting error while installing 21c XE
Your system has not been modified.
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.
Sir still the installation rolling back
I'm using windows 10
While installing this i got a error unable to open the file
Please download the software from description and follow the same steps.
How to create privileges for CORE schema
Please do it in admin schema. Watch my session fully. I explained how to make
can't able to extract hr schemas zip file
please use winrar software.
is this sql plus???
SQL developer
Can't able to download HR schema dumb file
I am not seeing any issues from my end. Please start download after some time.
First please let us 😢how to install Oracle 21c before connecting via sql developer.
It's not clear anywhere, i have tried many solutions.
I think you haven't watched the session fully, Please watch the session from the beginning without skipping, I have explained all the steps.
Sir puggable database I'd yepdi pakurathu na save panni vakkala