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.
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.
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
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.
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
@@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..
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
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.
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.
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.
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.
@@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.
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.
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.
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: th-cam.com/video/EeighIN8Nh8/w-d-xo.htmlsi=9IOW_HJD71AxX5x3
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.
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
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, 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.
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.
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.
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.
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.
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
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.
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;
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
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.
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.
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.
@@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
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
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. th-cam.com/video/EeighIN8Nh8/w-d-xo.html
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.
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.
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.
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.
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.
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
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.
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.
Hello DBACAVE!
It's help me a lot!
Thanks
Hi, it's my pleasure.
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.
Thank you so much, It helped me a lot !!
You are most 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
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
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
Can you help me with any dummy credentials for practice purpose
Yes, what do you need? Please let me know.
thank u bro i really struggled with making a connection
You are warm welcome, I'm happy for your comments.
'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.
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.
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.
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.
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.
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.
Great, keep it up😸😸
Thank you, I will
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.
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.
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.
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.
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.
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.
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:
th-cam.com/video/EeighIN8Nh8/w-d-xo.htmlsi=9IOW_HJD71AxX5x3
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.
usefull thanks
Glad it helped, you are welcome!
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 "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
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, 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.
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.
'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.
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.
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
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.
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.
Thanks a lot it helps me a lot
You are welcome
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.
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.
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.
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;
Geat video ..but please prepare videos in order as tutorial(playlist)
ok, Thanks
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
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.
thankyou sir
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.
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?
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
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
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 Password?
During database installation we must set a password.
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 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;
Great
Thank you so much.
I'm still facing some connection problem!
Oh sorry to hear. What kind of issue you facing?
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
Not working
😥Which issue are you facing?
@@DBACave database collection page not at started
I'm too facing issue.... Test-failed:oracle/jdbc/datasource/impl/OracleDAtaSource
Sorry to hear, please let me know details kindly.
I've installed on Ubuntu but the connections buttons doesn't appear.
Sorry to hear, is problem still facing??
@@DBACave Yes :(
'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.
th-cam.com/video/EeighIN8Nh8/w-d-xo.html