OraFAQ Forum: Server Administration » I think this is a magic . am i right ?

Home » RDBMS Server » Server Administration » I think this is a magic . am i right ?

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

I think this is a magic . am i right ? [message #278537]

Mon, 05 November 2007 00:23

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