随笔分类 -  oracle

linux 本地 yum 使用
摘要:1 创建 iso 文件目录mkdir /redhatiso将redhat iso文件解压后 将所有解压目录 FTP 上传到 /redhatiso 里2 安装createrepo检查 是否有相关安装包 # rpm -qa |grep createrepo如果没有 rpm -ivh /media/cdrom/Server/createrepo*进行安装3 .创建yum repository的xml-rpm-metadata# createrepo -g /redhatiso/Server/repodata/comps-rhel5-server-core.xml /redhatiso/Server/ 阅读全文

posted @ 2013-01-04 10:02 Eutopia 阅读(280) 评论(0) 推荐(0)

ORACLE 下新建 SCHEMA
摘要:CREATE TABLESPACE EDI NOLOGGING DATAFILE '/oracle/oradata/wmtst/data/edi01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 200m maxsize 4096m EXTENT MANAGEMENT LOCAL ONLINE SEGMENT SPACE MANAGEMENT AUTO;create user wmedi IDENTIFIED BY wmedidefault tablespace EDIquota unlimited on EDI;GRANT CONNECT,RESOUR 阅读全文

posted @ 2012-07-01 12:29 Eutopia 阅读(409) 评论(0) 推荐(0)

ORACLE 下如何 查看用户session 及 kill
摘要:SQL> drop user sysman cascade;drop user sysman cascade*ERROR at line 1:ORA-01940: cannot drop a user that is currently connectedSQL> select sid,serial# from v$session where username='SYSMAN'; SID SERIAL#---------- ---------- 2558 522 2564 29 2576 1023SQL> alter system kill session & 阅读全文

posted @ 2012-06-19 11:48 Eutopia 阅读(1474) 评论(0) 推荐(0)

oracle 11g 安装报错
摘要:今天在 AIX 7.1 安装 11gr2 安装报错 如下retry 后 还是可以用具体似乎 是一个 bugSolutionPlease work with IBM to get a fix for your OS Version, as you look to be running into AIX O.S. issue, you need to provide your current O.S. level to IBM to get the appropriate fix. Following are the iFixes need to be appliedhttps://www-304 阅读全文

posted @ 2012-06-12 19:50 Eutopia 阅读(157) 评论(0) 推荐(0)

Too many processes already exist
摘要:昨天 一个测试系统碰到这个的情况现象:不能登录数据库,并且oracle帐号执行命令很慢,其他帐号正常。登录Oracle用户时提示错误:/etc/profile[50]: 0403-030 The fork function failed. Too many processes already exist。 系统检查: 1.> ps -ef |grep oracle |wc -l 2049 [有很多 oracle 44921036 1 0 0:00 <defunct>进程,不知道啥东西] 2.> lsattr -El sys0 |grep maxuproc maxupro 阅读全文

posted @ 2012-06-08 19:31 Eutopia 阅读(614) 评论(0) 推荐(0)