Home » Infrastructure » Windows » ORACLEDB CONSOLE SERVICES (merged)
ORACLEDB CONSOLE SERVICES (merged) [message #291906] Mon, 07 January 2008 03:16 Go to next message
SGHIT
Messages: 2
Registered: January 2008
Junior Member
Hi to everybody,

I had installed the database 10g in my laptop and it is running fine whenever I am connected in our office local area network (LAN) but i found out that whenever I am disconnected from the LAN, the oracle database console (OraDBConsole______) services in WinXP SP 2 is not starting whenever I am restarting OS which the developer forms (Forms 6i) runtime is also not running whenever this OraDBConsole services is stopped. I need any solution of running the OraDBConsole services away from the LAN or disconnected from the LAN so that I can use my laptop even it is detach from our LAN, thank you in advance.


Re: ORACLEDB CONSOLE SERVICES [message #291932 is a reply to message #291906] Mon, 07 January 2008 04:59 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Is you laptop set up with DHCP? If so, check Installing Oracle Database on DHCP Computers.
icon4.gif  Re: ORACLEDB CONSOLE SERVICES [message #291947 is a reply to message #291906] Mon, 07 January 2008 05:24 Go to previous messageGo to next message
data_viper
Messages: 11
Registered: December 2007
Location: UK
Junior Member

Hi there...
I kinda facing now the same problem but with the difference that I had no problem with that service earlier. I can log on to sql console to do what ever I want, But the damn console service refuses to start lately. I did'nt change anything with my settings. The error message displays:


Error 1053: The service did not repond to the start or control request in a timely fasion.
Re: ORACLEDB CONSOLE SERVICES [message #291954 is a reply to message #291947] Mon, 07 January 2008 05:30 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
data_viper wrote on Mon, 07 January 2008 06:24


Error 1053: The service did not repond to the start or control request in a timely fasion.


But does the database eventually start? You'll sometimes encounter this on Windows, but you'll notice the database starts fine within a few seconds.

You'll notice that if you click OK to that message, the service's status should show "Starting". If you refresh the services pane after a few moments, the status should show "Started".

[Updated on: Mon, 07 January 2008 05:32]

Report message to a moderator

icon2.gif  Error 1053: The service did not repond [message #291957 is a reply to message #291906] Mon, 07 January 2008 05:34 Go to previous messageGo to next message
data_viper
Messages: 11
Registered: December 2007
Location: UK
Junior Member

Hi there...
I had no problem with that console service earlier. But the damn console service just refuses to start lately. I did'nt change anything with my settings. The complete error message displays:


Error 1053: The service did not repond to the start or control request in a timely fasion.
Re: Error 1053: The service did not repond [message #291959 is a reply to message #291957] Mon, 07 January 2008 05:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't start a new topic, reply in the previous one.

Regards
Michel
Re: Error 1053: The service did not repond [message #291962 is a reply to message #291957] Mon, 07 January 2008 05:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try it several times successively.
It may just be before the service starts in a time just less the the time-out and in this case it is just more than it.

Have a look at event log.

Regards
Michel
Re: ORACLEDB CONSOLE SERVICES [message #291971 is a reply to message #291932] Mon, 07 January 2008 05:55 Go to previous messageGo to next message
SGHIT
Messages: 2
Registered: January 2008
Junior Member
thank you very much for the reply. It is both working on DHCP as well as on static IP address, anyhow I had tried Installing a Loopback Adapter on OS and it did re-start the service automatically but when I am trying to connect my Developer forms 6i i have this message ORA-12528: Message 12528 not found; product=RDMS80;facility =ORA . any configuration should i modify in the Oracle side?
Re: ORACLEDB CONSOLE SERVICES [message #291972 is a reply to message #291971] Mon, 07 January 2008 05:57 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
This might help:

12528, 00000, "TNS:listener: all appropriate instances are blocking new connections"
// *Cause:  All instances supporting the service requested by the client
// reported that they were blocking the new connections. This condition may be
// temporary, such as at instance startup.
// *Action: Attempt the connection again. If error persists, then contact the
// administrator to check the status of the instances
Re: ORACLEDB CONSOLE SERVICES [message #292004 is a reply to message #291954] Mon, 07 January 2008 07:25 Go to previous messageGo to next message
data_viper
Messages: 11
Registered: December 2007
Location: UK
Junior Member

Hi again...

I have no problem with the database, it's working just fine. but the deal is that I can't open the OEM, I figured that the console service is part of the problem!

Thx.
Re: ORACLEDB CONSOLE SERVICES [message #292011 is a reply to message #292004] Mon, 07 January 2008 07:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Have a look at event log (Control Panel/Administrative tools/Event viewer).

Regards
Michel
Re: ORACLEDB CONSOLE SERVICES [message #292037 is a reply to message #292004] Mon, 07 January 2008 09:20 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What do you mean when you say you can't open OEM?

Have you checked the OEM logs in %ORACLE_HOME%/<hostname_sid>/sysman/log directory ?
Re: ORACLEDB CONSOLE SERVICES [message #292236 is a reply to message #292011] Tue, 08 January 2008 04:38 Go to previous messageGo to next message
data_viper
Messages: 11
Registered: December 2007
Location: UK
Junior Member


Ok guys the log error in the event log displayed the following:

The OracleDBConsolehighlife service terminated with service-specific error 2 (0x2).

And I have no log records in the sysman\log directory!
Re: ORACLEDB CONSOLE SERVICES [message #292251 is a reply to message #292236] Tue, 08 January 2008 05:12 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You can try the following:

In the %ORACLE_HOME%\bin\LaunchEMiasconsole.pm file add -XX:+ForceTimeHighResolution to the front of the line that contains -XmxNNN. Then try to restart the Windows service.
Re: ORACLEDB CONSOLE SERVICES [message #292288 is a reply to message #292251] Tue, 08 January 2008 07:29 Go to previous messageGo to next message
data_viper
Messages: 11
Registered: December 2007
Location: UK
Junior Member

ebrian wrote on Tue, 08 January 2008 13:12

You can try the following:

In the %ORACLE_HOME%\bin\LaunchEMiasconsole.pm file add -XX:+ForceTimeHighResolution to the front of the line that contains -XmxNNN.


I was looking for the file U gave me and here are all the files I found:

DBConsole.pm
EMAgent.pm
IASConsole.pm
EMDeploy.pm
EmctlCommon.pm

So, which one is the one I'm after?

Thx
Re: ORACLEDB CONSOLE SERVICES [message #292291 is a reply to message #292288] Tue, 08 January 2008 08:00 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you tried to recreate the repository?

emca -config dbcontrol db -repos recreate
Re: ORACLEDB CONSOLE SERVICES [message #292562 is a reply to message #292291] Wed, 09 January 2008 03:53 Go to previous messageGo to next message
data_viper
Messages: 11
Registered: December 2007
Location: UK
Junior Member

I tried it, but first I think I have 2 drop the existing Repository, because I got this message:

SEVERE: Repository already exists. Fix the error(s) and run EM Configuration Assistant again in standalone mode.

Should I drop the Repository? How?

Thx
Re: ORACLEDB CONSOLE SERVICES [message #292587 is a reply to message #292562] Wed, 09 January 2008 05:00 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
To drop, use:

emca -deconfig dbcontrol db -repos drop
Re: ORACLEDB CONSOLE SERVICES [message #292590 is a reply to message #292587] Wed, 09 January 2008 05:24 Go to previous messageGo to next message
data_viper
Messages: 11
Registered: December 2007
Location: UK
Junior Member

Alright I got this, I'm I missing something?

C:\WINDOWS\system32>emca -deconfig dbcontrol db -repos drop
Incorrect usage:
oracle.sysman.emcp.EMConfigAssistant [options] [list of parameters]
Options:
-a :configure for an ASM database
-b :configure for automatic backup
-c :configure a cluster database
-d :run EMCA from within the development view
-e <node> :remove a node from the cluster
-f <file> :specify the file name that contains parameter values
-h :help
-m :configure for central mode
-n <node> :add a new node to the cluster
-r :skip creation of repository schema
-s :silent mode (no user prompts
-x <db> :deletion of a SID or DB

The script will prompt for any required data that is not specified in a configuration file. The scr
ipt always prompts for all required passwords. If you use a configuration file, the file may contai
n any of the following specifications, as shown, with the specified values correctly filled in:

Parameters for single instance databases:
Re: ORACLEDB CONSOLE SERVICES [message #292592 is a reply to message #292590] Wed, 09 January 2008 05:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I assume you are on 10.1 then. If that's the case, you need to use:

emca -x <sid>
%ORACLE_HOME%\sysman\admin\emdrep\bin\RepManager <hostname> <listener_port> <sid> -action drop
Re: ORACLEDB CONSOLE SERVICES [message #292618 is a reply to message #292592] Wed, 09 January 2008 07:09 Go to previous messageGo to next message
data_viper
Messages: 11
Registered: December 2007
Location: UK
Junior Member

I'm not sure if U meant to use the command line on one or two steps! but I tried them both anyway...

Here R the results:

C:\WINDOWS\system32>emca -x highlife

STARTED EMCA at Wed Jan 09 14:53:15 EET 2008
09/01/2008 02:53:15 ع oracle.sysman.emcp.EMConfig stopOMS
INFO: Stopping the DBConsole ...
Enterprise Manager configuration is completed successfully
FINISHED EMCA at Wed Jan 09 14:53:16 EET 2008


I figured 2 use the path also as specified:

C:\WINDOWS\system32>emca -x highlife E:\oracle\product\10.1.0\Db_3\sysman\admin\emdrep\bin\RepManager intruder 5500 highlife -action drop

Incorrect usage:
Re: ORACLEDB CONSOLE SERVICES [message #292634 is a reply to message #292618] Wed, 09 January 2008 08:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
In your case %ORACLE_HOME% is E:\oracle\product\10.1.0\Db_3. Therefore, the second command is simply:

E:\oracle\product\10.1.0\Db_3\sysman\admin\emdrep\bin\RepManager intruder 5500 highlife -action drop
Re: ORACLEDB CONSOLE SERVICES [message #292983 is a reply to message #292634] Thu, 10 January 2008 06:54 Go to previous messageGo to next message
data_viper
Messages: 11
Registered: December 2007
Location: UK
Junior Member

I'm sorry, but isn't this the same command line I already wrote?
Re: ORACLEDB CONSOLE SERVICES [message #293021 is a reply to message #292983] Thu, 10 January 2008 11:18 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Unless you mis-typed in your reply, they are different:

-- Yours --
C:\WINDOWS\system32>emca -x highlife E:\oracle\product\10.1.0\Db_3\sysman\admin\emdrep\bin\RepManager intruder 5500 highlife -action drop

-- Mine --
E:\oracle\product\10.1.0\Db_3\sysman\admin\emdrep\bin\RepManager intruder 5500 highlife -action drop

Mine does not have the emca -x highlife preceding the command.
Re: ORACLEDB CONSOLE SERVICES [message #293837 is a reply to message #293021] Tue, 15 January 2008 04:01 Go to previous messageGo to next message
data_viper
Messages: 11
Registered: December 2007
Location: UK
Junior Member

Hi again my friend and sorry 4 the late answer...

I may be mistaken, but I can't realy type the 2nd command in the DOS console, it would result in an error! unless I preceeded it with the executable emca!

Thx , I realy appreciate the time U R giving me.
Re: ORACLEDB CONSOLE SERVICES [message #293854 is a reply to message #293837] Tue, 15 January 2008 05:03 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Can you find the RepManager executable on your system? This page describes all the necessary steps (Dropping the Management Repository).
Re: ORACLEDB CONSOLE SERVICES [message #297412 is a reply to message #293854] Thu, 31 January 2008 06:39 Go to previous messageGo to next message
data_viper
Messages: 11
Registered: December 2007
Location: UK
Junior Member


U C my friend I found the RepManager has no file extension and when I want 2 start it it gives me nothing:


C:\WINDOWS\system32>E:\oracle\product\10.1.0\Db_3\sysman\admin\emdrep\bin\
RepManager intruder 1521 python -action drop
'E:\oracle\product\10.1.0\Db_3sysman\admin\emdrep\bin\RepManager' is not recognised as an internal or external command, operable program or batch file.
Re: ORACLEDB CONSOLE SERVICES [message #297468 is a reply to message #297412] Thu, 31 January 2008 21:07 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Take a look here for all the details of recreating the DB repository. I really have no idea why RepManager wouldn't be located in %ORACLE_HOME%\sysman\admin\emdrep\bin.
Previous Topic: Why database is starting up auto ?
Next Topic: OS error
Goto Forum:
  


Current Time: Thu Nov 07 23:54:12 CST 2024