If anyone could help or give me some advice it would be much appreciated. I have scoured most related questions here and the Oracle Documentation but seem to have either found nothing related missed a step during install and config. Oracle SQL Developer Users Guide for more information about creating, editing, exporting, and importing database connections. I was wondering if anyone could shed some light on what I might have missed or which setting to use, and of course if I need to do anything in SQL Plus or if it just needs to be there? I did have this running a few years ago but have not used it and forgotten the procedure for a local connection. I know it was the simplest set up possible, this is all I need enough to build tables and run queries, and it definitely didn't cause this much grief back then when I knew a lot less. Which connection type do I Use?, in the past I know I had no virtual server, VM or anything of the like but just cannot remember. If yes what is the default password I should use to actual get to the SQL> prompt? I believe the main issue is not knowing the exact (or default) username and password to use for the new connection or what exact method to use (Local, Local Bequeth,TNS, etc).ĭo I need to get access and setup a database at the command line with SQL plus?, or does SQL Developer just source the files that it contains. I either get an I/O error : the network adapter is unable to set up a connection or Tns is not resolved error depending on what type of connection I try. The port in tnsnames.ora and listener.ora is set to 1521 which is what I am trying to set up in the Developer connection. I have shown Developer the path to Oracle Instant Client and checked the box to use it to use (Tools -> Preferences -> Database -> Advanced), I have tested this and it works. SQL Plus is working from the command line but I have no username or password so cannot login. Enter the following information: Connection Name - Enter the name for this cloud. The New/Select Database Connection dialog appears. In the Connections panel, right-click Connections and select New Connection. I have some SQL files ready to go but cannot make a connection via localhost so cannot run any commands inside developer. Define a SQL Developer Connection Open SQL Developer on your local computer. I have installed Oracle JAVA 8, SQL Developer 4.1.5 and SQL client 11.2 with SQL plus 11.2.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |