Home » RDBMS Server » Enterprise Manager » oracle moves to shutdown and automaticaly up
oracle moves to shutdown and automaticaly up [message #268545] Wed, 19 September 2007 01:12 Go to next message
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
Re: oracle moves to shutdown and automaticaly up [message #268549 is a reply to message #268545] Wed, 19 September 2007 01:24 Go to previous messageGo to next message
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.
Re: oracle moves to shutdown and automaticaly up [message #268556 is a reply to message #268549] Wed, 19 September 2007 01:34 Go to previous messageGo to next message
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
Re: oracle moves to shutdown and automaticaly up [message #268559 is a reply to message #268545] Wed, 19 September 2007 01:40 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

May be someone issued shutdown while you logging to database.
Re: oracle moves to shutdown and automaticaly up [message #268561 is a reply to message #268559] Wed, 19 September 2007 01:46 Go to previous messageGo to next message
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
Re: oracle moves to shutdown and automaticaly up [message #268562 is a reply to message #268545] Wed, 19 September 2007 01:53 Go to previous messageGo to next message
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;
Re: oracle moves to shutdown and automaticaly up [message #268566 is a reply to message #268562] Wed, 19 September 2007 02:01 Go to previous message
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>
Previous Topic: OEM_REPOSITORY Tablespace
Next Topic: ora-12500
Goto Forum:
  


Current Time: Sat Dec 03 01:22:57 CST 2016

Total time taken to generate the page: 0.12542 seconds