DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 20

Thread: checking if database is open on Unix

Threaded View

  1. 09-08-2003, 11:57 AM #3
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    very easy, create some dummy/inexistent user and connect to database and look for ORA-01017 error like

    Code:
    a=`(sqlplus ksaks/kajsa|grep ORA-01017) << EOF
EOF
`

if [ "${a}" != "" ]; then
   echo Database is up"
fi
    Last edited by pando; 09-08-2003 at 12:06 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width