26 Eylül 2014 Cuma

ORA-00600: internal error code, arguments: [kccbcf_omf_reuse], [], [], [], []


PROBLEM:
__________

While creating controlfile in ASM,I hit this error below:

ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-00600: internal error code, arguments: [kccbcf_omf_reuse], [], [], [], [],
[], [], []




SOLUTION:
__________

Control_files parameter set incorrectly in the spfile / pfile.

 *.control_files='+TEST/necodev/controlfile/current.ctl'

Bug 4309649: is fixed in 11g

Workaround:

 Use Diskgroup name 'only' for control_files init.ora parameter if create controlfile fails.
    Set the control_file parameter in the Auxiliary database spfile or pfile to 'only' the ASM Diskgroup name.

    Example:

     *.control_files='+TEST'


Best tray :))

19 Eylül 2014 Cuma

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 :)

3 Eylül 2014 Çarşamba

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          *
****************************