6 Replies Latest reply: Feb 3, 2013 8:59 AM by Karan RSS

    autoshut not working

    949210
      using oel5.7 and 11gr2
      i am using the following script to startup and shutdown automatically
      ORACLE_HOME=/home/oracle/product/10.1.0/Db_1
      ORA_OWNER=oracle

      case “$1″ in
      ’start’) #If the system is starting, then …
      su – $ORA_OWNER -c “$ORACLE_HOME/bin/lsnrctl start” #Start the listener
      su – $ORA_OWNER -c “$ORACLE_HOME/bin/dbstart #Start the database
      ;;

      ‘stop’) #If the system is stops, that is we’re shutting down our OS, then …
      su -$ORA_OWNER -c “$ORACLE_HOME/bin/dbshut“
      su -$ORA_OWNER -c “$ORACLE_HOME/bin/lsnrctl stop”
      ;;
      esac
      when the server starts the database starts automatically
      when the server shuts down the database does not shut down automatically
      this is a cut-out of alert log file
      :
      :
      ALTER DATABASE OPEN
      Thread 1 opened at log sequence 39
      Current log# 3 seq# 39 mem# 0: /home/oracle/u01/app/oracle/oradata/looking4/redo03.log
      Successful open of redo thread 1
      MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
      SMON: enabling cache recovery
      Successfully onlined Undo Tablespace 2.
      Verifying file header compatibility for 11g tablespace encryption..
      Verifying 11g file header compatibility for tablespace encryption completed
      SMON: enabling tx recovery
      Database Characterset is AL32UTF8
      No Resource Manager plan active
      replication_dependency_tracking turned off (no async multimaster replication found)
      Starting background process QMNC
      Thu Aug 30 15:03:50 2012
      QMNC started with pid=20, OS id=4598
      Completed: ALTER DATABASE OPEN
      Thu Aug 30 15:03:51 2012
      db_recovery_file_dest_size of 3852 MB is 0.00% 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.
      Starting background process CJQ0
      Thu Aug 30 15:03:51 2012
      CJQ0 started with pid=23, OS id=4630
      Thu Aug 30 15:08:37 2012
      Starting ORACLE instance (normal)
      LICENSE_MAX_SESSION = 0
      LICENSE_SESSIONS_WARNING = 0
      Picked latch-free SCN scheme 2
      Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
      Autotune of undo retention is turned on.
      IMODE=BR
      ILAT =27
      LICENSE_MAX_USERS = 0
      SYS auditing is disabled
      Starting up:
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options.
      Using parameter settings in server-side spfile /home/oracle/u01/app/oracle/product/11.2.0.1/db_1/dbs/spfilelooking4.ora
      System parameters with non-default values:
      processes = 150
      memory_target = 660M
      control_files = "/home/oracle/u01/app/oracle/oradata/looking4/control01.ctl"
      control_files = "/home/oracle/u01/app/oracle/flash_recovery_area/looking4/control02.ctl"
      db_block_size = 8192
      compatible = "11.2.0.0.0"
      db_recovery_file_dest = "/home/oracle/u01/app/oracle/flash_recovery_area"
      db_recovery_file_dest_size= 3852M
      undo_tablespace = "UNDOTBS1"
      remote_login_passwordfile= "EXCLUSIVE"
      db_domain = "local.lan"
      dispatchers = "(PROTOCOL=TCP) (SERVICE=looking4XDB)"
      local_listener = "(address=(protocol=tcp)(host=unknown485b39d0b515)(port=1521))"
      audit_file_dest = "/home/oracle/u01/app/oracle/admin/looking4/adump"
      audit_trail = "DB"
      db_name = "looking4"
      open_cursors = 300
      diagnostic_dest = "/home/oracle/u01/app/oracle"
      Thu Aug 30 15:08:39 2012
      PMON started with pid=2, OS id=3649
      Thu Aug 30 15:08:39 2012
      VKTM started with pid=3, OS id=3653
      VKTM running at (100ms) precision
      Thu Aug 30 15:08:39 2012
      GEN0 started with pid=4, OS id=3659
      Thu Aug 30 15:08:39 2012
      DIAG started with pid=5, OS id=3663
      Thu Aug 30 15:08:39 2012
      DBRM started with pid=6, OS id=3667
      Thu Aug 30 15:08:39 2012
      PSP0 started with pid=7, OS id=3671
      Thu Aug 30 15:08:39 2012
      DIA0 started with pid=8, OS id=3675
      Thu Aug 30 15:08:39 2012
      MMAN started with pid=9, OS id=3679
      Thu Aug 30 15:08:39 2012
      DBW0 started with pid=10, OS id=3683
      Thu Aug 30 15:08:39 2012
      LGWR started with pid=11, OS id=3687
      Thu Aug 30 15:08:39 2012
      CKPT started with pid=12, OS id=3691
      Thu Aug 30 15:08:40 2012
      SMON started with pid=13, OS id=3695
      Thu Aug 30 15:08:40 2012
      RECO started with pid=14, OS id=3699
      Thu Aug 30 15:08:40 2012
      MMON started with pid=15, OS id=3703
      starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
      Thu Aug 30 15:08:40 2012
      MMNL started with pid=16, OS id=3707
      starting up 1 shared server(s) ...
      ORACLE_BASE from environment = /home/oracle/u01/app/oracle/
      Thu Aug 30 15:08:40 2012
      ALTER DATABASE MOUNT
      Successful mount of redo thread 1, with mount id 1887520888
      Database mounted in Exclusive Mode
      Lost write protection disabled
      Completed: ALTER DATABASE MOUNT
      Thu Aug 30 15:08:45 2012
      ALTER DATABASE OPEN
      :
      :
      observe that there is no shutdown between the two "alter database open"s
      also when i manually execute dbshut it works
      [oracle@unknown485b39d0b515 bin]$ ./dbshut
      ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener
      Usage: ./dbshut ORACLE_HOME
      Processing Database instance "looking4": log file /home/oracle/u01/app/oracle/product/11.2.0.1/db_1/shutdown.log
      [oracle@unknown485b39d0b515 bin]$
      [oracle@unknown485b39d0b515 bin]$ ps -ef|grep smon
      oracle 5258 4757 0 15:42 pts/1 00:00:00 grep smon
      the symbolic links are given for run level 3 and 5 as follows
      # ln -s /etc/init.d/startdb /etc/rc.d/rc3.d/K01startdb
      # ln -s /etc/init.d/startdb /etc/rc.d/rc3.d/S99startdb
      # ln -s /etc/init.d/startdb /etc/rc.d/rc5.d/K01startdb
      # ln -s /etc/init.d/startdb /etc/rc.d/rc5.d/S99startdb
      why is the database not shutting down during server shutdown?
      or is it shutting down using "shutdown immediate" but just that this info is not written to alert log??
      thanks in advance

      Edited by: 946207 on Aug 30, 2012 3:42 PM