OraFAQ Forum: Windows » ORACLEDB CONSOLE SERVICES (merged)

Home » Infrastructure » Windows » ORACLEDB CONSOLE SERVICES (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORACLEDB CONSOLE SERVICES (merged) [message #291906]

Mon, 07 January 2008 03:16

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.

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #291932 is a reply to message #291906]

Mon, 07 January 2008 04:59

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Is you laptop set up with DHCP? If so, check Installing Oracle Database on DHCP Computers.

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #291947 is a reply to message #291906]

Mon, 07 January 2008 05:24

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.

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #291954 is a reply to message #291947]

Mon, 07 January 2008 05:30

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

Error 1053: The service did not repond [message #291957 is a reply to message #291906]

Mon, 07 January 2008 05:34

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.

Report message to a moderator

Re: Error 1053: The service did not repond [message #291959 is a reply to message #291957]

Mon, 07 January 2008 05:35

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Don't start a new topic, reply in the previous one.

Regards
Michel

Report message to a moderator

Re: Error 1053: The service did not repond [message #291962 is a reply to message #291957]

Mon, 07 January 2008 05:39

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #291971 is a reply to message #291932]

Mon, 07 January 2008 05:55

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?

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #291972 is a reply to message #291971]

Mon, 07 January 2008 05:57

Frank Naude
Messages: 4587
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

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #292004 is a reply to message #291954]

Mon, 07 January 2008 07:25

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.

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #292011 is a reply to message #292004]

Mon, 07 January 2008 07:51

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Regards
Michel

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #292037 is a reply to message #292004]

Mon, 07 January 2008 09:20

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 ?

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #292236 is a reply to message #292011]

Tue, 08 January 2008 04:38

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!

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #292251 is a reply to message #292236]

Tue, 08 January 2008 05:12

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.

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #292288 is a reply to message #292251]

Tue, 08 January 2008 07:29

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

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #292291 is a reply to message #292288]

Tue, 08 January 2008 08:00

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Have you tried to recreate the repository?

emca -config dbcontrol db -repos recreate

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #292562 is a reply to message #292291]

Wed, 09 January 2008 03:53

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

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #292587 is a reply to message #292562]

Wed, 09 January 2008 05:00

ebrian
Messages: 2794
Registered: April 2006

Senior Member

To drop, use:

emca -deconfig dbcontrol db -repos drop

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #292590 is a reply to message #292587]

Wed, 09 January 2008 05:24

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:

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #292592 is a reply to message #292590]

Wed, 09 January 2008 05:32

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

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #292618 is a reply to message #292592]

Wed, 09 January 2008 07:09

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:

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #292634 is a reply to message #292618]

Wed, 09 January 2008 08:39

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

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #292983 is a reply to message #292634]

Thu, 10 January 2008 06:54

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?

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #293021 is a reply to message #292983]

Thu, 10 January 2008 11:18

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.

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #293837 is a reply to message #293021]

Tue, 15 January 2008 04:01

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.

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #293854 is a reply to message #293837]

Tue, 15 January 2008 05:03

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).

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #297412 is a reply to message #293854]

Thu, 31 January 2008 06:39

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.

Report message to a moderator

Re: ORACLEDB CONSOLE SERVICES [message #297468 is a reply to message #297412]

Thu, 31 January 2008 21:07

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.

Report message to a moderator

Previous Topic:	Why database is starting up auto ?
Next Topic:	OS error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 06:20:44 CST 2024