oracle 11.2.0.1升级到11.2.0.4

SQL> @?/rdbms/admin/utlu112i.sql
………………
Miscellaneous Warnings


WARNING: --> Database is using a timezone file older than version 14.
.... After the release migration, it is recommended that DBMS_DST package
.... be used to upgrade the 11.2.0.1.0 database timezone version
.... to the latest version which comes with the new release.

在升级模式下执行:

SQL> EXEC DBMS_DST.BEGIN_PREPARE(14);

PL/SQL procedure successfully completed.

SQL> EXEC DBMS_DST.END_PREPARE;

PL/SQL procedure successfully completed.

SQL> EXEC DBMS_DST.BEGIN_UPGRADE(14);
BEGIN DBMS_DST.BEGIN_UPGRADE(14); END;

*
ERROR at line 1:
ORA-00904: "VIRTUAL_COLUMN": invalid identifier
ORA-06512: at "SYS.DBMS_DST", line 113
ORA-06512: at "SYS.DBMS_DST", line 1101
ORA-06512: at line 1

找不到出错的原因,求大侠们帮忙?

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
oracle 11.2.0.4 账户被锁的问题
请教各位一个问题! 目前数据库(单机文件系统)11.2.0.3版本,web端使用连接池连接数据库用户user/password正常。 升级到oracle 11.2.0.4版本并打完建议的补丁集后,同样的客户端连接到11.2.0.4的用户user/password用户被锁,提示用户名密码错误。 我修改系统参数密码不区分大小写验证-无效 解锁账户后,设置错误密码无限制次数连接,这样我在oracle账户下使用sqlplus user/password登录卡住,无法登录。很久才能登录进去,或者提示tns异常问题。 请各位高手指点上述问题可能引起的原因。 web 日志 09-Jun-2017 18:12:02.244 WARNING [C3P0PooledConnectionPoolManager[identityToken->1hge3nw9o12xef2j1y0tsbn|30a044a7, dataSourceName->hibernate-datasource]-HelperThread-#0] com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$WarnLogger.log Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@d0bcbac is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests. 09-Jun-2017 18:12:12.246 WARNING [C3P0PooledConnectionPoolManager[identityToken->1hge3nw9o12xef2j1y0tsbn|30a044a7, dataSourceName->hibernate-datasource]-HelperThread-#2] com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$WarnLogger.log com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@166de721 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (1). Last acquisition attempt exception: java.sql.SQLException: ORA-01017: invalid username/password; logon denied at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:388) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:381) at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:564) at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:359) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44) at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696) 有人能指导下上述问题出在什么地方不? 我们搞java的好像也无多大办法了。 我自己用jdbc 开多线程连接并无异常,c3p0 开始启动的时候业务异常,但是启动一段时间后就报上述用户名和密码错误。
oracle10.2.0.4升级到11.2.0.1相关问题
进行升级之后,11g的新特性只读表使用不成功,在升级后需要执行什么内置脚本吗?
Caused by: java.net.SocketException: Broken pipe
![图片说明](https://img-ask.csdn.net/upload/201709/26/1506406633_173793.png) ``` Caused by: java.net.SocketException: Broken pipe at java.net.SocketOutputStream.socketWrite0(Native Method) ~[na:1.7.0_80] at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113) ~[na:1.7.0_80] at java.net.SocketOutputStream.write(SocketOutputStream.java:159) ~[na:1.7.0_80] at oracle.net.ns.DataPacket.send(DataPacket.java:199) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:211) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:227) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] at oracle.net.ns.NetInputStream.read(NetInputStream.java:175) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] at oracle.net.ns.NetInputStream.read(NetInputStream.java:100) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] at oracle.net.ns.NetInputStream.read(NetInputStream.java:85) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:359) ~[ojdbc6-ojdbc6-11.1.0.7.0-jar.jar:11.2.0.1.0] ```
oracle 11.2.0.1版本数据库最近部署的环境数据库监听总断还无法自启;必须手动去启动服务
下边是出现这情况的alert日志 <msg time='2019-06-25T22:01:29.365+08:00' org_id='oracle' comp_id='rdbms' client_id='' type='UNKNOWN' level='16' host_id='WIN-10J35UM9LGQ' host_addr='fe80::4f:8dc2:480d:d9cf%12' module='' pid='2760'> <txt>Errors in file i:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_lgwr_2760.trc: ORA-00345: redo log write error block 60285 count 2048 ORA-00312: online log 3 thread 1: &apos;I:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG&apos; ORA-27070: async read/write failed OSD-04016: 异步 I/O 请求排队时出错。 O/S-Error: (OS 121) 信号灯超时时间已到 </txt> </msg> <msg time='2019-06-25T22:01:29.567+08:00' org_id='oracle' comp_id='rdbms' client_id='' type='UNKNOWN' level='16' host_id='WIN-10J35UM9LGQ' host_addr='fe80::4f:8dc2:480d:d9cf%12' module='' pid='2760'> <txt>Errors in file i:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_lgwr_2760.trc: ORA-00340: IO error processing online log 3 of thread 1 ORA-00345: redo log write error block 60285 count 2048 ORA-00312: online log 3 thread 1: &apos;I:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG&apos; ORA-27070: async read/write failed OSD-04016: 异步 I/O 请求排队时出错。 O/S-Error: (OS 121) 信号灯超时时间已到 </txt> </msg> <msg time='2019-06-25T22:01:29.567+08:00' org_id='oracle' comp_id='rdbms' client_id='' type='UNKNOWN' level='16' host_id='WIN-10J35UM9LGQ' host_addr='fe80::4f:8dc2:480d:d9cf%12' module='' pid='2760'> <txt>LGWR (ospid: 2760): terminating the instance due to error 340 </txt> </msg> <msg time='2019-06-25T22:01:30.410+08:00' org_id='oracle' comp_id='rdbms' client_id='' type='UNKNOWN' level='16' host_id='WIN-10J35UM9LGQ' host_addr='fe80::4f:8dc2:480d:d9cf%12' module='' pid='6956'> <txt>opiodr aborting process unknown ospid (6956) as a result of ORA-1092 </txt> </msg> <msg time='2019-06-25T22:01:30.410+08:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='WIN-10J35UM9LGQ' host_addr='fe80::4f:8dc2:480d:d9cf%12' pid='6956'> <txt>ORA-1092 : opitsk aborting process </txt> </msg> <msg time='2019-06-25T22:01:30.472+08:00' org_id='oracle' comp_id='rdbms' client_id='' type='UNKNOWN' level='16' host_id='WIN-10J35UM9LGQ' host_addr='fe80::4f:8dc2:480d:d9cf%12' module='' pid='8264'> <txt>opiodr aborting process unknown ospid (8264) as a result of ORA-1092 </txt> </msg> <msg time='2019-06-25T22:01:30.488+08:00' org_id='oracle' comp_id='rdbms' type='UNKNOWN' level='16' host_id='WIN-10J35UM9LGQ' host_addr='fe80::4f:8dc2:480d:d9cf%12' pid='8264'> <txt>ORA-1092 : opitsk aborting process </txt> </msg> <msg time='2019-06-25T22:01:32.001+08:00' org_id='oracle' comp_id='rdbms' client_id='' type='UNKNOWN' level='16' host_id='WIN-10J35UM9LGQ' host_addr='fe80::4f:8dc2:480d:d9cf%12' module='OEM.SystemPool' pid='9968'> <txt>opiodr aborting process unknown ospid (9968) as a result of ORA-1092 </txt> </msg>
求一份oracle 11.2.0 安全漏洞 补丁包
1   Oracle Database Server远程安全漏洞(CVE-2015-4863) 2   Oracle Database Server OJVM 本地安全漏洞(CVE-2017-10202) 3   Oracle Database Server Java VM组件安全漏洞(CVE-2018-3110) 4   Oracle Database Server Java VM 组件安全漏洞(CVE-2018-3259) 5   Oracle Database Server Java VM组件代码执行漏洞(CVE-2014-6453) 6   Oracle Database Server Java VM组件代码执行漏洞(CVE-2014-6560) 7   Oracle Database Server JPublisher组件代码执行漏洞(CVE-2014-6546) 8   Oracle Database Server Java VM组件代码执行漏洞(CVE-2014-6545) 9   Oracle Database Server Java VM组件代码执行漏洞(CVE-2014-6467) 10   Oracle Database Server SQLJ组件代码执行漏洞(CVE-2014-6455) 11   Oracle Database Server远程安全漏洞(CVE-2014-6567) 12   Oracle Database Server Java VM组件安全漏洞(CVE-2015-0457) 13   Oracle Database Server Java VM组件任意代码执行漏洞(CVE-2015-2629) 14   Oracle Database Server远程安全漏洞(CVE-2015-4873) 15   Oracle Database Server Java VM组件安全漏洞(CVE-2016-0499) 16   Oracle Database Server远程安全漏洞(CVE-2016-5555) 17   Oracle Database 远程安全漏洞(CVE-2014-2406) 18   Oracle Database Server Java VM组件安全漏洞(CVE-2018-2841) 太不好意思,已经没有C币可以悬赏了。。。。
oracle 11g里面将配置文件上载到em资料档案库失败
它的日志 文件这样解释 2019-4-27 12:34:03 oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc 配置: Setting oracle.installer.oui_loc to C:\app\ltx\product\11.2.0\dbhome_1\oui 2019-4-27 12:34:03 oracle.sysman.emcp.util.ClusterUtil isHASInstalled 配置: isHAInstalled: false 2019-4-27 12:34:03 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag '-migrate' set to false 2019-4-27 12:34:03 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'migrateFromDBControl' set to false 2019-4-27 12:34:03 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'migrateToCentralAgent' set to false 2019-4-27 12:34:03 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'migrateFromCentralAgent' set to false 2019-4-27 12:34:03 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'migrateToDBControl' set to false 2019-4-27 12:34:03 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag '-config' set to true 2019-4-27 12:34:03 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'UPDATE_EMAIL' set to true 2019-4-27 12:34:03 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'dbcontrol' set to true 2019-4-27 12:34:03 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'db' set to true 2019-4-27 12:34:03 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'create' set to true 2019-4-27 12:34:03 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: ORACLE_HOME value: C:\app\ltx\product\11.2.0\dbhome_1 2019-4-27 12:34:03 oracle.sysman.emcp.util.ClusterUtil isCRSInstalled 配置: isCRSInstalled: false 2019-4-27 12:34:03 oracle.sysman.emcp.util.ClusterUtil isHASInstalled 配置: isHAInstalled: false 2019-4-27 12:34:08 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: SID value: orcl 2019-4-27 12:34:08 oracle.sysman.emcp.DatabaseChecks getDbServiceName 配置: No service name available. Will try to set db_unique_name.db_domain 2019-4-27 12:34:08 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 REP_DB_RUNNING_HOST 的值。 2019-4-27 12:34:08 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DB_UNIQUE_NAME 的值。 2019-4-27 12:34:08 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:34:08 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database null : WIN-QUN6TUICVJJ 2019-4-27 12:34:08 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:34:08 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 SYSMAN_PWD 的值。 2019-4-27 12:34:08 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 PORT 的值。 2019-4-27 12:34:08 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:34:08 oracle.sysman.emcp.util.ClusterUtil isCRSInstalled 配置: isCRSInstalled: false 2019-4-27 12:34:08 oracle.sysman.emcp.util.ClusterUtil getLocalNode 配置: Cluster.isCluster: false. Skip call to getLocalNode 2019-4-27 12:34:08 oracle.sysman.emcp.util.ClusterUtil getLocalNode 配置: isLocalNodeDone: true localNode: null 2019-4-27 12:34:08 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DB_UNIQUE_NAME 的值。 2019-4-27 12:34:08 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Couldn't get listener port. File C:\app\ltx\product\11.2.0\dbhome_1\WIN-QUN6TUICVJJ_null\sysman\config\emoms.properties does not exists 2019-4-27 12:34:08 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 SERVICE_NAME 的值。 2019-4-27 12:34:08 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:34:08 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:34:08 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: 2019-4-27 12:34:09 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DB_UNIQUE_NAME 的值。 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DB_UNIQUE_NAME 的值。 2019-4-27 12:34:09 oracle.sysman.emcp.DatabaseChecks getDbUniqueName 配置: No Database unique name available. Will try to retrieve it from DB itself 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: DB_UNIQUE_NAME value: ORCL 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DB_DOMAIN 的值。 2019-4-27 12:34:09 oracle.sysman.emcp.DatabaseChecks getDbDomain 配置: No db domain available. Will query db for db_domain parameter 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: SERVICE_NAME value: ORCL 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:34:09 oracle.sysman.emcp.util.ClusterUtil getLocalNode 配置: isLocalNodeDone: true localNode: null 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:34:09 oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured 配置: Sid: ORCL Host: WIN-QUN6TUICVJJ Node: null OH: C:\app\ltx\product\11.2.0\dbhome_1 isDBC: false 2019-4-27 12:34:09 oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured 配置: Sid: ORCL Host: WIN-QUN6TUICVJJ Node: null OH: C:\app\ltx\product\11.2.0\dbhome_1 agentHome: null isCentral: false 2019-4-27 12:34:09 oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured 配置: Sid: ORCL Host: WIN-QUN6TUICVJJ Node: null OH: C:\app\ltx\product\11.2.0\dbhome_1 agentHome: null isCentral: false 2019-4-27 12:34:09 oracle.sysman.emcp.util.ClusterUtil isHASInstalled 配置: isHAInstalled: false 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 SYS_PWD 的值。 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 SYSMAN_PWD 的值。 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 PORT 的值。 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:34:09 oracle.sysman.emcp.util.ClusterUtil getLocalNode 配置: isLocalNodeDone: true localNode: null 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Couldn't get listener port. File C:\app\ltx\product\11.2.0\dbhome_1\WIN-QUN6TUICVJJ_ORCL\sysman\config\emoms.properties does not exists 2019-4-27 12:34:09 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:34:09 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:34:09 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: 2019-4-27 12:34:09 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'asm_db' set to false 2019-4-27 12:34:09 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'asm_db' set to false 2019-4-27 12:34:12 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: PORT value: 1521 2019-4-27 12:34:21 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: LISTENER_OH value: 1521 2019-4-27 12:34:24 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 SYS_PWD 的值。 2019-4-27 12:34:24 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ASM_OH 的值。 2019-4-27 12:34:24 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:34:24 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:34:24 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 SYSMAN_PWD 的值。 2019-4-27 12:34:24 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:34:24 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:34:24 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:34:24 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: SYS 2019-4-27 12:34:24 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:34:28 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ASM_OH 的值。 2019-4-27 12:34:28 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:34:28 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:34:28 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 SYSMAN_PWD 的值。 2019-4-27 12:34:28 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:34:28 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:34:28 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:34:28 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: DBSNMP 2019-4-27 12:34:28 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:34:34 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: EMAIL_ADDRESS value: 2019-4-27 12:34:35 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: MAIL_SERVER_NAME value: 2019-4-27 12:34:35 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:34:35 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: CONFIRMATION ANSWER value: 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: CONFIRMATION ANSWER value: 是 2019-4-27 12:34:38 oracle.sysman.emcp.EMConfig restoreOuiLoc 配置: Restoring oracle.installer.oui_loc to C:\app\ltx\product\11.2.0\dbhome_1\oui 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 LOG_FILE 的值。 2019-4-27 12:34:38 oracle.sysman.emcp.EMConfig addEMCALogFile 配置: ORACLE_BASE :C:\app\ltx 2019-4-27 12:34:38 oracle.sysman.emcp.EMConfig restoreOuiLoc 配置: Restoring oracle.installer.oui_loc to C:\app\ltx\product\11.2.0\dbhome_1\oui 2019-4-27 12:34:38 oracle.sysman.emcp.EMConfig restoreOuiLoc 配置: Restoring oracle.installer.oui_loc to C:\app\ltx\product\11.2.0\dbhome_1\oui 2019-4-27 12:34:38 oracle.sysman.emcp.EMConfig perform 信息: 正在将此操作记录到 C:\app\ltx\cfgtoollogs\emca\ORCL\emca_2019_04_27_12_34_03.log。 2019-4-27 12:34:38 oracle.sysman.emcp.util.ClusterUtil isCRSInstalled 配置: isCRSInstalled: false 2019-4-27 12:34:38 oracle.sysman.emcp.EMConfig restoreOuiLoc 配置: Restoring oracle.installer.oui_loc to C:\app\ltx\product\11.2.0\dbhome_1\oui 2019-4-27 12:34:38 oracle.sysman.emcp.EMConfig restoreOuiLoc 配置: Restoring oracle.installer.oui_loc to C:\app\ltx\product\11.2.0\dbhome_1\oui 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: EM_HOME value: C:\app\ltx\product\11.2.0\dbhome_1 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'CHECK_CONFIG' set to true 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ASM_OH 的值。 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:34:38 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:34:38 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:34:38 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: SYS 2019-4-27 12:34:38 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ASM_OH 的值。 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:34:38 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:34:38 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:34:38 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: DBSNMP 2019-4-27 12:34:38 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 MODIFY_SID 的值。 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:34:38 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:34:38 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:34:38 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:34:38 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: SYS 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'asm_db' set to false 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 MODIFY_SID 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.DatabaseChecks getDbServiceName 配置: No service name available. Will try to set db_unique_name.db_domain 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: SYS 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: DB_UNIQUE_NAME value: 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DB_UNIQUE_NAME 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.DatabaseChecks getDbUniqueName 配置: No Database unique name available. Will try to retrieve it from DB itself 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: DB_UNIQUE_NAME value: ORCL 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DB_DOMAIN 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.DatabaseChecks getDbDomain 配置: No db domain available. Will query db for db_domain parameter 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: DB_UNIQUE_NAME value: ORCL 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: SERVICE_NAME value: ORCL 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 MODIFY_SID 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DBID 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.DatabaseChecks getDbid 配置: No dbid available. Will query db to extract it. 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: SYS 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: DBID value: 1534425785 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'db' set to true 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 MODIFY_SID 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.DatabaseChecks getDbServiceName 配置: No service name available. Will try to set db_unique_name.db_domain 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: SYS 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: DB_UNIQUE_NAME value: 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DB_UNIQUE_NAME 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.DatabaseChecks getDbUniqueName 配置: No Database unique name available. Will try to retrieve it from DB itself 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: DB_UNIQUE_NAME value: ORCL 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DB_DOMAIN 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.DatabaseChecks getDbDomain 配置: No db domain available. Will query db for db_domain parameter 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: DB_UNIQUE_NAME value: ORCL 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: SERVICE_NAME value: ORCL 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 EMAIL_ADDRESS 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 MAIL_SERVER_NAME 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: SYS 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:34:39 oracle.sysman.emcp.EMDBPreConfig invoke 配置: Passed repository configuration check 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 MODIFY_SID 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 MODIFY_SID 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 GLOBAL_DB_UNIQUE_NAME 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName 配置: No Global database unique name available. Will try to retrieve it from DB itself 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: SYS 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DB_DOMAIN 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.DatabaseChecks getDbDomain 配置: No db domain available. Will query db for db_domain parameter 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: GLOBAL_DB_UNIQUE_NAME value: ORCL 2019-4-27 12:34:39 oracle.sysman.emcp.util.FileUtil _deleteFile 配置: 删除文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emd.properties.emca.tmp 2019-4-27 12:34:39 oracle.sysman.emcp.util.FileUtil copyFile 配置: exception caught in copyFile: oracle.sysman.emcp.exception.FileUtilException: 正在将文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emd.properties 复制到 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emd.properties.emca.tmp at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277) at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618) at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394) at oracle.sysman.emcp.util.FileUtil.backupFile(FileUtil.java:1264) at oracle.sysman.emcp.EMDBPreConfig.backupSharedFiles(EMDBPreConfig.java:1247) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:251) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522) Caused by: java.io.FileNotFoundException: C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emd.properties.emca.tmp (拒绝访问。) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.<init>(FileOutputStream.java:179) at java.io.FileOutputStream.<init>(FileOutputStream.java:131) at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263) ... 11 more 2019-4-27 12:34:39 oracle.sysman.emcp.util.FileUtil backupFile 警告: 无法备份文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emd.properties 2019-4-27 12:34:39 oracle.sysman.emcp.util.FileUtil backupFile 配置: Stack trace: oracle.sysman.emcp.exception.FileUtilException: 正在将文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emd.properties 复制到 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emd.properties.emca.tmp at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:625) at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394) at oracle.sysman.emcp.util.FileUtil.backupFile(FileUtil.java:1264) at oracle.sysman.emcp.EMDBPreConfig.backupSharedFiles(EMDBPreConfig.java:1247) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:251) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522) Caused by: oracle.sysman.emcp.exception.FileUtilException: 正在将文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emd.properties 复制到 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emd.properties.emca.tmp at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277) at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618) ... 10 more Caused by: java.io.FileNotFoundException: C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emd.properties.emca.tmp (拒绝访问。) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.<init>(FileOutputStream.java:179) at java.io.FileOutputStream.<init>(FileOutputStream.java:131) at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263) ... 11 more 2019-4-27 12:34:39 oracle.sysman.emcp.util.FileUtil _deleteFile 配置: 删除文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emoms.properties.emca.tmp 2019-4-27 12:34:39 oracle.sysman.emcp.util.FileUtil copyFile 配置: exception caught in copyFile: oracle.sysman.emcp.exception.FileUtilException: 正在将文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emoms.properties 复制到 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emoms.properties.emca.tmp at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277) at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618) at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394) at oracle.sysman.emcp.util.FileUtil.backupFile(FileUtil.java:1264) at oracle.sysman.emcp.EMDBPreConfig.backupSharedFiles(EMDBPreConfig.java:1268) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:251) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522) Caused by: java.io.FileNotFoundException: C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emoms.properties.emca.tmp (拒绝访问。) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.<init>(FileOutputStream.java:179) at java.io.FileOutputStream.<init>(FileOutputStream.java:131) at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263) ... 11 more 2019-4-27 12:34:39 oracle.sysman.emcp.util.FileUtil backupFile 警告: 无法备份文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emoms.properties 2019-4-27 12:34:39 oracle.sysman.emcp.util.FileUtil backupFile 配置: Stack trace: oracle.sysman.emcp.exception.FileUtilException: 正在将文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emoms.properties 复制到 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emoms.properties.emca.tmp at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:625) at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394) at oracle.sysman.emcp.util.FileUtil.backupFile(FileUtil.java:1264) at oracle.sysman.emcp.EMDBPreConfig.backupSharedFiles(EMDBPreConfig.java:1268) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:251) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522) Caused by: oracle.sysman.emcp.exception.FileUtilException: 正在将文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emoms.properties 复制到 C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emoms.properties.emca.tmp at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277) at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618) ... 10 more Caused by: java.io.FileNotFoundException: C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emoms.properties.emca.tmp (拒绝访问。) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.<init>(FileOutputStream.java:179) at java.io.FileOutputStream.<init>(FileOutputStream.java:131) at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263) ... 11 more 2019-4-27 12:34:39 oracle.sysman.emcp.util.FileUtil _deleteFile 配置: 删除文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\emd\targets.xml.emca.tmp 2019-4-27 12:34:39 oracle.sysman.emcp.util.FileUtil copyFile 配置: exception caught in copyFile: oracle.sysman.emcp.exception.FileUtilException: 正在将文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\emd\targets.xml 复制到 C:\app\ltx\product\11.2.0\dbhome_1\sysman\emd\targets.xml.emca.tmp at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277) at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618) at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394) at oracle.sysman.emcp.util.FileUtil.backupFile(FileUtil.java:1264) at oracle.sysman.emcp.EMDBPreConfig.backupSharedFiles(EMDBPreConfig.java:1274) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:251) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522) Caused by: java.io.FileNotFoundException: C:\app\ltx\product\11.2.0\dbhome_1\sysman\emd\targets.xml.emca.tmp (拒绝访问。) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.<init>(FileOutputStream.java:179) at java.io.FileOutputStream.<init>(FileOutputStream.java:131) at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263) ... 11 more 2019-4-27 12:34:39 oracle.sysman.emcp.util.FileUtil backupFile 警告: 无法备份文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\emd\targets.xml 2019-4-27 12:34:39 oracle.sysman.emcp.util.FileUtil backupFile 配置: Stack trace: oracle.sysman.emcp.exception.FileUtilException: 正在将文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\emd\targets.xml 复制到 C:\app\ltx\product\11.2.0\dbhome_1\sysman\emd\targets.xml.emca.tmp at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:625) at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394) at oracle.sysman.emcp.util.FileUtil.backupFile(FileUtil.java:1264) at oracle.sysman.emcp.EMDBPreConfig.backupSharedFiles(EMDBPreConfig.java:1274) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:251) at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522) Caused by: oracle.sysman.emcp.exception.FileUtilException: 正在将文件 C:\app\ltx\product\11.2.0\dbhome_1\sysman\emd\targets.xml 复制到 C:\app\ltx\product\11.2.0\dbhome_1\sysman\emd\targets.xml.emca.tmp at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277) at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618) ... 10 more Caused by: java.io.FileNotFoundException: C:\app\ltx\product\11.2.0\dbhome_1\sysman\emd\targets.xml.emca.tmp (拒绝访问。) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.<init>(FileOutputStream.java:179) at java.io.FileOutputStream.<init>(FileOutputStream.java:131) at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263) ... 11 more 2019-4-27 12:34:39 oracle.sysman.emcp.util.ClusterUtil isHASInstalled 配置: isHAInstalled: false 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.util.ClusterUtil getLocalNode 配置: isLocalNodeDone: true localNode: null 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'IS_CENTRAL_AGENT_RECONFIG' set to false 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.util.ClusterUtil getLocalNode 配置: isLocalNodeDone: true localNode: null 2019-4-27 12:34:39 oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured 配置: Sid: ORCL Host: WIN-QUN6TUICVJJ Node: null OH: C:\app\ltx\product\11.2.0\dbhome_1 agentHome: null isCentral: false 2019-4-27 12:34:39 oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured 配置: Sid: ORCL Host: WIN-QUN6TUICVJJ Node: null OH: C:\app\ltx\product\11.2.0\dbhome_1 isDBC: false 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setFlag 配置: Flag 'IS_DBCONTROL_CONFIGURED' set to false 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DBCONTROL_HTTP_PORT 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 AGENT_PORT 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 RMI_PORT 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 JMS_PORT 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.util.ClusterUtil getLocalNode 配置: isLocalNodeDone: true localNode: null 2019-4-27 12:34:39 oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured 配置: Sid: ORCL Host: WIN-QUN6TUICVJJ Node: null OH: C:\app\ltx\product\11.2.0\dbhome_1 isDBC: false 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 PORTS_FILE 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.util.ClusterUtil getLocalNode 配置: isLocalNodeDone: true localNode: null 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 JMS_PORT_WIN-QUN6TUICVJJ 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 JMS_PORT 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 RMI_PORT_WIN-QUN6TUICVJJ 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 RMI_PORT 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DBCONTROL_HTTP_PORT_WIN-QUN6TUICVJJ 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DBCONTROL_HTTP_PORT 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 AGENT_PORT_WIN-QUN6TUICVJJ 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 AGENT_PORT 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc 配置: Setting oracle.installer.oui_loc to C:\app\ltx\product\11.2.0\dbhome_1\oui 2019-4-27 12:34:39 oracle.sysman.emcp.util.PortManager markAllUsedPorts 配置: Homes to scan for used ports: [C:\app\ltx\product\11.2.0\dbhome_1] 2019-4-27 12:34:39 oracle.sysman.emcp.util.PortManager markAllUsedPorts 配置: Searching all DBConsole instances for used ports under ORACLE_HOME C:\app\ltx\product\11.2.0\dbhome_1 2019-4-27 12:34:39 oracle.sysman.emcp.util.PortManager markAllUsedPorts 配置: Marking JMS port: null from C:\app\ltx\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole 2019-4-27 12:34:39 oracle.sysman.emcp.util.PortManager markAllUsedPorts 配置: Marking RMI port: null from C:\app\ltx\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole 2019-4-27 12:34:39 oracle.sysman.emcp.util.PortManager markAllUsedPorts 配置: Marking HTTP port: null from C:\app\ltx\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole 2019-4-27 12:34:39 oracle.sysman.emcp.util.PortManager getAgentPort 配置: Cannot parse EMD_URL correctly. No port identified 2019-4-27 12:34:39 oracle.sysman.emcp.util.PortManager markAllUsedPorts 配置: Marking Agent port: null from C:\app\ltx\product\11.2.0\dbhome_1\sysman\config\emd.properties 2019-4-27 12:34:39 oracle.sysman.emcp.util.PortManager markAllUsedPorts 配置: Cannnot parse EMD_URL correctly. No port identified 2019-4-27 12:34:39 oracle.sysman.emcp.util.FileUtil getProperties 配置: 读取文件 C:\app\ltx\product\11.2.0\dbhome_1\install\staticports.ini 时出错 2019-4-27 12:34:39 oracle.sysman.emcp.util.PortManager getFreePorts 配置: C:\app\ltx\product\11.2.0\dbhome_1:WIN-QUN6TUICVJJ:null:ORCL:{}:null:{DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938} 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 AGENT_PORT_WIN-QUN6TUICVJJ 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: AGENT_PORT_WIN-QUN6TUICVJJ value: 3938 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 DBCONTROL_HTTP_PORT_WIN-QUN6TUICVJJ 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: DBCONTROL_HTTP_PORT_WIN-QUN6TUICVJJ value: 1158 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 JMS_PORT_WIN-QUN6TUICVJJ 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: JMS_PORT_WIN-QUN6TUICVJJ value: 5540 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 RMI_PORT_WIN-QUN6TUICVJJ 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: RMI_PORT_WIN-QUN6TUICVJJ value: 5520 2019-4-27 12:34:39 oracle.sysman.emcp.EMDBPreConfig getFreePorts 配置: Ports assigned for Node: WIN-QUN6TUICVJJ : {DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938} 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:34:39 oracle.sysman.emcp.util.ClusterUtil getLocalNode 配置: isLocalNodeDone: true localNode: null 2019-4-27 12:34:39 oracle.sysman.emcp.EMDBPreConfig copyAgentTimeStampFile 配置: File: C:\app\ltx\product\11.2.0\dbhome_1\WIN-QUN6TUICVJJ_ORCL\sysman\emd\agntstmp.txt:WIN-QUN6TUICVJJ does not exists. 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:34:39 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: SYS 2019-4-27 12:34:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:34:39 oracle.sysman.emcp.EMReposConfig createRepository 配置: Spooling to C:\app\ltx\cfgtoollogs\emca\ORCL\emca_repos_create_2019_04_27_12_34_39.log 2019-4-27 12:34:39 oracle.sysman.emcp.EMReposConfig createRepository 信息: 正在创建 EM 资料档案库 (此操作可能需要一段时间)... 2019-4-27 12:40:48 oracle.sysman.emcp.EMReposConfig invoke 信息: 已成功创建资料档案库 2019-4-27 12:40:48 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 EMAIL_ADDRESS 的值。 2019-4-27 12:40:48 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 MAIL_SERVER_NAME 的值。 2019-4-27 12:40:48 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 MAIL_SERVER_SENDER_NAME 的值。 2019-4-27 12:40:48 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 MAIL_SERVER_SENDER_ADDR 的值。 2019-4-27 12:40:48 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:40:48 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:40:48 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:40:48 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:40:48 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:40:48 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: SYS 2019-4-27 12:40:48 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:40:48 oracle.sysman.emcp.EMReposConfig unlockAccounts 配置: Unlocking dbsnmp and sysman 2019-4-27 12:40:48 oracle.sysman.emcp.EMReposConfig invoke 配置: Successfully unlocked relevant accounts 2019-4-27 12:40:48 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:40:48 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:40:48 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:40:48 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:40:48 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:40:48 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: SYS 2019-4-27 12:40:48 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:40:50 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs 配置: Finished executing emreposoutofbox.sql 2019-4-27 12:40:50 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:40:50 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:40:50 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:40:50 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:40:50 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:40:50 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: SYSMAN 2019-4-27 12:40:51 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:40:51 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs 配置: Submitting dbms job: C:\app\ltx\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\latest\admin\admin_submit_dbms_jobs.sql 2019-4-27 12:40:51 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs 配置: Successfully submitted dbms job 2019-4-27 12:40:51 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:40:51 oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl 配置: connectDesc : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-QUN6TUICVJJ)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCL))) 2019-4-27 12:40:51 oracle.sysman.emcp.ParamsManager getHost 配置: Host having instnces running for database ORCL : WIN-QUN6TUICVJJ 2019-4-27 12:40:51 oracle.sysman.emcp.ParamsManager setParam 配置: Setting param: REP_DB_RUNNING_HOST value: WIN-QUN6TUICVJJ 2019-4-27 12:40:51 oracle.sysman.emcp.ParamsManager getRepDbPort 配置: Listener Port: 1521 2019-4-27 12:40:51 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired 配置: isLocalConnectionRequired: true 2019-4-27 12:40:51 oracle.sysman.emcp.util.GeneralUtil initSQLEngine 配置: isLocalConnectionRequired: true. Connecting to database instance locally. 2019-4-27 12:40:51 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine connecting with SID: orcl, oracleHome: C:\app\ltx\product\11.2.0\dbhome_1, and user: SYS 2019-4-27 12:40:51 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly 配置: SQLEngine created successfully and connected 2019-4-27 12:40:51 oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl 配置: Passed listener validation check.Listener is up and running. 2019-4-27 12:40:51 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount 配置: Unlocking mgmt view user account 2019-4-27 12:40:51 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount 配置: view user sql: declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; 2019-4-27 12:40:51 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:40:51 oracle.sysman.emcp.util.PlatformInterface executeCommand 配置: 开始执行: CMD /C C:\app\ltx\product\11.2.0\dbhome_1\sysman\admin\scripts\emca\emcaDbUtil.bat "C:\app\ltx\product\11.2.0\dbhome_1\sysman\admin\scripts;C:\app\ltx\product\11.2.0\dbhome_1\bin;" C:/app/ltx/product/11.2.0/dbhome_1/perl/bin\perl.exe C:\app\ltx\product\11.2.0\dbhome_1\sysman\admin\scripts\emca\emcaDbUtil.pl C:\app\ltx\product\11.2.0\dbhome_1 "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-QUN6TUICVJJ)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCL)))" SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; orcl 1 SYSMAN_PWD 2019-4-27 12:40:52 oracle.sysman.emcp.util.PlatformInterface executeCommand 配置: Exit value of 0 2019-4-27 12:40:52 oracle.sysman.emcp.util.PlatformInterface executeCommand 配置: 已成功执行 CMD /C C:\app\ltx\product\11.2.0\dbhome_1\sysman\admin\scripts\emca\emcaDbUtil.bat "C:\app\ltx\product\11.2.0\dbhome_1\sysman\admin\scripts;C:\app\ltx\product\11.2.0\dbhome_1\bin;" C:/app/ltx/product/11.2.0/dbhome_1/perl/bin\perl.exe C:\app\ltx\product\11.2.0\dbhome_1\sysman\admin\scripts\emca\emcaDbUtil.pl C:\app\ltx\product\11.2.0\dbhome_1 "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-QUN6TUICVJJ)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCL)))" SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; orcl 1 SYSMAN_PWD 2019-4-27 12:40:52 oracle.sysman.emcp.util.PlatformInterface executeCommand 配置: Arguments passed C:\app\ltx\product\11.2.0\dbhome_1 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-QUN6TUICVJJ)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCL))) SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; orcl 1 SYSMAN_PWD Connecting to database using connect string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-QUN6TUICVJJ)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCL))) in home C:\app\ltx\product\11.2.0\dbhome_1 with user "SYS" role "SYSDBA". connected to database. sql to execute declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; noOfParams to bind: 1. sql execute successfully. 2019-4-27 12:40:52 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount 配置: Unlocked mgmt_view account 2019-4-27 12:40:52 oracle.sysman.emcp.EMReposConfig invoke 配置: Successfully unlocked mgmt_view account 2019-4-27 12:40:52 oracle.sysman.emcp.ParamsManager getParam 配置: 未设置参数 ORACLE_HOSTNAME 的值。 2019-4-27 12:40:52 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository 信息: 正在将配置数据上载到 EM 资料档案库 (此操作可能需要一段时间)... 2019-4-27 12:40:54 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository 配置: 将配置数据上载到资料档案库时出错 oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232) at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:699) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:385) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522) 2019-4-27 12:40:54 oracle.sysman.emcp.EMReposConfig invoke 信息: 有关详细资料, 请参阅 C:\app\ltx\cfgtoollogs\emca\ORCL\emca_repos_config_<日期>.log 中的日志文件。 2019-4-27 12:40:54 oracle.sysman.emcp.EMReposConfig invoke 严重: 将配置数据上载到资料档案库时出错 2019-4-27 12:40:54 oracle.sysman.emcp.EMConfig perform 严重: 将配置数据上载到资料档案库时出错 有关详细资料, 请参阅 C:\app\ltx\cfgtoollogs\emca\ORCL\emca_2019_04_27_12_34_03.log 中的日志文件。 2019-4-27 12:40:54 oracle.sysman.emcp.EMConfig perform 配置: Stack Trace: oracle.sysman.emcp.exception.EMConfigException: 将配置数据上载到资料档案库时出错 at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:397) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522) 2019-4-27 12:40:54 oracle.sysman.emcp.EMConfig restoreOuiLoc 配置: Restoring oracle.installer.oui_loc to C:\app\ltx\product\11.2.0\dbhome_1\oui 请问要怎么解决呀?
不知道是不是Oracle11g 11.0.4.0的一个bug
创建一个含有子分区的表(如下),然后执行一条查询语句,条件是主分区的一个范围值(范围要大于1048576)。在11.0.0.4下会抛一个错:ora-00600,具体什么忘记了,里面有一个数字是1048576。大家可以试一下,在11.0.1.0下不会出错。 不知道什么原因 CREATE TABLE HR.T_TEST ( ID NUMBER, NAME VARCHAR2(10) ) PARTITION BY RANGE (ID) INTERVAL( 1) SUBPARTITION BY HASH (NAME) SUBPARTITIONS 5 ( PARTITION P1 VALUES LESS THAN (1) ) ; SELECT * FROM HR.T_TEST WHERE ID BETWEEN 1 AND 234123123123;
关于Ubuntu14安装oracle11.0.2.0.4依赖包的问题
在安装依赖包的过程中出现两个依赖包不能安装: 1、未发现软件包 lesstif2 2、未发现软件包 libpthread-stubs0 各位大神如果没有这两个依赖包能安装么?会不会出错我这边是直接连接远程服务器 安装出错的话就会很麻烦,很麻烦,很麻烦
No provider available from registry ip for service com.zys.store.service.api.HelloServiceApi:1.0.0 on consumer ip use dubbo version 2.6.2
springboot整合zookeeper和dubbo报错 linux上zk版本号是3.4.14 项目用的zk包是3.4.9 dubbo用的是2.6.2 springboot是2.1.6 用main方式先运行store的模块 再运行order的模块 这个时候用浏览器去访问http://localhost:8088/hello?name=zys这个时候控制台就报错No provider available from registry 启动的时候不报错 浏览器访问就报错了 看zk日志有说是HelloServiceApi这个类的节点已经存在 但是我觉得跟这个问题不大 因为运行一次就会创建一个节点 多次的话肯定报节点存在的错 我的linux是虚拟机 并且已经关闭了防火墙 不存在端口跑不通的情况 1. 项目架构是maven的聚合项目![图片说明](https://img-ask.csdn.net/upload/201911/20/1574220333_973372.png) 2. 在zys-store-api写接口 package com.zys.store.service.api; public interface HelloServiceApi { String sayHello(String name); } 3.在zys-store暴露接口 package com.zys.store.service.provider; import com.alibaba.dubbo.config.annotation.Service; import com.zys.store.service.api.HelloServiceApi; @Service( version = "1.0.0", application = "zys-store", protocol = "dubbo", registry = "zys-store-registry" ) public class HelloServiceProvider implements HelloServiceApi{ @Override public String sayHello(String name) { return "hello" + name; } } 下面是zys-store的yml的配置 dubbo: application: id: zys-store name: zys-store qos-port: 22212 qos-enable: true scan: base-packages: com.zys.store.* protocol: id: dubbo name: dubbo port: 12343 registry: id: zys-store-registry address: zookeeper://192.168.146.132:2181?backup=192.168.146.131:2181,192.168.146.133:2181 4.在zys-order调用接口 package com.zys.order.controller; import com.alibaba.dubbo.config.annotation.Reference; import com.zys.store.service.api.HelloServiceApi; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; import javax.annotation.Resource; @RestController public class HelloController { @Reference( version = "1.0.0", application = "zys-order", interfaceName = "com.zys.store.service.api.HelloServiceApi", check = false, timeout = 3000, retries = 0 //读请求3次 写请求不重复 ) private HelloServiceApi helloServiceApi; @RequestMapping("/hello") public String hello(@RequestParam("name") String name){ return helloServiceApi.sayHello(name); } } 下面是zys-order的yml的配置 ```dubbo: application: id: zys-order name: zys-order qos-port: 22211 qos-enable: true qos-accept-foreign-ip: false scan: base-packages: com.zys.order.* protocol: id: dubbo name: dubbo port: 12343 registry: id: zys-order-registry address: zookeeper://192.168.146.132:2181?backup=192.168.146.131:2181,192.168.146.133:2181 store端的启动日志 2019-11-20 10:18:35.426 INFO 50632 --- [ main] a.b.d.c.e.WelcomeLogoApplicationListener : :: Dubbo Spring Boot (v0.2.0) : https://github.com/apache/incubator-dubbo-spring-boot-project :: Dubbo (v2.6.2) : https://github.com/apache/incubator-dubbo :: Google group : dev@dubbo.incubator.apache.org 2019-11-20 10:18:35.430 INFO 50632 --- [ main] e.OverrideDubboConfigApplicationListener : Dubbo Config was overridden by externalized configuration {dubbo.application.id=zys-store, dubbo.application.name=zys-store, dubbo.application.qos-enable=true, dubbo.application.qos-port=22212, dubbo.protocol.id=dubbo, dubbo.protocol.name=dubbo, dubbo.protocol.port=12343, dubbo.registry.address=zookeeper://192.168.146.132:2181?backup=192.168.146.131:2181,192.168.146.133:2181, dubbo.registry.id=zys-store-registry, dubbo.scan.base-packages=com.zys.store.*} . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.1.6.RELEASE) 2019-11-20 10:18:35.488 INFO 50632 --- [ main] com.zys.store.ZysStoreApplication : Starting ZysStoreApplication on DESKTOP-O0S84K8 with PID 50632 (D:\ideaworkspace\zys-project\zys-store\target\classes started by Administrator in D:\ideaworkspace\zys-project) 2019-11-20 10:18:35.489 INFO 50632 --- [ main] com.zys.store.ZysStoreApplication : No active profile set, falling back to default profiles: default 2019-11-20 10:18:35.963 WARN 50632 --- [ main] o.m.s.mapper.ClassPathMapperScanner : No MyBatis mapper was found in '[com.zys.store.dao, com.zys.store.mapper]' package. Please check your configuration. 2019-11-20 10:18:36.030 WARN 50632 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-configs' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:36.031 WARN 50632 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-properties' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:36.031 WARN 50632 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-references' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:36.031 WARN 50632 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-services' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:36.031 WARN 50632 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-shutdown' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:36.037 INFO 50632 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The dubbo config bean definition [name : zys-store, class : com.alibaba.dubbo.config.ApplicationConfig] has been registered. 2019-11-20 10:18:36.037 INFO 50632 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The BeanPostProcessor bean definition [com.alibaba.dubbo.config.spring.beans.factory.annotation.DubboConfigBindingBeanPostProcessor] for dubbo config bean [name : zys-store] has been registered. 2019-11-20 10:18:36.037 INFO 50632 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The dubbo config bean definition [name : zys-store-registry, class : com.alibaba.dubbo.config.RegistryConfig] has been registered. 2019-11-20 10:18:36.037 INFO 50632 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The BeanPostProcessor bean definition [com.alibaba.dubbo.config.spring.beans.factory.annotation.DubboConfigBindingBeanPostProcessor] for dubbo config bean [name : zys-store-registry] has been registered. 2019-11-20 10:18:36.037 INFO 50632 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The dubbo config bean definition [name : dubbo, class : com.alibaba.dubbo.config.ProtocolConfig] has been registered. 2019-11-20 10:18:36.038 INFO 50632 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The BeanPostProcessor bean definition [com.alibaba.dubbo.config.spring.beans.factory.annotation.DubboConfigBindingBeanPostProcessor] for dubbo config bean [name : dubbo] has been registered. 2019-11-20 10:18:36.060 WARN 50632 --- [ main] o.m.s.mapper.ClassPathMapperScanner : No MyBatis mapper was found in '[com.zys.store]' package. Please check your configuration. 2019-11-20 10:18:36.307 INFO 50632 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'com.alibaba.boot.dubbo.autoconfigure.DubboAutoConfiguration' of type [com.alibaba.boot.dubbo.autoconfigure.DubboAutoConfiguration$$EnhancerBySpringCGLIB$$437665e0] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:36.357 INFO 50632 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'relaxedDubboConfigBinder' of type [com.alibaba.boot.dubbo.autoconfigure.RelaxedDubboConfigBinder] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:36.364 INFO 50632 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$3474c06e] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:36.382 INFO 50632 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'relaxedDubboConfigBinder' of type [com.alibaba.boot.dubbo.autoconfigure.RelaxedDubboConfigBinder] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:36.383 INFO 50632 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'relaxedDubboConfigBinder' of type [com.alibaba.boot.dubbo.autoconfigure.RelaxedDubboConfigBinder] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:36.657 INFO 50632 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8089 (http) 2019-11-20 10:18:36.675 INFO 50632 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2019-11-20 10:18:36.675 INFO 50632 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.21] 2019-11-20 10:18:36.770 INFO 50632 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2019-11-20 10:18:36.770 INFO 50632 --- [ main] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 1249 ms 2019-11-20 10:18:37.038 INFO 50632 --- [ main] .f.a.DubboConfigBindingBeanPostProcessor : The properties of bean [name : dubbo] have been binding by prefix of configuration properties : dubbo.protocol 2019-11-20 10:18:37.568 INFO 50632 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor' 2019-11-20 10:18:37.744 INFO 50632 --- [ main] .f.a.DubboConfigBindingBeanPostProcessor : The properties of bean [name : zys-store] have been binding by prefix of configuration properties : dubbo.application 2019-11-20 10:18:37.747 INFO 50632 --- [ main] .f.a.DubboConfigBindingBeanPostProcessor : The properties of bean [name : zys-store-registry] have been binding by prefix of configuration properties : dubbo.registry 2019-11-20 10:18:37.816 INFO 50632 --- [ main] com.zaxxer.hikari.HikariDataSource : MyHikariCP - Starting... 2019-11-20 10:18:37.993 INFO 50632 --- [ main] com.zaxxer.hikari.HikariDataSource : MyHikariCP - Start completed. order端的启动日志 ```2019-11-20 10:18:47.233 INFO 48096 --- [ main] a.b.d.c.e.WelcomeLogoApplicationListener : :: Dubbo Spring Boot (v0.2.0) : https://github.com/apache/incubator-dubbo-spring-boot-project :: Dubbo (v2.6.2) : https://github.com/apache/incubator-dubbo :: Google group : dev@dubbo.incubator.apache.org 2019-11-20 10:18:47.239 INFO 48096 --- [ main] e.OverrideDubboConfigApplicationListener : Dubbo Config was overridden by externalized configuration {dubbo.application.id=zys-order, dubbo.application.name=zys-order, dubbo.application.qos-accept-foreign-ip=false, dubbo.application.qos-enable=true, dubbo.application.qos-port=22211, dubbo.protocol.id=dubbo, dubbo.protocol.name=dubbo, dubbo.protocol.port=12343, dubbo.registry.address=zookeeper://192.168.146.132:2181?backup=192.168.146.131:2181,192.168.146.133:2181, dubbo.registry.id=zys-order-registry, dubbo.scan.base-packages=com.zys.order.*} . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.1.6.RELEASE) 2019-11-20 10:18:47.301 INFO 48096 --- [ main] com.zys.order.ZysOrderApplication : Starting ZysOrderApplication on DESKTOP-O0S84K8 with PID 48096 (D:\ideaworkspace\zys-project\zys-order\target\classes started by Administrator in D:\ideaworkspace\zys-project) 2019-11-20 10:18:47.302 INFO 48096 --- [ main] com.zys.order.ZysOrderApplication : No active profile set, falling back to default profiles: default 2019-11-20 10:18:47.803 WARN 48096 --- [ main] o.m.s.mapper.ClassPathMapperScanner : No MyBatis mapper was found in '[com.zys.order.dao, com.zys.order.mapper]' package. Please check your configuration. 2019-11-20 10:18:47.868 WARN 48096 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-configs' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:47.869 WARN 48096 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-properties' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:47.870 WARN 48096 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-references' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:47.870 WARN 48096 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-services' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:47.870 WARN 48096 --- [ main] o.s.boot.actuate.endpoint.EndpointId : Endpoint ID 'dubbo-shutdown' contains invalid characters, please migrate to a valid format. 2019-11-20 10:18:47.875 INFO 48096 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The dubbo config bean definition [name : zys-order, class : com.alibaba.dubbo.config.ApplicationConfig] has been registered. 2019-11-20 10:18:47.875 INFO 48096 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The BeanPostProcessor bean definition [com.alibaba.dubbo.config.spring.beans.factory.annotation.DubboConfigBindingBeanPostProcessor] for dubbo config bean [name : zys-order] has been registered. 2019-11-20 10:18:47.875 INFO 48096 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The dubbo config bean definition [name : zys-order-registry, class : com.alibaba.dubbo.config.RegistryConfig] has been registered. 2019-11-20 10:18:47.875 INFO 48096 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The BeanPostProcessor bean definition [com.alibaba.dubbo.config.spring.beans.factory.annotation.DubboConfigBindingBeanPostProcessor] for dubbo config bean [name : zys-order-registry] has been registered. 2019-11-20 10:18:47.876 INFO 48096 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The dubbo config bean definition [name : dubbo, class : com.alibaba.dubbo.config.ProtocolConfig] has been registered. 2019-11-20 10:18:47.876 INFO 48096 --- [ main] .a.d.c.s.c.a.DubboConfigBindingRegistrar : The BeanPostProcessor bean definition [com.alibaba.dubbo.config.spring.beans.factory.annotation.DubboConfigBindingBeanPostProcessor] for dubbo config bean [name : dubbo] has been registered. 2019-11-20 10:18:47.894 WARN 48096 --- [ main] o.m.s.mapper.ClassPathMapperScanner : No MyBatis mapper was found in '[com.zys.order]' package. Please check your configuration. 2019-11-20 10:18:48.164 INFO 48096 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'com.alibaba.boot.dubbo.autoconfigure.DubboAutoConfiguration' of type [com.alibaba.boot.dubbo.autoconfigure.DubboAutoConfiguration$$EnhancerBySpringCGLIB$$5fbcce96] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:48.239 INFO 48096 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$50bb2924] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:48.261 INFO 48096 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'relaxedDubboConfigBinder' of type [com.alibaba.boot.dubbo.autoconfigure.RelaxedDubboConfigBinder] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:48.263 INFO 48096 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'relaxedDubboConfigBinder' of type [com.alibaba.boot.dubbo.autoconfigure.RelaxedDubboConfigBinder] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:48.264 INFO 48096 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'relaxedDubboConfigBinder' of type [com.alibaba.boot.dubbo.autoconfigure.RelaxedDubboConfigBinder] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2019-11-20 10:18:48.482 INFO 48096 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8088 (http) 2019-11-20 10:18:48.496 INFO 48096 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2019-11-20 10:18:48.496 INFO 48096 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.21] 2019-11-20 10:18:48.596 INFO 48096 --- [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext 2019-11-20 10:18:48.596 INFO 48096 --- [ main] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 1268 ms 2019-11-20 10:18:48.847 INFO 48096 --- [ main] .f.a.DubboConfigBindingBeanPostProcessor : The properties of bean [name : dubbo] have been binding by prefix of configuration properties : dubbo.protocol 2019-11-20 10:18:49.338 INFO 48096 --- [ main] .f.a.DubboConfigBindingBeanPostProcessor : The properties of bean [name : zys-order] have been binding by prefix of configuration properties : dubbo.application 2019-11-20 10:18:49.345 INFO 48096 --- [ main] .f.a.DubboConfigBindingBeanPostProcessor : The properties of bean [name : zys-order-registry] have been binding by prefix of configuration properties : dubbo.registry 2019-11-20 10:18:49.919 INFO 48096 --- [ main] o.a.c.f.imps.CuratorFrameworkImpl : Starting 2019-11-20 10:18:58.930 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:zookeeper.version=3.4.9-1757313, built on 08/23/2016 06:50 GMT 2019-11-20 10:18:58.930 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:host.name=DESKTOP-O0S84K8 2019-11-20 10:18:58.930 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:java.version=1.8.0_211 2019-11-20 10:18:58.930 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:java.vendor=Oracle Corporation 2019-11-20 10:18:58.930 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:java.home=C:\Program Files\Java\jdk1.8.0_211\jre 2019-11-20 10:18:58.930 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:java.class.path=C:\Program Files\Java\jdk1.8.0_211\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_211\jre\lib\rt.jar;D:\ideaworkspace\zys-project\zys-order\target\classes;D:\repository\org\springframework\boot\spring-boot-starter-web\2.1.6.RELEASE\spring-boot-starter-web-2.1.6.RELEASE.jar;D:\repository\org\springframework\boot\spring-boot-starter-json\2.1.6.RELEASE\spring-boot-starter-json-2.1.6.RELEASE.jar;D:\repository\com\fasterxml\jackson\core\jackson-databind\2.9.9\jackson-databind-2.9.9.jar;D:\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.9.9\jackson-datatype-jdk8-2.9.9.jar;D:\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.9.9\jackson-datatype-jsr310-2.9.9.jar;D:\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.9.9\jackson-module-parameter-names-2.9.9.jar;D:\repository\org\springframework\boot\spring-boot-starter-tomcat\2.1.6.RELEASE\spring-boot-starter-tomcat-2.1.6.RELEASE.jar;D:\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.21\tomcat-embed-core-9.0.21.jar;D:\repository\org\apache\tomcat\embed\tomcat-embed-el\9.0.21\tomcat-embed-el-9.0.21.jar;D:\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.21\tomcat-embed-websocket-9.0.21.jar;D:\repository\org\hibernate\validator\hibernate-validator\6.0.17.Final\hibernate-validator-6.0.17.Final.jar;D:\repository\javax\validation\validation-api\2.0.1.Final\validation-api-2.0.1.Final.jar;D:\repository\org\jboss\logging\jboss-logging\3.3.2.Final\jboss-logging-3.3.2.Final.jar;D:\repository\com\fasterxml\classmate\1.4.0\classmate-1.4.0.jar;D:\repository\org\springframework\spring-web\5.1.8.RELEASE\spring-web-5.1.8.RELEASE.jar;D:\repository\org\springframework\spring-beans\5.1.8.RELEASE\spring-beans-5.1.8.RELEASE.jar;D:\repository\org\springframework\spring-webmvc\5.1.8.RELEASE\spring-webmvc-5.1.8.RELEASE.jar;D:\repository\org\springframework\spring-aop\5.1.8.RELEASE\spring-aop-5.1.8.RELEASE.jar;D:\repository\org\springframework\spring-context\5.1.8.RELEASE\spring-context-5.1.8.RELEASE.jar;D:\repository\org\springframework\spring-expression\5.1.8.RELEASE\spring-expression-5.1.8.RELEASE.jar;D:\repository\org\springframework\boot\spring-boot-starter-actuator\2.1.6.RELEASE\spring-boot-starter-actuator-2.1.6.RELEASE.jar;D:\repository\org\springframework\boot\spring-boot-actuator-autoconfigure\2.1.6.RELEASE\spring-boot-actuator-autoconfigure-2.1.6.RELEASE.jar;D:\repository\org\springframework\boot\spring-boot-actuator\2.1.6.RELEASE\spring-boot-actuator-2.1.6.RELEASE.jar;D:\repository\io\micrometer\micrometer-core\1.1.5\micrometer-core-1.1.5.jar;D:\repository\org\latencyutils\LatencyUtils\2.0.3\LatencyUtils-2.0.3.jar;D:\repository\org\springframework\spring-core\5.1.8.RELEASE\spring-core-5.1.8.RELEASE.jar;D:\repository\org\springframework\spring-jcl\5.1.8.RELEASE\spring-jcl-5.1.8.RELEASE.jar;D:\repository\org\springframework\boot\spring-boot-starter-jdbc\2.1.6.RELEASE\spring-boot-starter-jdbc-2.1.6.RELEASE.jar;D:\repository\com\zaxxer\HikariCP\3.2.0\HikariCP-3.2.0.jar;D:\repository\org\springframework\spring-jdbc\5.1.8.RELEASE\spring-jdbc-5.1.8.RELEASE.jar;D:\repository\org\springframework\spring-tx\5.1.8.RELEASE\spring-tx-5.1.8.RELEASE.jar;D:\repository\com\baomidou\mybatis-plus-boot-starter\3.1.1\mybatis-plus-boot-starter-3.1.1.jar;D:\repository\com\baomidou\mybatis-plus\3.1.1\mybatis-plus-3.1.1.jar;D:\repository\com\baomidou\mybatis-plus-extension\3.1.1\mybatis-plus-extension-3.1.1.jar;D:\repository\com\baomidou\mybatis-plus-core\3.1.1\mybatis-plus-core-3.1.1.jar;D:\repository\com\baomidou\mybatis-plus-annotation\3.1.1\mybatis-plus-annotation-3.1.1.jar;D:\repository\com\github\jsqlparser\jsqlparser\1.2\jsqlparser-1.2.jar;D:\repository\org\mybatis\mybatis\3.5.1\mybatis-3.5.1.jar;D:\repository\org\mybatis\mybatis-spring\2.0.1\mybatis-spring-2.0.1.jar;D:\repository\org\springframework\boot\spring-boot-autoconfigure\2.1.6.RELEASE\spring-boot-autoconfigure-2.1.6.RELEASE.jar;D:\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;D:\repository\mysql\mysql-connector-java\6.0.6\mysql-connector-java-6.0.6.jar;D:\repository\com\alibaba\boot\dubbo-spring-boot-starter\0.2.0\dubbo-spring-boot-starter-0.2.0.jar;D:\repository\com\alibaba\dubbo\2.6.2\dubbo-2.6.2.jar;D:\repository\org\javassist\javassist\3.20.0-GA\javassist-3.20.0-GA.jar;D:\repository\org\jboss\netty\netty\3.2.5.Final\netty-3.2.5.Final.jar;D:\repository\org\apache\zookeeper\zookeeper\3.4.9\zookeeper-3.4.9.jar;D:\repository\jline\jline\0.9.94\jline-0.9.94.jar;D:\repository\io\netty\netty\3.10.5.Final\netty-3.10.5.Final.jar;D:\repository\org\apache\curator\curator-framework\2.12.0\curator-framework-2.12.0.jar;D:\repository\org\apache\curator\curator-client\2.12.0\curator-client-2.12.0.jar;D:\repository\com\alibaba\boot\dubbo-spring-boot-autoconfigure\0.2.0\dubbo-spring-boot-autoconfigure-0.2.0.jar;D:\repository\com\alibaba\boot\dubbo-spring-boot-actuator\0.2.0\dubbo-spring-boot-actuator-0.2.0.jar;D:\repository\com\netflix\hystrix\hystrix-core\1.5.12\hystrix-core-1.5.12.jar;D:\repository\org\slf4j\slf4j-api\1.7.26\slf4j-api-1.7.26.jar;D:\repository\com\netflix\archaius\archaius-core\0.4.1\archaius-core-0.4.1.jar;D:\repository\commons-configuration\commons-configuration\1.8\commons-configuration-1.8.jar;D:\repository\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;D:\repository\io\reactivex\rxjava\1.3.8\rxjava-1.3.8.jar;D:\repository\org\hdrhistogram\HdrHistogram\2.1.9\HdrHistogram-2.1.9.jar;D:\repository\com\netflix\hystrix\hystrix-metrics-event-stream\1.5.12\hystrix-metrics-event-stream-1.5.12.jar;D:\repository\com\netflix\hystrix\hystrix-serialization\1.5.12\hystrix-serialization-1.5.12.jar;D:\repository\com\fasterxml\jackson\module\jackson-module-afterburner\2.9.9\jackson-module-afterburner-2.9.9.jar;D:\repository\com\fasterxml\jackson\core\jackson-core\2.9.9\jackson-core-2.9.9.jar;D:\repository\com\fasterxml\jackson\core\jackson-annotations\2.9.0\jackson-annotations-2.9.0.jar;D:\repository\com\netflix\hystrix\hystrix-javanica\1.5.12\hystrix-javanica-1.5.12.jar;D:\repository\org\aspectj\aspectjrt\1.9.4\aspectjrt-1.9.4.jar;D:\repository\org\apache\commons\commons-lang3\3.3.1\commons-lang3-3.3.1.jar;D:\repository\org\ow2\asm\asm\5.0.4\asm-5.0.4.jar;D:\repository\org\aspectj\aspectjweaver\1.9.4\aspectjweaver-1.9.4.jar;D:\repository\com\google\guava\guava\15.0\guava-15.0.jar;D:\repository\com\google\code\findbugs\jsr305\2.0.0\jsr305-2.0.0.jar;D:\repository\org\apache\rocketmq\rocketmq-client\4.3.0\rocketmq-client-4.3.0.jar;D:\repository\org\apache\rocketmq\rocketmq-common\4.3.0\rocketmq-common-4.3.0.jar;D:\repository\org\apache\rocketmq\rocketmq-remoting\4.3.0\rocketmq-remoting-4.3.0.jar;D:\repository\com\alibaba\fastjson\1.2.29\fastjson-1.2.29.jar;D:\repository\io\netty\netty-all\4.1.36.Final\netty-all-4.1.36.Final.jar;D:\repository\org\apache\rocketmq\rocketmq-logging\4.3.0\rocketmq-logging-4.3.0.jar;D:\repository\io\netty\netty-tcnative-boringssl-static\2.0.25.Final\netty-tcnative-boringssl-static-2.0.25.Final.jar;D:\repository\com\zys\zys-store-api\0.0.1-SNAPSHOT\zys-store-api-0.0.1-SNAPSHOT.jar;D:\repository\org\springframework\boot\spring-boot-starter\2.1.6.RELEASE\spring-boot-starter-2.1.6.RELEASE.jar;D:\repository\org\springframework\boot\spring-boot\2.1.6.RELEASE\spring-boot-2.1.6.RELEASE.jar;D:\repository\org\springframework\boot\spring-boot-starter-logging\2.1.6.RELEASE\spring-boot-starter-logging-2.1.6.RELEASE.jar;D:\repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;D:\repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;D:\repository\org\apache\logging\log4j\log4j-to-slf4j\2.11.2\log4j-to-slf4j-2.11.2.jar;D:\repository\org\apache\logging\log4j\log4j-api\2.11.2\log4j-api-2.11.2.jar;D:\repository\org\slf4j\jul-to-slf4j\1.7.26\jul-to-slf4j-1.7.26.jar;D:\repository\javax\annotation\javax.annotation-api\1.3.2\javax.annotation-api-1.3.2.jar;D:\repository\org\yaml\snakeyaml\1.23\snakeyaml-1.23.jar;D:\idea\IntelliJ IDEA 2019.2\lib\idea_rt.jar 2019-11-20 10:18:58.930 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:java.library.path=C:\Program Files\Java\jdk1.8.0_211\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;D:\idea\IntelliJ IDEA 2019.2\jbr\\bin;D:\idea\IntelliJ IDEA 2019.2\jbr\\bin\server;D:\oracleClient\product\11.2.0\client_1\bin;D:\xshell\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\Java\jdk1.8.0_211;D:\Git\cmd;C:\Program Files\MySQL\MySQL Server 5.7\bin;D:\TortoiseSVN1.10\bin;D:\apache-maven-idea\bin;C:\Users\Administrator\AppData\Local\Microsoft\WindowsApps;;. 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:java.io.tmpdir=C:\Users\ADMINI~1\AppData\Local\Temp\ 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:java.compiler=<NA> 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:os.name=Windows 10 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:os.arch=amd64 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:os.version=10.0 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:user.name=Administrator 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:user.home=C:\Users\Administrator 2019-11-20 10:18:58.931 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Client environment:user.dir=D:\ideaworkspace\zys-project 2019-11-20 10:18:58.932 INFO 48096 --- [ main] org.apache.zookeeper.ZooKeeper : Initiating client connection, connectString=192.168.146.132:2181,192.168.146.131:2181,192.168.146.133:2181 sessionTimeout=60000 watcher=org.apache.curator.ConnectionState@5a3a1bf9 2019-11-20 10:18:58.942 INFO 48096 --- [8.146.132:2181)] org.apache.zookeeper.ClientCnxn : Opening socket connection to server 192.168.146.132/192.168.146.132:2181. Will not attempt to authenticate using SASL (unknown error) 2019-11-20 10:18:58.942 INFO 48096 --- [8.146.132:2181)] org.apache.zookeeper.ClientCnxn : Socket connection established to 192.168.146.132/192.168.146.132:2181, initiating session 2019-11-20 10:18:58.953 INFO 48096 --- [8.146.132:2181)] org.apache.zookeeper.ClientCnxn : Session establishment complete on server 192.168.146.132/192.168.146.132:2181, sessionid = 0x200000235350000, negotiated timeout = 40000 2019-11-20 10:18:58.957 INFO 48096 --- [ain-EventThread] o.a.c.f.state.ConnectionStateManager : State change: CONNECTED 2019-11-20 10:18:59.030 INFO 48096 --- [ main] c.a.d.c.s.b.f.a.ReferenceBeanBuilder : <dubbo:reference object="com.alibaba.dubbo.common.bytecode.proxy0@3b5c665c" singleton="true" interface="com.zys.store.service.api.HelloServiceApi" uniqueServiceName="com.zys.store.service.api.HelloServiceApi:1.0.0" generic="false" version="1.0.0" check="false" timeout="3000" id="com.zys.store.service.api.HelloServiceApi" /> has been built. 2019-11-20 10:18:59.242 INFO 48096 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor' 2019-11-20 10:18:59.420 INFO 48096 --- [ main] com.zaxxer.hikari.HikariDataSource : MyHikariCP - Starting... 2019-11-20 10:18:59.592 INFO 48096 --- [ main] com.zaxxer.hikari.HikariDataSource : MyHikariCP - Start completed. _ _ |_ _ _|_. ___ _ | _ | | |\/|_)(_| | |_\ |_)||_|_\ / | 3.1.1 2019-11-20 10:18:59.836 INFO 48096 --- [ main] o.s.b.a.e.web.EndpointLinksResolver : Exposing 2 endpoint(s) beneath base path '/actuator' 2019-11-20 10:18:59.897 INFO 48096 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8088 (http) with context path '' 2019-11-20 10:18:59.899 INFO 48096 --- [ main] com.zys.order.ZysOrderApplication : Started ZysOrderApplication in 12.907 seconds (JVM running for 13.464) 2019-11-20 10:18:59.956 INFO 48096 --- [-192.168.255.54] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet' 2019-11-20 10:18:59.956 INFO 48096 --- [-192.168.255.54] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet' 2019-11-20 10:18:59.969 INFO 48096 --- [-192.168.255.54] o.s.web.servlet.DispatcherServlet : Completed initialization in 13 ms ```
springboot 连接不到oracle
java.sql.SQLException: ORA-01017: 用户名/口令无效; 登录被拒绝 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:456) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:451) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1040) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:552) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:501) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1292) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1025) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:119) ~[HikariCP-3.2.0.jar:na] at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369) ~[HikariCP-3.2.0.jar:na] at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198) ~[HikariCP-3.2.0.jar:na] at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467) [HikariCP-3.2.0.jar:na] at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541) [HikariCP-3.2.0.jar:na] at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) [HikariCP-3.2.0.jar:na] at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) [HikariCP-3.2.0.jar:na] at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157) [spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115) [spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78) [spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:82) [mybatis-spring-2.0.1.jar:2.0.1] at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:68) [mybatis-spring-2.0.1.jar:2.0.1] at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336) [mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85) [mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) [mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) [mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) [mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) [mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) [mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) [mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) [mybatis-3.5.1.jar:3.5.1] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_144] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_144] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_144] at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_144] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) [mybatis-spring-2.0.1.jar:2.0.1] at com.sun.proxy.$Proxy58.selectList(Unknown Source) [na:na] at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) [mybatis-spring-2.0.1.jar:2.0.1] at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147) [mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80) [mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58) [mybatis-3.5.1.jar:3.5.1] at com.sun.proxy.$Proxy59.list(Unknown Source) [na:na] at com.bw.service.T_UserServiceImpl.list(T_UserServiceImpl.java:51) [classes/:na] at com.bw.controller.T_UserController.list(T_UserController.java:27) [classes/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_144] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_144] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_144] at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_144] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) [spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) [spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) [spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) [spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) [spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) [spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) [spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) [spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) [spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.16.jar:9.0.16] at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_144] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_144] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.16.jar:9.0.16] at java.lang.Thread.run(Unknown Source) [na:1.8.0_144] 2019-08-14 16:43:34.873 ERROR 31464 --- [nio-8080-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: ORA-01017: 用户名/口令无效; 登录被拒绝 ### The error may exist in file [F:\DianShang\YongHu\target\classes\com\bw\mapper\T_UserMapper.xml] ### The error may involve com.bw.mapper.T_UserMapper.list ### The error occurred while executing a query ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: ORA-01017: 用户名/口令无效; 登录被拒绝 ] with root cause java.sql.SQLException: ORA-01017: 用户名/口令无效; 登录被拒绝 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:456) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:451) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1040) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:552) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:501) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1292) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1025) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562) ~[ojdbc8-19.3.0.0.0.jar:19.3.0.0.0] at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:119) ~[HikariCP-3.2.0.jar:na] at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369) ~[HikariCP-3.2.0.jar:na] at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198) ~[HikariCP-3.2.0.jar:na] at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467) ~[HikariCP-3.2.0.jar:na] at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541) ~[HikariCP-3.2.0.jar:na] at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[HikariCP-3.2.0.jar:na] at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-3.2.0.jar:na] at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:82) ~[mybatis-spring-2.0.1.jar:2.0.1] at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:68) ~[mybatis-spring-2.0.1.jar:2.0.1] at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336) ~[mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85) ~[mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) ~[mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) ~[mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) ~[mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.1.jar:3.5.1] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_144] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_144] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_144] at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_144] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ~[mybatis-spring-2.0.1.jar:2.0.1] at com.sun.proxy.$Proxy58.selectList(Unknown Source) ~[na:na] at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) ~[mybatis-spring-2.0.1.jar:2.0.1] at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147) ~[mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80) ~[mybatis-3.5.1.jar:3.5.1] at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58) ~[mybatis-3.5.1.jar:3.5.1] at com.sun.proxy.$Proxy59.list(Unknown Source) ~[na:na] at com.bw.service.T_UserServiceImpl.list(T_UserServiceImpl.java:51) ~[classes/:na] at com.bw.controller.T_UserController.list(T_UserController.java:27) ~[classes/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_144] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_144] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_144] at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_144] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) ~[tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) [tomcat-embed-core-9.0.16.jar:9.0.16] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.16.jar:9.0.16] at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_144] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_144] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.16.jar:9.0.16] at java.lang.Thread.run(Unknown Source) [na:1.8.0_144] plsql能连接用户,但是项目死活就是连不上百度了好多方法都不行
求hibernate大神啊~~~~~~~~~~~~~~~~~
![图片说明](https://img-ask.csdn.net/upload/201507/23/1437645445_857857.png) 如上图hql,我要做一个时间的降序,时间是经过str处理的,如果直接把这个函数作为条件,查询是可以查询,但是会影响效率,所以我想加给别名,但是一直不能用报错~~~ Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "T": 标识符无效 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) ~[ojdbc6-11.2.0.4.jar:11.2.0.4.0] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) ~[ojdbc6-11.2.0.4.jar:11.2.0.4.0] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) ~[ojdbc6-11.2.0.4.jar:11.2.0.4.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) ~[ojdbc6-11.2.0.4.jar:11.2.0.4.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) ~[ojdbc6-11.2.0.4.jar:11.2.0.4.0] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) ~[ojdbc6-11.2.0.4.jar:11.2.0.4.0] 。。。。
阿里巴巴连接池断开连接
环境:spring spring mvc mybatis的maven项目。 问题:使用阿里巴巴连接池、登录后如果不去操作等待5分钟的样子就会报错如下: 23:28:14.801 [Druid-ConnectionPool-Destroy-1512369669] ERROR com.alibaba.druid.util.JdbcUtils - close connection error java.sql.SQLRecoverableException: IO 错误: Software caused connection abort: recv failed at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:504) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:3754) ~[ojdbc6-11.2.jar:11.2.0.1.0] at com.alibaba.druid.filter.FilterChainImpl.connection_close(FilterChainImpl.java:169) ~[druid-1.0.20.jar:1.0.20] at com.alibaba.druid.filter.stat.StatFilter.connection_close(StatFilter.java:254) ~[druid-1.0.20.jar:1.0.20] at com.alibaba.druid.filter.FilterChainImpl.connection_close(FilterChainImpl.java:165) ~[druid-1.0.20.jar:1.0.20] at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.close(ConnectionProxyImpl.java:115) ~[druid-1.0.20.jar:1.0.20] at com.alibaba.druid.util.JdbcUtils.close(JdbcUtils.java:83) ~[druid-1.0.20.jar:1.0.20] at com.alibaba.druid.pool.DruidDataSource.shrink(DruidDataSource.java:2297) [druid-1.0.20.jar:1.0.20] at com.alibaba.druid.pool.DruidDataSource$DestroyTask.run(DruidDataSource.java:2084) [druid-1.0.20.jar:1.0.20] at com.alibaba.druid.pool.DruidDataSource$DestroyConnectionThread.run(DruidDataSource.java:2071) [druid-1.0.20.jar:1.0.20] Caused by: java.net.SocketException: Software caused connection abort: recv failed at java.net.SocketInputStream.socketRead0(Native Method) ~[na:1.7.0_67] at java.net.SocketInputStream.read(SocketInputStream.java:152) ~[na:1.7.0_67] at java.net.SocketInputStream.read(SocketInputStream.java:122) ~[na:1.7.0_67] at oracle.net.ns.Packet.receive(Packet.java:282) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.net.ns.DataPacket.receive(DataPacket.java:103) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:230) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.net.ns.NetInputStream.read(NetInputStream.java:175) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.net.ns.NetInputStream.read(NetInputStream.java:100) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.net.ns.NetInputStream.read(NetInputStream.java:85) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF(T4C7Ocommoncall.java:61) ~[ojdbc6-11.2.jar:11.2.0.1.0] at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:491) ~[ojdbc6-11.2.jar:11.2.0.1.0] ... 9 common frames omitted 然后继续使用如果登录还未失效就会等很久才响应、页面才加载出来。​ 数据库使用的:oracle 配置如下: <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> <!-- 数据库基本信息配置 --> <property name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <property name="driverClassName" value="${jdbc.driverClassName}" /> <property name="filters" value="stat" /> <!-- 初始化连接数量 --> <property name="initialSize" value="1" /> <!-- 最小空闲连接数 --> <property name="minIdle" value="1" /> <!-- 最大并发连接数 --> <property name="maxActive" value="20" /> <!-- 配置获取连接等待超时的时间 --> <property name="maxWait" value="60000" /> <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 --> <property name="timeBetweenEvictionRunsMillis" value="60000" /> <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 --> <property name="minEvictableIdleTimeMillis" value="300000" /> <property name="removeAbandoned" value="true" /> <property name="removeAbandonedTimeout" value="1800" /> <!-- 申请连接的时候检测 --> <property name="testWhileIdle" value="true" /> <!-- 检测连接是否可用 --> <property name="validationQuery" value="SELECT 1 FROM DUAL" /> <!-- 申请连接时执行validationQuery检测连接是否有效 --> <property name="testOnBorrow" value="false" /> <!-- 归还连接时执行validationQuery检测连接是否有效 --> <property name="testOnReturn" value="false" /> <!-- 打开PSCache,并且指定每个连接上PSCache的大小 --> <property name="poolPreparedStatements" value="true" /> <property name="maxPoolPreparedStatementPerConnectionSize" value="20" /> </bean> ​ 请问有人知道怎么回事吗?
Connection reset by peer: socket write error
这个错误在网上能查到很多结果,但是我参照做都没有效果,现在问题依然存在,详细的错误信息如下 2014-05-01 21:46:37 -close connection error java.sql.SQLRecoverableException: IO 错误: Connection reset by peer: socket write error at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:587) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:4011) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] at com.alibaba.druid.filter.FilterChainImpl.connection_close(FilterChainImpl.java:167) [druid-1.0.0.jar:1.0.0] at com.alibaba.druid.filter.stat.StatFilter.connection_close(StatFilter.java:254) [druid-1.0.0.jar:1.0.0] at com.alibaba.druid.filter.FilterChainImpl.connection_close(FilterChainImpl.java:163) [druid-1.0.0.jar:1.0.0] at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.close(ConnectionProxyImpl.java:115) ~[druid-1.0.0.jar:1.0.0] at com.alibaba.druid.util.JdbcUtils.close(JdbcUtils.java:82) ~[druid-1.0.0.jar:1.0.0] at com.alibaba.druid.pool.DruidDataSource.discardConnection(DruidDataSource.java:967) [druid-1.0.0.jar:1.0.0] at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:934) [druid-1.0.0.jar:1.0.0] at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4534) [druid-1.0.0.jar:1.0.0] at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:661) [druid-1.0.0.jar:1.0.0] at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4530) [druid-1.0.0.jar:1.0.0] at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:880) [druid-1.0.0.jar:1.0.0] at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:872) [druid-1.0.0.jar:1.0.0] at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:97) [druid-1.0.0.jar:1.0.0] at org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:162) [payplat-dacq-1.0-SNAPSHOT.jar:na] at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) [payplat-dacq-1.0-SNAPSHOT.jar:na] at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) [payplat-dacq-1.0-SNAPSHOT.jar:na] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382) [payplat-dacq-1.0-SNAPSHOT.jar:na] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) [payplat-dacq-1.0-SNAPSHOT.jar:na] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464) [payplat-dacq-1.0-SNAPSHOT.jar:na] at com.payplat.util.jdbc.other.impl.JdbcServerImpl.meterList(JdbcServerImpl.java:88) [payplat-dacq-1.0-SNAPSHOT.jar:na] at com.smotive.action.DasControl.meterList(DasControl.java:52) [DasControl.class:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_45] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_45] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_45] at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_45] at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219) [spring-web-3.2.1.RELEASE.jar:3.2.1.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) [spring-web-3.2.1.RELEASE.jar:3.2.1.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) [spring-webmvc-3.2.1.RELEASE.jar:3.2.1.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745) [spring-webmvc-3.2.1.RELEASE.jar:3.2.1.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686) [spring-webmvc-3.2.1.RELEASE.jar:3.2.1.RELEASE] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) [spring-webmvc-3.2.1.RELEASE.jar:3.2.1.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925) [spring-webmvc-3.2.1.RELEASE.jar:3.2.1.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856) [spring-webmvc-3.2.1.RELEASE.jar:3.2.1.RELEASE] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:920) [spring-webmvc-3.2.1.RELEASE.jar:3.2.1.RELEASE] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:816) [spring-webmvc-3.2.1.RELEASE.jar:3.2.1.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) [servlet-api.jar:na] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:801) [spring-webmvc-3.2.1.RELEASE.jar:3.2.1.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) [servlet-api.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) [catalina.jar:6.0.35] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:6.0.35] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) [spring-web-3.2.1.RELEASE.jar:3.2.1.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-3.2.1.RELEASE.jar:3.2.1.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) [catalina.jar:6.0.35] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:6.0.35] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) [catalina.jar:6.0.35] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina.jar:6.0.35] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina.jar:6.0.35] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina.jar:6.0.35] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina.jar:6.0.35] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) [catalina.jar:6.0.35] at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877) [tomcat-coyote.jar:6.0.35] at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594) [tomcat-coyote.jar:6.0.35] at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675) [tomcat-coyote.jar:6.0.35] at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45] Caused by: java.net.SocketException: Connection reset by peer: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) ~[na:1.7.0_45] at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113) ~[na:1.7.0_45] at java.net.SocketOutputStream.write(SocketOutputStream.java:159) ~[na:1.7.0_45] at oracle.net.ns.DataPacket.send(DataPacket.java:210) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:230) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:321) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] at oracle.net.ns.NetInputStream.read(NetInputStream.java:268) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] at oracle.net.ns.NetInputStream.read(NetInputStream.java:190) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] at oracle.net.ns.NetInputStream.read(NetInputStream.java:107) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] at oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF(T4C7Ocommoncall.java:61) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:574) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0] ... 55 common frames omitted 根据网上的说法,出现的Connection reset by peer: 原因可能是多方面的,不过更常见的原因是: ①:服务器的并发连接数超过了其承载量,服务器会将其中一些连接Down掉; ②:客户关掉了浏览器,而服务器还在给客户端发送数据; ③:浏览器端按了Stop 2、3点可以排除,第一点让我觉得确实有问题,但是不知道该如何下手,还有一个问题就是,这个异常不是我手动捕获的,在我try catch前这个异常已经抛出,这个让我不解
linux上导入1个G的dmp,导出来只有不到5M
在centos7的oracle上创建新用户后,导入了一个1G多的dmp文件,再将这个用户导出时只有几个M ``` [oracle@oracle-test ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK[oracle@oracle-test ~]$ exp isc/isc@192.168.157.132:1521/orcl file=/disk3/expisc/tisc.dmp owner=isc Export: Release 11.2.0.1.0 - Production on Tue Jan 14 12:36:23 2020 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set About to export specified users ... . exporting pre-schema procedural objects and actions . exporting foreign function library names for user ISC . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user ISC About to export ISC's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export ISC's tables via Conventional Path ... . . exporting table HR_ORG_BASIC_INFO 0 rows exported . . exporting table HR_ORG_BASIC_INFO_TEMP 0 rows exported . . exporting table HR_POST_BASIC_INFO 0 rows exported . . exporting table HR_USER_BASIC_INFO 0 rows exported . . exporting table ISC_ACCOUNT 4 rows exported . . exporting table ISC_ACCOUNT_EXT_PROP 0 rows exported . . exporting table ISC_ACTOR_ROLE_R 4362 rows exported . . exporting table ISC_APPLICATION 3 rows exported . . exporting table ISC_APPSHOW_CONF 1 rows exported . . exporting table ISC_APP_CODE_CONF 0 rows exported . . exporting table ISC_APP_CODE_FIELD_EXT 0 rows exported . . exporting table ISC_APP_DATARESOUCE_R 3 rows exported . . exporting table ISC_AUTHORIZE_COMMIT 0 rows exported . . exporting table ISC_BASEORG 8801 rows exported . . exporting table ISC_BASEORG_EXT_PROP 0 rows exported . . exporting table ISC_BASEORG_SPORG_UNIT_R 0 rows exported . . exporting table ISC_COMMON_CONST 196 rows exported . . exporting table ISC_DEPLOY 2 rows exported . . exporting table ISC_DIM 0 rows exported . . exporting table ISC_DUTY 0 rows exported . . exporting table ISC_LOGIN_LOCK 36 rows exported . . exporting table ISC_MAIL_CONF 0 rows exported . . exporting table ISC_MAIL_TEMPLATE_CONF 0 rows exported . . exporting table ISC_MDMORG_SPORG_UNIT_R 0 rows exported . . exporting table ISC_MDM_ORG 0 rows exported . . exporting table ISC_MSG_RESOURCE 0 rows exported . . exporting table ISC_NODE 3 rows exported . . exporting table ISC_NODE_DEPLOY_R 2 rows exported . . exporting table ISC_ORG_ATTRIBUTE 11 rows exported . . exporting table ISC_ORG_SYS_DIM_R 0 rows exported . . exporting table ISC_ORG_UNIT_DIM_R 0 rows exported . . exporting table ISC_RESOURCE 642 rows exported . . exporting table ISC_RESOURCE_EXT_PROPERTY 172 rows exported . . exporting table ISC_RESOURCE_EXT_PROPERTY_ETL 0 rows exported . . exporting table ISC_RESOURCE_TYPE 15 rows exported . . exporting table ISC_RESOURC_TYPE_APPLICATION_R 0 rows exported . . exporting table ISC_RES_EXT_VALUE 3230 rows exported . . exporting table ISC_RES_RES_R 638 rows exported . . exporting table ISC_ROLEGROUP 8 rows exported . . exporting table ISC_ROLE_LAYER_BY_ORG 67 rows exported . . exporting table ISC_ROLE_RES_R 2947 rows exported . . exporting table ISC_SECURE_CONF 2 rows exported . . exporting table ISC_SPECIALORG_UNIT 9 rows exported . . exporting table ISC_SPECIALORG_UNIT_BAK 0 rows exported . . exporting table ISC_SPORG_EXTPROP 0 rows exported . . exporting table ISC_SPORG_EXTPROPVAL 0 rows exported . . exporting table ISC_SPORG_EXTPROP_ATTR_R 0 rows exported . . exporting table ISC_SPROLE 81 rows exported . . exporting table ISC_SPROLE_EXT 0 rows exported . . exporting table ISC_SPROLE_EXT_VALUE 0 rows exported . . exporting table ISC_SPROLE_R 0 rows exported . . exporting table ISC_SP_DOMAIN 3 rows exported . . exporting table ISC_SP_DOMAIN_CODE_RELATION 15 rows exported . . exporting table ISC_SP_ORG_SYSTEM 3 rows exported . . exporting table ISC_STRATEGY_BASEORG_R 0 rows exported . . exporting table ISC_STRATEGY_CONF 0 rows exported . . exporting table ISC_STRATEGY_SESSION 0 rows exported . . exporting table ISC_STRATEGY_USER 0 rows exported . . exporting table ISC_SYNC_LOG 0 rows exported . . exporting table ISC_SYNC_PROCESS 0 rows exported . . exporting table ISC_SYSTEM_START_CONFIG 1 rows exported . . exporting table ISC_TEMP_ACTOR_ROLE_TBL 0 rows exported . . exporting table ISC_TEMP_USER 0 rows exported . . exporting table ISC_TEMP_USER_TBL 0 rows exported . . exporting table ISC_UNIT 27 rows exported . . exporting table ISC_USER 1947 rows exported . . exporting table ISC_USER_CFCA_CONN 0 rows exported . . exporting table ISC_USER_DUTY 0 rows exported . . exporting table ISC_USER_EXT 0 rows exported . . exporting table ISC_USER_EXT_PROPERTY 0 rows exported . . exporting table ISC_USER_EXT_PROP_ERP 0 rows exported . . exporting table ISC_USER_EXT_PROP_VALUE_ERP 0 rows exported . . exporting table ISC_USER_PASSWORDUSEFULDAY 54 rows exported . . exporting table ISC_USER_PASSWORD_REPETITIONS 20 rows exported . . exporting table ISC_USER_SPORG 1557 rows exported . . exporting table ISC_WO_ACCOUNTAPPLY 0 rows exported . . exporting table ISC_WO_ACCOUNT_CHANGE 0 rows exported . . exporting table ISC_WO_APPCONF_CHANGE 0 rows exported . . exporting table ISC_WO_APPROVAL_COMMENTS 0 rows exported . . exporting table ISC_WO_APP_REGISTER 0 rows exported . . exporting table ISC_WO_ORDER 0 rows exported . . exporting table ISC_WO_ROLELIST 0 rows exported . . exporting table ISC_WO_ROLES 0 rows exported . . exporting table OPERATE_OBJ 81 rows exported . . exporting table OPERATE_TYPE 419 rows exported . . exporting table RESOURCE_DEFAULT_PROPERTY 43 rows exported . . exporting table SAS_REPORT_FILES_LOG 0 rows exported . . exporting table SAS_STANDARD_DB_LOG_201301 0 rows exported . . exporting table SAS_STANDARD_LOG_TYPE 5 rows exported . . exporting table SAS_STATISTICAL_RULES 0 rows exported . . exporting table SAS_STATISTICS_DAY_LOGIN_COUNT 44 rows exported . . exporting table SAS_STATISTICS_DAY_LOGIN_USERS 53 rows exported . . exporting table SAS_STATISTICS_SP_VISIT_COUNT 1 rows exported . . exporting table USER_VERIFY 6 rows exported . exporting synonyms . exporting views . exporting stored procedures . exporting operators . exporting referential integrity constraints . exporting triggers . exporting indextypes . exporting bitmap, functional and extensible indexes . exporting posttables actions . exporting materialized views . exporting snapshot logs . exporting job queues . exporting refresh groups and children . exporting dimensions . exporting post-schema procedural objects and actions . exporting statistics Export terminated successfully without warnings. ``` 请问为什么会这样子?
spring2.5,ibatis2.3 oracle11g只读事物不能生效
开发环境:spring2.5,ibatis2.3 oracle11g 执行一个get的service的方法时,日志里中显示设置了connection为readonly,但还是能写入数据库。 怎么才能让readonly的方法不能写入数据库呢,或者说怎么实现这个只读事物呢。 [code="java"]<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd" > <!--该配置文件主要用于管理项目中的事务 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource"> <ref bean="dataSource"/> </property> </bean> <aop:config> <aop:pointcut id="taxService" expression="execution(* bj.n22..service.*.*(..))" /> <aop:advisor advice-ref="txAdvice" pointcut-ref="taxService" /> </aop:config> <tx:advice id="txAdvice" transaction-manager="transactionManager"> <tx:attributes> <tx:method name="save*" /> <tx:method name="delete*" /> <tx:method name="update*" /> <tx:method name="new*" propagation="REQUIRES_NEW" /> <tx:method name="*" read-only="true" /> </tx:attributes> </tx:advice> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="driverClass" value="oracle.jdbc.driver.OracleDriver"/> <property name="jdbcUrl" value="jdbc:oracle:thin:@192.168.1.251:1521:orcl"/> <property name="user" value="demo"></property> <property name="password" value="demo" /> <property name="minPoolSize" value="1" /> <property name="maxPoolSize" value="1" /> <property name="maxIdleTime" value="1800" /> <property name="acquireIncrement" value="2" /> <property name="maxStatements" value="0" /> <property name="initialPoolSize" value="1" /> <property name="idleConnectionTestPeriod" value="1800" /> <property name="acquireRetryAttempts" value="30" /> <property name="breakAfterAcquireFailure" value="true" /> <property name="testConnectionOnCheckout" value="false" /> <property name="preferredTestQuery" value="select * from dual" /> </bean> <!--根据dataSource和configLocation创建一个SqlMapClient--> <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <property name="configLocation"> <value>/WEB-INF/classes/spring/sqlMapConfig.xml</value> </property> <property name="dataSource"> <ref bean="dataSource"/> </property> </bean> <!--将上面的模版类织入到我们的DAO对象中--> <bean id="baseDao" class="bj.n22.base.dao.BaseDaoImpl" > <property name="sqlMapClient"> <ref bean="sqlMapClient" /> </property> </bean> <import resource="application-log.xml"/> </beans>[/code] 日志输出: DEBUG [com.opensymphony.xwork2.util.InstantiatingNullHandler:72] Entering nullPropertyValue [target=[com.opensymphony.xwork2.DefaultTextProvider@14b0c98], property=struts] DEBUG [com.opensymphony.xwork2.DefaultActionProxy:65] Creating an DefaultActionProxy for namespace /log/log and action name edit DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory:389] No bean named 'bj.n22.rms.log.action.LogAction' found in org.springframework.beans.factory.support.DefaultListableBeanFactory@103bc02: defining beans [dataSource,transactionManager,org.springframework.aop.config.internalAutoProxyCreator,taxService,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0,txAdvice,sqlMapClient,baseDao,logDao,logService]; root of factory hierarchy DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory:1071] Not autowiring property 'actionErrors' of bean 'bj.n22.rms.log.action.LogAction' by name: no matching bean found DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory:1071] Not autowiring property 'actionMessages' of bean 'bj.n22.rms.log.action.LogAction' by name: no matching bean found DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory:1071] Not autowiring property 'fieldErrors' of bean 'bj.n22.rms.log.action.LogAction' by name: no matching bean found DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory:203] Returning cached instance of singleton bean 'logService' DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory:1065] Added autowiring by name from bean name 'bj.n22.rms.log.action.LogAction' via property 'logService' to bean named 'logService' DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory:1071] Not autowiring property 'servletRequest' of bean 'bj.n22.rms.log.action.LogAction' by name: no matching bean found DEBUG [com.opensymphony.xwork2.interceptor.PrefixMethodInvocationUtil:141] cannot find method [prepareEdit] in action [bj.n22.rms.log.action.LogAction@296cf1] DEBUG [com.opensymphony.xwork2.interceptor.PrefixMethodInvocationUtil:141] cannot find method [prepareDoEdit] in action [bj.n22.rms.log.action.LogAction@296cf1] DEBUG [com.opensymphony.xwork2.interceptor.I18nInterceptor:97] intercept '/log/log/edit' { DEBUG [com.opensymphony.xwork2.interceptor.I18nInterceptor:110] requested_locale=null DEBUG [com.opensymphony.xwork2.interceptor.I18nInterceptor:140] before Locale=zh_CN DEBUG [com.opensymphony.xwork2.util.InstantiatingNullHandler:72] Entering nullPropertyValue [target=[bj.n22.rms.log.vo.Log@1cb150a, bj.n22.rms.log.action.LogAction@296cf1, com.opensymphony.xwork2.DefaultTextProvider@14b0c98], property=struts] DEBUG [org.apache.struts2.interceptor.FileUploadInterceptor:204] Bypassing /log/log/ edit DEBUG [com.opensymphony.xwork2.interceptor.StaticParametersInterceptor:83] Setting static parameters {} DEBUG [com.opensymphony.xwork2.interceptor.ParametersInterceptor:148] Setting params logId => [ 1 ] DEBUG [com.opensymphony.xwork2.util.XWorkConverter:388] Property: logId DEBUG [com.opensymphony.xwork2.util.XWorkConverter:389] Class: bj.n22.rms.log.vo.Log DEBUG [com.opensymphony.xwork2.util.XWorkConverter:404] converter is null for property logId. Mapping size: 0 DEBUG [com.opensymphony.xwork2.util.XWorkConverter:278] field-level type converter for property [logId] = none found DEBUG [com.opensymphony.xwork2.util.XWorkConverter:302] global-level type converter for property [logId] = none found DEBUG [com.opensymphony.xwork2.util.XWorkConverter:320] falling back to default type converter [com.opensymphony.xwork2.util.XWorkBasicConverter@1470933] DEBUG [org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor:134] Validating /log/log/edit with method edit. DEBUG [com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor:183] Invoking validate() on action bj.n22.rms.log.action.LogAction@296cf1 DEBUG [com.opensymphony.xwork2.interceptor.PrefixMethodInvocationUtil:141] cannot find method [validateEdit] in action [bj.n22.rms.log.action.LogAction@296cf1] DEBUG [com.opensymphony.xwork2.interceptor.PrefixMethodInvocationUtil:141] cannot find method [validateDoEdit] in action [bj.n22.rms.log.action.LogAction@296cf1] DEBUG [com.opensymphony.xwork2.DefaultActionInvocation:383] Executing action method = edit DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager:319] Using transaction object [org.springframework.jdbc.datasource.DataSourceTransactionManager$DataSourceTransactionObject@1714bf9] DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager:347] Creating new transaction with name [bj.n22.rms.log.service.LogService.get]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,readOnly DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@1368553 [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1ba1868) DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager:202] Acquired Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@bbce54] for JDBC transaction DEBUG [org.springframework.jdbc.datasource.DataSourceUtils:155] Setting JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@bbce54] read-only DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager:219] Switching JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@bbce54] to manual commit DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager:168] Bound value [org.springframework.jdbc.datasource.ConnectionHolder@1e701b0] for key [com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> true, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge15c8e1rol9i71bnat25|9a1621, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge15c8e1rol9i71bnat25|9a1621, idleConnectionTestPeriod -> 1800, initialPoolSize -> 1, jdbcUrl -> jdbc:oracle:thin:@192.168.1.251:1521:orcl, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 1, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> select * from dual, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]] to thread [http-8777-1] DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager:222] Initializing transaction synchronization DEBUG [org.springframework.transaction.interceptor.TransactionInterceptor:288] Getting transaction for [bj.n22.rms.log.service.LogService.get] DEBUG [org.springframework.orm.ibatis.SqlMapClientTemplate:177] Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@d6999b] for iBATIS operation DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager:140] Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e701b0] for key [com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> true, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge15c8e1rol9i71bnat25|9a1621, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge15c8e1rol9i71bnat25|9a1621, idleConnectionTestPeriod -> 1800, initialPoolSize -> 1, jdbcUrl -> jdbc:oracle:thin:@192.168.1.251:1521:orcl, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 1, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> select * from dual, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]] bound to thread [http-8777-1] DEBUG [java.sql.Connection:27] {conn-100012} Connection DEBUG [org.springframework.orm.ibatis.SqlMapClientTemplate:194] Obtained JDBC Connection [Transaction-aware proxy for target Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@bbce54]] for iBATIS operation DEBUG [java.sql.Connection:27] {conn-100012} Preparing Statement: select SEQ_PRIMARY.NEXTVAL from dual DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager:140] Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e701b0] for key [com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> true, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge15c8e1rol9i71bnat25|9a1621, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge15c8e1rol9i71bnat25|9a1621, idleConnectionTestPeriod -> 1800, initialPoolSize -> 1, jdbcUrl -> jdbc:oracle:thin:@192.168.1.251:1521:orcl, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 1, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> select * from dual, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]] bound to thread [http-8777-1] DEBUG [java.sql.PreparedStatement:27] {pstm-100013} Executing Statement: select SEQ_PRIMARY.NEXTVAL from dual DEBUG [java.sql.PreparedStatement:27] {pstm-100013} Parameters: [] DEBUG [java.sql.PreparedStatement:27] {pstm-100013} Types: [] DEBUG [java.sql.ResultSet:27] {rset-100014} ResultSet DEBUG [java.sql.ResultSet:27] {rset-100014} Header: [NEXTVAL] DEBUG [java.sql.ResultSet:27] {rset-100014} Result: [21] DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager:140] Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e701b0] for key [com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> true, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge15c8e1rol9i71bnat25|9a1621, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge15c8e1rol9i71bnat25|9a1621, idleConnectionTestPeriod -> 1800, initialPoolSize -> 1, jdbcUrl -> jdbc:oracle:thin:@192.168.1.251:1521:orcl, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 1, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> select * from dual, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]] bound to thread [http-8777-1] DEBUG [org.springframework.orm.ibatis.SqlMapClientTemplate:177] Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@178d7b4] for iBATIS operation DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager:140] Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e701b0] for key [com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> true, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge15c8e1rol9i71bnat25|9a1621, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge15c8e1rol9i71bnat25|9a1621, idleConnectionTestPeriod -> 1800, initialPoolSize -> 1, jdbcUrl -> jdbc:oracle:thin:@192.168.1.251:1521:orcl, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 1, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> select * from dual, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]] bound to thread [http-8777-1] DEBUG [java.sql.Connection:27] {conn-100015} Connection DEBUG [org.springframework.orm.ibatis.SqlMapClientTemplate:194] Obtained JDBC Connection [Transaction-aware proxy for target Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@bbce54]] for iBATIS operation DEBUG [java.sql.Connection:27] {conn-100015} Preparing Statement: insert into TEST_LOG (logid,username,logTime) values (?,?,?) DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager:140] Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e701b0] for key [com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> true, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge15c8e1rol9i71bnat25|9a1621, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge15c8e1rol9i71bnat25|9a1621, idleConnectionTestPeriod -> 1800, initialPoolSize -> 1, jdbcUrl -> jdbc:oracle:thin:@192.168.1.251:1521:orcl, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 1, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> select * from dual, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]] bound to thread [http-8777-1] DEBUG [java.sql.PreparedStatement:27] {pstm-100016} Executing Statement: insert into TEST_LOG (logid,username,logTime) values (?,?,?) DEBUG [java.sql.PreparedStatement:27] {pstm-100016} Parameters: [21, get, null] DEBUG [java.sql.PreparedStatement:27] {pstm-100016} Types: [java.lang.Long, java.lang.String, null] DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager:140] Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e701b0] for key [com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> true, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge15c8e1rol9i71bnat25|9a1621, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge15c8e1rol9i71bnat25|9a1621, idleConnectionTestPeriod -> 1800, initialPoolSize -> 1, jdbcUrl -> jdbc:oracle:thin:@192.168.1.251:1521:orcl, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 1, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> select * from dual, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]] bound to thread [http-8777-1] DEBUG [org.springframework.orm.ibatis.SqlMapClientTemplate:177] Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@17b4650] for iBATIS operation DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager:140] Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e701b0] for key [com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> true, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge15c8e1rol9i71bnat25|9a1621, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge15c8e1rol9i71bnat25|9a1621, idleConnectionTestPeriod -> 1800, initialPoolSize -> 1, jdbcUrl -> jdbc:oracle:thin:@192.168.1.251:1521:orcl, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 1, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> select * from dual, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]] bound to thread [http-8777-1] DEBUG [java.sql.Connection:27] {conn-100017} Connection DEBUG [org.springframework.orm.ibatis.SqlMapClientTemplate:194] Obtained JDBC Connection [Transaction-aware proxy for target Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@bbce54]] for iBATIS operation DEBUG [java.sql.Connection:27] {conn-100017} Preparing Statement: select * from TEST_LOG where logid=? DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager:140] Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e701b0] for key [com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> true, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge15c8e1rol9i71bnat25|9a1621, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge15c8e1rol9i71bnat25|9a1621, idleConnectionTestPeriod -> 1800, initialPoolSize -> 1, jdbcUrl -> jdbc:oracle:thin:@192.168.1.251:1521:orcl, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 1, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> select * from dual, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]] bound to thread [http-8777-1] DEBUG [java.sql.PreparedStatement:27] {pstm-100018} Executing Statement: select * from TEST_LOG where logid=? DEBUG [java.sql.PreparedStatement:27] {pstm-100018} Parameters: [1] DEBUG [java.sql.PreparedStatement:27] {pstm-100018} Types: [java.lang.Long] DEBUG [java.sql.ResultSet:27] {rset-100019} ResultSet DEBUG [java.sql.ResultSet:27] {rset-100019} Header: [LOGID, USERNAME, LOGTIME] DEBUG [java.sql.ResultSet:27] {rset-100019} Result: [1, 测试new事物, null] DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager:140] Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1e701b0] for key [com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> true, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge15c8e1rol9i71bnat25|9a1621, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge15c8e1rol9i71bnat25|9a1621, idleConnectionTestPeriod -> 1800, initialPoolSize -> 1, jdbcUrl -> jdbc:oracle:thin:@192.168.1.251:1521:orcl, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 1, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> select * from dual, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]] bound to thread [http-8777-1] DEBUG [org.springframework.transaction.interceptor.TransactionInterceptor:317] Completing transaction for [bj.n22.rms.log.service.LogService.get] DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager:833] Triggering beforeCommit synchronization DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager:846] Triggering beforeCompletion synchronization DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager:660] Initiating transaction commit DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager:259] Committing JDBC transaction on Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@bbce54] DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager:859] Triggering afterCommit synchronization DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager:875] Triggering afterCompletion synchronization DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager:276] Clearing transaction synchronization DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager:193] Removed value [org.springframework.jdbc.datasource.ConnectionHolder@1e701b0] for key [com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> true, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge15c8e1rol9i71bnat25|9a1621, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge15c8e1rol9i71bnat25|9a1621, idleConnectionTestPeriod -> 1800, initialPoolSize -> 1, jdbcUrl -> jdbc:oracle:thin:@192.168.1.251:1521:orcl, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 1, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> select * from dual, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]] from thread [http-8777-1] DEBUG [org.springframework.jdbc.datasource.DataSourceUtils:202] Resetting read-only flag of JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@bbce54] DEBUG [org.springframework.jdbc.datasource.DataSourceTransactionManager:314] Releasing JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@bbce54] after transaction DEBUG [org.springframework.jdbc.datasource.DataSourceUtils:312] Returning JDBC Connection to DataSource DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1644] trace com.mchange.v2.resourcepool.BasicResourcePool@1368553 [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@1ba1868) DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory:389] No bean named 'org.apache.struts2.dispatcher.VelocityResult' found in org.springframework.beans.factory.support.DefaultListableBeanFactory@103bc02: defining beans [dataSource,transactionManager,org.springframework.aop.config.internalAutoProxyCreator,taxService,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0,txAdvice,sqlMapClient,baseDao,logDao,logService]; root of factory hierarchy DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory:183] Ignoring constructor [public org.apache.struts2.dispatcher.VelocityResult(java.lang.String)] of bean 'org.apache.struts2.dispatcher.VelocityResult': org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.apache.struts2.dispatcher.VelocityResult': Unsatisfied dependency expressed through constructor argument with index 0 of type [java.lang.String]: No unique bean of type [java.lang.String] is defined: Unsatisfied dependency of type [class java.lang.String]: expected at least 1 matching bean DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory:1071] Not autowiring property 'velocityManager' of bean 'org.apache.struts2.dispatcher.VelocityResult' by name: no matching bean found DEBUG [com.opensymphony.xwork2.util.InstantiatingNullHandler:72] Entering nullPropertyValue [target=[bj.n22.rms.log.vo.Log@1cb150a, bj.n22.rms.log.action.LogAction@296cf1, com.opensymphony.xwork2.DefaultTextProvider@14b0c98], property=message] DEBUG [com.opensymphony.xwork2.util.InstantiatingNullHandler:72] Entering nullPropertyValue [target=[bj.n22.rms.log.vo.Log@1cb150a, bj.n22.rms.log.action.LogAction@296cf1, com.opensymphony.xwork2.DefaultTextProvider@14b0c98], property=message] DEBUG [com.opensymphony.xwork2.util.InstantiatingNullHandler:72] Entering nullPropertyValue [target=[bj.n22.rms.log.vo.Log@1cb150a, bj.n22.rms.log.action.LogAction@296cf1, com.opensymphony.xwork2.DefaultTextProvider@14b0c98], property=struts_token] DEBUG [com.opensymphony.xwork2.interceptor.I18nInterceptor:145] after Locale=zh_CN DEBUG [com.opensymphony.xwork2.interceptor.I18nInterceptor:149] intercept } DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1935] Checking for expired resources - Thu Mar 24 10:36:00 CST 2011 [com.mchange.v2.resourcepool.BasicResourcePool@1368553] DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1447] BEGIN check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@1368553] DEBUG [com.mchange.v2.resourcepool.BasicResourcePool:1468] FINISHED check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@1368553]
【求助】oracle 11G 自动建立的实例名称无法使用
近期在redhat linux 5.8 oracle 11.2.0.4.0 上创建实例,创建完后发现无法使用实例名登陆,尝试着手动建立一个仅是把服务名改了,就可以正常登陆了,很无语,请各位大侠帮忙分析一下,谢谢! 自动建立的tnsnames.ora 中配置: SYSIT = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.12)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sysit) ) ) 尝试使用: sqlplus admin/admin12@sysit QL*Plus: Release 11.2.0.4.0 Production on Mon Aug 24 14:05:55 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA Enter user-name: 手动复制后改完服务名后: ISYSIT = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.12)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sysit) ) ) 尝试使用: sqlplus admin/admin12@isysit SQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 24 14:16:52 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>
springboot 配置hibernate 开始使用的是mysql,都正常,但是换成Oracle后总是创建表。
springboot 配置hibernate 开始使用的是mysql,都正常,但是换成Oracle后总是创建表。所以后台报如下表重复错误。这是为什么呀?应该是如果发现表已经有的话不应该再创建才对,请帮我看下哪里配置错了。 再详细说明下我的场景: 数据库映射的对象Product。 第一次系统启动肯定会创建一个,因为数据库中是没有这个表,然后系统重启或者再次启动,正常来讲,Product对象没有改过,数据库表也存在,hibernate不应该再创建,但是目前就是再创建,所以报表名已经有的错误。 ``` Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: 名称已由现有对象使用 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) ~[ojdbc-6.6.0.jar:11.2.0.4.0] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) ~[ojdbc-6.6.0.jar:11.2.0.4.0] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) ~[ojdbc-6.6.0.jar:11.2.0.4.0] ``` ``` server: port: 8001 spring: application: name: DEMO_TEST #f服务名称定义 datasource: type: com.alibaba.druid.pool.DruidDataSource # 当前数据源操作类型 #driver-class-name: com.mysql.cj.jdbc.Driver # mysql驱动包 driver-class-name: oracle.jdbc.driver.OracleDriver #url: jdbc:mysql://127.0.0.1:3306/rd_plm?serverTimezone=GMT%2B8 # 数据库名称 url: jdbc:oracle:thin:@127.0.0.1:1521/DD username: root password: root dbcp2: min-idle: 5 # 数据库连接池的最小维持连接数 initial-size: 5 # 初始化连接数 max-total: 5 # 最大连接数 max-wait-millis: 150 # 等待连接获取的最大超时时间 jpa: hibernate: naming: physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl ddl-auto: update show-sql: true properties: hibernate: #dialect: org.hibernate.dialect.MariaDBDialect dialect: org.hibernate.dialect.OracleDialect current_session_context_class: org.springframework.orm.hibernate5.SpringSessionContext #database: MYSQL database: oracle open-in-view: true ```
oracle自动关闭,提示ORA-27300
系统是centos7,oracle自动关闭后内存和硬盘使用情况: ``` [root@wjdb ~]# free -m total used free shared buffers cached Mem: 64267 62984 1283 16 277 60243 -/+ buffers/cache: 2462 61804 Swap: 35839 0 35839 [root@wjdb ~]# df -hl Filesystem Size Used Avail Use% Mounted on /dev/vda1 40G 27G 11G 73% / devtmpfs 32G 0 32G 0% /dev tmpfs 32G 84K 32G 1% /dev/shm tmpfs 32G 17M 32G 1% /run tmpfs 32G 0 32G 0% /sys/fs/cgroup /dev/mapper/centosVG-tmp 25G 45M 24G 1% /tmp /dev/mapper/centosVG-rac 1.1T 958G 113G 90% /data tmpfs 6.3G 4.0K 6.3G 1% /run/user/0 ``` 网上说修改logind.conf文件,但问题依旧 ``` [root@wjdb ~]# cat /etc/systemd/logind.conf [Login] RemoveIPC=on ``` 登录oracle出现如下错误 ``` Last login: Wed Oct 24 18:30:35 CST 2018 on pts/0 [oracle@wjdb ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 24 18:54:06 2018 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> select * from dual; select * from dual * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 ``` 检查trace目录的日志文件,如下: ``` Starting background process CJQ0 Mon Oct 22 23:45:08 2018 CJQ0 started with pid=43, OS id=2409 Archived Log entry 2777 added for thread 1 sequence 2783 ID 0xa5f27e dest 1: Mon Oct 22 23:45:08 2018 db_recovery_file_dest_size of 409600 MB is 52.01% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Setting Resource Manager plan SCHEDULER[0x3003]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Mon Oct 22 23:45:11 2018 Starting background process VKRM Mon Oct 22 23:45:11 2018 VKRM started with pid=41, OS id=2411 Mon Oct 22 23:53:18 2018 Starting background process SMCO Mon Oct 22 23:53:18 2018 SMCO started with pid=1030, OS id=12564 Tue Oct 23 02:00:00 2018 Clearing Resource Manager plan via parameter Tue Oct 23 08:00:17 2018 Thread 1 advanced to log sequence 2785 (LGWR switch) Current log# 4 seq# 2785 mem# 0: /data/oracle/oradata/wjdb/redo04.log Tue Oct 23 08:00:30 2018 Archived Log entry 2778 added for thread 1 sequence 2784 ID 0xa5f27e dest 1: Tue Oct 23 16:02:53 2018 Thread 1 advanced to log sequence 2786 (LGWR switch) Current log# 1 seq# 2786 mem# 0: /data/oracle/oradata/wjdb/redo01.log Tue Oct 23 16:03:06 2018 Archived Log entry 2779 added for thread 1 sequence 2785 ID 0xa5f27e dest 1: Tue Oct 23 19:07:01 2018 Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_j000_20537.trc: ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 Tue Oct 23 19:07:01 2018 Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_dbrm_2317.trc: ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 DBRM (ospid: 2317): terminating the instance due to error 27157 Tue Oct 23 19:07:01 2018 Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_j001_20539.trc: ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 Tue Oct 23 19:07:01 2018 Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_q000_2418.trc: ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 Instance terminated by DBRM, pid = 2317 Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_dbrm_2317.trc: ORA-27300: OS system dependent operation:semctl failed with status: 22 ORA-27301: OS failure message: Invalid argument ORA-27302: failure occurred at: sskgpwrm1 ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 Tue Oct 23 19:07:04 2018 Instance termination got error 27120 from SGA destruction. Error cleared. Process exiting. wjdb_j000_20537.trc内容如下 7f30aa2c8000-7f30aa2cb000 r-xp 00000000 fd:01 143235 /usr/lib64/libdl-2.17.so 7f30aa2cb000-7f30aa4ca000 ---p 00003000 fd:01 143235 /usr/lib64/libdl-2.17.so 7f30aa4ca000-7f30aa4cb000 r-xp 00002000 fd:01 143235 /usr/lib64/libdl-2.17.so 7f30aa4cb000-7f30aa4cc000 rwxp 00003000 fd:01 143235 /usr/lib64/libdl-2.17.so 7f30aa4cc000-7f30aa4cd000 r-xp 00000000 fd:01 136896 /usr/lib64/libaio.so.1.0.1 7f30aa4cd000-7f30aa6cc000 ---p 00001000 fd:01 136896 /usr/lib64/libaio.so.1.0.1 7f30aa6cc000-7f30aa6cd000 r-xp 00000000 fd:01 136896 /usr/lib64/libaio.so.1.0.1 7f30aa6cd000-7f30aa6ce000 rwxp 00001000 fd:01 136896 /usr/lib64/libaio.so.1.0.1 7f30aa6ce000-7f30aa73d000 r-xp 00000000 fc:01 37623267 /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so 7f30aa73d000-7f30aa83d000 ---p 0006f000 fc:01 37623267 /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so 7f30aa83d000-7f30aa84f000 rwxp 0006f000 fc:01 37623267 /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so 7f30aa84f000-7f30aa850000 rwxp 00000000 00:00 0 7f30aa850000-7f30aa85b000 r-xp 00000000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f30aa85b000-7f30aa95a000 ---p 0000b000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f30aa95a000-7f30aa95b000 rwxp 0000a000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f30aa95b000-7f30aa9f3000 r-xp 00000000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f30aa9f3000-7f30aaaf3000 ---p 00098000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f30aaaf3000-7f30aaaf5000 rwxp 00098000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f30aaaf5000-7f30aab8e000 r-xp 00000000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f30aab8e000-7f30aac8d000 ---p 00099000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f30aac8d000-7f30aac8f000 rwxp 00098000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f30aac8f000-7f30aac91000 r-xp 00000000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f30aac91000-7f30aad90000 ---p 00002000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f30aad90000-7f30aad91000 rwxp 00001000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f30aad91000-7f30ab1b9000 r-xp 00000000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f30ab1b9000-7f30ab2b9000 ---p 00428000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f30ab2b9000-7f30ab2cb000 rwxp 00428000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f30ab2cb000-7f30ab2cf000 rwxp 00000000 00:00 0 7f30ab2cf000-7f30ab2f1000 r-xp 00000000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f30ab2f1000-7f30ab3f0000 ---p 00022000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f30ab3f0000-7f30ab3f2000 rwxp 00021000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f30ab3f2000-7f30ab409000 r-xp 00000000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f30ab409000-7f30ab509000 ---p 00017000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f30ab509000-7f30ab50a000 rwxp 00017000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f30ab50a000-7f30ab78f000 r-xp 00000000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f30ab78f000-7f30ab88e000 ---p 00285000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f30ab88e000-7f30ab8d1000 rwxp 00284000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f30ab8d1000-7f30ab8d2000 rwxp 00000000 00:00 0 7f30ab8d2000-7f30ab8d9000 r-xp 00000000 fd:01 150366 /usr/lib64/librt-2.17.so 7f30ab8d9000-7f30abad8000 ---p 00007000 fd:01 150366 /usr/lib64/librt-2.17.so 7f30abad8000-7f30abad9000 r-xp 00006000 fd:01 150366 /usr/lib64/librt-2.17.so 7f30abad9000-7f30abada000 rwxp 00007000 fd:01 150366 /usr/lib64/librt-2.17.so 7f30abada000-7f30abb91000 r-xp 00000000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f30abb91000-7f30abc91000 ---p 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f30abc91000-7f30abc93000 rwxp 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f30abc93000-7f30abce2000 r-xp 00000000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f30abce2000-7f30abde1000 ---p 0004f000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f30abde1000-7f30abde9000 rwxp 0004e000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f30abde9000-7f30abe0a000 r-xp 00000000 fd:01 132827 /usr/lib64/ld-2.17.so 7f30abe10000-7f30abe45000 r-xs 00000000 fd:01 401548 /var/db/nscd/hosts 7f30abe45000-7f30abef7000 rwxp 00000000 00:00 0 7f30abf04000-7f30abf06000 rwxs 00000000 00:0a 44872319 /[aio] (deleted) 7f30abf06000-7f30abf07000 rwxp 00000000 00:00 0 7f30abf07000-7f30abf08000 r-xp 00000000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f30abf08000-7f30ac008000 ---p 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f30ac008000-7f30ac009000 rwxp 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f30ac009000-7f30ac00a000 rwxp 00000000 00:00 0 7f30ac00a000-7f30ac00b000 r-xp 00021000 fd:01 132827 /usr/lib64/ld-2.17.so 7f30ac00b000-7f30ac00c000 rwxp 00022000 fd:01 132827 /usr/lib64/ld-2.17.so 7f30ac00c000-7f30ac00d000 rwxp 00000000 00:00 0 7fffa52c6000-7fffa52fa000 rwxp 00000000 00:00 0 [stack] 7fffa53fe000-7fffa5400000 r-xp 00000000 00:00 0 [vdso] ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall] ******************* End of process map dump ************ Unexpected error 27157 in job slave process ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 wjdb_dbrm_2317.trc内容如下 7f2cbbad0000-7f2cbbad1000 rwxp 00007000 fd:01 150366 /usr/lib64/librt-2.17.so 7f2cbbad1000-7f2cbbb88000 r-xp 00000000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f2cbbb88000-7f2cbbc88000 ---p 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f2cbbc88000-7f2cbbc8a000 rwxp 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f2cbbc8a000-7f2cbbcd9000 r-xp 00000000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f2cbbcd9000-7f2cbbdd8000 ---p 0004f000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f2cbbdd8000-7f2cbbde0000 rwxp 0004e000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f2cbbde0000-7f2cbbe01000 r-xp 00000000 fd:01 132827 /usr/lib64/ld-2.17.so 7f2cbbe07000-7f2cbbe3c000 r-xs 00000000 fd:01 401548 /var/db/nscd/hosts 7f2cbbe3c000-7f2cbbeee000 rwxp 00000000 00:00 0 7f2cbbefa000-7f2cbbefb000 rwxs 00000000 fc:01 37492061 /data/oracle/product/11.2.0/db_1/dbs/hc_wjdb.dat 7f2cbbefb000-7f2cbbefd000 rwxs 00000000 00:0a 26080 /[aio] (deleted) 7f2cbbefd000-7f2cbbefe000 rwxp 00000000 00:00 0 7f2cbbefe000-7f2cbbeff000 r-xp 00000000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f2cbbeff000-7f2cbbfff000 ---p 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f2cbbfff000-7f2cbc000000 rwxp 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f2cbc000000-7f2cbc001000 rwxp 00000000 00:00 0 7f2cbc001000-7f2cbc002000 r-xp 00021000 fd:01 132827 /usr/lib64/ld-2.17.so 7f2cbc002000-7f2cbc003000 rwxp 00022000 fd:01 132827 /usr/lib64/ld-2.17.so 7f2cbc003000-7f2cbc004000 rwxp 00000000 00:00 0 7fff386d3000-7fff38705000 rwxp 00000000 00:00 0 [stack] 7fff387fe000-7fff38800000 r-xp 00000000 00:00 0 [vdso] ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall] ******************* End of process map dump ************ error 27157 detected in background process ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 *** 2018-10-23 19:07:01.746 DBRM (ospid: 2317): terminating the instance due to error 27157 *** 2018-10-23 19:07:04.048 ORA-27300: OS system dependent operation:semctl failed with status: 22 ORA-27301: OS failure message: Invalid argument ORA-27302: failure occurred at: sskgpwrm1 ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 skgm error 27120: errno = 22, info = 5, 229378, 0, 0, 229378, 0, 11 skgm error 27120: errno = 22, info = 5, 262147, 0, 0, 262147, 0, 11 skgm error 27120: errno = 22, info = 5, 294916, 0, 0, 294916, 0, 11 skgm error 27120: errno = 22, info = 5, 327685, 0, 0, 327685, 0, 11 skgm error 27120: errno = 22, info = 5, 360454, 0, 0, 360454, 0, 11 skgm error 27120: errno = 22, info = 5, 393223, 0, 0, 393223, 0, 11 skgm error 27120: errno = 22, info = 5, 425992, 0, 0, 425992, 0, 11 skgm error 27120: errno = 22, info = 5, 458761, 0, 0, 458761, 0, 11 skgm error 27120: errno = 22, info = 5, 491530, 0, 0, 491530, 0, 11 skgm error 27120: errno = 22, info = 5, 524299, 0, 0, 524299, 0, 11 skgm error 27120: errno = 22, info = 5, 557068, 0, 0, 557068, 0, 11 skgm error 27120: errno = 22, info = 5, 589837, 0, 0, 589837, 0, 11 skgm error 27120: errno = 22, info = 5, 622606, 0, 0, 622606, 0, 11 skgm error 27120: errno = 22, info = 5, 655375, 0, 0, 655375, 0, 11 skgm error 27120: errno = 22, info = 5, 688144, 0, 0, 688144, 0, 11 skgm error 27120: errno = 22, info = 5, 720913, 0, 0, 720913, 0, 11 skgm error 27120: errno = 22, info = 5, 753682, 0, 0, 753682, 0, 11 skgm error 27120: errno = 22, info = 5, 786451, 0, 0, 786451, 0, 11 skgm error 27120: errno = 22, info = 5, 819220, 0, 0, 819220, 0, 11 skgm error 27120: errno = 22, info = 5, 851989, 0, 0, 851989, 0, 11 skgm error 27120: errno = 22, info = 5, 884758, 0, 0, 884758, 0, 11 skgm error 27120: errno = 22, info = 5, 917527, 0, 0, 917527, 0, 11 skgm error 27120: errno = 22, info = 5, 950296, 0, 0, 950296, 0, 11 skgm error 27120: errno = 22, info = 5, 983065, 0, 0, 983065, 0, 11 skgm error 27120: errno = 22, info = 5, 1015834, 0, 0, 1015834, 0, 11 skgm error 27120: errno = 22, info = 5, 1048603, 0, 0, 1048603, 0, 11 skgm error 27120: errno = 22, info = 5, 1081372, 0, 0, 1081372, 0, 11 wjdb_j001_20539.trc内容如下 7f9d46ac3000-7f9d46b32000 r-xp 00000000 fc:01 37623267 /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so 7f9d46b32000-7f9d46c32000 ---p 0006f000 fc:01 37623267 /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so 7f9d46c32000-7f9d46c44000 rwxp 0006f000 fc:01 37623267 /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so 7f9d46c44000-7f9d46c45000 rwxp 00000000 00:00 0 7f9d46c45000-7f9d46c50000 r-xp 00000000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f9d46c50000-7f9d46d4f000 ---p 0000b000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f9d46d4f000-7f9d46d50000 rwxp 0000a000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f9d46d50000-7f9d46de8000 r-xp 00000000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f9d46de8000-7f9d46ee8000 ---p 00098000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f9d46ee8000-7f9d46eea000 rwxp 00098000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f9d46eea000-7f9d46f83000 r-xp 00000000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f9d46f83000-7f9d47082000 ---p 00099000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f9d47082000-7f9d47084000 rwxp 00098000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f9d47084000-7f9d47086000 r-xp 00000000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f9d47086000-7f9d47185000 ---p 00002000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f9d47185000-7f9d47186000 rwxp 00001000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f9d47186000-7f9d475ae000 r-xp 00000000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f9d475ae000-7f9d476ae000 ---p 00428000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f9d476ae000-7f9d476c0000 rwxp 00428000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f9d476c0000-7f9d476c4000 rwxp 00000000 00:00 0 7f9d476c4000-7f9d476e6000 r-xp 00000000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f9d476e6000-7f9d477e5000 ---p 00022000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f9d477e5000-7f9d477e7000 rwxp 00021000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f9d477e7000-7f9d477fe000 r-xp 00000000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f9d477fe000-7f9d478fe000 ---p 00017000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f9d478fe000-7f9d478ff000 rwxp 00017000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f9d478ff000-7f9d47b84000 r-xp 00000000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f9d47b84000-7f9d47c83000 ---p 00285000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f9d47c83000-7f9d47cc6000 rwxp 00284000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f9d47cc6000-7f9d47cc7000 rwxp 00000000 00:00 0 7f9d47cc7000-7f9d47cce000 r-xp 00000000 fd:01 150366 /usr/lib64/librt-2.17.so 7f9d47cce000-7f9d47ecd000 ---p 00007000 fd:01 150366 /usr/lib64/librt-2.17.so 7f9d47ecd000-7f9d47ece000 r-xp 00006000 fd:01 150366 /usr/lib64/librt-2.17.so 7f9d47ece000-7f9d47ecf000 rwxp 00007000 fd:01 150366 /usr/lib64/librt-2.17.so 7f9d47ecf000-7f9d47f86000 r-xp 00000000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f9d47f86000-7f9d48086000 ---p 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f9d48086000-7f9d48088000 rwxp 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f9d48088000-7f9d480d7000 r-xp 00000000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f9d480d7000-7f9d481d6000 ---p 0004f000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f9d481d6000-7f9d481de000 rwxp 0004e000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f9d481de000-7f9d481ff000 r-xp 00000000 fd:01 132827 /usr/lib64/ld-2.17.so 7f9d4823a000-7f9d482ec000 rwxp 00000000 00:00 0 7f9d482f9000-7f9d482fb000 rwxs 00000000 00:0a 44870643 /[aio] (deleted) 7f9d482fb000-7f9d482fc000 rwxp 00000000 00:00 0 7f9d482fc000-7f9d482fd000 r-xp 00000000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f9d482fd000-7f9d483fd000 ---p 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f9d483fd000-7f9d483fe000 rwxp 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f9d483fe000-7f9d483ff000 rwxp 00000000 00:00 0 7f9d483ff000-7f9d48400000 r-xp 00021000 fd:01 132827 /usr/lib64/ld-2.17.so 7f9d48400000-7f9d48401000 rwxp 00022000 fd:01 132827 /usr/lib64/ld-2.17.so 7f9d48401000-7f9d48402000 rwxp 00000000 00:00 0 7fff9ed9c000-7fff9edcf000 rwxp 00000000 00:00 0 [stack] 7fff9edfe000-7fff9ee00000 r-xp 00000000 00:00 0 [vdso] ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall] ******************* End of process map dump ************ Unexpected error 27157 in job slave process ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 wjdb_q000_2418.trc内容如下 7f71f86ef000-7f71f86f0000 rwxp 00000000 00:00 0 7f71f86f0000-7f71f86fb000 r-xp 00000000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f71f86fb000-7f71f87fa000 ---p 0000b000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f71f87fa000-7f71f87fb000 rwxp 0000a000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f71f87fb000-7f71f8893000 r-xp 00000000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f71f8893000-7f71f8993000 ---p 00098000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f71f8993000-7f71f8995000 rwxp 00098000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f71f8995000-7f71f8a2e000 r-xp 00000000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f71f8a2e000-7f71f8b2d000 ---p 00099000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f71f8b2d000-7f71f8b2f000 rwxp 00098000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f71f8b2f000-7f71f8b31000 r-xp 00000000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f71f8b31000-7f71f8c30000 ---p 00002000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f71f8c30000-7f71f8c31000 rwxp 00001000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f71f8c31000-7f71f9059000 r-xp 00000000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f71f9059000-7f71f9159000 ---p 00428000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f71f9159000-7f71f916b000 rwxp 00428000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f71f916b000-7f71f916f000 rwxp 00000000 00:00 0 7f71f916f000-7f71f9191000 r-xp 00000000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f71f9191000-7f71f9290000 ---p 00022000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f71f9290000-7f71f9292000 rwxp 00021000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f71f9292000-7f71f92a9000 r-xp 00000000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f71f92a9000-7f71f93a9000 ---p 00017000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f71f93a9000-7f71f93aa000 rwxp 00017000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f71f93aa000-7f71f962f000 r-xp 00000000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f71f962f000-7f71f972e000 ---p 00285000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f71f972e000-7f71f9771000 rwxp 00284000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f71f9771000-7f71f9772000 rwxp 00000000 00:00 0 7f71f9772000-7f71f9779000 r-xp 00000000 fd:01 150366 /usr/lib64/librt-2.17.so 7f71f9779000-7f71f9978000 ---p 00007000 fd:01 150366 /usr/lib64/librt-2.17.so 7f71f9978000-7f71f9979000 r-xp 00006000 fd:01 150366 /usr/lib64/librt-2.17.so 7f71f9979000-7f71f997a000 rwxp 00007000 fd:01 150366 /usr/lib64/librt-2.17.so 7f71f997a000-7f71f9a31000 r-xp 00000000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f71f9a31000-7f71f9b31000 ---p 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f71f9b31000-7f71f9b33000 rwxp 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f71f9b33000-7f71f9b82000 r-xp 00000000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f71f9b82000-7f71f9c81000 ---p 0004f000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f71f9c81000-7f71f9c89000 rwxp 0004e000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f71f9c89000-7f71f9caa000 r-xp 00000000 fd:01 132827 /usr/lib64/ld-2.17.so 7f71f9ce5000-7f71f9d97000 rwxp 00000000 00:00 0 7f71f9da4000-7f71f9da6000 rwxs 00000000 00:0a 28167 /[aio] (deleted) 7f71f9da6000-7f71f9da7000 rwxp 00000000 00:00 0 7f71f9da7000-7f71f9da8000 r-xp 00000000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f71f9da8000-7f71f9ea8000 ---p 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f71f9ea8000-7f71f9ea9000 rwxp 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f71f9ea9000-7f71f9eaa000 rwxp 00000000 00:00 0 7f71f9eaa000-7f71f9eab000 r-xp 00021000 fd:01 132827 /usr/lib64/ld-2.17.so 7f71f9eab000-7f71f9eac000 rwxp 00022000 fd:01 132827 /usr/lib64/ld-2.17.so 7f71f9eac000-7f71f9ead000 rwxp 00000000 00:00 0 7fff92da9000-7fff92ddc000 rwxp 00000000 00:00 0 [stack] 7fff92dfe000-7fff92e00000 r-xp 00000000 00:00 0 [vdso] ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall] ******************* End of process map dump ************ KSV 27157 error in slave process *** 2018-10-23 19:07:01.765 ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 OPIRIP: Uncaught error 447. Error stack: ORA-00447: fatal error in background process ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 ```
centos7.4无法静默安装oracle,提示not found in the bean store
INFO: Loading beanstore from file:/data/database/database/response/db_install.rsp INFO: Translating external format into raw format INFO: Loaded BeanStore using the flow data source INFO: Registering the flow data beans INFO: [INS-07001] Value for property 'oracle_install_RACInstall' not found in the bean store. INFO: [INS-07001] Value for property 'CLUSTER_NODES' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_OSDBA' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_OSOPER' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_GlobalDBName' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_SID' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_StorageType' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_InstallOption' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_CustomInstall' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_SystemClass' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_QuickInstallOption' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_AllocatedMemory' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_AutoMemoryOption' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_ConfigurationType' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_EMCentralAgentSelected' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_MountPointLocation' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_LaunchDBCA' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_SecureConfigDisabled' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_EnableAutoBackup' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_LoadExampleSchemas' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_ReceiveEmailNotif ication' not found in the bean store 环境变量: # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH export ORACLE_BASE=/data/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 #oracle启动数据库实例名 export ORACLE_SID=orcl11g #添加系统环境变量 export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib export TNS_ADMIN=$ORACLE_HOME/network/admin 安装文件: #------------------------------------------------------------------------------ # Do not change the following system generated value. #------------------------------------------------------------------------------ oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 #------------------------------------------------------------------------------ # Specify the installation option. # It can be one of the following: # 1. INSTALL_DB_SWONLY # 2. INSTALL_DB_AND_CONFIG # 3. UPGRADE_DB #------------------------------------------------------------------------------- oracle.install.option=INSTALL_DB_SWONLY #------------------------------------------------------------------------------- # Specify the hostname of the system as set during the install. It can be used # to force the installation to use an alternative hostname rather than using the # first hostname found on the system. (e.g., for systems with multiple hostnames # and network interfaces) #------------------------------------------------------------------------------- ORACLE_HOSTNAME=yukhan #------------------------------------------------------------------------------- # Specify the Unix group to be set for the inventory directory. #------------------------------------------------------------------------------- UNIX_GROUP_NAME=oinstall #------------------------------------------------------------------------------- # Specify the location which holds the inventory files. #------------------------------------------------------------------------------- INVENTORY_LOCATION=/data/oraInventory #------------------------------------------------------------------------------- # Specify the languages in which the components will be installed. # # en : English ja : Japanese # fr : French ko : Korean # ar : Arabic es : Latin American Spanish # bn : Bengali lv : Latvian # pt_BR: Brazilian Portuguese lt : Lithuanian # bg : Bulgarian ms : Malay # fr_CA: Canadian French es_MX: Mexican Spanish # ca : Catalan no : Norwegian # hr : Croatian pl : Polish # cs : Czech pt : Portuguese # da : Danish ro : Romanian # nl : Dutch ru : Russian # ar_EG: Egyptian zh_CN: Simplified Chinese # en_GB: English (Great Britain) sk : Slovak # et : Estonian sl : Slovenian # fi : Finnish es_ES: Spanish # de : German sv : Swedish # el : Greek th : Thai # iw : Hebrew zh_TW: Traditional Chinese # hu : Hungarian tr : Turkish # is : Icelandic uk : Ukrainian # in : Indonesian vi : Vietnamese # it : Italian # # Example : SELECTED_LANGUAGES=en,fr,ja #------------------------------------------------------------------------------ SELECTED_LANGUAGES=en #------------------------------------------------------------------------------ # Specify the complete path of the Oracle Home. #------------------------------------------------------------------------------ ORACLE_HOME=/data/oracle/product/11.2.0/db_1 #------------------------------------------------------------------------------ # Specify the complete path of the Oracle Base. #------------------------------------------------------------------------------ ORACLE_BASE=/data/oracle/ #------------------------------------------------------------------------------ # Specify the installation edition of the component. # # The value should contain only one of these choices. # EE : Enterprise Edition # SE : Standard Edition # SEONE : Standard Edition One # PE : Personal Edition (WINDOWS ONLY) #------------------------------------------------------------------------------ oracle.install.db.InstallEdition=EE #------------------------------------------------------------------------------ # This variable is used to enable or disable custom install. # # true : Components mentioned as part of 'customComponents' property # are considered for install. # false : Value for 'customComponents' is not considered. #------------------------------------------------------------------------------ oracle.install.db.isCustomInstall=false #------------------------------------------------------------------------------ # This variable is considered only if 'IsCustomInstall' is set to true. # # Description: List of Enterprise Edition Options you would like to install. # # The following choices are available. You may specify any # combination of these choices. The components you choose should # be specified in the form "internal-component-name:version" # Below is a list of components you may specify to install. # # oracle.rdbms.partitioning:11.2.0.1.0 - Oracle Partitioning # oracle.rdbms.dm:11.2.0.1.0 - Oracle Data Mining # oracle.rdbms.dv:11.2.0.1.0 - Oracle Database Vault # oracle.rdbms.lbac:11.2.0.1.0 - Oracle Label Security # oracle.rdbms.rat:11.2.0.1.0 - Oracle Real Application Testing # oracle.oraolap:11.2.0.1.0 - Oracle OLAP #------------------------------------------------------------------------------ oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11. 2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms .partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1. 0,oracle.rdbms.rat:11.2.0.1.0 ############################################################################### # # # PRIVILEGED OPERATING SYSTEM GROUPS # # ------------------------------------------ # # Provide values for the OS groups to which OSDBA and OSOPER privileges # # needs to be granted. If the install is being performed as a member of the # # group "dba", then that will be used unless specified otherwise below. # # # ############################################################################### #------------------------------------------------------------------------------ # The DBA_GROUP is the OS group which is to be granted OSDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.DBA_GROUP=dba #------------------------------------------------------------------------------ # The OPER_GROUP is the OS group which is to be granted OSOPER privileges. #------------------------------------------------------------------------------ oracle.install.db.OPER_GROUP=oinstall #------------------------------------------------------------------------------ # Specify the cluster node names selected during the installation. #------------------------------------------------------------------------------ oracle.install.db.CLUSTER_NODES= #------------------------------------------------------------------------------ # Specify the type of database to create. # It can be one of the following: # - GENERAL_PURPOSE/TRANSACTION_PROCESSING # - DATA_WAREHOUSE #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.type=GENERAL_PURPOSE #------------------------------------------------------------------------------ # Specify the Starter Database Global Database Name. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.globalDBName=orcl11g #------------------------------------------------------------------------------ # Specify the Starter Database SID. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.SID=orcl11g #------------------------------------------------------------------------------ # Specify the Starter Database character set. # # It can be one of the following: # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2, # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257, # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6, # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8, # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE, # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950, # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258 #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.characterSet=AL32UTF8 #------------------------------------------------------------------------------ # This variable should be set to true if Automatic Memory Management # in Database is desired. # If Automatic Memory Management is not desired, and memory allocation # is to be done manually, then set it to false. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.memoryOption=true #------------------------------------------------------------------------------ # Specify the total memory allocation for the database. Value(in MB) should be # at least 256 MB, and should not exceed the total physical memory available # on the system. # Example: oracle.install.db.config.starterdb.memoryLimit=512 #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.memoryLimit=3072 #------------------------------------------------------------------------------ # This variable controls whether to load Example Schemas onto the starter # database or not. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.installExampleSchemas=false #------------------------------------------------------------------------------ # This variable includes enabling audit settings, configuring password profiles # and revoking some grants to public. These settings are provided by default. # These settings may also be disabled. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.enableSecuritySettings=true ############################################################################### # # # Passwords can be supplied for the following four schemas in the # # starter database: # # SYS # # SYSTEM # # SYSMAN (used by Enterprise Manager) # # DBSNMP (used by Enterprise Manager) # # # # Same password can be used for all accounts (not recommended) # # or different passwords for each account can be provided (recommended) # # # ############################################################################### #------------------------------------------------------------------------------ # This variable holds the password that is to be used for all schemas in the # starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.ALL=root@001 #------------------------------------------------------------------------------- # Specify the SYS password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYS= #------------------------------------------------------------------------------- # Specify the SYSTEM password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSTEM= #------------------------------------------------------------------------------- # Specify the SYSMAN password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSMAN= #------------------------------------------------------------------------------- # Specify the DBSNMP password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.DBSNMP= #------------------------------------------------------------------------------- # Specify the management option to be selected for the starter database. # It can be one of the following: # 1. GRID_CONTROL # 2. DB_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.control=DB_CONTROL #------------------------------------------------------------------------------- # Specify the Management Service to use if Grid Control is selected to manage # the database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= #------------------------------------------------------------------------------- # This variable indicates whether to receive email notification for critical # alerts when using DB control. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false #------------------------------------------------------------------------------- # Specify the email address to which the notifications are to be sent. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.dbcontrol.emailAddress= #------------------------------------------------------------------------------- # Specify the SMTP server used for email notifications. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.dbcontrol.SMTPServer= ############################################################################### # # # SPECIFY BACKUP AND RECOVERY OPTIONS # # ------------------------------------ # # Out-of-box backup and recovery options for the database can be mentioned # # using the entries below. # # # ############################################################################### #------------------------------------------------------------------------------ # This variable is to be set to false if automated backup is not required. Else # this can be set to true. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.automatedBackup.enable=false #------------------------------------------------------------------------------ # Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily at # 2:00 AM to backup the database. This job will run as the operating system # user that is specified in this variable. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.automatedBackup.osuid= #------------------------------------------------------------------------------- # Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily at # 2:00 AM to backup the database. This job will run as the operating system user # specified by the above entry. The following entry stores the password for the # above operating system user. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.automatedBackup.ospwd= #------------------------------------------------------------------------------- # Specify the type of storage to use for the database. # It can be one of the following: # - FILE_SYSTEM_STORAGE # - ASM_STORAGE #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.storageType= #------------------------------------------------------------------------------- # Specify the database file location which is a directory for datafiles, control # files, redo logs. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= #------------------------------------------------------------------------------- # Specify the backup and recovery location. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= #------------------------------------------------------------------------------- # Specify the existing ASM disk groups to be used for storage. # # Applicable only when oracle.install.db.config.starterdb.storage=ASM #------------------------------------------------------------------------------- oracle.install.db.config.asm.diskGroup= #------------------------------------------------------------------------------- # Specify the password for ASMSNMP user of the ASM instance. # # Applicable only when oracle.install.db.config.starterdb.storage=ASM_SYSTEM #------------------------------------------------------------------------------- oracle.install.db.config.asm.ASMSNMPPassword= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username. # # Example : MYORACLESUPPORT_USERNAME=metalink #------------------------------------------------------------------------------ MYORACLESUPPORT_USERNAME= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username password. # # Example : MYORACLESUPPORT_PASSWORD=password #------------------------------------------------------------------------------ MYORACLESUPPORT_PASSWORD= #------------------------------------------------------------------------------ # Specify whether to enable the user to set the password for # My Oracle Support credentials. The value can be either true or false. # If left blank it will be assumed to be false. # # Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true #------------------------------------------------------------------------------ SECURITY_UPDATES_VIA_MYORACLESUPPORT= #------------------------------------------------------------------------------ # Specify whether user wants to give any proxy details for connection. # The value can be either true or false. If left blank it will be assumed # to be false. # # Example : DECLINE_SECURITY_UPDATES=false #------------------------------------------------------------------------------ DECLINE_SECURITY_UPDATES=true #------------------------------------------------------------------------------ # Specify the Proxy server name. Length should be greater than zero. # # Example : PROXY_HOST=proxy.domain.com #------------------------------------------------------------------------------ PROXY_HOST= #------------------------------------------------------------------------------ # Specify the proxy port number. Should be Numeric and atleast 2 chars. # # Example : PROXY_PORT=25 #------------------------------------------------------------------------------ PROXY_PORT= #------------------------------------------------------------------------------ # Specify the proxy user name. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication. # # Example : PROXY_USER=username #------------------------------------------------------------------------------ PROXY_USER= #------------------------------------------------------------------------------ # Specify the proxy password. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication. # # Example : PROXY_PWD=password #------------------------------------------------------------------------------ PROXY_PWD=
相见恨晚的超实用网站
搞学习 知乎:www.zhihu.com 简答题:http://www.jiandati.com/ 网易公开课:https://open.163.com/ted/ 网易云课堂:https://study.163.com/ 中国大学MOOC:www.icourse163.org 网易云课堂:study.163.com 哔哩哔哩弹幕网:www.bilibili.com 我要自学网:www.51zxw
花了20分钟,给女朋友们写了一个web版群聊程序
参考博客 [1]https://www.byteslounge.com/tutorials/java-ee-html5-websocket-example
爬虫福利二 之 妹子图网MM批量下载
爬虫福利一:27报网MM批量下载    点击 看了本文,相信大家对爬虫一定会产生强烈的兴趣,激励自己去学习爬虫,在这里提前祝:大家学有所成! 目标网站:妹子图网 环境:Python3.x 相关第三方模块:requests、beautifulsoup4 Re:各位在测试时只需要将代码里的变量 path 指定为你当前系统要保存的路径,使用 python xxx.py 或IDE运行即可。
字节跳动视频编解码面经
引言 本文主要是记录一下面试字节跳动的经历。 三四月份投了字节跳动的实习(图形图像岗位),然后hr打电话过来问了一下会不会opengl,c++,shador,当时只会一点c++,其他两个都不会,也就直接被拒了。 七月初内推了字节跳动的提前批,因为内推没有具体的岗位,hr又打电话问要不要考虑一下图形图像岗,我说实习投过这个岗位不合适,不会opengl和shador,然后hr就说秋招更看重基础。我当时
开源一个功能完整的SpringBoot项目框架
福利来了,给大家带来一个福利。 最近想了解一下有关Spring Boot的开源项目,看了很多开源的框架,大多是一些demo或者是一个未成形的项目,基本功能都不完整,尤其是用户权限和菜单方面几乎没有完整的。 想到我之前做的框架,里面通用模块有:用户模块,权限模块,菜单模块,功能模块也齐全了,每一个功能都是完整的。 打算把这个框架分享出来,供大家使用和学习。 为什么用框架? 框架可以学习整体
Java学习的正确打开方式
在博主认为,对于入门级学习java的最佳学习方法莫过于视频+博客+书籍+总结,前三者博主将淋漓尽致地挥毫于这篇博客文章中,至于总结在于个人,实际上越到后面你会发现学习的最好方式就是阅读参考官方文档其次就是国内的书籍,博客次之,这又是一个层次了,这里暂时不提后面再谈。博主将为各位入门java保驾护航,各位只管冲鸭!!!上天是公平的,只要不辜负时间,时间自然不会辜负你。 何谓学习?博主所理解的学习,它
程序员必须掌握的核心算法有哪些?
由于我之前一直强调数据结构以及算法学习的重要性,所以就有一些读者经常问我,数据结构与算法应该要学习到哪个程度呢?,说实话,这个问题我不知道要怎么回答你,主要取决于你想学习到哪些程度,不过针对这个问题,我稍微总结一下我学过的算法知识点,以及我觉得值得学习的算法。这些算法与数据结构的学习大多数是零散的,并没有一本把他们全部覆盖的书籍。下面是我觉得值得学习的一些算法以及数据结构,当然,我也会整理一些看过
Python——画一棵漂亮的樱花树(不同种樱花+玫瑰+圣诞树喔)
最近翻到一篇知乎,上面有不少用Python(大多是turtle库)绘制的树图,感觉很漂亮,我整理了一下,挑了一些我觉得不错的代码分享给大家(这些我都测试过,确实可以生成喔~) one 樱花树 动态生成樱花 效果图(这个是动态的): 实现代码 import turtle as T import random import time # 画樱花的躯干(60,t) def Tree(branch
深深的码丨Java HashMap 透析
HashMap 相关概念 HashTab、HashMap、TreeMap 均以键值对像是存储或操作数据元素。HashTab继承自Dictionary,HashMap、TreeMap继承自AbstractMap,三者均实现Map接口 **HashTab:**同步哈希表,不支持null键或值,因为同步导致性能影响,很少被使用 **HashMap:**应用较多的非同步哈希表,支持null键或值,是键值对...
大学四年自学走来,这些私藏的实用工具/学习网站我贡献出来了
大学四年,看课本是不可能一直看课本的了,对于学习,特别是自学,善于搜索网上的一些资源来辅助,还是非常有必要的,下面我就把这几年私藏的各种资源,网站贡献出来给你们。主要有:电子书搜索、实用工具、在线视频学习网站、非视频学习网站、软件下载、面试/求职必备网站。 注意:文中提到的所有资源,文末我都给你整理好了,你们只管拿去,如果觉得不错,转发、分享就是最大的支持了。 一、电子书搜索 对于大部分程序员...
linux系列之常用运维命令整理笔录
本博客记录工作中需要的linux运维命令,大学时候开始接触linux,会一些基本操作,可是都没有整理起来,加上是做开发,不做运维,有些命令忘记了,所以现在整理成博客,当然vi,文件操作等就不介绍了,慢慢积累一些其它拓展的命令,博客不定时更新 顺便拉下票,我在参加csdn博客之星竞选,欢迎投票支持,每个QQ或者微信每天都可以投5票,扫二维码即可,http://m234140.nofollow.ax.
Python 基础(一):入门必备知识
目录1 标识符2 关键字3 引号4 编码5 输入输出6 缩进7 多行8 注释9 数据类型10 运算符10.1 常用运算符10.2 运算符优先级 1 标识符 标识符是编程时使用的名字,用于给变量、函数、语句块等命名,Python 中标识符由字母、数字、下划线组成,不能以数字开头,区分大小写。 以下划线开头的标识符有特殊含义,单下划线开头的标识符,如:_xxx ,表示不能直接访问的类属性,需通过类提供
程序员接私活怎样防止做完了不给钱?
首先跟大家说明一点,我们做 IT 类的外包开发,是非标品开发,所以很有可能在开发过程中会有这样那样的需求修改,而这种需求修改很容易造成扯皮,进而影响到费用支付,甚至出现做完了项目收不到钱的情况。 那么,怎么保证自己的薪酬安全呢? 我们在开工前,一定要做好一些证据方面的准备(也就是“讨薪”的理论依据),这其中最重要的就是需求文档和验收标准。一定要让需求方提供这两个文档资料作为开发的基础。之后开发
网页实现一个简单的音乐播放器(大佬别看。(⊙﹏⊙))
今天闲着无事,就想写点东西。然后听了下歌,就打算写个播放器。 于是乎用h5 audio的加上js简单的播放器完工了。 欢迎 改进 留言。 演示地点跳到演示地点 html代码如下`&lt;!DOCTYPE html&gt; &lt;html&gt; &lt;head&gt; &lt;title&gt;music&lt;/title&gt; &lt;meta charset="utf-8"&gt
Python十大装B语法
Python 是一种代表简单思想的语言,其语法相对简单,很容易上手。不过,如果就此小视 Python 语法的精妙和深邃,那就大错特错了。本文精心筛选了最能展现 Python 语法之精妙的十个知识点,并附上详细的实例代码。如能在实战中融会贯通、灵活使用,必将使代码更为精炼、高效,同时也会极大提升代码B格,使之看上去更老练,读起来更优雅。 1. for - else 什么?不是 if 和 else 才
数据库优化 - SQL优化
前面一篇文章从实例的角度进行数据库优化,通过配置一些参数让数据库性能达到最优。但是一些“不好”的SQL也会导致数据库查询变慢,影响业务流程。本文从SQL角度进行数据库优化,提升SQL运行效率。 判断问题SQL 判断SQL是否有问题时可以通过两个表象进行判断: 系统级别表象 CPU消耗严重 IO等待严重 页面响应时间过长
2019年11月中国大陆编程语言排行榜
2019年11月2日,我统计了某招聘网站,获得有效程序员招聘数据9万条。针对招聘信息,提取编程语言关键字,并统计如下: 编程语言比例 rank pl_ percentage 1 java 33.62% 2 c/c++ 16.42% 3 c_sharp 12.82% 4 javascript 12.31% 5 python 7.93% 6 go 7.25% 7
通俗易懂地给女朋友讲:线程池的内部原理
餐厅的约会 餐盘在灯光的照耀下格外晶莹洁白,女朋友拿起红酒杯轻轻地抿了一小口,对我说:“经常听你说线程池,到底线程池到底是个什么原理?”我楞了一下,心里想女朋友今天是怎么了,怎么突然问出这么专业的问题,但做为一个专业人士在女朋友面前也不能露怯啊,想了一下便说:“我先给你讲讲我前同事老王的故事吧!” 大龄程序员老王 老王是一个已经北漂十多年的程序员,岁数大了,加班加不动了,升迁也无望,于是拿着手里
经典算法(5)杨辉三角
杨辉三角 是经典算法,这篇博客对它的算法思想进行了讲解,并有完整的代码实现。
腾讯算法面试题:64匹马8个跑道需要多少轮才能选出最快的四匹?
昨天,有网友私信我,说去阿里面试,彻底的被打击到了。问了为什么网上大量使用ThreadLocal的源码都会加上private static?他被难住了,因为他从来都没有考虑过这个问题。无独有偶,今天笔者又发现有网友吐槽了一道腾讯的面试题,我们一起来看看。 腾讯算法面试题:64匹马8个跑道需要多少轮才能选出最快的四匹? 在互联网职场论坛,一名程序员发帖求助到。二面腾讯,其中一个算法题:64匹
面试官:你连RESTful都不知道我怎么敢要你?
面试官:了解RESTful吗? 我:听说过。 面试官:那什么是RESTful? 我:就是用起来很规范,挺好的 面试官:是RESTful挺好的,还是自我感觉挺好的 我:都挺好的。 面试官:… 把门关上。 我:… 要干嘛?先关上再说。 面试官:我说出去把门关上。 我:what ?,夺门而去 文章目录01 前言02 RESTful的来源03 RESTful6大原则1. C-S架构2. 无状态3.统一的接
JDK12 Collectors.teeing 你真的需要了解一下
前言 在 Java 12 里面有个非常好用但在官方 JEP 没有公布的功能,因为它只是 Collector 中的一个小改动,它的作用是 merge 两个 collector 的结果,这句话显得很抽象,老规矩,我们先来看个图(这真是一个不和谐的图????): 管道改造经常会用这个小东西,通常我们叫它「三通」,它的主要作用就是将 downstream1 和 downstre...
为啥国人偏爱Mybatis,而老外喜欢Hibernate/JPA呢?
关于SQL和ORM的争论,永远都不会终止,我也一直在思考这个问题。昨天又跟群里的小伙伴进行了一番讨论,感触还是有一些,于是就有了今天这篇文。 声明:本文不会下关于Mybatis和JPA两个持久层框架哪个更好这样的结论。只是摆事实,讲道理,所以,请各位看官勿喷。 一、事件起因 关于Mybatis和JPA孰优孰劣的问题,争论已经很多年了。一直也没有结论,毕竟每个人的喜好和习惯是大不相同的。我也看
项目中的if else太多了,该怎么重构?
介绍 最近跟着公司的大佬开发了一款IM系统,类似QQ和微信哈,就是聊天软件。我们有一部分业务逻辑是这样的 if (msgType = "文本") { // dosomething } else if(msgType = "图片") { // doshomething } else if(msgType = "视频") { // doshomething } else { // doshom...
致 Python 初学者
欢迎来到“Python进阶”专栏!来到这里的每一位同学,应该大致上学习了很多 Python 的基础知识,正在努力成长的过程中。在此期间,一定遇到了很多的困惑,对未来的学习方向感到迷茫。我非常理解你们所面临的处境。我从2007年开始接触 python 这门编程语言,从2009年开始单一使用 python 应对所有的开发工作,直至今天。回顾自己的学习过程,也曾经遇到过无数的困难,也曾经迷茫过、困惑过。开办这个专栏,正是为了帮助像我当年一样困惑的 Python 初学者走出困境、快速成长。希望我的经验能真正帮到你
“狗屁不通文章生成器”登顶GitHub热榜,分分钟写出万字形式主义大作
一、垃圾文字生成器介绍 最近在浏览GitHub的时候,发现了这样一个骨骼清奇的雷人项目,而且热度还特别高。 项目中文名:狗屁不通文章生成器 项目英文名:BullshitGenerator 根据作者的介绍,他是偶尔需要一些中文文字用于GUI开发时测试文本渲染,因此开发了这个废话生成器。但由于生成的废话实在是太过富于哲理,所以最近已经被小伙伴们给玩坏了。 他的文风可能是这样的: 你发现,...
程序员:我终于知道post和get的区别
是一个老生常谈的话题,然而随着不断的学习,对于以前的认识有很多误区,所以还是需要不断地总结的,学而时习之,不亦说乎
《程序人生》系列-这个程序员只用了20行代码就拿了冠军
你知道的越多,你不知道的越多 点赞再看,养成习惯GitHub上已经开源https://github.com/JavaFamily,有一线大厂面试点脑图,欢迎Star和完善 前言 这一期不算《吊打面试官》系列的,所有没前言我直接开始。 絮叨 本来应该是没有这期的,看过我上期的小伙伴应该是知道的嘛,双十一比较忙嘛,要值班又要去帮忙拍摄年会的视频素材,还得搞个程序员一天的Vlog,还要写BU...
加快推动区块链技术和产业创新发展,2019可信区块链峰会在京召开
11月8日,由中国信息通信研究院、中国通信标准化协会、中国互联网协会、可信区块链推进计划联合主办,科技行者协办的2019可信区块链峰会将在北京悠唐皇冠假日酒店开幕。   区块链技术被认为是继蒸汽机、电力、互联网之后,下一代颠覆性的核心技术。如果说蒸汽机释放了人类的生产力,电力解决了人类基本的生活需求,互联网彻底改变了信息传递的方式,区块链作为构造信任的技术有重要的价值。   1...
程序员把地府后台管理系统做出来了,还有3.0版本!12月7号最新消息:已在开发中有github地址
第一幕:缘起 听说阎王爷要做个生死簿后台管理系统,我们派去了一个程序员…… 996程序员做的梦: 第一场:团队招募 为了应对地府管理危机,阎王打算找“人”开发一套地府后台管理系统,于是就在地府总经办群中发了项目需求。 话说还是中国电信的信号好,地府都是满格,哈哈!!! 经常会有外行朋友问:看某网站做的不错,功能也简单,你帮忙做一下? 而这次,面对这样的需求,这个程序员...
相关热词 c# clr dll c# 如何orm c# 固定大小的字符数组 c#框架设计 c# 删除数据库 c# 中文文字 图片转 c# 成员属性 接口 c#如何将程序封装 16进制负数转换 c# c#练手项目
立即提问