Home » SQL & PL/SQL » Client Tools » Oracle SQL Developer (Oracle 11.1.0. - Windows XP)
Oracle SQL Developer [message #525392] Sun, 02 October 2011 04:38 Go to next message
GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur
Member
OracleDBConsole service gives the below error message when starting.

"Windows could not start the OracleDBConsoleoracl on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 2."

I made a copy of the folder "OC4J_DBConsole_localhost_oracl" which is in the location D:\app\Ganesh\product\11.1.0\db_1\oc4j\j2ee and resolved it.

But now the Oracle SQL Developer is not get connected. I received the below message

"The Network Adapter could not establish the connection"

Solution please.

[Updated on: Sun, 02 October 2011 08:26]

Report message to a moderator

Re: Oracle SQL Developer [message #525407 is a reply to message #525392] Sun, 02 October 2011 10:19 Go to previous messageGo to next message
BlackSwan
Messages: 26207
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

are both Operating System Services for both Listener & DB started?

open Command Window & issue following OS commands

lsnrctl status
lsnrctl service

COPY commands & results then PASTE all back here
Re: Oracle SQL Developer [message #525409 is a reply to message #525407] Sun, 02 October 2011 11:40 Go to previous messageGo to next message
GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur
Member
Thanks for replying.

Here are the results of the command

C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 02-OCT-2011 21:59:51

Copyright (c) 1991, 2008, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production
Start Date 02-OCT-2011 21:55:23
Uptime 0 days 0 hr. 4 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\Ganesh\product\11.1.0\db_1\network\admin\listener.ora
Listener Log File d:\app\ganesh\diag\tnslsnr\sys1\listener\alert\log.xml

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
The listener supports no services
The command completed successfully


C:\>lsnrctl service

LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 02-OCT-2011 22:01:30

Copyright (c) 1991, 2008, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

[Updated on: Sun, 02 October 2011 11:46]

Report message to a moderator

Re: Oracle SQL Developer [message #525410 is a reply to message #525409] Sun, 02 October 2011 12:01 Go to previous messageGo to next message
BlackSwan
Messages: 26207
Registered: January 2009
Location: SoCal
Senior Member
>Uptime 0 days 0 hr. 4 min. 28 sec
>The listener supports no services
then no DB has been started
Re: Oracle SQL Developer [message #525412 is a reply to message #525410] Sun, 02 October 2011 12:45 Go to previous messageGo to next message
GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur
Member
Hi Swan,

>The listener supports no services
then no DB has been started

But it works fine with sqlplus.
What the actual problem is. Help me to resolve.
Re: Oracle SQL Developer [message #525413 is a reply to message #525412] Sun, 02 October 2011 12:51 Go to previous messageGo to next message
BlackSwan
Messages: 26207
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

>But it works fine with sqlplus.
post COPY & PASTE proof showing SQL*Net connection succeeds

>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
no remote client can ever connect to listener/DB
Re: Oracle SQL Developer [message #525414 is a reply to message #525413] Sun, 02 October 2011 13:31 Go to previous messageGo to next message
GaneshAnanth
Messages: 34
Registered: January 2011
Location: Thanjavur
Member
Here I have attached a scren shot of SQL prompt.

It shows results for some commands.


Re: Oracle SQL Developer [message #525415 is a reply to message #525414] Sun, 02 October 2011 13:45 Go to previous message
BlackSwan
Messages: 26207
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Previous Topic: third party tool to migrate Oracle to Mysql
Next Topic: Oracle Client
Goto Forum:
  


Current Time: Mon Oct 22 11:07:28 CDT 2018