Remote Instance startup/shutdown


Detailed Description

OCILIB, from version 3.4.0, supports Oracle 11g client features for manuipulating remote Oracle instances.

Oracle instances (on the same computer or on a remote server) can be

Several options are handled for this actions

Example
#include "ocilib.h"

int main(void)
{ 
    OCI_Initialize(NULL, NULL, OCI_ENV_DEFAULT);

    /* start remote instance */

    OCI_DatabaseStartup("db", 
                        "sys_usr", 
                        "sys_pwd", 
                        OCI_SESSION_SYSDBA, 
                        OCI_DB_SPM_FULL,
                        OCI_DB_SPF_FORCE,
                        NULL);


     /* shutdown remote instance */

    OCI_DatabaseShutdown("db", 
                         "sys_usr", 
                         "sys_pwd",  
                         OCI_SESSION_SYSDBA,
                         OCI_DB_SDM_FULL,
                         OCI_DB_SDF_ABORT);
    OCI_Cleanup();
    
    return EXIT_SUCCESS;
}   


Functions

OCI_EXPORT boolean OCI_API OCI_DatabaseStartup (const mtext *db, const mtext *user, const mtext *pwd, unsigned int sess_mode, unsigned int start_mode, unsigned int start_flag, const mtext *spfile)
 Start a database instance.
OCI_EXPORT boolean OCI_API OCI_DatabaseShutdown (const mtext *db, const mtext *user, const mtext *pwd, unsigned int sess_mode, unsigned int shut_mode, unsigned int shut_flag)
 Shutdown a database instance.


Function Documentation

OCI_EXPORT boolean OCI_API OCI_DatabaseShutdown ( const mtext *  db,
const mtext *  user,
const mtext *  pwd,
unsigned int  sess_mode,
unsigned int  shut_mode,
unsigned int  shut_flag 
)

Shutdown a database instance.

Parameters:
db - Oracle Service Name
user - Oracle User name
pwd - Oracle User password
sess_mode - Session mode
shut_mode - Shutdown mode
shut_flag - Shutdown flag
Warning:
Possible values for parameter sess_mode :
  • OCI_SESSION_SYSDBA
  • OCI_SESSION_SYSOPER
Note:
External credentials are supported by supplying a null value for the 'user' and 'pwd' parameters If the param 'db' is NULL then a connection to the default local DB is done
Possible (combined) values for parameter shut_mode :

Possible (exclusive) value for parameter shut_flag (from Oracle documentation) :

Returns:
TRUE on success otherwise FALSE

Definition at line 1408 of file library.c.

References OCI_Connection::cxt, OCI_Connection::err, OCI_ConnectionCreate(), OCI_ConnectionFree(), OCI_ExecuteStmt(), OCI_StatementCreate(), OCI_StatementFree(), OCI_TransactionFree(), and OCI_Connection::trs.

OCI_EXPORT boolean OCI_API OCI_DatabaseStartup ( const mtext *  db,
const mtext *  user,
const mtext *  pwd,
unsigned int  sess_mode,
unsigned int  start_mode,
unsigned int  start_flag,
const mtext *  spfile 
)

Start a database instance.

Parameters:
db - Oracle Service Name
user - Oracle User name
pwd - Oracle User password
sess_mode - Session mode
start_mode - Start mode
start_flag - Start flags
spfile - Client-side spfile to start up the database (optionnal)
Possible values for parameter sess_mode :

Note:
External credentials are supported by supplying a null value for the 'user' and 'pwd' parameters If the param 'db' is NULL then a connection to the default local DB is done
Possible (combined) values for parameter start_mode :

Possible (combined) values for parameter start_flag :

Note:
If the client side spfile is not provided, the database is started with its server-side spfile
Returns:
TRUE on success otherwise FALSE

Definition at line 1278 of file library.c.

References OCI_Connection::cxt, OCI_Connection::err, OCI_ConnectionCreate(), OCI_ConnectionFree(), OCI_ExecuteStmt(), OCI_StatementCreate(), and OCI_StatementFree().


Generated on Thu Jul 30 17:41:55 2009 for OCILIB (C Driver for Oracle) by  doxygen 1.5.4