| Connection Information [message #397585] |
Sun, 12 April 2009 22:55  |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
Hi all,
Can someone tell me what I need to put in the following fields
to get sql developer going ?
Hostname:
Port: 1521
SID:
or
Service Name:
I keep getting the error : Failure -lo exception: The Network Adapter could not establish the connection
|
|
|
|
|
|
| Re: Connection Information [message #397589 is a reply to message #397585] |
Sun, 12 April 2009 23:36  |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
I beleive I know what my sid is so let me refresh my question.
Can the hostname and sid be the same?
What would cause the error: Failure -lo exception: The Netword Adapter could not establish the connection
|
|
|
|
|
|
| Re: Connection Information [message #397602 is a reply to message #397589] |
Mon, 13 April 2009 00:15 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
I installed for the 1st time oracle 11g home edition.
I set my sid to default orcl. Looking at the tnsnames.ora file
it looks like my hostname is orcl as well. I try to log in through sql developer with userid: system and a password that I created during installation (which works for sql*plus).
When I enter orcl in the feilds for sid and hostname and also
using system as username and my password. I get the error:
Failure -lo exception: The Netword Adapter could not establish the connection
********Additional Info ***********
C:\Documents and Settings\John>lsnrctl stat
LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 13-APR-2009 02:06
:37
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1xx.1xx.x.xxx)(PORT=1521
)))
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
32-bit Windows Error: 60: Unknown error
[Updated on: Mon, 13 April 2009 01:16] Report message to a moderator |
|
|
|
|
|
| Re: Connection Information [message #398200 is a reply to message #397623] |
Wed, 15 April 2009 11:08 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
I corrected that information, but I am still getting the same error. However, I did notice something when I opened my pc.
A dos screen came up with the following:
OC4J Configuration issue. C:\app\John\product\11.1.0\db_1/oc4j/j2ee/OC4J_DBConsole_MICHELINEPC_orcl not found.
OC4J Configuration issue. C:\app\John\product\11.1.0\db_1/oc4j/j2ee/OC4J_DBConsole_MICHELINEPC_orcl not found.
We have 3 users on the pc.
I did the install using user John but the owner of the pc
is under name MICHELINEPC
Could that be the problem ?
|
|
|
|
|
|
|
|
| Re: Connection Information [message #398573 is a reply to message #397585] |
Thu, 16 April 2009 14:55 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
Is more than 1 Oracle s/w product installed on this system?
What is OS name & version? 32 or 64 bit OS?
Open command window & issue following command:
SET
Now CUT & PASTE results back here.
Which OS user owns the Oracle RDBMS software tree?
When logged in as Oracle s/w owner do:
lsnrctl status
lsnrctl start
lsnrctl status
Not CUT & PASTE all results from 3 commands above.
[Updated on: Thu, 16 April 2009 15:25] Report message to a moderator |
|
|
|
| Re: Connection Information [message #398582 is a reply to message #398573] |
Thu, 16 April 2009 15:55 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
At one point I did an install and I could not get the OEM to run, so I uninstalled and installed again. It is posible that the install did not do a good clean. I am not sure.
C:\Documents and Settings\John>SET
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\John\Application Data
CLASSPATH=.;C:\Program Files\Java\jre1.5.0_02\lib\ext\QTJava.zip
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=MICHELINEPC
ComSpec=C:\WINDOWS\system32\cmd.exe
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\John
LOGONSERVER=\\MICHELINEPC
NUMBER_OF_PROCESSORS=1
OS=Windows_NT
Path=C:\Perl\site\bin;C:\Perl\bin;C:\app\John\product\11.1.0\db_1\bin;C:\WINDOWS
\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\ATI Technologies\
ATI Control Panel;C:\Program Files\QuickTime\QTSystem\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 36 Stepping 2, AuthenticAMD
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=2402
ProgramFiles=C:\Program Files
PROMPT=$P$G
QTJAVA=C:\Program Files\Java\jre1.5.0_02\lib\ext\QTJava.zip
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\John\LOCALS~1\Temp
TMP=C:\DOCUME~1\John\LOCALS~1\Temp
USERDOMAIN=MICHELINEPC
USERNAME=John
USERPROFILE=C:\Documents and Settings\John
windir=C:\WINDOWS
C:\Documents and Settings\John>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 16-APR-2009 16:47
:02
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1xx.xxx.1.xxx)(PORT=1521
)))
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
32-bit Windows Error: 60: Unknown error
C:\Documents and Settings\John>lsnrctl start
LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 16-APR-2009 16:49
:20
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Production
System parameter file is C:\app\John\product\11.1.0\db_1\network\admin\listener.
ora
Log messages written to c:\app\john\diag\tnslsnr\MICHELINEPC\listener\alert\log.
xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521
ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1xx.xxx.1.xxx)(POR
T=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 49: Unknown error
Listener failed to start. See the error message(s) above...
C:\Documents and Settings\John>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 16-APR-2009 16:51
:24
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1xx.xxx.1.xxx)(PORT=1521
)))
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
32-bit Windows Error: 60: Unknown error
|
|
|
|
|
|
| Re: Connection Information [message #398932 is a reply to message #398583] |
Sun, 19 April 2009 21:27 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
After setting the ORACLE_HOME and ORACLE_SID I was still getting the problem. I think that the installation was all wrong and corrupted so I uninstalled and I will be starting over. If I can get a moderator to remove this thread.
Thanks to all of you that helped in trying to get the problem resolved.
|
|
|
|
| Re: Connection Information [message #400077 is a reply to message #398932] |
Sat, 25 April 2009 15:21 |
jxh461
Messages: 185
Registered: March 2005
|
Senior Member |
|
|
I would like to share with you guys what I did to make it work.
Basically I decided to uninstall are reinstall. Near the end of my install I was prompted to chose to use the default parameter of a previous install or use new ones. I chose new ones. And it worked, at least once. Now I have other issue which I will address in another thread.
Thanks to all.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
