user11934091 wrote:Helped a co-worker through this just yesterday. Brand new installation of XE allowed SQL*PLUS connection but SQL*Devleoper choked with the mesasge you cited. Web searches yielded 3 different forums suggesting removing (we renamed) the listener.ora file. We also had to bounce the listener. This was make more <sarcasm>fun</sarcasm> by Windows 7 refusing to let us edit LISTENER.ORA and TNSNAMES.ORA (we had to let the login user work with the file under properties/security for the network folder) AND refusing to let us shut down the listener (through command-line lsnrctl and the Services interface). We rebooted.
I am trying to create a new connection using SQL Developer and I am constantly getting bogged down with an error and the error is:
Status : Failure -Test failed: The Network Adapter could not establish the connection.
Brief background is :
a. Brand new machine from Dell and installed windows 7 profession 64 bit
b. Installed successfully Oracle 11g - Release 126.96.36.199.0
c. SQL Developer version - 3.2.20.09
c. Able to connect to sys and scott from SQL Plus but not through SQL Developer
d. Listener in running state and seems to be working properly