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 开始启动的时候业务异常,但是启动一段时间后就报上述用户名和密码错误。

4个回答

追问:我目前找不到是什么原因导致了,求大神解答


有人能指导下上述问题出在什么地方不?
我们搞java的好像也无多大办法了。
我自己用jdbc 开多线程连接并无异常,c3p0 开始启动的时候业务异常,但是启动一段时间后就报上述用户名和密码错误。

1、用dba角色的用户登陆,进行解锁,先设置具体时间格式,以便查看具体时间
SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
Session altered.
2、查看具体的被锁时间
SQL> select username,lock_date from dba_users where username='TEST';
USERNAME LOCK_DATE TEST 2009-03-10 08:51:03
3、解锁
SQL> alter user test account unlock;
User altered.
4、查看是那个ip造成的test用户被锁
查看$ORACLE_HOME/network/admin/log/listener.log日志
10-MAR-2009 08:51:03 * (CONNECT_DATA=(SID=lhoms)(SERVER=DEDICATED)(CID=(PROGRAM=Oracle)(HOST=omstestdb)(USER=oraoms))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.69.1.11)(PORT=49434)) * establish * lhoms * 0
10-MAR-2009 08:51:03 * (CONNECT_DATA=(SID=lhoms)(SERVER=DEDICATED)(CID=(PROGRAM=oracle)(HOST=omstestdb)(USER=oraoms))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.69.1.11)(PORT=49435)) * establish * lhoms * 0
这样可知是上面10.69.1.11的ip尝试多次失败登陆造成的被锁
注:
一般数据库默认是10次尝试失败后锁住用户
1、查看FAILED_LOGIN_ATTEMPTS的值
select * from dba_profiles where RESOURCE_NAME = 'FAILED_LOGIN_ATTEMPTS';
2、修改为30次
alter profile default limit FAILED_LOGIN_ATTEMPTS 30;
3、修改为无限次(为安全起见,不建议使用)
alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;

首先多谢您的回答,目前上述方式都尝试过了,我怀疑是前端web的c3p0连接池有异常。
多谢你

分析过11.2.4版本和11.2.3版本的变化。
替换了c3p0的驱动。
修改过 密码错误无上限验证等后问题还是没解决。、

最后让我在在意外中发现 ojdbc6.jar的驱动,在11.2.4版本中比原来的ojdc要大100kb左右。。。。。。。。。

一千万头操TM。。。

日咋早就不想想是不是这个驱动问题。

我替换过这个驱动后,系统运行正常,再无上述日志的错误。

此问题算完结。

再次多谢 热心的 @chenjiexixi

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
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 找不到出错的原因,求大侠们帮忙?
oracle10.2.0.4升级到11.2.0.1相关问题
进行升级之后,11g的新特性只读表使用不成功,在升级后需要执行什么内置脚本吗?
关于Ubuntu14安装oracle11.0.2.0.4依赖包的问题
在安装依赖包的过程中出现两个依赖包不能安装: 1、未发现软件包 lesstif2 2、未发现软件包 libpthread-stubs0 各位大神如果没有这两个依赖包能安装么?会不会出错我这边是直接连接远程服务器 安装出错的话就会很麻烦,很麻烦,很麻烦
c# 控制台程序连接oracle 出现“Oracle.DataAccess.Client.OracleConnection”的类型初始值设定项引发异常,已引用 Oracle.ManagedDataAccess.Client; 如何解决?
c# 控制台程序连接oracle 出现“Oracle.DataAccess.Client.OracleConnection”的类型初始值设定项引发异常,已引用 Oracle.ManagedDataAccess.Client; 在一台服务器上可正常运行,搬运到另一台服务器上才会出现上述问题,系统都是win7 64位,是否需要安装客户端?或者需要安装哪些程序才可以?
求一份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币可以悬赏了。。。。
不知道是不是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;
无效的列类型: getString/getNString not implemented for class oracle.jdbc.driver.T4CBlobAccessor
项目里的一个附件功能:刚开始在新增页面,填写个人信息,选择附件上传提交都是没问题的,然后到了审批流程,查看这个个人信息就会报错,还没有点“同意”或者“否决”,刚进入这个审批页面就报错了,报错如下: uncategorized SQLException for SQL []; SQL state [99999]; error code [17004]; 无效的列类型: getString/getNString not implemented for class oracle.jdbc.driver.T4CBlobAccessor; nested exception is java.sql.SQLException: 无效的列类型: getString/getNString not implemented for class oracle.jdbc.driver.T4CBlobAccessor![图片说明](https://img-ask.csdn.net/upload/201910/29/1572318374_855211.png)
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 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 请问要怎么解决呀?
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>
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 ```
oracle 11.2监听日志大量service update
今天早上无法远程登录oracle,报tns超时,去看了监听日志,大量的service update信息,过了一段时间以后,再链接又能远程登录了,日志也变正常了,这是怎么一回事情,怎么排查这一类问题
求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] 。。。。
windows系统的orcl32位版本11.2.0.1.0的安全补丁谁有发我一份
windows系统的orcl32位版本11.2.0.1.0的安全补丁谁有发我一份 ![图片说明](https://img-ask.csdn.net/upload/201908/09/1565323811_258638.jpg) ![图片说明](https://img-ask.csdn.net/upload/201908/09/1565323894_410401.jpg) ![图片说明](https://img-ask.csdn.net/upload/201908/09/1565324026_344008.jpg) ![图片说明](https://img-ask.csdn.net/upload/201908/09/1565324071_362478.jpg) 下面还有很多补丁要下载的 一次性全部发我得了
ubuntu server 13.10安装oracle11gr2问题:求帮助
调用 makefile '/var/u01/app/oracle/product/11.2.0/dbhome_1/ctx/lib/ins_ctx.mk' 的目标 'install' 时出错。有关详细信息, 请参阅 '/var/u01/app/oraInventory/logs/installActions2013-12-04_06-38-25AM.log'。 调用 makefile '/var/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk' 的目标 'agent nmhs' 时出错。有关详细信息, 请参阅 '/var/u01/app/oraInventory/logs/installActions2013-12-04_06-38-25AM.log'。 调用 makefile '/var/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk' 的目标 'all_no_orcl ipc_g' 时出错。有关详细信息, 请参阅 '/var/u01/app/oraInventory/logs/installActions2013-12-04_06-38-25AM.log'。 调用 makefile '/var/u01/app/oracle/product/11.2.0/dbhome_1/network/lib/ins_net_server.mk' 的目标 'install' 时出错。有关详细信息, 请参阅 '/var/u01/app/oraInventory/logs/installActions2013-12-04_06-38-25AM.log'。 调用 makefile '/var/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk' 的目标 'irman ioracle' 时出错。有关详细信息, 请参阅 '/var/u01/app/oraInventory/logs/installActions2013-12-04_06-38-25AM.log'。 具体的log没看到有神么错误信息,但是在make.log里面发现有很多ntt.c:(.text+0x1463c): undefined reference to `sltskyg'之类的问题
php2018用的php5.6打开oci之后Oracle Run-time Client Library Version一直显示0.0.0.0.0
php2018用的php5.6打开oci之后Oracle Run-time Client Library Version一直显示0.0.0.0.0![图片说明](https://img-ask.csdn.net/upload/201908/05/1565005481_340809.png)![图片说明](https://img-ask.csdn.net/upload/201908/05/1565005486_861377.png)
centos6.5远程安装oracle11g
在使用xmanger安装oracle11g执行./runInstaller 报错 Exception in thread "main" java.lang.NoClassDefFoundError at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:164) at java.awt.Toolkit$2.run(Toolkit.java:821) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:804) at com.jgoodies.looks.LookUtils.isLowResolution(Unknown Source) at com.jgoodies.looks.LookUtils.<clinit>(Unknown Source) at com.jgoodies.looks.plastic.PlasticLookAndFeel.<clinit>(PlasticLookAndFeel.java:122) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:242) at javax.swing.SwingUtilities.loadSystemClass(SwingUtilities.java:1783) at javax.swing.UIManager.setLookAndFeel(UIManager.java:480) at oracle.install.commons.util.Application.startup(Application.java:758) at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:164) at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:181) at oracle.install.commons.base.driver.common.Installer.startup(Installer.java:265) at oracle.install.ivw.db.driver.DBInstaller.startup(DBInstaller.java:114) at oracle.install.ivw.db.driver.DBInstaller.main(DBInstaller.java:132)
c3p0 oracle10.2 ojbc611.2.0.1.0. 数据库连接出错500
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
java.sql.SQLException: ORA-28040: 没有匹配的验证协议
2019-12-14 16:54:51,024 666517 [bio-8888-exec-7] DEBUG .web.servlet.DispatcherServlet - DispatcherServlet with name 'dispatcherServlet' processing GET request for [/travel_web/product/findAll1.do] 2019-12-14 16:54:51,024 666517 [bio-8888-exec-7] DEBUG n.RequestMappingHandlerMapping - Looking up handler method for path /product/findAll1.do 2019-12-14 16:54:51,024 666517 [bio-8888-exec-7] DEBUG n.RequestMappingHandlerMapping - Returning handler method [public java.util.List<com.tvl.domain.Product> com.tvl.web.controller.ProductController.findAll1()] 2019-12-14 16:54:51,024 666517 [bio-8888-exec-7] DEBUG ort.DefaultListableBeanFactory - Returning cached instance of singleton bean 'productController' 2019-12-14 16:54:51,024 666517 [bio-8888-exec-7] DEBUG .web.servlet.DispatcherServlet - Last-Modified value for [/travel_web/product/findAll1.do] is: -1 controller in ...... 2019-12-14 16:54:51,025 666518 [bio-8888-exec-7] DEBUG e.DataSourceTransactionManager - Creating new transaction with name [com.tvl.service.impl.ProductServiceImpl.findAll]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; '' 2019-12-14 16:55:05,058 680551 [reate-685899154] ERROR aba.druid.pool.DruidDataSource - create connection error java.sql.SQLException: ORA-28040: 没有匹配的验证协议 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278) at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:288) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1375) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1431) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1844)
爬虫福利二 之 妹子图网MM批量下载
爬虫福利一:27报网MM批量下载    点击 看了本文,相信大家对爬虫一定会产生强烈的兴趣,激励自己去学习爬虫,在这里提前祝:大家学有所成! 目标网站:妹子图网 环境:Python3.x 相关第三方模块:requests、beautifulsoup4 Re:各位在测试时只需要将代码里的变量 path 指定为你当前系统要保存的路径,使用 python xxx.py 或IDE运行即可。
Java学习的正确打开方式
在博主认为,对于入门级学习java的最佳学习方法莫过于视频+博客+书籍+总结,前三者博主将淋漓尽致地挥毫于这篇博客文章中,至于总结在于个人,实际上越到后面你会发现学习的最好方式就是阅读参考官方文档其次就是国内的书籍,博客次之,这又是一个层次了,这里暂时不提后面再谈。博主将为各位入门java保驾护航,各位只管冲鸭!!!上天是公平的,只要不辜负时间,时间自然不会辜负你。 何谓学习?博主所理解的学习,它
程序员必须掌握的核心算法有哪些?
由于我之前一直强调数据结构以及算法学习的重要性,所以就有一些读者经常问我,数据结构与算法应该要学习到哪个程度呢?,说实话,这个问题我不知道要怎么回答你,主要取决于你想学习到哪些程度,不过针对这个问题,我稍微总结一下我学过的算法知识点,以及我觉得值得学习的算法。这些算法与数据结构的学习大多数是零散的,并没有一本把他们全部覆盖的书籍。下面是我觉得值得学习的一些算法以及数据结构,当然,我也会整理一些看过
大学四年自学走来,这些私藏的实用工具/学习网站我贡献出来了
大学四年,看课本是不可能一直看课本的了,对于学习,特别是自学,善于搜索网上的一些资源来辅助,还是非常有必要的,下面我就把这几年私藏的各种资源,网站贡献出来给你们。主要有:电子书搜索、实用工具、在线视频学习网站、非视频学习网站、软件下载、面试/求职必备网站。 注意:文中提到的所有资源,文末我都给你整理好了,你们只管拿去,如果觉得不错,转发、分享就是最大的支持了。 一、PDF搜索网站推荐 对于大部
linux系列之常用运维命令整理笔录
本博客记录工作中需要的linux运维命令,大学时候开始接触linux,会一些基本操作,可是都没有整理起来,加上是做开发,不做运维,有些命令忘记了,所以现在整理成博客,当然vi,文件操作等就不介绍了,慢慢积累一些其它拓展的命令,博客不定时更新 顺便拉下票,我在参加csdn博客之星竞选,欢迎投票支持,每个QQ或者微信每天都可以投5票,扫二维码即可,http://m234140.nofollow.ax.
比特币原理详解
一、什么是比特币 比特币是一种电子货币,是一种基于密码学的货币,在2008年11月1日由中本聪发表比特币白皮书,文中提出了一种去中心化的电子记账系统,我们平时的电子现金是银行来记账,因为银行的背后是国家信用。去中心化电子记账系统是参与者共同记账。比特币可以防止主权危机、信用风险。其好处不多做赘述,这一层面介绍的文章很多,本文主要从更深层的技术原理角度进行介绍。 二、问题引入  假设现有4个人
程序员接私活怎样防止做完了不给钱?
首先跟大家说明一点,我们做 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)杨辉三角
写在前面: 我是 扬帆向海,这个昵称来源于我的名字以及女朋友的名字。我热爱技术、热爱开源、热爱编程。技术是开源的、知识是共享的。 这博客是对自己学习的一点点总结及记录,如果您对 Java、算法 感兴趣,可以关注我的动态,我们一起学习。 用知识改变命运,让我们的家人过上更好的生活。 目录一、杨辉三角的介绍二、杨辉三角的算法思想三、代码实现1.第一种写法2.第二种写法 一、杨辉三角的介绍 百度
腾讯算法面试题:64匹马8个跑道需要多少轮才能选出最快的四匹?
昨天,有网友私信我,说去阿里面试,彻底的被打击到了。问了为什么网上大量使用ThreadLocal的源码都会加上private static?他被难住了,因为他从来都没有考虑过这个问题。无独有偶,今天笔者又发现有网友吐槽了一道腾讯的面试题,我们一起来看看。 腾讯算法面试题:64匹马8个跑道需要多少轮才能选出最快的四匹? 在互联网职场论坛,一名程序员发帖求助到。二面腾讯,其中一个算法题:64匹
面试官:你连RESTful都不知道我怎么敢要你?
面试官:了解RESTful吗? 我:听说过。 面试官:那什么是RESTful? 我:就是用起来很规范,挺好的 面试官:是RESTful挺好的,还是自我感觉挺好的 我:都挺好的。 面试官:… 把门关上。 我:… 要干嘛?先关上再说。 面试官:我说出去把门关上。 我:what ?,夺门而去 文章目录01 前言02 RESTful的来源03 RESTful6大原则1. C-S架构2. 无状态3.统一的接
为啥国人偏爱Mybatis,而老外喜欢Hibernate/JPA呢?
关于SQL和ORM的争论,永远都不会终止,我也一直在思考这个问题。昨天又跟群里的小伙伴进行了一番讨论,感触还是有一些,于是就有了今天这篇文。 声明:本文不会下关于Mybatis和JPA两个持久层框架哪个更好这样的结论。只是摆事实,讲道理,所以,请各位看官勿喷。 一、事件起因 关于Mybatis和JPA孰优孰劣的问题,争论已经很多年了。一直也没有结论,毕竟每个人的喜好和习惯是大不相同的。我也看
SQL-小白最佳入门sql查询一
一 说明 如果是初学者,建议去网上寻找安装Mysql的文章安装,以及使用navicat连接数据库,以后的示例基本是使用mysql数据库管理系统; 二 准备前提 需要建立一张学生表,列分别是id,名称,年龄,学生信息;本示例中文章篇幅原因SQL注释略; 建表语句: CREATE TABLE `student` ( `id` int(11) NOT NULL AUTO_INCREMENT, `
项目中的if else太多了,该怎么重构?
介绍 最近跟着公司的大佬开发了一款IM系统,类似QQ和微信哈,就是聊天软件。我们有一部分业务逻辑是这样的 if (msgType = "文本") { // dosomething } else if(msgType = "图片") { // doshomething } else if(msgType = "视频") { // doshomething } else { // dosho
【图解经典算法题】如何用一行代码解决约瑟夫环问题
约瑟夫环问题算是很经典的题了,估计大家都听说过,然后我就在一次笔试中遇到了,下面我就用 3 种方法来详细讲解一下这道题,最后一种方法学了之后保证让你可以让你装逼。 问题描述:编号为 1-N 的 N 个士兵围坐在一起形成一个圆圈,从编号为 1 的士兵开始依次报数(1,2,3…这样依次报),数到 m 的 士兵会被杀死出列,之后的士兵再从 1 开始报数。直到最后剩下一士兵,求这个士兵的编号。 1、方
致 Python 初学者
文章目录1. 前言2. 明确学习目标,不急于求成,不好高骛远3. 在开始学习 Python 之前,你需要做一些准备2.1 Python 的各种发行版2.2 安装 Python2.3 选择一款趁手的开发工具3. 习惯使用IDLE,这是学习python最好的方式4. 严格遵从编码规范5. 代码的运行、调试5. 模块管理5.1 同时安装了py2/py35.2 使用Anaconda,或者通过IDE来安装模
“狗屁不通文章生成器”登顶GitHub热榜,分分钟写出万字形式主义大作
一、垃圾文字生成器介绍 最近在浏览GitHub的时候,发现了这样一个骨骼清奇的雷人项目,而且热度还特别高。 项目中文名:狗屁不通文章生成器 项目英文名:BullshitGenerator 根据作者的介绍,他是偶尔需要一些中文文字用于GUI开发时测试文本渲染,因此开发了这个废话生成器。但由于生成的废话实在是太过富于哲理,所以最近已经被小伙伴们给玩坏了。 他的文风可能是这样的: 你发现,
程序员:我终于知道post和get的区别
IT界知名的程序员曾说:对于那些月薪三万以下,自称IT工程师的码农们,其实我们从来没有把他们归为我们IT工程师的队伍。他们虽然总是以IT工程师自居,但只是他们一厢情愿罢了。 此话一出,不知激起了多少(码农)程序员的愤怒,却又无可奈何,于是码农问程序员。 码农:你知道get和post请求到底有什么区别? 程序员:你看这篇就知道了。 码农:你月薪三万了? 程序员:嗯。 码农:你是怎么做到的? 程序员:
《程序人生》系列-这个程序员只用了20行代码就拿了冠军
你知道的越多,你不知道的越多 点赞再看,养成习惯GitHub上已经开源https://github.com/JavaFamily,有一线大厂面试点脑图,欢迎Star和完善 前言 这一期不算《吊打面试官》系列的,所有没前言我直接开始。 絮叨 本来应该是没有这期的,看过我上期的小伙伴应该是知道的嘛,双十一比较忙嘛,要值班又要去帮忙拍摄年会的视频素材,还得搞个程序员一天的Vlog,还要写BU
加快推动区块链技术和产业创新发展,2019可信区块链峰会在京召开
      11月8日,由中国信息通信研究院、中国通信标准化协会、中国互联网协会、可信区块链推进计划联合主办,科技行者协办的2019可信区块链峰会将在北京悠唐皇冠假日酒店开幕。   区块链技术被认为是继蒸汽机、电力、互联网之后,下一代颠覆性的核心技术。如果说蒸汽机释放了人类的生产力,电力解决了人类基本的生活需求,互联网彻底改变了信息传递的方式,区块链作为构造信任的技术有重要的价值。   1
程序员把地府后台管理系统做出来了,还有3.0版本!12月7号最新消息:已在开发中有github地址
第一幕:缘起 听说阎王爷要做个生死簿后台管理系统,我们派去了一个程序员…… 996程序员做的梦: 第一场:团队招募 为了应对地府管理危机,阎王打算找“人”开发一套地府后台管理系统,于是就在地府总经办群中发了项目需求。 话说还是中国电信的信号好,地府都是满格,哈哈!!! 经常会有外行朋友问:看某网站做的不错,功能也简单,你帮忙做一下? 而这次,面对这样的需求,这个程序员
网易云6亿用户音乐推荐算法
网易云音乐是音乐爱好者的集聚地,云音乐推荐系统致力于通过 AI 算法的落地,实现用户千人千面的个性化推荐,为用户带来不一样的听歌体验。 本次分享重点介绍 AI 算法在音乐推荐中的应用实践,以及在算法落地过程中遇到的挑战和解决方案。 将从如下两个部分展开: AI 算法在音乐推荐中的应用 音乐场景下的 AI 思考 从 2013 年 4 月正式上线至今,网易云音乐平台持续提供着:乐屏社区、UGC
【技巧总结】位运算装逼指南
位算法的效率有多快我就不说,不信你可以去用 10 亿个数据模拟一下,今天给大家讲一讲位运算的一些经典例子。不过,最重要的不是看懂了这些例子就好,而是要在以后多去运用位运算这些技巧,当然,采用位运算,也是可以装逼的,不信,你往下看。我会从最简单的讲起,一道比一道难度递增,不过居然是讲技巧,那么也不会太难,相信你分分钟看懂。 判断奇偶数 判断一个数是基于还是偶数,相信很多人都做过,一般的做法的代码如下
日均350000亿接入量,腾讯TubeMQ性能超过Kafka
整理 | 夕颜出品 | AI科技大本营(ID:rgznai100) 【导读】近日,腾讯开源动作不断,相继开源了分布式消息中间件TubeMQ,基于最主流的 OpenJDK8开发的
8年经验面试官详解 Java 面试秘诀
    作者 | 胡书敏 责编 | 刘静 出品 | CSDN(ID:CSDNnews) 本人目前在一家知名外企担任架构师,而且最近八年来,在多家外企和互联网公司担任Java技术面试官,前后累计面试了有两三百位候选人。在本文里,就将结合本人的面试经验,针对Java初学者、Java初级开发和Java开发,给出若干准备简历和准备面试的建议。   Java程序员准备和投递简历的实
面试官如何考察你的思维方式?
1.两种思维方式在求职面试中,经常会考察这种问题:北京有多少量特斯拉汽车? 某胡同口的煎饼摊一年能卖出多少个煎饼? 深圳有多少个产品经理? 一辆公交车里能装下多少个乒乓球? 一
相关热词 c# 二进制截断字符串 c#实现窗体设计器 c#检测是否为微信 c# plc s1200 c#里氏转换原则 c# 主界面 c# do loop c#存为组套 模板 c# 停掉协程 c# rgb 读取图片
立即提问