在centos7下oracle11g数据库能支持中文吗

在centos7下oracle11g数据库能支持中文吗?谁知道怎么设置,或者要下载什么?我百度不到~!!求达人支援。

1个回答

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
在centos7系统下,oracle11g数据库创建用户出错。
已经是 SYStem权限了 没有创建临时空间,直接创建的用户 SQL>create urer XXX identified by ZZZ 2 Default tablespace user 3 temporary tablespace temp 4 grant connect,resource to XXX; create user XXX identified by ZZZ ERROR AT line 1: ORA-0195:丢失用户或角色名称 为什么会这样????
虚拟机上centos7,安装oracle数据库,最后配置监听一直失败。
小弟是菜鸟新手。 虚拟机上centos7,安装oracle11g数据库,最后配置监听启动总是各种失败, 方法用了无数还是不行,网上帖子看看很多,各说不一,都尝试了,还是不行。求一大神完整的配置监听启动流程!!小弟拜谢!
CentOS6.2下安装Oracle 11g R2 出现INS-35354,怎么解决?
CentOS6.2下安装Oracle 11g R2 版本的数据库 在选择安装RAC的时候,出现INS-35354,怎么解决?
CentOS安装Oracle11g数据库无法启动图形化安装程序
![图片说明](https://img-ask.csdn.net/upload/201908/21/1566371587_347342.png)![图片说明](https://img-ask.csdn.net/upload/201908/21/1566371604_296152.png)报出这样的错,然后用网上的一些方法用root用户xhost +也没有用
如何进行oracle的差异、增量备份数据库
1、环境:centos7系统 oracle11g 数据泵形式:expdp/impdp 2、操作:利用数据泵进行数据库的差异、增量备份 3、利用其他操作形式如exp/imp、rman或第三方软件进行备份都可以
plsql连接oracle问题
我在win7系统上装了个vmware,然后安装了centos,在centos上装了oracle11g。请问,在windows环境下,只安装plsql能不能连接上我linux下的oracle?在网上看有人说能,但是说的都不太清楚,如果能的话,请讲一下,谢谢!
急!重赏!LINUX+PHP环境上连接ORACLE数据库提示权限拒绝的问题
在LINUX CentOS6.5+PHP5.6环境下,要连接使用Oracle 11g 现在有: (1)D机:数据库服务器,为Oracle 11g (2)C1台式机:安装有 LINUX CentOS6.5+PHP5.6环境和OCI8 (3)C2笔记本机:LINUX CentOS6.5+PHP5.6环境和OCI8 (4)一个PHP WEB程序 在C2机上,PHP WEB程序连接使用D机 oracle正常。 在C1机上,同样的PHP WEB程序连接使用D机 oracle 时,即使OCI8文件已经给最高权限文件和777,还是一直提示: SQLSTATE[HY000]:pdo_oci_handle_factory:ORA-12546:TNS:permission denied (/root/PDO_OCI-1.0/oci_driver.c:463) 请问应该如何解决?![图片说明](https://img-ask.csdn.net/upload/201803/14/1521036171_238370.png)
oracle11g 监听配置问题。
我在centos7下建立数据库,建立监听配置时一直出错,请大神给完整配置流程。 还有,建立库的时候,我记得SID 是 orcl, 但配置文件里service__name 为orcl,这个是服务器名吧~还有 全局数据库名 又是什么??_
CentOS7.2安装Oracle11g,报错[INS-32038] ?
[FATAL] [INS-32038] The operating system group specified for central inventory (oraInventory) ownership is invalid. CAUSE: User performing installation is not a member of the operating system group specified for central inventory(oraInventory) ownership. ACTION: Specify an operating system group that the installing user is a member of. All the members of this operating system group will have write permission to the central inventory directory (oraInventory). A log of this session is currently saved as: /tmp/OraInstall2019-02-18_09-46-24PM/installActions2019-02-18_09-46-24PM.log. Oracle recommends that if you want to keep this log, you should move it from the temporary location to a more permanent location. [oraclenewone@tony01数据库]$ [FATAL] [ines -32038]为中央库存(oraInventory)所有权指定的操作系统组无效。 原因:执行安装的用户不是为中央库存(oraInventory)所有权指定的操作系统组的成员。 操作:指定安装用户所属的操作系统组。这个操作系统组的所有成员都将具有到中央目录目录(oraInventory)的写权限。 这个权限如何赋予才能通过,请教大神们。
centos安装oralce问题
我没有mos账号,但是想安装oracle11g数据库,![图片说明](https://img-ask.csdn.net/upload/201510/14/1444809882_438959.png)官网的这个数据库是什么?能用吗
centos7.4无法静默安装oracle,提示not found in the bean store
INFO: Loading beanstore from file:/data/database/database/response/db_install.rsp INFO: Translating external format into raw format INFO: Loaded BeanStore using the flow data source INFO: Registering the flow data beans INFO: [INS-07001] Value for property 'oracle_install_RACInstall' not found in the bean store. INFO: [INS-07001] Value for property 'CLUSTER_NODES' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_OSDBA' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_OSOPER' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_GlobalDBName' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_SID' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_StorageType' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_InstallOption' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_CustomInstall' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_SystemClass' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_QuickInstallOption' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_AllocatedMemory' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_AutoMemoryOption' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_ConfigurationType' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_EMCentralAgentSelected' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_MountPointLocation' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_LaunchDBCA' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_SecureConfigDisabled' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_EnableAutoBackup' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_LoadExampleSchemas' not found in the bean store. INFO: [INS-07001] Value for property 'oracle_install_db_ReceiveEmailNotif ication' not found in the bean store 环境变量: # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH export ORACLE_BASE=/data/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 #oracle启动数据库实例名 export ORACLE_SID=orcl11g #添加系统环境变量 export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib export TNS_ADMIN=$ORACLE_HOME/network/admin 安装文件: #------------------------------------------------------------------------------ # Do not change the following system generated value. #------------------------------------------------------------------------------ oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 #------------------------------------------------------------------------------ # Specify the installation option. # It can be one of the following: # 1. INSTALL_DB_SWONLY # 2. INSTALL_DB_AND_CONFIG # 3. UPGRADE_DB #------------------------------------------------------------------------------- oracle.install.option=INSTALL_DB_SWONLY #------------------------------------------------------------------------------- # Specify the hostname of the system as set during the install. It can be used # to force the installation to use an alternative hostname rather than using the # first hostname found on the system. (e.g., for systems with multiple hostnames # and network interfaces) #------------------------------------------------------------------------------- ORACLE_HOSTNAME=yukhan #------------------------------------------------------------------------------- # Specify the Unix group to be set for the inventory directory. #------------------------------------------------------------------------------- UNIX_GROUP_NAME=oinstall #------------------------------------------------------------------------------- # Specify the location which holds the inventory files. #------------------------------------------------------------------------------- INVENTORY_LOCATION=/data/oraInventory #------------------------------------------------------------------------------- # Specify the languages in which the components will be installed. # # en : English ja : Japanese # fr : French ko : Korean # ar : Arabic es : Latin American Spanish # bn : Bengali lv : Latvian # pt_BR: Brazilian Portuguese lt : Lithuanian # bg : Bulgarian ms : Malay # fr_CA: Canadian French es_MX: Mexican Spanish # ca : Catalan no : Norwegian # hr : Croatian pl : Polish # cs : Czech pt : Portuguese # da : Danish ro : Romanian # nl : Dutch ru : Russian # ar_EG: Egyptian zh_CN: Simplified Chinese # en_GB: English (Great Britain) sk : Slovak # et : Estonian sl : Slovenian # fi : Finnish es_ES: Spanish # de : German sv : Swedish # el : Greek th : Thai # iw : Hebrew zh_TW: Traditional Chinese # hu : Hungarian tr : Turkish # is : Icelandic uk : Ukrainian # in : Indonesian vi : Vietnamese # it : Italian # # Example : SELECTED_LANGUAGES=en,fr,ja #------------------------------------------------------------------------------ SELECTED_LANGUAGES=en #------------------------------------------------------------------------------ # Specify the complete path of the Oracle Home. #------------------------------------------------------------------------------ ORACLE_HOME=/data/oracle/product/11.2.0/db_1 #------------------------------------------------------------------------------ # Specify the complete path of the Oracle Base. #------------------------------------------------------------------------------ ORACLE_BASE=/data/oracle/ #------------------------------------------------------------------------------ # Specify the installation edition of the component. # # The value should contain only one of these choices. # EE : Enterprise Edition # SE : Standard Edition # SEONE : Standard Edition One # PE : Personal Edition (WINDOWS ONLY) #------------------------------------------------------------------------------ oracle.install.db.InstallEdition=EE #------------------------------------------------------------------------------ # This variable is used to enable or disable custom install. # # true : Components mentioned as part of 'customComponents' property # are considered for install. # false : Value for 'customComponents' is not considered. #------------------------------------------------------------------------------ oracle.install.db.isCustomInstall=false #------------------------------------------------------------------------------ # This variable is considered only if 'IsCustomInstall' is set to true. # # Description: List of Enterprise Edition Options you would like to install. # # The following choices are available. You may specify any # combination of these choices. The components you choose should # be specified in the form "internal-component-name:version" # Below is a list of components you may specify to install. # # oracle.rdbms.partitioning:11.2.0.1.0 - Oracle Partitioning # oracle.rdbms.dm:11.2.0.1.0 - Oracle Data Mining # oracle.rdbms.dv:11.2.0.1.0 - Oracle Database Vault # oracle.rdbms.lbac:11.2.0.1.0 - Oracle Label Security # oracle.rdbms.rat:11.2.0.1.0 - Oracle Real Application Testing # oracle.oraolap:11.2.0.1.0 - Oracle OLAP #------------------------------------------------------------------------------ oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11. 2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms .partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1. 0,oracle.rdbms.rat:11.2.0.1.0 ############################################################################### # # # PRIVILEGED OPERATING SYSTEM GROUPS # # ------------------------------------------ # # Provide values for the OS groups to which OSDBA and OSOPER privileges # # needs to be granted. If the install is being performed as a member of the # # group "dba", then that will be used unless specified otherwise below. # # # ############################################################################### #------------------------------------------------------------------------------ # The DBA_GROUP is the OS group which is to be granted OSDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.DBA_GROUP=dba #------------------------------------------------------------------------------ # The OPER_GROUP is the OS group which is to be granted OSOPER privileges. #------------------------------------------------------------------------------ oracle.install.db.OPER_GROUP=oinstall #------------------------------------------------------------------------------ # Specify the cluster node names selected during the installation. #------------------------------------------------------------------------------ oracle.install.db.CLUSTER_NODES= #------------------------------------------------------------------------------ # Specify the type of database to create. # It can be one of the following: # - GENERAL_PURPOSE/TRANSACTION_PROCESSING # - DATA_WAREHOUSE #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.type=GENERAL_PURPOSE #------------------------------------------------------------------------------ # Specify the Starter Database Global Database Name. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.globalDBName=orcl11g #------------------------------------------------------------------------------ # Specify the Starter Database SID. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.SID=orcl11g #------------------------------------------------------------------------------ # Specify the Starter Database character set. # # It can be one of the following: # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2, # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257, # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6, # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8, # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE, # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950, # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258 #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.characterSet=AL32UTF8 #------------------------------------------------------------------------------ # This variable should be set to true if Automatic Memory Management # in Database is desired. # If Automatic Memory Management is not desired, and memory allocation # is to be done manually, then set it to false. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.memoryOption=true #------------------------------------------------------------------------------ # Specify the total memory allocation for the database. Value(in MB) should be # at least 256 MB, and should not exceed the total physical memory available # on the system. # Example: oracle.install.db.config.starterdb.memoryLimit=512 #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.memoryLimit=3072 #------------------------------------------------------------------------------ # This variable controls whether to load Example Schemas onto the starter # database or not. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.installExampleSchemas=false #------------------------------------------------------------------------------ # This variable includes enabling audit settings, configuring password profiles # and revoking some grants to public. These settings are provided by default. # These settings may also be disabled. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.enableSecuritySettings=true ############################################################################### # # # Passwords can be supplied for the following four schemas in the # # starter database: # # SYS # # SYSTEM # # SYSMAN (used by Enterprise Manager) # # DBSNMP (used by Enterprise Manager) # # # # Same password can be used for all accounts (not recommended) # # or different passwords for each account can be provided (recommended) # # # ############################################################################### #------------------------------------------------------------------------------ # This variable holds the password that is to be used for all schemas in the # starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.ALL=root@001 #------------------------------------------------------------------------------- # Specify the SYS password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYS= #------------------------------------------------------------------------------- # Specify the SYSTEM password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSTEM= #------------------------------------------------------------------------------- # Specify the SYSMAN password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSMAN= #------------------------------------------------------------------------------- # Specify the DBSNMP password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.DBSNMP= #------------------------------------------------------------------------------- # Specify the management option to be selected for the starter database. # It can be one of the following: # 1. GRID_CONTROL # 2. DB_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.control=DB_CONTROL #------------------------------------------------------------------------------- # Specify the Management Service to use if Grid Control is selected to manage # the database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= #------------------------------------------------------------------------------- # This variable indicates whether to receive email notification for critical # alerts when using DB control. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false #------------------------------------------------------------------------------- # Specify the email address to which the notifications are to be sent. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.dbcontrol.emailAddress= #------------------------------------------------------------------------------- # Specify the SMTP server used for email notifications. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.dbcontrol.SMTPServer= ############################################################################### # # # SPECIFY BACKUP AND RECOVERY OPTIONS # # ------------------------------------ # # Out-of-box backup and recovery options for the database can be mentioned # # using the entries below. # # # ############################################################################### #------------------------------------------------------------------------------ # This variable is to be set to false if automated backup is not required. Else # this can be set to true. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.automatedBackup.enable=false #------------------------------------------------------------------------------ # Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily at # 2:00 AM to backup the database. This job will run as the operating system # user that is specified in this variable. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.automatedBackup.osuid= #------------------------------------------------------------------------------- # Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily at # 2:00 AM to backup the database. This job will run as the operating system user # specified by the above entry. The following entry stores the password for the # above operating system user. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.automatedBackup.ospwd= #------------------------------------------------------------------------------- # Specify the type of storage to use for the database. # It can be one of the following: # - FILE_SYSTEM_STORAGE # - ASM_STORAGE #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.storageType= #------------------------------------------------------------------------------- # Specify the database file location which is a directory for datafiles, control # files, redo logs. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= #------------------------------------------------------------------------------- # Specify the backup and recovery location. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= #------------------------------------------------------------------------------- # Specify the existing ASM disk groups to be used for storage. # # Applicable only when oracle.install.db.config.starterdb.storage=ASM #------------------------------------------------------------------------------- oracle.install.db.config.asm.diskGroup= #------------------------------------------------------------------------------- # Specify the password for ASMSNMP user of the ASM instance. # # Applicable only when oracle.install.db.config.starterdb.storage=ASM_SYSTEM #------------------------------------------------------------------------------- oracle.install.db.config.asm.ASMSNMPPassword= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username. # # Example : MYORACLESUPPORT_USERNAME=metalink #------------------------------------------------------------------------------ MYORACLESUPPORT_USERNAME= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username password. # # Example : MYORACLESUPPORT_PASSWORD=password #------------------------------------------------------------------------------ MYORACLESUPPORT_PASSWORD= #------------------------------------------------------------------------------ # Specify whether to enable the user to set the password for # My Oracle Support credentials. The value can be either true or false. # If left blank it will be assumed to be false. # # Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true #------------------------------------------------------------------------------ SECURITY_UPDATES_VIA_MYORACLESUPPORT= #------------------------------------------------------------------------------ # Specify whether user wants to give any proxy details for connection. # The value can be either true or false. If left blank it will be assumed # to be false. # # Example : DECLINE_SECURITY_UPDATES=false #------------------------------------------------------------------------------ DECLINE_SECURITY_UPDATES=true #------------------------------------------------------------------------------ # Specify the Proxy server name. Length should be greater than zero. # # Example : PROXY_HOST=proxy.domain.com #------------------------------------------------------------------------------ PROXY_HOST= #------------------------------------------------------------------------------ # Specify the proxy port number. Should be Numeric and atleast 2 chars. # # Example : PROXY_PORT=25 #------------------------------------------------------------------------------ PROXY_PORT= #------------------------------------------------------------------------------ # Specify the proxy user name. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication. # # Example : PROXY_USER=username #------------------------------------------------------------------------------ PROXY_USER= #------------------------------------------------------------------------------ # Specify the proxy password. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication. # # Example : PROXY_PWD=password #------------------------------------------------------------------------------ PROXY_PWD=
Oracle11g由于应用sql语句问题造成IO高,cpu高,业务中断,请教解决方法!
基本情况: 一个网站应用,两台虚拟机,一台web服务器,一台Oracle数据库服务器,最近经常出现应用中断现象,每次持续10到30分钟,不进行处理也能自行恢复正常,查看服务器状态发现是由于Oracle数据库CPU占用100%造成业务中断,经过排查发现是由于应用中的sql语句执行时间太长,并且是全表扫描,造成了IO达到峰值,进而造成CPU占用100%,因网站程序的开发团队已经解散,无法进行应用sql的优化,短期内又无法更换网站程序,所以想在Oracle服务器上看有没有什么可以解决的方案? Oracle中应用的表空间2.1G,已用88%,设置自增;临时表空间4.6G,无自增。Oracle服务器的系统为centos6.5,内存4G。
oracle连接 session关闭的问题
操作系统:本地WIN7 服务器 CentOs 6 项目语言:java 数据库:oracle 10g 今天出现这么个问题,当我连接服务器数据库时.tomcat启动,查看oracle的 'aaa'用户的连接数为10,tomcat关闭后,还是10,没有释放session。然后我重启tomcat后,session就变为20了。没启动一次连接数就变大。 而当我连接本地数据库时,tomcat启动,查看oracle的 'aaa'用户的连接数为10,tomcat关闭后,释放session,改用户连接数为0。 不知道是什么原因,是服务器上的ORACLE有问题?服务器的ORACLE有其它用户,其它用户的session正常。
oracle自动关闭,提示ORA-27300
系统是centos7,oracle自动关闭后内存和硬盘使用情况: ``` [root@wjdb ~]# free -m total used free shared buffers cached Mem: 64267 62984 1283 16 277 60243 -/+ buffers/cache: 2462 61804 Swap: 35839 0 35839 [root@wjdb ~]# df -hl Filesystem Size Used Avail Use% Mounted on /dev/vda1 40G 27G 11G 73% / devtmpfs 32G 0 32G 0% /dev tmpfs 32G 84K 32G 1% /dev/shm tmpfs 32G 17M 32G 1% /run tmpfs 32G 0 32G 0% /sys/fs/cgroup /dev/mapper/centosVG-tmp 25G 45M 24G 1% /tmp /dev/mapper/centosVG-rac 1.1T 958G 113G 90% /data tmpfs 6.3G 4.0K 6.3G 1% /run/user/0 ``` 网上说修改logind.conf文件,但问题依旧 ``` [root@wjdb ~]# cat /etc/systemd/logind.conf [Login] RemoveIPC=on ``` 登录oracle出现如下错误 ``` Last login: Wed Oct 24 18:30:35 CST 2018 on pts/0 [oracle@wjdb ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 24 18:54:06 2018 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> select * from dual; select * from dual * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 ``` 检查trace目录的日志文件,如下: ``` Starting background process CJQ0 Mon Oct 22 23:45:08 2018 CJQ0 started with pid=43, OS id=2409 Archived Log entry 2777 added for thread 1 sequence 2783 ID 0xa5f27e dest 1: Mon Oct 22 23:45:08 2018 db_recovery_file_dest_size of 409600 MB is 52.01% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Setting Resource Manager plan SCHEDULER[0x3003]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter Mon Oct 22 23:45:11 2018 Starting background process VKRM Mon Oct 22 23:45:11 2018 VKRM started with pid=41, OS id=2411 Mon Oct 22 23:53:18 2018 Starting background process SMCO Mon Oct 22 23:53:18 2018 SMCO started with pid=1030, OS id=12564 Tue Oct 23 02:00:00 2018 Clearing Resource Manager plan via parameter Tue Oct 23 08:00:17 2018 Thread 1 advanced to log sequence 2785 (LGWR switch) Current log# 4 seq# 2785 mem# 0: /data/oracle/oradata/wjdb/redo04.log Tue Oct 23 08:00:30 2018 Archived Log entry 2778 added for thread 1 sequence 2784 ID 0xa5f27e dest 1: Tue Oct 23 16:02:53 2018 Thread 1 advanced to log sequence 2786 (LGWR switch) Current log# 1 seq# 2786 mem# 0: /data/oracle/oradata/wjdb/redo01.log Tue Oct 23 16:03:06 2018 Archived Log entry 2779 added for thread 1 sequence 2785 ID 0xa5f27e dest 1: Tue Oct 23 19:07:01 2018 Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_j000_20537.trc: ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 Tue Oct 23 19:07:01 2018 Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_dbrm_2317.trc: ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 DBRM (ospid: 2317): terminating the instance due to error 27157 Tue Oct 23 19:07:01 2018 Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_j001_20539.trc: ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 Tue Oct 23 19:07:01 2018 Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_q000_2418.trc: ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 Instance terminated by DBRM, pid = 2317 Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_dbrm_2317.trc: ORA-27300: OS system dependent operation:semctl failed with status: 22 ORA-27301: OS failure message: Invalid argument ORA-27302: failure occurred at: sskgpwrm1 ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 Tue Oct 23 19:07:04 2018 Instance termination got error 27120 from SGA destruction. Error cleared. Process exiting. wjdb_j000_20537.trc内容如下 7f30aa2c8000-7f30aa2cb000 r-xp 00000000 fd:01 143235 /usr/lib64/libdl-2.17.so 7f30aa2cb000-7f30aa4ca000 ---p 00003000 fd:01 143235 /usr/lib64/libdl-2.17.so 7f30aa4ca000-7f30aa4cb000 r-xp 00002000 fd:01 143235 /usr/lib64/libdl-2.17.so 7f30aa4cb000-7f30aa4cc000 rwxp 00003000 fd:01 143235 /usr/lib64/libdl-2.17.so 7f30aa4cc000-7f30aa4cd000 r-xp 00000000 fd:01 136896 /usr/lib64/libaio.so.1.0.1 7f30aa4cd000-7f30aa6cc000 ---p 00001000 fd:01 136896 /usr/lib64/libaio.so.1.0.1 7f30aa6cc000-7f30aa6cd000 r-xp 00000000 fd:01 136896 /usr/lib64/libaio.so.1.0.1 7f30aa6cd000-7f30aa6ce000 rwxp 00001000 fd:01 136896 /usr/lib64/libaio.so.1.0.1 7f30aa6ce000-7f30aa73d000 r-xp 00000000 fc:01 37623267 /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so 7f30aa73d000-7f30aa83d000 ---p 0006f000 fc:01 37623267 /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so 7f30aa83d000-7f30aa84f000 rwxp 0006f000 fc:01 37623267 /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so 7f30aa84f000-7f30aa850000 rwxp 00000000 00:00 0 7f30aa850000-7f30aa85b000 r-xp 00000000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f30aa85b000-7f30aa95a000 ---p 0000b000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f30aa95a000-7f30aa95b000 rwxp 0000a000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f30aa95b000-7f30aa9f3000 r-xp 00000000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f30aa9f3000-7f30aaaf3000 ---p 00098000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f30aaaf3000-7f30aaaf5000 rwxp 00098000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f30aaaf5000-7f30aab8e000 r-xp 00000000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f30aab8e000-7f30aac8d000 ---p 00099000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f30aac8d000-7f30aac8f000 rwxp 00098000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f30aac8f000-7f30aac91000 r-xp 00000000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f30aac91000-7f30aad90000 ---p 00002000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f30aad90000-7f30aad91000 rwxp 00001000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f30aad91000-7f30ab1b9000 r-xp 00000000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f30ab1b9000-7f30ab2b9000 ---p 00428000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f30ab2b9000-7f30ab2cb000 rwxp 00428000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f30ab2cb000-7f30ab2cf000 rwxp 00000000 00:00 0 7f30ab2cf000-7f30ab2f1000 r-xp 00000000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f30ab2f1000-7f30ab3f0000 ---p 00022000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f30ab3f0000-7f30ab3f2000 rwxp 00021000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f30ab3f2000-7f30ab409000 r-xp 00000000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f30ab409000-7f30ab509000 ---p 00017000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f30ab509000-7f30ab50a000 rwxp 00017000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f30ab50a000-7f30ab78f000 r-xp 00000000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f30ab78f000-7f30ab88e000 ---p 00285000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f30ab88e000-7f30ab8d1000 rwxp 00284000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f30ab8d1000-7f30ab8d2000 rwxp 00000000 00:00 0 7f30ab8d2000-7f30ab8d9000 r-xp 00000000 fd:01 150366 /usr/lib64/librt-2.17.so 7f30ab8d9000-7f30abad8000 ---p 00007000 fd:01 150366 /usr/lib64/librt-2.17.so 7f30abad8000-7f30abad9000 r-xp 00006000 fd:01 150366 /usr/lib64/librt-2.17.so 7f30abad9000-7f30abada000 rwxp 00007000 fd:01 150366 /usr/lib64/librt-2.17.so 7f30abada000-7f30abb91000 r-xp 00000000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f30abb91000-7f30abc91000 ---p 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f30abc91000-7f30abc93000 rwxp 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f30abc93000-7f30abce2000 r-xp 00000000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f30abce2000-7f30abde1000 ---p 0004f000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f30abde1000-7f30abde9000 rwxp 0004e000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f30abde9000-7f30abe0a000 r-xp 00000000 fd:01 132827 /usr/lib64/ld-2.17.so 7f30abe10000-7f30abe45000 r-xs 00000000 fd:01 401548 /var/db/nscd/hosts 7f30abe45000-7f30abef7000 rwxp 00000000 00:00 0 7f30abf04000-7f30abf06000 rwxs 00000000 00:0a 44872319 /[aio] (deleted) 7f30abf06000-7f30abf07000 rwxp 00000000 00:00 0 7f30abf07000-7f30abf08000 r-xp 00000000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f30abf08000-7f30ac008000 ---p 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f30ac008000-7f30ac009000 rwxp 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f30ac009000-7f30ac00a000 rwxp 00000000 00:00 0 7f30ac00a000-7f30ac00b000 r-xp 00021000 fd:01 132827 /usr/lib64/ld-2.17.so 7f30ac00b000-7f30ac00c000 rwxp 00022000 fd:01 132827 /usr/lib64/ld-2.17.so 7f30ac00c000-7f30ac00d000 rwxp 00000000 00:00 0 7fffa52c6000-7fffa52fa000 rwxp 00000000 00:00 0 [stack] 7fffa53fe000-7fffa5400000 r-xp 00000000 00:00 0 [vdso] ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall] ******************* End of process map dump ************ Unexpected error 27157 in job slave process ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 wjdb_dbrm_2317.trc内容如下 7f2cbbad0000-7f2cbbad1000 rwxp 00007000 fd:01 150366 /usr/lib64/librt-2.17.so 7f2cbbad1000-7f2cbbb88000 r-xp 00000000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f2cbbb88000-7f2cbbc88000 ---p 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f2cbbc88000-7f2cbbc8a000 rwxp 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f2cbbc8a000-7f2cbbcd9000 r-xp 00000000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f2cbbcd9000-7f2cbbdd8000 ---p 0004f000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f2cbbdd8000-7f2cbbde0000 rwxp 0004e000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f2cbbde0000-7f2cbbe01000 r-xp 00000000 fd:01 132827 /usr/lib64/ld-2.17.so 7f2cbbe07000-7f2cbbe3c000 r-xs 00000000 fd:01 401548 /var/db/nscd/hosts 7f2cbbe3c000-7f2cbbeee000 rwxp 00000000 00:00 0 7f2cbbefa000-7f2cbbefb000 rwxs 00000000 fc:01 37492061 /data/oracle/product/11.2.0/db_1/dbs/hc_wjdb.dat 7f2cbbefb000-7f2cbbefd000 rwxs 00000000 00:0a 26080 /[aio] (deleted) 7f2cbbefd000-7f2cbbefe000 rwxp 00000000 00:00 0 7f2cbbefe000-7f2cbbeff000 r-xp 00000000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f2cbbeff000-7f2cbbfff000 ---p 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f2cbbfff000-7f2cbc000000 rwxp 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f2cbc000000-7f2cbc001000 rwxp 00000000 00:00 0 7f2cbc001000-7f2cbc002000 r-xp 00021000 fd:01 132827 /usr/lib64/ld-2.17.so 7f2cbc002000-7f2cbc003000 rwxp 00022000 fd:01 132827 /usr/lib64/ld-2.17.so 7f2cbc003000-7f2cbc004000 rwxp 00000000 00:00 0 7fff386d3000-7fff38705000 rwxp 00000000 00:00 0 [stack] 7fff387fe000-7fff38800000 r-xp 00000000 00:00 0 [vdso] ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall] ******************* End of process map dump ************ error 27157 detected in background process ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 *** 2018-10-23 19:07:01.746 DBRM (ospid: 2317): terminating the instance due to error 27157 *** 2018-10-23 19:07:04.048 ORA-27300: OS system dependent operation:semctl failed with status: 22 ORA-27301: OS failure message: Invalid argument ORA-27302: failure occurred at: sskgpwrm1 ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 skgm error 27120: errno = 22, info = 5, 229378, 0, 0, 229378, 0, 11 skgm error 27120: errno = 22, info = 5, 262147, 0, 0, 262147, 0, 11 skgm error 27120: errno = 22, info = 5, 294916, 0, 0, 294916, 0, 11 skgm error 27120: errno = 22, info = 5, 327685, 0, 0, 327685, 0, 11 skgm error 27120: errno = 22, info = 5, 360454, 0, 0, 360454, 0, 11 skgm error 27120: errno = 22, info = 5, 393223, 0, 0, 393223, 0, 11 skgm error 27120: errno = 22, info = 5, 425992, 0, 0, 425992, 0, 11 skgm error 27120: errno = 22, info = 5, 458761, 0, 0, 458761, 0, 11 skgm error 27120: errno = 22, info = 5, 491530, 0, 0, 491530, 0, 11 skgm error 27120: errno = 22, info = 5, 524299, 0, 0, 524299, 0, 11 skgm error 27120: errno = 22, info = 5, 557068, 0, 0, 557068, 0, 11 skgm error 27120: errno = 22, info = 5, 589837, 0, 0, 589837, 0, 11 skgm error 27120: errno = 22, info = 5, 622606, 0, 0, 622606, 0, 11 skgm error 27120: errno = 22, info = 5, 655375, 0, 0, 655375, 0, 11 skgm error 27120: errno = 22, info = 5, 688144, 0, 0, 688144, 0, 11 skgm error 27120: errno = 22, info = 5, 720913, 0, 0, 720913, 0, 11 skgm error 27120: errno = 22, info = 5, 753682, 0, 0, 753682, 0, 11 skgm error 27120: errno = 22, info = 5, 786451, 0, 0, 786451, 0, 11 skgm error 27120: errno = 22, info = 5, 819220, 0, 0, 819220, 0, 11 skgm error 27120: errno = 22, info = 5, 851989, 0, 0, 851989, 0, 11 skgm error 27120: errno = 22, info = 5, 884758, 0, 0, 884758, 0, 11 skgm error 27120: errno = 22, info = 5, 917527, 0, 0, 917527, 0, 11 skgm error 27120: errno = 22, info = 5, 950296, 0, 0, 950296, 0, 11 skgm error 27120: errno = 22, info = 5, 983065, 0, 0, 983065, 0, 11 skgm error 27120: errno = 22, info = 5, 1015834, 0, 0, 1015834, 0, 11 skgm error 27120: errno = 22, info = 5, 1048603, 0, 0, 1048603, 0, 11 skgm error 27120: errno = 22, info = 5, 1081372, 0, 0, 1081372, 0, 11 wjdb_j001_20539.trc内容如下 7f9d46ac3000-7f9d46b32000 r-xp 00000000 fc:01 37623267 /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so 7f9d46b32000-7f9d46c32000 ---p 0006f000 fc:01 37623267 /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so 7f9d46c32000-7f9d46c44000 rwxp 0006f000 fc:01 37623267 /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so 7f9d46c44000-7f9d46c45000 rwxp 00000000 00:00 0 7f9d46c45000-7f9d46c50000 r-xp 00000000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f9d46c50000-7f9d46d4f000 ---p 0000b000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f9d46d4f000-7f9d46d50000 rwxp 0000a000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f9d46d50000-7f9d46de8000 r-xp 00000000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f9d46de8000-7f9d46ee8000 ---p 00098000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f9d46ee8000-7f9d46eea000 rwxp 00098000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f9d46eea000-7f9d46f83000 r-xp 00000000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f9d46f83000-7f9d47082000 ---p 00099000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f9d47082000-7f9d47084000 rwxp 00098000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f9d47084000-7f9d47086000 r-xp 00000000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f9d47086000-7f9d47185000 ---p 00002000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f9d47185000-7f9d47186000 rwxp 00001000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f9d47186000-7f9d475ae000 r-xp 00000000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f9d475ae000-7f9d476ae000 ---p 00428000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f9d476ae000-7f9d476c0000 rwxp 00428000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f9d476c0000-7f9d476c4000 rwxp 00000000 00:00 0 7f9d476c4000-7f9d476e6000 r-xp 00000000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f9d476e6000-7f9d477e5000 ---p 00022000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f9d477e5000-7f9d477e7000 rwxp 00021000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f9d477e7000-7f9d477fe000 r-xp 00000000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f9d477fe000-7f9d478fe000 ---p 00017000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f9d478fe000-7f9d478ff000 rwxp 00017000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f9d478ff000-7f9d47b84000 r-xp 00000000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f9d47b84000-7f9d47c83000 ---p 00285000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f9d47c83000-7f9d47cc6000 rwxp 00284000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f9d47cc6000-7f9d47cc7000 rwxp 00000000 00:00 0 7f9d47cc7000-7f9d47cce000 r-xp 00000000 fd:01 150366 /usr/lib64/librt-2.17.so 7f9d47cce000-7f9d47ecd000 ---p 00007000 fd:01 150366 /usr/lib64/librt-2.17.so 7f9d47ecd000-7f9d47ece000 r-xp 00006000 fd:01 150366 /usr/lib64/librt-2.17.so 7f9d47ece000-7f9d47ecf000 rwxp 00007000 fd:01 150366 /usr/lib64/librt-2.17.so 7f9d47ecf000-7f9d47f86000 r-xp 00000000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f9d47f86000-7f9d48086000 ---p 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f9d48086000-7f9d48088000 rwxp 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f9d48088000-7f9d480d7000 r-xp 00000000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f9d480d7000-7f9d481d6000 ---p 0004f000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f9d481d6000-7f9d481de000 rwxp 0004e000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f9d481de000-7f9d481ff000 r-xp 00000000 fd:01 132827 /usr/lib64/ld-2.17.so 7f9d4823a000-7f9d482ec000 rwxp 00000000 00:00 0 7f9d482f9000-7f9d482fb000 rwxs 00000000 00:0a 44870643 /[aio] (deleted) 7f9d482fb000-7f9d482fc000 rwxp 00000000 00:00 0 7f9d482fc000-7f9d482fd000 r-xp 00000000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f9d482fd000-7f9d483fd000 ---p 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f9d483fd000-7f9d483fe000 rwxp 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f9d483fe000-7f9d483ff000 rwxp 00000000 00:00 0 7f9d483ff000-7f9d48400000 r-xp 00021000 fd:01 132827 /usr/lib64/ld-2.17.so 7f9d48400000-7f9d48401000 rwxp 00022000 fd:01 132827 /usr/lib64/ld-2.17.so 7f9d48401000-7f9d48402000 rwxp 00000000 00:00 0 7fff9ed9c000-7fff9edcf000 rwxp 00000000 00:00 0 [stack] 7fff9edfe000-7fff9ee00000 r-xp 00000000 00:00 0 [vdso] ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall] ******************* End of process map dump ************ Unexpected error 27157 in job slave process ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 wjdb_q000_2418.trc内容如下 7f71f86ef000-7f71f86f0000 rwxp 00000000 00:00 0 7f71f86f0000-7f71f86fb000 r-xp 00000000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f71f86fb000-7f71f87fa000 ---p 0000b000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f71f87fa000-7f71f87fb000 rwxp 0000a000 fc:01 37622977 /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so 7f71f87fb000-7f71f8893000 r-xp 00000000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f71f8893000-7f71f8993000 ---p 00098000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f71f8993000-7f71f8995000 rwxp 00098000 fc:01 37622976 /data/oracle/product/11.2.0/db_1/lib/libocrb11.so 7f71f8995000-7f71f8a2e000 r-xp 00000000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f71f8a2e000-7f71f8b2d000 ---p 00099000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f71f8b2d000-7f71f8b2f000 rwxp 00098000 fc:01 37622975 /data/oracle/product/11.2.0/db_1/lib/libocr11.so 7f71f8b2f000-7f71f8b31000 r-xp 00000000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f71f8b31000-7f71f8c30000 ---p 00002000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f71f8c30000-7f71f8c31000 rwxp 00001000 fc:01 37619552 /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so 7f71f8c31000-7f71f9059000 r-xp 00000000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f71f9059000-7f71f9159000 ---p 00428000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f71f9159000-7f71f916b000 rwxp 00428000 fc:01 37622972 /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so 7f71f916b000-7f71f916f000 rwxp 00000000 00:00 0 7f71f916f000-7f71f9191000 r-xp 00000000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f71f9191000-7f71f9290000 ---p 00022000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f71f9290000-7f71f9292000 rwxp 00021000 fc:01 37619532 /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so 7f71f9292000-7f71f92a9000 r-xp 00000000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f71f92a9000-7f71f93a9000 ---p 00017000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f71f93a9000-7f71f93aa000 rwxp 00017000 fc:01 37622974 /data/oracle/product/11.2.0/db_1/lib/libclsra11.so 7f71f93aa000-7f71f962f000 r-xp 00000000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f71f962f000-7f71f972e000 ---p 00285000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f71f972e000-7f71f9771000 rwxp 00284000 fc:01 37623084 /data/oracle/product/11.2.0/db_1/lib/libnnz11.so 7f71f9771000-7f71f9772000 rwxp 00000000 00:00 0 7f71f9772000-7f71f9779000 r-xp 00000000 fd:01 150366 /usr/lib64/librt-2.17.so 7f71f9779000-7f71f9978000 ---p 00007000 fd:01 150366 /usr/lib64/librt-2.17.so 7f71f9978000-7f71f9979000 r-xp 00006000 fd:01 150366 /usr/lib64/librt-2.17.so 7f71f9979000-7f71f997a000 rwxp 00007000 fd:01 150366 /usr/lib64/librt-2.17.so 7f71f997a000-7f71f9a31000 r-xp 00000000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f71f9a31000-7f71f9b31000 ---p 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f71f9b31000-7f71f9b33000 rwxp 000b7000 fc:01 37618703 /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so 7f71f9b33000-7f71f9b82000 r-xp 00000000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f71f9b82000-7f71f9c81000 ---p 0004f000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f71f9c81000-7f71f9c89000 rwxp 0004e000 fc:01 37623266 /data/oracle/product/11.2.0/db_1/lib/libcell11.so 7f71f9c89000-7f71f9caa000 r-xp 00000000 fd:01 132827 /usr/lib64/ld-2.17.so 7f71f9ce5000-7f71f9d97000 rwxp 00000000 00:00 0 7f71f9da4000-7f71f9da6000 rwxs 00000000 00:0a 28167 /[aio] (deleted) 7f71f9da6000-7f71f9da7000 rwxp 00000000 00:00 0 7f71f9da7000-7f71f9da8000 r-xp 00000000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f71f9da8000-7f71f9ea8000 ---p 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f71f9ea8000-7f71f9ea9000 rwxp 00001000 fc:01 37618636 /data/oracle/product/11.2.0/db_1/lib/libodmd11.so 7f71f9ea9000-7f71f9eaa000 rwxp 00000000 00:00 0 7f71f9eaa000-7f71f9eab000 r-xp 00021000 fd:01 132827 /usr/lib64/ld-2.17.so 7f71f9eab000-7f71f9eac000 rwxp 00022000 fd:01 132827 /usr/lib64/ld-2.17.so 7f71f9eac000-7f71f9ead000 rwxp 00000000 00:00 0 7fff92da9000-7fff92ddc000 rwxp 00000000 00:00 0 [stack] 7fff92dfe000-7fff92e00000 r-xp 00000000 00:00 0 [vdso] ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall] ******************* End of process map dump ************ KSV 27157 error in slave process *** 2018-10-23 19:07:01.765 ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 OPIRIP: Uncaught error 447. Error stack: ORA-00447: fatal error in background process ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 43 ORA-27301: OS failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 ```
Tomcat7启动时候,出现oracle的SID找不到的错误
在windows7上,作的linux虚拟机。virtual Box CentOS5.9 tomcat启动之后出错。数据库应该没有问题。本地连接没有问题。 想问一下,linux是不是需要装oracle的客户端? 还是需要什么设置? 或者是因为虚拟机的? 多谢!! 环境:virtual Box CentOS5.9 tomcat7 java7 错误信息: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor XML设定: Resource name="jdbc/webshopDataSource" auth="Container" type="javax.sql.DataSource" maxActive="20" maxIdle="10" maxWait="-1" username="name" password="pwd" driverClassName="oracle.jdbc.OracleDriver" factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" url="jdbc:oracle:thin:@192.168.222.29:1521:ORA11G" />
rman 全备份 恢复无效
最近再学习rman。 完全备份后 修改数据 再恢复,发现恢复无效。 环境:vm虚拟机 centos6.7 oracle12c 操作数据: 1.**启用archivelog模式: ** ``` [root@localhost ~]# su - oracle -bash-4.1$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 24 01:53:58 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /home/oracle/product/12.2.0/db_1/dbs/arch Oldest online log sequence 1 Next log sequence to archive 1 Current log sequence 1 SQL> ``` 2.进入rman ``` Last login: Wed Apr 24 01:53:04 2019 from 192.168.30.1 [root@localhost ~]# su - oracle -bash-4.1$ rman target / nocatalog Recovery Manager: Release 12.2.0.1.0 - Production on Wed Apr 24 01:57:30 2019 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: LESP (DBID=1750011068) using target database control file instead of recovery catalog RMAN> ``` 3.全备份 ``` RMAN> backup database; Starting backup at 24-APR-19 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=55 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=/home/oracle/oradata/lesp/system01.dbf input datafile file number=00003 name=/home/oracle/oradata/lesp/sysaux01.dbf input datafile file number=00004 name=/home/oracle/oradata/lesp/undotbs01.dbf input datafile file number=00005 name=/home/oracle/oradata/lesp/ts_data_lesp_etl_001.dbf input datafile file number=00007 name=/home/oracle/oradata/lesp/users01.dbf channel ORA_DISK_1: starting piece 1 at 24-APR-19 channel ORA_DISK_1: finished piece 1 at 24-APR-19 piece handle=/home/oracle/product/12.2.0/db_1/dbs/34tvomv8_1_1 tag=TAG20190424T015904 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45 Finished backup at 24-APR-19 Starting Control File and SPFILE Autobackup at 24-APR-19 piece handle=/home/oracle/product/12.2.0/db_1/dbs/c-1750011068-20190424-0a comment=NONE Finished Control File and SPFILE Autobackup at 24-APR-19 ``` 4.查看备份信息 ``` RMAN> list backupset ; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 106 Full 1.07G DISK 00:00:43 24-APR-19 BP Key: 106 Status: AVAILABLE Compressed: NO Tag: TAG20190424T015904 Piece Name: /home/oracle/product/12.2.0/db_1/dbs/34tvomv8_1_1 List of Datafiles in backup set 106 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- 1 Full 2016498 24-APR-19 NO /home/oracle/oradata/lesp/system01.dbf 3 Full 2016498 24-APR-19 NO /home/oracle/oradata/lesp/sysaux01.dbf 4 Full 2016498 24-APR-19 NO /home/oracle/oradata/lesp/undotbs01.dbf 5 Full 2016498 24-APR-19 NO /home/oracle/oradata/lesp/ts_data_lesp_etl_001.dbf 7 Full 2016498 24-APR-19 NO /home/oracle/oradata/lesp/users01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 107 Full 10.66M DISK 00:00:00 24-APR-19 BP Key: 107 Status: AVAILABLE Compressed: NO Tag: TAG20190424T015950 Piece Name: /home/oracle/product/12.2.0/db_1/dbs/c-1750011068-20190424-0a SPFILE Included: Modification time: 24-APR-19 SPFILE db_unique_name: LESP Control File Included: Ckp SCN: 2016523 Ckp time: 24-APR-19 ``` 6.修改数据库数据: 之前: ``` SQL> select count(1) from tabs; COUNT(1) ---------- 0 ``` 创建一个表: ``` SQL> select count(1) from tabs; COUNT(1) ---------- 1 ``` 7.恢复: 1.nomount ``` RMAN> shutdown abort; Oracle instance shut down RMAN> startup nomount; connected to target database (not started) Oracle instance started Total System Global Area 784334848 bytes Fixed Size 8625608 bytes Variable Size 658506296 bytes Database Buffers 113246208 bytes Redo Buffers 3956736 bytes ``` 7.2.restore controlfile ``` RMAN> restore controlfile from '/home/oracle/product/12.2.0/db_1/dbs/c-1750011068-20190424-0a' 2> ; Starting restore at 24-APR-19 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=37 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/home/oracle/oradata/lesp/control01.ctl output file name=/home/oracle/oradata/lesp/control02.ctl Finished restore at 24-APR-19 ``` 7.3 mount /restore/ recover ``` RMAN> alter database mount; Statement processed released channel: ORA_DISK_1 RMAN> restore database; Starting restore at 24-APR-19 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=37 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /home/oracle/oradata/lesp/system01.dbf channel ORA_DISK_1: restoring datafile 00003 to /home/oracle/oradata/lesp/sysaux01.dbf channel ORA_DISK_1: restoring datafile 00004 to /home/oracle/oradata/lesp/undotbs01.dbf channel ORA_DISK_1: restoring datafile 00005 to /home/oracle/oradata/lesp/ts_data_lesp_etl_001.dbf channel ORA_DISK_1: restoring datafile 00007 to /home/oracle/oradata/lesp/users01.dbf channel ORA_DISK_1: reading from backup piece /home/oracle/product/12.2.0/db_1/dbs/34tvomv8_1_1 channel ORA_DISK_1: piece handle=/home/oracle/product/12.2.0/db_1/dbs/34tvomv8_1_1 tag=TAG20190424T015904 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:36 Finished restore at 24-APR-19 RMAN> recover database; Starting recover at 24-APR-19 using channel ORA_DISK_1 starting media recovery archived log for thread 1 with sequence 1 is already on disk as file /home/oracle/oradata/lesp/redo01.log archived log file name=/home/oracle/oradata/lesp/redo01.log thread=1 sequence=1 media recovery complete, elapsed time: 00:00:01 Finished recover at 24-APR-19 RMAN> alter database open resetlogs; Statement processed RMAN> ``` 8.查看效果; ``` SQL> select count(1) from tabs; COUNT(1) ---------- 1 ``` 没有恢复 还是备份之后的数据
终于明白阿里百度这样的大公司,为什么面试经常拿ThreadLocal考验求职者了
点击上面↑「爱开发」关注我们每晚10点,捕获技术思考和创业资源洞察什么是ThreadLocalThreadLocal是一个本地线程副本变量工具类,各个线程都拥有一份线程私...
《奇巧淫技》系列-python!!每天早上八点自动发送天气预报邮件到QQ邮箱
将代码部署服务器,每日早上定时获取到天气数据,并发送到邮箱。 也可以说是一个小人工智障。 思路可以运用在不同地方,主要介绍的是思路。
加快推动区块链技术和产业创新发展,2019可信区块链峰会在京召开
11月8日,由中国信息通信研究院、中国通信标准化协会、中国互联网协会、可信区块链推进计划联合主办,科技行者协办的2019可信区块链峰会将在北京悠唐皇冠假日酒店开幕。   区块链技术被认为是继蒸汽机、电力、互联网之后,下一代颠覆性的核心技术。如果说蒸汽机释放了人类的生产力,电力解决了人类基本的生活需求,互联网彻底改变了信息传递的方式,区块链作为构造信任的技术有重要的价值。   1...
阿里面试官问我:如何设计秒杀系统?我的回答让他比起大拇指
你知道的越多,你不知道的越多 点赞再看,养成习惯 GitHub上已经开源 https://github.com/JavaFamily 有一线大厂面试点脑图和个人联系方式,欢迎Star和指教 前言 Redis在互联网技术存储方面使用如此广泛,几乎所有的后端技术面试官都要在Redis的使用和原理方面对小伙伴们进行360°的刁难。 作为一个在互联网公司面一次拿一次Offer的面霸,打败了...
C语言魔塔游戏
很早就很想写这个,今天终于写完了。 游戏截图: 编译环境: VS2017 游戏需要一些图片,如果有想要的或者对游戏有什么看法的可以加我的QQ 2985486630 讨论,如果暂时没有回应,可以在博客下方留言,到时候我会看到。 下面我来介绍一下游戏的主要功能和实现方式 首先是玩家的定义,使用结构体,这个名字是可以自己改变的 struct gamerole { char n...
面试官问我:什么是消息队列?什么场景需要他?用了会出现什么问题?
你知道的越多,你不知道的越多 点赞再看,养成习惯 GitHub上已经开源 https://github.com/JavaFamily 有一线大厂面试点脑图、个人联系方式和人才交流群,欢迎Star和完善 前言 消息队列在互联网技术存储方面使用如此广泛,几乎所有的后端技术面试官都要在消息队列的使用和原理方面对小伙伴们进行360°的刁难。 作为一个在互联网公司面一次拿一次Offer的面霸...
Android性能优化(4):UI渲染机制以及优化
文章目录1. 渲染机制分析1.1 渲染机制1.2 卡顿现象1.3 内存抖动2. 渲染优化方式2.1 过度绘制优化2.1.1 Show GPU overdraw2.1.2 Profile GPU Rendering2.2 卡顿优化2.2.1 SysTrace2.2.2 TraceView 在从Android 6.0源码的角度剖析View的绘制原理一文中,我们了解到View的绘制流程有三个步骤,即m...
微服务中的Kafka与Micronaut
今天,我们将通过Apache Kafka主题构建一些彼此异步通信的微服务。我们使用Micronaut框架,它为与Kafka集成提供专门的库。让我们简要介绍一下示例系统的体系结构。我们有四个微型服务:订单服务,行程服务,司机服务和乘客服务。这些应用程序的实现非常简单。它们都有内存存储,并连接到同一个Kafka实例。 我们系统的主要目标是为客户安排行程。订单服务应用程序还充当网关。它接收来自客户的请求...
致 Python 初学者们!
作者| 许向武 责编 | 屠敏 出品 | CSDN 博客 前言 在 Python 进阶的过程中,相信很多同学应该大致上学习了很多 Python 的基础知识,也正在努力成长。在此期间,一定遇到了很多的困惑,对未来的学习方向感到迷茫。我非常理解你们所面临的处境。我从2007年开始接触 Python 这门编程语言,从2009年开始单一使用 Python 应对所有的开发工作,直至今...
究竟你适不适合买Mac?
我清晰的记得,刚买的macbook pro回到家,开机后第一件事情,就是上了淘宝网,花了500元钱,找了一个上门维修电脑的师傅,上门给我装了一个windows系统。。。。。。 表砍我。。。 当时买mac的初衷,只是想要个固态硬盘的笔记本,用来运行一些复杂的扑克软件。而看了当时所有的SSD笔记本后,最终决定,还是买个好(xiong)看(da)的。 已经有好几个朋友问我mba怎么样了,所以今天尽量客观...
程序员一般通过什么途径接私活?
二哥,你好,我想知道一般程序猿都如何接私活,我也想接,能告诉我一些方法吗? 上面是一个读者“烦不烦”问我的一个问题。其实不止是“烦不烦”,还有很多读者问过我类似这样的问题。 我接的私活不算多,挣到的钱也没有多少,加起来不到 20W。说实话,这个数目说出来我是有点心虚的,毕竟太少了,大家轻喷。但我想,恰好配得上“一般程序员”这个称号啊。毕竟苍蝇再小也是肉,我也算是有经验的人了。 唾弃接私活、做外...
字节跳动面试官这样问消息队列:分布式事务、重复消费、顺序消费,我整理了一下
你知道的越多,你不知道的越多 点赞再看,养成习惯 GitHub上已经开源 https://github.com/JavaFamily 有一线大厂面试点脑图、个人联系方式和人才交流群,欢迎Star和完善 前言 消息队列在互联网技术存储方面使用如此广泛,几乎所有的后端技术面试官都要在消息队列的使用和原理方面对小伙伴们进行360°的刁难。 作为一个在互联网公司面一次拿一次Offer的面霸...
Python爬虫爬取淘宝,京东商品信息
小编是一个理科生,不善长说一些废话。简单介绍下原理然后直接上代码。 使用的工具(Python+pycharm2019.3+selenium+xpath+chromedriver)其中要使用pycharm也可以私聊我selenium是一个框架可以通过pip下载 pip installselenium -ihttps://pypi.tuna.tsinghua.edu.cn/simple/ ...
阿里程序员写了一个新手都写不出的低级bug,被骂惨了。
这种新手都不会范的错,居然被一个工作好几年的小伙子写出来,差点被当场开除了。
Java工作4年来应聘要16K最后没要,细节如下。。。
前奏: 今天2B哥和大家分享一位前几天面试的一位应聘者,工作4年26岁,统招本科。 以下就是他的简历和面试情况。 基本情况: 专业技能: 1、 熟悉Sping了解SpringMVC、SpringBoot、Mybatis等框架、了解SpringCloud微服务 2、 熟悉常用项目管理工具:SVN、GIT、MAVEN、Jenkins 3、 熟悉Nginx、tomca...
SpringBoot2.x系列教程(三十六)SpringBoot之Tomcat配置
Spring Boot默认内嵌的Tomcat为Servlet容器,关于Tomcat的所有属性都在ServerProperties配置类中。同时,也可以实现一些接口来自定义内嵌Servlet容器和内嵌Tomcat等的配置。 关于此配置,网络上有大量的资料,但都是基于SpringBoot1.5.x版本,并不适合当前最新版本。本文将带大家了解一下最新版本的使用。 ServerProperties的部分源...
Python绘图,圣诞树,花,爱心 | Turtle篇
每周每日,分享Python实战代码,入门资料,进阶资料,基础语法,爬虫,数据分析,web网站,机器学习,深度学习等等。 公众号回复【进群】沟通交流吧,QQ扫码进群学习吧 微信群 QQ群 1.画圣诞树 import turtle screen = turtle.Screen() screen.setup(800,600) circle = turtle.Turtle()...
作为一个程序员,CPU的这些硬核知识你必须会!
CPU对每个程序员来说,是个既熟悉又陌生的东西? 如果你只知道CPU是中央处理器的话,那可能对你并没有什么用,那么作为程序员的我们,必须要搞懂的就是CPU这家伙是如何运行的,尤其要搞懂它里面的寄存器是怎么一回事,因为这将让你从底层明白程序的运行机制。 随我一起,来好好认识下CPU这货吧 把CPU掰开来看 对于CPU来说,我们首先就要搞明白它是怎么回事,也就是它的内部构造,当然,CPU那么牛的一个东...
破14亿,Python分析我国存在哪些人口危机!
一、背景 二、爬取数据 三、数据分析 1、总人口 2、男女人口比例 3、人口城镇化 4、人口增长率 5、人口老化(抚养比) 6、各省人口 7、世界人口 四、遇到的问题 遇到的问题 1、数据分页,需要获取从1949-2018年数据,观察到有近20年参数:LAST20,由此推测获取近70年的参数可设置为:LAST70 2、2019年数据没有放上去,可以手动添加上去 3、将数据进行 行列转换 4、列名...
听说想当黑客的都玩过这个Monyer游戏(1~14攻略)
第零关 进入传送门开始第0关(游戏链接) 请点击链接进入第1关: 连接在左边→ ←连接在右边 看不到啊。。。。(只能看到一堆大佬做完的留名,也能看到菜鸡的我,在后面~~) 直接fn+f12吧 <span>连接在左边→</span> <a href="first.php"></a> <span>←连接在右边</span> o...
在家远程办公效率低?那你一定要收好这个「在家办公」神器!
相信大家都已经收到国务院延长春节假期的消息,接下来,在家远程办公可能将会持续一段时间。 但是问题来了。远程办公不是人在电脑前就当坐班了,相反,对于沟通效率,文件协作,以及信息安全都有着极高的要求。有着非常多的挑战,比如: 1在异地互相不见面的会议上,如何提高沟通效率? 2文件之间的来往反馈如何做到及时性?如何保证信息安全? 3如何规划安排每天工作,以及如何进行成果验收? ...... ...
作为一个程序员,内存和磁盘的这些事情,你不得不知道啊!!!
截止目前,我已经分享了如下几篇文章: 一个程序在计算机中是如何运行的?超级干货!!! 作为一个程序员,CPU的这些硬核知识你必须会! 作为一个程序员,内存的这些硬核知识你必须懂! 这些知识可以说是我们之前都不太重视的基础知识,可能大家在上大学的时候都学习过了,但是嘞,当时由于老师讲解的没那么有趣,又加上这些知识本身就比较枯燥,所以嘞,大家当初几乎等于没学。 再说啦,学习这些,也看不出来有什么用啊!...
这个世界上人真的分三六九等,你信吗?
偶然间,在知乎上看到一个问题 一时间,勾起了我深深的回忆。 以前在厂里打过两次工,做过家教,干过辅导班,做过中介。零下几度的晚上,贴过广告,满脸、满手地长冻疮。 再回首那段岁月,虽然苦,但让我学会了坚持和忍耐。让我明白了,在这个世界上,无论环境多么的恶劣,只要心存希望,星星之火,亦可燎原。 下文是原回答,希望能对你能有所启发。 如果我说,这个世界上人真的分三六九等,...
2020年全新Java学习路线图,含配套视频,学完即为中级Java程序员!!
新的一年来临,突如其来的疫情打破了平静的生活! 在家的你是否很无聊,如果无聊就来学习吧! 世上只有一种投资只赚不赔,那就是学习!!! 传智播客于2020年升级了Java学习线路图,硬核升级,免费放送! 学完你就是中级程序员,能更快一步找到工作! 一、Java基础 JavaSE基础是Java中级程序员的起点,是帮助你从小白到懂得编程的必经之路。 在Java基础板块中有6个子模块的学...
B 站上有哪些很好的学习资源?
哇说起B站,在小九眼里就是宝藏般的存在,放年假宅在家时一天刷6、7个小时不在话下,更别提今年的跨年晚会,我简直是跪着看完的!! 最早大家聚在在B站是为了追番,再后来我在上面刷欧美新歌和漂亮小姐姐的舞蹈视频,最近两年我和周围的朋友们已经把B站当作学习教室了,而且学习成本还免费,真是个励志的好平台ヽ(.◕ฺˇд ˇ◕ฺ;)ノ 下面我们就来盘点一下B站上优质的学习资源: 综合类 Oeasy: 综合...
爬取薅羊毛网站百度云资源
这是疫情期间无聊做的爬虫, 去获取暂时用不上的教程 import threading import time import pandas as pd import requests import re from threading import Thread, Lock # import urllib.request as request # req=urllib.request.Requ...
如何优雅地打印一个Java对象?
你好呀,我是沉默王二,一个和黄家驹一样身高,和刘德华一样颜值的程序员。虽然已经写了十多年的 Java 代码,但仍然觉得自己是个菜鸟(请允许我惭愧一下)。 在一个月黑风高的夜晚,我思前想后,觉得再也不能这么蹉跎下去了。于是痛下决心,准备通过输出的方式倒逼输入,以此来修炼自己的内功,从而进阶成为一名真正意义上的大神。与此同时,希望这些文章能够帮助到更多的读者,让大家在学习的路上不再寂寞、空虚和冷。 ...
雷火神山直播超两亿,Web播放器事件监听是怎么实现的?
Web播放器解决了在手机浏览器和PC浏览器上播放音视频数据的问题,让视音频内容可以不依赖用户安装App,就能进行播放以及在社交平台进行传播。在视频业务大数据平台中,播放数据的统计分析非常重要,所以Web播放器在使用过程中,需要对其内部的数据进行收集并上报至服务端,此时,就需要对发生在其内部的一些播放行为进行事件监听。 那么Web播放器事件监听是怎么实现的呢? 01 监听事件明细表 名...
3万字总结,Mysql优化之精髓
本文知识点较多,篇幅较长,请耐心学习 MySQL已经成为时下关系型数据库产品的中坚力量,备受互联网大厂的青睐,出门面试想进BAT,想拿高工资,不会点MySQL优化知识,拿offer的成功率会大大下降。 为什么要优化 系统的吞吐量瓶颈往往出现在数据库的访问速度上 随着应用程序的运行,数据库的中的数据会越来越多,处理时间会相应变慢 数据是存放在磁盘上的,读写速度无法和内存相比 如何优化 设计...
HTML5适合的情人节礼物有纪念日期功能
前言 利用HTML5,css,js实现爱心树 以及 纪念日期的功能 网页有播放音乐功能 以及打字倾诉感情的画面,非常适合情人节送给女朋友 具体的HTML代码 具体只要修改代码里面的男某某和女某某 文字段也可自行修改,还有代码下半部分的JS代码需要修改一下起始日期 注意月份为0~11月 也就是月份需要减一。 当然只有一部分HTML和JS代码不够运行的,文章最下面还附加了完整代码的下载地址 <!...
Python新型冠状病毒疫情数据自动爬取+统计+发送报告+数据屏幕(三)发送篇
今天介绍的项目是使用 Itchat 发送统计报告 项目功能设计: 定时爬取疫情数据存入Mysql 进行数据分析制作疫情报告 使用itchat给亲人朋友发送分析报告 基于Django做数据屏幕 使用Tableau做数据分析 来看看最终效果 目前已经完成,预计2月12日前更新 使用 itchat 发送数据统计报告 itchat 是一个基于 web微信的一个框架,但微信官方并不允许使用这...
python沙箱逃逸
沙箱逃逸是CTF和实际场景中经常遇到的一种情况。需要利用python的特性来实现逃逸。本文详细介绍了关于python逃逸的基础以及一些构造payload方法,并且附加习题提供练习。
作为程序员的我,大学四年一直自学,全靠这些实用工具和学习网站!
我本人因为高中沉迷于爱情,导致学业荒废,后来高考,毫无疑问进入了一所普普通通的大学,实在惭愧???? 我又是那么好强,现在学历不行,没办法改变的事情了,所以,进入大学开始,我就下定决心,一定要让自己掌握更多的技能,尤其选择了计算机这个行业,一定要多学习技术。 在进入大学学习不久后,我就认清了一个现实:我这个大学的整体教学质量和学习风气,真的一言难尽,懂的人自然知道怎么回事? 怎么办?我该如何更好的提升自...
相关热词 c#如何定义数组列表 c#倒序读取txt文件 java代码生成c# c# tcp发送数据 c#解决时间格式带星期 c#类似hashmap c#设置istbox的值 c#获取多线程返回值 c# 包含数字 枚举 c# timespan
立即提问