Oracle常见错误

一 、 Oracle不可能动态注册

      在SQL*PLUS下往往输入alter system
register.监听器的情事一贯突显为The listener supports no services。

      可查看listener.ora里面包车型客车IP或主机名是不是与/etc/hosts里面包车型大巴相呼应。

2、 ORA-00845: MEMORY_TARGET not
supported on this system

Oracle,      Oracle解释如下:

[oracle@node3 ~]$ oerr ora 845
00845, 00000, "MEMORY_TARGET not supported on this system"
// *Cause: The MEMORY_TARGET parameter was not supported on this operating system or /dev/shm was not sized correctly on Linux.
// *Action: Refer to documentation for a list of supported operating systems. Or, size /dev/shm to be at least the SGA_MAX_SIZE on each Oracle instance running on the system.

     其实,在运营进度中,告警日志会报以下错误:

WARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted for at least 369098752 bytes. /dev/shm is either not mounted or is mounted with available space less than this size. Please fix this so that MEMORY_TARGET can work as expected. Current available is 261324800 and used is 0 bytes. Ensure that the mount point is /dev/shm for this directory.
memory_target needs larger /dev/shm

   
 原因:AMM是11g引入的新本性,它会使用到Linux系统中的/dev/shm,/dev/shm必须当先或等于memory_target。

     解决措施:

     1> 马上生效–注意:/dev/shm的size值必须为整数,暗中认可是内部存款和储蓄器的二分一

[root@node3 oracle]# umount tmpfs
[root@node3 oracle]# mount -t tmpfs shmfs -o size=400m /dev/shm

     2> 修改/etc/fstab    

tmpfs                   /dev/shm                tmpfs   defaults,size=400m      0 0

     也足以先修改/etc/fstab,然后用 mount -o remount
/dev/shm重新挂载/dev/shm

   
 在福特ExplorerHEL6以上是系统的3个bug,就算在/etc/fstab中期维修改了/dev/shm的值,重启后依然恢复生机到内部存储器的八分之四。

   
 https://bugzilla.redhat.com/show_bug.cgi?id=669700,关于网上说的改动/etc/rc.d/rc.sysinit文件,经测试,依然鞭长莫及消除难点,反而会导致其余的盘没有挂载。

     最后,只能将 mount -o remount /dev/shm编辑到/etc/rc.local文件中

3. ORA-29701: unable to connect to
Cluster Synchronization Service

    手动运行CSS:crsctl start res ora.cssd

4. ORA-12641: Authentication service
failed to initialize

   
看一下$ORACLE_HOME/network/admin/sqlnet.ora文件中SQLNET.AUTHENTICATION_SELX570VICES的参数是不是为all了。

 

 

      

相关文章