ORACLE DMP文件导入数据库是,系统报archive log已满,于是想到archive log禁用;
1、shutdown immediate;
成功
2、startup mount;
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
处理办法:listener文件,添加如下内容:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
--//这里添加
(SID_DESC=
(GLOBAL_DBNAME=orcl.com)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
--==GLOBAL_DBNAME 和SID_NAME都需要写上
)
3、重启侦听服务
lsnrctl stop;
slnrctl start;
4、SYS 用户登录
startup mount;
已经连接到空闲例程
5、alter database noarchivelog;
6、alter database open;