Oracle SQL Developer Installation in Linux | Karan Rajpoot

                                      Steps to Install Oracle SQL Developer 


Step 1) You need to download the SQL developer rpm and java development kit rpm of the version as per your requirement.

Links to download rpm's: -



Step 2) Login to your Linux Machine and install both the rpm's.

[root@dr sf_Oracle_DBA_Softwares]# rpm -ivh sqldeveloper-18.4.0-376.1900.noarch.rpm
Preparing...                ########################################### [100%]
   1:sqldeveloper           ########################################### [100%]
[root@dr sf_Oracle_DBA_Softwares]# 


[root@dr sf_Oracle_DBA_Softwares]# rpm -ivh jdk-8u201-linux-x64.rpm
warning: jdk-8u201-linux-x64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:jdk1.8                 ########################################### [100%]
Unpacking JAR files...
tools.jar...
plugin.jar...
javaws.jar...
deploy.jar...
rt.jar...
jsse.jar...
charsets.jar...
localedata.jar...
[root@dr sf_Oracle_DBA_Softwares]# 

Step 3) Now find the java home path through below command.

To check the java home path execute the command: - namei  /usr/bin/java

Output: -
[root@dr sf_Oracle_DBA_Softwares]# namei  /usr/bin/java
f: /usr/bin/java
 d /
 d usr
 d bin
 l java -> /etc/alternatives/java
   d /
   d etc
   d alternatives
   l java -> /usr/java/jdk1.8.0_201-amd64/jre/bin/java
     d /
     d usr
     d java
     d jdk1.8.0_201-amd64
     d jre
     d bin
     - java
[root@dr sf_Oracle_DBA_Softwares]# 

In my case java home is /usr/java/jdk1.8.0_201-amd64

Step 4) Now execute the sqldeveloper command and provide the path of the java home.

Java Home
Java Home
Oracle SQL Welcome Page
Oracle SQL Welcome Page

Note: - Sometimes while executing the sqldeveloper command, you will face below issue.

Issue: -

[root@dr sf_Oracle_DBA_Softwares]# sqldeveloper
Oracle SQL Developer Copyright (c) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
Exception in thread "main" java.lang.UnsupportedClassVersionError: oracle/dbtools/raptor/startup/HomeSupport : Unsupported major.minor version 52.0 at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:800) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) at java.net.URLClassLoader.defineClass(URLClassLoader.java:449) at java.net.URLClassLoader.access$100(URLClassLoader.java:71) at java.net.URLClassLoader$1.run(URLClassLoader.java:361) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:425) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:358) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:274) at java.util.ServiceLoader$LazyIterator.next(ServiceLoader.java:363) at java.util.ServiceLoader$1.next(ServiceLoader.java:445) at oracle.ide.osgi.boot.LauncherUtil.processOJStartupHook(LauncherUtil.java:356) at oracle.ide.osgi.boot.LauncherUtil.initialize(LauncherUtil.java:101) at oracle.ide.osgi.boot.OracleIdeLauncher.main(OracleIdeLauncher.java:80)

Cause: - The java development kit which you have installed is not matched with the current SQL developer version.

Solution: - Install the java development kit version as same as your SQL developer version. I have provided the above links to download both the rpm's.

If this blog is helpful please like, share and comment.

Thank you!!


Comments

Post a Comment

Popular posts from this blog

How to do "Multiplexing of Control Files" through spfile ( server parameter file) in Oracle 11g

Image
Step 1)  To perform "Multiplexing of Control Files" through spfile ( server parameter file)" first we need to create spfile from pfile. Example to create spfile from pfile: -                                       Step 2) Copy the control files in physical location from 'cp' command. Note: - At present, I have 2 control files,  I will add one more Control files in the same location. Example: -  Now you can see from above output control04.ctl file has been physically added successfully under /u01/app/oracle/oradata/prod/control04.ctl location. Step 3)  Now you need to set the same through alter command. a)  first shut down the database                                          b)  Startup (Start the database through spfile) ...
Read more

How to Add, Resize, Drop and Rename of a datafile in Tablespace

Image
                                       How to Add, Resize, Drop and Rename a datafile in Tablespace In order to create a data file first, need to create a tablespace, To know how to create a tablespace  Click here To demonstrate, I will use USERS tablespace to Add,  Resize, Drop and Rename a data file. First, we can check how many data files are present under USERS tablespace through below command. Command: - select name from v$datafile; We can see from above output only a single data file is present under USERS tablespace. Addition of Datafile: - Command to add a datafile: - alter tablespace users add datafile '/u01/app/oracle/oradata/prod/users02.dbf' size 50m; The new data file has been added to my USERS tablespace. Resize of a Datafile: - Command to resize the datafile: - alter database datafile '/u01/app/oracle/oradata/prod/users02...
Read more

Oracle "Redo log Groups addition/deletion" | Karan Rajpoot

Image
                    Oracle "Redo log Groups addition/deletion" Step 1) To add redo log group first we will check the log groups, members details, location, and size. Example: - From the above output, we can see we have 3 groups and inside every group, we have 1 member each of size 50 MB and the location is /u01/app/oracle/oradata/karan/ Step 2) Now we will add one group and check the status of that group. Example: - Now again we can check the details of log groups and member. Now the 4th group and a member of 50 MB has been added successfully. Step 3) Now I will add one more member to the 4th log group. Example: - We can see from the above output that in group 4, now 2 members are there. Steps to drop the latest added group and member Note: - We cannot drop CURRENT members as shown in the above output, So I will add a new member in group 3 and then I will drop th...
Read more