h2内存数据库

摘要： Initialization Parameter files: PFILEs vs. SPFILEsSubmitted by admin on Sun, 2003-08-03 19:29 RDBMS ServerWhen an Oracle Instance is started, the characteristics of the Instance are established by parameters specified within the initialization parameter file. These initialization parameters are eith 阅读全文

摘要： 如何查看数据库的parameter方法1-show parameterSQL>show parameter NAME TYPE VALUE ————————— ———– —————————— background_core_dump string partial background_dump_dest string D:\ORACLE\PRODUCT\10.2.0\ADMIN \ORCL\BDUMP backup_tape_io_slaves boolean FA... 阅读全文

摘要： Symptom访问Help->Diagnostics->Examine报"Function not available to this responsibility.Change responsibilities or contact your System Administrator."的错误提示CauseUpgraded to 12.1.3- or -Applied Patch 9734709Solution - Log in as System Administrator- Choose Profile/System- Change the profile 阅读全文

摘要： 数据库启动监听addlnctl.sh start instance启动数据库addbctl.sh start启动应用服务器adstrtal.sh停止应用服务器adstpall.sh查看HTTP/OC4J Statusadopmnctl.sh statussample output:Processes in Instance: mc3yd213_bej301441.bej301441.cn.oracle.com---------------------------------+--------------------+---------+---------ias-component | proc 阅读全文

摘要： EBS adpatch的时候报ORA-03113: end-of-file on communication channel从adpatch的日志中看到================adpatch.log====================================== Running utl_recomp.recomp_parallel(4), if it exists OWNER NUM_INVALID ------------------------------ ----------- SERVICES 24 PROJMFG 24 PSBE... 阅读全文

摘要： 对于EBS数据库管理员用户，可以把db/tech_st/10.2.0下的<CONTEXT_NAME>.env设置到/home/user下的.bash_profile文件（隐藏文件）中，这样和DB相关的一些环境变量就会自动在登录时加载（比如ORACLE_HOME，ORACLE_SID，PATH，TNS_ADMIN，CONTEXT_NAME，LIBPATH等）eg.把/u01/oracle/mc3yd213/db/tech_st/11.1.0/mc3yd213_bej301441.env加到.bash_profile对于EBS Application管理员用户，可以把apps/apps 阅读全文

摘要： ===For Applmgr User===APPL_TOP: 11i:<APPS_BASE>/<SID>applR12:<APPS_BASE>/apps/apps_st/applNOTE:Oracle Applicaitons product files,including $INV_TOP,$AU_TOP....COMMON_TOP:11i:<APPS_BASE>/<SID>comnR12:<APPS_BASE>/apps/apps_st/comn(Common files such as Java&HTML) 阅读全文

摘要： Oracle uses three files (listener.ora, tnsnames.ora & sqlnet.ora) for network configuration.Oracle Net is configured by configuration files. These include (but are not limited to):TNSNAMES.ORA - This file contains a list of service names, which translate into the instances the client can connect 阅读全文

摘要： 5月28号 晚上8点：文件格式如下：123abc456456def123567abc789789def567要求输出：456ABC123123DEF456789ABC567567DEF789初看上去知道这里需要用到大小写字母转化，还有数字位置转换等：[root@fsailing1 shell]# sed 'y/abcdef/ABCDEF/' chen1.txt 123ABC456 456DEF123 567ABC789 789DEF567 [root@fsailing1 shell]# sed -r 's/([1-9]{3})([a-f]{3})([1-9]{3})/\ 阅读全文

摘要： 在二十一节中，提到过调用ngx_eventfind_timer()获取timer，然后传递给epoll模块，做等待时间，今天我们主要讲解下这个方法。本文来自于：http://blog.csdn.net/lengzijiannginx中的timer用红黑树的结构排序。ngx_event_timer_rbtree就是nginx中timer的红黑树。1.下面我们来看一下ngx_event_timer_rbtree的结构：src/core/ngx_rbtree.h typedef struct ngx_rbtree_s ngx_rbtree_t; typedef void (*ngx_rbtre... 阅读全文