Home » RDBMS Server » Server Administration » I think this is a magic . am i right ?
I think this is a magic . am i right ? [message #278537] Mon, 05 November 2007 00:23 Go to next message
shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala
Member
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
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

SQL> select open_mode from v$database;

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

After a bit of time ,

SQL> select open_mode from v$database;
select open_mode from v$database
*
ERROR at line 1:
ORA-03135: connection lost contact
Then i issued the command
SQL> connect sys/admin as sysdba;

ORA-01033: ORACLE initialization or shutdown in progress


After a bit of time ,

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

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

The value of
db_recovery_file_dest_size is 4294967295
db_block_size is 8192
db_cache_size is 159383552
sga_max_size is 385212672
sga_target is 385875968
The value of Kernel parameter
kernel.shmmax = 4294967295

I also posted the the alert log below here

Starting background process EMN0
EMN0 started with pid=36, OS id=12457
Wed Oct 31 14:47:53 2007
Shutting down instance: further logons disabled
Wed Oct 31 14:47:55 2007
Stopping background process QMNC
Wed Oct 31 14:47:55 2007
Stopping background process CJQ0
Wed Oct 31 14:47:57 2007
Stopping background process MMNL
Wed Oct 31 14:47:58 2007
Stopping background process MMON
Wed Oct 31 14:47:59 2007
Shutting down instance (immediate)
License high water mark = 18
Wed Oct 31 14:47:59 2007
Stopping Job queue slave processes
Wed Oct 31 14:47:59 2007
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Wed Oct 31 14:48:10 2007
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Oct 31 14:48:22 2007
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Oct 31 14:48:26 2007
ALTER DATABASE CLOSE NORMAL
Wed Oct 31 14:48:27 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Oct 31 14:48:27 2007
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 782
Successful close of redo thread 1
Wed Oct 31 14:48:27 2007
Completed: ALTER DATABASE CLOSE NORMAL
Wed Oct 31 14:48:27 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Oct 31 14:48:30 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
sga_max_size = 385875968
__shared_pool_size = 113246208
shared_pool_size = 113246208
__large_pool_size = 29360128
large_pool_size = 29360128
__java_pool_size = 75497472
java_pool_size = 75497472
__streams_pool_size = 0
streams_pool_size = 0
sga_target = 385875968
control_files = /u01/app/oracle/oradata/oratest/control01.ctl, /u01/app/oracle/oradata/oratest/control02.ctl, /u01/app/oracle/oradata/oratest/control03.ctl
db_block_size = 8192
__db_cache_size = 159383552
db_cache_size = 159383552
compatible = 10.2.0.1.0
log_archive_dest_1 = LOCATION=/u01/app/oracle/admin/oratest/arch
log_archive_max_processes= 1
log_archive_format = %t_%s_%r.dbf
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 4294967295
log_checkpoints_to_alert = TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=oratestXDB)
plsql_compiler_flags = NATIVE, NON_DEBUG
plsql_native_library_dir = /u01/app/oracle/oracle/product/10.2.0/db_1/plsql/lib
job_queue_processes = 10
background_dump_dest = /u01/app/oracle/admin/oratest/bdump
user_dump_dest = /u01/app/oracle/admin/oratest/udump
core_dump_dest = /u01/app/oracle/admin/oratest/cdump
audit_file_dest = /u01/app/oracle/admin/oratest/adump
db_name = oratest
open_cursors = 1500
sql_trace = FALSE
pga_aggregate_target = 94371840
Deprecated system parameters with specified values:
plsql_compiler_flags
sql_trace
End of deprecated system parameter listing
PMON started with pid=2, OS id=12506
PSP0 started with pid=3, OS id=12508
MMAN started with pid=4, OS id=12510
DBW0 started with pid=5, OS id=12512
LGWR started with pid=6, OS id=12514
CKPT started with pid=7, OS id=12516
SMON started with pid=8, OS id=12518
RECO started with pid=9, OS id=12520
CJQ0 started with pid=10, OS id=12522
MMON started with pid=11, OS id=12524
Wed Oct 31 14:48:31 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=12526
Wed Oct 31 14:48:31 2007
starting up 1 shared server(s) ...
Wed Oct 31 14:48:32 2007
ALTER DATABASE MOUNT
Wed Oct 31 14:48:36 2007
Setting recovery target incarnation to 1
Wed Oct 31 14:48:36 2007
Successful mount of redo thread 1, with mount id 3172793408
Wed Oct 31 14:48:36 2007
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Wed Oct 31 14:48:43 2007
alter database open
Wed Oct 31 14:48:43 2007
Thread 1 opened at log sequence 782
Current log# 3 seq# 782 mem# 0: /u01/app/oracle/oradata/oratest/redo03.log
Successful open of redo thread 1
Wed Oct 31 14:48:43 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Oct 31 14:48:43 2007
SMON: enabling cache recovery
Wed Oct 31 14:48:43 2007
Incremental checkpoint up to RBA [0x30e.16897.0], current log tail at RBA [0x30e.16897.0]
Wed Oct 31 14:48:44 2007
Successfully onlined Undo Tablespace 1.
Wed Oct 31 14:48:44 2007
SMON: enabling tx recovery
Wed Oct 31 14:48:45 2007
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=12555
Wed Oct 31 14:48:51 2007
db_recovery_file_dest_size of 4095 MB is 77.77% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Oct 31 14:48:51 2007
Completed: alter database open
Wed Oct 31 14:49:35 2007
Beginning log switch checkpoint up to RBA [0x30f.2.10], SCN: 18437465
Thread 1 advanced to log sequence 783
Current log# 1 seq# 783 mem# 0: /u01/app/oracle/oradata/oratest/redo01.log


Re: I think this is a magic . am i right ? [message #278538 is a reply to message #278537] Mon, 05 November 2007 00:27 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Not a Magic. There is another agent/person who issued shutdown database and startup.
Re: I think this is a magic . am i right ? [message #278552 is a reply to message #278538] Mon, 05 November 2007 01:05 Go to previous messageGo to next message
shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala
Member
No sir , That is not possible today i am alone in my office
Re: I think this is a magic . am i right ? [message #278562 is a reply to message #278552] Mon, 05 November 2007 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Cron/schedule job?

The message is clear:
Quote:

Wed Oct 31 14:47:59 2007
Shutting down instance (immediate)

At this time someone or something execute a "shutdown immediate".

Regards
Michel
Re: I think this is a magic . am i right ? [message #278564 is a reply to message #278552] Mon, 05 November 2007 01:25 Go to previous messageGo to next message
shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala
Member
Every time i host emctl start dbconsole , Database moves to down and automaticaly up ............
Re: I think this is a magic . am i right ? [message #278566 is a reply to message #278537] Mon, 05 November 2007 01:28 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Then...

Quote:

Cron/schedule job?


Check ..
Re: I think this is a magic . am i right ? [message #278568 is a reply to message #278562] Mon, 05 November 2007 01:29 Go to previous messageGo to next message
shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala
Member
It is not a Cron/schedule job .
There is no chance for someone to execute a "shutdown immediate".

Please help me sir ............
Re: I think this is a magic . am i right ? [message #278570 is a reply to message #278568] Mon, 05 November 2007 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Then you clicked on "restart" button.

Regards
Michel
Re: I think this is a magic . am i right ? [message #278571 is a reply to message #278566] Mon, 05 November 2007 01:31 Go to previous messageGo to next message
shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala
Member
Only backup operation is croned .................
please sir ............
Re: I think this is a magic . am i right ? [message #278573 is a reply to message #278571] Mon, 05 November 2007 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Cold backup?
Check your script.

Regards
Michel
Re: I think this is a magic . am i right ? [message #278574 is a reply to message #278570] Mon, 05 November 2007 01:35 Go to previous messageGo to next message
shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala
Member
Sir i am in SQL> terminal ,
here no restart button to press.
This problem has been started for more tham 5 months , whenever i issued
SQL>host emctl start dbconsole , after a bit of time the database moves to down and up automatically
Re: I think this is a magic . am i right ? [message #278631 is a reply to message #278574] Mon, 05 November 2007 03:43 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How does EMCTL file look like? Did you (or someone else) modify it in order to shut down and start up the database?
Re: I think this is a magic . am i right ? [message #278699 is a reply to message #278574] Mon, 05 November 2007 07:25 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

PMON failed to acquire latch, see PMON dump
And you also hit bug: Check Metalink Note: 4632780.8, BUG# 4632780


Re: I think this is a magic . am i right ? [message #278700 is a reply to message #278699] Mon, 05 November 2007 07:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good eyes! I didn't see it in all this stuff. Cool

Regards
Michel
Re: I think this is a magic . am i right ? [message #279160 is a reply to message #278573] Wed, 07 November 2007 02:59 Go to previous messageGo to next message
shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala
Member

NOt cold backup
it is a Hot backup script
Re: I think this is a magic . am i right ? [message #279161 is a reply to message #278699] Wed, 07 November 2007 03:05 Go to previous messageGo to next message
shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala
Member
After this error , My pmon dump was stated below

/u01/app/oracle/admin/oratest/bdump/oratest_pmon_3055.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
ORACLE_HOME = /u01/app/oracle/oracle/product/10.2.0/db_1
System name: Linux
Node name: linuxserver1
Release: 2.6.9-42.ELsmp
Version: #1 SMP Sat Aug 12 09:39:11 CDT 2006
Machine: i686
Instance name: oratest
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 3055, image: oracle@linuxserver1 (PMON)

*** 2007-09-22 14:38:10.683
*** SERVICE NAME:(SYS$BACKGROUND) 2007-09-22 14:38:10.683
*** SESSION ID:(170.1) 2007-09-22 14:38:10.683
PMON unable to acquire latch 20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
gotten 3985 times wait, failed first 0 sleeps 0
gotten 2002 times nowait, failed: 0
possible holder pid = 33 ospid=13260
----------------------------------------
SO: 0x36e2190c, type: 2, owner: (nil), flag: INIT/-/-/0x00
(process) Oracle pid=33, calls cur/top: (nil)/0x347bf86c, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 1089 8 12
last post received-location: ksusig
last process to post me: 36e2190c 5 0
last post sent: 0 0 200
last post sent-location: kmmpsh
last process posted by me: 36e1acb0 1 0
(latch info) wait_event=0 bits=2
holding (efd=4) 20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
Process Group: DEFAULT, pseudo proc: 0x36e4c65c
O/S info: user: oracle, term: UNKNOWN, ospid: 13260
OSD pid info: Unix process pid: 13260, image: oracle@linuxserver1 (TNS V1-V3)
Short stack dump: ksdxfstk()+19<-ksdxcb()+1321<-sspuser()+81<-0037F7A2
Dump of memory from 0x36E0AB84 to 0x36E0AD08
36E0AB80 00000012 367D4C8C 00000010 [.....L}6....]
36E0AB90 0003139D 347BF86C 00000003 0003139D [....l.{4........]
36E0ABA0 3647B7E8 0000000B 0003139D 36EF6408 [..G6.........d.6]
36E0ABB0 00000004 00031291 35907278 00000006 [........xr.5....]
36E0ABC0 0003139D 36FBA378 00000005 0003139D [....x..6........]
36E0ABD0 358373BC 00000007 0003139D 35837440 [.s.5........@t.5]
36E0ABE0 00000007 0003139D 358374C4 00000007 [.........t.5....]
36E0ABF0 0003139D 3647B884 0000000B 0003139D [......G6........]
36E0AC00 358375CC 00000007 0003139D 35837650 [.u.5........Pv.5]
36E0AC10 00000007 0003139D 358376D4 00000007 [.........v.5....]
36E0AC20 0003139D 35837758 00000007 0003139D [....Xw.5........]
36E0AC30 358377DC 00000007 0003139D 35837860 [.w.5........`x.5]
36E0AC40 00000007 0003139D 358378E4 00000007 [.........x.5....]
36E0AC50 0003139D 35837968 00000007 0003139D [....hy.5........]
36E0AC60 00000000 00000000 00000000 00000000 [................]
Repeat 9 times
36E0AD00 00000000 00000000 [........]
*** 2007-09-22 14:38:11.164
PMON unable to acquire latch 20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
gotten 3985 times wait, failed first 0 sleeps 0
gotten 2002 times nowait, failed: 0
possible holder pid = 33 ospid=13260
*** 2007-09-22 14:38:13.588
PMON unable to acquire latch 20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
gotten 3985 times wait, failed first 0 sleeps 0
gotten 2002 times nowait, failed: 0
possible holder pid = 33 ospid=13260
*** 2007-09-22 14:38:15.988
PMON unable to acquire latch 20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
gotten 3985 times wait, failed first 0 sleeps 0
gotten 2002 times nowait, failed: 0
possible holder pid = 33 ospid=13260
*** 2007-09-22 14:38:18.419
PMON unable to acquire latch 20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
gotten 3985 times wait, failed first 0 sleeps 0
gotten 2002 times nowait, failed: 0
possible holder pid = 33 ospid=13260
*** 2007-09-22 14:38:20.828
PMON unable to acquire latch 20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
gotten 3985 times wait, failed first 0 sleeps 0
gotten 2002 times nowait, failed: 0
possible holder pid = 33 ospid=13260
*** 2007-09-22 14:38:23.159
PMON unable to acquire latch 20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
gotten 3985 times wait, failed first 0 sleeps 0
gotten 2002 times nowait, failed: 0
possible holder pid = 33 ospid=13260
*** 2007-09-22 14:38:25.472
Re: I think this is a magic . am i right ? [message #279171 is a reply to message #279161] Wed, 07 November 2007 03:45 Go to previous message
shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala
Member
The emctl.msg file contains
HealthMonitor Nov 7, 2007 3:20:46 PM Job Dispatcher error: Could not get connection
Previous Topic: Problem with Special Symbol (£) - is it NLS_LANg Setting Problem?
Next Topic: ASM Diskgroup dismounted - how to drop disk from?
Goto Forum:
  


Current Time: Tue Dec 06 04:27:47 CST 2016

Total time taken to generate the page: 0.18175 seconds