UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Installing Oracle Gui    
 
   
duggie
post Jul 24 2018, 11:56 AM
Post#1



Posts: 474
Joined: 14-October 12



I've followed these instructions to install Oracle on my PC:

CODE
https://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#XEINW136


It has been successfully installed but when I start it via All Programs, all I get is a black screen, similar to a Command Prompt.

What I expected to see was a screen like SQL Server Management Studio.

Does Oracle have such a GUI and if so, how do I get that installed?

Thanks


Go to the top of the page
 
cheekybuddha
post Jul 24 2018, 12:32 PM
Post#2


UtterAccess VIP
Posts: 11,487
Joined: 6-December 03
From: Telegraph Hill


Looks like you installed a command line interface. How's your SQL? wink.gif

You could try dbeaver, a free GUI that interfaces with many flavours of database server.

You will need to install the relevant ODBC drivers for Oracle, but I think that is handled from within dbeaver.

hth,

d
Go to the top of the page
 
duggie
post Jul 24 2018, 12:49 PM
Post#3



Posts: 474
Joined: 14-October 12



Thanks

Found this link:

CODE
https://www.linkedin.com/pulse/free-gui-management-tools-oracle-db-sajjad-amiri


and managed to install a GUI.

I'm totally new to this so what's preferable, Command Prompt (ie black screen) or GUI?

Is this similar to asking DOS v Windows?

Also I expected to be able to find this new GUI under All Programs but I can't.

Instead, to launch it, every time I have to navigate to the .exe and double click on that. Is that the norm?


This post has been edited by duggie: Jul 24 2018, 12:58 PM
Go to the top of the page
 
BruceM
post Jul 24 2018, 01:55 PM
Post#4


UtterAccess VIP
Posts: 7,963
Joined: 24-May 10
From: Downeast Maine


How to start the program from All Programs (or in any of several other ways) depends in part on your OS. What OS are you using?
Go to the top of the page
 
cheekybuddha
post Jul 24 2018, 04:15 PM
Post#5


UtterAccess VIP
Posts: 11,487
Joined: 6-December 03
From: Telegraph Hill


>> so what's preferable, Command Prompt (ie black screen) or GUI? <<

The answer to that is "whatever works best for you"!

If you're comfortable administering databases in SQL then you might find it more efficient to use the command line.

If you like something visual, then I guess the GUI is the way to go.

I use both, and also more often just a text editor!

thumbup.gif

d
Go to the top of the page
 
duggie
post Jul 24 2018, 04:32 PM
Post#6



Posts: 474
Joined: 14-October 12



I prefer GUI.

My OS is windows 10.


This post has been edited by duggie: Jul 24 2018, 04:35 PM
Go to the top of the page
 
duggie
post Jul 24 2018, 04:34 PM
Post#7



Posts: 474
Joined: 14-October 12



Furthermore, what's the most efficient way to extract the results (either from the black screen or the GUI), so I can analyse it, in Excel?
This post has been edited by duggie: Jul 24 2018, 04:37 PM
Go to the top of the page
 
cheekybuddha
post Jul 24 2018, 05:45 PM
Post#8


UtterAccess VIP
Posts: 11,487
Joined: 6-December 03
From: Telegraph Hill


I'm not familiar with any of the GUI's you linked to except SquirrelSQL which I never really got along with!

Most GUI's tend to have some sort of export resultset to file feature, at least to CSV format if not native Excel, which can be opened in Excel. DBeaver certainly has.

Or you could install the Oracle ODBC driver and connect from Access - and analyse it there, or export to Excel from there.

I don't have any direct experience connecting to Oracle db's, so maybe others who have will chime in with their suggestions.

hth,

d
Go to the top of the page
 
duggie
post Jul 24 2018, 05:56 PM
Post#9



Posts: 474
Joined: 14-October 12



Thanks

Go to the top of the page
 
BruceM
post Jul 25 2018, 06:24 AM
Post#10


UtterAccess VIP
Posts: 7,963
Joined: 24-May 10
From: Downeast Maine


To have a shortcut appear on your Start menu, place the shortcut into C:\Users\UserName\AppData\Roaming\Microsoft\Windows\Start Menu

From there you can right click it in the list and choose Pin to Start, if you wish.
Go to the top of the page
 
duggie
post Jul 26 2018, 02:06 AM
Post#11



Posts: 474
Joined: 14-October 12



When you say the shortcut, do you mean the sqldeveloper.exe file?

Go to the top of the page
 
BruceM
post Jul 26 2018, 07:03 AM
Post#12


UtterAccess VIP
Posts: 7,963
Joined: 24-May 10
From: Downeast Maine


Yes. Create a shortcut in the Start Menu folder to the file you double click to start the program.
Go to the top of the page
 
duggie
post Jul 29 2018, 04:21 AM
Post#13



Posts: 474
Joined: 14-October 12



Thanks

Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    23rd September 2019 - 04:09 AM