Відео

Yap, it's from Charlie Chaplin Thank you🙂🙂

@@hotdogbutdiff Hi, yes you have to download oracle database software and install the software on your computer. Then you will able to run sqlplus from cmd. SQL Developer is just a software to connect database and it has no database itself. I will send you the link how to download and install the required software on your computer.

ua-cam.com/video/EeighIN8Nh8/v-deo.htmlsi=EuEepuBZF91yD7bj

شكرا على تعليقاتكم القيمة، والسلام عليكم ورحمة الله وبركاته! Thank your for your valuable comment, peace be upon on you!

Hi, yes please. What is the issue? Thanks

@@AshokKumar-u9q9i thanks, actually I was worked SQL Server to Oracle. I haven’t experience about your case. It’s good to learn it. I will try to catch it.

Hi Ashok, You may use below guideline to do that. ua-cam.com/video/WDsaeNvi_3c/v-deo.htmlsi=Mi81ZJXS4VASF1ea Thanks

​@@DBACave thanks but i need using oracle gateway proceess only

Thanks a lot for reach my channel. Actually your installed Oracle Database Express Edition (XE) is a light database version. Enterprise edition default SID name is ORCL and XE edition default SID is XE.

Hello, SQL Developer software need another Active Database for connecting with databases. You have to install oracle database software on your computer. May be on your computer you have an database that is not up and running. Please start the database first. It's possible from CMD or from Services.

@@DBACave How can i do what you say?

@@eltacabbasov8850 Please install oracle 19c database on your computer. You could follow below steps if you want: ua-cam.com/video/EeighIN8Nh8/v-deo.htmlsi=9IOW_HJD71AxX5x3

@@BrooksWesely your database instance not started, start your database. Simply we use SQL> alter database open; May be it’s on mount mode! If it’s PDB then start your PDB database.

So nice of you! You are welcome. I'm glad that it's helps some of our new learner. Take care.

Glad it helps you.

Nice to hear from you

You are welcome! Happy to hear from you.🙂

Thank you so much. It's my pleasure that it's helps you! Keep learning :)

@@RajeevRanjan-wy2wm Sorry to hear about that. If it’s a PDB database then you should have to create another TNS name for that.

You are welcome. Actually my current role is DBA. That's why my regular focuses are DBA administration related. I will try to make videos by your suggestion. Thanks for the feedback.

Hello, It's happen due to Listener issue. Please verify that database LISTENER status ok and related database is up and running. Check listener from CMD or Linux Terminal by: lsnrctl status Thanks

Thanks for your asking, Yes we have to install Oracle database software for connect from SQL Developer. You could use another PC's database or install on the same PC. No additional database software attached on SQL Developer itself.

Sorry to hear that, is the issue still exist? Sorry for late reply.

Sure, here is the link! drive.google.com/drive/folders/1vVZd9nesefMYTejivQBBH2uZXYhv9GTX?usp=sharing Pink me if any issue during download. Thanks

Sorry for the late reply. Hope issue is resolved. If not resolved please bounce the listener and register the service again. If the DB server is Linux then do below: Edit /etc/systemd/system.conf Set DefaultTasksMax to 'infinity'. May the issue resolve. Thanks

I am getting this same issue. @DBCave can you tell how to solve??

@@Namnika-j7b Which version is your DB? If it's 11G: follow below link; dba.stackexchange.com/questions/69184/ora-12518-tnslistener-could-not-hand-off-client-connection-oracle-xe-11-2-x64 Thanks

ধন্যবাদ, প্রক্সি আইপি নিয়ে আমার তেমন ধারণা না থাকার কারণে এতদিন রিপ্লাই দিতে পারিনি। চেষ্টা করে দেখবো।

HR schema/user is the practice database schema which is attached with Oracle database. lsnrctl is the command that can able to maintain oracle listener services. Thanks

v$database is a database dictionary metadata and it's keep the database name. Service name is the name which we set during software installation. Thanks

Hello, ki problem hoyeche apnar?

Hello Sir, you need to install oracle database software on your computer too. We need one active database and then SQL Developer. Please install Oracle database latest version on your PC. Then connect sys user then alter other user like HR

Hello Sir, you need to install oracle database software on your computer too. We need one active database and then SQL Developer. Please install Oracle database latest/19c version on your PC.

​@@DBACaveHow to install oracle data base

@ Thanks a lot. It depends Which versions of Database, OS and Variants. I’m sharing DB 19c On Windows 10 ua-cam.com/video/EeighIN8Nh8/v-deo.htmlsi=Dlpqt4KXZl8x-nNM

Thanks for your comments, SQL developer is a RUN time software and its not installed on our PCs system/control panel. If we want to remove SQL developer then just remove the software files where it was extracted it will removed from our PCs. No need to uninstall from Control panel.

Dear user, you have to install oracle database software on your computer first to chek this step. We need oracle active and running database software on our pc to connect from CMD sqlplus.

We are sorry to hear about your issues. Please mention which issue you are facing? Thanks

SQL cannot find internal or external prompt

I trying to download oracle database by watching U r video

Yes, it happend when there is no database software installed on this PC. Like this from Command Prompt: C:\Users\dbacave>sqlplus -v 'sqlplus' is not recognized as an internal or external command, operable program or batch file. C:\Users\dbacave> You need to run SQLPLUS command from a database installed PC.

@@pavanasrikanaparthi8396 Please install any version of Oracle DB software on your computer.

SQL Developer always show the result on same output windows, I'm not clear about your issue. Kindly check again after restart SQL Developer. Or please share your issues screen shot.

You are welcome, glad that helps you.

SQL>alter user sys identified by sys123; here <sys123> is the new password for setup. When we perform this then SYS user's old password will reset with new(sys123) one. Thanks for your question.

Be sure that database instance running with active listener. Check database is open and listener status is ok. Connect database from CMD or SQL plus for sure the database is ok.

Please be sure that you have the proper permission to login with the trying user. Sometime we have to grant permission to a user for connection. Like: GRANT CREATE SESSION TO <user_name>; Please share which user you are tried? Sample schema HR user has the connection and session permission to connect. If you have any other issues please knock us with +8801921105214.

Sorry to know your issue. We need to set HR schema password during database installation, if you don't unlock and setup password for HR during database installation then you need to set a password and unlock your HR schema. Command from sys user: alter user hr identified by <new_password> account unlock;

Glad it could help you.

Glad I could help. You are welcome.

Sorry for the late reply. HR user is for practice and it's includes oracle database software itself with multiple tables and data. It's a sample schema for training and learning. I think you are clear now. Thanks

Glad it helped, you are welcome!

Thanks for comments. During installation we can set the HR schema password as hr for practice. If didn't set password for HR schema then please reset the password from SYS user. Command: cmd> sqlplus / as sysdba; SQL> alter user hr identified by hr account unlock;

Thank you so much.

You're welcome!

Glad it helped

You're welcome! Thanks for reach out the DBA Cave❤️❤️

My pleasure, thanks you too

Sorry to hear, this occur due to various issue. Please ensure the proper permission on the listener and tns files. Check sqlnet.ora, listener.ora, tnsname.ora file configuration. Disable firewall. Check all the file path on the listener and tns files.

Why not, please send me your email address

@@DBACave Appreciate it if you could send it to me at your earliest convenience because am having an exam tomorrow and I need to install dbms with patching

drive.google.com/drive/folders/1p9QHZkTq9R2SrtdDWmAChPyyXR4PDEZO?usp=drive_link

Sorry to hear the issue, please make sure the database is up and listener status is open. Check the database and listener status.

It happened when oracle database software not available on the device/pc. You need to install oracle database software on your device first.

can you put a link to install oracle database plz@@DBACave

​@@DBACave Hey, I'm getting the same error. Can you please tell how to install. Or is there any video available.

@@attarsaba8552 Sorry to hear your issue. Please install oracle database software if it's not installed on your machine. ua-cam.com/video/EeighIN8Nh8/v-deo.html

I used SYS user and testing password was sys. You need an active database to connect from PL/SQL developer.

What is the oracle scope in 2024?