12c
okman312
底层it工作者
展开
-
imp报错Warning: This import generated a separate SQL file “fx_sys.sql“ which contains DDL that failed
[oracle@oracle04 ~]$imp fx/fx file=fx.dmp log=fx.log rows=n full=yImport: Release 12.2.0.1.0 - Production on Mon Nov 2 07:23:05 2020Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 12c Enterp原创 2020-11-02 07:26:03 · 2907 阅读 · 1 评论 -
imp导入报错IMP-00013: only a DBA can import a file exported by another DBA
报错:IMP-00013: only a DBA can import a file exported by another DBA提示导入的用户要有DBA权限;授权再导入[oracle@oracle04 ~]$sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Mon Nov 2 07:08:02 2020Copyright (c) 1982, 2016, Oracle. All rights reserved.原创 2020-11-02 07:11:51 · 633 阅读 · 0 评论 -
oracle 12 监听器提示The listener supports no services
情况如下:[oracle@oracle05 ~]$ lsnrctl statusLSNRCTL for Linux: Version 12.2.0.1.0 - Production on 07-OCT-2020 12:16:14Copyright (c) 1991, 2016, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle05)(PORT=1521)))S原创 2020-10-07 12:25:06 · 320 阅读 · 1 评论 -
oracle12c安装报错1
在centos7.5上安装oracle12c在初始化安装引导时报错,如下:Cause - Failed to access the temporary location. Action - Ensure that the current user has required permissions to access the temporary location. Additional Information: - PRVG-1901 : failed to setup CVU remote exec原创 2020-09-12 12:20:31 · 1000 阅读 · 0 评论