**********************单机下dbca创建多个库遇到的问题**************************
1、启动监听失败TNS-12555,TNS-12560,TNS-00525 (统一环境创建多个数据库可遇见)
ls -l /var/tmp/.oracle; ls -l /tmp/.oracle查看用户和用户组需要是oracle,dba,若不是则执行chown -R oracle:dba ***进行修改,再次lsnrctl start即可。(注,启动监听需先su - oracle用户再执行)
2、startup遇到ORA-00845: MEMORY_TARGET not supported on this system
df -h查看/dev/shm挂载点容量,重新分配mount -o remount,size=3G /dev/shm/
3、dbca创建第二个数据库后,监听启动成功,但是日志报错TNS-12542: TNS:address already in use,且其中一个实例无法启动会报后台进程无法启动。(tns.ora在dbca创建新库时已自动修改,只需修改listener.ora即可)
需要修改listener.ora,增加以下配置,再重启监听即可。(以下案例增加了ZhangchenDb库)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /data/oracle/product/11.2.0)
(SID_NAME = orcl)
)
(SID_DESC =
(GLOBAL_DBNAME = ZhangchenDb)
(ORACLE_HOME = /data/oracle/product/11.2.0)
(SID_NAME = ZhangchenDb)
)
)
4、oracle后台的ora_*进程异常结束,导致报错‘ORA-27102: out of memory Linux-x86_64 Error: 12: Cannot allocate memory’
杀死后台所有ora进程, for p in `ps -ef| grep ora| awk '{print $2}'`;do kill -9 $p;done,再重启监听,重启数据库。