Connect Oracle Database with SQL Developer.

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 พ.ย. 2024

ความคิดเห็น • 183

  • @massyl5090
    @massyl5090 ปีที่แล้ว +9

    i resolved a problem that took me 20 days searching about it, thanks for the tutorial :)

    • @DBACave
      @DBACave  ปีที่แล้ว

      Happy to hear finally you get release from the issue.
      Thanks for reach my #DBAcave

    • @uknown2246
      @uknown2246 10 หลายเดือนก่อน +1

      i still searching for a solution xddd

  • @prajaram1918
    @prajaram1918 2 หลายเดือนก่อน +2

    Super ji... within few seconds, a days headache gone....

    • @DBACave
      @DBACave  2 หลายเดือนก่อน +1

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

  • @Intaberna986
    @Intaberna986 9 หลายเดือนก่อน +1

    Thank you very much, I wasn't able to connect to the db, this saved my day.

    • @DBACave
      @DBACave  8 หลายเดือนก่อน +1

      Glad it could help you.

  • @subbaraogaddale
    @subbaraogaddale 2 หลายเดือนก่อน +1

    thanks for the vedio.Such useful vedios will help so many to connect and practice .

    • @DBACave
      @DBACave  2 หลายเดือนก่อน

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

  • @sreenumetla
    @sreenumetla 9 หลายเดือนก่อน +1

    Thank you very much, after lot of cheks i got to know how to get it this

    • @DBACave
      @DBACave  9 หลายเดือนก่อน +1

      Glad I could help.
      You are welcome.

  • @amitbhagat6215
    @amitbhagat6215 8 หลายเดือนก่อน +1

    Thank you sir for the video it really helped me

    • @DBACave
      @DBACave  8 หลายเดือนก่อน

      You are welcome, glad that helps you.

  • @venkatachennareddy-d3n
    @venkatachennareddy-d3n ปีที่แล้ว +1

    good i resolved a problem that took me 10 days searching about it, thanks for the tutorial :)

    • @DBACave
      @DBACave  ปีที่แล้ว

      Glad it helped! It's always happy to help others.
      You are welcome.

  • @rafaelquerubin3834
    @rafaelquerubin3834 ปีที่แล้ว +2

    no wonder why your video has ZERO DISLIKES! Thank you so much!!!

    • @DBACave
      @DBACave  ปีที่แล้ว

      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.

  • @mandayash2980
    @mandayash2980 20 วันที่ผ่านมา +1

    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?

    • @DBACave
      @DBACave  19 วันที่ผ่านมา

      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.

  • @swetapogaku2372
    @swetapogaku2372 6 หลายเดือนก่อน +1

    Can you please show how did you establish my_HR_schema_connection_test?
    What is 1snrct1 in the command prompt window??

    • @DBACave
      @DBACave  6 หลายเดือนก่อน

      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

  • @panggilajabell
    @panggilajabell 8 หลายเดือนก่อน +1

    in command prompt alter user sys identified by sys123; where we can know sys123? i'm confused in this step, thanks for your attention!

    • @DBACave
      @DBACave  8 หลายเดือนก่อน

      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.

  • @Aleja_BB
    @Aleja_BB 7 หลายเดือนก่อน +1

    when i tried to do the prompt with sqlplus it says sqlplus not recognized as a command how can i fix this?

    • @DBACave
      @DBACave  7 หลายเดือนก่อน

      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.

  • @snowsnow-e7s
    @snowsnow-e7s ปีที่แล้ว +1

    Hello DBACAVE!
    It's help me a lot!
    Thanks

    • @DBACave
      @DBACave  ปีที่แล้ว

      Hi, it's my pleasure.

  • @DzTubeDz
    @DzTubeDz ปีที่แล้ว +2

    it show me " Statut : échec -Echec du test : Erreur d'E/S: The Network Adapter could not establish the connection (CONNECTION_ID=g53POP4LT4+OLgvXo01F3w==)"

    • @DBACave
      @DBACave  ปีที่แล้ว

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

  • @hasnaebouhmady9812
    @hasnaebouhmady9812 2 ปีที่แล้ว +3

    Thank you so much, It helped me a lot !!

    • @DBACave
      @DBACave  2 ปีที่แล้ว

      You are most welcome

  • @PallavviPatil
    @PallavviPatil 4 หลายเดือนก่อน +2

    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?

    • @DBACave
      @DBACave  4 หลายเดือนก่อน

      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
      @Namnika-j7b 3 หลายเดือนก่อน +1

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

    • @DBACave
      @DBACave  3 หลายเดือนก่อน

      @@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

  • @krov8325
    @krov8325 ปีที่แล้ว

    1 month problem solved within a minute, thanks for making this.

    • @DBACave
      @DBACave  ปีที่แล้ว

      Thanks for the the compliments, wish your continuous success.

    • @diptikokate7348
      @diptikokate7348 ปีที่แล้ว +1

      Hii please help me na

    • @DBACave
      @DBACave  ปีที่แล้ว

      @@diptikokate7348 please let us know which issue you are facing?

    • @diptikokate7348
      @diptikokate7348 ปีที่แล้ว

      @@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..

    • @DBACave
      @DBACave  ปีที่แล้ว

      @@diptikokate7348 Whatsapp us on
      +8801921105214

  • @KajalbegumShaik
    @KajalbegumShaik 9 หลายเดือนก่อน +1

    Hi @DBAcave what is HR user ? I understand sys is a default user. i didnt understand HR user. could you please explain

    • @DBACave
      @DBACave  9 หลายเดือนก่อน

      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

  • @navyamonangiri6339
    @navyamonangiri6339 2 ปีที่แล้ว +3

    Can you help me with any dummy credentials for practice purpose

    • @DBACave
      @DBACave  2 ปีที่แล้ว

      Yes, what do you need? Please let me know.

  • @iamklevy
    @iamklevy ปีที่แล้ว +1

    thank u bro i really struggled with making a connection

    • @DBACave
      @DBACave  ปีที่แล้ว

      You are warm welcome, I'm happy for your comments.

  • @numanassadi5874
    @numanassadi5874 2 ปีที่แล้ว +1

    'sqlplus' is not recognized as an internal or external command,
    operable program or batch file.
    im getting this message in command prompt

    • @DBACave
      @DBACave  2 ปีที่แล้ว

      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.

  • @adityaprakash7228
    @adityaprakash7228 3 หลายเดือนก่อน +1

    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

    • @DBACave
      @DBACave  3 หลายเดือนก่อน

      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.

  • @johnmelbinm972
    @johnmelbinm972 ปีที่แล้ว +1

    Hi sir in my cmd prompt showing error like not internal cmd like that. What should I do?

    • @DBACave
      @DBACave  ปีที่แล้ว

      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.

  • @satishnaidu-z8u
    @satishnaidu-z8u 8 หลายเดือนก่อน +1

    EVEN AFTER USING SET SERVEROUTPUT ON; BUT STILL UNABLE TO SEE OUTPUT?
    guide me on this

    • @DBACave
      @DBACave  8 หลายเดือนก่อน

      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.

  • @sabilakhan7841
    @sabilakhan7841 ปีที่แล้ว +1

    I am getting invalid username/password while creating a connection with pdb

    • @DBACave
      @DBACave  ปีที่แล้ว

      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.

  • @BrooksWesely
    @BrooksWesely หลายเดือนก่อน

    getting error on building HR connection (ORA-01109: Database not open)????

    • @DBACave
      @DBACave  หลายเดือนก่อน

      @@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.

  • @Ramisha-yp3ud
    @Ramisha-yp3ud ปีที่แล้ว

    Great, keep it up😸😸

    • @DBACave
      @DBACave  ปีที่แล้ว

      Thank you, I will

  • @ZNSong1
    @ZNSong1 7 หลายเดือนก่อน +1

    how to uninstall oracle sql developer please make a video

    • @DBACave
      @DBACave  7 หลายเดือนก่อน

      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.

  • @pradeepkumarjetta2260
    @pradeepkumarjetta2260 ปีที่แล้ว +1

    when i am giving even correct user name id it shows invaild . help me out

    • @DBACave
      @DBACave  ปีที่แล้ว

      Sorry to hear about your issue, please be sure user and password working from cmd/SQL prompt.

  • @bhavishrohilla365
    @bhavishrohilla365 ปีที่แล้ว +1

    What is the password for sysdba... i am getting an error that states "invalid usernmae/ password"

    • @DBACave
      @DBACave  ปีที่แล้ว

      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.

  • @rajjain7106
    @rajjain7106 2 ปีที่แล้ว +1

    What do I do if I accidentally clicked x and there is just a fruit on the screen

    • @DBACave
      @DBACave  2 ปีที่แล้ว

      If accidently click on x then it will pop confirm window as I know.
      Sorry to hear about your issue.

  • @thelightoflifechurch_chennai43
    @thelightoflifechurch_chennai43 2 ปีที่แล้ว +1

    It shows No tns entries found in how to connect!

    • @DBACave
      @DBACave  2 ปีที่แล้ว

      Sad... First, check your Listener is running and provide the correct Service name or SID with the hostname or IP of your DB server.

  • @parasunirmala2398
    @parasunirmala2398 ปีที่แล้ว

    When I execute SQL developer it shows warning that install some modules and then it closes automatically

    • @DBACave
      @DBACave  ปีที่แล้ว

      Please download again and extract the software perfectly.
      After *Confirm Import Preferences* window close main homepage will open.

  • @eltacabbasov8850
    @eltacabbasov8850 หลายเดือนก่อน

    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?

    • @DBACave
      @DBACave  หลายเดือนก่อน

      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
      @eltacabbasov8850 หลายเดือนก่อน +1

      @@DBACave How can i do what you say?

    • @DBACave
      @DBACave  หลายเดือนก่อน

      @@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

  • @rehankhaled4886
    @rehankhaled4886 8 หลายเดือนก่อน

    I'm getting this error while connecting the SQL server
    Status : Failure -Test failed: ORA-01031: insufficient privileges

    • @DBACave
      @DBACave  8 หลายเดือนก่อน

      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.

  • @vjnhtran63
    @vjnhtran63 9 หลายเดือนก่อน +1

    usefull thanks

    • @DBACave
      @DBACave  9 หลายเดือนก่อน

      Glad it helped, you are welcome!

  • @benmesn5481
    @benmesn5481 ปีที่แล้ว

    Hi, my error appear : no more authentication available? What is that mean?

    • @DBACave
      @DBACave  ปีที่แล้ว

      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.

  • @nasrinbanu100
    @nasrinbanu100 6 หลายเดือนก่อน +1

    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

    • @DBACave
      @DBACave  6 หลายเดือนก่อน

      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

  • @Namnika-j7b
    @Namnika-j7b 3 หลายเดือนก่อน

    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??

    • @DBACave
      @DBACave  3 หลายเดือนก่อน

      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

  • @sajidAli-sz4kn
    @sajidAli-sz4kn ปีที่แล้ว

    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?

    • @DBACave
      @DBACave  ปีที่แล้ว

      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.

  • @darklife8533
    @darklife8533 ปีที่แล้ว +1

    How to connect by it with online database ?

    • @DBACave
      @DBACave  ปีที่แล้ว

      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.

  • @priyavarshanrg700
    @priyavarshanrg700 8 หลายเดือนก่อน

    'sqlplus' is not recognized as an internal or external command,
    operable program or batch file.

    • @DBACave
      @DBACave  8 หลายเดือนก่อน

      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.

  • @rajanranade534
    @rajanranade534 ปีที่แล้ว +1

    What password you typed there below username...?

    • @DBACave
      @DBACave  ปีที่แล้ว

      During database software installation we set a password, by default we set (sys/sys) (hr/hr) for practice.

  • @buthynah19
    @buthynah19 ปีที่แล้ว

    how can I solve the Unable to set the current directory based on the module file name Error?

    • @DBACave
      @DBACave  ปีที่แล้ว

      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.

    • @buthynah19
      @buthynah19 ปีที่แล้ว

      @@DBACave thank you

  • @Nishanovels1992
    @Nishanovels1992 ปีที่แล้ว

    Io error..the network adaptor could not establish the connection

    • @DBACave
      @DBACave  ปีที่แล้ว

      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.

  • @about_satya.01
    @about_satya.01 2 ปีที่แล้ว +1

    Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=v6HqXdZiTtWqrJTH6JnQrg==)

    • @DBACave
      @DBACave  2 ปีที่แล้ว +1

      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.

  • @nuriakedir9984
    @nuriakedir9984 ปีที่แล้ว +1

    Thanks a lot it helps me a lot

    • @DBACave
      @DBACave  ปีที่แล้ว

      You are welcome

  • @aneeshk4018
    @aneeshk4018 ปีที่แล้ว

    I am unable to connect manually... failure occurs...it show some error: the network adaptor could not establish the connection.

    • @aneeshk4018
      @aneeshk4018 ปีที่แล้ว

      Please help me ..

    • @DBACave
      @DBACave  ปีที่แล้ว

      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

    • @DBACave
      @DBACave  ปีที่แล้ว

      Check the database and listener are up and running.
      Check the firewall, if on then off the firewall.

  • @pavanasrikanaparthi8396
    @pavanasrikanaparthi8396 8 หลายเดือนก่อน +1

    Hi i am facing connecting issue i tried everything but not works please helpmee🥺

    • @DBACave
      @DBACave  8 หลายเดือนก่อน

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

    • @pavanasrikanaparthi8396
      @pavanasrikanaparthi8396 8 หลายเดือนก่อน

      SQL cannot find internal or external prompt

    • @pavanasrikanaparthi8396
      @pavanasrikanaparthi8396 8 หลายเดือนก่อน +1

      I trying to download oracle database by watching U r video

    • @DBACave
      @DBACave  8 หลายเดือนก่อน

      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.

    • @DBACave
      @DBACave  8 หลายเดือนก่อน

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

  • @RajeevRanjan-wy2wm
    @RajeevRanjan-wy2wm 3 หลายเดือนก่อน

    Still not connecting with sys123 I altered command to

    • @DBACave
      @DBACave  3 หลายเดือนก่อน

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

  • @nandiniballamudi7693
    @nandiniballamudi7693 8 หลายเดือนก่อน

    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

    • @DBACave
      @DBACave  8 หลายเดือนก่อน

      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;

  • @whynottech515
    @whynottech515 2 ปีที่แล้ว

    Geat video ..but please prepare videos in order as tutorial(playlist)

    • @DBACave
      @DBACave  2 ปีที่แล้ว

      ok, Thanks

  • @dhianprameswari3524
    @dhianprameswari3524 7 หลายเดือนก่อน

    I get the comment alter is not recognized as an internal or external command, operable program or batch file.

    • @DBACave
      @DBACave  7 หลายเดือนก่อน +1

      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

  • @Popo-xs1qu
    @Popo-xs1qu ปีที่แล้ว +1

    what to fill in username and password’m

    • @DBACave
      @DBACave  ปีที่แล้ว

      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.

  • @melvin9703
    @melvin9703 ปีที่แล้ว +1

    thankyou sir

  • @ArabindaKumarNayak-d7q
    @ArabindaKumarNayak-d7q 8 หลายเดือนก่อน

    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...

    • @DBACave
      @DBACave  8 หลายเดือนก่อน

      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.

  • @ganesh_dudyala
    @ganesh_dudyala ปีที่แล้ว

    IO Error : the network adapter could not establish the connection

    • @DBACave
      @DBACave  ปีที่แล้ว +1

      Please be sure that you are providing proper hostname, service name, port and username plus password.
      If you need assistant please ping me.

  • @sandip_kanzariya8476
    @sandip_kanzariya8476 2 ปีที่แล้ว +2

    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 🤠

    • @DBACave
      @DBACave  2 ปีที่แล้ว +2

      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.

    • @sandip_kanzariya8476
      @sandip_kanzariya8476 2 ปีที่แล้ว +1

      @@DBACave ok now resolved

    • @muhammadabdullah6650
      @muhammadabdullah6650 ปีที่แล้ว +1

      same issue with me
      please tell me how to resolve it?

  • @vamsinagavolu
    @vamsinagavolu ปีที่แล้ว +1

    thank you so much

    • @DBACave
      @DBACave  ปีที่แล้ว

      You're welcome!
      #DBA_Cave so much happy for reaching our channels!

    • @vamsinagavolu
      @vamsinagavolu ปีที่แล้ว

      @@DBACave I'm not able to unzip the file , it is showing 0x80000405 error I tried a lot , could u help me

    • @DBACave
      @DBACave  ปีที่แล้ว

      @@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

    • @DBACave
      @DBACave  ปีที่แล้ว

      @@vamsinagavolu if your error code is 0x800004005 then try to resolve.
      www.winhelponline.com/blog/zip-error-0x80004005-extract-copy-unspecified-error/

    • @vamsinagavolu
      @vamsinagavolu ปีที่แล้ว

      @@DBACave i need informatica , i have successfully installed SQL developer , can u share informatica file

  • @rajatkumar5374
    @rajatkumar5374 2 ปีที่แล้ว +2

    Hm isme ye kaise pta karege ki Name, Username aur Password kya h??????

    • @DBACave
      @DBACave  2 ปีที่แล้ว

      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.

    • @selimyurtyapan7722
      @selimyurtyapan7722 ปีที่แล้ว

      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

    • @DBACave
      @DBACave  ปีที่แล้ว

      @@selimyurtyapan7722 Sorry to hear this, Can you please check if oracle software is installed properly? If need U can ping me whatsapp +8801921105214

  • @XQUADRA1
    @XQUADRA1 2 ปีที่แล้ว +1

    works!

    • @DBACave
      @DBACave  2 ปีที่แล้ว

      Happy to hear! Thanks

  • @nishantpatil7628
    @nishantpatil7628 ปีที่แล้ว +1

    hii I have
    one problem can you resolve

    • @DBACave
      @DBACave  ปีที่แล้ว

      Please share your problem kindly

    • @nishantpatil7628
      @nishantpatil7628 ปีที่แล้ว

      in second connection you give username hr but what is pass you written..?

    • @DBACave
      @DBACave  ปีที่แล้ว

      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;

    • @nishantpatil7628
      @nishantpatil7628 ปีที่แล้ว

      Mera nahi ho raha hai error aa raha hai

    • @DBACave
      @DBACave  ปีที่แล้ว

      @@nishantpatil7628 so sad, keep trying

  • @mr.dunkindonuts1590
    @mr.dunkindonuts1590 ปีที่แล้ว +1

    It worked tsm!!

    • @DBACave
      @DBACave  ปีที่แล้ว

      Thanks for reach out DBA Cave

  • @farzana-filaa5808
    @farzana-filaa5808 2 ปีที่แล้ว +1

    What is the Password?

    • @DBACave
      @DBACave  2 ปีที่แล้ว

      During database installation we must set a password.

  • @rumanashereen1663
    @rumanashereen1663 ปีที่แล้ว +1

    what is the password

    • @DBACave
      @DBACave  ปีที่แล้ว

      You will need to give database user name and password for establish connection from SQL developer to database which you want.

  • @jilensahoo5696
    @jilensahoo5696 10 หลายเดือนก่อน

    What is the user - hr password

    • @DBACave
      @DBACave  10 หลายเดือนก่อน

      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;

  • @EusraEkram
    @EusraEkram 10 หลายเดือนก่อน +1

    Great

    • @DBACave
      @DBACave  10 หลายเดือนก่อน

      Thank you so much.

  • @HammadKhan-xi6rs
    @HammadKhan-xi6rs 2 ปีที่แล้ว

    I'm still facing some connection problem!

    • @DBACave
      @DBACave  2 ปีที่แล้ว

      Oh sorry to hear. What kind of issue you facing?

  • @nishantchawda406
    @nishantchawda406 2 ปีที่แล้ว

    Test failed ORA-28000 : The account is locked

    • @DBACave
      @DBACave  2 ปีที่แล้ว +1

      Please unlock your target user first... >> ALTER USER user_name ACCOUNT UNLOCK;

    • @nishantchawda406
      @nishantchawda406 2 ปีที่แล้ว +1

      @@DBACave thankyou will give it a try

  • @vaibhavpatle3117
    @vaibhavpatle3117 2 ปีที่แล้ว

    Not working

    • @DBACave
      @DBACave  2 ปีที่แล้ว

      😥Which issue are you facing?

    • @vaibhavpatle3117
      @vaibhavpatle3117 2 ปีที่แล้ว

      @@DBACave database collection page not at started

  • @apekshanaik5449
    @apekshanaik5449 2 ปีที่แล้ว

    I'm too facing issue.... Test-failed:oracle/jdbc/datasource/impl/OracleDAtaSource

    • @DBACave
      @DBACave  2 ปีที่แล้ว

      Sorry to hear, please let me know details kindly.

  • @bcassilhas
    @bcassilhas 2 ปีที่แล้ว

    I've installed on Ubuntu but the connections buttons doesn't appear.

    • @DBACave
      @DBACave  2 ปีที่แล้ว +1

      Sorry to hear, is problem still facing??

    • @bcassilhas
      @bcassilhas 2 ปีที่แล้ว

      @@DBACave Yes :(

  • @Asherox
    @Asherox ปีที่แล้ว

    'sqlplus' is not recognized as an internal or external command,
    operable program or batch file.

    • @DBACave
      @DBACave  ปีที่แล้ว

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

    • @evanft6178
      @evanft6178 ปีที่แล้ว

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

    • @attarsaba8552
      @attarsaba8552 ปีที่แล้ว +1

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

    • @DBACave
      @DBACave  ปีที่แล้ว +1

      @@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