• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1550
  • Last Modified:

Launch sqlplus from JDeveloper

When i goto Tools and click sqlplus after selecting my connection , Iam not able to launch my sqlplus window. I see a flicker of dos window and it dies quickly?

Any ideas?
0
shasta123
Asked:
shasta123
  • 6
  • 4
  • 2
  • +2
1 Solution
 
ggridleyCommented:
Can you try this?  

Right Click on the connection and select Edit, go to the test tab, and test the connection.
0
 
paquicubaCommented:
Go to:
           Tools --> Preferences --> Database Connections --> SQL*Plus Executable:  --> Make sure the path is correct

           i.e. C:\oracle\product\10.2.0\db_1\BIN\sqlplus.exe OR C:\oracle\product\10.2.0\db_1\BIN\sqlplusw.exe
                                                                          ^                                                                          ^
                                                         Command Line                                                                 GUI version
                 
                   
0
 
shasta123Author Commented:
i can see the tables and stuff under my connections and listener names.
I have also verified the sqlplus.exe path.
BUt right click and select sqlplus is still not launching the window.
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
shasta123Author Commented:
BTW, test connection was success too.
0
 
paquicubaCommented:
Which on are you using: sqlplus.exe or sqlplusw.exe ?
0
 
mohammadzahidCommented:
Here are few places you can check:

After connecting to the database goto Tools > enter path of sqlplus, click ok.
OR you can add path of sqlxxx.exe in database connections in preferences under Tools.  

* sqlplus.exe with open session to the database in DOS window.
* sqlplusw.exe will launch SQL Plus and prompt you to enter password.

I would check path to make sure oracle_home is defined correctly.
0
 
shasta123Author Commented:
oracle_home is fine thats why it picked my sqlplus.exe under ORACLE_HOME/bin/sqlplus.exe automatically.
I can launch sqplus worksheet which opens terminal in Jdeveloper itself.
0
 
shasta123Author Commented:
All my driver class paths etc are empty under TOOls preferences?
0
 
mohammadzahidCommented:
You don't need anything defined in class paths. All you need is to make sure correct sqlplus executable is defined in database connection in perferences.
On my system I have in SQL Plus executable defined as :  D:\Oracle\Ora92\bin\sqlplusw.exe

0
 
shasta123Author Commented:
It looks like opening a DOS window session, but with a flicker it is dies out immediately
0
 
mohammadzahidCommented:
are you using sqlplus.exe or sqlplusw.exe?
0
 
shasta123Author Commented:
sqlplus.exe
0
 
mohammadzahidCommented:
Do you have sqlplusw.exe on your system?
If yes, then try using sqlplusw.exe instead of sqlplus.exe
 
0
 
ggridleyCommented:
shasta123 confirmed that sqlplus was opening in DOS and mohammadshahid gave a good recommendation to use sqlplusw.exe instead, I think mohammadzahid should get it.
0
 
derosaCommented:
What if you run as administrator?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 4
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now