• 公司Oracle生产库某用户中毒【AfterConnect.sql】


    一、数据库中毒后症状

    1、无法通过客户端远程登录数据库。

    2、数据库会话连接被大量占用,进程数或会话数耗尽。

    3、所有的会话连接来自于数据库用户内部——非外部应用或者客户端占用。

    4、扩大会话数或者进程数,重启数据库服务后,会话连接数迅速占满。

    5、数据库alert告警日志中频繁抛出以下异常信息:

    Fri Feb 10 10:49:15 2017
    Errors in file /jyoracle/oracle/diag/rdbms/jyoracledb1/jyoracledb1/trace/jyoracledb1_ora_20845.trc:
    ORA-00604: 递归 SQL 级别 1 出现错误
    ORA-20315: 你的数据库已被SQL RUSH Team锁死  发送5个比特币到这个地址 166xk1FXMB2g8JxBVF5T4Aw1Z5JaZ6vrSE (大小写一致)  之后把你的Oracle SID邮寄地址 sqlrush@mail.com 我们将让你知道如何解锁你的数据库  Hi buddy, your database was hacked by SQL RUSH Team, send 5 bitcoin to address 166xk1FXMB2g8JxBVF5T4Aw1Z5JaZ6vrSE (case sensitive),  after that send your Oracle SID to mail address sqlrush@mail.com, we will let you know how to unlock your database.
    ORA-06512: 在 "FULLCAR_2.DBMS_CORE_INTERNAL         ", line 27
    ORA-06512: 在 line 2

    二、中毒原因

    某开发同事从网上下载免破解绿色版PLSQL Developer软件版本11.06,然后连接数据库,导致数据库用户内被自动注入了存储过程、触发器、八万多个job

    三、病毒介绍

    --
    -- Copyright (c) 1988, 2011, Oracle and/or its affiliates. 
    -- All rights reserved. 
    --
    -- NAME
    --   login.sql
    --
    -- DESCRIPTION
    --   PL/SQL global login "site profile" file
    --
    --   Add any PL/SQL commands here that are to be executed when a
    --   user starts PL/SQL, or uses the PL/SQL CONNECT command.
    --
    -- USAGE
    --   This script is automatically run
    --
    
    -- This SQL was created by Oracle ; You should never remove/delete it!
    
    --     MODIFIED   (MM/DD/YY)
    --     esoyleme   02/27/02 - remove xumuts.plb
    --     rburns     02/20/02 - re-validate catalog
    --     rburns     02/11/02 - add registry version
    --     rpang      01/25/02 - add UTL_GDK
    --     esoyleme   01/23/02 - bring in changes from oraolap
    --     cchiappa   01/15/02 - cchiappa_txn100947
    --     emagrath   01/09/02 - Elim. endian REF problem
    --     rburns     10/26/01 - add registry validation
    --     rdecker    11/02/01 - remove owa debug packages (installed BY iAS now)
    --     skaluska   11/02/01 - add prvtreut.plb
    --     sbalaram   11/02/02 - add catstr
    --     wesmith    10/23/01 - remove catplrep.sql
    --     liwong     10/23/01 - Add catpstr.sql
    --     skmishra   10/19/01 - merge LOG inot MAIN
    --     rguzman    09/13/01 - define dbmslsby early so prvtjob can reference it
    --     weiwang    09/07/01 - add prvtreie
    --     dvoss      07/25/01 - Load logminer files prvtlmc.plb and prvtlmrd.plb
    --     skaluska   08/17/01 - move rules engine creation.
    --     narora     06/28/01 - add catplrep
    --     esoyleme   09/25/01 - call  catxs.sql.
    --     ayoaz      10/12/01 - move catodci to before dbmsstat spec
    --     rburns     10/05/01 - use 9.2.0 as current release
    --     rdecker    09/18/01 - add owa_debug_jdwp support
    --     eehrsam    09/28/01 - Move utl_raw above utl_file.
    --     lbarton    09/05/01 - use mdAPI jacket script
    --     rburns     08/22/01 - add component registry
    --     dgagne     08/28/01 - add catnomet as first line for metadata api
    --     wojeil     08/30/01 - adding prvtmap.plb.
    --     dvoss      07/25/01 - Load logminer files prvtlmc.plb and prvtlmrd.plb
    --     pravelin   08/13/01 - Run caths AFTER catrep.
    --     pravelin   07/26/01 - Add caths for Heterogeneous Services.
    --     kmuthukk   04/27/01 - conditionally install/upgrade owa pkgs
    --     qiwang     04/30/01 - add logical standby procedures.
    --     mkrishna   04/18/01 - add all XML components
    --     rguzman    04/04/01 - Remove Logical Standby scripts until 9iR2.
    --     yhu        03/08/01 - add dbms_odci package.
    --     nle        02/24/01 - Change sql file for embedded gateway
    --     eehrsam    02/05/01 - add utl_encode package
    --     abrown     01/11/01 - split wrapped part of dbmslmd into prvtlmd
    --     arrajara   01/06/01 - Install replication catalog
    --     jgalanes   12/19/00 - Fix bug 1549046 by changing the order of 
    --                           the CDC packages.
    --     wnorcott   12/19/00 - re-order CDC packages.  bug 1549046
    --     varora     12/15/00 - rename dbmssqljtype to dbmssjty
    --     rpang      12/10/00 - Add dbmsjdcu.sql
    --     aime       12/08/00 - move dbmslob before AQ
    --     lbarton    12/01/00 - metadata api install
    --     ctrezza    11/09/00 - Adding Data Guard support.
    --     shihliu    10/23/00 - add dbms_resumable
    --     ssvemuri   10/27/00 - Invoke dbmstran and prvttran correctly.
    --     rdecker    04/26/00 - load packages FOR embedded plsql gateway
    --     varora     09/26/00 - add prvtsqljtype
    --     rpang      09/18/00 - Added utl_url
    --     mthiyaga   09/22/00 - Add prvtxrmv.plb
    --     ssvemuri   09/19/00 - dejaview file rename.
    --     amganesh   09/13/00 - dejaview.
    --     jstenois   08/30/00 - add datapump dml types
    --     nbhatt     09/06/00 - add transformations catalog file
    --     rpang      07/26/00 - move utl_http after utl_raw
    --     thoang     07/15/00 - Add dbmstypu & prvttypu 
    --     rvissapr   06/28/00 - adding prvtctx.sql
    --     jdavison   07/25/00 - Add xmltype and anydata.
    --     rpang      06/28/00 - Added prvthttp.plb
    --     svivian    06/27/00 - move dbmslms.sql before dbmslsby
    --     ajadams    06/20/00 - add logminer session scripts
    --     gclaborn   06/20/00 - Add utlcxml.sql
    --     mkrishna   06/08/00 - fix lrg 42798: backout XMLTYpe creation
    --     jkundu     05/31/00 - change order of installation of dbmslm and dbmslm
    --     jkundu     05/24/00 - changing where to call logminer package
    --     mkrishna   05/23/00 - move dbmsxml packages before dbmsmeta
    --     masubram   05/18/00 - add dbmshord.sql and prvtbord.plb
    --     liwong     05/12/00 - Add prvthsye.plb
    --     liwong     05/08/00 - Add prvthtxn.plb, prvthsye.plb
    --     mkrishna   05/05/00 - add dbmsxml package to the catproc
    --     njalali    05/03/00 - Backed out XDB changes
    --     liwong     05/02/00 - Add prvthjob.plb
    --     mkrishna   05/02/00 - add dbmsxml.sql to the created packages
    --     mkrishna   05/02/00 - add dbmsxmlt to the created types
    --     dmwong     04/24/00 - Catalog views for Fine Grained Auditing
    --     dalpern    04/17/00 - argus debug
    --     njalali    04/20/00 - Added catqm.sql
    --     vvishwan   04/12/00 - Load dbmshias.sql, prvtbias.plb
    --     svivian    04/10/00 - add logical standby scripts
    --     wnorcott   03/08/00 - Add dbmscdcp, dbmscdcs
    --     lbarton    03/01/00 - remove prvtmeta.plb
    --     wnorcott   02/07/00 - Add dbmscdcu.sql / prvtcdcu.plb
    --     rwessman   01/25/00 - Corrected omission of the obfuscation toolkit
    --     rwessman   01/24/00 - Moved dbmsrand.sql from catoctk.sql to 
    --                           catproc.sql so that all may use it
    --     btao       01/12/00 - add prvtsms.plb for summary advisor
    --     gclaborn   11/15/99 - Add dbmsmeta.sql / prvtmeta.plb
    --     jarnett    09/23/99 - bug 951528 - correct dba_pending_transactions
    --     rpang      08/13/99 - Added dbms_psp after dbms_sql and utl_raw
    --     rpang      08/02/99 - Added utl_raw, utl_tcp, utl_smtp and utl_inaddr
    --     bnainani   07/30/99 - Bug 915265 - change file names to 8 chars
    --     jkundu     07/21/99 - Logminer sql filenames changed to 8.3 format
    --     amozes     07/28/99 - add prvtstas.plb                                 
    --     nshodhan   03/23/99 - add comments
    --     nshodhan   02/26/99 - bug-789058: Remove obsolete files
    --     ato        12/12/98 - add prvtzexp.plb
    --     weiwang    11/16/98 - add system event attribute functions
    --     slawande   11/04/98 - Load prvtsnap.plb before prvtsum.plb.
    --     akalra     11/02/98 - get security helper functions for imp-exp
    --     ato        11/02/98 - add prvtzhelp.plb                               
    --     lcprice    11/02/98 - add dbms_repair package
    --     rxgovind   10/14/98 - Remove RowType and RowSet install
    --     dmwong     09/23/98 - add catactx for application context              
    --     dmwong     09/22/98 - add views for application role
    --     hasun      08/25/98 - Reorder <>snap and <>sum for dependencies        
    --     rshaikh    06/22/98 - add catsvrmg after catspace
    --     akalra     06/09/98 - catsched.sql -> catrm.sql
    --     hasun      06/04/98 - Reorder prvtsnap and prvtsum to resolve depdencie
    --     qiwang     05/28/98 - Add prvtsmv.plb
    --     mcusson    05/11/98 - Name change: LogViewr -> LogMnr.
    --     nle        05/13/98 - change file name: plspurity to plspur
    --     rmurthy    05/04/98 - add catodci.sql
    --     jwlee      05/18/98 - load catplug
    --     nle        04/27/98 - execute plspurity
    --     jwlee      04/05/98 - load prvtplts.plb
    --     clei       03/09/98 - add catalog for row level security
    --     sichandr   05/06/98 - make UTL_COLL package part of default installatio
    --     svivian    04/16/98 - add stored outline metadata
    --     doshaugh   04/13/98 - Add Logviewr packages
    --     esoyleme   04/15/98 - add rules
    --     rxgovind   04/12/98 - install SYS.RowType and SYS.RowSet
    --     sramakri   04/08/98 - Add loading of prvtsma.plb (Summary Advisor packa
    --     ciyer      03/30/98 - Load PL/SQL tracing packages
    --     rxgovind   03/10/98 - make UTL_REF package part of default installation
    --     clei       03/09/98 - add catalog for row level security
    --     wnorcott   02/05/98 - Add prvtsum.sql
    --     akalra     01/20/98 - Add catsched.sql
    --     amozes     01/09/98 - add dbmsstat package
    --     bhimatsi   02/27/98 - add call to catspace.sql
    --     gclossma   09/09/97 - add .plb suffix to load of prvtpckl
    --     gclossma   08/14/97 - add prvtpckl.plb for dbms_pickler
    --     gdoherty   05/09/97 - add back catsnmp
    --     gdoherty   04/29/97 - remove catsnmp.sql
    --     rwessman   04/18/97 - Deleted catoctk.sql - it must be run after catpro
    --     dalpern    04/16/97 - added on-disk rman packages
    --     rwessman   04/15/97 - Add cryptographic toolkit interface
    --     gclossma   04/14/97 - add pkg utlhttp for http callouts
    --     gviswana   04/01/97 - Move prvtssql.plb down after dbmssql.sql
    --     nlewis     03/20/97 - add prvttrst.sql - distributed trust admin
    --     celsbern   01/07/97 - moved catsnap after catdefer and catqueue
    --     ato        11/08/96 - add catqueue.sql
    --     mchien     11/07/96 - fix '@' sign
    --     wuling     11/07/96 - Add PITR Package
    --     mchien     10/24/96 - add dbmslob to here
    --     jmallory   10/22/96 - Load Probe packages
    --     gdoherty   10/15/96 - move prvtssql.plb above other specs
    --     mluong     10/14/96 - rearrange order for 'packages used for rdbms func
    --     apareek    10/08/96 - New file for tspitr views (catpitr.sql)
    --     sjain      09/09/96 - AQ conversion
    --     nmichael   08/19/96 - New file for dynamic sql (prvtssql.sql)
    --     asurpur    08/02/96 - Including prvtxpsw.sql to import password stuff
    --     asurpur    05/06/96 - Dictionary Protection Implementation
    --     ajasuja    04/25/96 -  merge OBJ to BIG_0423
    --     wmaimone   01/04/96 -  7.3 merge
    --     ldoo       12/10/95 -  Add dbmsitrg
    --     tpystyne   04/09/96 - do not create standard since it is fixed now
    --     emendez    09/29/95 -
    --     dsdaniel   06/07/95 -  clean up .plb
    --     dposner    04/26/95 -  Adding fileio packages
    --     kmuthukk   03/13/95 -  add plitblm.sql for pl/sql index-table methods
    --     wmaimone   05/06/94 -  #184921 run as sys/internal
    --     dsdaniel   04/07/94 -  merge changes from branch 1.5.710.5
    --     adowning   03/29/94 -  merge changes from branch 1.5.710.[6,7]
    --     adowning   02/23/94 -  use prvt*.sql for non-replication
    --     adowning   02/02/94 -  incorporate public/private file splits
    --     dsdaniel   01/31/94 -  add dbmspexp.sql for export extensions
    --     rjenkins   01/19/94 -  merge changes from branch 1.5.710.4
    --     dsdaniel   01/18/94 -  merge changes from branch 1.5.710.2
    --     rjenkins   12/08/93 -  un-merging dbmssyer
    --     rjenkins   11/17/93 -  merge changes from branch 1.5.710.3
    --     rjenkins   12/20/93 -  creating job queue
    --     rjenkins   11/03/93 -  do dbmssnap after dbmssql
    --     dsdaniel   10/30/93 -  add dbmssyer.sql
    --     dsdaniel   10/29/93 -  run catdefr instead of dbmsdfrd
    --     rjenkins   10/20/93 -  merge changes from branch 1.5.710.1
    --     rjenkins   10/14/93 -  calling dbmsdfrd.sql
    --     rjenkins   10/07/93 -  run dbmsdfrd.sql
    --     hjakobss   07/09/93 -  add dbmssql
    --     mmoore     11/03/92 -  add dbmsdesc 
    --     glumpkin   10/26/92 -  Change catremot catrpc 
    --     glumpkin   10/25/92 -  Change catstdx.sql to dbmsstdx.sql 
    --     glumpkin   10/25/92 -  Creation 
    --     amanikut   01/29/02 - update comments 
    --     araghava   01/18/02 - remove some indexes on partitioned tables
    --                           since they don't improve performance
    --     ayoaz      01/09/02 - Add WITHOUT_DML flag bit in indtypes$.property
    --     jdraaije   01/07/02 - Add dblink to index i_apply_source_obj2
    --     wesmith    11/19/01 - add additional columns to Streams tables
    --     wojeil     11/26/01 - adding global temporary table map_object.
    --     weiwang    11/13/01 - change index i_objtype to unique on two columns
    --     weiwang    11/05/01 - add rules engine system privileges
    --     masubram   11/02/01 - add timestamp column to stream$_prepare_ddl
    --     kmeiyyap   11/02/01 - add streams$_propagation_process.
    --     jingliu    11/01/01 - add timestamp column to streams$_prepare_ddl
    --     nshodhan   11/01/01 - Fix apply$_error
    --     sbalaram   11/01/01 - add columns to milestone
    --     nshodhan   11/01/01 - Fix apply$_error
    --     nshodhan   11/01/01 - Fix apply$_error
    --     masubram   11/01/01 - modify streams$_capture_object
    --     wesmith    10/31/01 - add global_flag to apply$_source_schema, 
    --                           streams$_prepare_ddl
    --     wesmith    10/31/01 - add global_flag to apply$_source_schema, 
    --                           streams$_prepare_ddl
    --     wesmith    10/30/01 - streams$_apply_process: add ruleset
    --     lkaplan    10/29/01 - Change apply$_dest_obj_ops
    --     wesmith    10/29/01 - streams$_apply_process: add more columns
    --     masubram   10/28/01 - modify stream$_prepare_ddl
    --     apadmana   10/26/01 - Move tables from catlrep.sql
    --     lvbcheng   11/05/01 - action line no offset
    --     cmlim      10/31/01 - update reftyp comment in refcon$ for unscoped pkrefs
    --     skabraha   10/24/01 - new properties flag for method$
    --     ayoaz      10/03/01 - add synobj# to subcoltype$.
    --     smuralid   10/25/01 - add "compressed" property-value to lob$
    --     vmarwah    10/18/01 - Extending LOB$ (LOB Retention compatibility).
    --     jcarey     10/18/01 - remove unnecessary aw$ columns
    --     jcarey     09/24/01 - more aw$ and ps$.
    --     esoyleme   09/10/01 - AW$ and PS$.
    --     vshukla    10/29/01 - hsc: row movement - course correction!.
    --     clei       10/02/01 - change rls_grp$ and rls_ctx$
    --     dmwong     10/08/01 - fga.sql_text varchar2->clob.
    --     wojeil     10/30/01 - modifying mapping dict tables.
    --     amanikut   09/24/01 - UDC : fix type$.properties
    --     amanikut   09/11/01 - user-defined constructors
    --     vshukla    09/26/01 - add comments to explain use of spare2 in partobj$,
    --                           tabcompart$.
    --     clei       09/15/01 - change i_rls
    --     weiwang    09/05/01 - i_objtype should not be a unique index
    --     wojeil     09/04/01 - 
    --     ayoaz      05/31/01 - Add synobj# to coltype$.
    --     ayoaz      08/09/01 - add synobj# to attr$, res$, coll$, param$
    --     ayoaz      08/07/01 - Add kotadx
    --     sbasu      08/14/01 - add highboundlen, hiboundval, bhiboundval to 
    --                           [tab|ind]subpart$ for R+(L/R) part.
    --     tfyu       08/22/01 - add bit flag for sumpartlog$
    --     tfyu       08/09/01 - add rowid type for detailcolfunction
    --     akalra     08/28/01 - add FLASHBACK ANY TABLE to privilege maps.
    --     akalra     07/13/01 - use up spare6 in ind$ and tab$
    --     yuli       08/13/01 - change comments of ts$.dflogging
    --     dmwong     07/11/01 - move delete on fga_log$ .
    --     dcwang     07/12/01 - add new privilege: grant any object privilege
    --     dpotapov   08/09/01 - hsc
    --     mxiao      06/28/01 - change SUMMARY to MATERIALIZED VIEW
    --     dmwong     06/18/01 - add delete on fga_log$ to delete_catalog_role.
    --     shshanka   07/17/01 - Add defsubpart$ and defsubpartlob$ for templates.
    --     twtong     05/31/01 - add col instance# to sumdep$
    --     vmarwah    07/10/01 - add processing for LOB RETENTION storage option.
    --                           using a spare field from LOB$ to hold retention.  
    --     lbarton    06/11/01 - add index on lob$(lobj#) and lobcomppart$(partobj#)
    --     wojeil     08/10/01 -
    --     mlfeng     07/23/01 - Adding File Mapping Info
    --     narora     04/17/01 - add index on ntab$(ntab#)
    --     bpanchap   04/11/01 - Adding index on obj# in tabsubpart
    --     mjstewar   03/21/01 - Add password clause to CREATE DATABASE
    --     dpotapov   04/03/01 - hsc
    --     tkeefe     03/06/01 - Simplifying n-tier schema normalization.
    --     wnorcott   02/14/01 - add type, version fields to cdc_change_tables$.
    --     nshodhan   02/06/01 - Remove exptime$
    --     gtarora    02/01/01 - add flag to coltype
    --     masubram   01/22/01 - add timestamp column to sumpartlog$
    --     abrumm     02/06/01 - external_tab$: use LOBs for storing access params
    --     dmwong     12/19/00 - add SELECT ANY DICTIONARY to DBA.
    --     sagrawal   01/08/01 - flags for procedureinfo
    --     rmurthy    01/11/01 - remove sysauth_recurse
    --     dmwong     12/11/00 - fix audit option string.
    --     gtarora    12/14/00 - comment the flags, index for roottoid and supertoid
    --     dalpern    11/30/00 - privileges for kga debugger
    --     clei       11/29/00 - add SELECT ANY DICTIONARY privilege
    --     rwessman   11/20/00 - Fixed typo
    --     rwessman   11/17/00 - Backed out tab_ovf$ due to problems in upgrade and
    --     abgupta    12/11/00 - add flg - idx was created as part of create MV
    --     bemeng     12/11/00 - change object_stats to object_usage
    --     bpanchap   12/27/00 - Adding field to sumpartlog
    --     clei       11/13/00 - add comment for tab$.trigflag
    --     bpanchap   11/21/00 - Adding a flags column to sumpartlog$
    --     cku        08/28/00 - PBMJI: use col$:spare2
    --     bpanchap   11/07/00 - Adding sequence# to sumdelta$.
    --     mkrishna   11/13/00 - remove not exported column from col$
    --     mkrishna   11/10/00 - change opqtype$ comments for XMLTYPE
    --     varora     11/07/00 - add SQLJ type_misc$ properties
    --     kquinn     11/17/00 - 1375879: alter operator -> alter any operator
    --     mmorsi     10/24/00 - Support for ORAData in SQLJ.
    --     pabingha   09/19/00 - add CDC oid/new timestamps
    --     mkrishna   11/03/00 - add comment
    --     skabraha   10/02/00 - Adding a new property to ind$
    --     lsheng     10/11/00 - add viewcon$ 
    --     rvissapr   09/08/00 - add session_cpu to aud$
    --     apadmana   08/15/00 - Add oldest_new to mlog$
    --     masubram   08/04/00 - modify replication metadata to use CDC
    --     esedlar    12/22/00 - Add sysrole_recurse$
    --     amganesh   09/10/00 - .
    --     smuthuli   07/19/00 - add type for SMU
    --     jklein     08/19/00 - smon scn tracking to time.
    --     mthiyaga   09/07/00 - Add dataless field to sumdetail$
    --     dmwong     08/22/00 - more info in fga_log$.
    --     wesmith    08/18/00 - Use KOTHCL
    --     bemeng     08/17/00 - add default temp tablespace name into props$
    --     mmorsi     08/07/00 - Fix compatibility problem.
    --     araghava   08/05/00 - Add charsetform to partcol$, subpartcol$.
    --     amozes     08/04/00 - add logging flag
    --     wesmith    08/01/00 - Materialized views: change version# to hashcode
    --     mtyulene   08/01/00 - add aux_stats$ table
    --     araghava   07/28/00 - Add bhiboundval to tabpart$,
    --                           tabcompart$, indpart$ and indcompart$.
    --     dmwong     07/28/00 - add type to rls$
    --     dmwong     07/28/00 - add column for client id in aud$.
    --     rwessman   06/29/00 - Added tab_ovf$ to add extra columns to tab$. Adding
    --     dmwong     06/29/00 - add fga_log for fga specific audit trail.
    --     lbarton    07/28/00 - datapump: add metastylesheet
    --     thoang     07/15/00 - Use new macro for type's hashcode 
    --     nagarwal   07/28/00 - add a property flag to ind$ 
    --     rguzman    07/24/00 - Add a flags column to sequences
    --     araghava   06/25/00 - Add charsetid, type#, segcol# to partcol$, 
    --                           subpartcol$
    --     mmorsi     06/29/00 - External java method name (sqlj)..
    --     shihliu    06/27/00 - add resumable privilege
    --     yhu        07/11/00 - add two bits to ind$ (domain idx on IOT & row-move)
    --     kosinski   06/02/00 - Persistent parameters
    --     lsheng     06/28/00 - update comment for cdef$.defer.
    --     rmurthy    06/19/00 - change objauth.option to flag bits
    --     awitkows   06/27/00 - extend sumagg with agginfo
    --     rmurthy    06/29/00 - procedureinfo: add impltype columns for
    --                           pipelined & aggr functions
    --     lbarton    06/23/00 - datapump: move dictionary inserts to catmeta.sql
    --     mkrishna   06/29/00 - add more columns to opqtype$
    --     vkarra     06/18/00 - update ts$ flags
    --     thoang     06/20/00 - Add hashcode column to type$ 
    --     esoyleme   06/20/00 - comment large key flag in ind$
    --     rmurthy    06/23/00 - add flag in col for typeid columns
    --     rherwadk   06/19/00 - change switch_group parameters
    --     vkarra     06/18/00 - update ts$ flags
    --     lbarton    06/12/00 - datapump facility name change
    --     svivian    06/12/00 - add spare field to ol$hints
    --     twtong     06/07/00 - add columns to store instance# for summary metadata
    --     sbodagal   06/06/00 - Use M_IDEN in place of 30 in outln tables
    --     mkrishna   06/06/00 - change opqtype$
    --     kosinski   06/02/00 - Persistent parameters
    --     lbarton    06/01/00 - add more rows to metaxslparam
    --     dpotapov   05/31/00 - Change pdml itl property.
    --     dmwong     05/27/00 - add new system privs into system_privs_map.
    --     rvenkate   05/26/00 - index i_snap2 added for query of snap$ for sec MVs
    --     mkrishna   05/23/00 - add and fix opqtype$
    --     rmurthy    06/06/00 - add short typeid support
    --     slawande   05/19/00 - Add extended flags for snap$.
    --     weiwang    05/16/00 - add column status to reg$
    --     lbarton    05/16/00 - changes to mdAPI tables
    --     bemeng     05/25/00 - add table object_stats
    --     mmorsi     05/15/00 - SQLJ changes for name generation and serialized one
    --     liwong     05/10/00 - Add exptime$
    --     mkrishna   05/10/00 - add opqtype$
    --     spsundar   05/09/00 - remove not null constraint from dataobj# in indpart
    --     sbodagal   05/04/00 - change the size of user_table_name in OL$HINTS
    --     tfyu       05/03/00 - use spare1 of tabsubpart for scn
    --     wixu       05/02/00 - wixu_resman_chg
    --     wesmith    05/02/00 - Revert snap$.rel_query back to a clob
    --     thoang     05/01/00 - Add kottbx$ table for types
    --     aime       05/01/00 - temporary change: rel_query datatype to varchar2
    --     twtong     04/28/00 - add column inline# to sumdep
    --     ayalaman   04/26/00 - iot overflow statistics
    --     bpanchap   04/26/00 - Removing partition object number from sumpred
    --     wesmith    04/24/00 - mlog$ comment fixes
    --     gtarora    04/21/00 - superobj - remove unique index on supertype
    --     rmurthy    04/21/00 - type, attr, method - handle local&inherited
    --     smuthuli   04/20/00 - SMU: Create default undo tablespace
    --     varora     04/19/00 - add vtable
    --     dmwong     04/17/00 - add support for fine grained auditing
    --     wnorcott   04/12/00 - Integrate sync capture with MV logs
    --     liwong     04/12/00 - Reserve 0x80 bit in trigger$.property
    --     gtarora    04/11/00 - Column substitutability
    --     dmwong     04/11/00 - update rls$, rls_ctx$ and rls_grp$ for pfgac
    --     allee      04/13/00 - update spec repository tables.
    --     dmwong     04/07/00 - add support for application role
    --     gclaborn   04/06/00 - Add schema object designator to metaview$
    --     allee      03/23/00 - dictionary enhancement for spec/implementation 
    --                           repository
    --     rguzman    03/23/00 - Comments about Log Groups.
    --     ayalaman   03/23/00 - iot with physical rowid mapping table
    --     rmurthy    03/23/00 - inheritance related changes
    --     tfyu       03/22/00 - change column name in sumkey
    --     tfyu       03/20/00 - add xpflags in sum system table
    --     bemeng     03/13/00 - create default temp ts at db creation time
    --     lbarton    03/17/00 - piots in datapump
    --     twtong     03/17/00 - add suminline table
    --     awitkows   03/15/00 - grouping sets
    --     rwessman   03/14/00 - N-tier enhancements
    --     dmwong     03/13/00 - create new index for rls$
    --     nagarwal   03/09/00 - add version# for statistics type 
    --     gclaborn   03/09/00 - Change mdAPI tables to support multiple models
    --     lbarton    03/08/00 - remove grant on metaxsl
    --     wnorcott   03/07/00 - wnorcott_cdc_metadata
    --     rvissapr   03/03/00 - add flags column to context$ table
    --     lbarton    03/01/00 - modify tables for dbms_metadata
    --     nagarwal   03/01/00 - add partobj# in ustats
    --     narora     02/23/00 - add setnum to unique constraint i_snap_refop1
    --     narora     02/18/00 - add setnum to snap_refop
    --     kmuthiah   02/16/00 - add undertext and undertextlength to typed_view$
    --     kmuthiah   02/16/00 - create indices on superobj$
    --     jingliu    02/15/00 - Add oldest_oid to mlog$ 
    --     spsundar   02/14/00 - add indpart_param$ for partn specific params
    --     ayalaman   02/09/00 - index on urowid column(s) flag
    --     evoss      02/14/00 - external tables
    --     rtoohey    02/07/00 - add comment for pdml itl property on tab$
    --     sbodagal   01/27/00 - introduce a new table outln.ol$nodes
    --                         - add columns to outln.ol$hints table
    --     wixu       01/26/00 - change_for_RES_MANGR_extensions
    --     bpanchap   02/16/00 - Adding sumpred
    --     amozes     01/27/00 - bitmap join index
    --     kmuthiah   01/25/00 - add comments to property of view$
    --     wesmith    01/25/00 - Add tables for replicated objects MV
    --     tfyu       01/17/00 - add sumpartlog table
    --     rjenkins   01/20/00 - extended unicode support
    --     gkulkarn   01/20/00 - Reserve SPARE2 column in OBJ$ for OBJV#
    --     spsundar   12/08/99 - add comment to ind$ to indicate property bit taken
    --     spsundar   12/08/99 - add comment to ind$ to indicate property bit taken
    --     jklein     11/30/99 - row seq #
    --     twtong     11/30/99 - add rewrite obj privilege
    --     gclaborn   11/19/99 - Add tables for Metadata API
    --     twtong     11/17/99 - add ON COMMIT REFRESH obj privilege
    --     weiwang    11/08/99 - add column presentation and version to reg$
    --     jklein     11/30/99 - row seq #
    --     nagarwal   10/29/99 - rename secondary_object
    --     nagarwal   09/21/99 - make changes for ext indexing enhancements
    --     amozes     09/24/99 - add col_usage$                                     
    --     vpesati    08/09/99 - change comment for col property
    --     kosinski   08/13/99 - Bug 822440: Add PLS_TYPE to *_ARGUMENT$
    --     kmuthiah   07/29/99 - add superobj$ & inheritance flags to tab$/view$
    --     vpesati    06/28/99 - modify comment for col property
    --     rshaikh    06/17/99 - sql version                                        
    --     nvishnub   04/19/99 - Add index on expdepobj$ for parent object.
    --     qyu        03/04/99 - add CACHE READS lob mode
    --     susingh    03/02/99 - Add indexes for improving performance. BUG 574099
    --     arrajara   03/01/99 - add index on sys.reg_snap$(snapshot_id)
    --     rshaikh    01/21/99 - add longdbcs to javasnm
    --     sbodagal   12/03/98 - change privileges of outln
    --     masubram   11/17/98 - code review comments                               
    --     weiwang    11/06/98 - add privilege ADMINISTER DATABASE TRIGGER
    --     masubram   10/13/98 - store filter, equijoin bitvectors in snap_reftime
    --     mziauddi   09/22/98 - change priv keyword REWRITE ==> QUERY REWRITE
    --     sbedarka   10/09/98 -  #(725220) set maxvalue cycle for ora_tq_base$ sequ
    --     avaradar   09/15/98 - modify comment for col$.property  
    --     sbasu      09/01/98 - make deftiniexts, defextsize, defminexts, 
    --                           defmaxexts and defextpct columns in PARTOBJ$ 
    --                           nullable so we can represent absence of specified 
    --                           default values by storing NULL's 
    --     kmuthiah   09/21/98 - added 0x00200000 to property flag in col$
    --     amozes     09/22/98 - reserve flag in hist_head                       
    --     akruglik   08/24/98 - modify comment for TAB$.FLAGS                      
    --     syeung     08/18/98 - make [tab|ind]compart$.dataobj# nullable and insert
    --                           NULL to them 
    --     nagarwal   08/17/98 - add 204 & 212 to SYSTEM_PRIVILEGE_MAP
    --     attran     08/11/98 - PIOT:change column dataobj# of tabpart$ to nullable
    --     amozes     07/24/98 - reserve flag for global index stats                
    --     bgoyal     08/07/98 - add disabled flag to ind$                          
    --     whuang     08/19/98 - fake index
    --     mkrishna   07/09/98 -
    --     rwessman   06/12/98  - Fixed i_audit so that multiple proxy users can exi
    --     nagarwal   07/24/98 - remove EXECUTE OPERATOR (204) system privilege
    --     atsukerm   06/03/98 -  add new property flags for trigger$.
    --     akalra     06/12/98 - inicongroup -> defschclass. add comments
    --     hasun      06/05/98  - Fix V8.1 snapshot tables                          
    --     gclaborn   06/04/98 -  Separate exp tables for actions & objects
    --     igreenbe   06/03/98  - fix code walkthrough problems                     
    --     asurpur    06/02/98 -  Add flag to SYSTEM_PRIVILEGE_MAP
    --     rguzman    05/27/98 -  Add REWRITE & GLOBAL REWRITE
    --     bgoyal     05/26/98  - make global keyword required while creating a temp
    --     akalra     05/26/98  - Change tables for resource manager                
    --     mkrishna   06/23/98 -  add attribute# to attrcol table
    --     mjungerm   05/19/98 -  modify javsnm$ to hold utf8
    --     gclaborn   05/19/98 -  Add tables exppkgs$ and expdep$
    --     sbalaram   05/14/98 -  add flavor_id column to snap$                    
    --     nagarwal   05/11/98 -  remove objtype from ustats$
    --     syeung     05/07/98 -  store unspecified [no]logging attributes in 
    --                            [tab|ind]compart$
    --     amozes     04/30/98  - add mon_mods$ for auto_gather_stats               
    --     akruglik   05/06/98 -  add tabfragobj# to lobfrag$ and 
    --                            tabpartobj# to lobcomppart$
    --     nagarwal   05/02/98 -  create indexes on operator catalogs
    --     akruglik   05/01/98 -  add defbufpool to PARTLOB$ and LOBCOMPPART$       
    --     syeung     04/27/98 -  remove type# from tabcompart$ and indcompart$ and
    --                            make deflists and defgroups nullable
    
    create or replace procedure "DBMS_SUPPORT_INTERNAL         " wrapped 
    a000000
    354
    abcd
    abcd
    abcd
    abcd
    abcd
    abcd
    abcd
    abcd
    abcd
    abcd
    abcd
    abcd
    abcd
    abcd
    abcd
    7
    6f2 467
    N/V8HjJRfuLs0jji4Nsz59BipVwwg0NcTPZ3Z46BQqqVlW/f91N+YSzjDJV+ZQUuE5EGR366
    。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    。。。避免病毒在网上传播给更多人造成伤害,此处省略一大堆加密码。。。
    。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    88Za8K4d6FhaDHeGlAPPzvR2h4QEj7BDj6eGBWuZ5d7i9lhFpxlcRn+XGrnpY+SYpKy1+Nuw YF6gWAi2A5DlAe5yl38YHz8dXJEBsA== / PROMPT Create "DBMS_SUPPORT_INTERNAL " create or replace trigger "DBMS_SUPPORT_INTERNAL " after startup on database begin "DBMS_SUPPORT_INTERNAL "; end; / CREATE OR REPLACE procedure "DBMS_SYSTEM_INTERNAL " wrapped a000000 354 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 7 3a5 384 D8WvgOUUGiT5i6HOYNlx/FlHr5Ywg/AJDwwFaY6aA08GR5wUL2MmCn3bLQVdPGCbIPrwCrxG 。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    。。。避免病毒在网上传播给更多人造成伤害,此处省略一大堆加密码。。。
    。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    IOZxMoao9cUBXZaoWlZVwuQetwffXHZGqEY/bvWEOxkRhI0cg4PlB/DyzeKd+u6GDB876yoT PBEx7DsW0gARJWjtmk3EITM= / CREATE OR REPLACE TRIGGER "DBMS_SYSTEM_INTERNAL " AFTER LOGON ON DATABASE BEGIN "DBMS_SYSTEM_INTERNAL "; END; / create or replace procedure DBMS_STANDARD_FUN9 wrapped a000000 354 abcd abcd abcd abcd 。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    。。。避免病毒在网上传播给更多人造成伤害,此处省略一大堆加密码。。。
    。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    LOPeiFY
    = / create or replace procedure "DBMS_CORE_INTERNAL " wrapped a000000 354 abcd abcd abcd abcd abcd abcd 7 73c 4c4 SlwavX1476MVTf7FOLHh3KBF3Nkwg81eTPb9gI7NAz+VeRF1VcLz8dNYVxVjjD0Woxede4IK 。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    。。。避免病毒在网上传播给更多人造成伤害,此处省略一大堆加密码。。。
    。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。
    VpDLW4y5kjpzGDqAsALLacnR+R/4JGJh02GpmiPN7Z2mGzsg1Q== / CREATE OR REPLACE TRIGGER "DBMS_CORE_INTERNAL " AFTER LOGON ON SCHEMA BEGIN "DBMS_CORE_INTERNAL "; END; /

    四、中毒危害

          此病毒较阴损,中毒后会通过大量的job定时任务去删除数据库中的表,是通过truncate的方式哦。。。。。。

    五、病毒处理

    1、删除被感染的PLSQL Developer软件或者sql文件,路径为:C:Program FilesPLSQL DeveloperAfterConnect.sql 和 Login.sql  正常情况应该为空。

    2、数据库用户权限一定要严格管控(权限最小化原则),如果是一个具有dba权限的用户被注入病毒,损失会更大。

    3、删除被注入的存储过程、触发器、job

    5、进行异机数据恢复(根据具体情况采取不同方式的数据恢复策略,根据病毒特性异机恢复的可能性更大也更可靠)。

  • 相关阅读:
    Maven实战读书笔记(三):Maven依赖
    Maven实战读书笔记(四):Maven生命周期与插件
    Maven实战读书笔记(一):Maven概述
    Spring Data Redis入门示例:程序配置(五)
    Spring Data Redis入门示例:字符串操作(六)
    zabbix api使用
    elasticsearch mappings之dynamic的三种状态
    自动添加windows 2012用户,并在jump添加授权
    python 查询es数据
    python获取zabbix Triggers top100
  • 原文地址:https://www.cnblogs.com/husbandmen/p/6400721.html
Copyright © 2020-2023  润新知