Thank you so much for this. I am studying for a job interview and I hadn't been able to find one resource that doesn't seem to overlook a step/step(s). Your video was extremely concise and helpful after 2 hours of trying to get my feet off the ground in Oracle.
Sweet lord all mighty i deleted all the tables on the hr db by accident and you just saved my life with your video, plus your voice relaxed the shit out of me.
Excellent video that ended my Oracle suffering for this weekend. I'm running Oracle Express, so the key for me was using SERVICE NAME: XEPDB1 in SQL Developer when trying to make a connection with the newly created user HR after running script one. The connection issues information in the description pointed me in the right direction there. Thank you so much!
I found this very useful after I struggled for hours. everything you said was spot on. Most other instructions were vague or assumed I knew things I didn't. I really appreciate this.
Thanks Ben, you solved my problem in 5 mins for which I was exploring from last 3 hrs. I was using 10g xe but unfortunately my hard disk got corrupted and I lost all the files, when I again installed it (10g) I was not able to connect to HR as it was asking password which I was not remembering some how I created system account with the new installation and from there I followed your video and got HR schema loaded into my 10g, it was quite challenging also as I was using older version of sql developer where I was not getting docker option. from system itself i created HR user and then created schema, MANY THANKS AND KEEP MAKING LEARING MORE EASY, KUDOS TO YOU!!!
Good tutorial, but I got stuck. First, in script nº1, you must edit ALTER SESSION SET CONTAINER = ORCLPDB1; to the correct container. Oracle21 ships with XEPDB1, so the correct comnmand should be ALTER SESSION SET CONTAINER = XEPDB1; In script 2, you should mention that when you create conection HR, you must change from SID to the name of the PDB, in our case XEPDB1 , at the bottom of the "create connection" window. Thnak you for your time: it really helped me!
Awesome, thanks for the corrections! Yes, recent versions of Oracle include a PDB (Pluggable Database) which makes the connection process a little more confusing.
hi i please im stuck at the part where I load the sql scripts. The files appear as txt instead of sql in the IDE. Can you assist with where Im going wrong? might you be able to assist?thanks
hi i please im stuck at the part where I load the sql scripts. The files appear as txt instead of sql in the IDE. Can you assist with where Im going wrong? might you be able to assist?thanks
I'm using Oracle 21C XE on my machine. by running the command "Show con_name;" I see that my pluggable DB is called 'XEPDB1' instead of 'orclpdb' so I had to change the first query in the first file . from "Alter session set container=orclpdb" to "Alter session set container=XEPDB1"
Okay. Perfect.. at the part "Create HR Connection" you make new connection, eazy peazy,, but your SID is different. When I try to make this conneciton i get ORA-12514. Awesome man.. I went after you turorials because all of the others are crap. And now how do you soppose we connect to this DB when we dont have this connection in our tnsnames file? How some newbie who wants to connect to Oracle will manage to do it by following these steps? Why there is no video on that.. Anyway, you are better than the others
Thanks for the feedback! I agree that connecting to Oracle can be tricky - it's actually the number one problem that I get asked about by those who are learning Oracle. And as you can probably tell, the connection process is not easy. I've written about some common errors and possible solutions here: www.databasestar.com/oracle-connection-issues/ I also plan on enhancing that page, and making a video, to include more about connecting to Oracle. So, that page doesn't include all issues that could come up, but it may help. If it doesn't help, then hopefully some other results in Google or Stack Overflow could help you.
hi please im stuck at the part where I load the sql scripts. The files appear as txt instead of sql in the IDE. Can you assist with where Im going wrong? thanks
Just two things I thought useful after running the entire process: 1) If you need to make your PDB modifiable, just go to sqplus (in my case, using Windows command prompt) and write: sqlplus / as sysdba 1.1) Optional step, that might help or do nothing (in my case, my user of interest was SYSTEM): grant all privileges to USER_OF_INTEREST grant dba to USER_OF_INTEREST container=all; grant sysdba to USER_OF_INTEREST container=all; 1.2) Check your current PDB: select name,open_mode from v$pdbs; 1.3) Now having the PDB name and it properly in the "MOUNTED" state*, write: *1.3.0) If it is not mounted, you might just Google how to write the MOUNT statement and execute it in this step. Only then write the following: alter pluggable database YOUR_PDB_HERE open; alter pluggable database YOUR_PDB_HERE save state; From now on, your PDB will be readable/writeable. 2) If you do not use Docker, your service name will be only your PDB name, without the ".localdomain" part. Thank you for sharing!!
Sir I would love if you could translate the other oracle sample schemas (sales history, order entry, product media, information exchange) into sql commands as well, I'm trying to learn sql from a docker oracle database but i cant install the sample schemas in any other way besides yours.
I am getting the following error for every line of the first script: Error report - ORA-01917: user or role HR does not exist 01917. 00000 - user or role %s does not exist *Cause: There is not a user or role by that name. *Action: Re-specify the nam Can anybody please assist?
I assume this is happening on the command "DROP USER HR CASCADE"? If so, that's OK, because the user does not exist. You can skip this and run the next line which is "CREATE USER HR..."
Yes, if you're using this on Docker, you'll need to use a mount volume. I'm not sure how to set that up, but I'll look into it and create a video on it soon.
Hi. I ran your first script and everything was successful, but now when i try to connect to the hr database i get that error message: Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied. EDIT: I am using oracle xe 21c.
Hmm, it could be that you're connecting to the wrong database or the user is not set up correctly. I haven't used 21c XE yet, so maybe something has changed there too. I've got this post on resolving connection issues, hopefully it can help: www.databasestar.com/oracle-connection-issues/
I had same issue in 21c. When you run this CREATE USER HR IDENTIFIED BY hrpass; it creates password in uppercase. If you want to have it case sensitive include within ". Or try with HRPASS as password.
I have a problem with the first script, I am using the oracle connection in docker but the new image, this image I got for your video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-56dSXI2PbCQ.html I got the first problem in de command: alter session, I think it was the container, en your video, you use OraDoc in DB_SID. Plissss help me sorry for my English.
