Errors/Workarounds11g – SyedSaadAli

June 19, 2017 ORA-12645 Parameter does not exist, Oracle error code

Errors/Workarounds10gErrors/Workarounds11gOracle Database Material

ERROR

Translation of the error message from Oracle’s support site:
ORA-12645: Parameter does not exist.

Cause: A sqlnet.ora parameter from which a value was needed does not exist.
Action: Set the parameter in the parameter file.

(more…)

May 23, 2017 ORA-00845: MEMORY_TARGET not supported on this system

Errors/Workarounds11gOracle Database Material

ERROR

SQL> startup nomount;

ORA-00845: MEMORY_TARGET not supported on this system

SOLUTION

[oracle@oel6 ~]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_oel6-lv_root
                       43G   15G   26G  37% /
tmpfs                1001M  212M  789M  22% /dev/shm
/dev/sda1             485M   55M  405M  12% /boot
.host:/               245G  126G  119G  52% /mnt/hgfs

Change the size of that files System by issuing the following command:

mount -t tmpfs shmfs -o size=2g /dev/shm

The shared memory file system should be big enough to accommodate the MEMORY_TARGET and MEMORY_MAX_TARGET values, else Oracle will throw the ORA-00845 error.

Note: While changing something with the mount command, the changes are not permanent.
To make the change persistent, edit your /etc/fstab file

tmpfs                   /dev/shm                tmpfs   defaults,size=2G         0 0

May 20, 2017 ORA-01078: failure in processing system parameters ORA-29701: unable toconnect to Cluster Synchronization Service

Errors/Workarounds11gOracle Database Material

ERROR

startup of ASM instance failed with error:
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service

SOLUTION

check services by command:

crs_stat -t

Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DATA.dg    ora....up.type OFFLINE   OFFLINE      
ora....ER.lsnr ora....er.type ONLINE    ONLINE    orcl01   
ora....2C.lsnr ora....er.type ONLINE    ONLINE    orcl01   
ora.asm        ora.asm.type   OFFLINE   OFFLINE      
ora.cssd       ora.cssd.type  ONLINE    ONLINE    orcl01   
ora.diskmon    ora....on.type ONLINE    ONLINE    orcl01   
ora.orcl.db    ora....se.type OFFLINE   OFFLINE    


Start services manually


#crsctl start resource ora.cssd

CRS-2672: Attempting to start 'ora.cssd' on 'orcl01'
CRS-2679: Attempting to clean 'ora.diskmon' on 'orcl01'
CRS-2681: Clean of 'ora.diskmon' on 'orcl01' succeeded
CRS-2672: Attempting to start 'ora.diskmon' on 'orcl01'
CRS-2676: Start of 'ora.diskmon' on 'orcl01' succeeded
CRS-2676: Start of 'ora.cssd' on 'orcl01' succeeded

#sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 25 12:35:10 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup;
ASM instance started

Total System Global Area  283930624 bytes
Fixed Size                  2212656 bytes
Variable Size             256552144 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted

May 16, 2017 could not validate asmsnmp password due to following errorora-01031:insufficent privileges

Errors/Workarounds11gOracle Database Material

ERROR

During Create new database, It shows following errors
“could not validate asmsnmp password due to following error ora-01031:insufficent privileges”

SOLUTION

Step 1. Create Password file for ASM Instance

$orapwd file=/u0/app/11.2.0/grid/dbs/orapw+ASM password=anypassword

Step 2. $sqlplus / as sysasm

SQL>create user asmsnmp identified by password;

SQL>grant sysdba to asmsnmp;