Oracle SQL Developer 19.4 Installation on Ubuntu 16.04 LTS and connect Oracle Database 19c

Sdílet
Vložit
  • čas přidán 7. 02. 2020
  • In this video we are going to see how to install SQL Developer 19.4 on Ubuntu 16.04 LTS using Oracle JDK 8 and connect Oracle Database 19c Enterprise Edition.
    Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, edit and debug PL/SQL statements, manipulate and export data, and view and create reports. You can connect to Oracle databases, and you can connect to selected third-party (non-Oracle) databases, view metadata and data, and migrate these databases to Oracle.
    SQL Developer also integrates interfaces into several related technologies, including Oracle Data Miner, Oracle OLAP, Oracle TimesTen In-Memory Database, and SQL Developer Data Modeler (read-only).
    SQL Developer can be obtained from the below link.
    www.oracle.com/tools/download...
    Feature Enhancements
    ORDS installer supports:
    REST SQL and SQL Developer Web configuration
    Custom JDBC urls and TNS
    Allows non-SYSDBA user to install/upgrade, repair and uninstall ORDS
    Bundled SQLcl now includes liquibase features
    Include Orakafka ZIP in all distributions
    Java Home updated to 8u221
    Oracle NoSQL plugin updated to version 19.3.12
    Database Copy added 'Ignore Storage' to avoid tablespace dependencies
    Data Pump Wizard now supports encrypted DMP files
    SQL Editor Code template options panel moved to code editor page
    Code formatter new setting for number of commas to allow before a linebreak on PL/SQL call
    Added SET CODESCAN to look for SQL Injection vulnerabilities
    TABLE IMPORT enhanced to ignore virtual columns
    JDK Support
    Oracle SQL Developer 19.4 release requires Oracle Java 8 or 11/12/13, with a minimum version of 1.8 update 121.
  • Věda a technologie

Komentáře • 18

  • @arthurchazelle9071
    @arthurchazelle9071 Před 3 lety

    Thank you !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  • @hugobrenet864
    @hugobrenet864 Před 3 lety +5

    Where u find your hostname ????

  • @jairoduai
    @jairoduai Před 4 lety

    friend to connect Oracle Database 19c
    I had to install oracle database 19c can you explain me please

  • @salonikhandelwal936
    @salonikhandelwal936 Před 2 lety

    Thanks

  • @vikassoni4166
    @vikassoni4166 Před 3 lety +1

    Bro please make a video on sqlplus instant client.

  • @yasink18
    @yasink18 Před 3 lety

    How to install oracle jdk 8?

  • @ritikshandilya7075
    @ritikshandilya7075 Před 3 lety

    Plz give link of setup download

  • @deveshsharma2345
    @deveshsharma2345 Před 4 měsíci

    From where you got the password and IP

  • @shilpashreear2443
    @shilpashreear2443 Před 4 lety

    Sir..i didn't create any user for this I'm trying to Install on the default user but i don't know how to give the permission for this user so plz tell me how to continue further

    • @javafrm
      @javafrm  Před 4 lety

      Hi shilpa,
      execute the below commands as root user
      1. chmod -R 777 /opt/sqldeveloper
      this will give full permission to the directory.
      2. chown username:username -R /opt/sqldeveloper

    • @Kennerdoll
      @Kennerdoll Před rokem

      @@javafrm what does the second command do?

  • @GunjaDave-xq7hv
    @GunjaDave-xq7hv Před 2 měsíci

    how to find username and password, it was supposed to enter during installation but in ubuntu we install it through terminal, so there was no option for username and password. now i am having problem in creating connection.

    • @SravankumarGatla
      @SravankumarGatla Před 2 měsíci

      Did you find how to create connection

    • @deveshsharma2345
      @deveshsharma2345 Před 7 dny

      even I am facing the same problem. Did not got any videos where they can share this information on how to get username and password

  • @gouravsuram
    @gouravsuram Před 3 lety +1

    how to get username and password please help while creating new database connection

  • @techinnovation7457
    @techinnovation7457 Před 3 lety

    I don't have permission to extract . What should I do?

    • @aizazzaheen
      @aizazzaheen Před 3 lety

      first make your ujser Administratior from setting
      or you can just extract it in the downloads and then
      try in command line these codes
      sudo mv -r (traget folder ) (destination folder)