debugging dbstart / dbstop
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: debugging dbstart / dbstop

  1. #1
    Join Date
    Oct 2002
    Posts
    182

    debugging dbstart / dbstop

    Oracle 9.2.0.4 on SunOS sunprod1 5.8
    Generic_108528-23 sun4u sparc SUNW,Ultra-80

    What would be the most appropriate way to debug dbstart and dbstop?
    I read the docs, edited the appropriate files on the server, but the database does not startup on reboot.

    Perhaps there is a better tutorial link out there than I have found.
    - Cookies

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    yes, learn shell scripting

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    tell us what you have done - crystal ball broken

  4. #4
    Join Date
    Oct 2002
    Posts
    182
    Been testing on a Linux box with same version 9.2.0.4

    What I did:
    Code:
    -	Changed /etc/oratab file to: DEV1:/opt/ora9/product/9.2:Y
    -	Create file /etc/init.d/dbora
    #!/bin/sh
    # Set ORA_HOME to be equivalent to the $ORACLE_HOME
    # from which you wish to execute dbstart and dbshut;
    #
    # Set ORA_OWNER to the user id of the owner of the
    # Oracle database in ORA_HOME.
    
    ORA_HOME=/opt/ora9/product/9.2
    ORA_OWNER=oracle
    
    if [! -f $ORA_HOME/bin/dbstart]
    Configuration Tasks to Perform as the root User
    then
    	echo "Oracle startup: cannot start"
    	exit
    fi
    
    case "$1" in
    	ístartí)
    
    
    		# Start the Oracle databases:
    		# The following command assumes that the oracle login
    		# will not prompt the user for any values
    
    	su - $ORA_OWNER -c $ORA_HOME/bin/dbstart &
    	;;
    
    	ístopí)
    		# Stop the Oracle databases:
    		# The following command assumes that the oracle login
    		# will not prompt the user for any values
    
    	su - $ORA_OWNER -c $ORA_HOME/bin/dbshut &
    	;;
    esac
    
    - chmod 755 dbora
    - ln -s /etc/init.d/dbora /etc/rc0.d/K10dbora
    - ln -s /etc/init.d/dbora /etc/rc3.d/S99dbora
    - Cookies

  5. #5
    Join Date
    Oct 2002
    Posts
    182
    I got the dbstart and dbshut scripts to work on their own,
    but I still am having problems getting the server to run them
    on reboot.
    - Cookies

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Are you positive the server is executing them at the runlevel you expect?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Oct 2002
    Posts
    182
    Originally posted by marist89
    Are you positive the server is executing them at the runlevel you expect?
    I wasn't positive about that so I added the run-script to every runlevel and it worked. Yay for me!

    Also, before that, I realized that oracle F-ed up with their
    stupid scripts which I had to edit to account for spfiles and
    a few other configurations.

    The end result was that I got it working.
    - Cookies

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width