Oracle SQL Developer 19.4 Installation on Ubuntu 16.04 LTS and connect Oracle Database 19c
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
Thank you !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Where u find your hostname ????
friend to connect Oracle Database 19c
I had to install oracle database 19c can you explain me please
Thanks
Bro please make a video on sqlplus instant client.
How to install oracle jdk 8?
Plz give link of setup download
From where you got the password and IP
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
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
@@javafrm what does the second command do?
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.
Did you find how to create connection
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
how to get username and password please help while creating new database connection
same problem here
I don't have permission to extract . What should I do?
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)