OraFAQ Forum: Enterprise Manager » oracle moves to shutdown and automaticaly up

Home » RDBMS Server » Enterprise Manager » oracle moves to shutdown and automaticaly up

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

oracle moves to shutdown and automaticaly up [message #268545]

Wed, 19 September 2007 01:12

shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala

Member

when i use emctl start dbconsole then the output is here

TZ set to Asia/Calcutta
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://linuxserver1:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ........................ started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/oracle/product/10.2.0/db_1/linuxserver1_oratest/sysman/log

---------------

but the oracle moves to shutdown and automaticaly up

Report message to a moderator

Re: oracle moves to shutdown and automaticaly up [message #268549 is a reply to message #268545]

Wed, 19 September 2007 01:24

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

but the oracle moves to shutdown and automaticaly up

How you identified that? Some one manually can do that or there may be scheduled task to shutdown and startup the database.

Report message to a moderator

Re: oracle moves to shutdown and automaticaly up [message #268556 is a reply to message #268549]

Wed, 19 September 2007 01:34

shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala

Member

After that i login to database , then "Oracle shutdown in progress" message comes , after a few minutes i can login to database

Report message to a moderator

Re: oracle moves to shutdown and automaticaly up [message #268559 is a reply to message #268545]

Wed, 19 September 2007 01:40

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

May be someone issued shutdown while you logging to database.

Report message to a moderator

Re: oracle moves to shutdown and automaticaly up [message #268561 is a reply to message #268559]

Wed, 19 September 2007 01:46

shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala

Member

sir , it is not possible because i am the only one person who knows Oracle , and also one question
when we use emctl start dbcomsole , why oracle moves to shutdown

Report message to a moderator

Re: oracle moves to shutdown and automaticaly up [message #268562 is a reply to message #268545]

Wed, 19 September 2007 01:53

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Copy and paste the following query while log in into SQL*PLUS.

select open_mode from v$database;
host emctl start dbconsole
select open_mode from v$database;

Report message to a moderator

Re: oracle moves to shutdown and automaticaly up [message #268566 is a reply to message #268562]

Wed, 19 September 2007 02:01

shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala

Member

Sir , one point is that it is not happening all time
now the output is

SQL> connect sys/admin as sysdba
Connected.
SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

SQL> host emctl start dbconsole
TZ set to Asia/Calcutta
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://linuxserver1:1158/em/console/aboutApplication
- An instance of Oracle Enterprise Manager 10g Database Control is already running.

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

SQL>

Report message to a moderator

Previous Topic:	OEM_REPOSITORY Tablespace
Next Topic:	ora-12500

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 01:07:36 CST 2024