Unable to find the best wishes for you dear. Please take salute from my channel. I just try to work for those man who can face issues which one I faced earlier. Please stay with #DBA_Cave.
@@DBACave i was getting listener related issue.that solved. now it again I'm getting network not instabilished.. I'm so tired to trying everything.. it's been so many days.. please if you have anydesk number please connect na once.. i will be thankful.. please reply ASAP..
SQL>alter user sys identified by sys123; here 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.
Can you tell how the localhost server was setup - to which your sql developer is connected? Is it done with sql developer or you had to install other things as well
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.
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
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.
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
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.
it show me " Statut : échec -Echec du test : Erreur d'E/S: The Network Adapter could not establish the connection (CONNECTION_ID=g53POP4LT4+OLgvXo01F3w==)"
I am getting this error "Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off client connection (CONNECTION_ID=B/Qo7U3ZQ9+ZpHlJ4j3jkQ==)" what can I do here?
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
@@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
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.
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.
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.
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
@@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.
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.
Dear Sir, from where you hit sqlplus? If you install oracle database XE or enterprise versions on your pc then you can connect sqlplus command prompt from those pc CMD. Please mention that is yous exact issue. +8801921105214 is my Whatsapp.
Hi.I have a problem that i download sql developer but in cmd there is error like "Connect to an idle instance".What can i do? Please help me about that?
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.
@@eltacabbasov8850 Please install oracle 19c database on your computer. You could follow below steps if you want: ruclips.net/video/EeighIN8Nh8/видео.htmlsi=9IOW_HJD71AxX5x3
@@vamsinagavolu please check the downloaded file is not corrupted. If you wish download it = drive.google.com/file/d/1pzQZ4eaYUZKvLHEYH5bKH9jl-jN67N9b/view?usp=share_link
Hi Lens, We are very sorry to hear your issue. Can you confirm first is the database server configured earlier? You need a running database instance for connection testing. By default we use "sys" for sys user password when we install database software for practice or dev. You can reset your sys password anytime from cmd > sqlplus / as sysdba SQL> alter user sys identified by sys account unlcok; Hope you will understand.
Thanks for your query, which online database you want to connect from SQL developer? If Oracle Cloud database then easy, if AWS then you need to do some extra works.
I got this error: Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=ZArtofrUQUS8pTWTTeCGEA==) what should I do to resolve??
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
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
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.
hello, im having issue with the actual database installation. it give me operating system not supported and having some kind of memory available checking issue. after than i can install this. how can i solve that. do you have video on that?
Thanks for reach DBA CAVE, sorry to hear your issue. Some times some oracle DB realise have some issues with operating system level. Please ignore if this is for training or test environment. In production please fulfill the pre-requisite. We are very sorry to inform you that we have't any mentioned issue solving video.
We are sorry to hear about your issue, please make sure your database is running has an active listener. Check the listener status it should be the status running. From cmd > lsnrctl status
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 ; 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.
We are feeling sorry to hear your issue, please make which Authentication Type you chosen during testing? There Default authentication type is Default, others are OS and Kerberos. Simply we use Default Authentication.
Hi , Iam unable to connect to hr connection and getting error message like ORA-01017: Invalid username/password; logon denied. can you please help me with the password once to connect
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 account unlock;
Thanks for reach out to DBA Cave. We are very sorry to hear about your issue. May there JDK issues on your environment. Please download and install JDK included software. Also check Java environments if possible. Hope for the best.
In first step of command prompt : 'sqlplus' is not recognised as an internal or external command, operable program or batch file. Please help to resolve this error. Nice video ! Good 🤠
Is there you install any oracle database? If you configure 11g,12c or 19c database software then sqlplus will work from cmd. If database server is remote server then you can connect with SQL developer directly.
Thanks for reach DBA Cave, you need to install oracle database software on your computer or use another database server connection details for coonect from SQL Developer.
At first we need to know database instance name, username and user password for connection setup. During install the database software we must set the instance name (like ORCL), super user SYS and setup the password for SYS user.
Command prompt, "sqlplus is not recognized as an internal or external command, operable program or batch file." warning pops up. what should I do ? thanks in advance
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=ITGmt3LyQyqGZtRDYQFgVQ==) SHOWS THIS ERROR. CAN YOU PLEASE SOLVE IT BUDDY...
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.
Welcome to DBA Cave! Username is the Schema name and password is which you set during create the new schema. During installation some schema or user created automatically such as SYS, SYSTEM. You can connect users which have the create connection/session permission.
By default for practice/training we set hr schema password same as hr. We set pasword by below command during practice: alter user hr identified by hr account unlock;
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;
@@attarsaba8552 Sorry to hear your issue. Please install oracle database software if it's not installed on your machine. ruclips.net/video/EeighIN8Nh8/видео.html
![How to Create Database Connection Using Oracle SQL Developer [2024] | Oracle SQL Developer](http://i.ytimg.com/vi/Nv1UXigIpOM/mqdefault.jpg)
i resolved a problem that took me 20 days searching about it, thanks for the tutorial :)
Happy to hear finally you get release from the issue.
Thanks for reach my #DBAcave
i still searching for a solution xddd
Super ji... within few seconds, a days headache gone....
Thank you so much.
It's my pleasure that it's helps you!
Keep learning :)
Thank you very much, I wasn't able to connect to the db, this saved my day.
Glad it could help you.
thanks for the vedio.Such useful vedios will help so many to connect and practice .
So nice of you! You are welcome.
I'm glad that it's helps some of our new learner.
Take care.
no wonder why your video has ZERO DISLIKES! Thank you so much!!!
Unable to find the best wishes for you dear.
Please take salute from my channel.
I just try to work for those man who can face issues which one I faced earlier.
Please stay with #DBA_Cave.
good i resolved a problem that took me 10 days searching about it, thanks for the tutorial :)
Glad it helped! It's always happy to help others.
You are welcome.
Thank you very much, after lot of cheks i got to know how to get it this
Glad I could help.
You are welcome.
Thank you sir for the video it really helped me
You are welcome, glad that helps you.
Hello DBACAVE!
It's help me a lot!
Thanks
Hi, it's my pleasure.
1 month problem solved within a minute, thanks for making this.
Thanks for the the compliments, wish your continuous success.
Hii please help me na
@@diptikokate7348 please let us know which issue you are facing?
@@DBACave i was getting listener related issue.that solved. now it again I'm getting network not instabilished.. I'm so tired to trying everything.. it's been so many days.. please if you have anydesk number please connect na once.. i will be thankful.. please reply ASAP..
@@diptikokate7348 Whatsapp us on
+8801921105214
Thank you so much, It helped me a lot !!
You are most welcome
in command prompt alter user sys identified by sys123; where we can know sys123? i'm confused in this step, thanks for your attention!
SQL>alter user sys identified by sys123; here 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.
thank u bro i really struggled with making a connection
You are warm welcome, I'm happy for your comments.
Can you tell how the localhost server was setup - to which your sql developer is connected? Is it done with sql developer or you had to install other things as well
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.
Can you please show how did you establish my_HR_schema_connection_test?
What is 1snrct1 in the command prompt window??
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
when i typed select name from v$database, the result is only XE not orcl. Is this a problem? how if i select SID not the server name?
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.
Hi @DBAcave what is HR user ? I understand sys is a default user. i didnt understand HR user. could you please explain
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
when i tried to do the prompt with sqlplus it says sqlplus not recognized as a command how can i fix this?
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.
usefull thanks
Glad it helped, you are welcome!
Great, keep it up😸😸
Thank you, I will
it show me " Statut : échec -Echec du test : Erreur d'E/S: The Network Adapter could not establish the connection (CONNECTION_ID=g53POP4LT4+OLgvXo01F3w==)"
Sorry to hear the issue, please make sure the database is up and listener status is open.
Check the database and listener status.
Thanks a lot it helps me a lot
You are welcome
I am getting this error "Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off client connection
(CONNECTION_ID=B/Qo7U3ZQ9+ZpHlJ4j3jkQ==)"
what can I do here?
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
EVEN AFTER USING SET SERVEROUTPUT ON; BUT STILL UNABLE TO SEE OUTPUT?
guide me on this
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.
Hi sir in my cmd prompt showing error like not internal cmd like that. What should I do?
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.
how to uninstall oracle sql developer please make a video
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.
Can you help me with any dummy credentials for practice purpose
Yes, what do you need? Please let me know.
Hi "select name from ........ " What is that i cant be able to see. Pls send me. And service name u typed one parameter that also pls share
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
Geat video ..but please prepare videos in order as tutorial(playlist)
ok, Thanks
thankyou sir
getting error on building HR connection (ORA-01109: Database not open)????
@@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.
I am getting invalid username/password while creating a connection with pdb
Sorry to hear, you need to create another TNS/Service name on tnsnames.ora file for your pdbs.
Then you verify first with tnsping from command line.
when i am giving even correct user name id it shows invaild . help me out
Sorry to hear about your issue, please be sure user and password working from cmd/SQL prompt.
'sqlplus' is not recognized as an internal or external command,
operable program or batch file.
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.
'sqlplus' is not recognized as an internal or external command,
operable program or batch file.
im getting this message in command prompt
Dear Sir, from where you hit sqlplus? If you install oracle database XE or enterprise versions on your pc then you can connect sqlplus command prompt from those pc CMD. Please mention that is yous exact issue. +8801921105214 is my Whatsapp.
Hi.I have a problem that i download sql developer but in cmd there is error like "Connect to an idle instance".What can i do? Please help me about that?
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:
ruclips.net/video/EeighIN8Nh8/видео.htmlsi=9IOW_HJD71AxX5x3
thank you so much
You're welcome!
#DBA_Cave so much happy for reaching our channels!
@@DBACave I'm not able to unzip the file , it is showing 0x80000405 error I tried a lot , could u help me
@@vamsinagavolu please check the downloaded file is not corrupted.
If you wish download it =
drive.google.com/file/d/1pzQZ4eaYUZKvLHEYH5bKH9jl-jN67N9b/view?usp=share_link
@@vamsinagavolu if your error code is 0x800004005 then try to resolve.
www.winhelponline.com/blog/zip-error-0x80004005-extract-copy-unspecified-error/
@@DBACave i need informatica , i have successfully installed SQL developer , can u share informatica file
What is the password for sysdba... i am getting an error that states "invalid usernmae/ password"
Hi Lens, We are very sorry to hear your issue. Can you confirm first is the database server configured earlier? You need a running database instance for connection testing. By default we use "sys" for sys user password when we install database software for practice or dev. You can reset your sys password anytime from cmd > sqlplus / as sysdba SQL> alter user sys identified by sys account unlcok; Hope you will understand.
How to connect by it with online database ?
Thanks for your query, which online database you want to connect from SQL developer?
If Oracle Cloud database then easy, if AWS then you need to do some extra works.
I got this error: Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=ZArtofrUQUS8pTWTTeCGEA==) what should I do to resolve??
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
What do I do if I accidentally clicked x and there is just a fruit on the screen
If accidently click on x then it will pop confirm window as I know.
Sorry to hear about your issue.
I get the comment alter is not recognized as an internal or external command, operable program or batch file.
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
Hi i am facing connecting issue i tried everything but not works please helpmee🥺
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.
hello, im having issue with the actual database installation. it give me operating system not supported and having some kind of memory available checking issue. after than i can install this. how can i solve that. do you have video on that?
Thanks for reach DBA CAVE, sorry to hear your issue. Some times some oracle DB realise have some issues with operating system level. Please ignore if this is for training or test environment. In production please fulfill the pre-requisite. We are very sorry to inform you that we have't any mentioned issue solving video.
I am unable to connect manually... failure occurs...it show some error: the network adaptor could not establish the connection.
Please help me ..
We are sorry to hear about your issue, please make sure your database is running has an active listener.
Check the listener status it should be the status running.
From cmd > lsnrctl status
Check the database and listener are up and running.
Check the firewall, if on then off the firewall.
I'm getting this error while connecting the SQL server
Status : Failure -Test failed: ORA-01031: insufficient privileges
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 ;
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.
It shows No tns entries found in how to connect!
Sad... First, check your Listener is running and provide the correct Service name or SID with the hostname or IP of your DB server.
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=v6HqXdZiTtWqrJTH6JnQrg==)
Sorry to hear about your issue, this can occur due to various reasons. Listener and net service name with database may be not configured correctly.
Great
Thank you so much.
Hi, my error appear : no more authentication available? What is that mean?
We are feeling sorry to hear your issue, please make which Authentication Type you chosen during testing?
There Default authentication type is Default, others are OS and Kerberos.
Simply we use Default Authentication.
Hi , Iam unable to connect to hr connection and getting error message like ORA-01017: Invalid username/password; logon denied. can you please help me with the password once to connect
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 account unlock;
how can I solve the Unable to set the current directory based on the module file name Error?
Thanks for reach out to DBA Cave.
We are very sorry to hear about your issue.
May there JDK issues on your environment.
Please download and install JDK included software.
Also check Java environments if possible.
Hope for the best.
@@DBACave thank you
Still not connecting with sys123 I altered command to
@@RajeevRanjan-wy2wm Sorry to hear about that.
If it’s a PDB database then you should have to create another TNS name for that.
What password you typed there below username...?
During database software installation we set a password, by default we set (sys/sys) (hr/hr) for practice.
When I execute SQL developer it shows warning that install some modules and then it closes automatically
Please download again and extract the software perfectly.
After *Confirm Import Preferences* window close main homepage will open.
In first step of command prompt :
'sqlplus' is not recognised as an internal or external command, operable program or batch file.
Please help to resolve this error.
Nice video ! Good 🤠
Is there you install any oracle database?
If you configure 11g,12c or 19c database software then sqlplus will work from cmd.
If database server is remote server then you can connect with SQL developer directly.
@@DBACave ok now resolved
same issue with me
please tell me how to resolve it?
Io error..the network adaptor could not establish the connection
Thanks for reach DBA Cave, you need to install oracle database software on your computer or use another database server connection details for coonect from SQL Developer.
Hm isme ye kaise pta karege ki Name, Username aur Password kya h??????
At first we need to know database instance name, username and user password for connection setup. During install the database software we must set the instance name (like ORCL), super user SYS and setup the password for SYS user.
Command prompt, "sqlplus is not recognized as an internal or external command, operable program or batch file." warning pops up. what should I do ?
thanks in advance
@@selimyurtyapan7722 Sorry to hear this, Can you please check if oracle software is installed properly? If need U can ping me whatsapp +8801921105214
works!
Happy to hear! Thanks
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=ITGmt3LyQyqGZtRDYQFgVQ==) SHOWS THIS ERROR.
CAN YOU PLEASE SOLVE IT BUDDY...
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.
IO Error : the network adapter could not establish the connection
Please be sure that you are providing proper hostname, service name, port and username plus password.
If you need assistant please ping me.
what to fill in username and password’m
Welcome to DBA Cave!
Username is the Schema name and password is which you set during create the new schema.
During installation some schema or user created automatically such as SYS, SYSTEM.
You can connect users which have the create connection/session permission.
hii I have
one problem can you resolve
Please share your problem kindly
in second connection you give username hr but what is pass you written..?
By default for practice/training we set hr schema password same as hr.
We set pasword by below command during practice:
alter user hr identified by hr account unlock;
Mera nahi ho raha hai error aa raha hai
@@nishantpatil7628 so sad, keep trying
It worked tsm!!
Thanks for reach out DBA Cave
What is the user - hr password
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;
what is the password
You will need to give database user name and password for establish connection from SQL developer to database which you want.
What is the Password?
During database installation we must set a password.
I'm still facing some connection problem!
Oh sorry to hear. What kind of issue you facing?
Not working
😥Which issue are you facing?
@@DBACave database collection page not at started
Test failed ORA-28000 : The account is locked
Please unlock your target user first... >> ALTER USER user_name ACCOUNT UNLOCK;
@@DBACave thankyou will give it a try
I'm too facing issue.... Test-failed:oracle/jdbc/datasource/impl/OracleDAtaSource
Sorry to hear, please let me know details kindly.
'sqlplus' is not recognized as an internal or external command,
operable program or batch file.
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.
ruclips.net/video/EeighIN8Nh8/видео.html
I've installed on Ubuntu but the connections buttons doesn't appear.
Sorry to hear, is problem still facing??
@@DBACave Yes :(