ORA-12705: Cannot access NLS data files or invalid environment specified

PROBLEM:
----------------

While connecting sqlplus we got this error.

bash$>sqlplus A/A@NECODB


ERROR
-----------

ORA-12705: Cannot access NLS data files or invalid environment specified



SOLUTION:
----------------

You have to check ORACLE_HOME enviroment in your profile.

When we check the our .profile ,hit this line below:

export ORACLE_HOME=u101/app/oracle/product/10.2.0/db_1

This path is incorrect./ is missing

Must be /u101/app/oracle/product/10.2.0/db_1

After we changed the .profile.

Sqlplus connected database successfully .


Pray & Tray :)

CRS-1714:Unable to discover any voting files, retrying discovery

PROBLEM:
----------------

[cssd(26226)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /u01/app/11.2.0/grid/log/ndx1/cssd/ocssd.log
2014-09-02 11:42:11.636:


SOLUTION:
----------------


****************************
Check the disks owner.                 *
Disks owner must be oracle          *
****************************

RMAN-20001: target database not found in recovery catalog

PROBLEM:
----------------

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

SOLUTION:
-----------------

connect catalog database and register database to catalog

RMAN>register database


RMAN-20002: target database already registered in recovery catalog

ORA-12537:TNS:Connection Closed

PROBLEM:
----------------

ORA-12537:TNS:Connection Closed


SOLUTION:
---------------

Check the location which is oracle installed.

In my case,oracle software installed /oracle and /oracle %100.

So hit an "max number of process exceed" error in alertlog.

ORA-600 kdsgrp1

PROBLEM:
------------

Causes and Solutions for ora-600 [kdsgrp1] (Doc ID 1332252.1)


SOLUTION:
----------------


alter system flush buffer_cache;

Analyze table scott.dept validate structure cascade online;

ORA-01499: table/index cross reference failure

PROBLEM:
---------------

ORA-01499: table/index cross reference failure



SOLUTION:
-------------
Drop indexes

analyze table

create indexes

Asmlib ASM:/opt/oracle/extapi/64/asm/orcl/1/libasm.so op asm_open error Operation not permitted

PROBLEM:
----------------

asmlib ASM:/opt/oracle/extapi/64/asm/orcl/1/libasm.so op asm_open error Operation not permitted


SOLUTION:
--------------

To prevent ASMLIB from discovering the same disk more than once it needs to be forced to look only at /dev/dm*  and ignore all /dev/sd* devices.

1. either edit the file /etc/sysconfig/oracleasm-_dev_oracleasm    and change the lines:

ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
to

ORACLEASM_SCANORDER="dm"
ORACLEASM_SCANEXCLUDE="sd"
or alternatively run the following command (as user root)

/usr/sbin/oracleasm configure -i -e -u user -g group -o "dm" -x "sd"

2. stop & restart ASMLIB as user root using:

/usr/sbin/oracleasm exit
/usr/sbin/oracleasm init
/usr/sbin/oracleasm scandisks

3. restart CRS or reboot node