Friday, November 30, 2012

ORA-01565: error in identifying file '+DATA/...' Ora-17503 Ora-01031 Insufficient privileges

Got error at my Test 11gR2 grid infrastructure node 1

ORA-01565: error in identifying file '+DATA/...'
Ora-17503:   ksfdopn:2 Failes to open file
Ora-01031 Insufficient privileges


Cause:
          Mistakenly set SQLNET.AUTHENTICATION_SERVICES parameter in sqlnet.ora file, in $GRID_HOME/network/admin

Solution:
         Commented the line SQLNET.AUTHENTICATION_SERVICES in GRID_HOME/network/admin.

Note:
        This has to be done at GRID_HOME directory of 11g grid infrastructure not in ORACLE_HOME directory.

Saturday, November 3, 2012

Character Set Migration


Take Full export of database before starting this activity.
1. Do a full backup via export or RMAN
2. SHUTDOWN IMMEDIAT;
3. STARTUP MOUNT;
4. ALTER SYSTEM ENABLE RESTRICTED SESSION;
5. ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
7. ALTER DATABASE OPEN;
8. ALTER DATABASE CHARACTER SET AL32UTF8;
I got error at step 8:
SQL> ALTER DATABASE CHARACTER SET AL32UTF8;
ALTER DATABASE CHARACTER SET AL32UTF8
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
We need to make sure New character set would be superset of old characterset , check below link for checking super set
alternatively used
ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
This command does not the check whether character set is a subset or superset.
9. SHUTDOWN IMMEDIATE;
10. STARTUP;