主页 > 分集介绍 > oracle带入dmp数据文件ORA01017错误处理

oracle带入dmp数据文件ORA01017错误处理

2020-03-12 16:29:58 作者:admin   |   浏览(126)

  即兴象:带入dmp文件时报错:

  imp system/system@dssq file=‘XXXX.dmp’ full=y ignore=y;

  IMP-00058: ORACLE error 1017 encountered

  ORA-01017: invalid username/password; logon deniedUsername:

  处理方法:

  alter user system identified

  by system account unlock

  修改完后带入成

  1、清空oracle共享池

  ALTER SYSTEM FLUSH

  SHARED_POOL

  2、检查以后oracle共享池的占用情景

  select * from v$sgastat

  3、修改日期输入为yyyy-mm-dd hh24:mi:ss程式

  alter session set

  nls_date_format='yyyy-mm-dd hh24:mi:ss'

  4、检查表数据量的父亲小

  SELECT SEGMENT_NAME,SUM(BYTES)

  FROM USER_SEGMENTS

  WHERE SEGMENT_NAME IN (SELECT

  TNAME FROM TAB WHERE TABTYPE='TABLE')

  GROUP BY SEGMENT_NAME;

  5、父亲表删摒除记载,每回删摒除1000条

  declare

  -- Local variables here

  i integer;

  begin

  while(true) loop

  -- Test statements here

  DELETE FROM tbilllog12 WHERE callend >=TO_DATE('20031205

  00:00:00','YYYYMMDD HH24:MI:SS') and rownum<1001;

  if(sql%notfound) then exit;

  end if;

  commit;

  end loop;

  end;

  6、数据库的展触动

  sql>start umount

  sql>alter database

  mount

  sql>start mount

  sql>alter database open

  7、检查经过对应的sql语句子

  SELECT SQL_Text FROM V$SQLTEXT

  A, V$SESSION B ,V$PROCESS C

  WHERE B.PAddr=C.Addr AND

  A.Hash_Value=B.SQL_Hash_Value AND C.SPID=''

  8、检查表的字段数

  select table_name,count(*)

  from user_tab_columns group by table_name

  9、修改oracle体系参数

  alter system set

  db_cache_size=900M scope=spfile;

  alter system set

  db_cache_size=900M scope=both;

  10.何以做debug不清雅察RAC运用了指定的IP地址

  $sqlplus " / as sysdba"

  $sqlplus>oradebug setmypid

  $sqlplus>oradebug ipc

  在$ORACLE_HOME/admin/ora92/udump检查最新的阿谁trace文件,看UDP的设置

  11.修改job的instance参数

  exec dbms_job.instance(222,1);

  commit;

  12.检查数据库经过情节的SQL语句子

  SELECT sql_text FROM v$sqltext a

  WHERE (a.hash_value, a.address) IN

  (SELECT DECODE (sql_hash_value,0,

  prev_hash_value,sql_hash_value),DECODE