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 各位大神如果没有这两个依赖包能安装么?会不会出错我这边是直接连接远程服务器 安装出错的话就会很麻烦,很麻烦,很麻烦
求一份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币可以悬赏了。。。。
c# 控制台程序连接oracle 出现“Oracle.DataAccess.Client.OracleConnection”的类型初始值设定项引发异常,已引用 Oracle.ManagedDataAccess.Client; 如何解决?
c# 控制台程序连接oracle 出现“Oracle.DataAccess.Client.OracleConnection”的类型初始值设定项引发异常,已引用 Oracle.ManagedDataAccess.Client; 在一台服务器上可正常运行,搬运到另一台服务器上才会出现上述问题,系统都是win7 64位,是否需要安装客户端?或者需要安装哪些程序才可以?
不知道是不是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;
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] ```
无效的列类型: 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)
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>
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] 。。。。
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'之类的问题
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 ```
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) 下面还有很多补丁要下载的 一次性全部发我得了
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!
大家觉得几大主流的数据库发展前景怎么样?oracle.mysql.nosql等等....
大家觉得几大主流的数据库发展前景怎么样?oracle.mysql.nosql等等....现在在学oracle.但是oracle是不开源的,以后是不是主要从事oracleDBA工作。是认真只学oracle好 还是学多一两种数据库(但是肯定集中学习时间在一种上面)。第一次提问,求搭理.....
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)
终于明白阿里百度这样的大公司,为什么面试经常拿ThreadLocal考验求职者了
点击上面↑「爱开发」关注我们每晚10点,捕获技术思考和创业资源洞察什么是ThreadLocalThreadLocal是一个本地线程副本变量工具类,各个线程都拥有一份线程私有的数
《奇巧淫技》系列-python!!每天早上八点自动发送天气预报邮件到QQ邮箱
此博客仅为我业余记录文章所用,发布到此,仅供网友阅读参考,如有侵权,请通知我,我会删掉。 补充 有不少读者留言说本文章没有用,因为天气预报直接打开手机就可以收到了,为何要多此一举发送到邮箱呢!!!那我在这里只能说:因为你没用,所以你没用!!! 这里主要介绍的是思路,不是天气预报!不是天气预报!!不是天气预报!!!天气预报只是用于举例。请各位不要再刚了!!! 下面是我会用到的两个场景: 每日下
面试官问我:什么是消息队列?什么场景需要他?用了会出现什么问题?
你知道的越多,你不知道的越多 点赞再看,养成习惯 GitHub上已经开源 https://github.com/JavaFamily 有一线大厂面试点脑图、个人联系方式,欢迎Star和完善 前言 消息队列在互联网技术存储方面使用如此广泛,几乎所有的后端技术面试官都要在消息队列的使用和原理方面对小伙伴们进行360°的刁难。 作为一个在互联网公司面一次拿一次Offer的面霸,打败了无数
8年经验面试官详解 Java 面试秘诀
    作者 | 胡书敏 责编 | 刘静 出品 | CSDN(ID:CSDNnews) 本人目前在一家知名外企担任架构师,而且最近八年来,在多家外企和互联网公司担任Java技术面试官,前后累计面试了有两三百位候选人。在本文里,就将结合本人的面试经验,针对Java初学者、Java初级开发和Java开发,给出若干准备简历和准备面试的建议。   Java程序员准备和投递简历的实
究竟你适不适合买Mac?
我清晰的记得,刚买的macbook pro回到家,开机后第一件事情,就是上了淘宝网,花了500元钱,找了一个上门维修电脑的师傅,上门给我装了一个windows系统。。。。。。 表砍我。。。 当时买mac的初衷,只是想要个固态硬盘的笔记本,用来运行一些复杂的扑克软件。而看了当时所有的SSD笔记本后,最终决定,还是买个好(xiong)看(da)的。 已经有好几个朋友问我mba怎么样了,所以今天尽量客观
MyBatis研习录(01)——MyBatis概述与入门
C语言自学完备手册(33篇) Android多分辨率适配框架 JavaWeb核心技术系列教程 HTML5前端开发实战系列教程 MySQL数据库实操教程(35篇图文版) 推翻自己和过往——自定义View系列教程(10篇) 走出思维困境,踏上精进之路——Android开发进阶精华录 讲给Android程序员看的前端系列教程(40集免费视频教程+源码) 版权声明 本文原创作者:谷哥的小弟 作者博客
程序员一般通过什么途径接私活?
二哥,你好,我想知道一般程序猿都如何接私活,我也想接,能告诉我一些方法吗? 上面是一个读者“烦不烦”问我的一个问题。其实不止是“烦不烦”,还有很多读者问过我类似这样的问题。 我接的私活不算多,挣到的钱也没有多少,加起来不到 20W。说实话,这个数目说出来我是有点心虚的,毕竟太少了,大家轻喷。但我想,恰好配得上“一般程序员”这个称号啊。毕竟苍蝇再小也是肉,我也算是有经验的人了。 唾弃接私活、做外
Python爬虫爬取淘宝,京东商品信息
小编是一个理科生,不善长说一些废话。简单介绍下原理然后直接上代码。 使用的工具(Python+pycharm2019.3+selenium+xpath+chromedriver)其中要使用pycharm也可以私聊我selenium是一个框架可以通过pip下载 pip install selenium -i https://pypi.tuna.tsinghua.edu.cn/simple/ 
阿里程序员写了一个新手都写不出的低级bug,被骂惨了。
你知道的越多,你不知道的越多 点赞再看,养成习惯 本文 GitHub https://github.com/JavaFamily 已收录,有一线大厂面试点思维导图,也整理了很多我的文档,欢迎Star和完善,大家面试可以参照考点复习,希望我们一起有点东西。 前前言 为啥今天有个前前言呢? 因为你们的丙丙啊,昨天有牌面了哟,直接被微信官方推荐,知乎推荐,也就仅仅是还行吧(心里乐开花)
Java工作4年来应聘要16K最后没要,细节如下。。。
前奏: 今天2B哥和大家分享一位前几天面试的一位应聘者,工作4年26岁,统招本科。 以下就是他的简历和面试情况。 基本情况: 专业技能: 1、&nbsp;熟悉Sping了解SpringMVC、SpringBoot、Mybatis等框架、了解SpringCloud微服务 2、&nbsp;熟悉常用项目管理工具:SVN、GIT、MAVEN、Jenkins 3、&nbsp;熟悉Nginx、tomca
Python爬虫精简步骤1 获取数据
爬虫的工作分为四步: 1.获取数据。爬虫程序会根据我们提供的网址,向服务器发起请求,然后返回数据。 2.解析数据。爬虫程序会把服务器返回的数据解析成我们能读懂的格式。 3.提取数据。爬虫程序再从中提取出我们需要的数据。 4.储存数据。爬虫程序把这些有用的数据保存起来,便于你日后的使用和分析。 这一篇的内容就是:获取数据。 首先,我们将会利用一个强大的库——requests来获取数据。 在电脑上安装
Python绘图,圣诞树,花,爱心 | Turtle篇
1.画圣诞树 import turtle screen = turtle.Screen() screen.setup(800,600) circle = turtle.Turtle() circle.shape('circle') circle.color('red') circle.speed('fastest') circle.up() square = turtle.Turtle()
作为一个程序员,CPU的这些硬核知识你必须会!
CPU对每个程序员来说,是个既熟悉又陌生的东西? 如果你只知道CPU是中央处理器的话,那可能对你并没有什么用,那么作为程序员的我们,必须要搞懂的就是CPU这家伙是如何运行的,尤其要搞懂它里面的寄存器是怎么一回事,因为这将让你从底层明白程序的运行机制。 随我一起,来好好认识下CPU这货吧 把CPU掰开来看 对于CPU来说,我们首先就要搞明白它是怎么回事,也就是它的内部构造,当然,CPU那么牛的一个东
破14亿,Python分析我国存在哪些人口危机!
2020年1月17日,国家统计局发布了2019年国民经济报告,报告中指出我国人口突破14亿。 猪哥的朋友圈被14亿人口刷屏,但是很多人并没有看到我国复杂的人口问题:老龄化、男女比例失衡、生育率下降、人口红利下降等。 今天我们就来分析一下我们国家的人口数据吧! 更多有趣分析教程,扫描下方二维码关注vx公号「裸睡的猪」 即可查看! 一、背景 1.人口突破14亿 2020年1月17日,国家统计局发布
web前端javascript+jquery知识点总结
Javascript javascript 在前端网页中占有非常重要的地位,可以用于验证表单,制作特效等功能,它是一种描述语言,也是一种基于对象(Object)和事件驱动并具有安全性的脚本语言 ,语法同java类似,是一种解释性语言,边执行边解释。 JavaScript的组成: ECMAScipt 用于描述: 语法,变量和数据类型,运算符,逻辑控制语句,关键字保留字,对象。 浏览器对象模型(Br
Python实战:抓肺炎疫情实时数据,画2019-nCoV疫情地图
文章目录1. 前言2. 数据下载3. 数据处理4. 数据可视化 1. 前言 今天,群里白垩老师问如何用python画武汉肺炎疫情地图。白垩老师是研究海洋生态与地球生物的学者,国家重点实验室成员,于不惑之年学习python,实为我等学习楷模。先前我并没有关注武汉肺炎的具体数据,也没有画过类似的数据分布图。于是就拿了两个小时,专门研究了一下,遂成此文。 2月6日追记:本文发布后,腾讯的数据源多次变更u
听说想当黑客的都玩过这个Monyer游戏(1~14攻略)
第零关 进入传送门开始第0关(游戏链接) 请点击链接进入第1关: 连接在左边→ ←连接在右边 看不到啊。。。。(只能看到一堆大佬做完的留名,也能看到菜鸡的我,在后面~~) 直接fn+f12吧 &lt;span&gt;连接在左边→&lt;/span&gt; &lt;a href="first.php"&gt;&lt;/a&gt; &lt;span&gt;←连接在右边&lt;/span&gt; o
在家远程办公效率低?那你一定要收好这个「在家办公」神器!
相信大家都已经收到国务院延长春节假期的消息,接下来,在家远程办公可能将会持续一段时间。 但是问题来了。远程办公不是人在电脑前就当坐班了,相反,对于沟通效率,文件协作,以及信息安全都有着极高的要求。有着非常多的挑战,比如: 1在异地互相不见面的会议上,如何提高沟通效率? 2文件之间的来往反馈如何做到及时性?如何保证信息安全? 3如何规划安排每天工作,以及如何进行成果验收? ......
作为一个程序员,内存和磁盘的这些事情,你不得不知道啊!!!
截止目前,我已经分享了如下几篇文章: 一个程序在计算机中是如何运行的?超级干货!!! 作为一个程序员,CPU的这些硬核知识你必须会! 作为一个程序员,内存的这些硬核知识你必须懂! 这些知识可以说是我们之前都不太重视的基础知识,可能大家在上大学的时候都学习过了,但是嘞,当时由于老师讲解的没那么有趣,又加上这些知识本身就比较枯燥,所以嘞,大家当初几乎等于没学。 再说啦,学习这些,也看不出来有什么用啊!
渗透测试-灰鸽子远控木马
木马概述 灰鸽子( Huigezi),原本该软件适用于公司和家庭管理,其功能十分强大,不但能监视摄像头、键盘记录、监控桌面、文件操作等。还提供了黑客专用功能,如:伪装系统图标、随意更换启动项名称和表述、随意更换端口、运行后自删除、毫无提示安装等,并采用反弹链接这种缺陷设计,使得使用者拥有最高权限,一经破解即无法控制。最终导致被黑客恶意使用。原作者的灰鸽子被定义为是一款集多种控制方式于一体的木马程序
Python:爬取疫情每日数据
前言 有部分同学留言说为什么412,这是因为我代码里全国的cookies需要你自己打开浏览器更新好后替换,而且这个cookies大概只能持续20秒左右! 另外全国卫健委的数据格式一直在变,也有可能会导致爬取失败! 我现在已根据2月14日最新通报稿的格式修正了! 目前每天各大平台,如腾讯、今日头条都会更新疫情每日数据,他们的数据源都是一样的,主要都是通过各地的卫健委官网通报。 为什么已经有大量平台做
这个世界上人真的分三六九等,你信吗?
偶然间,在知乎上看到一个问题 一时间,勾起了我深深的回忆。 以前在厂里打过两次工,做过家教,干过辅导班,做过中介。零下几度的晚上,贴过广告,满脸、满手地长冻疮。   再回首那段岁月,虽然苦,但让我学会了坚持和忍耐。让我明白了,在这个世界上,无论环境多么的恶劣,只要心存希望,星星之火,亦可燎原。   下文是原回答,希望能对你能有所启发。   如果我说,这个世界上人真的分三六九等,
B 站上有哪些很好的学习资源?
哇说起B站,在小九眼里就是宝藏般的存在,放年假宅在家时一天刷6、7个小时不在话下,更别提今年的跨年晚会,我简直是跪着看完的!! 最早大家聚在在B站是为了追番,再后来我在上面刷欧美新歌和漂亮小姐姐的舞蹈视频,最近两年我和周围的朋友们已经把B站当作学习教室了,而且学习成本还免费,真是个励志的好平台ヽ(.◕ฺˇд ˇ◕ฺ;)ノ 下面我们就来盘点一下B站上优质的学习资源: 综合类 Oeasy: 综合
雷火神山直播超两亿,Web播放器事件监听是怎么实现的?
Web播放器解决了在手机浏览器和PC浏览器上播放音视频数据的问题,让视音频内容可以不依赖用户安装App,就能进行播放以及在社交平台进行传播。在视频业务大数据平台中,播放数据的统计分析非常重要,所以Web播放器在使用过程中,需要对其内部的数据进行收集并上报至服务端,此时,就需要对发生在其内部的一些播放行为进行事件监听。 那么Web播放器事件监听是怎么实现的呢? 01 监听事件明细表 名
3万字总结,Mysql优化之精髓
本文知识点较多,篇幅较长,请耐心学习 MySQL已经成为时下关系型数据库产品的中坚力量,备受互联网大厂的青睐,出门面试想进BAT,想拿高工资,不会点MySQL优化知识,拿offer的成功率会大大下降。 为什么要优化 系统的吞吐量瓶颈往往出现在数据库的访问速度上 随着应用程序的运行,数据库的中的数据会越来越多,处理时间会相应变慢 数据是存放在磁盘上的,读写速度无法和内存相比 如何优化 设计
Python新型冠状病毒疫情数据自动爬取+统计+发送报告+数据屏幕(三)发送篇
今天介绍的项目是使用 Itchat 发送统计报告 项目功能设计: 定时爬取疫情数据存入Mysql 进行数据分析制作疫情报告 使用itchat给亲人朋友发送分析报告(本文) 基于Django做数据屏幕 使用Tableau做数据分析 来看看最终效果 目前已经完成,预计2月12日前更新 使用 itchat 发送数据统计报告 itchat 是一个基于 web微信的一个框架,但微信官方并不允
作为程序员的我,大学四年一直自学,全靠这些实用工具和学习网站!
我本人因为高中沉迷于爱情,导致学业荒废,后来高考,毫无疑问进入了一所普普通通的大学,实在惭愧...... 我又是那么好强,现在学历不行,没办法改变的事情了,所以,进入大学开始,我就下定决心,一定要让自己掌握更多的技能,尤其选择了计算机这个行业,一定要多学习技术。 在进入大学学习不久后,我就认清了一个现实:我这个大学的整体教学质量和学习风气,真的一言难尽,懂的人自然知道怎么回事? 怎么办?我该如何更好的提升
粒子群算法求解物流配送路线问题(python)
粒子群算法求解物流配送路线问题(python) 1.查找论文文献 找一篇物流配送路径优化+粒子群算法求解的论文 参考文献:基于混沌粒子群算法的物流配送路径优化 2.了解粒子群算法的原理 讲解通俗易懂,有数学实例的博文:https://blog.csdn.net/daaikuaichuan/article/details/81382794 3.确定编码方式和解码策略 3.1编码方式 物流配送路线的
教你如何编写第一个简单的爬虫
很多人知道爬虫,也很想利用爬虫去爬取自己想要的数据,那么爬虫到底怎么用呢?今天就教大家编写一个简单的爬虫。 下面以爬取笔者的个人博客网站为例获取第一篇文章的标题名称,教大家学会一个简单的爬虫。 第一步:获取页面 #!/usr/bin/python # coding: utf-8 import requests #引入包requests link = "http://www.santostang.
前端JS初级面试题二 (。•ˇ‸ˇ•。)老铁们!快来瞧瞧自己都会了么
1. 传统事件绑定和符合W3C标准的事件绑定有什么区别? 传统事件绑定 &lt;div onclick=""&gt;123&lt;/div&gt; div1.onclick = function(){}; &lt;button onmouseover=""&gt;&lt;/button&gt; 注意: 如果给同一个元素绑定了两次或多次相同类型的事件,那么后面的绑定会覆盖前面的绑定 (不支持DOM事...
相关热词 c# 压缩图片好麻烦 c#计算数组中的平均值 c#获取路由参数 c#日期精确到分钟 c#自定义异常必须继承 c#查表并返回值 c# 动态 表达式树 c# 监控方法耗时 c# listbox c#chart显示滚动条
立即提问