3 Replies Latest reply on Jun 12, 2019 9:16 PM by 792311

    sqldeveloper in oracle 19.3c

    792311
    792311 Jun 12, 2019 2:36 PM

      OS: Oracle Linux 7.6

      Oracle DB: 19.3c

      Virtual Box

       

      Question:  In Oracle 18c sqldeveloper useed to come pre-installed. I used to be able to start it by going to --> Oracle_Home--> sqldeveloper-->sqldeveloper--->bin--> ./sqldeveloper. 

                        In 19c, I doin't see ./sqldeveloper in bin, instead I am seeing the following 3 files:

       

                         README.md, sql, sql.exe

       

                      Any idea how I can start sqldeveloper?  I tried ./sql.exe  but I keep getting permission denied error, the owner is oracle:oinstall, and I am logged in as oracle.

       

            Thanks for your help.

      • 601 Views
      • Tags:
        • 1. Re: sqldeveloper in oracle 19.3c
          thatJeffSmith-Oracle
          thatJeffSmith-Oracle Jun 12, 2019 5:52 PM (in response to 792311)

          We no longer ship SQL Developer with the database media, because:

          1. it's big
          2. we update it every 3 months
          3. most people already have sql developer

           

          So if you want to run it on the database server, you'll need to go to oracle.com/sqldeveloper, and download the right package

           

          The SQL binary you see there is for SQLcl.

          • 2. Re: sqldeveloper in oracle 19.3c
            792311
            792311 Jun 12, 2019 6:43 PM (in response to thatJeffSmith-Oracle)

            Jeff,

             

            Thanks for your kind reply and for your help.

            • 3. Re: sqldeveloper in oracle 19.3c
              792311
              792311 Jun 12, 2019 9:16 PM (in response to thatJeffSmith-Oracle)

              Jeff,

               

              I just watched your excellent youtube video on Oracle SQLcl Demonstration. You provided great details; this is what I understood: we can download SQLCl  and install on our pc/laptop and next we can connect to our oracle database without going through sqlplus or sql developer.  So why do we have sql.exe for SQLcl binary provided in oracle bin directory?  Are we able to use SQLcl while logged in to Oracle instead of using sqlplus? For example, if I am in my /u01 or in $ORACLE_HOME directory, can I use SQLcl ?

               

              I want to use SQLcl, but I only have virtualbox for testing, and I have access to RAC but that is on 11.2.0.3.0 on RHEL.

               

              Thanks.