Join with the other

    320

Subscribe Blog Via Email

Flag Counter

SRVCTL Command : For Database

SRVCTL : For Database
To Add Database

    srvctl add database -d racdb -o /db/oracle/app/oracle/product/11.2/

To Remove Database

    srvctl remove database -d racdb

To Start Database with different option

    srvctl start database -d racdb -o nomount
    srvctl start database -d racdb -o mount
    srvctl start db -d racdb
    srvctl start database -d racdb -o open

To Stop Database with different option

    srvctl stop database -d racdb -o transactional
    srvctl stop database -d racdb -o immediate
    srvctl stop database -d racdb -o abort
    srvctl stop db -d racdb -o immediate

To check the status of the database

    srvctl status database -d racdb -v service_name
    srvctl status database -d racdb

To enable and disable database

    srvctl enable database -d racdb
    srvctl disable db -d racdb

To configure databasee option

    srvctl config database -d racdb

To modify database settings

    srvctl modify database -d racdb -r logical_standby
    srvctl modify db -d racdb -p /db/oracle/oradata/racdb/spfilebhavik_test.ora -- moves p file
    srvctl modify database -d racdb -o /db/oracle/app/oracle/product/11.2/ -s open

To get/set/unset the environment settings

    srvctl getenv database -d racdb
    srvctl setenv database -d racdb -t "TNS_ADMIN=/db/oracle/app/oracle/product/11.2/asm/network/admin"
    srvctl setenv db -d racdb -t LANG=en
    srvctl unsetenv database -d racdb -t CLASSPATH