晚上给几个测试库打补丁，停完监听和实例后查看已经没有Oracle的进程了，于是执行opatch apply。但执行报如下错误：$ opatch apply Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2017, Oracle Corporation. All rights reserved.Oracle Home : /opt/oracle/app/oracle/product/11.2.4/db_1 Central Inventory : /opt/oracle/app/oracle/oraInventory from : /opt/oracle/app/oracle/pro...
之前以为是系统的原因，弄得重装系统T^T 因为听很多同学说Oracle有些难装难卸，没找到主要原因就开始重装，这真是浪费时间。 百度了原因，若在安装过程中出现： 未找到文件 F:\app\Administrator\product\11.2.0\dbhome_2\owb\external\oc4j_applications\applications\WFMLRSVCApp.ear 有网友找到了解决办法： 将win64_11gR2_database_2of2中的\win64_11gR2_database_2of2\database\stage\Components\*拷到\win64_11gR2_d...
[oracle@host capture]$ wrc system/oracle@db1 REPLAYDIR=/home/oracle/cap_dir/Workload Replay Client: Release 11.1.0.7.0 - Production on Sun Jul 19 17:16:56 2015Copyright (c) 1982, 2007, Oracle. All rights reserved.The client could not open ‘wcr_login.pp‘ for login queue at directory ‘/home/oracle/cap_dir/‘ Errors in file : ORA-15557: workload replay client cannot access the replay directory or...
SQL> alter database archivelog;alter database archivelog*ERROR at line 1:ORA-00265: instance recovery required, cannot set ARCHIVELOG mode 正常关库、启库使数据库一致性关闭 SQL>shutdown immediate SQL>startup 在关库、启动到mount状态 SQL>shutdown immediate SQL>startup mount; SQL> alter database archivelog;『ORACLE』修改归档时报错：instance recovery required, cannot set ARCHIVELOG mode标签：can bs...
所以在【主库】执行如下rman操作命令时会报错控制文件记录的数据库名与实际拷贝的数据库名不相同 RMAN> duplicate target database for standby from active database; Starting Duplicate Db at 01-MAY-17using target database control file instead of recovery catalogallocated channel: ORA_AUX_DISK_1channel ORA_AUX_DISK_1: SID=10 device type=DISK contents of Memory Script:{ backup as copy reuse targetfile ‘...
17/05/02 15:45:28 WARN conf.HiveConf: DEPRECATED: hive.metastore.ds.retry.* no longer has any effect. Use hive.hmshandler.retry.* insteadorg.apache.thrift.transport.TTransportException: Could not create ServerSocket on address 0.0.0.0/0.0.0.0:9083. at org.apache.thrift.transport.TServerSocket.<init>(TServerSocket.java:93) at org.apache.thrift.transport.TServerSocket.<init>(TServerSocket.java:75) a...
hive> > > create table test(a string, b int);FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : ORA-01754: 表只能包含一个 LONG 类型的列 java.sql.SQLSyntaxErrorException: ORA-01754: 表只能包含一个 LONG 类型的列at oracle.jdbc.driver.T4CTTIoer.pro...
NHibernate.Exceptions.GenericADOException:“could not execute query [ select sys_user0_.USERID as USERID1_0_, sys_user0_.LOGINNAME as LOGINN2_0_, sys_user0_.LOGINPASSWORD as LOGINP3_0_, sys_user0_.DEPTID as DEPTID4_0_, sys_user0_.REALNAME as REALNA5_0_, sys_user0_.TILTLE as TILTLE6_0_, sys_user0_.SEX as SEX7_0_, sys_user0_.PHONE as PHONE8_0_, sys_user0_.FAX as FAX9_0_, sys_user0_.PROVID as PROVI10...
Oracle 11g R2安装过程中遇到的报错及解决办法 1.提示Check if the DISPLAYvariable is set. Failed<<<<解决方案： #xhost + //切换到root用户输入 #su – Oracle //切换到oracle用户 $./runInstaller //执行安装程序 xhost 是用来控制X server访问权限的。 通常当你从hostA登陆到hostB上运行hostB上的应用程序时， 做为应用程序来说，hostA是client,但是作为图形来说， 是在hostA上显示的，需要使用hostA的Xserver,所以ho...
The Network Adapter could not establish the connection 网络适配器不能创建连接作为初学者的来说，这个问题让我找了好多次，每次重新开启电脑时就可以正常获取连接，过了一会儿，自己不知道做了什么就会又报错，使用pl/sql时也会登录用户半天登陆不上。 配置文件如下：获取连接的语句如下public static Connection getConnection(){ String className = SmbmsProperties.getInstance().getValue("jdbc.class"); St...
ORA-06512: at "PERFSTAT.STATSPACK", line 978 ORA-06512: at "PERFSTAT.STATSPACK", line 1612 ORA-06512: at "PERFSTAT.STATSPACK", line 71 ORA-06512: at line 1 Mon Jun 16 13:47:46 2014 ORA-1631: max # extents 505 reached in table PERFSTAT.STATS$SQL_SUMMARY解决例如以下： SQL> select tablespace_name,bytes/1024/1024 from dba_free_space where tablespace_name=‘STATSPACK1‘; TABLESPACE_NAME ...
原因： Oracle需要装client才能让第三方工具通过OCI(Oracle Call Interface)来连接。 解决方案： 1. 去oracle官网下载Instant Client 11, 或者 2. 直接解压到合适目录下，如C:\instantclient_11_2。 3. Navicat --> 工具 --> 选项... --> 其他 --> OCI, OCI library(oci.dll)*: 选择 C:\instantclient_11_2\oci.dll SQL*Plus: 选择 C:\instantclient_11_2\sqlplus.exe 4. 重新尝试连接Oracle数据库，OK!Navicat连接Oracle报错_C...
INFO: End output from spawned process. INFO: ---------------------------------- INFO: Exception thrown from action: make Exception Name: MakefileException Exception String: Error in invoking target ‘irman ioracle‘ of makefile ‘/export/home/oracle/u01/app/oracle/product/11.2.0/db_1/rdbms/lib/ins_rdbms.mk‘. See ‘/export/home/oracle/u01/app/oraInventory/logs/installActions2014-05-13_02-15-59PM.l...
ORA-28547：connection to server failed,probable Oracle Net admin error，截图如下：问题原因：重装系统之后，需要先安装oracle客户端，我们把oracle客户端安装之后，看看是否还会存在这个问题注意：如果你是在您本机装的oracle，然后访问本机的数据库，是不需要再额外安装客户端了，因为oracle服务器就会带有客户端1、oracle客户端下载去官网下载客户端，我这边数据库版本为11.2.0.4.0，官网上没有提供客户端，只能下载11.2.0....
我遇到此类问题，一般是右键计算机－管理－服务，找到OracleOraDB12Home1TNSListener设为自动启动，并重启，当然这种操作你要确定监听文件什么的都已经检查无问题哦。本文出自 “myOracle” 博客，请务必保留此出处http://clarkbg.blog.51cto.com/13019785/1939554oracle 12c启动监听报错协议适配器错误标签：oracle 计算机 适配器 本文系统来源：http://clarkbg.blog.51cto.com/13019785/1939554