Tuesday, April 16, 2013

orcale 11g–error log 1

orcale sql error log 1:

C:\Windows\system32>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on 星期二 4月 16 15:14:49 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:
ORA-12560: TNS: 协议适配器错误





fixed:


set oracle_sid=fjgs

 


error 2:

C:\Windows\system32>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on 星期二 4月 16 15:09:51 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:
ORA-01031: insufficient privileges



fixed:

控制面板->管理工具->计算机管理->本地用户和组->用户->lian456 , 右击属性 ->隶属于->添加->高级->立即查找->ora_dba,一直确定。





error 3:

ORA-01034: ORACLE not available



fixed:

startup open fjgs




error 4:

C:\Windows\system32>Imp fjgsdba@fjgs full=y file= D:\work\svn\jm\pki\src\db\fjg
.dmp

Import: Release 11.2.0.1.0 - Production on 星期二 4月 16 15:59:29 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

口令:

IMP-00058: 遇到 ORACLE 错误 12154
ORA-12154: TNS: 无法解析指定的连接标识符
IMP-00000: 未成功终止导入



fixed:

Imp fjgsdba/fjgs#2006



then input by the tip.

No comments: