srvctl remove commands

SRVCTL REMOVE DATABASE - Removes a database configuration

Syntax and Options

srvctl remove database -d db_unique_name [-f]
-d db_unique_name
-f 
Force remove the database.

Example

srvctl remove database -d racdb

SRVCTL REMOVE INSTANCE - Removes a database instance configuration

Syntax and Options

srvctl remove instance -d db_unique_name -i inst_name [-f]
-d db_unique_name
-i inst_name
-f 
Force remove the database.

Example

srvctl remove instance -d racdb -i racdb01 -f

SRVCTL REMOVE NODEAPPS - Removes the node application configuration from the specified node. You must have
full administrative privileges to run this command. On Linux and UNIX systems, you must be logged in as root
and on Windows systems, you must be logged in as a user with Administrator privileges.

Syntax and Options

srvctl remove nodeapps -n node_name_list [-f]

Options Description 
-n node_name_list
 Node name or a comma-delimited list of node names.
-f
 Force remove.

Example

srvctl remove nodeapps -n "mynode1,mynode2,mynode3"

srvctl remove listener - Removes the listener from the specified node.

Syntax and Options

srvctl remove listener -n node_name [-l listener_name]

Options Description 
-n node_name
 Name of the node.
-l listener_name
 Name of the listener that you want to remove.

You will see something like below from $GRID_HOME/bin/crsstat output

HA Resource                                   Target     State
-----------                                   ------     -----
ora.LISTENER.lsnr                             ONLINE     ONLINE on myrac1d1
ora.LISTENER_SCAN1.lsnr                       ONLINE     ONLINE on myrac1d4
ora.myrac1d1.ASM1.asm                         ONLINE     ONLINE on myrac1d1
ora.myrac1d1.LISTENER_MYRAC1D1.lsnr           ONLINE     ONLINE on myrac1d1
ora.nmsis1d1.ons                              ONLINE     ONLINE on myrac1d1

Examples
The following command removes the listener LISTENER_MYRAC1D1 from the myrac1d1 node:

srvctl remove listener -n myrac1d1 -l LISTENER_MYRAC1D1

ORA-12012: error on auto execute of job : ORA-01878: specified field not found in datetime or interval

You may see the below errors in your alert log file after the daylight time changes if the job happens to run around
the time when the daylight time changes, which is 2 AM.

ORA-12012: error on auto execute of job 219820676
ORA-01878: specified field not found in datetime or interval

You can run the below queries to find out when the job was scheduled to run and who owns the job

select job ,to_char(LAST_DATE,'YYYYMMDD HH24:MI:SS'),to_char( NEXT_DATE ,'YYYYMMDD HH24:MI:SS') from dba_jobs where NEXT_DATE < sysdate;

select job, what, log_user, priv_user from dba_jobs where job=<job_number> ;

Connect to the database with the priv_user from the above query for that particular job and change the next_date manually by running the following

NOTE: If possible move the time of the job to away from 2 AM time, that is when the time change happens twice every year. I did moved the job to 04:00 AM so you are good for the future as well.

exec DBMS_JOB.NEXT_DATE(219820676,to_date('20130409 04:00:00','YYYYMMDD HH24:MI:SS')) ;