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
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
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
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
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
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
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
LEARN ABOUT PHP
fbsql_db_status
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)