Home » RDBMS Server » Networking and Gateways » Connection Information (Windows server Oracle 11g)
Connection Information [message #397585] Sun, 12 April 2009 22:55 Go to next message
jxh461
Messages: 177
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 #397586 is a reply to message #397585] Sun, 12 April 2009 22:58 Go to previous messageGo to next message
BlackSwan
Messages: 22780
Registered: January 2009
Senior Member
jxh461,

Sorry but I no longer can read minds & my crystal ball is broken.

It is YOUR system & YOU are the only one who knows what SID you created.

Why do you honestly expect us to know what you have done on your system?????

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Re: Connection Information [message #397589 is a reply to message #397585] Sun, 12 April 2009 23:36 Go to previous messageGo to next message
jxh461
Messages: 177
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 #397591 is a reply to message #397585] Sun, 12 April 2009 23:39 Go to previous messageGo to next message
BlackSwan
Messages: 22780
Registered: January 2009
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Re: Connection Information [message #397602 is a reply to message #397589] Mon, 13 April 2009 00:15 Go to previous messageGo to next message
jxh461
Messages: 177
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 #397623 is a reply to message #397602] Mon, 13 April 2009 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 59076
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
it looks like my hostname is orcl as well

Quote:
HOST=1xx.1xx.x.xxx

Something wrong in what you posted.

By the way, you don't need net services and listener to locally connect, just set ORACLE_HOME and ORACLE_SID environment variables.

Regards
Michel
Re: Connection Information [message #398200 is a reply to message #397623] Wed, 15 April 2009 11:08 Go to previous messageGo to next message
jxh461
Messages: 177
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 #398206 is a reply to message #398200] Wed, 15 April 2009 12:23 Go to previous messageGo to next message
babuknb
Messages: 1731
Registered: December 2005
Location: NJ
Senior Member

>>I corrected that information

Thanks for the feedback. Please explain us what you tried.

>C:\app\John\product\11.1.0\db_1/oc4j/j2ee/OC4J_DBConsole_MICHELINEPC_orcl not found

Here "John" is a folder. You may need to give OS level permission.

Did you configured OEM Database Console??

Babu
Re: Connection Information [message #398564 is a reply to message #398206] Thu, 16 April 2009 14:37 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
I used ip address for host name
and orcl for sid.

I opened the permissions to the folder.

I am still getting the same error.

There is no OEM configured.
Re: Connection Information [message #398573 is a reply to message #397585] Thu, 16 April 2009 14:55 Go to previous messageGo to next message
BlackSwan
Messages: 22780
Registered: January 2009
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 Go to previous messageGo to next message
jxh461
Messages: 177
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 #398583 is a reply to message #397585] Thu, 16 April 2009 16:51 Go to previous messageGo to next message
BlackSwan
Messages: 22780
Registered: January 2009
Senior Member
Please note that neither ORACLE_HOME nor ORACLE_SID are defined.
Re: Connection Information [message #398932 is a reply to message #398583] Sun, 19 April 2009 21:27 Go to previous messageGo to next message
jxh461
Messages: 177
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 Go to previous message
jxh461
Messages: 177
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.
Previous Topic: SHARED SERVER MODE: connection refused
Next Topic: failing to configure dbconsole after installing 11g
Goto Forum:
  


Current Time: Tue Sep 16 03:00:38 CDT 2014

Total time taken to generate the page: 0.14138 seconds