ORA-27478: job "string.string" is running

Cause : An attempt was made to drop a job that is currently running.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Stop the job and then reissue the command, or reissue the command specifying the force option to stop the job first.

update : 29-06-2017
ORA-27478

ORA-27478 - job "string.string" is running
ORA-27478 - job "string.string" is running

  • ora-33214 : (CINSERT02) The workspace object dimension is too large.
  • ora-16716 : clearing parameter LOG_ARCHIVE_DEST failed
  • ora-23458 : inappropriate flavor string at string
  • ora-16785 : the database is not in ARCHIVELOG mode
  • ora-15127 : ASM file name 'string' cannot use templates
  • ora-40283 : missing cost matrix
  • ora-02719 : osnfop: fork failed
  • ora-38907 : DML error logging is not supported for FILE column "string"
  • ora-08342 : sropen: failed to open a redo server connection
  • ora-16156 : LGWR archive log dependency not allowed if database is standby protected
  • ora-28559 : FDS_CLASS_NAME is string, FDS_INST_NAME is string
  • ora-19507 : failed to retrieve sequential file, handle="string", parms="string"
  • ora-30342 : referenced level is not defined in this dimension
  • ora-01946 : DEFAULT TABLESPACE already specified
  • ora-26032 : index string.string loading aborted after string keys
  • ora-00355 : change numbers out of order
  • ora-12609 : TNS: Receive timeout occurred
  • ora-07227 : rtneco: unable to set noecho mode.
  • ora-30567 : name already used by an existing log group
  • ora-31441 : table is not a change table
  • ora-12014 : table 'string' does not contain a primary key constraint
  • ora-06027 : NETASY: channel close failure
  • ora-08180 : no snapshot found based on specified time
  • ora-33006 : (XSAGDNGL02) The relation workspace object is not related to itself.
  • ora-36210 : (XSAGOP05R) In AGGMAP workspace object, you can only specify the REMOPERATOR string with the PROPORTIONAL, EVEN, or HEVEN operators, not string.
  • ora-00469 : CKPT process terminated with error
  • ora-12088 : cannot online redefine table "string"."string" with unsupported datatype
  • ora-27196 : skgfpbk: sbtpcbackup returned error
  • ora-36155 : (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR.
  • ora-02314 : illegal use of type constructor
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.