Home » RDBMS Server » Networking and Gateways » Possible error messages - sql statement running - database suddenly down
Possible error messages - sql statement running - database suddenly down [message #159352] Fri, 17 February 2006 09:59 Go to next message
juttusenthil
Messages: 2
Registered: February 2006
Junior Member
Hi,
Through a cron job, a shell script is run. In the shell script, connected to a oracle database and a sql file is run.
The sql file contains nothing other that a single selet statement with joins.
I wanted to know what are the possible errors messages the sql statement will give, if the database is down or server down when the sql file is running??

Report message to a moderator

Re: Possible error messages - sql statement running - database suddenly down [message #173313 is a reply to message #159352] Sun, 21 May 2006 14:30 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
If the server is down then cron is not running.

In your cron script you can check to see if the instance is up and report when it is not.
Neil.

Report message to a moderator

Previous Topic: Database Link Timing Out?
Next Topic: ora-12547 tns lost contact err
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 05:03:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.