Sponsored Content
Top Forums Shell Programming and Scripting To Check Oracle Database Status Post 302450442 by vpv0002 on Thursday 2nd of September 2010 03:48:43 PM
Old 09-02-2010
To Check Oracle Database Status

I have to check the oracle database status using ksh, if the database is down then i need to send my dba an email saying database is down and wait for 10 mins and check for the status again and so on. once the database is up then should continue to the next step in the script.
Any help is appriciated.

Thank you.
 

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

check the status and send an email with status

Hi, We have a text file which has the following data. ISA~00~ ~00~ ~ZZ~VISTN ~ZZ~U1CAD ~051227~183 7~U~00200~000011258~0~P~< GS~FA~EE05J~U1CAD~051227~1831~000011258~X~002002 ST~997~0001 AK1~SH~247 AK2~856~2470001 AK5~A AK2~856~2470002 AK5~A... (3 Replies)
Discussion started by: isingh786
3 Replies

2. Shell Programming and Scripting

Exit status always zero in KSH from Oracle Scheduler

Hi, Running Oracle Scheduler 11g2 on an AIX 6.01. I want to run a shell script (called "external program" in Oracle terminology) which executes some commands and react on the outcome using the exit status $?. For example a "cat thisfiledoesnotexist" and then get the $? which should be not zero.... (6 Replies)
Discussion started by: hermanmol
6 Replies

3. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General... (0 Replies)
Discussion started by: solaris_user
0 Replies

4. UNIX and Linux Applications

Oracle database recovery

Is there a way to recover Oracle database in x86 server from broken sparc server (Solaris10)? (9 Replies)
Discussion started by: orange47
9 Replies

5. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies

6. UNIX and Linux Applications

Oracle Database - How to check if user roles and system roles are separated?

I have these two table. How do I see if user roles and system roles are seperated? SQL> desc DBA_ROLES; Name Null? Type ----------------------------------------- -------- ---------------------------- ROLE NOT NULL... (1 Reply)
Discussion started by: alvinoo
1 Replies
FBSQL_DB_STATUS(3)							 1							FBSQL_DB_STATUS(3)

fbsql_db_status - Get the status for a given database

SYNOPSIS
int fbsql_db_status (string $database_name, [resource $link_identifier]) DESCRIPTION
Gets the current status of the specified database. PARAMETERS
o $database_name - The database name. o $ link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if fbsql_connect(3) was called with no arguments. RETURN VALUES
Returns an integer value with the current status. This can be one of the following constants: o FALSE - The exec handler for the host was invalid. This error will occur when the $link_identifier connects directly to a database by using a port number. FBExec can be available on the server but no connection has been made for it. o FBSQL_UNKNOWN - The Status is unknown. o FBSQL_STOPPED - The database is not running. Use fbsql_start_db(3) to start the database. o FBSQL_STARTING - The database is starting. o FBSQL_RUNNING - The database is running and can be used to perform SQL operations. o FBSQL_STOPPING - The database is stopping. o FBSQL_NOEXEC - FBExec is not running on the server and it is not possible to get the status of the database. SEE ALSO
fbsql_start_db(3), fbsql_stop_db(3). PHP Documentation Group FBSQL_DB_STATUS(3)
All times are GMT -4. The time now is 04:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy