Eutopia 的SAP BASIS世界

摘要：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 & 阅读全文

摘要：今天在 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 阅读全文

摘要：smitty vgMove cursor to desired item and press Enter. Add an Original Volume Group Add a Big Volume Group Add a Scalable Volume Group Type or select values in entry fields.Press Enter AFTER making all desired changes. [Entry Fields] VOLUME GROUP name [wmsvg] Physical partition SIZE in megabytes 5... 阅读全文

摘要：一个节点至少应有两块网卡连接每个网络：一块服务网卡（service adapter）和一块备份网卡（standby adapter）。如果配置IP地址接管，还应配置启动网卡（boot adapter）。启动网卡并不需要单独的物理网卡，而是配置在服务网卡上的不同的IP地址。hosts文件下分别有以下几个地址100.100.180.100 boot_db 100.100.170.100 stby_db100.100.190.200sapprd01100.100.190.202 priv_db 阅读全文

摘要：昨天 一个测试系统碰到这个的情况现象：不能登录数据库，并且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 阅读全文

摘要：原系统1准备备份备份脚本source /oracle/EP1/.cshrcrman nocatalog target / cmdfile=/oracle/EP1/backup_scripts/backup_database_by-mgy.scr log=/backup/backup_database_by-mgy.logrun{allocate channel c1 type disk;allocate channel c2 type disk;BACKUP FORMAT '/oracle/EP1/sapdata9/EP1_full_%U_%T' skip inaccessib 阅读全文